IBM Support

What do the reason codes in the ASN8999D and similar ASN8xxxD messages mean?

Question & Answer


Question

Is there a list of the return or reason codes in the ASN8999D and similar ASN8xxxD messages?

Answer

ASN8999D and similar ASN8xxxD messages are diagnostic messages to provide additional documentation in the event of a program error. The messages are not formally documented and can be changed or deleted based on programming requirements. These messages supplement the formal product messages which are messages with a prefix of ASN and a suffix of E, I or W.

Examples of ASN8xxxD messages include:
ASN8001D "Capture" : "ASN" : Unexpected return code "902" from routine "pruneCDNormal".

ASN8007D "Capture" : "ASN" : Freed hex "10800" bytes of ECSA at address "21656800".

ASN8045D "Apply" : "CVEMLAIL" : "Initial" : Thread "Initial" received return code "2001" from exiting thread "WorkerThread".

This document provides a list of the return or reason codes that may be issues in the ASN8999D and similar ASN8xxxD messages.

400 Function Completed successfully. Informational reason codes may be returned.
401 Row combined when added to transaction
402 Row consumed when added to transaction
403 No transaction memory obtained
404 No transaction. End of log reached.
405 No transaction. Log limit reached.
406 Skip restart from early driver
407 Decode detected no changed columns
408 CD trigger suppressed insert
409 No data capture on source
410 Required CD column missing or wrong type
411 Did some work
412 reached trans memory limit
413 no CD table when trying to prune
414 no row match (eg for update/delete)
415 No more active workers
416 "?" parameter on command line
417 Error, but stop_on_error=N
418 Partial dangled LF/DL list
419 Global signal encountered
420 No valid LSN returned
421 MgID already exist in ADMMSGS
422 Change application code page
423 Function did nothing
424 Dependency already exists
425 Signal sent by p2pSchemaError
426 logrdr has less node than qResMsg
427 logrdr has more node than qResMsg
428 LobId could not be found
429 No double byte codepage
430 No codepage blank was set
431 Table version not in version table
432 addRow row ignored.
433 Table version must be recorded
434 End of data for processing reached
435 Old dummy table versions must be recorded
436 BRF table with only ADDCOL (no ALTER DATATYPE)
438 Large malloc failure to be retried
499 Please no larger warning codes

500 MQ Errors
501 MQ connect error
502 MQ get error
503 MQ put error
504 MQ open error
505 MQ disconnect error
506 MQ close error
507 MQ get for delete error
508 MQ syncpoint failed
509 MQ begin failed
510 MQ back failed
511 MQ queue empty
512 MQ queue not empty
513 MQ queue doesn't exist
514 MQ inquire error
515 Invalid attribute in MQ q/object def
516 MQ unexpected reason code
517 MQ msg not found
518 MQ spillq logically gone
519 Invalid non-Q Replication MQ message

600 Function failed. The failure was caused by invalid specification of the request or by an invalid state detected by the function.
601 Something exists, but shouldn't
602 Something doesn't exist, but should
603 Invalid parameter
604 State is incorrect
605 Something bad in MQ message
606 Bad subscription. Not a fatal error
607 Subscription not found. Not fatal
608 Try the request later
609 Bad architecture level
610 No license
611 Bad mapping; not fatal
612 Key expression and XML expression defined, not fatal
613 Try the request later
614 A function timed out
614 Regular agent waits for a state transition
615 Spill agent stops
616 Monster agent rolls back transaction
617 Disable the subscription
618 Invalid MCG parm
619 Invalid MCG state

800 Function failed. The failure was caused by a condition or logic error in the operating system.
801 Out of storage condition. Cannot get storage from OS.
802 Could not create thread
803 Could not create required file, i.e. log file or trace file.
804 Could not create an external IPC queue.
805 Could not get/set a valid IPC key.
805 Could not write to an external IPC queue.
806 Error opening file
807 Error on file seek
808 Error on file read
809 Error on file write
810 Error on file close
811 Error on file remove
815 Could not attach to an external IPC queue.
816 Could not read from an external IPC queue.
817 Error in the content of an IPC message.
818 Error setting global signals mask.
819 Error from pthread_setspecific
820 Error from setEnvVars
821 Load not supported for the environment
822 Error from export function
823 Bad codepage
824 Timeout waiting for reply
825 Wrong IPC version
826 Warning or error from db2flsn
827 Error from POPEN
828 Program not APF authorized
829 Data set dynamic allocation error
899 Last environment error code

900 The 900 series is a failed function. The failure was caused by a condition or logic error in the DBMS.
901 Error on EXEC of static SQL
902 Error on EXEC of prepared SQL
903 Error on SQL PREPARE
904 Error on OPEN
905 Error on FETCH
906 Error on DESCRIBE
907 Error on CONNECT
908 Error on CLOSE
909 Error on EXEC IMMEDIATE
910 Error on sqlurlog call
911 Error on COMMIT
912 Error on BIND
913 Error manipulating DB context
914 Unexpected error code from the DB
915 -911 or -913 from dbms
916 User signaled error
917 -117 on CD insert
918 Could not determine DB2 instance
919 Error on DECLARE
920 Table is empty
921 DBMS object is undefined
922 More than 1 row
923 Error on sqloipth call
924 Database has been recovered
925 Database has been rolled forward
926 SQL0204
927 Table full (-289 or -904)
928 DB2 is down (-1032)
929 DB2 is quiesced
930 Could not query DB2 state
931 DB2 release is not supported
932 Error on ROLLBACK
933 Conflicting update/insert/delete
934 Error on update/insert/delete
935 Referential integrity constraint violated
936 +100 row not found
937 -803 duplicate row
938 row not found but a row with the the same keys exists (WHERE clause too restrictive)
939 Database transaction log full sql0964
940 Not enough authority for sqlmonss
941 Version-based conflict I/U/D/KU
942 Error on SQL VALUES
943 Stored procedure CALL failed
944 Error on SET REGISTER
945 Unique constraint violation (803)
946 Stored procedure not found
947 P2P Key Update(+100)=>Insert
948 Error executing
949 Empty source select statement
950 Error preparing classic statement
951 Error fetching number of columns
952 DB2 subsystem attach error
952 RRS not active error
953 Lost data in the log buffer
954 Buffered insert asynchronous error
955 Resource not available error(-904)
956 MaintModeSTT has been called, retry transaction
957 MRI-related errors (potential bugs)
990 Error using statements
991 Error setting the RIB structure
992 Error on checking the statement syntax
997 Unique cst violation (803) empty spill queue
998 Used in asntdsql.SQC, indicate end of a fetch
999 Last database error code

1000 Function failed. The failure was caused by a logic error on the part of the function called.
1001 Either
(1) Could not initialize lock.
(2) Could not get the lock.
(3) Could not release the lock.
The protected structure state is undefined.
1002 Unimplemented feature encountered
1003 Not enough of something. Should appear with another error message such as out of memory (ASN0543E).
1004 Value not in expected range
1005 a thread attempts to unlock it has not locked first

2000 Function failed. Must terminate either normally or abnormally.
2001 Stopped by operator
2002 Invalid parameters specified on startup
2003 Required source server DBMS not specified
2004 Another capture is already processing the database
2005 Setup is wrong. One ore more of the required tables does not exist.
2006 At least one thread is stopped and can not be restarted but not all
2007 All threads are stopped not be restarted
2008 RecoveryMgr setup failed
2009 RecoveryMgr induced thread term
2010 RecoveryMgr recursion
2011 Thread stopped itself; no error
2012 Thread stopped because of an error
2013 stop_on_error termination
2014 MQ message out of place (Q Apply)
2015 Stop when a timestamp is reached
2016 Agent stopped because browser thread is stopping
2017 Handle Sync request from Q Capture
2018 SQL restart info bad, must run MIGRATE=Y

3000 Start trace failed. Must terminate.
3001 Compression dictionary permanently gone
3002 Unknown log variation.
3003 Base table altered
3006 Capture synchtime older than laglimit
3007 Compression dictionary temporarily gone
3008 Editproc error - dump taken
3010 Alter data type pre z/OS V10.1
3011 Transaction has DDL process that needs to be finished
3012 Unsuccessful try to parse DDL statement
3013 After DDL conversion, nothing is left
3014 Unexpected log record header information

4000 The subscription is disabled
4001 The subscription state is not as expected
4002 Subscription encountered error or conflict
4003 Source and target types are incompatible
4004 Incompatible source and target lengths
4005 Source and target types are incompatible

5000 Cannot open ICU converter
5001 Cannot convert to unicode
5002 Cannot convert from unicode
5003 Warning that data has been truncated
5004 Unknown/bad format of data
5005 Codepage conversion is needed
5006 UCS conversion error
5500 Unknown data type
5501 Column type category not set
5502 Can not allocate memory for generating escape sequence for reserved character
5503 Bad data, could not convert, warning
5504 XML parser error
5505 Trailing LOBs cannot be applied to XML
5506 Oversized LOB/XML data cannot be applied to the target
5600 Invalid format for skiptrans
5601 Transaction to skip not present on the receive queue
5602 Skipping transaction is not allowed
6000 Restart queue does not exist
6001 Administration queue does not exist
6002 Queue manager not available
6003 Unexpected MQ message length
6004 Invalid MQ message version
6005 Internal coding error
6006 Missing subkey
6007 Duplicate subkey
6008 Send queue maximum message size too small
6009 No subscription in IBMQREP_SUBS table
6010 Invalid subscription
6011 Missing queue name in signal
6012 Subscription already activated
6013 Subscription not activated
6014 Wrong value in signal
6015 Invalid signal type
6016 Subscription is invalid pre state regarding a state transition
6017 Source column not exist
6018 Invalid subscription predicate
6019 No base table column in subscription predicate
6020 LUW partitioned table
6021 Incorrect administration message type
6022 Missing name type in REQUESTVALIDATION signal input
6023 Missing subname in REQUESTVALIDATION signal input
6024 No more space in buffer
6025 The maximum message size defined for a queue has been exceeded
6026 Subscribed source not a table
6027 Error converting code page for administration message
6028 Subscription has no key columns
6029 A queue has been invalidated
6030 Q Capture has to be stopped on queue error
6031 Transient MQ error
6032 Unexpected MQ error - capture to stop
6033 Invalid half state
6034 Invalid subscription state
6035 Maximum number of send queues is exceeded
6036 Incomplete signal input
6037 Invalid signal for the subscription
6038 Subscription has no load phase
6039 Subscription is in error
6040 LOB column specified as a key source column
6041 Some columns are not subscribed in peer-to-peer
6042 Version column errors
6043 Predicate exists
6044 Base table has no primary key
6046 Row operation was expected to be flagged as a row LOB operation
6048 Invalid subscription type
6049 Invalid subscription state in database
6050 No LOB message found
6051 Invalid message format
6052 Invalid load phase
6053 Invalid row number
6054 Invalid source column options
6055 Long column specified as a key column
6057 Invalid before values
6058 Invalid changed columns
6059 Row operation not flagged as XML
6060 Wrong capture_load parameter
6061 Invalid ignore transaction criteria
6062 From log -> LOB is not inline in log
6063 Pending stop at EOL condition reached
6064 A commit time exceeds a Q Capture up to time
6065 Log fetching thread ended unexpectedly
6066 Generic error for unsupported feature
6067 Retry publishTrans on firstDML
6068 Table not found in database
6069 Invalid schema subscription
6070 Invalid excluded schema

7000 Queue not found in catalogs

8000 No parameters, general conversion error
8001 Unknown or unsupported data type
8002 General parse error
8003 General decoding decimal error
8004 Error in OCCI setting statement parameters
8005 Unsupported DDL encountered
8006 Log file name could not be retrieved
8050 LogMiner dictionary mismatch
8051 LogMiner invalid SQL_REDO
8052 LogMiner no supplemental log data
8053 LogrdOra not initialized
8054 LogMiner failed to start
8055 LogMiner needs a log file added
8056 LogMiner fetch failed
9000 Error during create socket
9001 Error during bind socket
9002 Error while trying to listen on socket
9003 Error during select call on socket
9004 Error during accept call on socket
9005 Error during accept call on socket
9006 Error during accept call on socket
9007 Error during accept call on socket
9008 Too many client connections
9009 Error during send operation on socket
9010 Error during read operation on socket
9011 Error during getaddrinfo call on socket
9012 Error during create socket
9013 Error during accept call on socket
9014 Retryable error connecting to socket
9015 Error during connect to socket
9016 Retryable error during send on socket
9017 Error during send operation on socket

[{"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0.0;9.7;10.2.1.0","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"8.1;8.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21177206