Author Topic: Data push delay In Cognos Controller  (Read 438 times)

Offline nilamani

  • Associate
  • **
  • Join Date: Feb 2018
  • Posts: 2
  • Forum Citizenship: +0/-0
Data push delay In Cognos Controller
« on: 18 Feb 2018 11:03:31 pm »
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?
« Last Edit: 09 Mar 2018 03:56:15 am by nilamani »

Offline smiley

  • Community Leader
  • *****
  • Join Date: Oct 2005
  • Posts: 204
  • Forum Citizenship: +12/-0
Re: Data push delay In Cognos Controller
« Reply #1 on: 09 Mar 2018 06:08:14 am »
Have you tried with "track data" disabled in your import spec?

Offline nilamani

  • Associate
  • **
  • Join Date: Feb 2018
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Data push delay In Cognos Controller
« Reply #2 on: 05 Jul 2018 01:40:35 am »
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.

 


       
Twittear