Summary

The restoration of an Oracle backup may generate some inconsistencies in Bizagi. This guide is released to help the user to fix the problems that may occur during the startup of Bizagi.

Applies to

Bizagi Engine .NET 10.x with Oracle database

Symptoms

When the user tries to startup Bizagi Web Application after restoring the Oracle database backup an error message is displayed to contact your system administrator. After analyzing the Event logs, an error message similar to this one is found:

Source:

BizAgi.UI

Message:

Application start failed. You may need to update the project.

Stack Trace:

at BizAgi.UI.WFBase.CSite.OnInit(EventArgs e)

at BizAgiBPM._default.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean

includeStagesBeforeAsyncPoint, Boolean

includeStagesAfterAsyncPoint)

-------------------------------------------------------Date Time:

3/22/2015 2:17:20 PM

Source:

mscorlib

Message:

The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.

Cause

Oracle adds blank spaces to some database values when restoring the backup. These blank spaces generate a data-type inconsistency generating the mentioned error.

Solution

In order to solve this problem, please follow the steps below

1. Stop the IIS service and the Scheduler.
2. Log in your Bizagi Schema with the Execution tool like TOAD or SQLPlus using the owner user of the Bizagi schema.
3. Execute the command EXECUTE spBA_Ora_TrimDefaults()
4. Restart the services.