Skip to Content
author's profile photo Former Member
Former Member

Scheduling Failed

Hi all,

I have a issue about crystal report scheduling (not sure it coming from the platform or crystal report).

I schedule a crystal report and wait for an hour. After a few hours, the failed status appear.

Error message: Object failed to run due to an error while processing on the Job Server.

I have been tried restart the SIA server and the result remain same.

Besides that, I also try to check the data source (ODBC) and reconfigure the data location with the report, but still failed.

Here is the server that run the BI 4

VMWare Virtual Platform

OS: Windows Server 2008 R2 Enterprise 64-bit

BI Platform: BI 4 SP7

Database: Ms SQL 2008

RAM: 16 GB

Hard Disk: 250 GB

Anyone has the solution or the idea to solve this problem.

Regards,

Thank You.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2014 at 08:02 AM

    At last I found the problem cause was come from the crystal report, not the platform.

    Thank You.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2014 at 09:00 AM

    Hi Wong,

    Is the same report is refreshing fine from Launchpad?

    Do you have any Error messages in the Adaptive Job server logs which will be helpful to narrow down the issue

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2014 at 11:41 AM

    Lets narrow down this to an issue at server level.

    1. Check whether the report is executed properly at CR client tools

    2. Look whether the report can be refreshed appropriately.

    3. Check whether this is a rights issue. Schedule the report with administrator account and not with delegated administrators.

    4. Ensure that the issue is consistent for specific report.

    According to your updates on above points issue can be narrowed down further.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Yew Han,

      I will completely agree with Arvind Pandalai

      Does these two reports use the same Connection as other reports?

      Do you have huge data for these two reports?

      How it is performing when you are trying to create a test report on the same Data connection?

      What is the source of the reports?

      Regards,

      JRK PRASAD

  • Posted on Jan 13, 2014 at 09:23 PM

    Hi Yew Han,

    • How long does this report take to run in Crystal Reports designer?
    • Does this issue happen to all reports or this specific report?
    • On the Job Server machine, in the Task Manager, check for SPLWOW64.EXE. If there is one in memory, try killing the process and reschedule the report.

    However based on the current information provided, there's still a lot of information that needs to be gathered.

    Regards,

    Wallie

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2014 at 09:29 PM

    When you schedule, what destination and Format did you schedule it to?

    Are you scheduling it to email? or file system?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It should be optimize where the stored procedure:

      1. create the prompt

      2. take 3 years data based on the prompt (requirement for the report)

      3. create temp tables (7 tables)

      4. retrieve the required data from temp tables

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.