The extraction is done, followed by Transformation but failed, details as below -
Error transforming data: SyntaxErrorException: [Vertica]VJDBC ERROR: Relation BSAD does not exist. Celonis Support ID: 473a50a9-aa4b-4f3e-8fc1-b3e280d9ce33
Or you can refer to my screenshot. Actually the data extraction for BSAD Table is done, so im confused why this error shows. image2362697 54.5 KB image18841072 177 KB
Hi sean sean,
Do you by chance still have some detailed information on how you tackled the problem? I am facing the same problem with the table BKPF for the P2P and/or AP processes. Specifically: Error transforming data: SyntaxErrorException: Vertica]]VJDBC](4566) ERROR: Relation "BKPF" does not exist. Celonis Support ID: 3702879a-1437-4c7f-8907-4009bee05025
I created a support case but I am a little under pressure from the project management so I am trying to find an alternative solution.
Many thanks!
Sebastian
Hi again,
Nevemind I figured it out myself.
If anyone has the same problem: For me it was simply down to the fact that I did not extend the "Fiscal Year" filter of the AP Extraction beyond the default value (=2017) and there was no suitable data in the tables, therefore one of them was empty and caused the problem.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.