COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: sakthi.s on 05 Jan 2010 07:15:53 AM

Title: Urgent - Problem Facing while execute both builds and Jobs
Post by: sakthi.s on 05 Jan 2010 07:15:53 AM
Hi Friends,

We have builds and jobs defined in Cognos Decision Stream for Date – Time dimension. I tried to execute both builds and Jobs, in command prompt it is showing as succeeded but I am unable to see any data updated in the corresponding SQL server table (ALL_TIME). Please let me know what other criteria's need to be checked before executing the builds and jobs in Decision Stream. Also on a note, source system (JDE) has data available but it is not being pulled from Decision Stream to upload in SQL Server.

Thanks in Advance
Title: Re: Urgent - Problem Facing while execute both builds and Jobs
Post by: MFGF on 06 Jan 2010 05:24:52 AM
Go to the properties of the build in the Designer, onto the Logging tab, and enable Progress and Detail logging.  Save then run the build, and look at the generated log file.  This should list stats for the rows read, processed and delivered.  If in doubt, post the text from the log file here and we can help.

MF.
Title: Re: Urgent - Problem Facing while execute both builds and Jobs
Post by: JaiCognos on 06 Jan 2010 06:48:25 AM
Hi,

When you want to run the build there is different options to run the build.

We can set the option to TEST which executes the build but will not load the data.

So please check the execution of the build and also check the log detail log file.