Hi all,
I've a problem with a fresh InfoMart installation.
Log Snippet:
[code]
....
INFO ecp-0 30042 Job step InitDateTime completed successfully.
INFO ecp-0 30041 Job step InitAnchorFlags started.
INFO ecp-0 30042 Job step InitAnchorFlags completed successfully.
INFO ecp-0 30041 Job step InitPartitions started.
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.gim-etl.etl-start-date=2018-06-12 09:09:01
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_TSERVER=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_ISERVER=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_OCS=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_CFG=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_TSERVER=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_ISERVER=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_OCS=null
INFO ecp-0 25000 Reading CTL_SCHEMA_INFO.PURGE_GIDB_CFG=null
ERROR ecp-0 20155 Database error: Stream has already been closed; CODE=17027; SQLSTATE=99999; DBError=UNCATEGORIZED; SQL=[ ? ].
INFO ecp-0 30000 com.google.common.util.concurrent.UncheckedExecutionException: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: getColumns(GEN_GIM_85,CALLBACK_FACT); Uncategorized SQLException for SQL [?]; SQLSTATE=99999; error code=17027; DBError=UNCATEGORIZED; Stream has already been closed.GimAddPartitionsTask threw runStep - UncheckedExecutionException
WARN ecp-0 20049 Job step 'InitPartitions' failed. com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: getColumns(GEN_GIM_85,CALLBACK_FACT); Uncategorized SQLException for SQL [?]; SQLSTATE=99999; error code=17027; DBError=UNCATEGORIZED; Stream has already been closed.
com.google.common.util.concurrent.UncheckedExecutionException: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: getColumns(GEN_GIM_85,CALLBACK_FACT); Uncategorized SQLException for SQL [?]; SQLSTATE=99999; error code=17027; DBError=UNCATEGORIZED; Stream has already been closed
....
WARN ecp-0 20044 Job 'Job_InitializeGIM' completed unsuccessfully.
....
[/code]
[u]Database:[/u]
Type: Oracle 12C Enterprise Edition
DB Initialization script used: make_gim_partitioned.sql
DB User GRANTs:
GRANT CONNECT, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE JOB TO gen_gim_85;
GRANT EXECUTE ON dbms_lock TO gen_gim_85;
[u]Database:[/u]
JDBC DAP is used for GIM DB
DBS DAPs of ICon are used with jdbc-url to connect from GIM
[gim-etl] - Role is set to :
[list]
[li]INFO_MART on dap_gim_jdbc[/li]
[li]ICON_CFG on dap_icon_cfg[/li]
[li]ICON_CORE on dap_icon_voice[/li]
[/list]
I've tried it with different versions of InfoMart on RHEL7 but it's always the same error.
[list]
[li]v8.5.011.09[/li]
[li]v8.5.011.04[/li]
[li]v8.5.009.24[/li]
[li]v8.5.008.19[/li]
[/list]
Did anybody came across this issue and knows what the cause is?
Thank you,
All the best
Edit: Issue is solved.
Problem was the ojdbc version.
Oracle 12c Client comes with ojdbc8.jar but it obviously needs to run with ojdbc6.jar.
After changing copying ojdbc6 and adjusting CLASSPATH to it, the startup ran successful.
Cheers
Edit2:
Small correction, Oracle 12c R2 comes with ojdbc8, and is not yet supported by GIM.
Haven't tried it with ojdcb7 though, which comes with 12c.
