Community
Showing results for 
Search instead for 
Do you mean 
Reply

New Sync Error Message - Invalid Column Name

Avid Listener
Posts: 40
Country: USA

New Sync Error Message - Invalid Column Name

I have started seeing the following error message pop-up on several of my remote databases. 

Synchronization has failed. Invalid Column Name 'USER 7' Contact your administrator for assistance.

I have seen it with both USER 7 and USER 8 in it. 

I have detached, repaired, re-indexed, etc. without any luck. This is on an XP machine running 2012 Premium with the latest HF installed

Any assistance would be welcome.

Thanks 

David

Copper Elite Contributor
Posts: 233
Country: USA

Re: New Sync Error Message - Invalid Column Name

Hey David,

 

Is this a repost? Did the steps I sent you work?

 

Thanks,

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: New Sync Error Message - Invalid Column Name

Hello David,
We have published a solution for this issue in the following Knowledgebase article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2839...

We have had customers experiencing this issue report the solution was successful for them. Be sure to do the repairs in the order listed in the article.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Avid Listener
Posts: 40
Country: USA

Re: New Sync Error Message - Invalid Column Name

Kurt

 

We were handling this off list. Sorry for the confusion.

 

David

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: New Sync Error Message - Invalid Column Name

Update...we have revised this KB article to include a batch file that should resolve the issue.
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2839...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 133
Country: Canada

Re: New Sync Error Message - Invalid Column Name

I have another remote user who cannot sync anymore - USER8 field.

I ran the batch file, did the repair DB procedure, etc. Still cannot sync.

 

What now?