Upgrade 6.x issue for some standalone or network Firebird users

AyaNova 1.x - 6.x AyaNova 3.x to 6.x
1

If your database was originally an AyaNova 3.x database, and you perform the upgrade steps to AyaNova 6.x, you may encounter the following error:

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.
System.Reflection.TargetInvocationException

Inner exception:
*** FATAL ERROR SCHEMA UPDATE FAILED ***
CONTACT TECHNICAL SUPPORT IMMEDIATELY

No message for error code 335544351 found.
No message for error code 335544434 found.

This is due to the original database not having been formated to take advantage of new larger index sizes of Firebird 2

If your AyaNova configuration is for stand-alone use (single computer) do the following:

  1. Zip up your AYANOVA.FDB database file using WinZip

(if you are upgrading from AyaNova 3, the folder location may be C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3

</SPAN>Or if a Windows XP or 2003 computer, this is in the C:\Documents and Settings\All Users\Application Data\AyaNovaData folder or if a Vista or Windows 7 computer this is in the C:\ProgramData\AyaNovaData folder)

  1. Attach to an email to support@ayanova.com

  2. Include the error message you receive in your email (so we know why you are sending the database)

  3. Include your AyaNova Administrator username and password

  4. We will re-index your database and send it back to you

  5. You will delete your existing AYANOVA.FDB and extract the AYANOVA.FDB sent back to you and complete the update steps

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

This issue will not occur if your database was originally a 4.x or higher database, or if you have restored your network database from backup at some time previously.

2

If upgrading to AyaNova 6.x or 7.x, and you get the following error:

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

unsuccessful metadata update
key size exceeds implementation restriction for index “IDX6_AVENDOR_CVR” —> FirebirdSql.Data.FirebirdClient.FbException: unsuccessful metadata update
key size exceeds implementation restriction for index “IDX6_AVENDOR_CVR” —> unsuccessful metadata update
key size exceeds implementation restriction for index “IDX6_AVENDOR_CVR”
— End of inner exception stack trace —
at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
at GZTW.AyaNova.BLL.DBManager.Schemalizer.DataPortal_Update()
— End of inner exception stack trace —
at GZTW.AyaNova.BLL.DBManager.Schemalizer.DataPortal_Update()

If your AyaNova configuration is for stand-alone use (single computer) do the following:

  1. Zip up your AYANOVA.FDB database file using WinZip

(if you are upgrading from AyaNova 3, the folder location may be C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3

Or if a Windows XP or 2003 computer, this is in the C:\Documents and Settings\All Users\Application Data\AyaNovaData folder or if a Vista or Windows 7 computer this is in the C:\ProgramData\AyaNovaData folder)

  1. Attach to an email to support@ayanova.com

  2. Include the error message you receive in your email (so we know why you are sending the database)

  3. Include your AyaNova Administrator username and password

  4. We will re-index your database and send it back to you

  5. You will delete your existing AYANOVA.FDB and extract the AYANOVA.FDB sent back to you and complete the update steps

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

.