Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
duplicate object dependency
71 views
Skip to first unread message
Gregor Kovač
Sep 28, 2015, 7:28:39 PM9/28/15
to
Hi!
I'm using DB2 Express-C 10.5.5 on Linux, 32-bit.
When I try to build a procedure or a trigger on one of the tables I get:
The SQL statement or command failed because of a database system error. (Reason "duplicate object dependency".). SQLCODE=-901, SQLSTATE=58004, DRIVER=4.18.60
What does that mean? Searching Google and IBM.com didn't get me anywhere.
Best regards,
Kovi
I'm using DB2 Express-C 10.5.5 on Linux, 32-bit.
When I try to build a procedure or a trigger on one of the tables I get:
The SQL statement or command failed because of a database system error. (Reason "duplicate object dependency".). SQLCODE=-901, SQLSTATE=58004, DRIVER=4.18.60
What does that mean? Searching Google and IBM.com didn't get me anywhere.
Best regards,
Kovi
Gregor Kovač
Sep 29, 2015, 6:34:17 AM9/29/15
to
Dne torek, 29. september 2015 01.28.39 UTC+2 je oseba Gregor Kovač napisala:
I solved the problem, but still don't know what this error means.
How I solved the problem? I commented out block of code in the procedure I tried to compile. When the procedure compiled I knew the table. Then I dropped the table and recreated it. This solved the problem.
How I solved the problem? I commented out block of code in the procedure I tried to compile. When the procedure compiled I knew the table. Then I dropped the table and recreated it. This solved the problem.
CRPence
Sep 29, 2015, 11:02:38 AM9/29/15
to
On 29-Sep-2015 04:34 -0600, Gregor Kovač wrote:
> 29-sep-2015 01.28.39 UTC+2 je oseba Gregor Kovač napisala:
which there is no specific SQLCODE and SQLSTATE to diagnose the error,
and may be indicative of a coding error in the SQL feature for which a
fix may be required to be preventive or corrective to the condition that
gives rise to the error; i.e. the "System Error" SQLstate Class Code of
58
[https://www-304.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/db2z_sqlstatevalues.dita]
Presumably the replacement text for the "Reason" was chosen by the
developers of the SQL feature to help them identify where is the origin
for, or more specifically what is, the condition being diagnosed. Thus
the specific error is being described only in\with the code, rather than
being described by any external documentation. Presumably, until the
issue is reported to the software service provider [either directly or
eventually to IBM] for which a PMR is opened with IBM, and then an APAR
opened and closed against the issue, the above message may remain the
only incident capable of being searched on the web with
[https://www.google.com/search?&q=%22sqlstate%22+%2258004%22+%22duplicate+object+dependency%22];
oddly, that topic was not found presently with that search.
--
Regards, Chuck
> 29-sep-2015 01.28.39 UTC+2 je oseba Gregor Kovač napisala:
>>
>> I'm using DB2 Express-C 10.5.5 on Linux, 32-bit.
>>
>> When I try to build a procedure or a trigger on one of the tables I
>> get: The SQL statement or command failed because of a database
>> system error. (Reason "duplicate object dependency".).
>> SQLCODE=-901, SQLSTATE=58004, DRIVER=4.18.60
>>
>> What does that mean? Searching Google and IBM.com didn't get me
>> anywhere.
>>
>
>> I'm using DB2 Express-C 10.5.5 on Linux, 32-bit.
>>
>> When I try to build a procedure or a trigger on one of the tables I
>> get: The SQL statement or command failed because of a database
>> system error. (Reason "duplicate object dependency".).
>> SQLCODE=-901, SQLSTATE=58004, DRIVER=4.18.60
>>
>> What does that mean? Searching Google and IBM.com didn't get me
>> anywhere.
>>
>
> I solved the problem, but still don't know what this error means.
> How I solved the problem? I commented out block of code in the
> procedure I tried to compile. When the procedure compiled I knew the
> table. Then I dropped the table and recreated it. This solved the
> problem.
AIUI that SQLSTATE means the SQL feature has encountered an error for
> How I solved the problem? I commented out block of code in the
> procedure I tried to compile. When the procedure compiled I knew the
> table. Then I dropped the table and recreated it. This solved the
> problem.
which there is no specific SQLCODE and SQLSTATE to diagnose the error,
and may be indicative of a coding error in the SQL feature for which a
fix may be required to be preventive or corrective to the condition that
gives rise to the error; i.e. the "System Error" SQLstate Class Code of
58
[https://www-304.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/db2z_sqlstatevalues.dita]
Presumably the replacement text for the "Reason" was chosen by the
developers of the SQL feature to help them identify where is the origin
for, or more specifically what is, the condition being diagnosed. Thus
the specific error is being described only in\with the code, rather than
being described by any external documentation. Presumably, until the
issue is reported to the software service provider [either directly or
eventually to IBM] for which a PMR is opened with IBM, and then an APAR
opened and closed against the issue, the above message may remain the
only incident capable of being searched on the web with
[https://www.google.com/search?&q=%22sqlstate%22+%2258004%22+%22duplicate+object+dependency%22];
oddly, that topic was not found presently with that search.
--
Regards, Chuck
Steve Pearson (news only)
Jan 29, 2016, 9:25:27 PM1/29/16
to
Hi Kovi.
It looks like there was some kind of unexpected/internal error (thus code -901). In this case it appears that DB2 unexpectedly encountered duplicate "dependency" data in the catalog, probably in SYSCAT.SYSTRIGDEP (https://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0001065.html?cp=SSEPGG_10.5.0%2F2-12-8-113&lang=en).
HTH.
Regards,
-Steve P.
It looks like there was some kind of unexpected/internal error (thus code -901). In this case it appears that DB2 unexpectedly encountered duplicate "dependency" data in the catalog, probably in SYSCAT.SYSTRIGDEP (https://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0001065.html?cp=SSEPGG_10.5.0%2F2-12-8-113&lang=en).
HTH.
Regards,
-Steve P.
0 new messages