Follow

APP: 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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments