Community
Showing results for 
Search instead for 
Do you mean 
Reply

Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

Copper Contributor
Posts: 83
Country: NZ

Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

This error occurs whenever the user tries to edit the Company field in an Act! v17.1 Pro database (MSSQL 2012 64bit installed on a Win 2012 Server 64bit) recently upgraded from Act! 2000. There might be a linkage to Handheld Contact but not sure at this stage. The DB seemed ok to start with, but then the problem developed very quickly. I created a copy of the DB & that tested ok. Then reconfigured HHC to work with the new DB & initiated the sync. The error manifested itself immediately. But as I say, I am not sure if there is a relationship with HHC. It is the first time I have installed Act! with MSSQL 2012 + HHC. Any help appreciated.

Copper Contributor
Posts: 83
Country: NZ

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

A corection to my previous post.  MSSQL 2014 was installed, not MSSQL 2012.

Copper Super Contributor
Posts: 659
Country: Netherlands

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

i i have the exact same issue with Premium 17.1 

its not possible to link a contact to an existing company.

HHC is not installed. (123sync is )

SQL 2014 express is used

Otto Lanjouw
www.relact.nl
Copper Super Contributor
Posts: 659
Country: Netherlands

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

created a copy of the database

first time logged in i was able to add a contact to company

logged of and back in and unfortunately the same error again

Otto Lanjouw
www.relact.nl
Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

We have the same issue in a client implementation (Act! Premium 17,1 on SQL 2014 Express). Error is occuring on server and RDBs on Win 7 and Win 8 laptops with SQL 2014 Express. Brand new database (one addon installed - Exponenciel's Excel Quote/Invoice Maker II). Tried recreating the publisher (save copy as) and rebuilding RDBs - no joy.

 

Demo database appears to fucntion correctly. All ACTDIAG stuff run. Swiftpage support (UK) arent aware of this and have recommended database rebuild (which would be OK if it werent already a brand new database).


Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

I'm wondering if this is an issue with a linked field and the Company field that the Contact field is linked to doesn't allow nulls?  Just a wild guess.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

Thanks Stan - rational guess (and I appreciate your time) but I've narrowed it down to 'Company Preferences'...

 

If Company Creation threshold is set to anything other than '0', the problem manifests itself.

 

By resetting to '0', the problem goes away, so at least I have a workaround in the short term.

 

There's still some underlying issue here though. I have no mandatory fields in my database - either in the Contact or Company entity. The only Linked Fields are the default ones. There are no custom fields in the Company entity (just a couple in the Contact entity).

 

I've tested this again in the Demo DB and that doesnt exhibit the same symptoms (even with Company Creation enabled).

 

Could be a bug I guess.

 

 


Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

Are there values in the default sorting list for Companies?


Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
Copper Elite Contributor
Posts: 118
Country: United_Kingdom

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

Yes, it's just sorting by Company Name.

Will Ingleby
ACT! Certified Product Specialist

Solutions for Accounting & CRM (UK)

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Cannot insert the Value NULL into column "ROWID1", table [db name].CTL.SYNCROW_ADD; Column does not allow Nulls. Insert Fails.

Oh well.  Just a stab in the dark.  Act! Development is looking into the issue.  Hopefully they'll have a fix soon.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!