Jayark: New page: == DB Write is failing with Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred == {| border="1" |- ! '''Problem Summary''' | DB Write is failing with...

2010-05-06T11:41:58Z

New page: == DB Write is failing with Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred == {| border="1" |- ! '''Problem Summary''' | DB Write is failing with...

New page

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

{| border="1"
|-
! '''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'''
|-
|}

[[Category:Unified CCX, Release 7.0]]

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

Jayark: New page: == DB Write is failing with Exception: java.sql.SQLException: No row count was produced ExecuteUpdate Error Occurred == {| border="1" |- ! '''Problem Summary''' | DB Write is failing with...