Errors In Logs: Format Error Of Table.column (Doc ID 1669051.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Utilities Transaction Management - Version 1.6.1.13 and later
Information in this document applies to any platform.

Symptoms

The loss of functionality: An error is displayed on the Lodestar log file
The sequence of events: Data (Menu) -> OV Connection Register -> Use the search field 'Year Month Combination' -> Search. The search will go fine and you get results but in the logs the error will be added for each result (each record).
Where it happened: The error occurs from EIP
The significance of loss / cusotmer impact: The TM search facility doesn't work
Include specific error messages (error number with syntax): Format error of table.column = 'GTCONNREG.YEARMONTH' with value = '2013-06'. Error: Type mismatch.
What IS working; Other TM functionalities are not impacted
What is the expected or acceptable result? The log file should not contain any error
What about the system has recently changed? Nothing

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