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

Last updated on OCTOBER 06, 2022

Applies to:

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(Energy Information Platform)
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 the expected or acceptable result? The log file should not contain any error

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.