AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Database error Expand / Collapse
Author
Message
Posted 3/10/2006 9:06:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 6/26/2006 5:29:19 PM
Posts: 6, Visits: 28
AyaNova seems to have taken a dive on us.  When we try and access the DB, we get the error in the attached:

When we click OK, we get into the Workorders window, but no workorders are present.  We have rebooted the server.

Post #935
Posted 3/10/2006 9:24:21 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
Hi

Please zip up your AyaNova database file SCDATA.SC using WinZip and attach it to an email directly to support@ayanova.com

Include in your direct email message your manager password

Also include your username and password please

We will take a look at the database and get right back to you.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #936
Posted 3/10/2006 10:52:55 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
In this instance a workorder record had become corrupted. We repaired the database and reset the internal indexes for workorders.

The AyaNova database can become corrupt because of various reasons.

The AyaNova CE Manual technical section "Repairing the AyaNova Database" outlines possible causes that can than be remedied on your network.

The five main causes of database corruption are:

  1. Database is suspect/corrupted because of interrupted write operation - computer crashed or network lost power etc
  2. Faulty networking hardware - network wiring, network cards, hubs etc chatter, or are faulty
  3. Opening and saving the file in another program
  4. Jet database engine version is older than 04.00.4331
  5. Mismatched versions of the Jet database engine - different computers on the same network accessing the same database have different versions

For AyaNova CE users that may encounter an error message logging into AyaNova CE, the AyaNova CE Manual and the AyaNova CE Technical Answers web page http://www.ayanova.com/AyaNovaCE/faq_technical.htm also contains information on issues and errors that may occur with AyaNova CE, and recommended solutions.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #937
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 1:19am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 10 queries. Compression Disabled.