SAP Knowledge Base Article - Public

1927514 - Error: '/CRYSTAL/OSQL_EXECUTE_QUERY', when refreshing a report based off the function "FI_IMPORT_BALANCE_SHEET_TEXT" in Crystal Reports

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

  1. In Crystal Report designer, create a report and select the connect type: "SAP Table, Cluster,or Function"
  2. Logon your SAP System, and select the specific function "FI_IMPORT_BALANCE_SHEET_TEXT"
  3. Click on "OK"
  4. Error appears as "Failed to retrieve data from the database"
  5. 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

Keywords

/CRYSTAL/OSQL_EXECUTE_QUERY, FI_IMPORT_BALANCE_SHEET_TEXT , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016