cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion error ? Can anyone help?

Former Member
0 Kudos

The Error that shows is :

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 6: missing structure(s) before type 'headerData'

What could be the possible reason for this error? It is urgent and poits to be rewarded. Thanks in advance.

My structure is like the one below :

<HEADER>

<.Field1..>

< Field2 >

....

</HEADER>

<headerData>

<fields>

....

</headerData>

<itemData>

<fields>

....

</itemData>

<textData>

<fields>

...

</textData>

<Footer>

<fields>

.....

</Footer>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello ,

Please construct the Query.I didnt get you...

With Regards,

Vidya

Former Member
0 Kudos

In the Sender Communication channel I have configured as follows for the above structure.

Header.fieldNames : Header Fields

Header.fieldFixedLenghts : Some numeric Values

Header.keyFieldValue : 4

headerData.fieldNames : header data fields

headerData.fieldFixedLenghts : some numeric values

headerData.keyFieldValue : 1

itemData.fieldNames : item data fields

itemData.fieldFixedLenghts : some numeric values

itemData.keyFieldValue : 2

textData.fieldNames : text data fields

textData.fieldFixedLenghts : some numeric values

textData.keyFieldValue : 3

Footer.fieldNames : footer data fields ()

Footer.fieldFixedLenghts : some numeric values

Footer.keyFieldValue : 5

Header.lastFieldsOptional : yes

headerData.lastFieldsOptional : yes

itemData.lastFieldsOptional : yes

textData.lastFieldsOptional : yes

Footer.lastFieldsOptional : yes

ignoreRecordsetname : true

The Recordset structure is : Header,1,headerData,,itemData,,textData,*,Footer,1

There is a common keyfield in Header, headerData, itemData, textData and Footer, which is REC_TYPE.

stefan_grube
Active Contributor
0 Kudos

I think in the source file, the first line does not have the key field 4, what is expected as header line. As the header line is the first line in your configuration, there must not be any other line before.

Regards

Stefan

Former Member
0 Kudos

if u r using fieldFixedLenghts , make sure all values of target are getting populated

because if you use fieldFixedLenghts, it expects value in each element

Former Member
0 Kudos

I checked the source file and the first field is having value "4". Also there is no other line bofore it.

&#65279;4GIPS2SAP.DAT GIPS ME P.R .TRANSMISSION 20071002200710021901GIPS ME TORINO 0000000#

10027879961 00662522 PL11619 12PL11031000 PL11031000ZDUM 33610 PL11EUR

227879961 120071002N.2 BANCHI PER RACCOLTA STILLICIDIO KONIECZNY 000000000001000EA 2007113000000500000

327879961 1001FORNITURA N°2 BANCHI PER RACCOLTA STILLICIDIO PER #

327879961 1002LINEA LAVORAZIONE TESTE CILINDRI. #

10027879958 00662522 PL11619 14PL11031000 PL11031000ZDUM 33610 PL11EUR

227879958 120071002NUOVI SAG PER LINEA BASAMENTO MOTORE KONIECZNY 000000000001000EA 2007113000000500000

327879958 1001Fornitura scaffali a gravita per materiali della #

327879958 1002linea di lavorazione besamento motore. #

10027879959 00662522 PL11619 13PL11031000 PL11031000ZDUM 33210 PL11EUR

227879959 120071002FORNITURA PEDANE ANTIFORUNISTICHE KONIECZNY 000000000001000EA 2007113000000500000

327879959 1001FORNITURA E POSA DELLE PEDANE ANTIFORTUNISTICHE PER #

327879959 1002LINEE DI LAVORAZIONE BASAMENTO MOTORE E TESTE #

327879959 1003CILINDRI COME DA SPECIFICA DEL 10/09/2007. #

5GIPS2SAP.DAT GIPS ME TEXAS 000 0 0 0000015##################################################################

stefan_grube
Active Contributor
0 Kudos

Have you set 'Recordest Sequence' to variable?

Otherwise you are not allowed to use repeating structures.

Former Member
0 Kudos

Thanks Stefan. It started to pick the files.

Former Member
0 Kudos

Hi Stephan,

The file we have is a .dat File type.

We renamed it to .txt for testing purpose and uploaded it to the application server via std. R/3 program interface.

The problem is :

All fields are coming but except the Header data is not coming. Is there any problem because we renamed the file to .txt? Also do let me know the following :

We are getting the source file as .dat . If we upload the same .dat file to the application server, the file adapter is not picking the data. Will there be any problem if we have such a file type? Also what would be the solution for having data being picked by the file adapter.? How can we acheive this? Any thing to do on the configuration side? Please let me know. Urgent....

Answers (3)

Answers (3)

Former Member
0 Kudos

Require some more information.

Former Member
0 Kudos

I think where u r missing out is a root element which is why the error states xml conversion failed start , you could also try "ignore record set structure"

hope it helps

Former Member
0 Kudos

Hi I tried with the "ignore record set structure", but the same error is coming.

GabrielSagaya
Active Contributor
0 Kudos

I think the problem is in FCC Parameters.

Can you please post the complete content conversion parameters??