| Author |
Message
|
| rajeevreddy |
 Posted: Mon Oct 27, 2008 5:03 pm Post subject: packed decimal -ConversionException BIP5505E |
 |
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
I have loaded a Copy book into a message set which has a element as
CLASS NO. PIC S9(09) COMP-3.
which got translated into
Logical Type as - Int
Value as min -999999999
max 999999999
Physical type as - Packed Decimal
Length as 5 bytes.
When i send a sample data it fails with below error ,
ConversionException BIP5505E: A data conversion failed because the data was invalid. Type of data being read: 'packed decimal, no sign found ' Data: '0x016dd1093c'
Test Data is from OS/390 system...using rfhutil to drop the msg on broker system.
Sample data looks like - > 1.mÑ.<.Å“ÃÃÃ*... (when i look from rfhutil.)Need your help in solving the issue.
Your help is much appreciated. Can you also suggest me the right way of performing unit testing with Main frame data against the message set.
Thanks |
|
| Back to top |
|
 |
| rajeevreddy |
| Posted: Tue Oct 28, 2008 6:13 am Post subject: |
|
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
Can someone help me...Please by responding your valuable suggestion for my request.
Thnaks. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Oct 28, 2008 6:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Your data does not include a negative or positive sign on it, to indicate whether it is a negative or positive number.
Either your data does not match the copybook or the copybook does not match the data.
Or the message was improperly marked as MQFMT_STRING and MQ has translated the packed decimal data into character data. |
|
| Back to top |
|
|
| rajeevreddy |
| Posted: Tue Oct 28, 2008 6:38 am Post subject: |
|
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
Thanks a lot Jeff.
How to make sure my incoming data is comingin right format.Main frame folks have porvided a TXT file with test data and i am using RFHUTIL to drop the messages. I think the way i am dropping message is wrong. Can you direct me the right way of testing my Copy book.
Thanks. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Oct 28, 2008 6:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Packed decimals are not text. |
|
| Back to top |
|
|
| rajeevreddy |
| Posted: Tue Oct 28, 2008 6:55 am Post subject: |
|
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
Thanks Jeff
If you don't mind can you be more elaborate . I am new to Coby books and have issues understanding. Can you suggest me on how to test my CC Book ? Can i change the encoding in my flow will it work ?
Thanks. |
|
| Back to top |
|
|
| rajeevreddy |
| Posted: Tue Oct 28, 2008 8:50 am Post subject: |
|
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
| Can some one give me a sample on how to handle COMP-3 elements. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Oct 28, 2008 1:37 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Load the file from the MF with RFHUTIL, mark it to be CCSID 500 or 37 depending on your MF qmgr setting and do leave the format blank.
The file you got should look like gibberish if you open it in wordpad or notepad. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| rajeevreddy |
| Posted: Tue Oct 28, 2008 2:03 pm Post subject: |
|
|
Apprentice
Joined: 07 Sep 2004
Posts: 39
|
I keep getting below error ,
ParserException BIP5171E: An error occurred while a Custom Wire Format message was being parsed:
Current message: 'msg_TESTRECORD'
Current element: 'TEST_FIELD02'
Path from message root: '/msg_TESTRECORD'
Offset from start of message: 16
See the following errors for more details.
ConversionException BIP5505E: A data conversion failed because the data was invalid.
Type of data being read: 'packed decimal, no sign found '
Data: '0x20127f8c7f7f'
Element on the CC book is TEST-FIELD02 PIC 9(10) COMP-3.
Thanks. |
|
| Back to top |
|
|
| mqbrk_newbie |
| Posted: Fri May 08, 2009 2:13 pm Post subject: packed decimal -ConversionException BIP5505E |
|
|
Acolyte
Joined: 13 Sep 2004
Posts: 70
|
Hi Rajeev,
Were you able to come up any solution for this issue. I sam facing the same problem I have a copy book which has a field. PIC S9(13)V99 COMP-3. I have asked the mainframe to send the data in txt file in EBCDIC format. But I am not able to match the data with copybook and sample file. I have created a message set importing this copybook. The sample data is parsing fine, but later throwing me a data conversion exception in Packed Decimal field.
Have you solved this issue?
Your response is highly appreciated.
Thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Sat May 09, 2009 11:46 am Post subject: Re: packed decimal -ConversionException BIP5505E |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqbrk_newbie wrote: |
| I sam facing the same problem I have a copy book which has a field. PIC S9(13)V99 COMP-3. I have asked the mainframe to send the data in txt file in EBCDIC format. |
A COMP-3 field can't be represented in any text format. Hence you'll get an exception when the broker tries to interpret this field.
What you need is a binary file and put in on the queue as described as fjb_saper.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat May 09, 2009 12:48 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Using RFHUTIL, load the copybook to rfhutil and verify the hex value of the comp-3 field... for 123 it should be something like 123F or 123D or 123C...
Have fun
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Sat May 09, 2009 1:00 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fjb_saper wrote: |
| for 123 it should be something like 123F or 123D or 123C... |
Pedantically 123D would be -123 if anyone cares...
C A F E 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun May 10, 2009 6:31 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
| Data: '0x20127f8c7f7f' |
Is just a random Hex value and in no way represents a comp-3 byte array.
Tell your people to stop sending you junk and force them to initialize each and every field on the copy book.
Verify that your offset is right. 0x20127F could be comp-3 #, although finishing with F, I believe it would be unsigned.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqbrk_newbie |
| Posted: Mon May 11, 2009 2:29 pm Post subject: packed decimal -ConversionException BIP5505E |
|
|
Acolyte
Joined: 13 Sep 2004
Posts: 70
|
Thanks a lot Vitor/fjb_saper for your response. I understand that comp 3 field cannot be represented as a txt file. we have been designing interfaces where we are integrating mainframe application, we have a fileInput node as a starting point of message flow.
So when we do our unit testing , the mainframe folks send us the sample data in the form of a txt file in EBCDIC format, when we open these files it opens on RFHUTIL in OS/390 MODE IN EBCDIC FORMAT. We then open the cobol copybook and validate the file with copybook. Once the sample data is validated against copybook we use that sample data for testing. This method has been successfull so far.We have already changed the CCSID and Encoding in the Input MEssage Parsing properties of file Input node,So far it is working fine when we did our integration testing.
ISSUE:
This is the first time we have having copybook with COMP-3 representation and most of the fields are in packed decimal format.
My question here is can we able to validate the sample data they send us with copybook we have on RFHUTIL like the same way we did it before?
THanks all for your help |
|
| Back to top |
|
|
|
|
