ITM Adapter Startup: Error Occurred In Poller Java.lang.NumberFormatException: Null (Doc ID 2266282.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, ITM Adapter

When attempting to run ITM Adapter concurrent job the following error occurs.

This below errors can be found in two places:
1) ITMSTARTUP: Adapter Startup log file
2) Thread log file : threadmain-5-15-2017.log


---- Mon May 15 08:50:25 EDT 2017 ----
129 POLLER (ERROR) Error Occurred in Poller java.lang.NumberFormatException: null
---- Mon May 15 08:50:25 EDT 2017 ----
129 POLLER (ERROR) Poller terminated due to the error java.lang.NumberFormatException: null
129 main (INFO) Poller Exited, Shutting down Thread Pool ...
129 main (INFO) Poller Exited, Shutting down Thread Pool ...
129 main (INFO) About to stop Thread Pool
7235 main (DEBUG) In the method AppsConnection.getConnectionFromPool of Apps Manager
7236 main (DEBUG) Fetched Session ID: 0x1ca3dcb
7236 main (INFO) Updating the Adapter status to Inactive
7239 main (DEBUG) In the method AppsConnection.freeConnection
7239 main (DEBUG) Freeing Session ID: 0x1ca3dcb
7239 main (DEBUG) Returned connection to pool
7239 main (INFO) Normal Shutdown of Adapter
*************************************************************
...The log will also show the parameter WSH_ITM_LOG_SEVERITY is Null (0)

WSH_ITM_MIN_NO_THREADS = 2
WSH_ITM_MAX_NO_THREADS = 5
WSH_ITM_THREAD_MAX_IDLE_TIME = 100000
WSH_ITM_QUEUE_POLL_INTERVAL = 7000
WSH_ITM_MAX_RESUBMITS = 2
WSH_ITM_LOG_SEVERITY = 0
ITM_DB_CODEPAGE = UTF8
WSH_ITM_INTG_GTM = TRUE


Restarting the ITM Adapter does not help and the records are NOT processing.
The process_flag of the stuck records is -1 (Request picked up by the ITM Adapter Poller.)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms