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 IndexWebSphere Message Broker SupportIssue with deleting client request under usr folder.

Post new topicReply to topic
Issue with deleting client request under usr folder. View previous topic :: View next topic
Author Message
Lebowski
PostPosted: Thu Aug 03, 2017 7:00 am Post subject: Issue with deleting client request under usr folder. Reply with quote

Newbie

Joined: 26 May 2016
Posts: 7

Hi all,

Encountered an issue and I'm really scratching my head over it.

In the message flow we are using aggregation folders to store the original messages.

On the response coming from the backend system there are two client request folders which structure looks like this -

Code:
<OutputRoot>
                <MQRHF2>
                            <usr>
                                <INTERNAL_DATA>
                                                        <ClientRequests>
                                                                             <ClientRequest>
                                                                             <ClientRequest>

There is some code to determine if the client request matches the client name we are looking for in the response. Once that is confirmed to match I am wanting to delete the second ClientRequest field as the following service only requires the first one.

When trying to do this however I am encountering an error "Could not create parser"

I've tried using code to set it to NULL, DELETE FIELD yet none seem to work.

Any help would be greatly appreciated.
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Aug 03, 2017 7:36 am Post subject: Re: Issue with deleting client request under usr folder. Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 24409
Location: Ohio, USA

Lebowski wrote:
When trying to do this however I am encountering an error "Could not create parser"

I've tried using code to set it to NULL, DELETE FIELD yet none seem to work.


Please post your code snippet(s) and the actual error. With relevant tags to aid readability if you'd be so good.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Aug 03, 2017 8:22 am Post subject: Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19218
Location: LI,NY

Looks like you do not understand the nature of the usr folder.
It contains only name value pairs....

So in order to do what you want to do you would need to:
  • extract the INTERNAL_DATA from the usr folder.
  • Parse the extracted data
  • Manipulate the parsed data
  • Serialize the manipulated parsed data
  • update the INTERNAL_DATA with the serialized data


Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
inMo
PostPosted: Thu Aug 03, 2017 1:03 pm Post subject: Reply with quote

Master

Joined: 27 Jun 2009
Posts: 211
Location: NY

I second Vitor - I'd like to see the code snipet you are using for this task.
Back to top
View user's profile Send private message
Lebowski
PostPosted: Fri Aug 04, 2017 12:14 am Post subject: Reply with quote

Newbie

Joined: 26 May 2016
Posts: 7

DECLARE storeRef REFERENCE TO OutputRoot.MQRFH2;

DECLARE found BOOLEAN FALSE;

DECLARE CLIENT_NAME CONSTANT CHAR 'servicename';

DECLARE originalRef REFERENCE TO storeRef;

MOVE storeRef TO
storeRef.usr.INTERNAL_DATA.ClientRequests.ClientRequest[>];

WHILE LASTMOVE(storeRef) DO
IF storeRef.(XML.Attribute)CLIENT_NAME = CLIENT_NAME THEN

RETURN TRUE;
ELSE
MOVE storeRef NEXTSIBLING REPEAT TYPE NAME;
END IF;
END WHILE;

This determines the Client name passed in through the Client request folder matches the one declared in this code. Following this I just simply have -

DELETE FIELD storeRef;

I've tried doing drilling right down rather than deleting the reference and that hasn't worked either.
Back to top
View user's profile Send private message
inMo
PostPosted: Fri Aug 04, 2017 1:19 am Post subject: Reply with quote

Master

Joined: 27 Jun 2009
Posts: 211
Location: NY

Questions:

1) are you dealing with an MQ message or something else?
2) where is the sample data structure coming from? (How did you get the sample?)
3) assuming sample is correct, are you sure your first line of code actually works?
Back to top
View user's profile Send private message
Lebowski
PostPosted: Fri Aug 04, 2017 2:07 am Post subject: Reply with quote

Newbie

Joined: 26 May 2016
Posts: 7

1) are you dealing with an MQ message or something else?
Yes it's an xml MQ message
2) where is the sample data structure coming from? (How did you get the sample?)
Sample is just the MQRFH2 header which comes back on the reply
3) assuming sample is correct, are you sure your first line of code actually works?
Yes the code which determines if the CLIENT_NAME matches does work as intended, it's simply when trying to remove the 'storeRef' that I encounter problems.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Fri Aug 04, 2017 5:00 am Post subject: Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19218
Location: LI,NY

Lebowski wrote:
Code:
DECLARE storeRef    REFERENCE TO OutputRoot.MQRFH2;

DECLARE found       BOOLEAN FALSE;

DECLARE CLIENT_NAME CONSTANT CHAR 'servicename';

DECLARE originalRef REFERENCE TO storeRef;
   
MOVE storeRef TO
storeRef.usr.INTERNAL_DATA.ClientRequests.ClientRequest[>]; --not possible as usr.INTERNAL_DATA is the name of a name value pair...
   
      WHILE LASTMOVE(storeRef) DO -- will always return false...
         IF storeRef.(XML.Attribute)CLIENT_NAME = CLIENT_NAME THEN
            
            RETURN TRUE;
         ELSE
            MOVE storeRef NEXTSIBLING REPEAT TYPE NAME;
         END IF;   
      END WHILE;


This determines the Client name passed in through the Client request folder matches the one declared in this code. Following this I just simply have -

DELETE FIELD storeRef;

I've tried doing drilling right down rather than deleting the reference and that hasn't worked either.

Your code is not doing what you think. Especially the move before the while...
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIssue with deleting client request under usr folder.
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


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

Copyright MQSeries.net. All rights reserved.