SAP ByDesign : Server error "INVALID_CHARACTERISTIC_NAME"

[urabe62]

When I am retrieving a large amount of data in SAP ByDesign's OData endpoint, sometimes I get an "INVALID_CHARACTERISTIC_NAME" error. What is the cause of this error?

Below is the request and response when the error occurs.

Request URL

GET https://***.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/RPZF1CD3A3FB8D6C70E118566QueryResult...

Request Header

HTTP Auth Scheme: 0
User: ***********
Password: ************
GET /sap/byd/odata/cc_home_analytics.svc/RPZF1CD3A3FB8D6C70E118566QueryResults?$select=CIPY_BUYER_PTY%2cTIPY_BUYER_PTY%2cCIPY_BILL_TO_PTY%2cTDOC_S_AG_CANCEL%2cTITM_S_CANCEL%2cC1DOC_UUIDsDOC_CHANGED_DT%2cKCIAV_CFFULF_QT_B%2cKCITV_CONF_QT_B%2cTDOC_S_CONSIST%2cC1DOC_UUIDsDOC_CREATED_DT%2cTIAV_INV_AM_CC_R%2cTITV_NT_AM_CC_R%2cTITM_S_FUL_PROC%2cKCIAV_FULF_QT_B%2cTDOC_S_AG_FULFIL%2cKCIAV_INV_AM_D%2cKCIAV_INV_AM_R%2cKCIAV_INV_QT_B%2cUCIAV_INV_QT_B%2cTITM_S_INV_PROC%2cTITM_TYPE%2cTDOC_S_AG_COR_LC%2cKCITV_NT_AM_R%2cKCITV_NET_AM_D%2cKCITV_REQU_QT_B%2cUCITV_REQU_QT_B%2cCITM_POST_DT%2cC1SC5H8YQSIXFQC28BVVGFST3TK%2cT1SC5H8YQSIXFQC28BVVGFST3TK%2cCIPR_PROD_UUID%2cTIPR_PROD_UUID%2cTDOC_S_AG_PL_REL%2cCDBA_SLS_ORG%2cTDBA_SLS_ORG%2cCIPY_SLS_UNIT_PTY%2cTIPY_SLS_UNIT_PTY%2cCIPY_SELLER_PTY%2cTIPY_SELLER_PTY%2cCDOC_UUID%2cCITEM_UUID%2cCIPY_SUPPL_PTY%2cTIPY_SUPPL_PTY%2cTIAV_INV_AM_CC_D%2cCDTT_INIT_REC_DT&$skip=0&$top=1000&saml2=disabled&$format=json HTTP/1.1
Host: ***.sapbydesign.com
Authorization:******
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
MaxDataServiceVersion: 2.0
MinDataServiceVersion: 2.0

Response Header

HTTP/1.1 400 Bad Request
content-type: application/json
content-length: 166
strict-transport-security: max-age=31536000; includeSubDomains
set-cookie: sap-usercontext=sap-client=217; path=/;HttpOnly;Secure
set-cookie: *****; path=/; secure; HttpOnly;HttpOnly;Secure

Response Body

{"error":{"code":"00145E5B1CC71EE0ACBD33E944B1819D","message":{"lang":"en","value":"Program error in class CL_RSBOLAP_QV_AXIS method : INVALID_CHARACTERISTIC_NAME"}}}

Thanks,

[scloutier]

I have the same error, even though the same query could to work flawlessly for days on end. Sometimes it starts returning `Program error in class CL_RSBOLAP_QV_AXIS method : INVALID_CHARACTERISTIC_NAME`

[pavithraa_jc]

Dear Customer,

Hope you are doing well!

OData Query URL should consist of work center detail, end point from where data has to be fetched. 
Consider the same example : 
https://XXXXXX.sapbydesign.com/sap/byd/odata/sapbyd.XXXXXXX_XXXXQueryResult 
This does not have work center mentioned in it. 

The correct format of OData Query would be as : 
https://XXXXXX.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/XXXXXXX_XXXXQueryRe...

If the issue persists, then raise a case to SAP support to investigate further. 

Thanks and Regards,

Pavithra