Crystal reports XI R2 11.5 - Scheduled reports stuck in pending

[rw409168]

I'm assisting in migrating a Crystal reports server XI R2 11.5 installation and reports to a new server, currently the existing installation is running along side the new install on a different server.

The problem I'm experiencing with the new install is when scheduling reports, the report currently alternates from running/pending and cannot be completed.
The following error can be seen in the windows event log:

http://i140.photobucket.com/albums/r13/robtyketto/WindowsEventLogSchedulerError.png

I have more experience with crystal reports designer than the administrator side, though to debug the problem I compared the settings of the crystal reports servers between the installations.

The Program job and destination server have destinations whereas the Report job server has NONE (See diagram below).

http://i140.photobucket.com/albums/r13/robtyketto/ProgramJobServer.png

When I schedule the report they are emailed to a number of email addresses, these are not the default email settings I've set up on the program job server which is an option to use in the scheduler, instead I specify the email addresses.

Firstly does the scheduler use the destinations from the reports job server? If so, as mine has no options to use the defaults, how do I add the destinations?

If this is not the issue with the report not running/being stuck in pending mode can anyone advise some steps to resovle this issue.

Thanks Rob

 

[briangriffin]

I doubt this has anything to do with the destinations defined on the job server, but that might be an additional problem.

When you click the work "Pending" in the job history, what does it say? (sorry can't hit shared storage from here to see your screenshots).

 

[rw409168]

From within Infoview when clicking on the pending in the history the following is being displayed:

Status Pending
Printer: The instance is not printed.
External Destination: Mail the instance to: "[xxxx.xxx@xxxx.com]" with a subject of: "Test Report" .
Recurrence Type: Report runs once.
Creation Time: 09/08/2011 17:24
Next Run Time: 15/08/2011 16:34

The servers windows error log display the following details:
Transport System exception for backend plugin DLL type newIJob():: Couldn't get IJob interface: CORBA exception! Object type is: CrystalEnterprise.Report and detail: IDLmg.org/CORBA/UserException:1.0
. Details: %2.

 

[briangriffin]

Can you schedule any of the sample reports successfully? Can you schedule any of your problem reports to default BOE destination (not email)? If the sample report runs sucessfully, can you schedule it to an email destination successfully?

Based on what I read in your SAP forum post, you should probably open a ticket with SAP to back your bets.

 

[rw409168]

Thanks for your help.

I am unable to schedule reports to any of the destinations availble from the drop down e.g. Inbox, file location or email.

Status alternates between running/pending, the same error is written to the windows event log as posted above.

Within the Logging directory (Program Files\Business Objects XI\Crystal Reports\BusinessObjects Enterprise 11.5\Logging)

The latest JobServer log has the following details logged (can upload if required):

assert failure: (.\csiprocess.cpp:796). (0 : CreateProcess() failed for commandline ["C:\BusinessObjects Enterprise 11.5\win32_x86\jobserverchild.exe" "C:\BusinessObjects Enterprise 11.5\win32_x86\jobserverchild.exe" -cmdLine cmdLine=%22C%3A%5CBusinessObjects+Enterprise+11.5%5Cwin32_x86%5Cjobserverchild.exe%22+%22C%3A%5CBusinessObjects+Enterprise+11.5%5Cwin32_x86%5Cjobserverchild.exe%22+%2Dservice+%2Dns+ofs%2Dcrystal+%2DobjectType+CrystalEnterprise.Report+%2Dtype+outproc+%2Drestart+%2DjsTypeDescription+%22Crystal+Reports+Job+Server%22+%2Dname+ofs%2Dcrystal.reportjobserver+%2Dlib+procReport+%2Ddir+%22E%3A%5CProgram+Files%5CBusiness+Objects+XI%5CCrystal+Reports%5CBusinessObjects+Enterprise+11.5%5CData%5CprocSched%5Cofs%2Dcrystal.reportjobserver%22+%2Durlfile+%2DnumericIP+false -readPipe 348 -writePipe 338 -type mixedproc]. Last error is 2).

 

[briangriffin]

Does this mean you can run both your reports and sample reports to default destination?

I think you have problems more than just configuration - first thing I'd do is run the installer in repair mode. Then test functionality using the sample reports.

 

[rw409168]

Thanks again for the reply, I have tested the sample reports and they too get stuck in pending and report the same error to the windows event log.

I will work with the infrastructure team to run the installer in repair mode.

 

[rw409168]

Re-ran the Crystal reports XI R2 SP2 11.5.8.826 installer and selected repair option which completed without errors.

Rebooted server.

Running sample or my uploaded reports has the same issues with the report left in pending however the Jobserver log in (E:\Program Files\Business Objects XI\Crystal Reports\BusinessObjects Enterprise 11.5\Logging) is not being updated when the job is running with errors as it was before.

The CMS log however points to an issue that looks like a permissions or similar issue to the mysql database (see below)

CMS_20110815_183949_1116.log
[Mon Aug 15 18:40:06 2011] 1116 6040 assert failure: (.\pluginhelper.cpp:797). (cuidToIdMap.GetCount() == lArraySize : CrystalEnterprise.MetaData.DataConnection).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:220). (0 : no message).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:58). (0 : no message).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:401). (0 : no message).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:58). (0 : no message).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:120). (0 : no message).
[Mon Aug 15 18:55:36 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:768). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1195). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1052). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1067). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1121). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1647). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:802). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1750). (0 : no message).
[Mon Aug 15 18:57:53 2011] 1116 3468 assert failure: (.\ScheduleObject.cpp:1913). (0 : no message).
[Mon Aug 15 19:01:15 2011] 1116 4620 assert failure: (.\mysqlwrapper\MySQLDatabase.cpp:526). (0 : MySQL Database: ERROR while connecting to the MySql database host.).
[Mon Aug 15 19:01:15 2011] 1116 3468 assert failure: (.\mysqlwrapper\MySQLDatabase.cpp:526). (0 : MySQL Database: ERROR while connecting to the MySql database host.).
[Mon Aug 15 19:01:15 2011] 1116 4620 assert failure: (.\ObjectSubsystem.cpp:2968). (0 : Database access error. Reason ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061). MySQL database error: ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061)
).
[Mon Aug 15 19:01:15 2011] 1116 3468 assert failure: (.\ObjectSubsystem.cpp:2968). (0 : Database access error. Reason ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061). MySQL database error: ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061)
).
[Mon Aug 15 19:01:20 2011] 1116 1672 assert failure: (.\cparamlineargs.cpp:330). (!m_programName.isEmpty() : no message).
[Mon Aug 15 19:01:21 2011] 1116 3480 assert failure: (.\mysqlwrapper\MySQLDatabase.cpp:526). (0 : MySQL Database: ERROR while connecting to the MySql database host.).
[Mon Aug 15 19:01:21 2011] 1116 3480 assert failure: (.\ObjectSubsystem.cpp:2530). (0 : Database access error. Reason ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061). MySQL database error: ERROR2003(HY000): Can't connect to MySQL server on '127.0.0.1' (10061)
).


Then a later CMS log records
CMS_20110815_190147_1384.log

Timestamp ProcessID ThreadID Message
[Mon Aug 15 19:02:01 2011] 1384 1404 assert failure: (.\pluginhelper.cpp:797). (cuidToIdMap.GetCount() == lArraySize : CrystalEnterprise.MetaData.DataConnection).

 

[rw409168]

The was a delay in the logging as the JobServer logs were then created in volume and reported the error (as detailed in an earlier post)

assert failure: (.\csiprocess.cpp:796). (0 : CreateProcess() failed for commandline ["C:\BusinessObjects Enterprise 11.5\win32_x86\jobserverchild.exe" "C:\BusinessObjects Enterprise 11.5\win32_x86\jobserverchild.exe" -cmdLine cmdLine=%22C%3A%5CBusinessObjects+Enterprise+11.5%5Cwin32_x86%5Cjobserverchild.exe%22+%22C%3A%5CBusinessObjects+Enterprise+11.5%5Cwin32_x86%5Cjobserverchild.exe%22+%2Dservice+%2Dns+ofs%2Dcrystal+%2DobjectType+CrystalEnterprise.Report+%2Dtype+outproc+%2Drestart+%2DjsTypeDescription+%22Crystal+Reports+Job+Server%22+%2Dname+ofs%2Dcrystal.reportjobserver+%2Dlib+procReport+%2Ddir+%22E%3A%5CProgram+Files%5CBusiness+Objects+XI%5CCrystal+Reports%5CBusinessObjects+Enterprise+11.5%5CData%5CprocSched%5Cofs%2Dcrystal.reportjobserver%22+%2Durlfile+%2DnumericIP+false -readPipe 348 -writePipe 338 -type mixedproc]. Last error is 2).

 

[rw409168]

Slightly off topic to contact SAP support I assume they would need registration details.

For the Crystal Reports XI Developer I simply launch the About page which has the details.

How do I go about finding the same information for Crystal Reports XI R2 Server?

I assume as different products would have different registration numbers, I cannot find these details in the Central management console, info view or the Central configuration manager etc..,

Thanks

 

[briangriffin]

I don't have Crystal Server handy, but I'm pretty sure the Central Management Console looks the same - you should see a link for license keys.

SAP should have that info stored under your account info, but if not you can add them when you log into the SAP site.

 

[rw409168]

Thanks indeeded the is an option "License keys", I'd seen this and it displays the product key I wasn't sure if there was another key/code that I need to reference for SAP communication.

 

[rw409168]

Well I contacted SAP support, unfortunately as the company I work for don't have a valid agreement with SAP (though products are registered) they advised to post the isse on their forum (which I have already posted on with little response).

Does anyone have any other ideas to diagnose what the problem is with scheduling reports?

I can preview sample and inhouse reports from the central console managements it's just they won't run from the scheduler, always stuck in pending.

Thanks for the advice given so far, learning more and more about Crystal Reports.

 

[briangriffin]

I would consider a complete reinstall if that's an option, and it sounds like it is. Before migrating any content make sure you can schedule one of the sample reports, view it on demand, and do the same with Webi if you'll be using that.

Then add the SMTP info to the appropriate servers and make sure you can email one of the sample reports.

At that point I'd be pretty confident that migrated content would also process properly (once you recreate all the data sources).

 

[rw409168]

Thanks for the reply as soon as infrastructure guy is back in the office I will work with him to re-install Crystal reports server and report back the success rate.

 

[rw409168]

I installed crystal reports XI R2 and then SP2 on top and there are no problems with scheduling now, nor the entire installation.

No idea how the original install had a mixture of servers running different version numbers, happy to have learnt so much about Crystal reports in the last few weeks.