Oracle CRM On Demand Report Services API Developer's Guide > Using the ReportExecute Method >

Troubleshooting the ReportExecute Method


The Oracle CRM On Demand Report Services API can encounter problems with the command line and parameters, and also with generating reports. The Oracle CRM On Demand Report Services API responds to error conditions by returning an error message. To resolve a problem, see Table 6.

Table 6. ReportExecution Method Error Messages
Problem
Cause
Solution

Your ReportService request failed. VariableName method is incorrect or not supported. Please check for supported methods and try again.

You specified an incorrect method name.

Check for supported methods and try again.

Your ReportService request failed (Required parameter VariableName missing in method VariableName). Please check your syntax and try again.

One or more parameters are missing.

Review the parameters used and revise the command.

Your ReportService request failed (Incorrect delivery format VariableName provided; supported delivery formats are VariableName). Please check your delivery format and try again.

You specified an incorrect delivery format.

Review the delivery format used and specify a supported format.

Your ReportService request failed (Incorrect Action parameter value provided; supported Action is 'Filter'). Please check your Action parameter value and try again.

You specified the Action=Filter parameter incorrectly.

Specify the Action=Filter parameter correctly.

Your ReportService request failed (Incorrect P0 parameter value provided; supported values only within range 1-6). Please check your P0 parameter value and try again.

You specified the P0 value (number of filters) outside the range of 1-6.

Review and specify the P0 parameter correctly within the range of
1-6.

Your ReportService request failed (Specified P0 parameter value and subsequent parameters not matching). Please provide proper parameters and try again.

The number of filters specified in the P0 value does not match the subsequent filters provided.

Make sure that the number of filters provided matches with the P0 parameter value.

Your ReportService request failed (Operator is not in the specified list of operators). Please provide proper operator and try again.

You specified an operator that is not in the specified list.

Use only supported operators as shown in Table 5.

Your ReportService request failed (Table column parameter is not existing or not specified properly). Please provide the table column parameter correctly and try again.

You specified the table column incorrectly.

Review and make sure the table column does exist and is specified properly, double-quotes (%22) are provided where needed and encoding is done for spaces (%20).

Your ReportService request failed (Column value parameter is not specified properly). Please provide the column value or values correctly and try again.

You specified the column value incorrectly.

Review and make sure that the number of values match the operator, multiple values are separated by a plus (+) sign, and are enclosed within double quotes (%22) where needed.

Your ReportService request failed (Incorrect refresh option VariableName provided; supported refresh options are 'Y' or 'N'). Please check your refresh option and try again.

You specified an incorrect refresh option.

Review the refresh option used and specify a supported option.

Your ReportService Report Execution request failed (Internal error). Please ensure that you can run the report in CRM On Demand and try again.

The ReportService encountered a problem that is not related to a parameter in Table 4. Possible causes include lack of permission to the report folder, the report timed out, memory issues, or the report name was misspelled or does not exist.

Using Oracle CRM On Demand and the same account, try to generate the report. If the report is generated, then check the file name to make sure the correct values are used, and that you have not exceeded service allotments.

Your ReportService request failed (Catalog not enabled)

Analytics V2 is disabled for your company instance.

Contact your administrator.

Your ReportService request failed (Incorrect Catalog value provided; supported Catalog values are 'V3' or 'V3m'). Please check your Catalog value and try again

The catalog you specified is not available.

Review the value that you specified in the Catalog parameter and specify a supported value.

Access Denied

The user account that you used to sign in to Oracle CRM On Demand to call the ReportExecute method does not have the appropriate privilege to access the Company Wide Shared Folder or the Migrated Company Wide Shared Folder.

Contact your administrator to get the appropriate privilege enabled for the user account.

Error messages are captured in the output file specified for the generated content in the ReportExecute method.

Oracle CRM On Demand Report Services API Developer's Guide, Release 37 Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.