Skip to main content
Question

Event collection - OTC Data Job Error

  • August 20, 2020
  • 3 replies
  • 5 views
.
Level 0
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

.
Level 0
  • .14600834
  • Author
  • Level 0
  • August 21, 2020
this erro has been closed myself. tks!
A
  • Anonymous
  • June 19, 2021

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

A
  • Anonymous
  • June 20, 2021

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.

Community Code of ConductAccessibility statement