Community
Showing results for 
Search instead for 
Do you mean 
Reply

Upgraded to 18.1.103.0 Update 7 and now I can't access database

New Member
Posts: 6
Country: USA

Upgraded to 18.1.103.0 Update 7 and now I can't access database

Everything has been working fine with Act 18 but had a notification about an upgrade so I went ahead.  After I opened updated Act I had an exception while it was converting database.  Now I can't access database or any older (backed up) versions of my database.

 

Tried some of the tricks by deleting .pad and .alf files but no success.  Tried a system restore but that failed.

 

 

The database is shared between 2 computers and I updated both computers (server and client) and have the same problem on both.  Server is running Win 7 Pro and client is running Win 10.  Both have been working nicely for about a year with Act 18.

 

I'm completely stuck !  Please Help. 

New Member
Posts: 6
Country: USA

Re: Upgraded to 18.1.103.0 Update 7 and now I can't access database

Just a quick update.  After trying a number of things with tech support today, still no luck.  I did opt to do the backup before I did the update but wasn't able to use it to restore my database.  Got some object reference error of some kind every time I tried.  

 

However, today I decided to try to create a new database from the backup and that worked !  

 

Now, I just have to try to rename the database to the old name so all the other stuff will work but at least we have access to the data and hopefully we'll be back up running again tomorrow after a completely lost day.

Administrator
Posts: 4,024
Country: United_Kingdom

Re: Upgraded to 18.1.103.0 Update 7 and now I can't access database

Hi Hackermeister.

Thanks for letting us know how you resolved the issue.

It would be interesting to know the exact exception error message you received while upgrading the database. This would be useful to have for other customers experiencing the same issue, who search for the error message.
New Member
Posts: 6
Country: USA

Re: Upgraded to 18.1.103.0 Update 7 and now I can't access database

I was multitasking when i ran the update and didn't pay much attention to the error message except last line said "Exception" when I first started the updated ACT.  I kind of realized as soon as I hit OK I should probably have paid more attention.  The error came during the database conversion that needed to be done after the update.

 

Once I had this error I couldn't open the database.  I tried open a backup copy, I tried do a restore from ACT but it refused to do anything.  Don't know why I didn't think of creating a new database from my backup earlier.

Copper Elite Contributor
Posts: 112
Country: Germany

Re: Upgraded to 18.1.103.0 Update 7 and now I can't access database

We have had similar issues when upgrading older databases to v18. Our best practice since then is to stop the SQL service, take a copy of ADF and ALF to a safe place, restart teh SQL service and then give it a first try to convert the database. As we stop/start the SQL service during that process, this seems to be the actual action healing the problems with the database updates. Since we do that, we never had to redo the database update, they all went through on the first attempt.

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de