| Author |
Message |
 Topic: Unique Records |
kotagiriaashish
Replies: 17
Views: 17231
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 02, 2020 5:32 am Subject: Unique Records |
Problem Solved at
https://ibmintegration.wordpress.com/2017/03/19/select-distinct-in-esql/ |
| Topic: contect-type application/x-www-form-urlencoded |
kotagiriaashish
Replies: 1
Views: 4482
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 02, 2020 4:27 am Subject: contect-type application/x-www-form-urlencoded |
| If you use JSON Domain, the content type will be overridden to Application/json though your requirement is not quite clear, if you intend to post a valid JSON with content type as application/x-www-fo ... |
| Topic: ORA-01002: fetch out of sequence |
kotagiriaashish
Replies: 8
Views: 8709
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 23, 2015 12:41 am Subject: ORA-01002: fetch out of sequence |
This is solved..... 
So it turns out the DB team did an insert before opening a cursor and forgot to commit it. once the commit was executed everything was working ... |
| Topic: ORA-01002: fetch out of sequence |
kotagiriaashish
Replies: 8
Views: 8709
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 22, 2015 9:17 pm Subject: ORA-01002: fetch out of sequence |
I have tried all the combinations with workarounds and with EnableStaticCursorsForLongData as 0 and 1 but this exception still exists. how to know whats causing the exception.
even the UserTrace fa ... |
| Topic: ORA-01002: fetch out of sequence |
kotagiriaashish
Replies: 8
Views: 8709
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 18, 2015 5:18 am Subject: ORA-01002: fetch out of sequence |
Well, I guess this has something to do with the data source configuration. I recommend you to check the cursor properties... Some cursor options are not enabled by default...
Thaks for the advice ... |
| Topic: ORA-01002: fetch out of sequence |
kotagiriaashish
Replies: 8
Views: 8709
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 18, 2015 4:51 am Subject: ORA-01002: fetch out of sequence |
What happens if you call the stored procedure outside IIB with that specific values?
it returns values, DB tam is able to see the cursors in their toolkit. |
| Topic: ORA-01002: fetch out of sequence |
kotagiriaashish
Replies: 8
Views: 8709
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 18, 2015 4:26 am Subject: ORA-01002: fetch out of sequence |
we are getting ORA-01002: fetch out of sequence on a oracle stored procedure call, user trace shows that there is exception while calling the stored procedure....
did anyone come across this proble ... |
| Topic: PASSING |
kotagiriaashish
Replies: 12
Views: 9761
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jun 07, 2015 5:08 am Subject: PASSING |
Thanks fjb_saper
I was finally able to do it with small modification to the procedure declaration on the ESQL side...
create procedure DEMO_PROCEDURE (OUT content CHARACTER)
... |
| Topic: PASSING |
kotagiriaashish
Replies: 12
Views: 9761
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jun 06, 2015 10:56 pm Subject: PASSING |
Hello I have to pass a row variable to oracle stored procedure signature of the procedure is
create or replace PROCEDURE procCursorExample(cursorParam IN SYS_REFCURSOR , userNameParam OUT ... |
| Topic: Configuring role-based security |
kotagiriaashish
Replies: 0
Views: 2071
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 20, 2014 10:33 pm Subject: Configuring role-based security |
Hello. I am trying to enable web based administration for WMB V8 FP 3
I followed below steps
mqsiwebuseradmin <broker> -c -u <USER> -r mqm -a <USER>
mqsichangebroker <brok ... |
| Topic: OutputLocalEnvironment |
kotagiriaashish
Replies: 4
Views: 5470
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 03, 2014 4:43 am Subject: OutputLocalEnvironment |
| That should be it.. I copied it in haste and was unable to realize that its my mistake.... Thanks a lot mjk! |
| Topic: OutputLocalEnvironment |
kotagiriaashish
Replies: 4
Views: 5470
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 02, 2014 3:10 am Subject: OutputLocalEnvironment |
What is the 'compute mode' setting of your compute node?
Its set to ALL ... thats not the issue the issue is in debug it shows that its requesting to backend URL in Localenvironment but when the re ... |
| Topic: OutputLocalEnvironment |
kotagiriaashish
Replies: 4
Views: 5470
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 02, 2014 1:22 am Subject: OutputLocalEnvironment |
I have been working with webservices since a year... and this problem... i cant understand....
Im setting the request URL before SOAP Request node like
SET OutputLocalEnvironment.Destination.S ... |
| Topic: MQ pub/sub |
kotagiriaashish
Replies: 5
Views: 5240
|
Forum: General IBM MQ Support Posted: Sun Jun 01, 2014 10:42 pm Subject: MQ pub/sub |
That's because that's not the queue you publish messages to! That's the queue you use to register your subscription.
Look up the manual and publish to the right queue! 
Yes im sending ... |
| Topic: MQ pub/sub |
kotagiriaashish
Replies: 5
Views: 5240
|
Forum: General IBM MQ Support Posted: Mon May 26, 2014 10:02 am Subject: MQ pub/sub |
That's because that's not the queue you publish messages to! That's the queue you use to register your subscription.
Look up the manual and publish to the right queue!
Yes im sending ... |
