PH57651: RESULT DATABASE - COM.GHC.JDBC.ORACLE.ORACLETABLEUTILS SAVELOB FAILED TO INSERT BLOB

APAR status

• Closed as program error.

Error description

• Environment Detailsl
  ---------------------
  Db - Oracle 19c
  RIT 10.5.3
  
  
  Customer is noticing the following SEVERE level errors in both
  RIT-Agent as RIT-Engine logs of RIT Tests using a RIT project
  with an Oracle Database as Result Database.
  
  
  RIT-Agent0-0.log: [03/10/2023, 16:27:52.152] INFO
  com.greenhat.agent.Agent com.greenhat.agent.Agent
  startApplicationProcess RunTests/instance1 (1046) launching as
  /opt/IBM/RIT-Agent/RunTests -noHTTP -project
  /var/rtvs/ita/2321819745306226939/engines/1046/ProjectFiles/RIT-
  DEMO.ghp -domain RIT -environment -2006737f:1773e9bd055:-7b74
  -agentId 8dab996e-ec14-454e-984d-129b1836aed0 -instanceName
  instance1 -instanceUUID 17359c41-79f4-47bd-9ae5-03e84a0d1e5b
  -projectString test5178518795443578091 -overrideSlowFail
  SCENARIO -controlledBy tcp://127.0.0.1:37881/?spawnId=1046 -run
  -2006737f:17743f22660:-69dd -data
  /var/rtvs/ita/2321819745306226939/engines/1046/workspace
  -configuration
  /var/rtvs/ita/2321819745306226939/engines/1046/configuration
  -ghServerURL https://lste006278.eu.rabonet.com:5443/RTCP/
  --launcher.appendVmargs -vmargs
  -Djava.io.tmpdir=/var/rtvs/ita/2321819745306226939/engines/1046/
  tmp
  -Djava.util.logging.config.file=/opt/IBM/RIT-Agent/agent-logging
  .properties -Dagent.spawned=true -DHSV_METRIC_ALIAS_launch=rtcp
  -DHSV_METRIC_ALIAS_domain=RIT
  -DHSV_METRIC_ALIAS_env=-2006737f:1773e9bd055:-7b74
  [RunTests/instance1 (1046)]: [RunTests/instance1 (1046)]:
  Operating system process id for engine is 3381755
  [RunTests/instance1 (1046)]:
  
  Engine logs are being written to directory
  /opt/IBM/RIT-Agent/logs [RunTests/instance1 (1046)]:
  [03/10/2023, 16:27:59.810] SEVERE
  com.ghc.jdbc.oracle.OracleTableUtils
  com.ghc.jdbc.oracle.OracleTableUtils saveLob Failed to insert
  BLOB. [RunTests/instance1 (1046)]: [03/10/2023, 16:27:59.818]
  SEVERE com.ghc.jdbc.oracle.OracleTableUtils
  com.ghc.jdbc.oracle.OracleTableUtils saveLob Failed to insert
  BLOB. [RunTests/instance1 (1046)]: [03/10/2023, 16:27:59.832]
  SEVERE com.ghc.jdbc.oracle.OracleTableUtils
  com.ghc.jdbc.oracle.OracleTableUtils saveLob Failed to insert
  BLOB. RIT-Enginexxx-0.log [03/10/2023, 16:27:59.795] INFO
  com.ghc.ghTester.commandline.CmdLineConsole
  com.ghc.ghTester.commandline.CmdLineConsole displayLog
  [10/03/2023, 4:27:59.794 PM] Stubs started [03/10/2023,
  16:27:59.810] SEVERE com.ghc.jdbc.oracle.OracleTableUtils
  com.ghc.jdbc.oracle.OracleTableUtils saveLob Failed to insert
  BLOB. [03/10/2023, 16:27:59.817] INFO
  com.ghc.schema.StaticSchemaProvider
  com.ghc.schema.refresh.SchemaRefreshJob$Builder X_run Refreshing
  Schema:Text [03/10/2023, 16:27:59.818] SEVERE
  com.ghc.jdbc.oracle.OracleTableUtils
  com.ghc.jdbc.oracle.OracleTableUtils saveLob Failed to insert
  BLOB. [03/10/2023, 16:27:59.825] INFO
  com.ghc.schema.StaticSchemaProvider
  com.ghc.schema.refresh.SchemaRefreshJob$Builder X_run Schema
  refreshed.
  
  
  
  Work around:
  -------------
  Add the following flag within the IntegrationTester.ini and
  RunTests.ini file
  
  -Doracle.jdbc.autoCommitSpecCompliant=false
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users capturing test results to an Oracle results database.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Previously, when you used an Oracle Database as the Result   *
  * Database in your project, you might have observed errors     *
  * with the SEVERE level logged in the Test Integrations and    *
  * APIs-Engine logs. This might be due to the change in the     *
  * version of the database drivers.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The driver version has been updated and the errors no longer
  appear in the logs.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL INTEGRA TE

• Fixed component ID

  5725G79IT

Applicable component levels