KB Article #178307
Container deployment throws this: [JDB - 18001]: ORA-01843: not a valid month [JDX - 17023]: Execute Query failed [JDX - 17038]: Select statement has failed [MON - 1018]: Error during JDBC MapBroker
Problem
After installing Integrator 3.7.3 SP5, a container deployment in disconnected mode throws an error on an SQL query:
[JDB - 18001]: ORA-01843: not a valid month
[JDX - 17023]: Execute Query failed
[JDX - 17038]: Select statement has failed
[MON - 1018]: Error during JDBC MapBroker (path\path) execution
Mapbroker execution failed (general failure)
Collecting mapbroker output instances...
Finished: 0 output instance(s) collected.
Finished processing mapbroker path\path: returned 1
Done: propagating failure
Finished processing mapbroker path\path : returned 1
MON_ProcessMapBroker() returned 1
Resolution
Try on Integrator 3.7 environment:
- run Integrator profiles script
- execute commands:
---
java -XshowSettings:properties 2>&1 | findstr user.country
java -XshowSettings:properties 2>&1 | findstr user.language
---
- if the above commands do not display something like "fr" then it should add in CORE_ROOT/config/java/jvm.cfg the following lines:
---
ALL:Replace= -Duser.language=fr
ALL:Replace= -Duser.country=fr