BusinessObjects job reports output format different from SAP BusinessObjects Central Management Console (CMC).
Article ID: 87860
CA Automic Workload Automation - Automation EngineAUTOMIC WORKLOAD AUTOMATION
Error Message : N/A
When the output option ‘tab separated values’ is selected on a SAP BusinessObjects job defined against the RA BusinessObjects Agent the results display in the csv file with double quotes around them as shown below.
This is because SAP’s REST API that Automic is using doesn’t have the same text qualifier options available as are available from SAP’s CMC. So when the ‘tab separated values’ option is selected SAP’s BusinessObject’s REST API sets the default to a double quote instead of setting the output to the desired format in plain text without the quotes such as this:
We do have a workaround available for those customers running the RA BusinessObjects Agent from the Automation Engine, which is basically to run a Post Process script that will strip off the quote characters from the report. A Word document outlining the setup for this workaround is attached to this Article as well as well as 2 sample report output files showing the data before running the Post Process script and after.
Cause type: Other Root Cause: According to SAP, only the ‘ and the “ are approved values within the RESTful SDK, which is what Automic is using for their RA BusinessObjects Agent. SAP stated that the RESTful SDK is not yet at full parity with what the CMC/BI Launchpad is able to do.
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.
Fix Version(s): In order for all the output delimiter options to be available in Automic’s RA BusinessObjects Agent that are available in CMC/BI Launchpad, SAP will need to add those output delimiter options to their RESTful Web Services SDK