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 Index » WebSphere Message Broker (ACE) Support » parser not recognizing a field

Post new topic  Reply to topic
 parser not recognizing a field « View previous topic :: View next topic » 
Author Message
madi
PostPosted: Fri Aug 12, 2011 6:25 am    Post subject: parser not recognizing a field Reply with quote

Chevalier

Joined: 17 Jan 2006
Posts: 475

some how the esql cannot refer to a particular field in the input

Code in first compute

Code:
DECLARE sap_idoccontrol                 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_idoccontrol';
CREATE FIELD OutputRoot.XMLNSC.p:EXCHANGE_RATE01.p:Control_record.sap_idoccontrol:sap_idoccontrol;


Code in second compute

Code:
DECLARE sap_idoccontrol NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_idoccontrol';
CALL CopyEntireMessage();
         DECLARE REF_Out_iDoc REFERENCE TO OutputRoot.XMLNSC.*[>1].*[>1].{sap_idoccontrol}:sap_idoccontrol;


Error in user trace is that it cannot find the 5th element in the last declare stmt.

any ideas on fixing this? I have been breaking my head on this all day

appreciate any help
_________________
IBM Certified Solutions Developer - WMB 6.0
Back to top
View user's profile Send private message
WGerstma
PostPosted: Fri Aug 12, 2011 6:50 am    Post subject: Reply with quote

Acolyte

Joined: 18 Jul 2011
Posts: 55

Tried to remove the {}?
Back to top
View user's profile Send private message
madi
PostPosted: Fri Aug 12, 2011 7:01 am    Post subject: Reply with quote

Chevalier

Joined: 17 Jan 2006
Posts: 475

sorry false alrm, couldnt get it to work

i did take the {} out

this is the error
Code:
2011-08-12 10:40:59.457973    20516   UserTrace   BIP2568I: Node 'I3014_OAG_EXCHRATES_SAPP.sub_setIdocControl_FromDB.Get_IDOC_Control_Info': Copying sub-tree from ''InputRoot'' to ''OutputRoot''.
2011-08-12 10:40:59.458015    20516   UserTrace   BIP2537I: Node 'I3014_OAG_EXCHRATES_SAPP.sub_setIdocControl_FromDB.Get_IDOC_Control_Info': Executing statement   ''DECLARE REF_Out_iDoc REFERENCE TO OutputRoot.XMLNSC.*:*[1].*:*[1].*:sap_idoccontrol;'' at ('.sub_setIdocControl_FromDB_Get_IDOC_Control_Info.PopulateIDOCControlSegment', '13.4').
2011-08-12 10:40:59.458034    20516   UserTrace   BIP2543I: Node 'I3014_OAG_EXCHRATES_SAPP.sub_setIdocControl_FromDB.Get_IDOC_Control_Info': ('.sub_setIdocControl_FromDB_Get_IDOC_Control_Info.PopulateIDOCControlSegment', '13.38') : Failed to navigate to path element number '5' because it does not exist.
2011-08-12 10:40:59.458057    20516   UserTrace   BIP2537I: Node 'I3014_OAG_EXCHRATES_SAPP.sub_setIdocControl_FromDB.Get_IDOC_Control_Info': Executing statement   ''DECLARE REF_In_iDoc REFERENCE TO InputRoot.XMLNSC.*:*[1].*:*[1].*:sap_idoccontrol;'' at ('.sub_setIdocControl_FromDB_Get_IDOC_Control_Info.PopulateIDOCControlSegment', '14.4').
2011-08-12 10:40:59.458076    20516   UserTrace   BIP2543I: Node 'I3014_OAG_EXCHRATES_SAPP.sub_setIdocControl_FromDB.Get_IDOC_Control_Info': ('.sub_setIdocControl_FromDB_Get_IDOC_Control_Info.PopulateIDOCControlSegment', '14.37') : Failed to navigate to path element number '5' because it does not exist.


but in the trace bfore the compute
Code:

[quote]
Root:( ['MQROOT' : 0x242e6c98]
  (0x01000000:Folder):XMLNSC = ( ['xmlnsc' : 0x242e46a0]
    (0x01000000:Folder)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EXCHANGE_RATE01:EXCHANGE_RATE01 = (
      (0x03000100:Attribute):verb                                                                                 = 'Create' (CHARACTER)
      (0x01000000:Folder   )http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EXCHANGE_RATE01:Control_record = (
        (0x01000000:Folder)http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_idoccontrol:sap_idoccontrol = ([/quote]

_________________
IBM Certified Solutions Developer - WMB 6.0
Back to top
View user's profile Send private message
kimbert
PostPosted: Mon Aug 15, 2011 3:47 pm    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

The 'verb' attribute is getting in the way. Your path is asking for the first child with name 'sap_idoccontrol' under the first child of the first child of OutputRoot.XMLNSC. Time to get more explicit about your ESQL path reference. *:* is easy, but error-prone.

You may want to use (XMLNSC.Element)*:* if you can't be sure about the tag names, but you want to ignore attributes.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » parser not recognizing a field
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.