Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interface not running: ORA-01722: invalid number

424400Jul 31 2007 — edited May 26 2010

Hi,

I have migrated my ODI master&work repositories from my development-machine to my local laptop and now I get this error when executing one of my Interfaces:
ORA-01722 Invalid number (I translated this because I get this error in Dutch!!).

On my development-machine, I do not get this error, and IF I get errors, I get them in English (which I prefer).

So, my questions are:
1) how do I change my errors on my local machine from Dutch to English?
does that depend on the database? or on java? or on ....?

2) can I make changes in ODI to get this Interface running?

Thanks in advance!
Steffen

ps. I already tried
a) to set in 'odiparams.bat'
ODI_ADDITIONAL_JAVA_OPTIONS='-Duser.language=en -Duser.country=US"
but this didn't help...

and
b: set my Oracle database run in AMERICAN_AMERICA.
set my Locale Settings to English [US]
.. still no luck.. ;-((

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2010

Added on Jul 31 2007

#business-intelligence-applications, #data-integrator, #system-management-and-integration

13 comments

3,434 views