CC error in RFC to File Scenario

[Former Member]

Hi ,

While am trying to do end-to-end test for a RFC to file Scenario. Am getting this below error. Please help me to proceed further.

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 '2008-08-13' too long (>8 for 2. column) - must stop', probably configuration error in file adapter (XML parser error)'

Regards,

Hemanthika

[Former Member · Accepted solution]

Hi,

use the "date transform" function for that date filed convert to required formate.

RFC date FieldDate Transform(Target date YYYYMMDD)targetDateField.

Otherwise change the FixedFieldlength in the FCC.

Regards,

Prakasu

[Former Member · Accepted solution]

Hi ,

Here the value for date from the RFC is in YYYYMMDD format and we have just mapped it on the other end with out any seperators. I am not able to understand why the CC is finding the value YYYY-MM-DD. Suggestions pls

Regards,

Hemanthika

[VijayKonam · Accepted solution]

Did you use the data type as Date in the Data Type definition on the receiver side? If you are writing to a fixed field length file, increase the length to 10 to get rid of the error first. Check in sxmb_moni what is coming in and what is going out after the mapping.

VJ

[Former Member]

Hi,

Please go through this Blog

check this blog on how to configure sender rfc adapter.

I hope it helps,

Regards,

Surya

[Former Member]

Column value '2008-08-13' too long (>8 for 2. column)

-

---

>

Expected length is 8 whereas it is actually 10 in file...

Check FCC fieldFixedLength parameter, it must be expecting 8 for this field

[santhosh_kumarv]

Hi,

If u are using FCC at the receive side check if it is correct. Might be an isssue with the fixedfield length parameter.

Thanks

SaNv...

[Former Member]

>>Column value '2008-08-13' too long

As the error message clearly says this value is exceeding the length limit.

Please check in receiver payload where this value is coming.

It must be 20080813

Thanx

Aamir