Skip to main content
Question

Event collection - OTC Data Job Error

  • Aug 20, 2020 3:56 PM UTC
  • 3 replies
  • 128 views

Hi all, Id like to run the data job in O2C process conenctor after i connect IBC and SAP ECC. 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

3 replies

  • Aug 21, 2020 7:53 AM UTC
this erro has been closed myself. tks!

  • Jun 19, 2021 8:25 AM UTC

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


  • Jun 20, 2021 8:14 PM UTC

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.