Reports Getting Failed..Help needed

[vivek_cyno]

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.

[Grim]

Run an SDS trace on the job and this should help.
http://www-01.ibm.com/support/docview.wss?uid=swg21340148

[vivek_cyno]

Hi Grim,

Only few reports getting failed.Please assist.

[vivek_cyno]

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

[Grim]

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.

[vivek_cyno]

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?

[Grim]

Only if they are all scheduled by the same person/account.

[vivek_cyno]

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.

[Grim]

How bout this...

Try the renew credentials first, and if that doesn't work get the SDS trace and post it here.

[vivek_cyno]

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

[Grim]

Depends on what version your running and if you modified the appender.

Code Select Expand

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