Forum Discussion
CastroRibeiro
Helper I
5 years agoSAP BW connectivity issue, CX_SY_DYNAMIC_OSQL_SYNTAX exception
The query was working normally until it started to give this problem, would anyone have an idea of what it could be?
In the BW module the query works normally, the problem only happens when you pull the Powerbi
DataSource.Error: The SAP BW server reported an error: 'An exception of type CX_SY_DYNAMIC_OSQL_SYNTAX has occurred, but it has not been handled locally or declared through a clause'. For more information about this error, visit the SAP support website and search for 'RS_EXCEPTION 000'.
Details:
DataSourceKind=SapBusinessWarehouse
DataSourcePath=vhwpp.host.com/WPP/700/WPP
ID=RS_EXCEPTION
NUMBER=000
MESSAGE_V1 = An exception of type
MESSAGE_V2 = CX_SY_DYNAMIC_OSQL_SYNTAX, but it was not handled
MESSAGE_V3 = locally or declared by means of a clause
SYSTEM=LS_WPP_700
Command=EXECUTE FUNCTION 'BAPI_MDPROVIDER_GET_HIERARCHYS' EXPORTS CAT_NAM = 'SP_LTM26', CUBE_NAM = 'SP_LTM26/SPX_LT_APONT_MUL_01' TABLES 'HIERARCHIES' INTO RESULTSET;
1 Reply
- v-kelly-msft
Community Support
Hi CastroRibeiro ,
Check below thread from SAP community which may be of help:
https://answers.sap.com/questions/10475835/loading-fi-gl-master-from-ecc-to-bw.html
Best Regards,
KellyDid I answer your question? Mark my post as a solution!