kodo.persistence.PersistenceException: ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]

Oracle Community | 666705 | 1 decade ago
  1. 0

    kodo.persistence.PersistenceException: expression must have same datatype

    Oracle Community | 1 decade ago | 666705
    kodo.persistence.PersistenceException: ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]
  2. 0

    Kodo v4.0.0EA2 Bugs List

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: relation "kodo_sequence_table" does not exist {prepstmnt 31538514 SELECT SEQUENCE_VALUE FROM KODO_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [reused=0]} [code=0, state=42P01]
  3. 0

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The column prefix 't3' does not match with a table name or alias name used in the query. {prepstmnt 1710895 SELECT DISTINCT t0.id_i, t0.classtype_id_vc, t0.rowversion_i, t0.active_b, t0.imagemimetype_vc, t0.lastupdated_dt, t0.newsdate_dt, t0.relatedurl_vc, t0.title_vc, t0.lastupdatedby_person_id_i, t0.postedby_person_id_i, t4.id_i, t4.rowversion_i, t4.active_b, t4.birthday_dt, t4.cellphone_vc, t4.created_dt, t4.createdby_person_id_i, t4.encryptedpassword_vc, t4.fax_vc, t4.firstname_vc, t4.hired_dt, t4.homephone_vc, t4.im_vc, t4.lastmodified_dt, t4.lastmodifiedby_person_id_i, t4.lastname_vc, t4.maincorrelat_organization_id_i, t4.middlename_vc, t4.nickname_vc, t4.officephone_vc, t4.primaryEmail_vc, t4.secondaryEmail_vc, t4.title_vc, t4.username_vc, t4.website_vc FROM cor.t_news t0 INNER JOIN cor.t_map_newsitem_organization t1 ON t0.id_i = t1.newsitem_id_i LEFT OUTER JOIN cor.t_person t2 ON t0.postedby_person_id_i = t2.id_i LEFT OUTER JOIN cor.t_person t4 ON t3.postedby_person_id_i = t4.id_i WHERE (t0.active_b = ? AND t0.newsdate_dt >= ? AND t1.organization_id_i = ?) AND t0.classtype_id_vc = ?} [code=107, state=HY000]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Group by clause corresponding to a reference field

    Oracle Community | 1 decade ago | 3004
    java.lang.reflect.InvocationTargetException
  6. 0

    count(1) problem

    Oracle Community | 1 decade ago | 3004
    kodo.util.UserException: com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000]

    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.solarmetric.jdbc.ReportingSQLException

      ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:184)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:21)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1098)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      4 frames
    3. kodo.jdbc.kernel
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1633)
      1 frame
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:332)
      1 frame
    5. kodo.jdbc.sql
      Union.execute
      1. kodo.jdbc.sql.Union.execute(Union.java:425)
      2. kodo.jdbc.sql.Union.execute(Union.java:332)
      3. kodo.jdbc.sql.Union.execute(Union.java:313)
      4. kodo.jdbc.sql.SelectImpl.addEagerResults(SelectImpl.java:386)
      5. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:350)
      6. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:301)
      7. kodo.jdbc.sql.Union$UnionSelect.execute(Union.java:642)
      8. kodo.jdbc.sql.Union.execute(Union.java:326)
      9. kodo.jdbc.sql.Union.execute(Union.java:313)
      9 frames
    6. kodo.jdbc.kernel
      SelectResultObjectProvider.open
      1. kodo.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:98)
      1 frame
    7. com.solarmetric.rop
      EagerResultList.<init>
      1. com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
      1 frame
    8. kodo.kernel
      DelegatingQuery.execute
      1. kodo.kernel.QueryImpl.toResult(QueryImpl.java:1445)
      2. kodo.kernel.QueryImpl.execute(QueryImpl.java:1167)
      3. kodo.kernel.QueryImpl.execute(QueryImpl.java:953)
      4. kodo.kernel.QueryImpl.execute(QueryImpl.java:871)
      5. kodo.kernel.DelegatingQuery.execute(DelegatingQuery.java:774)
      5 frames
    9. kodo.persistence
      QueryImpl.getResultList
      1. kodo.persistence.QueryImpl.execute(QueryImpl.java:241)
      2. kodo.persistence.QueryImpl.getResultList(QueryImpl.java:290)
      2 frames
    10. com.savantcg.blackcar
      AppConfigDecidesToViewRoleTypesEvent.performEvent
      1. com.savantcg.blackcar.business.securitydomain.Users.getUser(Users.java:48)
      2. com.savantcg.blackcar.business.businessevents.newco.AppConfigDecidesToViewRoleTypesEvent.performEvent(AppConfigDecidesToViewRoleTypesEvent.java:54)
      2 frames
    11. com.savantcg.business
      BusinessEvent.perform
      1. com.savantcg.business.businessevents.BusinessEvent.perform(BusinessEvent.java:62)
      1 frame
    12. com.savantcg.blackcar
      TestGetListOfRoleTypes.main
      1. com.savantcg.blackcar.tests.TestGetListOfRoleTypes.getAccts(TestGetListOfRoleTypes.java:39)
      2. com.savantcg.blackcar.tests.TestGetListOfRoleTypes.main(TestGetListOfRoleTypes.java:87)
      2 frames