IDB Merging into single Info Mart

[santoshsundaram]

Hi

I have 3 tenants and a single Infomart and i want to do a merging. Based on teh document i have done the merging for one Tenant and it is working fine. When i am doing for teh next one i am getting a error. Not able to figure out the issue as versions and database are the same.

The log shows error as below :

01:04:13.430 Trc 30034 Initializing DAP 'ICONJDBCDAPKOL' for role(s) 'ICON_CORE'.  Database='ICON01@INKLRBGERPT' Owner='dbo'
01:04:16.868 Trc 30035 Completed initializing DAP 'ICONJDBCDAPKOL' for role(s) 'ICON_CORE'.
01:04:16.868 Trc 30034 Initializing DAP 'ICONMUMJDBCDAP' for role(s) 'ICON_CORE'.  Database='ICON01@INMUTE-RPT' Owner='dbo'
01:04:18.227 Trc 30035 Completed initializing DAP 'ICONMUMJDBCDAP' for role(s) 'ICON_CORE'.
01:04:18.227 Trc 30034 Initializing DAP 'ICONJDBCDAPVAD' for role(s) 'ICON_CORE'.  Database='ICON01@INVDABGERPT' Owner='dbo'
01:04:19.368 Trc 30035 Completed initializing DAP 'ICONJDBCDAPVAD' for role(s) 'ICON_CORE'.
01:04:19.383 Std 23001 DAP 'ICONJDBCDAPKOL' database error for table 'G_LOG_MESSAGES'.  Exception: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

Your feedback and suggestions would be appreciated.

Regards
Santosh

[ecki]

Hi,

Looks like wrong connection parameters for you first ICON DB or the ICON DB is empty. Did you run each ICON after you installed them?

e.

[santoshsundaram]

Hi

I have checked and found the ICONDB tables structure is as required.
As a last action plan i have decided to recreate the ICON DB and run all the scripts again.

Regards
Santosh

[ecki]

Hi Santosh,

What I was talking about is that you need run all ICONs first before you start any GIM ETL job.
ICON will initialize ICON Database and populate some tables. Without it GIM will report errors.

E.