com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'locCreationType' in 'where clause' ...

Kuali JIRA | Bryan Hutchinson | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    Kuali JIRA | 3 years ago | Bryan Hutchinson
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'locCreationType' in 'where clause' ...
  2. 0

    # Per conversation with James on KFSTP-1536, it appears that the CG Aging Report is returning INV's as well as CINV's. The CG Aging Report should only return CINV's. # If you search by org and do not enter the chart, and the report option is either processing org or billing org, no error is displayed and the results are not filtered on the org. Require a chart if org criteria is entered in the search and the report option is either processing org or billing org. # Generate print file throws STE (full STE attached, previously reported in KFSMI-13446) ** Search results return with no problem, but generate print file throws STE (screenshot of full STE attached): java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument' at org.kuali.rice.krad.util.ObjectUtils.getPropertyValue(ObjectUtils.java:311) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getPropertyValue(ContractsGrantsReportHelperServiceImpl.java:145) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getListOfValuesSortedProperties(ContractsGrantsReportHelperServiceImpl.java:133) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildSubTotalMap(ContractsGrantsAgingReportBuilderServiceImpl.java:178) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildReportDataHolder(ContractsGrantsAgingReportBuilderServiceImpl.java:64) at org.kuali.kfs.module.ar.web.struts.ContractsGrantsReportLookupAction.print(ContractsGrantsReportLookupAction.java:104)

    Kuali JIRA | 2 years ago | Barb Sutton
    java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument'
  3. 0

    Search results return with no problem, but generate print file throws STE (screenshot of full STE attached): java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument' at org.kuali.rice.krad.util.ObjectUtils.getPropertyValue(ObjectUtils.java:311) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getPropertyValue(ContractsGrantsReportHelperServiceImpl.java:145) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getListOfValuesSortedProperties(ContractsGrantsReportHelperServiceImpl.java:133) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildSubTotalMap(ContractsGrantsAgingReportBuilderServiceImpl.java:178) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildReportDataHolder(ContractsGrantsAgingReportBuilderServiceImpl.java:64) at org.kuali.kfs.module.ar.web.struts.ContractsGrantsReportLookupAction.print(ContractsGrantsReportLookupAction.java:104) I put this in project priorities, but could probably be convinced it belongs in TBD

    Kuali JIRA | 2 years ago | Barb Sutton
    java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Search results return with no problem, but generate print file throws STE (screenshot of full STE attached): java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument' at org.kuali.rice.krad.util.ObjectUtils.getPropertyValue(ObjectUtils.java:311) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getPropertyValue(ContractsGrantsReportHelperServiceImpl.java:145) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getListOfValuesSortedProperties(ContractsGrantsReportHelperServiceImpl.java:133) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildSubTotalMap(ContractsGrantsAgingReportBuilderServiceImpl.java:178) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildReportDataHolder(ContractsGrantsAgingReportBuilderServiceImpl.java:64) at org.kuali.kfs.module.ar.web.struts.ContractsGrantsReportLookupAction.print(ContractsGrantsReportLookupAction.java:104) I put this in project priorities, but could probably be convinced it belongs in TBD

    Kuali JIRA | 2 years ago | Barb Sutton
    java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument'
  6. 0

    # Per conversation with James on KFSTP-1536, it appears that the CG Aging Report is returning INV's as well as CINV's. The CG Aging Report should only return CINV's. # If you search by org and do not enter the chart, and the report option is either processing org or billing org, no error is displayed and the results are not filtered on the org. Require a chart if org criteria is entered in the search and the report option is either processing org or billing org. # Generate print file throws STE (full STE attached, previously reported in KFSMI-13446) ** Search results return with no problem, but generate print file throws STE (screenshot of full STE attached): java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument' at org.kuali.rice.krad.util.ObjectUtils.getPropertyValue(ObjectUtils.java:311) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getPropertyValue(ContractsGrantsReportHelperServiceImpl.java:145) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsReportHelperServiceImpl.getListOfValuesSortedProperties(ContractsGrantsReportHelperServiceImpl.java:133) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildSubTotalMap(ContractsGrantsAgingReportBuilderServiceImpl.java:178) at org.kuali.kfs.module.ar.report.service.impl.ContractsGrantsAgingReportBuilderServiceImpl.buildReportDataHolder(ContractsGrantsAgingReportBuilderServiceImpl.java:64) at org.kuali.kfs.module.ar.web.struts.ContractsGrantsReportLookupAction.print(ContractsGrantsReportLookupAction.java:104)

    Kuali JIRA | 2 years ago | Barb Sutton
    java.lang.RuntimeException: error getting property value for class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument.award.agency.agencyNumber Unknown property 'award' on class 'class org.kuali.kfs.module.ar.document.ContractsGrantsInvoiceDocument'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

      Unknown column 'locCreationType' in 'where clause' ...

      at org.kuali.kfs.module.ar.dataaccess.impl.ContractsGrantsInvoiceDocumentDaoOjb.getInvoicesByCriteria()
    2. org.kuali.kfs
      ContractsGrantsInvoiceDocumentServiceImpl.retrieveOpenAndFinalCGInvoicesByLOCFund
      1. org.kuali.kfs.module.ar.dataaccess.impl.ContractsGrantsInvoiceDocumentDaoOjb.getInvoicesByCriteria(ContractsGrantsInvoiceDocumentDaoOjb.java:76)
      2. org.kuali.kfs.module.ar.document.service.impl.ContractsGrantsInvoiceDocumentServiceImpl.retrieveOpenAndFinalCGInvoicesByLOCFund(ContractsGrantsInvoiceDocumentServiceImpl.java:977)
      2 frames