Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fields in the database tables do not appear in re-imported table

There is already existing datastore pointing to Oracle 9i  with the tables imported, which are acting as the source in the jobs.The jobs run perfectly well here.When I changed the configuration of the datastore to 11g database and re-imported the tables,some fields in the structure are lost.What I mean by this is that, the fields are present on the database but they do not appear in the re-imported tables.The fields in 9i and 11g database are exactly same.Hence the job throws error since it is unable to find the source fields for mapping.

If I do not re-import the tables after changing the configuration, the structure is retained and job runs well. I do not understand why the fields are lost during re-import when they are present on the database.

Please help!

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question