Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gautham on July 12, 2016, 06:49:25 PM

Title: Infomart data missing
Post by: Gautham on July 12, 2016, 06:49:25 PM

Hi Friends,

I am facing data missing issue with Infomart . But all data available in ICON. yesterday's data  available in infomart . only day before yesterday data is missing. So i need to run the job for that particular date to to get the data to infomart then i will generate report in SAP BO. Kindly help me to know what i need to do exactly to get  the data to infomart.

Thanks,
Gowtham ???

Title: Re: Infomart data missing
Post by: hsujdik on July 13, 2016, 12:56:20 AM

Has one of your servers by any chance been set to a time in the future? If so, Info Mart might have set the High Water Mark to that date and didn't extract things before it. In that case, the best way to proceed is to open a ticket

Title: Re: Infomart data missing
Post by: CGB on July 13, 2016, 02:06:42 PM

Hello,

We face that problem some time ago, without reason, data were not agregate to Infomart for ten hours. We did the following (This solution was given by Genesys Customer Services and it worked for us, If I can't post it, please advice me and I will remove it):

Disable the schedulers on your GIM application and one time all of them have finished, stop the GIM.

Run on your GIM installation path:
java -jar agg\GIMAgg.jar -user=<user> -pass=<password> -jdbcurl=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST = <host>)(PORT = <port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <service_name<))) -levelOfLog=.:INFO,Agg:FINEST -insertPendingAggRaw ALLTENANTS:ALLSETS:XX:YY

where ALLTENANTS:ALLSETS:XX:YY it's the time you want to recover on EPOCH formate

Then, run manually the agregate job:
java -jar GIMAgg.jar -user= <user> -pass=<password> -jdbcurl= jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST = <host>)(PORT = <port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <service_name>)))  -levelOfLog=.:INFO,Agg:FINEST -log=agg_log.txt

Then, check agg_log.txt file and check if your data has been agregate to infomart. Now, you can enable the jobs again and start your GIM.

As I said, it worked for us, please, open a case with Genesys before to do anything¡¡