Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: dnib on January 31, 2012, 12:21:40 PM

Title: InfoMart missing data
Post by: dnib on January 31, 2012, 12:21:40 PM

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

Title: Re: InfoMart missing data
Post by: dnib on February 01, 2012, 12:45:31 PM

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 .

Title: Re: InfoMart missing data
Post by: smile on February 01, 2012, 03:21:58 PM

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.

Title: Re: InfoMart missing data
Post by: Allan on February 03, 2012, 11:19:16 AM

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

Title: Re: InfoMart missing data
Post by: smile on February 03, 2012, 11:30:32 AM

[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!

Title: Re: InfoMart missing data
Post by: dnib on March 06, 2012, 08:14:48 AM

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 .

Title: Re: InfoMart missing data
Post by: postx on March 07, 2012, 08:09:59 PM

[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...

Title: Re: InfoMart missing data
Post by: dnib on March 22, 2012, 09:41:35 AM

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.