E1: GRID: Unable to Save Grid Formats (User Overrides) in Web Client (Doc ID 650138.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

In Web Client, when a user creates a new override using the customize grid function, the newly created grid format is available to the user, and appears in the "Customize grid" drop-down list but the customized grid format disappears after the user exits the application and executes the application again or after the user logs off and back on to the software. The new grid format is not saved in the User Override table F98950.

The user found the following errors in the JAS.LOG:

"SQLException occurred in the SQLPhysicalConnection.insert(): | Vendor code = 17068"
"JDBj database operation failed"


Example:

SQLException occurred in the SQLPhysicalConnection.insert(): | Vendor code = 17068, SQL state = null | Table or View Name = F98950 | Data Source = Central Objects - PY811
java.sql.SQLException: Invalid argument(s) in call
java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:269)
at oracle.sql.BLOB.createTemporary(BLOB.javANSWER:765)
........

JDBCProxy.jdbcProxy(): JDBj database operation failed | UserName : PSFT, Environment : JPY811, User Role : *ALL com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Invalid argument(s) in call.
java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.javANSWER:269)
at oracle.sql.BLOB.createTemporary(BLOB.javANSWER:765)
......

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