| Author |
Message
|
| brokerics |
 Posted: Sun Oct 30, 2005 10:52 pm Post subject: Problem adding foreign key |
 |
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
hey people
i had established a DB server connection in the data perspective in broker.but it showd the fol error
Problem adding foreign key, 'RTAB', to table 'null'. IWAS0074E SQLState [57011], [IBM][CLI Driver][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
here, RTAB is user defined.
also, while inserting rows into the database, it works thru an esql statemnt defined under the database node. But when i try to insert a stmnt wit differnt values , the older values keep enterin the db!
help me please |
|
| Back to top |
|
 |
| brokerics |
| Posted: Mon Oct 31, 2005 12:29 am Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
| btw i use broker version 5.1 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Oct 31, 2005 2:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Why is it trying to insert into a table named "null"?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerics |
| Posted: Mon Oct 31, 2005 3:37 am Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
i dont know jeff 
the second problm is more irritatin..
i hav a MQ input node ,as an input to the database node. so when a msg is put inthe queue, the DB node executes the ESQL query..consider insert statement. the first time it executes fine, the second time i modify the insert statement for differnt values, the DB node executes and inserts in the same values as the first one.
and if i change the queue associated wit the MQINPUT, the msg doesnt even reach the DB.
is there a bind b/w the queue and the node?
wat do i do?? |
|
| Back to top |
|
|
| brokerics |
| Posted: Mon Oct 31, 2005 3:39 am Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
| am i missin a concept here? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Oct 31, 2005 3:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to redeploy after you change things.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerics |
| Posted: Tue Nov 01, 2005 8:32 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
i did jeff...
i keep redeployin it every time i do a change...
but somehow, it doesnt work |
|
| Back to top |
|
|
| brokerics |
| Posted: Tue Nov 01, 2005 8:41 pm Post subject: |
|
|
Apprentice
Joined: 30 Oct 2005
Posts: 45
|
| hey i just noticed that even the default execution group is not running...wat cud b the problm? |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Wed Nov 02, 2005 12:25 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
For your first problem:
You can try to increase the application heap size for the broker databases in DB2.
For the second:
1. Consider doing a complete deploy of the broker else, redeploy the flow by moving it to a new exec group.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
|
|
