Mendix Application has to restart frequently

0
I deploy my Mendix application but notice it need restart frequently to fix the error below.   “Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not exist”.     To fix the issue,    I have to execute a system-created sql script by restarting the Application. The SQL script basically updates DB schema.  Why it need refresh DB schema again and again after the changes have been deployed. Please help, Thanks!   Here is the content from the system-created SQL script. It is auto-created by system and I am asked to execute it when restarting the Application. ===== 20220927_134744_database_commands.sql  ALTER TABLE "Q3MODULE$ATTACHMENTS_QRAS" DROP CONSTRAINT "UNIQ_Q3MO$ATTACH_QRA_Q3MO$QRAS"; ALTER TABLE "Q3MODULE$ATTACHMENTS_QRAS" DROP CONSTRAINT "UNIQ_Q3MO$ATTAC_QR_Q3MO$ATTACH"; DROP INDEX "IDX_Q3MODULE$ATTACHMENTS_QRAS"; ALTER TABLE "Q3MODULE$ATTACHMENTS_QSS" DROP CONSTRAINT "UNIQ_Q3MO$ATTAC_QS_Q3MO$ATTACH"; ALTER TABLE "Q3MODULE$ATTACHMENTS_QSS" DROP CONSTRAINT "UNIQ_Q3MO$ATTACH_QS_Q3MOD$QSSI"; DROP INDEX "IDX_Q3MODULE$ATTACHMENTS_QSS"; … ALTER TABLE "Q3MODULE$ATTACHMENTS" RENAME TO "Q3MODULE$ATTACHMENTSPDF"; UPDATE "SYSTEM$FILEDOCUMENT"  SET "SUBMETAOBJECTNAME" = 'Q3Module.AttachmentsPDF'  WHERE "SUBMETAOBJECTNAME" = 'Q3Module.Attachments'; ALTER TABLE "Q3MODULE$ATTACHMENTS_QRAS" RENAME TO "Q3MODULE$ATTACHMENTSPDF_QRAS"; ALTER TABLE "Q3MODULE$ATTACHMENTS_QSS" RENAME TO "Q3MODULE$ATTACHMENTSPDF_QSS"; ALTER TABLE "Q3MODULE$ATTACHMENTS_QSM" RENAME TO "Q3MODULE$ATTACHMENTSPDF_QSM"; ALTER TABLE "Q3MODULE$ATTACHMENTS_MFGS" RENAME TO "Q3MODULE$ATTACHMENTSPDF_MFGS"; ALTER TABLE "Q3MODULE$MFGS" DROP COLUMN "JOB_FUNCTION"; UPDATE "Q3MODULE$MFGS"  SET "AUTHOR_LOGS" = SUBSTR("AUTHOR_LOGS", 0, 5000); …  SET "CHANGETO" = "2D946C551C9B448CB37642629349A1"; ALTER TABLE "Q3MODULE$MFGS" DROP COLUMN "2D946C551C9B448CB37642629349A1"; DELETE FROM "MENDIXSYSTEM$ATTRIBUTE"  WHERE "ID" = '57c6ecb2-70fb-4234-9db4-e192ed83bd8a'; UPDATE "MENDIXSYSTEM$ATTRIBUTE"  SET "ENTITY_ID" = '02dfc936-f3fd-4cd5-a3d2-43c1b19c70cb', "ATTRIBUTE_NAME" = 'revision', "COLUMN_NAME" = 'REVISION', "TYPE" = 30, "LENGTH" = 200, "DEFAULT_VALUE" = '-', "IS_AUTO_NUMBER" = 0  WHERE "ID" = '72c53da3-38ce-4653-852e-b5247432b601'; UPDATE "MENDIXSYSTEM$ATTRIBUTE"  SET "ENTITY_ID" = '02dfc936-f3fd-4cd5-a3d2-43c1b19c70cb', "ATTRIBUTE_NAME" = 'organization', "COLUMN_NAME" = 'ORGANIZATION', "TYPE" = 30, "LENGTH" = 1000, "DEFAULT_VALUE" = '',    
asked
0 answers