MQSeries.net :: View topic - Unable to connect to data base with DSN in compute node.

sravan · Posted: Wed Sep 11, 2013 8:32 am Post subject:

We had the DSN configured in and used in MB compute node,the connection is from z OS mainfram ebroker to Oracle data base,I gave DSN details below the error -

Getting below error when a query is ran,Does it indicate a DSN set up issue or wrong query ?-

( ['MQROOT' : 0x2f23a008]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610P/src/DataFlowEngine/ImbComputeNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 464 (INTEGER)
(0x03000000:NameValue):Function = 'ImbComputeNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'RGWTest#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'RGWTest.Compute' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/V610SRV/FP10/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 338 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2393 (INTEGER)
(0x03000000:NameValue):Text = 'Root SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'RPJDBCPROVIDERORA' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/V610SRV/FP10/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 491 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '22024' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-300' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '{DB2 FOR OS/390}{ODBC DRIVER} DSNT408I SQLCODE = -300, ERROR: THE STRING CONTAINED IN HOST VARIABLE OR PARAMETER 1 IS NOT NUL-TERMINATED DSNT418I SQLSTATE = 22024 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRIHB SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -335 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFEB1' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=1:13:2' (CHARACTER)
)
)
)
)
)

RPJDBCPROVIDERORA
connectionUrlFormat='jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]'
connectionUrlFormatAttr1='RSS1S'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='RSW1A'
databaseType='Oracle'
databaseVersion='10'
description='RPOracleDB'
environmentParms='default_none'
jarsURL='/usr/XXXX/qt94brk/oradriver'
portNumber='49126'
securityIdentity='ABC1SID'
serverName='vufdgwut010'
type4DatasourceClassName='oracle.jdbc.xa.client.OracleXADataSource' type4DriverClassName='oracle.jdbc.OracleDriver'
_________________
skr_wmb