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]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web24

  • via Unknown by 3004,
  • via Unknown by 3004,
  • Stack trace

    • 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] at kodo.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4092) at kodo.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:82) at kodo.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:66) at kodo.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:46) at kodo.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:176) at com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:32) at kodo.kernel.QueryImpl.toResult(QueryImpl.java:1445) at kodo.kernel.QueryImpl.execute(QueryImpl.java:1167) at kodo.kernel.QueryImpl.execute(QueryImpl.java:953) at kodo.kernel.QueryImpl.execute(QueryImpl.java:871) at kodo.kernel.DelegatingQuery.execute(DelegatingQuery.java:774) at kodo.persistence.QueryImpl.execute(QueryImpl.java:241) at kodo.persistence.QueryImpl.getResultList(QueryImpl.java:290) at com.savantcg.blackcar.business.securitydomain.Users.getUser(Users.java:48) at com.savantcg.blackcar.business.businessevents.newco.AppConfigDecidesToViewRoleTypesEvent.performEvent(AppConfigDecidesToViewRoleTypesEvent.java:54) at com.savantcg.business.businessevents.BusinessEvent.perform(BusinessEvent.java:62) at com.savantcg.blackcar.tests.TestGetListOfRoleTypes.getAccts(TestGetListOfRoleTypes.java:39) at com.savantcg.blackcar.tests.TestGetListOfRoleTypes.main(TestGetListOfRoleTypes.java:87) Caused by: 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(LoggingConnectionDecorator.java:184) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:21) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1098) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345) at kodo.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1633) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:332) at kodo.jdbc.sql.Union.execute(Union.java:425) at kodo.jdbc.sql.Union.execute(Union.java:332) at kodo.jdbc.sql.Union.execute(Union.java:313) at kodo.jdbc.sql.SelectImpl.addEagerResults(SelectImpl.java:386) at kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:350) at kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:301) at kodo.jdbc.sql.Union$UnionSelect.execute(Union.java:642) at kodo.jdbc.sql.Union.execute(Union.java:326) at kodo.jdbc.sql.Union.execute(Union.java:313) at kodo.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:98) at com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22) ... 12 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    We couldn't find other users who have seen this exception.