| Author |
Message |
 Topic: MQ persistent messages go missing in WMQ v7 and WMB v7 |
Diwakar
Replies: 7
Views: 5475
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 25, 2011 7:41 pm Subject: MQ persistent messages go missing in WMQ v7 and WMB v7 |
There is an exception handling subflow in each of the flows A, B , C, and D and the subflow extracts the error code/text and forms an exception message and puts it to an error queue.
But we don't s ... |
| Topic: MQ persistent messages go missing in WMQ v7 and WMB v7 |
Diwakar
Replies: 7
Views: 5475
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 25, 2011 7:19 pm Subject: MQ persistent messages go missing in WMQ v7 and WMB v7 |
Hello,
We have MQ v7.0.1, and MB v7.0.0.1 on Win 2008 servers.
We just upgraded from MQv6.0.x, and MB v6.0.x, and JText Adapters.
We have a peculiar problem (we had this in version 6 too, and w ... |
| Topic: executing an INSERT via PASSTHRU into Oracle |
Diwakar
Replies: 5
Views: 16264
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 15, 2011 8:08 am Subject: executing an INSERT via PASSTHRU into Oracle |
As far as I know my SQL statement above can be done in WMB-ESQL only via a PASSTHRU.
Because of its nested structure I can't use the SQL in an EVAL statement.
Am I correct ?
Thanks |
| Topic: executing an INSERT via PASSTHRU into Oracle |
Diwakar
Replies: 5
Views: 16264
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 14, 2011 10:33 pm Subject: executing an INSERT via PASSTHRU into Oracle |
Hi
I was able to get the syntax correct. I deployed the msgflow.
And when a sample xml was sent, I saw the following exception in broker, but NO clue what it means (as the SQL works fine in SQL d ... |
| Topic: executing an INSERT via PASSTHRU into Oracle |
Diwakar
Replies: 5
Views: 16264
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 14, 2011 8:26 pm Subject: executing an INSERT via PASSTHRU into Oracle |
Here is the SQL that works in WMB v7 via a PASSTHRU with hardcoded values in place of ? above:
-----------------------------------------------------------------------------
PASSTHRU('Insert into ... |
| Topic: executing an INSERT via PASSTHRU into Oracle |
Diwakar
Replies: 5
Views: 16264
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 14, 2011 8:17 pm Subject: executing an INSERT via PASSTHRU into Oracle |
Hi people,
I have an SQL statement that works fine in SQL Developer.
It executes fine in MB v7.0.0.1 w/ MQ v7.0.1 when I supply hardcoded values via a PASSTHRU.
But I need to pass variables (f ... |
| Topic: AdoptNewMCA, MCACheck in QMGR's channel stanza |
Diwakar
Replies: 1
Views: 4423
|
Forum: IBM MQ Installation/Configuration Support Posted: Mon Feb 07, 2011 8:58 pm Subject: AdoptNewMCA, MCACheck in QMGR's channel stanza |
I read several posts (and the manuals) regarding AdoptNewMCA, and AdoptNewMCACheck and I think I understand what the parameters do.
Channels:
AdoptNewMCA=ALL
AdoptNewMCACheck=ALL
But ... |
| Topic: why can't we define a backout queue? question from infocentr |
Diwakar
Replies: 4
Views: 6007
|
Forum: IBM MQ Java / JMS Posted: Thu Feb 03, 2011 8:55 pm Subject: why can't we define a backout queue? question from infocentr |
fjb_saper,
"Figuring out" may not give us the correct info always.
In our case, nothing happens when we try with both. I know that could mean we have other issues to look into.
So ... |
| Topic: why can't we define a backout queue? question from infocentr |
Diwakar
Replies: 4
Views: 6007
|
Forum: IBM MQ Java / JMS Posted: Thu Feb 03, 2011 5:30 pm Subject: why can't we define a backout queue? question from infocentr |
| We use MQ v7.0.1, as the JMS messaging provider for Websphere Process Server v6.0.1. We have just 1 queue manager but 2 clustered process server boxes connected to MQ qmgr using MQ-CLIENT connections. ... |
| Topic: why can't we define a backout queue? question from infocentr |
Diwakar
Replies: 4
Views: 6007
|
Forum: IBM MQ Java / JMS Posted: Thu Feb 03, 2011 9:07 am Subject: why can't we define a backout queue? question from infocentr |
Hi,
Here is an excerpt from the MQ v7 info center :
http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/topic/com.ibm.mq.amqwak.doc/ir19630_.htm
---------------------------------------------- ... |
| Topic: WMB version 7 support end-date announced ? |
Diwakar
Replies: 16
Views: 9122
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jan 19, 2011 12:43 pm Subject: WMB version 7 support end-date announced ? |
Hello,
My manager asked me to find out these:
1) Is there an announced end-date for WMB version 7 support ? Yes, I am asking about version SEVEN.
2) Any announcements for WMB version 8 so far ... |
| Topic: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Diwakar
Replies: 26
Views: 20400
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 13, 2011 5:48 pm Subject: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
MGK,
Thanks for the post, and that's exactly what I needed.
I tried TRIM the way you suggested, and it worked for me.
TRANSLATE is messy, and may cause problems in my case because I need only ... |
| Topic: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Diwakar
Replies: 26
Views: 20400
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 13, 2011 10:52 am Subject: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Vitor,
My question was the same as mqjeff's : is two translates bettwr than a cast and a translate ? That's why I asked how you'd translate it with acceptable characters.
Since you said you have ... |
| Topic: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Diwakar
Replies: 26
Views: 20400
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 13, 2011 9:35 am Subject: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Thanks Vitor,
But how do I use TRANSLATE with acceptable chars ? TRANSLATE is used to remove unwanted chars as per the syntax.
Also, the list of acceptable characters might be huge.
thanks |
| Topic: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
Diwakar
Replies: 26
Views: 20400
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 13, 2011 9:22 am Subject: Unable to TRIM spaces/tabs/newlines on either sides of a tag |
I can't change the 'Awakward situation' for now, as I am not allowed to change all the code written already. So, I'll have to live with TRANSLATE I guess.
DECLARE invisibleCharList CHAR CAST(x'0d0a ... |
