| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Intermittent errors updating SQL Servers |
« View previous topic :: View next topic » |
| Author |
Message
|
| dean |
 Posted: Thu Sep 03, 2009 2:48 am Post subject: Intermittent errors updating SQL Servers |
 |
|
Novice
Joined: 29 May 2009
Posts: 15
|
I am seeing intermittent errors when executing stored procedures against SQL Servers from within ESQL. Below are two of the exception lists showing SQLSTATE 20122 and at different times "Timeout Expired".
Is anyone else having issues with SQL Server? Has anyone else ran into this. We are on WMB6 on Red Hat Linux x64 and using SQL Server 2000.
*************************************************************************************
Date is: 9/2/2009
Time is: 16:43
Environment is:
( ['MQROOT' : 0x1d157ac0]
(0x01000000:Name):variables = (
(0x03000000:NameValue):DB = '' (CHARACTER)
(0x03000000:NameValue):SQLCodeX = -1 (INTEGER)
(0x03000000:NameValue):SQLState1 = '20122' (CHARACTER)
(0x03000000:NameValue):SQLErrorText1 = '[IBM][ODBC SQL Server Driver]20122' (CHARACTER)
(0x03000000:NameValue):SQLNativeError1 = 0 (INTEGER)
(0x03000000:NameValue):Meter_Station = 9685 (INTEGER)
(0x03000000:NameValue):Meter = 2 (INTEGER)
)
)
Exception List is:
Root is:
( ['MQROOT' : 0x2aaae0148fa0]
(0x01000000:Name ):Properties = ( ['MQPROPERTYPARSER' : 0x2aaae0033b60]
(0x03000000:NameValue):MessageSet = 'rm_0' (CHARACTER)
(0x03000000:NameValue):MessageType = '{}:rm_5' (CHARACTER)
(0x03000000:NameValue):MessageFormat = 'Binary1' (CHARACTER)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Transactional = TRUE (BOOLEAN)
(0x03000000:NameValue):Persistence = FALSE (BOOLEAN)
(0x03000000:NameValue):CreationTime = GMTTIMESTAMP '2009-09-02 02:38:28.900' (GMTTIMESTAMP)
(0x03000000:NameValue):ExpirationTime = -1 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):ReplyIdentifier = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):ReplyProtocol = 'MQ' (CHARACTER)
(0x03000000:NameValue):Topic = 'MEAS/SAG_Springfield/009685A/rm.5' (CHARACTER)
(0x03000000:NameValue):ContentType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceToken = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedType = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedToken = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
)
(0x01000000:Name ):MQMD = ( ['MQHMD' : 0x2aaae0026af0]
(0x03000000:NameValue):SourceQueue = 'SCADA.SEND.TO.DEV.IN' (CHARACTER)
(0x03000000:NameValue):Transactional = TRUE (BOOLEAN)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Format = 'MQHRF2 ' (CHARACTER)
(0x03000000:NameValue):Version = 2 (INTEGER)
(0x03000000:NameValue):Report = 0 (INTEGER)
(0x03000000:NameValue):MsgType = 8 (INTEGER)
(0x03000000:NameValue):Expiry = -1 (INTEGER)
(0x03000000:NameValue):Feedback = 0 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):Persistence = 0 (INTEGER)
(0x03000000:NameValue):MsgId = X'414d5120504430312020202020202020776d8d4a637d0420' (BLOB)
(0x03000000:NameValue):CorrelId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):BackoutCount = 0 (INTEGER)
(0x03000000:NameValue):ReplyToQ = ' ' (CHARACTER)
(0x03000000:NameValue):ReplyToQMgr = 'PD01 ' (CHARACTER)
(0x03000000:NameValue):UserIdentifier = 'wmq ' (CHARACTER)
(0x03000000:NameValue):AccountingToken = X'0335303300000000000000000000000000000000000000000000000000000006' (BLOB)
(0x03000000:NameValue):ApplIdentityData = ' ' (CHARACTER)
(0x03000000:NameValue):PutApplType = 6 (INTEGER)
(0x03000000:NameValue):PutApplName = 'DataFlowEngine ' (CHARACTER)
(0x03000000:NameValue):PutDate = DATE '2009-09-02' (DATE)
(0x03000000:NameValue):PutTime = GMTTIME '02:38:28.900' (GMTTIME)
(0x03000000:NameValue):ApplOriginData = ' ' (CHARACTER)
(0x03000000:NameValue):GroupId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):MsgSeqNumber = 1 (INTEGER)
(0x03000000:NameValue):Offset = 0 (INTEGER)
(0x03000000:NameValue):MsgFlags = 0 (INTEGER)
(0x03000000:NameValue):OriginalLength = -1 (INTEGER)
)
(0x01000000:Name ):MQRFH2 = ( ['MQHRF2' : 0x2aaae00953b0]
(0x03000000:NameValue):Version = 2 (INTEGER)
(0x03000000:NameValue):Format = ' ' (CHARACTER)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Flags = 0 (INTEGER)
(0x03000000:NameValue):NameValueCCSID = 1208 (INTEGER)
(0x01000000:Name ):psc = (
(0x01000000:Name):Command = (
(0x02000000:Value): = 'Publish' (CHARACTER)
)
(0x01000000:Name):QoS = (
(0x02000000:Value): = '0' (CHARACTER)
)
(0x01000000:Name):PubClientId = (
(0x02000000:Value): = 'Dean' (CHARACTER)
)
(0x01000000:Name):PubMsgId = (
(0x02000000:Value): = '0' (CHARACTER)
)
(0x01000000:Name):Topic = (
(0x02000000:Value): = 'MEAS/SAG_Springfield/009685A/rm.5' (CHARACTER)
)
)
(0x01000000:Name ):mcd = (
(0x01000000:Name):Msd = (
(0x02000000:Value): = 'mrm' (CHARACTER)
)
(0x01000000:Name):Set = (
(0x02000000:Value): = 'rm_0' (CHARACTER)
)
(0x01000000:Name):Type = (
(0x02000000:Value): = '{}:rm_5' (CHARACTER)
)
(0x01000000:Name):Fmt = (
(0x02000000:Value): = 'Binary1' (CHARACTER)
)
)
)
(0x01000021:Name+):MRM = ( ['mrm' : 0x2aaae00585a0]
(0x0300000B:NameValue+):second = 4 (INTEGER)
(0x0300000B:NameValue+):minute = 59 (INTEGER)
(0x0300000B:NameValue+):hour = 18 (INTEGER)
(0x0300000B:NameValue+):day = 1 (INTEGER)
(0x0300000B:NameValue+):month = 9 (INTEGER)
(0x0300000B:NameValue+):year = 9 (INTEGER)
(0x0300000B:NameValue+):DiffPressure = -3.11763379722834E-2 (FLOAT)
(0x0300000B:NameValue+):StaticPressure = 1.07623916625977E+2 (FLOAT)
(0x0300000B:NameValue+):Temperature = 8.43448028564453E+1 (FLOAT)
(0x0300000B:NameValue+):realmcf = 0E+0 (FLOAT)
(0x0300000B:NameValue+):reason = 0 (INTEGER)
)
)
*************************************************************************************^M
Date is: 9/2/2009^M
Time is: 10:59^M
Environment is:^M
( ['MQROOT' : 0x2595990]
(0x01000000:Name):variables = (
(0x03000000:NameValue):DB = 'BCCDSWB1' (CHARACTER)
)
)^M
Exception List is:^M
( ['MQROOT' : 0x2595410]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 464 (INTEGER)
(0x03000000:NameValue):Function = 'ImbComputeNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'Main_Measurement_flow#FCMComposite_1_5.Route_To_Database_sublfow#FCMComposite_1_8.gh5_subFlow#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'Main_Measurement_flow.Route_To_Database_sublfow.gh5_subflow.gh5_subflow_Compute_SQL' (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 ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 581 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'Main_Measurement_flow#FCMComposite_1_5.Route_To_Database_sublfow#FCMComposite_1_8.gh5_subFlow#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'Main_Measurement_flow.Route_To_Database_sublfow.gh5_subflow.gh5_subflow_Compute_SQL' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.gh5_subFlow_Compute_SQL.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '46.4' (CHARACTER)
)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'gh5usp(meternum, InputRoot.MRM.run, InputRoot.MRM.flags, InputRoot.MRM.DiffPressure, InputRoot.MRM.StaticPressure, InputRoot.MRM.Temperature, InputRoot.MRM.flowrate, InputRoot.MRM.enrate, InputRoot.MRM.mcf, InputRoot.MRM.dth, InputRoot.MRM.nonmcf, InputRoot.MRM.nondth, InputRoot.MRM.ai1, InputRoot.MRM.ai2, InputRoot.MRM.ai3, InputRoot.MRM.month, InputRoot.MRM.day, InputRoot.MRM.year, InputRoot.MRM.hour, InputRoot.MRM.minute, InputRoot.MRM.second, GMSTIME, GMSTIME, GMSTIME, offset, dstoff, meterId, devicetype, InputRoot.MRM.battery) IN Database.{DB}.dbo;' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 330 (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 = 'BCCDSWB1' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 446 (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 = 'HYT00' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '0' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC SQL Server Driver][libssclient23]Timeout Expired.' (CHARACTER)
)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 446 (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 = 'IM006' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '0' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed' (CHARACTER)
)
)
)
)
)
) |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Sep 03, 2009 3:27 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
I'd suspect one or both of the following
- Network loading issues
- Performance problems on the System running SQL Server.
As it is intermittent, it may be a problem to track down.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| dean |
| Posted: Thu Sep 03, 2009 4:48 am Post subject: |
|
|
Novice
Joined: 29 May 2009
Posts: 15
|
Are there WMB or ODBC settings that will compensate if it is a load issue?
Where can I find documentation on these type of errors?
Thanks for the response. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
