Failed to Execute Query: For input string… error encountered when refreshing reports based on SAP BW BEx query
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.
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.
BW Table RSADMIN
To resolve this issue, the Safety Belt objects should be corrected to specify the correct, intended values. KBA1773823 explains how to make the change.
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