Forum Discussion

CastroRibeiro's avatar
5 years ago

SAP 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;