Database table does not exist (database Query)

Help Activities
,
#1

how do i skip database table when it does not exist ? i want to continue my workflow even when the database table doesn’t exist.

this is my error:

Execute Query: ERROR [42S02] [Oracle][ODBC][Ora]ORA-00942: Tabel of view bestaat niet.

#3

Hi @Nightowl_music ,

You can enclose this flow in try catch block and can continue with you next activities.

Regards,
Sanjit Pa

#4

hello i hav 5 Query’s so put them al in 1 try catch block?

#5

Hi @Nightowl_music,

Yes, you can put all those queries in the try block and in the catch block you can use the Log message activity for the thrown exception.

Regards,
Sanjit Pal

#6

he still stops with the error

image
image1236×521 28.4 KB

#7

log message is in finally

#8

@Nightowl_music

You are running the process in Debug mode because of that it’s getting stopped here. You can click on Ignore button in Debug Tab to continue with next steps.

#9

how is that in production?

#10

@Nightowl_music

If you running the process in Normal without Debug mode then it will continue with the next steps even if any exception occurred as you enclosed thise activities inside Try block.

#11

thanks mate!

1 Like