Author |
Message
|
elvis_gn |
Posted: Tue Oct 12, 2004 5:44 am Post subject: Cant get the Date in output !!!! HELP !!! URGENT !!!! |
|
|
 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 |
|
 |
kirani |
Posted: Tue Oct 12, 2004 10:52 am Post subject: |
|
|
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 |
|
 |
rvikky |
Posted: Fri Mar 24, 2006 1:57 am Post subject: |
|
|
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 |
|
 |
kimbert |
Posted: Fri Mar 24, 2006 2:27 am Post subject: |
|
|
 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 |
|
 |
elvis_gn |
Posted: Fri Mar 24, 2006 2:37 am Post subject: |
|
|
 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 |
|
 |
rvikky |
Posted: Fri Mar 24, 2006 3:01 am Post subject: |
|
|
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 |
|
 |
rvikky |
Posted: Fri Mar 24, 2006 3:36 am Post subject: |
|
|
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 |
|
 |
kimbert |
Posted: Fri Mar 24, 2006 4:42 am Post subject: |
|
|
 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 |
|
 |
elvis_gn |
Posted: Sun Mar 26, 2006 8:28 pm Post subject: |
|
|
 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 |
|
 |
n1ghtrain |
Posted: Wed Mar 29, 2006 1:52 am Post subject: |
|
|
 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 |
|
 |
kimbert |
Posted: Wed Apr 05, 2006 1:31 am Post subject: |
|
|
 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 |
|
 |
|