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