Scheduling a report to FTP as CSV fails

[Former Member]

Hi everyone,

A webi is scheduled to ftp location with output format as CSV fails throwing error

"Object failed to run due to an error while processing on the job server".

if same report is scheduled as excel or pdf to FTP it runs successfully. i have also scheduled report with output format CSV to enterprise location and report fails. i see it has problem converting report into CVS. do i need to change any parameter valu in universe or something similar.

we are on BI 4.0 SP6 patch 1.

any kind of help is appreciated.

Thanks

[Former Member]

Hi Bhavanam,

Sorry for getting back late on this.

report takes like less than a minute to run.

exporting the report to CSV fails but exporting the same report to pdf works fine.

all other reports work fine exporting to CSV.

[former_member136842]

Hi,

so its that report specific. Take out the Dimension which you say is "character long" and re- try.

Regards

-Seb.

[Former Member]

Hi,

So as Seb mentioned this is to do with single report. Shoot it that way.

Regards,

Upendra.

[amitrathi239]

Hi,

Check the 1900005 - Error "Object failed to run due to an error while processing on the Job Server" when sched... sap note.

Resolution

Increase the Java VM setting of Adaptive Job Server.

1. Open the Central Management Console
2. Browse to the Servers page
3. Open the properties of Adaptive Job Server
4. In the Command Line Parameters, locate the string Xmx, then change it to Xmx2g ( 2G of RAM). Depending on the complexity and data size, you may need to use Xmx4g.
5. Save and Close.
6. Restart the Adaptive Job Server

The following is the sample of Command Line Parameter field of Adaptive Job Server:

Before the change:

-javaargs "Djava.awt.headless=true,Dcom.businessobjects.mds.cs.ImplementationID=csEX,XX:MaxPermSize=192m,Xmx,Dbusinessobjects.connectivity.directory=C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0//dataAccess/connectionServer" -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -maxDesktops 0 -jsTypeDescription "Crystal Reports Job Server" -objectType CrystalEnterprise.Report

After the change:

-javaargs "Djava.awt.headless=true,Dcom.businessobjects.mds.cs.ImplementationID=csEX,XX:MaxPermSize=192m,Xmx2g,Dbusinessobjects.connectivity.directory=C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0//dataAccess/connectionServer" -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -maxDesktops 0 -jsTypeDescription "Crystal Reports Job Server" -objectType CrystalEnterprise.Report

[Former Member]

Thanks for the reply Amit.

i tried increasing java VM to 4g and tried scheduling the report but it still failed giving same error.

Report contains one character long object data type i think this may be causing the issue where it is not able to convert data into CVS.

any help?

Thanks

[Former Member]

Hi Kumar,

Lets take the issue one step down first.

1. Refresh the report.

• How long does the report refresh take?
• This is to check on the time out settings in place from universe level.

2. Export to CSV.

• What happens here? does it get exported with out any issue?
• Try any other report to export to CSV again and check.
  

From here you confirm if the issue is with the scheduling alone or with the processing server.

Regards,

Upendra.