Found invalid SQL Script
Symptom
The synchronization process hangs showing the following error message in the text protocol:
234 0 0 NAV_ProcessTask———————– Attempt 1 failed with error The following SQL error was unexpected:
A .NET Framework error occurred during execution of user-defined routine or aggregate “UDP_Execute_SQL_Script_ANVEODELTA”:
System.Exception: found invalid sql script
System.Exception:
at StoredProcedures.checkCommandHash(String checkInputHash, String inputStr)
at StoredProcedures.UDP_Execute_SQL_Script_ANVEODELTA(SqlInt32 EntryNo).
The statement has been terminated.
Cause
An empty record in table ACF SQL is causing the Anveo Delta Server to stop the calculation process.
Solution
Open table ACF SQL and delete all records with an empty value in field Script.