Invoking Impact Analysis ERRORCODE=-4496

Article Id: 50261

Status: Published

Updated On: 21-03-2018 06:12

Legacy Id: TEC552075

Products:

CA Repository

Issue/Introduction:

Description:

If you are running CA Repository for z/OS WebStation Option r7.2 in a Websphere Application Server environment, and using a 'XA' Data Source connection, any attempt to click on the Impact Analysis Icon for any given row in a result set will produce the following error:

com.ibm.db2.jcc.am.SqlException: An SQL OPEN for a held cursor was issued on a XA connection ERRORCODE=-4496, SQLSTATE=null

Note:
This does not apply to Tomcat and JBOSS Application Server environments

Solution:

IBM has a solution for this error when using a 'XA' DataSource connection with your application(s) defined within Websphere.

Please refer to the following url.
https://www-304.ibm.com/support/docview.wss?uid=swg21386486
The alternative is to revert to a 'connection pooled' datasource where the error does not occur.

Environment:

Release:
Component: XWSO