Symptom
When attempting to extract data from specific SAP Views (such as USER_ADDR or V_USR_NAME) using the SAP ERP connection type, the extraction job fails.
If the underlying RFC_READ_TABLE function module is tested directly in the SAP backend (using transaction SE37) with the exact parameters passed by SAP Signavio Process Intelligence, the following error is observed in the debugger:
-
Exception:
OPTION_NOT_VALID -
System Message (SY-MSGV4):
The parser produced the error: "ORDER BY PRIMARY K "
Data extraction from other views, such as V_ADDR_USR, completes successfully without this error.
Read more...
Environment
-
SAP Signavio Process Intelligence
-
Process Data Management (PDM) Bridge
-
On-premises Package (OPP) / Extractor
-
SAP ERP Connection
-
On-premises SAP ERP system
Product
Keywords
soe, PDM, PDM Bridge, RFC Connection, Extractor, CData JDBC, SAP ERP, RFC_READ_TABLE, OPTION_NOT_VALID, ORDER BY PRIMARY KEY, GET_SORTED, Extra Connection Argument, SE37, USER_ADDR, V_USR_NAME , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview