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 » Cant get the Date in output !!!! HELP !!! URGENT !!!!

Post new topic  Reply to topic
 Cant get the Date in output !!!! HELP !!! URGENT !!!! « View previous topic :: View next topic » 
Author Message
elvis_gn
PostPosted: Tue Oct 12, 2004 5:44 am    Post subject: Cant get the Date in output !!!! HELP !!! URGENT !!!! Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

I'm using TDS format to run a message flow.

The input is [Pts_Input=[Name=ELVIS,Visa=3333,PassportId=4444,TravelDocId=5555]]

This works perfectly for the default compute node ESQL,even when some database operation is performed using this data,it works......only when i try to extract a DATE type into the output the field is empty.

This is my trace node output,which is just before the output node.
(0x01000021):MRM = (
(0x03000000):VisaValid = DATE '2004-10-10'
(0x03000000):TravelValid = DATE '2004-08-08'
(0x03000000):PersonAlert = 'NOALERT'
(0x03000000):TravelAlert = 'NO ALERT'
)

This is my final output
[VisaValid=,TravelValid=,PersonAlert=NOALERT,TravelAlert=NO ALERT]

The VisaValid and TravelValid are supposed to be Date types and are not showing the value,though it is there in the trace
Back to top
View user's profile Send private message Send e-mail
kirani
PostPosted: Tue Oct 12, 2004 10:52 am    Post subject: Reply with quote

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Is this the same problem that's described in http://www.mqseries.net/phpBB2/viewtopic.php?t=18199
_________________
Kiran


IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Back to top
View user's profile Send private message Visit poster's website
rvikky
PostPosted: Fri Mar 24, 2006 1:57 am    Post subject: Reply with quote

Apprentice

Joined: 14 Feb 2006
Posts: 32
Location: Bangalore

hi elvis,
i'm also facing the same problem.
In CSV format i'm giving date(yyyy-MM-dd) and I'm trying to convert it into XML format but it goes to backout queue.when i give the same without date it works.
Message - "rvikky,Chennai,2006-04-05" - doesn't work and goes to backout queue
Message - "rvikky,Chennai," - works
Back to top
View user's profile Send private message
kimbert
PostPosted: Fri Mar 24, 2006 2:27 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Check the system log for errors. Post any relevant errors here.
If you can't find anything in the system log, switch on user trace, put your message through the message flow, and then post the formatted trace here.
Back to top
View user's profile Send private message
elvis_gn
PostPosted: Fri Mar 24, 2006 2:37 am    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hmmm...those were the days... (Actually, somedays it still feels like those days )

Anyway, I don't remember what i did 2 years back....

I would like to see the code that you are using...Please post it...

Regards.
Back to top
View user's profile Send private message Send e-mail
rvikky
PostPosted: Fri Mar 24, 2006 3:01 am    Post subject: Reply with quote

Apprentice

Joined: 14 Feb 2006
Posts: 32
Location: Bangalore

hi elvis,
its the same code which i mailed u today morning. i've just added one more field thatz it. i'll mail the code to u.
Back to top
View user's profile Send private message
rvikky
PostPosted: Fri Mar 24, 2006 3:36 am    Post subject: Reply with quote

Apprentice

Joined: 14 Feb 2006
Posts: 32
Location: Bangalore

i tried formatting the user trace and I ended up getting an error.
The error is:

BIP5004E: XML parsing error ('An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:/Documents and Settings/All Users/Application Data/IBM/MQSI/common/log/CSO_BROKER.efd24a2b-0a01-0000-0080-c06b8ccae6ea.userTrace.bin.1 ') encountered on line 0 column 0 while parsing element ''.
The above error was reported by the generic XML parser.
This message is usually caused by a badly-formed XML message. Check that the XML message being passed in is a well-formed XML message that adheres to the XML specification. Note that the line number and column number quoted above give the position where the parser discovered the problem. The actual error may be earlier in the message. Internal error codes : (-1), ('').

BIP8047E: Unable to parse the data received, exception caught 'ImbException'.
The command uses parser functions to analyze XML data, the parser has detected an error in the format of the XML data being parsed. Use the line number and column number to locate the XML causing the problem.
Check that the data being parsed is correctly formatted. The command may produce partial output. It may also be possible to modify the XML data that the command is parsing so that the error does not occur.

The formatted log file contains:
Timestamps are formatted in local time, 330 minutes past GMT.
Back to top
View user's profile Send private message
kimbert
PostPosted: Fri Mar 24, 2006 4:42 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Hmmm, that's contact admin. You could try resetting the trace log file using the -r option on the mqsichangetrace command.
Back to top
View user's profile Send private message
elvis_gn
PostPosted: Sun Mar 26, 2006 8:28 pm    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi kimbert,

I think we shouldn't get deep into this....

rvikky defined the field as date and was trying to send the date as a string through it....

This was on friday...hope he has fixed it by today.

Regards.
Back to top
View user's profile Send private message Send e-mail
n1ghtrain
PostPosted: Wed Mar 29, 2006 1:52 am    Post subject: Reply with quote

Apprentice

Joined: 23 Mar 2006
Posts: 48
Location: Bangalore

hi elvis..
I tried doin something similar..

Date format is yyyy-MM-dd in both XML and TDS physical properties in the message definition..

Everything seem to be working fine.. but it won't create an equivalent xml tag,
if the date field is present.. i tried debuggin the flow too...but no good.



Data in --> xxxx*yyyy*2006-04-04*2006-04-04




UserTrace BIP4060I: Data ''
(
(0x0300000B):NAME = 'xxxx'
(0x0300000B):ADDRESS = 'yyyy'
(0x0300000B):START_DATE = DATE '2006-04-04'
(0x0300000B):END_DATE = DATE '2006-04-04'

)'' from trace node 'PHP_MA1.Trace'.




Should we extract date from ----- DATE '2006-04-04' ..??

....
Regards
Back to top
View user's profile Send private message Yahoo Messenger
kimbert
PostPosted: Wed Apr 05, 2006 1:31 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Quote:
but it won't create an equivalent xml tag, if the date field is present..
I don't understand. In your next post, please provide
- the output message that you want
- the output message that you are getting
- any exceptions which are being thrown by the message flow
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 » Cant get the Date in output !!!! HELP !!! URGENT !!!!
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.