SAP Knowledge Base Article - Public

3447677 - Internal Server Error on CPQ API calls

Symptom

Error message when running Quotes API:
{
    "error": {
        "code": "116000",
        "message": "Internal server error.",
        "target": "/api/v1/quotes?$filter=quotenumber%eq%",
        "details": [],
        "internalMessage": "Incorrect syntax near the keyword 'for'.\r\nInvalid usage of the option NEXT in the FETCH statement.\r\nIncorrect syntax near the keyword 'for'."
    }
}

Environment

SAP SALES CLOUD CPQ

Reproducing the Issue

Run following API endpoint /api/v1/quotes?$filter=quotenumber eq 'QuoteNumber' using bearer token.

Cause

The visibility rule has a problem, the database contains quote status names instead of IDs. This causes an exception when evaluating quote visibility.

Resolution

 The advanced condition of the visibility rule should be edited with the correct quote status.

Keywords

CPQ, internal, server, error, incorrect, syntax, API, quote, number, keyword , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem

Product

SAP CPQ 2024