[forum note: issue no longer occurs with latestAyaNova 6.2]
Issue occurs withConfiguration: network configured for use with SQL Server or SQL Express only (does not occur with stand-alone or network Firebird)
Issue: When performing step #12 of the network Generator setup http://www.ayanova.com/AyaNova6webHelp/network_generator_installation.htmtesting the Generator whereattempt to create a new schedule marker for a user subscribed to “Schedue Marker - JustCreated” will get the following error:
>Exception has been thrown by the target of an invocation. —> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column ‘ASAVEDMESSAGE’, table ‘AyaNova.dbo.ANOTIFYEVENT’; column does not allow nulls. INSERT fails.
Solution :
- Make sure all of exited out of AyaNova and Generator service stopped
- Run your SQL Management Studio on your server
- Select your AyaNova database on the left
- Click on the menu option New Query
- Enter in the text into the query field
alter table anotifyevent alter column asavedmessage nvarchar(1024) NULL
- Select menu Execute
- Exit out of SQL Management Studio
- Start your Generator, and run AyaNova and log in. You will now be able to create a new schedule marker for a user that is subscribed.
This issue will be resolved automatically in the next maintenance update if applicable.
[forum note: issue no longer occurs with latestAyaNova 6.2]