View just stopped working

Application ID: 94D17EE3-97F1-475D-FFDF-DA02068C4500
Error UID: 9FDA3575-4469-4E93-FFF2-99BB332BE900

Backendless encountered an error while handling the request. An internal trouble ticket with ID 9FDA3575-4469-4E93-FFF2-99BB332BE900 has been created and we will be investigating the issue.
java.sql.SQLSyntaxErrorException: Table '94D17EE3-97F1-475D-FFDF-DA02068C4500.udv.pottpornLive' doesn't exist

Query being executed when exception was thrown:
ALTER VIEW `udv.pottpornLive` (`objectId`,`exhaustDetails`,`exhaustName`,`created`,`dbKiller`,`bikeId`,`exhaustId`,`userId`,`userName`,`soundUrl`,`exhaustObjectId`,`imageUrl`,`profilImageUrl`,`rrId`,`bikeName`,`approved`,`___system_ownerId`) AS select `udt.pottporn`.`objectId` as `objectId`, `rel_udt.pottporn_exhausts_exhaust`.`exhaustDetails` as `exhaustDetails`, `rel_udt.pottporn_exhausts_exhaust`.`exhaustName` as `exhaustName`, `udt.pottporn`.`created` as `created`, `udt.pottporn`.`dbKiller` as `dbKiller`, `rel_udt.pottporn_bikes_bike`.`objectId` as `bikeId`, `rel_udt.pottporn_exhausts_exhaust`.`exhaustId` as `exhaustId`, `rel_udt.pottporn_Users_user`.`userId` as `userId`, `rel_udt.pottporn_Users_user`.`userName` as `userName`, `udt.pottporn`.`soundUrl` as `soundUrl`, `rel_udt.pottporn_exhausts_exhaust`.`objectId` as `exhaustObjectId`, `udt.pottporn`.`imageUrl` as `imageUrl`, `rel_udt.pottporn_Users_user`.`profilImageUrl` as `profilImageUrl`, `rel_udt.pottporn_bikes_bike`.`rrId` as `rrId`, `rel_udt.pottporn_bikes_bike`.`bikeName` as `bikeName`, `udt.pottporn`.`approved` as `approved`, `udt.pottporn`.`ownerId` as `___system_ownerId` from `udt.pottporn` left outer join `pottporn.exhausts.exhaust` as `reltable_udt.pottporn_exhausts_exhaust` on `udt.pottporn`.`objectId` = `reltable_udt.pottporn_exhausts_exhaust`.`rel_from` left outer join `udt.exhausts` as `rel_udt.pottporn_exhausts_exhaust` on `rel_udt.pottporn_exhausts_exhaust`.`objectId` = `reltable_udt.pottporn_exhausts_exhaust`.`rel_to` left outer join `pottporn.bikes.bike` as `reltable_udt.pottporn_bikes_bike` on `udt.pottporn`.`objectId` = `reltable_udt.pottporn_bikes_bike`.`rel_from` left outer join `udt.bikes` as `rel_udt.pottporn_bikes_bike` on `rel_udt.pottporn_bikes_bike`.`objectId` = `reltable_udt.pottporn_bikes_bike`.`rel_to` left outer join `pottporn.Users.user` as `reltable_udt.pottporn_Users_user` on `udt.pottporn`.`objectId` = `reltable_udt.pottporn_Users_user`.`rel_from` left outer join `udt.Users` as `rel_udt.pottporn_Users_user` on `rel_udt.p ... (truncated)


java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Table '94D17EE3-97F1-47

Problem description

Did / changed nothing. View just stopped working.

Steps to reproduce

Please describe steps to reproduce starting from the first action.

  1. Just try to look at the view.

Hello @Torben_Murach

I’ve created an internal ticket BKNDLSS-25767 to investigate your problem

Regards,
Viktor

Hello @Torben_Murach

the issue with view on this app was fixed, please check in your application