Forge Component
Published on 2018-11-19 by Rui Mendes
18 votes
Published on 2018-11-19 by Rui Mendes
I am using the forge component Webpreviewer to display Base64/pdf content that is stored in the database.
After i installed the component on our environment (java stack) i get an error every time the scheduled job "DeleteFiles" runs.

The error message we get in the errorlog is:
Timer DeleteFiles error (inside action 'DeleteFiles'). Timer duration = 0 secs: Error in advanced query DeleteFiles in DeleteFiles in WebPreviewer (DELETE FROM {FileCache};): ORA-00911: invalid character
 [retry 3 of 3 scheduled]

As stated in the error the advanced query in the timed job contains an invalid character, which i find a bit surprising in such a straight forward delete statement.

Is this a known error?
How can we fix this?
Hi Roel.

Remove the semicolon from the expression.
Since I haven't tested in a java stack, let me know if it worked.

Thanks. Such a small and easy fix!

No more errors.