Symptom
One of the errors below occur in Analysis for Office when the query/workbook/report was executed using a range for a variable:
-----------------------------
An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources.
Nested exception. See inner exception below for more details
sql syntax error: incorrect syntax near ")": line 1 col 434 (at pos 434)
Operation could not be carried out for
An error occurred when getting data from the processor.
Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION
-----------------------------
An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources.
Nested exception. See inner exception below for more details
sql syntax error: incorrect syntax near "BETWEEN": line 1 col 370 (at pos 370)
Operation could not be carried out for
An error occurred when getting data from the processor.
Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION
-----------------------------
The RSTT trace shows the following entries:
Error in >> Execution of function module BICS_PROV_GET_MEMBERS
sql syntax error: incorrect syntax near ")": line 1 col 434 (at pos 434)
Operation could not be carried out for
An error occurred when getting data from the processor.
CL_SQL_STATEMENT >> Row: Inc: 36 Prog: EXECUTE_QUERY
or
Error in >> Execution of function module BICS_PROV_GET_MEMBERS
sql syntax error: incorrect syntax near "BETWEEN": line 1 col 370 (at pos 370)
Operation could not be carried out for
An error occurred when getting data from the processor.
CL_SQL_STATEMENT >> Row: Inc: 36 Prog: EXECUTE_QUERY
Read more...
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Product
Keywords
error, range, exception, sql, backend, BETWEEN, parentheses , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-F4 , MasterData read services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.