Error on SQL command on the SAP MII after new installation - ORA-01722: invalid number

[Former Member]

Hi Dear,

Here on the company we have two MII machines, one of them was installed on last week. We have the same application on both, the more old is working fine, but in the other machine the SQL queries are returning the error:

"com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: java.sql.SQLException: ORA-01722: invalid number"

The SQL commands that we are using is sending a parameter between quotes, for exemplo: '98.6598'. But on the new environment this command is not working.

We already checked the internationalization server config, the same on both, the JVM too.

Anybody help me?

Thanks

Thiago Alves

[Former Member]

Make sure the parameter is actually being populated with data before the SQL statement is executed.

Also try and execute the SQL through an SQL tool like SQL developer from oracle or SQL Plus. This will validate your SQL query is valid.

The quotes shouldn't matter Oracle should try and parse the string into a number if it's expecting a number. But removing the quotes wouldn't hurt and it would save some CPU cycles.

[agentry_src]

Please try it without the quotes.  In general, you should not need the quotes when you have numbers as the Values.

Regards, Mike