Visitor.. jtodd1
Visitor..
312 views

OO 10.80 SQLException in logs

Hi

 We are seeing an error in the general.log and server.log on our OO 10.80 instances:

 2018-05-14 18:01:00,178 [local-scheduler-persisted_Worker-8] (TransactionAspectSupport.java:506) ERROR - Application exception overridden by rollback exception org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SELECT DISTINCT EXEC_STATE_ID FROM OO_EXECUTION_QUERIES WHERE          (STATUS = 7) OR            (STATUS = 😎 OR           (STATUS = 6)    ]; SQL state [99999]; error code [17412]; Bigger type length than Maximum; nested exception is java.sql.SQLException: Bigger type length than Maximum

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate (AbstractFallbackSQLExceptionTranslator.java:84)

....

 This SQL exception is occurring every minute and is filling up the logs.  We are not seeing any actual issues within the application itself.

 We are connected to an ORACLE RAC database using a servicename.  The two Central Servers we have are Redhat machines, if this information assists at all.

 Thanks

0 Likes
3 Replies
Outstanding Contributor.. csaunderson Outstanding Contributor..
Outstanding Contributor..

Re: OO 10.80 SQLException in logs

I took at peek at our 10.80 centrals, granted we're on Windows, and I don't see those errors being thrown. We're also connecting to an 11.2.0.4 RAC instance for all of our clusters, so I'd expect to see it in our logs somewhere.

 

A quick search seemed to indicate an Oracle driver mismatch: not sure quite where to look, I'm guessing that you're using 12c on... you know what, no guesses. What Oracle version on what OS are you running?

 

--Chris

0 Likes
Visitor.. jtodd1
Visitor..

Re: OO 10.80 SQLException in logs

Hi Chris

We are using Redhat 7.2 for the Central machines and Oracle RAC 11g R2.  The JDBC driver we are using is the OJDBC6.jar which can be found on the ORACLE website and is the suggested jdbc driver for use with 11g R2.

Thanks

Joseph

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: OO 10.80 SQLException in logs

Hi Joseph,

In OO before the change required to exclude  the JDBC drvier for Oracle we used ojdbc7-12.1.0.2 driver (ojdbc 7) for all versions of Oracle supported without any side efects for both 11gr2 and 12c. Change your driver to this one and see if the errors persist. Note you will have to update the driver in both central\lib folder and in tomcat\lib folder.  A safe way to replace it everywhere it needs to be replaced is locating it in the central/lib folder and then searching for that name in the entire OO folder.

Hope this helps,

Vlad

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.