Community
Showing results for 
Search instead for 
Do you mean 
Reply

DBFix for schema update.... (Inactive edited by)

Copper Contributor
Posts: 103
Country: Netherlands

DBFix for schema update.... (Inactive edited by)

I am running an Act Premium database with 20 users.

 

Technical environement:

ACT! by Sage Premium 2009 (11.0) Version 11.1.183.0, Hotfix 4

Database schema according to actdiag is: 11.01.0178.0000

Running on Windows XP clients and SBS2008 server. 

 

Problem

During maintenance of the database i run the Actdiag program (11.1.183.0)

When i use the option Database Fixes > Schema update > Fix known schema updates,

the actdiag program comes up with 7 records that need fixing, and as soon as the fixing process is ready, the following message appears:

 

 

 

 

 

 

 

 

 

 

One would think that by fixing these items the database would be in perfect shape again. However, during a NEXT actdiagrun of the same fix actdiag finds again 7 items (most likely the same ones as in run 1), and the programs states that the records have been fixed again with the above message.
This is an ongoing thing. Either the program does not fix the records in such a way that they are fixed for real during this procedure, or something must be wrong with my database.

 

Can anyone comment on having the same issues with their databases?
Can anyone comment on what the nature of this fix within the AcDiagprogram is? Is the error that is being fixed a major or minor one?

 

Any help or comments appreciated!

 

Rene van der Velde

aka The Dutch Betatester



Kind regards,

Rene van der Velde
The Netherlands
aka 'The Dutch Betatester'
Copper Contributor
Posts: 103
Country: Netherlands

Re: DBFix for schema update.... (Inactive edited by)

Update:

 

I also see that this messages pops up when finishing repair of the demodatabase!

 

Does anybody know what is exactly meant when talking about these 7 fixes?



Kind regards,

Rene van der Velde
The Netherlands
aka 'The Dutch Betatester'
Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: DBFix for schema update.... (Inactive edited by)

Did it save a text file on the desktop? Most of the repairs do. If so, post it here

 

If it happens on demo database also, try a new created database. If that also has this error, you might need to uninstall (including removing the ACT7 SQL instance) and reinstall.