CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

An SQL exception occurred: Data type mismatch. (P#=1).

Hello,

TR -9.2.5.6, AR-9.2, DB2 as400 machine.

I am getting in e1 root logs and multiple logs getting filled in 10mb size and in hole logs below appears…

………………………………………………………………………………………………

26 Dec 2024 10:42:25,405 [SEVERE] - [JVM2][JAS] JDBCProxy.jdbcProxy(): JDBj database operation failed | UserName : 100060, Environment : JPD920, User Role : 499000101 com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Data type mismatch. (P#=1).
26 Dec 2024 10:42:25,406 [SEVERE] - [JVM2][JDBJ] SQLException occured in the SQLPhysicalConnection.select():Auto: | Table or View Name = F1202 - Data Source[0] = Business Data - PROD java.sql.SQLException: Data type mismatch. (P#=1)
26 Dec 2024 10:42:25,406 [SEVERE] - [JVM2][BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Data type mismatch. (P#=1). java.sql.SQLException: Data type mismatch. (P#=1)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center