Platform
Learn
Community
Support
Sign up
or
Log in
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Beta
Learn
Training
Documentation
Evaluation Guide
Community
Jobs
Home
Forums
Forge
Ideas
Badges
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Pre Sales Demos
Sign up
or
Log in
Home
Jobs
Forums
Forge
Ideas
Members
Badges
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Forge Discussions
[Web Previewer] Webpreviewer - Timer deletefiles error
Webpreviewer
Invalidcharacter
DeleteFiles
Webpreviewer
Invalidcharacter
DeleteFiles
New Post
New Post
Forge Component
Web Previewer
(17)
Published on 2018-11-19 by Rui Mendes
17 votes
Published on 2018-11-19 by Rui Mendes
Roel Oomens
Posted on 2016-07-01
Roel Oomens
Rank: #7372
Posted on 2016-07-01
Hi,
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?
Rui Mendes
Posted on 2016-07-11
Rui Mendes
Rank: #219
Posted on 2016-07-11
Solution
Hi Roel.
Remove the semicolon from the expression.
Since I haven't tested in a java stack, let me know if it worked.
Cheers
Solution
Roel Oomens
Posted on 2016-07-11
Roel Oomens
Rank: #7372
Posted on 2016-07-11
Solution
Thanks. Such a small and easy fix!
No more errors.
Solution
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Hints and How-To Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...
(hidden) New Badge Popup