Skip to Content
avatar image
Former Member

Error while importing XML file into SAP BODS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 15, 2015 at 09:25 AM

    Hello Prasannakumar,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2015 at 11:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Dirk Venken

      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

  • avatar image
    Former Member
    Oct 16, 2015 at 01:00 PM

    Hello there,

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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