Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: vivek_cyno on 06 Feb 2012 07:30:42 AM

Title: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 07:30:42 AM
Hi,

I have a scheduled job wherein I have reports to execute and deliver to my email.

I see few reports got failed and when I rerun Its running fine.Could you please assist on this.Thanks in advance.
Title: Re: Reports Getting Failed..Help needed
Post by: Grim on 06 Feb 2012 07:38:54 AM
Run an SDS trace on the job and this should help.
http://www-01.ibm.com/support/docview.wss?uid=swg21340148
Title: Re: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 07:42:02 AM
Hi Grim,

Only few reports getting failed.Please assist.
Title: Re: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 08:00:04 AM
I was able to rerun the reports. But when a job does not run good, we have to do that manually.

Today again we have jobs where soms reports are failed. So also today we have to run some reports manually.
Can you search why some reports of jobs sometime fails? If we have to validate each jobs and rerun reports
Title: Re: Reports Getting Failed..Help needed
Post by: Grim on 06 Feb 2012 08:08:36 AM
I'd suggest whoever owns those jobs/schedules renew their credentials. This usually fixes this issue 9 times out of 10.
http://publib.boulder.ibm.com/infocenter/caapps/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cc.8.4.1.doc/ug_cc_i_ScheduledReportsFail.html

The if the above does not fix it, run the SDS trace and examine the trace log for clues on the error. Usually a mail server issue.
Title: Re: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 08:15:30 AM
Hi Grim ,

Thanks for your suggestion.

I wonder how come few reports was success and few are error'd out...If the credentials being the issue all should get failed rite?
Title: Re: Reports Getting Failed..Help needed
Post by: Grim on 06 Feb 2012 08:18:53 AM
Only if they are all scheduled by the same person/account.
Title: Re: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 08:22:59 AM
Grim,

Yes ,all the reports are executed by a single job...May you please let me know, how come it be a authentication issue, as few reports in that  job succeeded and few failed.
Title: Re: Reports Getting Failed..Help needed
Post by: Grim on 06 Feb 2012 08:27:40 AM
How bout this...

Try the renew credentials first, and if that doesn't work get the SDS trace and post it here.
Title: Re: Reports Getting Failed..Help needed
Post by: vivek_cyno on 06 Feb 2012 08:30:37 AM
Hi Grim,

Thanks much..I have SDC enabled.Could you please tell me which file I have to look for in  cognos\c8\logs

Thanks again
Title: Re: Reports Getting Failed..Help needed
Post by: Grim on 06 Feb 2012 10:12:50 AM
Depends on what version your running and if you modified the appender.

Code Select
        <appender name="clientFlatFile" class="org.apache.log4j.RollingFileAppender">
                <!-- The setting for the File parameter below has been tested with ReportNet while running under Tomcat.Because of their 'current working directory',
        other application servers (e.g. WebLogic), may require that an absolute path to the log file be specified. Ensure the log directory is writable.
        -->
                <param name="File" value="../logs/crnclient.log"/>
                <param name="MaxBackupIndex" value="1"/>
                <param name="MaximumFileSize" value="10485760"/>
                <layout class="org.apache.log4j.PatternLayout">
                        <param name="ConversionPattern" value="%m%n"/>
                </layout>
        </appender>

This is the default and as such if you didn't modify your you will looke for "../logs/crnclient.log"
Text only | Text with Images