on 10-15-2015 8:52 AM
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
Hello there,
What's your database? Could you check if 'void' is a reserved word for that ddbb?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hello Prasannakumar,
Could you please attach the XSD schema and the XML please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.