Skip to main content

FairCom SQL error codes 13000 - 15999

Table 1. SQL errors 13000 - 13513

Value

Symbolic constant

Description

13000

FCREPL_WARNING, RCES_WARNING

RCES warning error code

13001

FCREPL_CONFIG_ERR, RCES_CONFIG_ERR

Couldn't initialize the configuration object

13002

FCREPL_LOGGER_ERR, RCES_LOGGER_ERR

Couldn't initialize the logger object

13003

FCREPL_NOTIF_ERR, RCES_NOTIF_ERR

Couldn't initialize the notification object

13004

FCREPL_FILESYSTEM_ERR, RCES_FILESYSTEM_ERR

Couldn't initialize the filesystem object

13005

FCREPL_PROVIDER_ERR, RCES_PROVIDER_ERR

Couldn't initialize the data provider object

13006

FCREPL_INVARG_ERR, RCES_INVARG_ERR

Invalid argument count

13007

FCREPL_INVARGVAL_ERR, RCES_INVARGVAL_ERR

Invalid argument value. This can occur if an element is missing from a connection string, such as a missing or invalid user name or password when connecting to the sever.

13008

FCREPL_MISARG_ERR, RCES_MISARG_ERR

Missing required argument

13009

FCREPL_HASHFULL_ERR, RCES_HASHFULL_ERR

Hash table exceeded the max size

13010

FCREPL_MEM_ERR, RCES_MEM_ERR

Memory allocation error

13011

FCREPL_QUEUEFULL_ERR, RCES_QUEUEFULL_ERR

Queue exceeded the max size

13012

FCREPL_INVACTION_ERR, RCES_INVACTION_ERR

Invalid notification action

13013

FCREPL_QUEUE_ERR, RCES_QUEUE_ERR

Queue is not initilized

13014

FCREPL_MUTEX_ERR, RCES_MUTEX_ERR

Mutex is not initilized

13015

FCREPL_PROCTHRD_ERR, RCES_PROCTHRD_ERR

Mutex is not start the process thread

13016

FCREPL_ACTION_ERR, RCES_ACTION_ERR

Invalid action

13017

FCREPL_DB_TYPE_ERR, RCES_DB_TYPE_ERR

Mismatch provider DB type

13018

FCREPL_LOCALCT_ERR, RCES_LOCALCT_ERR

Couldn't load local c-tree library

13019

FCREPL_SESSION_ERR, RCES_SESSION_ERR

Couldn't allocate ctree session

13020

FCREPL_INVFLD_ERR, RCES_INVFLD_ERR

Invalid field number

13021

FCREPL_SCHEMATHRD_ERR, RCES_SCHEMATHRD_ERR

Couldn't start schema update thread

13022

FCREPL_INTERN_ERR, RCES_INTERN_ERR

Internal error

13023

FCREPL_REPL_ERR, RCES_REPL_ERR

Couldn't initialize the replication object

13024

FCREPL_INVREPLOBJ_ERR, RCES_INVREPLOBJ_ERR

Invalid replication object

13025

FCREPL_STARTED_ERR, RCES_STARTED_ERR

Already started error

13026

FCREPL_CONSUMER_ERR, RCES_CONSUMER_ERR

Consumer not found

13027

FCREPL_ALREADYEX_ERR, RCES_ALREADYEX_ERR

Already exists error

13028

FCREPL_INVFILTYP_ERR, RCES_INVFILTYP_ERR

Invalid file type

13029

FCREPL_INVFILVOL_ERR, RCES_INVFILVOL_ERR

Invalid file volume

13030

FCREPL_REPLNDEP_ERR, RCES_REPLNDEP_ERR

replication plan is not deployed

13031

FCREPL_MISAUTH_ERR, RCES_MISAUTH_ERR

Missing authentication information

13032

FCREPL_FTRNSFR_ERR, RCES_FTRNSFR_ERR

File transfer not initialized

13033

FCREPL_REPLACT_ERR, RCES_REPLACT_ERR

replication plan is not stopped

13034

FCREPL_REPLNFOUND_ERR, RCES_REPLNFOUND_ERR

replication plan is not found

13035

FCREPL_INUSE_ERR, RCES_INUSE_ERR

Entity is in use

13036

FCREPL_MISREPL_ERR, RCES_MISREPL_ERR

Missing replication plan error

13037

FCREPL_MISDB_ERR, RCES_MISDB_ERR

Missing database in subscription

13038

FCREPL_MISVOL_ERR, RCES_MISVOL_ERR

Missing volume information

13039

FCREPL_FNOTFOUND_ERR, RCES_FNOTFOUND_ERR

File not found error

13040

FCREPL_INVSUBS_ERR, RCES_INVSUBS_ERR

Invalid subscription

13041

FCREPL_INVPATH_ERR, RCES_INVPATH_ERR

Invalid file path

13042

FCREPL_INVFUNC_ERR, RCES_INVFUNC_ERR

Invalid function

13043

FCREPL_INVOS_ERR, RCES_INVOS_ERR

Invalid opSystem

13044

FCREPL_NOTRUN_ERR, RCES_NOTRUN_ERR

Thread is not running

13045

FCREPL_NACTIVE_ERR, RCES_NACTIVE_ERR

replication plan is not started

13046

FCREPL_MISLPOS_ERR, RCES_MISLPOS_ERR

replication plan is missing log position

13047

FCREPL_NCONN_ERR, RCES_NCONN_ERR

Agent is not connected

13048

FCREPL_INVTOK_ERR, RCES_INVTOK_ERR

Invalid token, it can be wrong or expired.

13049

FCREPL_DBINUSE_ERR, RCES_DBINUSE_ERR

DBEngine is in use

13050

FCREPL_REPLAGENT_ERR, RCES_REPLAGENT_ERR

Replication agent error

13051

FCREPL_MASTERNOTRDY_ERR, RCES_MASTERNOTRDY_ERR

Master server is not ready yet

13052

FCREPL_MISSUBS_ERR, RCES_MISSUBS_ERR

Replication doesn't have any Subscription

13053

FCREPL_TARFIL_ERR, RCES_TARFIL_ERR

Target file already exists

13054

FCREPL_REPLDISC_ERR, RCES_REPLDISC_ERR

Replication agent is disconnected

13055

FCREPL_RESYNC_ERR, RCES_RESYNC_ERR

Replication resync failed

13056

FCREPL_INRESYNC_ERR, RCES_INRESYNC_ERR

Replication is in a resync operation now

13057

FCREPL_EREPLFILE_ERR, RCES_EREP

Replication doesn't have any file

13058

FCREPL_CANCELLED_ERR, RCES_CANCEL

Operation has been cancelled

13059

FCREPL_RESTORE_ERR, RCES_RESTORE_ERR

File dump restore error

13060

FCREPL_SQLPORT_ERR, RCES_SQLPORT_ERR

SQL Port mismatch

13061

FCREPL_REPLEXIST_ERR, RCES_REPLEXIST_ERR

replication plan information already exist

13062

FCREPL_NINACTIVE_ERR, RCES_NINACTIVE_ERR

replication plan is not inactive

13063

FCREPL_NARCHIVED_ERR, RCES_NARCHIVED_ERR

replication plan is not archived

13064

FCREPL_MISPROV_ERR, RCES_MISPROV_ERR

Missing data provider

13065

FCREPL_MEMUNMG_ERR, RCES_MEMUNMG_ERR

Not possible to mark Memphis as unmanaged

13066

FCREPL_FTINSUP_ERR, RCES_FTINSUP_ERR

FTI not supported

13067

FCREPL_DELEXCEP_ERR, RCES_DELEXCEP_ERR

Not able to clean Replication Exceptions

13068

FCREPL_SYSCONSUMER_ERR, RCES_SYSCONSUMER_ERR

Not possible to control system consumer

13069

FCREPL_MISLIB_ERR, RCES_MISLIB_ERR

Missing library

13070

FCREPL_TDBNCONN_ERR, RCES_TDBNCONN_ERR

DBEngine doesn't accept external connection, but it is required. Target server is required to accept external connection because of the Resync and Deploy actions

13071

FCREPL_SDBNCONN_ERR, RCES_SDBNCONN_ERR

Source DBEngine doesn't accept external connection, but it can be ok if the replication plan is in PUSH mode

13072

FCREPL_MEMRONLY_ERR, RCES_MEMRONLY_ERR

Not possible to mark Memphis as readonly

13073

FCREPL_NEVERRONLY_ERR, RCES_NEVERRONLY_ERR

DBEngine doesn't support readonly mode

13074

FCREPL_HAMULTIPRI_ERR, RCES_HAMULTIPRI_ERR

Multiple primary replicas

13075

FCREPL_HAMISPRI_ERR, RCES_HAMISPRI_ERR

Missing primary replica

13076

FCREPL_INVPRIREPL_ERR, RCES_INVPRIREPL_ERR

Replica conflict on existing Replication

13077

FCREPL_AVAILNDEP_ERR, RCES_AVAILNDEP_ERR

Avail Group not deployed

13078

FCREPL_AVAILFAIL_ERR, RCES_AVAILFAIL_ERR

Avail Group switch failed

13079

FCREPL_AVAILASYNC_WRN, RCES_AVAILASYNC_WRN

Avail Group doesn't have a sync replica to failover, but it is ok

13080

FCREPL_AVAILASYNC_ERR, RCES_AVAILASYNC_ERR

Avail Group doesn't have a sync replica to failover, and should fail

13081

FCREPL_AVAILACTIVE_ERR, RCES_AVAILACTIVE_ERR

Avail Group is not inactive

13082

FCREPL_DBINACTIVE_ERR, RCES_DBINACTIVE_ERR

DBEngine is not active

13083

FCREPL_REPLLATENCY_ERR, RCES_REPLLATENCY_ERR

replication plan is too behind

13084

FCREPL_REPLFILTERERR_ERR, RCES_REPLFILTERERR_ERR

Failed to update replication file filter

13085

FCREPL_CLIENTMEMGRID_ERR, RCES_CLIENTMEMGRID_ERR

Client memory grid not available

13086

FCREPL_PUBMODE_ERR, RCES_PUBMODE_ERR

Current publication mode is not compatible

13087

FCREPL_MISSYM_ERR, RCES_MISSYM_ERR

Missing symbol in a dynamic library

13088

FCREPL_DB_NFOUND_ERR, RCES_DB_NFOUND_ERR

DBEngine not found physically

13089

FCREPL_REBUILD_ERR, RCES_REBUILD_ERR

Superfile rebuild error

13090

FCREPL_PUB_NFOUND_ERR, RCES_PUB_NFOUND_ERR

Couldn't find any valid publication

13091

FCREPL_AVAILEXIST_ERR, RCES_AVAILEXIST_ERR

Availability Group exists for DBEngines

13092

FCREPL_NULL_RETURN_ERR, RCES_NULL_RETURN_ERR

Function call returned NULL

13093

FCREPL_INVSTATUS_ERR, RCES_INVSTATUS_ERR

Invalid status

13501

RCESDP_MEM_ERR, FCREPLDP_MEM_ERR

Couldn't allocate memory

13502

RCESDP_INVHDL_ERR, FCREPLDP_INVHDL_ERR

Invalid handle

13503

RCESDP_INVSTR_ERR, FCREPLDP_INVSTR_ERR

Invalid connection string

13504

RCESDP_PREPARE_ERR, FCREPLDP_PREPARE_ERR

Error during the SQL command prepare

13505

RCESDP_MORE_RESULT, FCREPLDP_MORE_RESULT

There are more record to be retrieves

13506

RCESDP_INVFILETYPE_ERR, FCREPLDP_INVFILETYPE_ERR

Invalid file type

13507

RCESDP_INVARG_ERR, FCREPLDP_INVARG_ERR

Invalid argument

13508

RCESDP_MISSYM_ERR, FCREPLDP_MISSYM_ERR

Missing symbol

13509

RCESDP_CIRFIL_ERR, FCREPLDP_CIRFIL_ERR

Circular file replication

13510

RCESDP_NOFILE_ERR, FCREPLDP_NOFILE_ERR

Empty publication

13511

RCESDP_TOOMANYF_ERR, FCREPLDP_TOOMANYF_ERR

Too many temporary files

13512

RCESDP_MISSING_ERR, FCREPLDP_MISSING_ERR

Missing elements

13513

RCESDP_TOOSMALL_ERR, FCREPLDP_TOOSMALL_ERR

Buffer too small



Table 2. SQL errors 14000 - 14999

Value

Symbolic constant

Description

14101

SAF_SUBSCRIBED

Instance has already been subscribed

14102

SAF_NOT_SUBSCRIBED

Instance has not been subscribed yet

14103

SAF_MEMORY

Not able to allocate memory

14104

SAF_ARG_MISSING

Missing argument

14105

SAF_ARG_INVALID

Invalid argument

14106

SAF_NOT_ACTIVE

Not active

14201

MQTT_NSUP

Feature not supported yet

14202

MQTT_PERACT

Persistence already active

14203

MQTT_PERNFOUND

Persistence not found

14204

MQTT_MISPARM

Parameter missing

14205

MQTT_SCHMMIS

Schema mismatch

14206

MQTT_NOMEMORY

Not able to allocate buffer

14207

MQTT_INVMSG

Invalid message

14208

MQTT_NSUP_VER

MQTT API unsupported version

14209

MQTT_MIS_DB

MQTT API missing database

14210

MQTT_MIS_OP

MQTT API missing operation

14211

MQTT_MIS_TOPIC

MQTT API missing topic

14212

MQTT_NOT_CONN

MQTT not able to connect

14213

MQTT_SSL_FAIL

MQTT SSL connection failed

14214

MQTT_REPL_ERR

Not able to turn replication ON

14215

MQTT_OLIM_ERR

MQTT purge period is out of limits

14216

MQTT_MISPROP

Missing persisted property in message

14217

MQTT_INVVALUE

Invalid persisted value

14218

MQTT_INVALTER

Invalid alter persistence operation

14219

MQTT_FILE_ERR

Not able to open/create file

14221

MQTT_INUSE_ERR

Client ID is already in use

14222

MQTT_INVFMT_ERR

Invalid format

14223

MQTT_AIDX_ERR

Array index is not found

14224

MQTT_SUBS_ERR

Client ID is already a subscriber

14225

MQTT_NSUBS_ERR

Client ID is not a subscriber

14226

MQTT_TIMEOUT_ERR

MQTT time out

14227

MQTT_MSGID_ERR

Sent message ID not found

14228

MQTT_INVPARM

Invalid parameter value

14229

MQTT_INVOPSTATUS

Invalid operation for current status

14230

MQTT_SAFDISABLED

Store&Forward is not enabled, but it is required

14231

MQTT_TABLENAME

Table name not found

14232

MQTT_MISTS

Table is missing the auto timestamp field

14233

MQTT_MISBROKER

Remote broker not found

14234

MQTT_LOCALBROKER

Remote broker is set for the local one

14235

MQTT_BROKERUSE

Remote broker is in use

14236

MQTT_TOPICNFOUND

Topic not found

14237

MQTT_SESSNFOUND

Session not found

14238

MQTT_SUBSBROKER

Not able to subscribe to external broker

14239

MQTT_NOT_ACTIVE

Not active

14240

MQTT_TALIAS_ERR

Topic Alias is out of bounds

14241

MQTT_GROUP_ERR

Invalid shared subscription group name

14242

MQTT_CONN_NFOUND

Connection not found

14243

MQTT_INVTOPIC

Invalid topic name

14244

MQTT_MIS_PARAMS

MQTT API missing params

14245

MQTT_PARAM_MAX

MQTT parameter exceeds the maximum length

14246

MQTT_LISTNFOUND

MQTT listener not found

14301

FCMQ_MEM_ERR

Not able to allocate memory

14302

FCMQ_NSUP_ERR

Not supported yet

14303

FCMQ_INVBRK_ERR

Invalid broker settings file

14304

FCMQ_TIMEOUT_ERR

Connection timeout

14305

FCMQ_CONN_ERR

Connection error

14306

FCMQ_MISPARM_ERR

Missing required parameter

14307

FCMQ_INVPARM_ERR

Invalid parameter value

14308

FCMQ_BRKRNFOUND_ERR

Broker connection is not found

14309

FCMQ_TABLENFOUND_ERR

Table publication is not found

14310

FCMQ_ACTION_ERR

JSON Action failed

14311

FCMQ_CREATESESSION_ERR

Not able to create session

14312

FCMQ_INVALIDRESP_ERR

Not able to create persistence

14313

FCMQ_TOPICNFOUND_ERR

Topic not found

14314

FCMQ_INVMSG_ERR

Invalid message

14401

CTOPC_STARTED_ERR

Plugin already started

14402

CTOPC_MEM_ERR

Not able to allocate memory

14403

CTOPC_MISARG_ERR

Missing required argument

14404

CTOPC_INVARG_ERR

Invalid argument

14406

CTOPC_SCHMMIS

Schema mismatch

14407

CTOPC_INVSET

Invalid settings

14408

CTOPC_INVCALL

Invalid call

14409

CTOPC_MISSYM_ERR

Missing symbol

14410

CTOPC_CLIENT_ERR

OPC server error

14420

PLUGIN_OPCUA_ERROR

OPC UA PLC returned an error

14421

PLUGIN_MODBUS_ERROR

Modbus PLC returned an error

14422

PLUGIN_AB_ERROR

Allen-Bradley PLC returned an error

14423

PLUGIN_SIEMENSS7_ERROR

Siemens S7 PLC returned an error

14501

TW_STARTED_ERR

Plugin already started

14502

TW_MEM_ERR

Not able to allocate memory

14503

TW_MISSYM_ERR

Symbol not found

14504

TW_CSDK_ERR

C-SDK error

14505

TW_NULL_ERR

NULL parameter

14506

TW_NSUP_ERR

Not supported

14507

TW_INVARG_ERR

Not supported

14508

TW_OVERFLOW_ERR

Lost overflow

14601

SCHEMA_TOO_SHORT

the binary UDT message provided is too short - shorter than the schema would expect

14602

SCHEMA_TOO_LONG

the binary UDT message provided is too long - longer than the schema would expect

14603

SCHEMA_STR_LEN_MISMATCH

the binary UDT's "actual string length" is greater than the binary UDT's "max string length"

14604

SCHEMA_STR_TOO_LARGE

actual and/or maximum string length (from the binary UDT message) are larger than the limit of 253

14605

SCHEMA_STR_INV_PADDING

Invalid string padding in the binary UDT

14606

SCHEMA_STR_GREATER_SCHEMA

binary UDT's "max string length" is greater than the schema's "max string length" (for example, "String[32]")

14607

SCHEMA_STR_MISMATCH_SCHEMA

binary UDT's "max string length" does not match the schema's "max string length" (for example, "String[32]")

14700

JSONNAV_MISSING_PARAM

JSONNAV_UNKNOWN_PARAM

JSONNAV_INVALID_PARAM_VALUE

A required JSON property is missing, invalid, or has an invalid value.

14701

JSONNAV_UNKNOWN_METHOD

The method provided does not exist or is not available.

14702

JSONNAV_WRONG_PARAM

JSONNAV_INVALID_METHOD_PARAM

JSONNAV_MISSING_METHOD_PARAM

A required JSON parameter property is the wrong data type, has an invalid value, or is missing.

14703

JSONNAV_INTERNAL_ERROR

JSONNAV_NOTYET_PARAM

A jsonAction internal error was encountered. Report this to FairCom.

14704

JSONNAV_TRANSPORT_ERROR

An error in the transport protocol was encountered.



Table 3. SQL errors 15000 - 15026: flat-file storage system

Error code

SQLSTATE value

Class condition

Subclass message

15001

60601

FairCom DB SQL FF errors

FF- File IO error

15002

60602

FairCom DB SQL FF errors

FF- No more records

15003

42603

Access violation error

FF- Table already exists

15004

22604

Data exception

FF- Invalid record number

15005

60605

FairCom DB SQL FF errors

FF- Record deleted

15006

60606

FairCom DB SQL FF errors

FF- Invalid type

15007

60607

FairCom DB SQL FF errors

FF- Duplicate value

15008

08608

Connection exception

FF- Database exists

15009

08609

Connection exception

FF- No database found

15010

60610

FairCom DB SQL FF errors

FF- Version mismatch

15011

60611

FairCom DB SQL FF errors

FF- Virtual file cache exceeded

15012

60612

FairCom DB SQL FF errors

FF- Physical file open error

15013

60613

FairCom DB SQL FF errors

FF- Corrupt virtual file handle

15014

22614

Data exception

FF- Overflow error

15021

60615

FairCom DB SQL FF errors

FF- dbm_calls not implemented

15024

60616

FairCom DB SQL FF errors

FF- Data exceeds max field length supported

15026

60616

FairCom DB SQL FF errors

FF- Max columns per table exceeded