InfoMart missing data

[dnib]

Hi all,

I am having a problem with InfoMart. During the weekend the database run out ouf space and job LoadGIM failed. After the space issue was solved I restarted InfoMart and run the jobs manually.
Now the jobs work fine but I cannot see any data in InfoMart for this last days. In ICON db , table G_CALL, I have data for this days .

Do you have any ideas of what could be wrong ? I do not see any errors in log files.


Thank you

[dnib]

After some more searching I can see that data was not extracted from ICON (there is no new data in _FACT tables ). Does anyone have an idea how to extract this data?

That job that initially failed was LoadGIM .

[smile]

1. what version of GIM are you using?
2. in case 7.6 check data in staging db, because on the first step data transferred from icon db to staging db, not facts tables.

[Allan]

When you ran out of space, the job LoadGIM failed. You sorted out the space problem and then restarted Infomart.

Did you rerun LoadGIM and was it successful?

Agree with previous post that the extracted and transformed data would have been in Staging Database ready for loading into Infomart.

As new interactions are now in Icon and you state that the jobs are running fine, are you able to ascertain which period has missing data?

Depending on how many days data you store in Icon and if you have a reliable backup of GIM and Staging databases, you could rollback to a known point in time (for both GIM and Staging) and rerun the ETL jobs.

Good luck and suggest that you contact Genesys technical support to help you fix this problem.

Allan

[smile]

[quote author=Allan link=topic=6921.msg30085#msg30085 date=1328267956]

Depending on how many days data you store in Icon and if you have a reliable backup of GIM and Staging databases, you could rollback to a known point in time (for both GIM and Staging) and rerun the ETL jobs.

Good luck and suggest that you contact Genesys technical support to help you fix this problem.

Allan
[/quote]

+1, good suggestion!

[dnib]

Thank you for your replys.

Unfortunately the number of days passed does not allow me to do a rollback . I opened an SR with Genesys Support and they told me that i must upgrade ICON .

[postx]

[quote author=dnib link=topic=6921.msg30274#msg30274 date=1331021688]
Thank you for your replys.

Unfortunately the number of days passed does not allow me to do a rollback . I opened an SR with Genesys Support and they told me that i must upgrade ICON .
[/quote]

as usual...

[dnib]

The suggested ICON upgrade did not help but Genesys provided some scripts to apply on ICON DB. I will do that and run GIM jobs. I hope it will work this time.