08-09-2016 02:04 PM
Today I started getting the below error that I have not seen before. It occurs when I try to add a new contact:
"Cannot insert the value NULL into column 'AEM_OPTOUT', table 'SJL3Contacts.dbo.TBL_CONTACT'; column does not allow nulls. INSERT fails. The statement has been terminated."
I am running Act! Pro Version 18.104.22.168, Update 1, on a Windows 7 Pro-64 PC.
Anyone have any suggestions?
08-10-2016 02:40 AM - edited 08-10-2016 02:40 AM
Please could you try the database rebuild and repair procedures detailed in the following Knowledgebase article: http://kb.act.com/app/answers/detail/a_id/19642 and testing after the process has finished?
08-11-2016 11:38 AM
Not resolving the issue.
When I do the Tools > Database Maintenance > Check and Repair, it runs for a while then I get the error “An error has been found. For this to be fixed a database lock will need to be applied and all users will be locked out. Would you like to repair the database now?” I click yes and it runs for a while and then I get “The database has been repaired.” Unfortunately, the issues continue even after this repair. I have tried the repair tool multiple times. No change.
When I try the Act! Diagnostics Utility Database Repair Procedures, I get the original error “Unhandled Exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index” whenever I click the gray rectangle to the left of the appropriate Database name to select the database and choose any option.
08-12-2016 02:25 AM
09-16-2016 12:39 PM
I am having the same problem immediately after upgrading from 18.1 to 18.2.53 Update 2...
I am not able to add a contact nor duplicate a contact (either duplicate contact option).
I am able to add notes, etc... just am not able to add or duplicate contacts. It is obvious that the update caused some sort of db issue. This was not a hot-fix and I hope that SP can step up to handle this issue???
I am not able to create an empty copy of the DB as it gives me the same error.
ACT user for 19 years.
09-19-2016 02:12 AM
Have you tried the rebuild and repair procedures which I reccomended above? http://kb.act.com/app/answers/detail/a_id/19642
09-19-2016 06:05 AM
Yes, I followed the instructions... can not create empty copy of db either... get the same error.
An ACT support person then walked through all of the options with me and still no fix. This certainly seems like the 18.2 db update caused the issue.
09-20-2016 02:50 AM
It sounds like this could be an issue where the database schema is not being properly updated.
Please could you try the steps below to force the database schema to update manually? Make sure you have a backup of your database before proceeding.