Scheduled Crystal Report not be sent out.

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

MatthewD

Veteran Member

Posts: 53

11/20/2012 8:14 PM

We just upgraded to Lawson 9.0.1 from 9.0.0. We have a custom Crystal Report that's been running daily out of Reporting Services to a printer. The printer is really a folder for report 2 web. After the go live we noticed the report was not getting sent to the "printer"/folder. I was able to perform a device test which made it to the folder however even though the report shows it ran nothing is going out to the folder. I checked the systemout.log and found the following message. "Error printing file: java.io.IOException: Cannot run program ""C:\Program": CreateProcess error=2, The system cannot find the file specified."

Matthew Nye

Veteran Member

Posts: 514

11/21/2012 12:25 PM

Matthew,

So Im assuming you defined a PDF Printer as a device? Your upgrading Lawson environment shouldnt have effected LBI unless they share the same server. In that case, did you upgrade Adobe Reader by any chance? First off, check the path that is defined in your Printer Device used for this schedule. Next, login to your Framework Services server (if FS and RS are on separate servers, be sure you are on FS). Open a Windows Explorer and paste that directory in the address. I imagine this isnt the issue, but if you get an error here, you need to update the locaton of the Adobe Reader exe. So assuming this test passes the next thing to check is permissions.

Is the directory that is being written to remote to the FS server? If yes, are you running WebSphere under a network service account that has access to that remote folder?

Post back your results and we can further troubleshoot if none of this uncovers the issue.

MatthewD

Veteran Member

Posts: 53

11/21/2012 5:32 PM

According to the systemout.log just prior to the error message Lawson is trying to open Adobe from C:\Program Files\Adobe... however Adobe isn't installed on this new 64bit box. When i try to install it Adobe won't install under C:\Program Files\ only C:\Program Files (x86)\ even though both exist.
I'd like to change the path stored in Lawson but not sure where to find it.

Matthew Nye

Veteran Member

Posts: 514

11/22/2012 8:29 AM

You should be able to chose a custom location when installing Adobe Reader. If you cant get that to work changing the path is no problem but just to clarify, you said "I'd like to change the path stored in Lawson ". I want to make sure we are discussing a printer set up in Lawson Business Intelligence (or more specifically, Framework Services). If this is true, you would:

1. Go to the Tools dashboard
2. Click Delivery
3. Click Manage Devices Types
4. Find the Name that is used in your bursting set up and click it
5. You need to update the field "Path to Acrobat"

MatthewD

Veteran Member

Posts: 53

12/3/2012 6:07 PM

Matthew thanks. I did change the path in Lawson Framework services to point to the new Adobe path. While i'm not getting that error message any more I still can't get a scheduled job to go to a printer device however the device test is able to send a test file to the printer device.

Matthew Nye

Veteran Member

Posts: 514

12/4/2012 4:54 PM

i would validate that the report is returning data, that your user that the device is assigned to has permissions and that the bursting is set to go to all report users and report owners, not just owners, if you are not the report owner.

are there any messages in the logfiles when the schedule kicks off?