Ayanova upgrade 4.2 to 7 failure

I am trying to upgrade to Ayanova 7. After setting it up on a new server, I was able to install Ayanova and Firebird successfully. When I copied the data file (after turning off Firebird on the old server), I try to run Ayanova 7. I get this message:


AyaNova was unable to start

Depending on how early in startup the problem occurred,
a detailed log of the problem with suggestions may have
been saved to the file AyaLog.txt
located at: file:\C:\Program Files\Ground Zero Tech-Works Inc\AyaNova

Error details:
Unhandled Exception:
Exception has been thrown by the target of an invocation.
Inner exception type: System.ApplicationException
Inner exception message:

*** FATAL ERROR SCHEMA UPDATE FAILED ***
CONTACT TECHNICAL SUPPORT IMMEDIATELY

unsuccessful metadata update
key size exceeds implementation restriction for index “IDX6_AVENDOR_CVR”

What should I do?
thanks

Hi jfarlow

This is occurring because your original database is oriignally from 3.x and has not been indexed for use with Firebird Server 2.1 yet - which is easily done by backing up the database and restoring it using Firebird.

Steps to resolve:

If your AyaNova configuration is for network Firebird do the following: