Anveo Knowledge Base

Frequently Asked Questions / Anveo Mobile App / Found invalid SQL Script

Found invalid SQL Script

Updated

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.