As you may have guessed from my earlier post, I'm trying to complete both client & equipment loads in order to go live.

Earlier this evening, I'd successfully loaded a couple of test files of data & wanted to delete everything & start over with clean data now that the files are ready to go.

As per the instructions, I logged in as the AyaNova Administrator, selcted menu Help -> License & selected the Erase all Data menu option.  I then rec'd the error log attached.

Any suggestions will be greatly appreciated!

Gladys

	Post Attachments
	ayalog.txt (5 views, 69.48 KB)

From the error, I'm thinking that another was logged in or another AyaNova related program was running. To be sure, do the following:

1. Make sure all users are out of the AyaNova program, including yourself
2. Make sure there are no other AyaNova related programs still loaded (none of the Import utilites, not Generator, not WBI, not QBI, not Data Portal etc - double-check none of these are running)
3. Now log in as the AyaNova Administrator on one computer only, select Help -> License -> Erase entire database

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

As I was the only one in working at 10pm last night, I figured I was safe.  I'm positive I was the only user on the program. 

Although at this point the program will not activate.  I tried rebooting the system & when trying to open it, I receive an error (I thought I saw it in the log at the end) and it fails.

Gladys 

I will send the error currently being generated when trying to open Ayanova later today when I have access.

Thank you for your patience-

Gladsy

Without the error message I can not say for certain - but if it is a case that the database has become corrupted, you will want to restore from your backup prior to erasing the database.

Please do post the full text of the error message here and we can go from there.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Well things just keep getting more interesting by the minute......

Launched Ayanova & it came to the login screen.  Logged in as Administrator & it actually opened with the Client test data as it was loaded last night!  However as soon as you touch a Client, receive the following error:  Object reference not set to an instance of an object. Then the program shuts down.  The same result with the subgrids within Client & Units.  Have also logged in with another user id although still an administrator account. 

Checked some of the other grid areas to determine the User (memos & notifications), Service, Quotes, Preventative Maintenance, Inventory & Schedule are cleared or erased. 

Since I'd made the change to the .config to import the client files would that have made any difference?

Any ideas to try?

Thanks -

Gladys

It may be that your database became corrupted during the Erase - not all data was successfully erased and links between tables were therefore corrupted etc.

1. Exit out of AyaNova
2. Ensure no one else or no other program is attaching to the AyaNova database (this includes any anti-virus program)
3. Log in as the AyaNova Administator and go directly to the Help -> License -> Erase entire database
4. The database will erase itself and shut down at the same time.
5. Than log back in and confirm it is erased.

If this does not address the issue, than:

1. Perform the restore of your backup that was made sometime prior to erasing the database - restore as per the instructions for backup up and restore of the network Firebird configuration of AyaNova in the AyaNova v3 Manual section "BACKING UP USING THE NETWORK FIREBIRD SERVER" starting page 587 with the restore instructions starting on page 590.
2. Once you have successfully restored, than perform the erase again - be sure to be logged in as the AyaNova Administrator.

Let me know

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

As recommended, went through the Erase all Data steps again.  Receive the warnings that all data will be erased & the process starts.  Receive the error:

   internal gds software consistency check (partner index description no found 175)

Choice is to Abort, Ignore or Copy All, then the program shuts down.

When relaunching AyaNova receive the attached error then the program shuts down.

Thank you for all your assistance.

Gladys

	Post Attachments
	error.txt (2 views, 1.70 KB)

Did you restore from your backup as suggested? I've copied again below my previous suggestion.

If this does not address the issue, than:

1. Perform the restore of your backup that was made sometime prior to erasing the database - restore as per the instructions for backup up and restore of the network Firebird configuration of AyaNova in the AyaNova v3 Manual section "BACKING UP USING THE NETWORK FIREBIRD SERVER" starting page 587 with the restore instructions starting on page 590.
2. Once you have successfully restored, than perform the erase again - be sure to be logged in as the AyaNova Administrator.

Let me know

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

and sorry for the delay in getting back to you on this. 

Have been trying to determine if a back up had ever been created correctly in this system & unfortunately not.  There is a copy of the database that was made recently.  Is there any way to restore from the copy.  If not, what will be our next step?

Thanks -

Gladys