ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexSearch

Search found 163 matches
Author Message
Topic:ORA-01002: fetch out of sequence
kotagiriaashish

Replies: 8
Views: 2122

PostForum:WebSphere Message Broker 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: 2122

PostForum:WebSphere Message Broker 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: 2122

PostForum:WebSphere Message Broker 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: 2122

PostForum:WebSphere Message Broker 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: 2122

PostForum:WebSphere Message Broker 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: 3079

PostForum:WebSphere Message Broker 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: 3079

PostForum:WebSphere Message Broker 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: 680

PostForum:WebSphere Message Broker 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: 1681

PostForum:WebSphere Message Broker 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: 1681

PostForum:WebSphere Message Broker 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: 1681

PostForum:WebSphere Message Broker 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: 1761

PostForum: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: 1761

PostForum: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 ...
Topic:MQ pub/sub
kotagiriaashish

Replies: 5
Views: 1761

PostForum:General IBM MQ Support Posted: Mon May 26, 2014 4:12 am Subject: MQ pub/sub
Hello guys, I have a problem with registering topics in fact I have a problem with SYSTEM.BROKER.CONTROL.QUEUE, messages are just piling up on the queue.

I did a couple of things to trouble shoot, ...
Topic:XI52 Connect to Host
kotagiriaashish

Replies: 0
Views: 1602

PostForum:WebSphere DataPower Posted: Sun Feb 23, 2014 11:16 pm Subject: XI52 Connect to Host
Hi, I have Datapower XI52 VM Running on my System, the problem I am facing is, When I configure a new queue manager Datapower is unable to connect to the QM

Datapower :
Event Code 0x806000bb -
T ...
Goto page 1, 2, 3 ... 9, 10, 11  Next Page 1 of 11

Jump to:
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.