PLCSQL Link - Support
Back

Error/status codes from the PLCSQL Link controller

Here is the complete list of possible error/status codes:

0:    SQL_Controller - PLCSQL Link controller not called yet. PLC in STOP? Is the block called?
1:    SQL_Controller - SQL Controller was reset, trying to connect.
6:    SQL_Controller - All DB Blocks checked and ok
10:   SQL_Controller - All LogParm and RecipeParm arrays checked and ok
20:   SQL_Controller - Connected, waiting for MySQL Server Greeting...
30:   SQL_Controller - Initialize and send MySQL login request, wait for response
100:  SQL_Controller - SQL Login packet 1 was send
130:  SQL_Controller - Processing login response header received from SQL Server
150:  SQL_Controller - Login completed successfully - ready for log or recipe request
200:  SQL_Controller - Send Get Query and reset DBs
205:  SQL_Controller - Query String Build Request completed
220:  SQL_Controller - Query Request Send completed
231:  SQL_Controller - Data from SQL server values was succesfully transferred to user program
232:  SQL_Controller - Log Data server was succesfully accepted and saved in SQL server

1001: SQL_Controller - SQL Controller Timeout - giving up (Max retries reached)

2000: SQL_Client - Not started yet. No status for license received.
2101: SQL_Client - License key for the current CPU serial number was accepted
2102: SQL_Client - License key for the current MMC/Memory card serial number was accepted
2200: SQL_Client - License key missing
2201: SQL_Client - Error CPU license. Length of CPU serial number does not match the entered license key
2202: SQL_Client - Error MMC license. Length of Memory Card serial number does not match the entered license key
2301: SQL_Client - Error license key. Checksum error in given license key. Please check the license key input for typing errors
2401: SQL_Client - Error CPU license. CPU license key does not match to the current CPU serial number
2402: SQL_Client - Error MMC license. MMC license key does not match to the current memory card serial number

3000: SQL_ReadDataStream was reset
3001: SQL_ReadDataStream - SQL Server Login OK
3002: SQL_ReadDataStream - SQL Info message from Server received
3003; SQL_ReadDataStream - Stored Procedure Completed, Retval=RowCount
3004: SQL_ReadDataStream - Processing Row Token
3101: SQL_ReadDataStream - SQL Server Login Error
3102: SQL_ReadDataStream - Too large packet received from SQL server. Increase size of Data Block SQL_Receive
3103: SQL_ReadDataStream - Too large or invalid packet received from MySQL server. PLCSQL Cannot handle this packet size. Please reduce data.
3104: SQL_ReadDataStream - SQL Error message from Server received
3105: SQL_ReadDataStream - Unknown Token received. Status.Retval=Token
3106: SQL_ReadDataStream - No data found in database for the current request
3107: SQL_ReadDataStream - Too large packet received from SQL server. TCP Packet size larger than defined in Setup
3108: SQL_ReadDataStream - Invalid ParamID in recipe from SQL Server 
3109: SQL_ReadDataStream - WHILE loop exception in SQL_ReadDataStream. (was errorcode 3103 in PLCSQL Link version < 2.6
3150: SQL_ReadDataStream - MySQL Error response received
3151: SQL_ReadDataStream - MySQL OK response without rowcount received
3152: SQL_ReadDataStream - MySQL resultset response with rowcount received
3154: SQL_ReadDataStream - MysqL Invalid number received
3201: SQL_ReadDataStream - Error Token, 0xAA. Error in BLKMOV SQL_Receive.CurrentOffset->DefineMsg.Text
3202: SQL_ReadDataStream - BLKMOV error in Recipe_ParamString
4401: SQL_TCP - SendDB is too small for the current request
4402: SQL_TCP - Query data length exceeded max size
7101: SQL_CheckDB - DB error. SQL_Send Data Block used as network send buffer is not accessible
7102: SQL_CheckDB - DB error. SQL_Receive Data Block used as network Receive buffer is not accessible
7103: SQL_CheckDB - DB error. SQL_Setup Data Block used for configuration of PLCSQL Link is not accessible
7104: SQL_CheckDB - DB error. SQL_RecipeParm Data Block used for configuration of PLCSQL Link is not accessible
7105: SQL_CheckDB - SQL_CheckDB - DB error. SQL_LogParm Data Block used for log data is not accessible
7106: SQL_CheckDB - DB error. SQL_Query Data Block used for preparing SQL Query is not accessible
7111: SQL_CheckDB - DB error. SQL_Send Data Block used as network send buffer is write protected
7112: SQL_CheckDB - DB error. SQL_Receive Data Block used as network Receive buffer is write protected
7113: SQL_CheckDB - DB error. SQL_Setup Data Block used for configuration of PLCSQL Link is write protected
7114: SQL_CheckDB - DB error. SQL_RecipeParm Data Block used for configuration of PLCSQL Link is write protected
7115: SQL_CheckDB - DB error. SQL_LogParm Data Block used for log data is write protected
7116: SQL_CheckDB - DB error. SQL_Query Data Block used for preparing SQL Query is write protected
8121: SQL_CheckArray - Error in array datatype for SQL_LogParm.ParamREAL. RetVal=Source.DataType
8122: SQL_CheckArray - Error in array datatype for SQL_LogParm.ParamINT. RetVal=Source.DataType
8123: SQL_CheckArray - Error in array datatype for SQL_LogParm.ParamDINT. RetVal=Source.DataType
8124: SQL_CheckArray - Error in array datatype for SQL_LogParm.ParamBOOL. RetVal=Source.DataType
8125: SQL_CheckArray - Error in array datatype for SQL_LogParm.ParamSTRING. RetVal=Source.DataType
8126: SQL_CheckArray - Error in array datatype for SQL_RecipeParm.ParamREAL. RetVal=Source.DataType
8127: SQL_CheckArray - Error in array datatype for SQL_RecipeParm.ParamINT. RetVal=Source.DataType
8128: SQL_CheckArray - Error in array datatype for SQL_RecipeParm.ParamDINT. RetVal=Source.DataType
8129: SQL_CheckArray - Error in array datatype for SQL_RecipeParm.ParamBOOL. RetVal=Source.DataType
8130: SQL_CheckArray - Error in array datatype for SQL_RecipeParm.ParamSTRING. RetVal=Source.DataType
8241: SQL_CheckArray - Error, cannot access first element in array:  "SQL_LogParm".ParamREAL. RetVal=BLMOV.RetVal
8242: SQL_CheckArray - Error, cannot access first element in array:  "SQL_LogParm".ParamINT. RetVal=BLMOV.RetVal
8243: SQL_CheckArray - Error, cannot access first element in array:  "SQL_LogParm".ParamDINT. RetVal=BLMOV.RetVal
8244: SQL_CheckArray - Error, cannot access first element in array:  "SQL_LogParm".ParamBOOL. RetVal=BLMOV.RetVal
8245: SQL_CheckArray - Error, cannot access first element in array:  "SQL_LogParm".ParamSTRING. RetVal=BLMOV.RetVal
8246: SQL_CheckArray -  Error, cannot access first element in array:  "SQL_RecipeParm".ParamREAL. RetVal=BLMOV.RetVal
8247: SQL_CheckArray - Error, cannot access first element in array:  "SQL_RecipeParm".ParamINT. RetVal=BLMOV.RetVal
8248: SQL_CheckArray - Error, cannot access first element in array:  "SQL_RecipeParm".ParamDINT. RetVal=BLMOV.RetVal
8249: SQL_CheckArray - Error, cannot access first element in array:  "SQL_RecipeParm".ParamBOOL. RetVal=BLMOV.RetVal
8250: SQL_CheckArray - Error, cannot access first element in array:  "SQL_RecipeParm".ParamSTRING. RetVal=BLMOV.RetVal

ALSMATIK A/S | Lollandsgade 2 | DK-6400 Sønderborg | Denmark | Tel.: +45 74 43 46 84 | www.alsmatik.dk