com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Invalid column name in Criteria is causing a SQLException when running the letterOfCreditJob batch job. Full stacktrace is attached. Below are some highlights: 2014-01-29 14:39:37,467 [scheduler_Worker-3] u:/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl :: [java] * SQLException during execution of sql-statement: [java] * sql statement was 'SELECT A0.FDOC_NBR,A0.LTRCR_CRTN_TYP,A0.PRPSL_NBR,A0.LTRCR_FNDGRP_CD,A0.LTRCR_FND_CD,A0.OBJ_ID,A0.VER_NBR,A0.UNIV_FISCAL_YR,A0.UNIV_FISCAL_PRD_CD,A0.AR_INV_HDR_TXT,A0.AR_INV_ATTN_LN_TXT,A0.AR_INV_DUE_DT,A0.AR_INV_CLOSE_DT,A0.AR_BILLING_DT,A0.AR_INV_TERMS_TXT,A0.ORG_INV_NBR,A0.CUST_PO_NBR,A0.AR_PRN_INV_IND,A0.CUST_PO_DT,A0.AR_BILL_BY_COA_CD,A0.AR_BILL_BY_ORG_CD,A0.CUST_SHIP_ADDR_ID,A0.CUST_BILL_ADDR_ID,A0.CUST_SPCL_PRCS_CD,A0.CUST_REC_ATT_IND,A0.AR_OPEN_INV_IND,A0.PMT_FIN_COA_CD,A0.PMT_ACCT_NBR,A0.PMT_SUB_ACCT_NBR,A0.PMT_FIN_OBJ_CD,A0.PMT_FIN_SUB_OBJ_CD,A0.PMT_PROJECT_CD,A0.PMT_ORG_REF_ID,A0.AR_PRNT_DT,A0.NXT_INV_ITEM_NBR,A0.CUST_NM,A0.BILL_ADDR_NM,A0.BILL_LINE_1_ADDR,A0.BILL_LINE_2_ADDR,A0.BILL_CITY_NM,A0.BILL_STATE_CD,A0.BILL_ZIP_CD,A0.BILL_CNTRY_CD,A0.BILL_ADDR_INTL_PROV_NM,A0.BILL_INTL_MAIL_CD,A0.BILL_EMAIL_ADDR,A0.BILL_ADDR_TYPE_CD,A0.SHIP_ADDR_NM,A0.SHIP_LINE_1_ADDR,A0.SHIP_LINE_2_ADDR,A0.SHIP_CITY_NM,A0.SHIP_STATE_CD,A0.SHIP_ZIP_CD,A0.SHIP_CNTRY_CD,A0.SHIP_ADDR_INTL_PROV_NM,A0.SHIP_INTL_MAIL_CD,A0.SHIP_EMAIL_ADDR,A0.SHIP_ADDR_TYPE_CD,A0.RECURRED_INV_IND,A0.MRKD_FOR_PRCSSNG,A0.RPRT_PROCESSED_DT,A0.RFRL_TYP_CD,A0.FINAL_DISPOS_CD FROM AR_INV_DOC_T A0 INNER JOIN FS_DOC_HEADER_T A1 ON A0.FDOC_NBR=A1.FDOC_NBR INNER JOIN KRNS_DOC_HDR_T A2 ON A1.FDOC_NBR=A2.DOC_HDR_ID WHERE ((((locCreationType = ?) AND A0.LTRCR_FND_CD = ?) AND A0.AR_OPEN_INV_IND = ?) AND A1.FDOC_STATUS_CD <> ?) AND A1.FDOC_STATUS_CD <> ?' [java] * Exception message is [Unknown column 'locCreationType' in 'where clause'] [java] * Vendor error code [1054] [java] * SQL state code [42S22] [java] * The root stack trace is --> [java] * com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'locCreationType' in 'where clause' ... [java] at org.kuali.kfs.module.ar.dataaccess.impl.ContractsGrantsInvoiceDocumentDaoOjb.getInvoicesByCriteria(ContractsGrantsInvoiceDocumentDaoOjb.java:76) [java] at org.kuali.kfs.module.ar.document.service.impl.ContractsGrantsInvoiceDocumentServiceImpl.retrieveOpenAndFinalCGInvoicesByLOCFund(ContractsGrantsInvoiceDocumentServiceImpl.java:977) [jav
    via by Bryan Hutchinson,
    • com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'locCreationType' in 'where clause' ... at org.kuali.kfs.module.ar.dataaccess.impl.ContractsGrantsInvoiceDocumentDaoOjb.getInvoicesByCriteria(ContractsGrantsInvoiceDocumentDaoOjb.java:76) at org.kuali.kfs.module.ar.document.service.impl.ContractsGrantsInvoiceDocumentServiceImpl.retrieveOpenAndFinalCGInvoicesByLOCFund(ContractsGrantsInvoiceDocumentServiceImpl.java:977)
    No Bugmate found.