Skip to Content (Press Enter)
2018-06-04 08-06-09
Peter Van Den Ochtend
158Views
2Comments
[Warmup] Installing / Publishing warmup fails because incorrect SQL
Question
Forge
warmup
Web icon
Warmup (O11)
Forge asset by Wei Zhu

When trying to install the application it fails on module warmup.

When inspecting that module it seems that there are two advanced queries that call the [OSSYS_ESPACE_SCREEN] table directly. That fails with the error "Invalid SQL
OSSYS_ is a reserved prefix in GetScreen."

How did you make this work?

0
0
04 Apr 2017
Copy Link
2021-06-21 12-37-59
Wei Zhu

Unfortunately, it seems we can not access the systems table (ossys_xxx) any more.

So the best way is to create view on those tables and use view instead of table.



0
0
04 Apr 2017
Copy Link
2018-06-04 08-06-09
Peter Van Den Ochtend

Hello Wei Zhu,

I've used a different trick to go around that check and without adjusting the SQL database (because in some environments like ours or cloud, you don't have database access).

Please check my adjustments in the query and give me some feedback/thoughts.

Warmup_custom_query.oap
0
0
05 Apr 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.