Symptom
- Error "Failed to retrieve data from the database"
- Error "Crystal/OSQL_EXECUTE_QUERY returned: subrc:4 . Message: type "%S" is unknown. Line:4. Word:0"
- When refreshing reports based off SAP function "FI_IMPORT_BALANCE_SHEET_TEXT" with connection "SAP Table, Cluster,or Function", it generates an error:
"Database Connector error: "Crystal/OSQL_EXECUTE_QUERY returned: subrc:4 . Message: type "%S" is unknown. Line:4. Word:0"
Environment
- SAP Crystal Reports 2011
Reproducing the Issue
- In Crystal Report designer, create a report and select the connect type: "SAP Table, Cluster,or Function"
- Logon your SAP System, and select the specific function "FI_IMPORT_BALANCE_SHEET_TEXT"
- Click on "OK"
- Error appears as "Failed to retrieve data from the database"
- Clicking on "OK" return the error:
"Database Connector error: "Crystal/OSQL_EXECUTE_QUERY returned: subrc:4 . Message: type "%S" is unknown. Line:4. Word:0"
Resolution
- Load the SAP Integration Kit Transports corresponsing to the exact version of Crystal Reports used to the SAP System.
- To verify the version of the SAP Integration Kit Transports loaded on your SAP System, see the SAP Knowledge Base Articles:
Keywords
/CRYSTAL/OSQL_EXECUTE_QUERY, FI_IMPORT_BALANCE_SHEET_TEXT , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016