| Author |
Message |
Krijn Michiels
Guest
|
 Posted:
Tue May 03, 2005 8:51 am Post subject:
msdb2Exception and job info |
|
|
Hi,
The msdb2Exception does not return full error information.
Trying to save an invalid record by using a foreign key constraint the
msdb2Exception only contains :
"A SQL error has occurred. Please consult the documentation for your
specific DB2 version for a description of the associated Native Error and SQL
State. SQLSTATE: 23503, SQLCODE: -530".
There is no key information returned (type of key, the name of the key).
Is there a good way to get the full job message from AS400 ? |
|
| Back to top |
|
 |
Jeff Derstadt [MSFT]
Guest
|
| Posted:
Thu May 12, 2005 9:59 pm Post subject:
RE: msdb2Exception and job info |
|
|
You can look in the HIS traces to find the tokens that go along with the
error 23503/-530. You turn traces on by using the "SNA Trace Utility" and
then enabling all of the trace checkboxes for "DB2 Network Library". Once
your application has run, look in the "DB2MSG1.ATF" trace file for a SQLCA
message. You can see the "Descriptors" in there.
Jeff Derstadt
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: msdb2Exception and job info
thread-index: AcVPqvBo1kiErO8fQFilkMzuv1749g==
X-WBNR-Posting-Host: 195.95.34.7
From: "=?Utf-8?B?S3Jpam4gTWljaGllbHM=?="
<KrijnMichiels@discussions.microsoft.com>
Subject: msdb2Exception and job info
Date: Mon, 2 May 2005 23:40:04 -0700
Lines: 11
Message-ID: <BFA1BD65-2FB6-4F1F-98A3-9A43004AC163@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.hiserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.hiserver.general:1628
X-Tomcat-NG: microsoft.public.hiserver.general
Hi,
The msdb2Exception does not return full error information.
Trying to save an invalid record by using a foreign key constraint the
msdb2Exception only contains :
"A SQL error has occurred. Please consult the documentation for your
specific DB2 version for a description of the associated Native Error and
SQL
State. SQLSTATE: 23503, SQLCODE: -530".
There is no key information returned (type of key, the name of the key).
Is there a good way to get the full job message from AS400 ? |
|
| Back to top |
|
|
Krijn Michiels
Guest
|
| Posted:
Fri May 13, 2005 4:53 pm Post subject:
RE: msdb2Exception and job info |
|
|
I was more thinking of creating a FKmessage table wich would contain of two
columns foreign key name and message. If I could grab the foreign key name
wich was throwing the exception I could place a message from the FKmessage
table in the DataRow.RowError. It would work, if I had the name ..
The tracing is only usefull in development and I'm not going to enable it on
a runtime HIS.
Is there a good way to connect with the AS400 messaging system ? Get the
current job log ?
"Jeff Derstadt [MSFT]" wrote:
| Quote: | You can look in the HIS traces to find the tokens that go along with the
error 23503/-530. You turn traces on by using the "SNA Trace Utility" and
then enabling all of the trace checkboxes for "DB2 Network Library". Once
your application has run, look in the "DB2MSG1.ATF" trace file for a SQLCA
message. You can see the "Descriptors" in there.
Jeff Derstadt
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: msdb2Exception and job info
thread-index: AcVPqvBo1kiErO8fQFilkMzuv1749g==
X-WBNR-Posting-Host: 195.95.34.7
From: "=?Utf-8?B?S3Jpam4gTWljaGllbHM=?="
KrijnMichiels@discussions.microsoft.com
Subject: msdb2Exception and job info
Date: Mon, 2 May 2005 23:40:04 -0700
Lines: 11
Message-ID: <BFA1BD65-2FB6-4F1F-98A3-9A43004AC163@microsoft.com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.hiserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.hiserver.general:1628
X-Tomcat-NG: microsoft.public.hiserver.general
Hi,
The msdb2Exception does not return full error information.
Trying to save an invalid record by using a foreign key constraint the
msdb2Exception only contains :
"A SQL error has occurred. Please consult the documentation for your
specific DB2 version for a description of the associated Native Error and
SQL
State. SQLSTATE: 23503, SQLCODE: -530".
There is no key information returned (type of key, the name of the key).
Is there a good way to get the full job message from AS400 ?
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in