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



Multiple occurrances of same records in... Expand / Collapse
Author
Message
Posted 5/17/2008 11:24:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/25/2008 6:10:03 AM
Posts: 5, Visits: 117
After update from v3 to v4 our head offices grid is showing multiple occurrances of the same record. This has happened for quite a number but not all of the H/O's however when we try to delete the exta records we get an error as there is data that is related and dependant on the head office record.

Pleas help.... It may be faulty indexes or similar .... any ideas ????
Post #4044
Posted 5/17/2008 1:35:46 PM
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 @ 2:47:18 PM
Posts: 1,835, Visits: 4,254
abscon (5/17/2008)
After update from v3 to v4 our head offices grid is showing multiple occurrances of the same record. This has happened for quite a number but not all of the H/O's however when we try to delete the exta records we get an error as there is data that is related and dependant on the head office record.

Pleas help.... It may be faulty indexes or similar .... any ideas ????

Hi

To confirm what you are saying: Before the upgrade, in your AyaNova 3, there was no duplicates of Head Offices, but now there is - correct?

What configuration of AyaNova were you usingt with AyaNova 3 and that you are using with AyaNova 4.1.5 - stand-alone default or network Firebird Server or SQL Express or SQL Server 2000 or SQL Server 2005?

What was the exact full version of AyaNova before you upgraded - Were you using AyaNova 3.6.0.0 before upgrading to AyaNova 4.1.5?

When you first ran AyaNova 4 on your database, did you confirm that no other AyaNova program such as network Generator, dataportal, etc was running?

I would recommend that if your database was 3.6.0.0  to make sure all AyaNova programs are shut down, than restore your AyaNova 3 database again, and than on the server run AyaNova and let it update to AyaNova 4.

If you continue to experience an issue, please send directly to support@ayanova.com the following:

  • copy of your AyaNova 3 database file backup - zipped using WinZip
  • The exact full version of AyaNova 3 before you upgraded to 4.1.5 (i.e. 3.1.0.0, or 3.6.0.0 etc)
  • What configuration was your AyaNova 3 - standalone, network Firebird Server, SQL Express, SQL Server 2000 or SQL Server 2005
  • Is this the same configuration of your AyaNova 4
  • zipped copy of your ayalog.txt from the AyaNova 4 program folder
  • If possible, zipped copy of your ayalog.txt file from your AyaNova 3 program folder.
  • AyaNova Administrator username and password

Do let me know if restoring from backup and repeating the upgrade steps fixes this, as well as answers to the info above, or if redoing that does not work, that you will be sending the information and database requested.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4046
Posted 5/19/2008 1:03:41 PM
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 @ 2:47:18 PM
Posts: 1,835, Visits: 4,254
Hi again

We have not received a copy of the database and the details via direct email - did restoring from backup and redoing the upgrade again resolve this issue that you experience?  Do let me know either way, and if not resolved, do send the requested information so that we can help troubleshoot why this is occurring.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4048
Posted 6/8/2008 9:58:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/25/2008 6:10:03 AM
Posts: 5, Visits: 117
Hi Joyce,

Sorry we did not see the reply come in for sometime, been very busy.

We will zip up the data and email you the appropriate information asap.

Regards Tracy
Post #4084
Posted 6/9/2008 10:38:28 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 @ 2:47:18 PM
Posts: 1,835, Visits: 4,254
Hi again Tracy, have not yet received? Do let me know.

Also, do subscribe toyour post so that you are notified when a reply is made. See the forum topic http://forum.ayanova.com/Topic36-60-1.aspx for details.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4087
Posted 6/24/2008 9:09:37 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 @ 2:47:18 PM
Posts: 1,835, Visits: 4,254
Unfortunately, still have never received additional information on this topic to be able to help point the user in the right direction. As it has been some time since they initially posted, more than likely it was is a case of the user mis-reading a grid and as there is no issue, there was no posting back.

If anyone else experiences a similar issue, please do always send requested information right away so that the issue can be resolved right away.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4129
« 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:16am

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