GIM DB not being populated

Voice & Telephony
1

Hi,
My GIM DB is not being populated. All jobs end as successful but there is no data in the G_CALL table even though there is a lot of info in the Icon DB.
In the GIM logs I can’t see any errors except a lot of these:


2015-03-16 12:06:09,003 INFO  ecp-1-6860   30000 TransformUD$FillStgUdhVoice.runStep (TSERVER) - enter
2015-03-16 12:06:09,003 DEBUG ecp-1-6860   35000 SQLUtils.executeUpdate (if exists (select 1 from sysobjects where id = object_id('dbo.STG_UDH_V') and type = 'U') DROP TABLE dbo.STG_UDH_V,294318208,null) - enter
2015-03-16 12:06:09,003 DEBUG ecp-1-6809   35000 SQLSTATE=S0001; error code=16954; Executing SQL directly; no cursor.
2015-03-16 12:06:09,003 DEBUG ecp-1-6809   35000 SQLUtils.queryAndScan - exit(elapsed 0 ms) returning 1

Could this be my problem? Should I talk to my DB engineer for this?

Regards,
Mihai

2

Can you post your jdbc string for the GIM DAP?

3

Check on what stored procedure the process terminated and try to run this query directly from SQL studio

4

Hi,

I didn’t start new topic , I have the same issue on my ICON_CORE when I run transformation Job.

2022-04-28T15:40:33,300 DEBUG ecp-176 35000 SQLUtils.executeUpdate (DAP_GIM@5[d][15],IF OBJECT_ID(‘dbo.TMP_MERGE’,‘U’) IS NOT NULL DROP TABLE dbo.TMP_MERGE,null) - enter
2022-04-28T15:40:33,300 DEBUG ecp-176 35000 SQLUtils.executeUpdate - exit(elapsed 0 ms) returning 0
2022-04-28T15:40:33,300 DEBUG ecp-176 35000 COMMIT: DAP_GIM@5[d][15]; called by com.genesyslab.gim.etl.jobs.extract.MergeMoveStep.run(MergeMoveStep.java:341)
2022-04-28T15:40:33,300 INFO ecp-176 30000 MergeMove: .insertIRs4ConCalls2TmpMerge () - enter
2022-04-28T15:40:33,300 DEBUG ecp-176 35000 SQLUtils.queryAndScan (DAP_GIM@5[d][15],SELECT IRID,ROOTIRID INTO dbo.TMP_MERGE FROM (SELECT (u.c1_ROOTIRID) IRID,(u.c2_ROOTIRID) ROOTIRID,(ROW_NUMBER() OVER(PARTITION BY u.c1_ROOTIRID ORDER BY u.c2_ROOTIRID ASC)) XX_ROW_NUMBER FROM ((SELECT (c1.ROOTIRID) IRID,(c1.ROOTIRID) c1_ROOTIRID,(c2.ROOTIRID) c2_ROOTIRID FROM dbo.G_CALL c1 INNER HASH JOIN dbo.G_CALL c2 ON c1.MERGECALLID = c2.CALLID) UNION (SELECT (c1.ROOTIRID) IRID,(c1.ROOTIRID) c1_ROOTIRID,(c2.ROOTIRID) c2_ROOTIRID FROM dbo.G_CALL c1 INNER HASH JOIN dbo.G_CALL c2 ON c1.PARENTCALLID = c2.CALLID)) u WHERE u.c1_ROOTIRID <> u.c2_ROOTIRID) T WHERE XX_ROW_NUMBER = 1; SELECT @@ROWCOUNT) - enter
2022-04-28T15:40:33,316 DEBUG ecp-176 35000 SQLSTATE=S0001; error code=16954; Executing SQL directly; no cursor.
2022-04-28T15:40:33,316 DEBUG ecp-176 35000 SQLSTATE=S0000; error code=8625; Warning: The join order has been enforced because a local join hint is used.

same error pn indexes
2022-04-28T15:42:07,238 DEBUG ecp-196 35000 SQLUtils.executeUpdate (DAP_GIM@5[2b][14],IF NOT EXISTS (SELECT 1 FROM sysindexes WHERE id = object_id(‘TMP_UP_UDE_FT_223’) AND name = ‘PK_TMP_UP_UDE_FT_223’ AND indid > 0 AND indid < 255) CREATE UNIQUE NONCLUSTERED INDEX PK_TMP_UP_UDE_FT_223 ON TMP_UP_UDE_FT_223(INTERACTION_RESOURCE_ID ASC),null) - enter
2022-04-28T15:42:07,254 DEBUG ecp-196 35000 SQLUtils.executeUpdate - exit(elapsed 16 ms) returning 0
2022-04-28T15:42:07,254 DEBUG ecp-196 35000 COMMIT: DAP_GIM@5[2b][14]; called by com.genesyslab.gim.etl.jobs.transform.core.TransformUD.createIndexOnTmpTable(TransformUD.java:3589)
2022-04-28T15:42:07,254 INFO ecp-196 30000 TransformUD$LoadFact.populateTmpUdeTable - exit(elapsed 219 ms) returning 0
2022-04-28T15:42:07,254 INFO ecp-196 30000 TransformUD$LoadFact.runStep - exit(elapsed 766 ms) returning 0
2022-04-28T15:42:07,254 DEBUG ecp-196 35000 COMMIT: DAP_GIM@5[2b][14]; called by com.genesyslab.gim.etl.server.CallableTransactionStep.runTransaction(CallableTransactionStep.java:66)
2022-04-28T15:42:07,254 DEBUG ecp-196 35000 CLOSE: DAP_GIM@5[2b][14]; called by com.genesyslab.gim.etl.util.Disposer.dispose(Disposer.java:36)
2022-04-28T15:42:07,269 DEBUG ecp-17b 35000 SQLSTATE=S0001; error code=16954; Executing SQL directly; no cursor.

Br,