Author |
Message
|
sireesha |
Posted: Tue Jul 10, 2007 3:25 am Post subject: Message Flow with Oracle Database |
|
|
Novice
Joined: 11 May 2007 Posts: 14 Location: India
|
Hi,
Previously i used to work with DB2 Database. Now i want to use my oracle Database to insert the in that Database. For that in simple message flow i have used Compute node. The Flow has been deployed. But it is not working. Again when i want to redeploy also it is giving error. For that i have deleted the record in CBROKER Table of Configuration Manager Database. After that the flow has been redeployed. But next time also i am facing same problem. Is there any restriction that we need to use only DB2 Database?
With Regards,
Sireesha. |
|
Back to top |
|
 |
Vitor |
Posted: Tue Jul 10, 2007 3:50 am Post subject: Re: Message Flow with Oracle Database |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
sireesha wrote: |
Again when i want to redeploy also it is giving error. For that i have deleted the record in CBROKER Table of Configuration Manager Database. |
Is that an IBM recommended solution?
sireesha wrote: |
Is there any restriction that we need to use only DB2 Database?
|
What version of WMB? What are the supported databases in the relevant documentation? What is the deploy error? _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
sireesha |
Posted: Mon Jul 16, 2007 12:40 am Post subject: |
|
|
Novice
Joined: 11 May 2007 Posts: 14 Location: India
|
Yes, This is IBM recommended solution. I got this solution in IBM site only.
i.e
http://www-1.ibm.com/support/docview.wss?uid=swg21171458
I am using MB Version 5.0.5
While deployment i am not facing any problem. But the flow is not working. In debugging also the flow is not coming to debug. I am new to this stream. So i am unable to explain this thing. So while redeployment i am facing the problem what i have explained.
With Regards,
Sireesha. |
|
Back to top |
|
 |
elvis_gn |
Posted: Mon Jul 16, 2007 12:45 am Post subject: Re: Message Flow with Oracle Database |
|
|
 Padawan
Joined: 08 Oct 2004 Posts: 1905 Location: Dubai
|
Hi sireesha,
sireesha wrote: |
But it is not working. Again when i want to redeploy also it is giving error. |
Please paste the error text that you are getting.
Regards. |
|
Back to top |
|
 |
Vitor |
Posted: Mon Jul 16, 2007 12:50 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
That link talks about restarting channels, config managers and queue managers. I don't see the reference to removing rows in the table.
Maybe I'm missing it.  _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
fjb_saper |
Posted: Mon Jul 16, 2007 2:37 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
If you did not convert the database to Oracle you are better off deleting and recreating the broker with the oracle DB. Of course as per manual you need to establish the ODBC link first...
Don't know about V5 but in V6 you would need to remove all objects from the broker before you delete it (constistency with config mgr).
This means as well you need a full deployment once your new configuration works....
Enjoy  _________________ MQ & Broker admin |
|
Back to top |
|
 |
sireesha |
Posted: Mon Jul 16, 2007 4:25 am Post subject: |
|
|
Novice
Joined: 11 May 2007 Posts: 14 Location: India
|
I am using DB2 Database only for Configuration Manager and Broker. I want to insert my personal data in my Oracle Database using Compute Node in Message Flow. For that i am facing problem.
The below error i am getting for redeployment.
BIP1510E: Unable to deploy configuration data.
An attempt was made to deploy configuration data to one or more brokers, but the Configuration Manager is already deploying to broker WBRK_BROKER. You can not deploy to a set of brokers if there is an earlier deploy outstanding to any broker in the set. The deploy operation was not performed.
Wait for the outstanding deploy to complete before retrying the operation. The Event Log Editor may be used to check that all responses to the outstanding deploy have been received and processed. If the outstanding deploy does not fully complete in a suitable period of time, check that all brokers exist and are running, all WebSphere Business Integration queue managers are running, and that all channels between queue managers are started. Also check that deploy messages have been correctly delivered to the target brokers, and have not been put to the dead letter queue. Correct any problems you find. If it still does not complete, then cancel the deploy operation by specifying the 'Cancel' option in the Message Brokers Toolkit Note that 'Cancel' affects all outstanding deployment operations throughout the domain, so you may not have the authority to perform this.
With Regards,
Sireesha. |
|
Back to top |
|
 |
Vitor |
Posted: Mon Jul 16, 2007 4:31 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
sireesha wrote: |
I am using DB2 Database only for Configuration Manager and Broker. I want to insert my personal data in my Oracle Database using Compute Node in Message Flow. For that i am facing problem.
The below error i am getting for redeployment.
BIP1510E: Unable to deploy configuration data.
|
I don't think this has anything to do with your flow having a Compute Node accessing an Oracle database (which is a reasonable enough thing to do). This is a stuffed up deployment process, possibly caused by you messing around with the database deleting things, and you should resolve that first.
Check for broker problems as per the documentation, get the broker to a state where a simple MQInput->Compute->MQOutput flow will deploy, then revisit your actual flow. Once you can deploy the simple flow, your Oracle one should be no problem. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
sireesha |
Posted: Mon Jul 16, 2007 5:23 am Post subject: |
|
|
Novice
Joined: 11 May 2007 Posts: 14 Location: India
|
After redeploying that oracle message flow i have worked with another flows. All flows are working fine. Thats why i am asking the problem. I have tested the broker with several flows. Except that flow all flows are working.
With Regards,
Sireesha. |
|
Back to top |
|
 |
Vitor |
Posted: Mon Jul 16, 2007 5:29 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
sireesha wrote: |
Except that flow all flows are working. |
Interesting.
I've no idea then. There's nothing intrinsically wrong with what you're doing within the flow, and if there was you should get a run time error not a deploy one.
Unless someone with more brains than me has a better idea I'd consider a PMR.  _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
|