Error while importing XML file into SAP BODS

[Former Member]

Hi Experts,

I am working on SAP BODS, recently i got an xml file generated from SAP PowerDesigner Data Movement Model, I tried to import that xml file into SAP BODS to create Project, but while importing it is showing error as Invalid Expression. The XML file was validated successfully.How to correct this issue.

error:

Thanks in advance

Prasannakumar pendela

[Former Member]

Hello there,

What's your database? Could you check if 'void' is a reserved word for that ddbb?

[Former Member]

hi,

i am using SQL Server database, the VOID is taken as column name in some tables. but mentioned in the Quotations which it considerd as String. and the same column is also present in the TestPK xml file which imported successfully. but dont understand why this RXREPORT xml file is creating issue.

Thanks and Regards

PrasannaKumar

[former_member187605]

The DS import facility can only import .atl files and .xml files generated by DS itself or using the Object creation XML toolkit.

I don't think the PowerDesigner output is compatible with the DS model.

[Former Member]

Hi Dirk Venken

    Thanks for your reply.

      No, DS supports the XML file generated from PowerDesigner DataMovementModel. Actually we already tested the flow also with some sample DMM's.

1.Generated XML file for the DMM created in SAP PowerDesigner

2.In DS, from Tools--> Import from File --> generated XML file.

but for the one i am trying now resulted in error.

I am unable to attach the XML file, as it is more than 1MB

Can you provide me your mail id, so then i can send it to your mail

Thanks in advance

PrasannaKumar

[former_member187605]

Nice, I didn't know that.

As the error message states "<syntax error at line <1>", you could start with posting the first couple of line of the generated xml file.

On another note, because you say you had this working before, why don't you compare those xml files? And look for the word VOID.

[Former Member]

HI,

  Thanks again for responding,

The first lines of XML are as follows,

<?xml version="1.0" encoding="UTF-8" ?>

<DataIntegratorExport formatVersion="1.0" repositoryVersion="14.2.2.0000" productVersion="14.2.2.446" repositoryName="" timestamp="">

<!-- Database to Datastore definition -->

<DIDatabaseDatastore name="PKPHYSICAL" id="34702166-2E1E-4F9D-825D-14724AD585D2" typeId="3" >

<DIAttributes>

<DIAttribute name="DBLiveLoad" value="no"/>

<DIAttribute name="application_type" value="Custom"/>

<DIAttribute name="cdc_enabled" value="no"/>

<DIAttribute name="datastore_repotype" value="local"/>

<DIAttribute name="ds_configuration_enabled" value="yes"/>

<DIAttribute name="ds_configurations" hasNestedXMLTree ="true">

<DSConfigurations>

<DSConfiguration default="true" name="Configuration1">

<case_sensitive>no</case_sensitive>

<database_type>ODBC</database_type>

<odbc_data_source>PK</odbc_data_source>

<odbc_database_type>OTHER</odbc_database_type>

<user>harishankard</user>

<password></password>

</DSConfiguration>

</DSConfigurations>

</DIAttribute>

</DIAttributes>

</DIDatabaseDatastore>

<!-- Database to Datastore definition -->

<DIDatabaseDatastore name="PKTESTPHYSICALCOLLAPSE" id="0247C706-231A-4EDA-BBF0-76B3B57DC191" typeId="3" >

<DIAttributes>

<DIAttribute name="DBLiveLoad" value="no"/>

<DIAttribute name="application_type" value="Custom"/>

<DIAttribute name="cdc_enabled" value="no"/>

<DIAttribute name="datastore_repotype" value="local"/>

<DIAttribute name="ds_configuration_enabled" value="yes"/>

<DIAttribute name="ds_configurations" hasNestedXMLTree ="true">

<DSConfigurations>

<DSConfiguration default="true" name="Configuration1">

<case_sensitive>no</case_sensitive>

<database_type>ODBC</database_type>

<odbc_data_source>NewBigCollap</odbc_data_source>

<odbc_database_type>OTHER</odbc_database_type>

<user>harishankard</user>

<password></password>

</DSConfiguration>

</DSConfigurations>

</DIAttribute>

</DIAttributes>

</DIDatabaseDatastore>

and i also compared with the previous xml file, but didn't found any much difference. and VOID is taken as a Column name in some table. But the previous Sample XML files are also having the same column. but at that time it was successded, now it is not importing.

Thanks in advance

Prasannakumar

[Former Member]

Hello Prasannakumar,

Could you please attach the XSD schema and the XML please?

[Former Member]

Hi Néstor Martínez

       Thanks for responding.

        I am unable to attach the XML file, as it is more than 1 MB.

        Can you provide me your mailID, i will send it to your mail.

Thanks in advance

Prasannakumar

[Former Member]

And....Dropbox, Drive, etc... ?

[Former Member]

Hi Néstor Martínez

I have uploaded into google drive, please visit the link, and please click on Request for Access, i will provide the access for you.

https://drive.google.com/open?id=0B8_EpbTXe3NUUmdjWVUzbmx4Yjg

Thanks in advance

Prasannakumar

[Former Member]

Requested.

Could you also attach one of the XML files that you could import ok?

[Former Member]

Hi,

Yes i gave permission to access, and also attached the XML file (DMM_TestPK_PD2DS) that is imported.

please find the file in the below link

https://drive.google.com/open?id=0B8_EpbTXe3NUakJtZHgycnlPZlE

Thanks in advance

Prasannakumar