Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Deleted error integration data on a flat file from a stage

More
20 Mar 2017 17:08 - 21 Mar 2017 17:39 #1 by asma
error integration data on a flat file from a stage was created by asma
hi,

I m trying to apply a transformation of a column in an flat file txt. so, i did a mapping having the flat file (.txt) as a source a stage (query) to apply the transformation and the final flat file (.txt) as target.

But when i execute the mapping i have an error. could you plz help me to resolve it, if you have an idea about it?
the screenshot of the error is attached.
You do not have permissions to access this page.
You do not have permissions to access this page.


the error is :
java.sql.SQLSyntaxErrorException: ORA-00923: mot-clé FROM absent à l'emplacement prévu
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)....

thanks a lot!
Asma
Attachments:
Last edit: 21 Mar 2017 17:39 by asma.
More
22 Mar 2017 17:33 #2 by Thomas BLETON
Replied by Thomas BLETON on topic error integration data on a flat file from a stage
Hi,
This kind of error should not occur in a mapping with standard templates.
Can you please send an "Export models and dependencies" of your mapping to the Support team ?
They will look into this ;)