| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Cannot deploy relationship on DB2 <-- SOLVED |
« View previous topic :: View next topic » |
| Author |
Message
|
| fponcet |
 Posted: Sat Dec 10, 2005 6:18 am Post subject: Cannot deploy relationship on DB2 <-- SOLVED |
 |
|
Acolyte
Joined: 20 Oct 2005
Posts: 55
|
Hi,
I would like to deploy a relationship in my local db2 database. However when I deploy it in the local WICS server I get the following message:
Relationship:Params - JDBC error encountered during an attempt to execute the query: CREATE PROCEDURE Params_1_0_0_SP (OUT newID INT)
LANGUAGE SQL
BEGIN
VALUES (NEXTVAL FOR Params_1_0_0) INTO newId;END [info]:: (SQLState [42904]:[IBM][CLI Driver][DB2/NT] SQL7032N SQL procedure "PARAMS_1_0_0_SP" not created. Diagnostic file is "P2133789.log". SQLSTATE=42904
DB specific error:-7032)
Relationship:Params - Cannot activate a relationship definition whose run time schema was not created/updated.
How can I create/update that run time schema?
Last edited by fponcet on Wed Feb 01, 2006 7:12 am; edited 1 time in total |
|
| Back to top |
|
 |
| amateur10 |
| Posted: Sat Dec 10, 2005 7:46 am Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
| Deploy as user project, and click CREATE SCHEMA. once you do that, it will create schema. |
|
| Back to top |
|
|
| fponcet |
| Posted: Wed Jan 25, 2006 3:19 am Post subject: |
|
|
Acolyte
Joined: 20 Oct 2005
Posts: 55
|
| amateur10 wrote: |
| Deploy as user project, and click CREATE SCHEMA. once you do that, it will create schema. |
I have done it but again the same problem:
2810 Reboot the server to activate the deployed components.
Relationship Params 2813 JDBC error encountered during an attempt to execute the query: CREATE PROCEDURE Params_1_0_0_SP (OUT newID INT)
LANGUAGE SQL
BEGIN
VALUES (NEXTVAL FOR Params_1_0_0) INTO newId;END [info]:: (SQLState [42904]:[IBM][CLI Driver][DB2/NT] SQL7032N SQL procedure "PARAMS_1_0_0_SP" not created. Diagnostic file is "P2181373.log". SQLSTATE=42904
DB specific error:-7032)
Relationship Params 2813 Cannot activate a relationship definition whose run time schema was not created/updated. |
|
| Back to top |
|
|
| sdng |
| Posted: Wed Jan 25, 2006 4:24 am Post subject: |
|
|
Acolyte
Joined: 23 Nov 2005
Posts: 53
|
may be, i'm not right, but i had such problem because it's need GNU C Compiler for db2 and public path to it bin subdirectory.
_________________
Are you gangsters? No, we are Russians! |
|
| Back to top |
|
|
| fponcet |
| Posted: Thu Jan 26, 2006 2:52 am Post subject: |
|
|
Acolyte
Joined: 20 Oct 2005
Posts: 55
|
| sdng wrote: |
| may be, i'm not right, but i had such problem because it's need GNU C Compiler for db2 and public path to it bin subdirectory. |
Thank you, you were right. After a hellish  installation/configuration of the compiler, it works.
Right after installing it I realized that the relationship table structure is different in Oracle and DB2. I wonder why.
Regards. |
|
| 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
|
|
|
|
