API tools faq
paste
Advertisement
mugs

[ORA-00904: "A0"."SEND_VENDOR_EMAIL": invalid identifier

mugs
Mar 5th, 2018
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 14.08 KB | None | 0 0
raw download clone embed print report
  1. 2018-03-05 07:51:11,816 [ajp-8009-1] u:11942657/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl ::
  2. * SQLException during execution of sql-statement:
  3. * sql statement was 'SELECT A0.FDOC_NBR,A0.OBJ_ID,A0.VER_NBR,A0.PO_ID,A0.REQS_ID,A0.REQS_SRC_CD,A0.PO_VNDR_CHC_CD,A0.VNDR_HDR_GNRTD_ID,A0.VNDR_DTL_ASND_ID,A0.VNDR_NM,A0.VNDR_LN1_ADDR,A0.VNDR_LN2_ADDR,A0.VNDR_CTY_NM,A0.VNDR_ST_CD,A0.VNDR_PSTL_CD,A0.VNDR_CNTRY_CD,A0.VNDR_RSTRC_IND,A0.VNDR_PMT_TERM_CD,A0.VNDR_SHP_TTL_CD,A0.VNDR_PHN_NBR,A0.VNDR_FAX_NBR,A0.VNDR_CUST_NBR,A0.VNDR_CONTR_GNRTD_ID,A0.VNDR_NTE_TXT,A0.VNDR_DEBRD_REAS_TXT,A0.VNDR_SHP_PMT_TERM_CD,A0.FND_SRC_CD,A0.RQSTR_PRSN_NM,A0.RQSTR_PRSN_EMAIL_ADDR,A0.RQSTR_PRSN_PHN_NBR,A0.NON_INST_FND_ORG_COA_CD,A0.NON_INST_FND_ORG_CD,A0.NON_INST_FND_COA_CD,A0.NON_INST_FND_ACCT_NBR,A0.DLVY_CMP_CD,A0.DLVY_BLDG_CD,A0.DLVY_BLDG_NM,A0.DLVY_BLDG_RM_NBR,A0.DLVY_BLDG_LN1_ADDR,A0.DLVY_BLDG_LN2_ADDR,A0.DLVY_CTY_NM,A0.DLVY_ST_CD,A0.DLVY_PSTL_CD,A0.DLVY_CNTRY_CD,A0.DLVY_TO_NM,A0.DLVY_TO_EMAIL_ADDR,A0.DLVY_TO_PHN_NBR,A0.DLVY_REQ_DT,A0.DLVY_INSTRC_TXT,A0.DLVY_REQ_DT_REAS_CD,A0.DLVY_BLDG_OTHR_IND,A0.FIN_COA_CD,A0.ORG_CD,A0.PO_CRTE_DT,A0.PO_ENCUM_FSCL_YR,A0.PO_CST_SRC_CD,A0.PO_TRNS_MTHD_CD,A0.PO_TOT_LMT,A0.PO_BEG_DT,A0.PO_END_DT,A0.RECUR_PMT_FREQ_CD,A0.RECUR_PMT_AMT,A0.RECUR_PMT_TYP_CD,A0.RECUR_PMT_DT,A0.INST_CNTCT_NM,A0.INST_CNTCT_PHN_NBR,A0.INST_CNTCT_EMAIL_ADDR,A0.BILL_NM,A0.BILL_LN1_ADDR,A0.BILL_LN2_ADDR,A0.BILL_CTY_NM,A0.BILL_ST_CD,A0.BILL_PSTL_CD,A0.BILL_CNTRY_CD,A0.BILL_PHN_NBR,A0.BILL_EMAIL_ADDR,A0.INIT_PMT_AMT,A0.INIT_PMT_DT,A0.FNL_PMT_AMT,A0.FNL_PMT_DT,A0.EXT_ORG_B2B_SUPP_ID,A0.CONTR_MGR_CD,A0.PO_AUTO_IND,A0.PO_INIT_OPEN_DT,A0.PO_LST_TRNS_DT,A0.PO_QT_DUE_DT,A0.PO_QT_TYP_CD,A0.PO_QT_VNDR_NTE_TXT,A0.PO_CNFRMD_IND,A0.PO_COMM_DESC,A0.PO_PREV_ID,A0.ALTRNT_VNDR_HDR_GNRTD_ID,A0.ALTRNT_VNDR_DTL_ASND_ID,A0.ALTRNT_VNDR_NM,A0.PO_CUR_IND,A0.PEND_ACTN_IND,A0.PO_1ST_TRNS_DT,A0.AP_PUR_DOC_LNK_ID,A0.VNDR_ADDR_INTL_PROV_NM,A0.RCVNG_DOC_REQ_IND,A0.PMT_RQST_PSTV_APRVL_IND,A0.PO_QT_INITLZTN_DT,A0.PO_QT_AWDED_DT,A0.CPTL_AST_SYS_TYP_CD,A0.CPTL_AST_SYS_ST_CD,A0.PUR_RCVNG_NM,A0.PUR_RCVNG_LN1_ADDR,A0.PUR_RCVNG_LN2_ADDR,A0.PUR_RCVNG_CTY_NM,A0.PUR_RCVNG_ST_CD,A0.PUR_RCVNG_PSTL_CD,A0.PUR_RCVNG_CNTRY_CD,A0.PUR_RCVNG_ADDR_TO_VNDR_IND,A0.USE_TAX_IND,A0.VNDR_ATTN_NM,A0.PO_ASND_ID,A0.ACCT_DISTR_MTD_IND,A0.send_vendor_email,A0.EXCHANGE_RATE FROM PUR_PO_T A0 WHERE (A0.AP_PUR_DOC_LNK_ID = ?) AND A0.PO_CUR_IND = ?'
  4. * Exception message is [ORA-00904: "A0"."SEND_VENDOR_EMAIL": invalid identifier
  5. ]
  6. * Vendor error code [904]
  7. * SQL state code [42000]
  8. * The root stack trace is -->
  9. * java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."SEND_VENDOR_EMAIL": invalid identifier
  10.  
  11.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  12.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  13.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  14.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  15.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  16.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  17.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  18.     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
  19.     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  20.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
  21.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  22.     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
  23.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
  24.     at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
  25.     at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
  26.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  27.     at java.lang.reflect.Method.invoke(Method.java:606)
  28.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  29.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  30.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  31.     at com.sun.proxy.$Proxy502.executeQuery(Unknown Source)
  32.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
  33.     at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
  34.     at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
  35.     at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
  36.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
  37.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
  38.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  39.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  40.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  41.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
  42.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
  43.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
  44.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195)
  45.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  46.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162)
  47.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193)
  48.     at org.kuali.kfs.module.purap.document.dataaccess.impl.PurchaseOrderDaoOjb.getPurchaseOrderIdForCurrentPurchaseOrderByRelatedDocId(PurchaseOrderDaoOjb.java:48)
  49.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  50.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  51.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  52.     at java.lang.reflect.Method.invoke(Method.java:606)
  53.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  54.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  55.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  56.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  57.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  58.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  59.     at com.sun.proxy.$Proxy694.getPurchaseOrderIdForCurrentPurchaseOrderByRelatedDocId(Unknown Source)
  60.     at org.kuali.kfs.module.purap.service.impl.SensitiveDataServiceImpl.getSensitiveDatasAssignedByRelatedDocId(SensitiveDataServiceImpl.java:78)
  61.     at org.kuali.kfs.module.purap.document.authorization.PurchasingAccountsPayableTransactionalDocumentAuthorizerBase.addRoleQualification(PurchasingAccountsPayableTransactionalDocumentAuthorizerBase.java:41)
  62.     at org.kuali.rice.krad.bo.DataObjectAuthorizerBase.getRoleQualification(DataObjectAuthorizerBase.java:168)
  63.     at org.kuali.rice.kns.bo.authorization.BusinessObjectAuthorizerBase.isAuthorizedByTemplate(BusinessObjectAuthorizerBase.java:65)
  64.     at org.kuali.kfs.sec.document.authorization.SecTransactionalDocumentAuthorizer.isAuthorizedByTemplate(SecTransactionalDocumentAuthorizer.java:182)
  65.     at za.org.kuali.kfs.sec.document.authorization.SecTransactionalDocumentAuthorizer.canOpen(SecTransactionalDocumentAuthorizer.java:32)
  66.     at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.loadDocument(KualiDocumentActionBase.java:395)
  67.     at org.kuali.kfs.sys.web.struts.KualiAccountingDocumentActionBase.loadDocument(KualiAccountingDocumentActionBase.java:114)
  68.     at org.kuali.kfs.module.purap.document.web.struts.PurchasingAccountsPayableActionBase.loadDocument(PurchasingAccountsPayableActionBase.java:98)
  69.     at org.kuali.kfs.module.purap.document.web.struts.AccountsPayableActionBase.loadDocument(AccountsPayableActionBase.java:139)
  70.     at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.docHandler(KualiDocumentActionBase.java:358)
  71.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  72.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  73.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  74.     at java.lang.reflect.Method.invoke(Method.java:606)
  75.     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
  76.     at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:171)
  77.     at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:129)
  78.     at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:176)
  79.     at org.kuali.kfs.sys.document.web.struts.FinancialSystemTransactionalDocumentActionBase.execute(FinancialSystemTransactionalDocumentActionBase.java:73)
  80.     at org.kuali.kfs.sys.web.struts.KualiAccountingDocumentActionBase.execute(KualiAccountingDocumentActionBase.java:103)
  81.     at org.kuali.kfs.module.purap.document.web.struts.AccountsPayableActionBase.execute(AccountsPayableActionBase.java:89)
  82.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:494)
  83.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  84.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:490)
  85.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:219)
  86.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:206)
  87.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:95)
  88.     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  89.     at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:198)
  90.     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
  91.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  92.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  93.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  94.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  95.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:75)
  96.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
  97.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  98.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  99.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:90)
  100.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:79)
  101.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  102.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  103.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:277)
  104.     at org.kuali.rice.kew.web.DummyLoginFilter.doFilter(DummyLoginFilter.java:96)
  105.     at org.kuali.rice.kew.web.DummyLoginFilter.doFilter(DummyLoginFilter.java:55)
  106.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:270)
  107.     at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:168)
  108.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  109.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  110.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  111.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  112.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  113.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  114.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:185)
  115.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:159)
  116.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  117.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  118.     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
  119.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  120.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  121.     at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69)
  122.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  123.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  124.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  125.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  126.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
  127.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  128.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  129.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  130.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
  131.     at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448)
  132.     at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399)
  133.     at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
  134.     at java.lang.Thread.run(Thread.java:744)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!