Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

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
asma created the topic: error integration data on a flat file from a stage
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)....
sqlexport_2017-03-20.PNG


thanks a lot!
Asma
Attachments:
Last Edit: 21 Mar 2017 17:39 by asma.
More
22 Mar 2017 17:33 #2 by Thomas BLETON
Thomas BLETON replied the 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 ;)