Infomart data missing

[Gautham]

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

[hsujdik]

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

[CGB]

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ˇˇ