If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data push delay In Cognos Controller

Started by nilamani, 18 Feb 2018 11:03:31 PM

Previous topic - Next topic

nilamani

Data transferred from Oracle to controller through Java Coding.Data flow from Oracle temp table to controller table xstagefact. After data gets inserted into xstagefact, a process triggered for batch id creation  and validation as defined in import specification. Post validation the data gets inserted into xdb18.The entire process which usually takes 45 mins, however sometimes it takes 5 to 6 hr to complete and after optimization it get normal.Pls suggest how to find out the cause?

smiley

Have you tried with "track data" disabled in your import spec?

nilamani

Track Data was already disabled. However the we have cleared the xstagefact table as auto delete was not enabled, and run optimization every week as a maintenance plan. The issue has not repeated for last 5 month.