DB Write is failing with Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred

From DocWiki

Jump to: navigation, search

DB Write is failing with Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred

Problem Summary DB Write is failing with the following Exception in the MIVR log.

Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred 1059786: May 04 07:34:10.308 EDT %MIVR-SS_DB-3-EXECUTE_SQL_UPDATE_EXCEPTION:Exception occurred while executing SQL Update: SQL State=null,SQL Error code=null,Connection #=null


Error Message "java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred"
Possible Cause DB Read and DB Write does not support executing triggers and stored procedures as part of the query. The return value expected is the number of rows affected by the query. If the DB Write query trying to do some operation and trying to return some value, it will fail with the above Exception in the MIVR log.
Recommended Action Modify the DB Read and DB Write steps and make sure that it returns the number of rows affected by the query. Stored Procedures are not supported as part of the query.
Release Release 7.0, Release 5.0
Associated CDETS # None

Rating: 0.0/5 (0 votes cast)

Personal tools