**Fixed in 6.2** Issue creating schedule marker with SQL configuration

[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 :

  1. Make sure all of exited out of AyaNova and Generator service stopped
  2. Run your SQL Management Studio on your server
  3. Select your AyaNova database on the left
  4. Click on the menu option New Query
  5. Enter in the text into the query field

alter table anotifyevent alter column asavedmessage nvarchar(1024) NULL

  1. Select menu Execute
  2. Exit out of SQL Management Studio
  3. 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]