Answered

Database upgrade error - system cannot find BizAgi.EntityManager.dll

I wish to use the sample database with the Process Automation 2 eLearning course. I have downloaded the SQL server backup file and restored it into a new Bizagi project that I have created in which I'll run the tutorial. I use the steps for restoring a project from the Bizagi documentation: stop scheduler, restore bak into Bizagi\Projects\Database, reset IIS. When I attempt to open the restored project, I am prompted to upgrade the database to which I respond OK. After a pause I receive an error message:

"Error updating database: Could not load file or assembly 'file:///C:\Program FIles\Bizagi\Bizagi Studio\MC\BizAgi.EntityManager.dll' or one of its dependencies. The system cannot find the file specified."

I am using Bizagi Studio/Engine v10.6.1.2075. I receive the same error trying to open/upgrade the project in Bizagi Studio or Bizagi Mgmt Console. When I check the folder in question, I do not see the specified file.

Operating System is WIndows 7. I am operating in a development mode.

Thanks in advance for any troubleshooting insight that can be provided.

photo
0

Dear Jeffrey Puuri,

We would like to know if you have restored the database in SQL Server no into the folder.

Please stop the IIS and the scheduler and then go to C:\Bizagi\Projects\[Project]\Temporary and delete all files and folders. After that, try again.

We look forward

Regards

photo
0

Prior to initiating my post yesterday, I had browsed this forum for similar issues previously encountered and saw the suggestion for stopping IIS and removing files from the project's Temporary folder. I had tried that, but it didn't seem to work.

I re-ran all the steps again, this time naming the project and the database after the name inside the database backup file downloaded from the lesson website, but I still receive the message.

Here is the complete rundown of steps I took:

Bizagi Studio:

Create new Bizagi project called AutoII in C:\Bizagi\Projects

Project folder is C:\Bizagi\Projects\AutoII

Bizagi Management Console:

Open Existing Project AutoII and stop scheduler

SQL Server Mgmt Studio:

Restore 'Initial database.bak' (downloaded from link in Process Automation 2 lesson) as:

C:\Bizagi\Projects\AutoII\Database\AutoII_dat.mdf

C:\Bizagi\Projects\AutoII\Database\AutoII_log.ldf

using overwrite option

command prompt (run as administrator):iisreset /stop

Windows Explorer: Navigate to C:\Bizagi\Projects\AutoII\Temporary

Delete all files/folders

Bizagi Management Console: (because I would like to restart scheduler)

Open an existing project: Select AutoII from the list

Receive prompt: The database AutoII in server [Servername] is outdated, you want to upgrade the database now?

Press Yes

After some processing time I am returned a message box entitled 'Final' with the message: Cannot update project:Error updating database: Could not load file or assembly 'file:///C:\Program Files\Bizagi\Bizagi Studio\MS\BizAgi.EntityManager.dll' or one of its dependencies. The system cannot find the file specified.

During the time it was processing (after pressing yes to the db upgrade prompt, but before the error message box) a db backup file called AutoII_2015-7-9-5-50-50.bak was created in the C:\MSSQL\MSSQL12.MSSQLSERVER\MSSQL\Backup folder, so it is getting that far in the upgrade process before failing on the file not found condition.Thanks for your response to my question.Jeff Puuri

photo
0

Dear Jeffrey,

According this problem, please copy and paste BizAgi.EntityManager.dll file from Studio folder to MC folder.

Regards

photo
0

Thank you Juan, your last suggestion solved the issue. The database upgraded successfully and appears to operational now in Bizagi Studio.

Thanks!

Jeff Puuri