Question

3
Replies
263
Views
Close popover
Siripuram Mahesh (MAHI252385)
Infosys
Consultant
Infosys
IN
MAHI252385 Member since 2010 21 posts
Infosys
Posted: August 2, 2017
Last activity: August 18, 2017
Closed

Transaction resume failure - Connect-SQL method( The server failed to resume the transaction. Desc:4700000001)

we are getting transaction failure message when we call external Data base Storedprocedure. I have provided the error we capture from SP in below and this issue is not getting from SQL managment studio. We are using one integrated windows account to execute external DB from TomCat. This account have execute permissions.

Calling SP is querying internally some external Databases. So i have given permissions to that DBs also.

Error Details:

NGAWLR-51 Encountered SQL Error
pxRDBError = There was a problem performing a database query: Problem retrieving database information for database ngabfd: code: 3971 SQLState: S0001 Message: The server failed to resume the transaction. Desc:4700000001.
pxRDBSQLCode = S0001
pxRDBSQLVendorError1 = 3971
pxRDBSQLVendorError2 =
pxRDBSQLVendorMessage1 = The server failed to resume the transaction. Desc:4700000001.
pxRDBSQLVendorMessage2 =
pxSQLStatementPre = {SQLPage:MySqlErrorsPage} \{ Call dbo.GetAgentDomainInpCLI( {.CLI}, {.ProductID} ) \}
pxSQLStatementPost = { Call dbo.GetAgentDomainInpCLI( ?, ? ) }

Please let us know if any one have idea on this issue or any suggestions.

Data Integration
Moderation Team has archived post