cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Variable substitution

Former Member
0 Kudos

Hi Expets,

I am using varaible substitution at receiver side.

My structure is like

PO

File

Header

Record

var1(not specified any length)

var2(not specified any length)

In variable substitution i have given %var1%

var1 -


payload:PO,1,var1,1

This var1 contains only 4 charects but if i check in my runtim work bench i am getting the following error.

Could not process due to error: java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value 'sdsds' too long (>1 for 0. column) - must stop', probably configuration error in file adapter (XML parser error)'

After i have changed var1,1 to var2,1 which have different value but still i am getting the same error.

Please help us in resolving this

Regards

Sowmya

Accepted Solutions (0)

Answers (2)

Answers (2)

prateek
Active Contributor
0 Kudos

I don't think this is variable substitution error. Are you using FCC? If yes, then there seems to be some problem with that.

Regards,

Prateek

Former Member
0 Kudos

Hi,

I have done the same thing for other scenarios and it is working.I am using FCC. I have checked all the FCC parameters and all are fine.

But it is working fine if i am passing one charecter to var1.

My XI system has SP12

what could be the problem

Regards

Sowmya

Edited by: Sowmya on Nov 19, 2008 12:43 PM

SudhirT
Active Contributor
0 Kudos

Hi,

Check what fieldlength you have specified for var1 in FCC parameters.

Thanks!

prateek
Active Contributor
0 Kudos

Try adding the parameter in FCC

NodeName.fixedLengthTooShortHandling = cut

Regards,

Prateek

MichalKrawczyk
Active Contributor
0 Kudos

hi,

do you have adapter specific message attributes (XI 3.0 sp14 at least)

if so don't use variable substitution and start using ASMA

it's much nicer and simpler way to do that

Regards,

Michal Krawczyk

Former Member
0 Kudos

Hi Michale,

I have adapter specific paramters option. But even if i user this option I should use variable substitution to replace the target name with dynamic file name right.

Please suggest me

Regards

Sowmya

former_member194786
Active Contributor
0 Kudos

Hi Sowmya,

In case you are using ASMA its not at all required to use variable substitution. You can directly set the name of the target file using a simple UDF. Refer to Michals blog for the same.

Thanks and Regards,

Sanjeev.