| Author |
Message
|
| anshu |
 Posted: Mon Jan 23, 2006 12:54 pm Post subject: SWIFT - CRLF Problem. |
 |
|
Novice
Joined: 23 Jan 2006
Posts: 19
|
I have a TDS to SWIFT conversion message flow. The SWIFT output looks clean except there is a CRLF introduced before the 32A amount field. So instead of
:32A:060123USD1000,00
my output looks like
:32A:060123USD
1000,00
with the CRLF introduced after USD. Any reason why this is happening? Everything else is correct. |
|
| Back to top |
|
 |
| wschutz |
| Posted: Mon Jan 23, 2006 1:13 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Did you create the Swift message set yourself or is this the Cat 1 supportpac?
Are you saying that the message on the input side des not have a CRLF?
_________________
-wayne |
|
| Back to top |
|
|
| anshu |
| Posted: Mon Jan 23, 2006 1:20 pm Post subject: |
|
|
Novice
Joined: 23 Jan 2006
Posts: 19
|
I used the IBM SWIFT message sets supportpac . Regarding the mapping, it is done as follows.
InputRoot.MRM.field 1 mapped to SW32A.date
InputRoot.MRM.field5 mapped to SW32A.currency
InputRoot.MRM.filed7 mapped to SW32A.Amount.
I don't think it is the input root as I used hardcoded values and still get the CRLF. |
|
| Back to top |
|
|
| wschutz |
| Posted: Mon Jan 23, 2006 1:52 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Do you know that the CRLF is a problem? If you send the message to MERVA/SWIFT, does it get rejected?
I assume the CRLF is showing up because its in the message set. if it turns out to be wrong, you'll need to contact your support person for the SWIFT message set. if you need to find out who that is, you can e-mail me. Thanks -wayne
_________________
-wayne |
|
| Back to top |
|
|
| anshu |
| Posted: Mon Jan 23, 2006 2:17 pm Post subject: |
|
|
Novice
Joined: 23 Jan 2006
Posts: 19
|
Wayne,
It does cause problems at SWIFT. I looked at the SWIFT message set for 32A fields. The amount is defined as decimal with a zero length. I tried the following
1. changed the field type to string
2. kept the field type as decimal with length 15 and used a CAST in my esql to decimal(12,2)
3. kept the field type as decimal with length 0 (default setting)
all 3 give the desired result for the amount field except in all cases it's preceded by the (undesired)CRLF. As I am in control of the SWIFT message setting, not sure if the customer support would be of any help. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Jan 24, 2006 1:49 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi anshu,
Could you please post your Input and Output message by using a trace node.
Regards. |
|
| Back to top |
|
|
| wschutz |
| Posted: Tue Jan 24, 2006 2:56 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
I'd like to see the ESQL you're using to assign the :32A fields (I'm assuming your doing this in a compute node and not using a mapping node) 
_________________
-wayne |
|
| Back to top |
|
|
| anshu |
| Posted: Tue Jan 24, 2006 5:40 am Post subject: |
|
|
Novice
Joined: 23 Jan 2006
Posts: 19
|
| I solved the problem ( I think....) by altering the properties of the SW message set. |
|
| Back to top |
|
|
| woodoo2k |
| Posted: Tue Jan 24, 2006 5:57 am Post subject: |
|
|
Apprentice
Joined: 07 Feb 2005
Posts: 28
Location: USA
|
Could you please put which property of WS message set did you change ?
This will help others having similar problem. |
|
| Back to top |
|
|
|
|
