tags:

views:

205

answers:

1
Q: 

PeopleSoft Crystal process remains queued if part of PSJob

Hi

I am being driven mad with some PeopleSoft jobs that I'm scheduling. Job Sets and PSJobs with Crystal will not initiate the Crystal processes. The process (or any other Cyrstal process I try) will run if scheduled independently but in any form of PSJob or Job Set they remain with teh first Crystal job status=queued.

I've spent a day googling, reading Metalink, etc. Anyone got any ideas?

Cheers Karl

+1  A: 

I have seen this happen when the job is run on a unix process scheduler and, as you probably know, crystal will only run on a windows process scheduler. The solution was to force the entire job to run on a windows process scheduler.

WayneH  2010-02-20 02:23:00
I considered this but we have some very data-intensive Cobols and SQRs in the jobs and want them on the Unix Scheduler with no network between the DB and Scheduler. Doh!
Karl  2010-02-23 18:43:05
Do you also have access to the FSCM modules, AM has examples of AE programs scheduling SQR programs. Insert the data right into the process scheduler tables. This might be an option as well, instead of crystal being in the PSJOB, replace it with an AE program that submits the crystal to run on windows process scheduler.
WayneH  2010-02-23 23:12:08
Of course, that is assuming that the crystal does not really have to be part of the job and only has to run at that point in time. The job would still continue on the unix scheduler, which is where a problem could occur.
WayneH  2010-02-23 23:13:42

related questions

Dynamically change an image in a Crystal Report at runtime
Change the Catalog property of a Crystal Report in VS 2005
Crystal Reports .Net Guidance
VS 2003 CrystalReports - details section problem
Where can I get a list of what Crystal Reports features conflict?
VB6 / Crystal Report 8.5 error: A string is required here
Merge Modules for Crystal Reports 2008 - Needs a Keycode?
Crystal Reports and LINQ
VB.NET 2005 problems with Designer not being able to process a code line.
How do you detect and print the current drilldown in the CrystalReportViewer control?
How do I query the CrystalReports CMS database?
Crystal Reports 2008 InprocServer + TempDir = "Operation not yet implemented"
Crystal Report icons/toolbar not working when deployed on web server
Using MySQL on Visual Studio 2008
XML dataset in Crystal Reports
Replace a database connection for report and all subreports
Is it okay to have a lot of database views?
How to handle variable width FieldObjects in Crystal Reports
"File Save Failed" error when working with Crystal Reports in VS2008
Summary fields in Crystal Report VS2008
Broken chart images in Crystal Reports in web application
What's the best way of diffing Crystal Reports?
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
.NET 3.5 SP1 and aspnet_client Crystal Reports
Is there some way of recycling a Crystal Reports dataset?