Author Topic: [SolvedGIM] Initialization Failed - Oracle  (Read 90 times)

Offline zwerg82

  • Newbie
  • *
  • Posts: 8
  • Karma: 1
[SolvedGIM] Initialization Failed - Oracle
« on: July 12, 2018, 06:55:36 PM »
Hi all,

I've a problem with a fresh InfoMart installation.

Log Snippet:

Code: [Select]
....
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.
....

Database:
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;

Database:
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 :
  • INFO_MART on dap_gim_jdbc
  • ICON_CFG on dap_icon_cfg
  • ICON_CORE on dap_icon_voice

I've tried it with different versions of InfoMart on RHEL7 but it's always the same error.
  • v8.5.011.09
  • v8.5.011.04
  • v8.5.009.24
  • v8.5.008.19

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.



« Last Edit: July 13, 2018, 01:12:03 AM by zwerg82 »

Offline hsujdik

  • Full Member
  • ***
  • Posts: 219
  • Karma: 11
    • Genesys Brasil
Re: [SolvedGIM] Initialization Failed - Oracle
« Reply #1 on: July 13, 2018, 03:09:58 AM »
Just a small comment: the ojdbc version should match your java version...
ojdbc6 -> java 1.6
ojdbc7 -> java 1.7
ojdbc8 -> java 1.8

Offline zwerg82

  • Newbie
  • *
  • Posts: 8
  • Karma: 1
Re: [SolvedGIM] Initialization Failed - Oracle
« Reply #2 on: July 14, 2018, 04:05:53 PM »
That's the thing.
I'm using java 1.8 but it still works for now with ojdbc6.

Actually starting with version 8.5.003.12 Genesys officially supports Java 8,
but ojdbc8 doesn't work.

Best regards