Skip to Content
Author's profile photo Charles Reed

Failed to Execute Query: For input string… error encountered when refreshing reports based on SAP BW BEx query

Issue Description

The following error message (or very similar) appears when you attempt to refresh a SAP BusinessObjects report built off a SAP BW BEx query using BICS.

Failed to execute query: ‘java.lang.NumberFormatException: For input string: “2000,0000”’.

The input string will differ based on the environment, but the key to this is that the format is incorrect.  In the above example, the input string value is 2000,0000.  The thousands separator is in the incorrect location, thus throwing the java.lang.NumberFormatException.  I’ve included screenshots of what the error looks like in both Crystal Reports and Web Intelligence.

Crystal Reports

ForInputString Crystal.png

Web Intelligence

ForInputString WebI.png

Web Intelligence throws an error code of WIS 00000, which is pretty generic.

What is Causing This?

This has nothing to do with default values or formulas in the report, so you can stop looking there.  The input string (in our example 2000,0000) is coming from the SAP BW Safety Belt setup. If you are not familiar with the SAP BW Safety Belt, read about it here.  The value 2000,0000 is read from the SAP BW Safety Belt objects stored in the table RSADMIN.  Below is a screenshot from RSADMIN showing the objects and the values.




To resolve this issue, the Safety Belt objects should be corrected to specify the correct, intended values.  KBA1773823 explains how to make the change.

More Information

1773823 – How to resolve error message ‘For input string: “500,0000” (WIS 00000)’ in BI 4.0 Web Intelligence reporting off of SAP BEx query?

1127156 – Safety belt: Result set is too large

SAP BusinessObjects Increasing Stability by Setting Limits on Max. Retrievable Cells from SAP BW into Web Intelligence using BICS

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sri Kandrakota
      Sri Kandrakota

      Thank you Charles,
      This post is very helpful 🙂

      Managed to solve following error

      java.lang.NumberFormatexception:For input string "500000000000":(WIS 00000)