No. 2000 ~ 2999

2001: Completed successfully with warnings or additional information.

• Cause: The function has concluded successfully but with warnings or additional information related to the results.

• Action: Check the warnings and additional information with the GetDiagField() function.

2002: DSN (Database Source Name) file was not found.

• Cause: DSN file could not be found.

• Action: Check the dsn file in the 'client/config' directory under the database home directory.

2003: DSN (Database Source Name) file is corrupted.

• Cause: DSN file is corrupted.

• Action: Check the dsn file in the 'client/config' directory under the database home directory.

2004: DSN (Database Source Name) file format is invalid.

• Cause: DSN file format is invalid.

• Action: Check the dsn file in the 'client/config' directory under the database home directory.

2005: Username is too long: must be less than 128 bytes.

• Cause: The user name is too long. User names may not be longer than 128 bytes.

• Action: Check the size of the user name in the argument.

2006: Password is too long: must be less than 64 bytes.

Cause The password is too long. Passwords may not be longer than 63 bytes.

Action Check the size of the password in the argument.

2007: Table name is too long: must be less than 128 bytes.

Cause The table name is too long. Table names may not be longer than 128 bytes.

Action Check the size of the table name in the argument.

2008: Column name is too long: must be less than 128 bytes.

Cause The column name is too long. Column names may not be longer than 127 bytes.

Action Check the size of the column name in the argument.

2009: Schema name is too long: must be less than 128 bytes.

Cause The schema name is too long. Schema names may not be longer than 127 bytes.

Action Check the size of the schema name in the parameter.

2010: String data was right-truncated.

Cause Actual data is larger than the buffer.

Action Check the size of the data buffer.

2011: Wrong parameter number given.

Cause Invalid parameter number.

Action Check the parameter number.

2012: Prepared statement is not a cursor specification.

Cause The prepared statement does not provide a valid cursor specification.

Action Verify the statement is a SELECT statement.

2013: Invalid column index at descriptor.

Cause Invalid column index.

Action Check the descriptor column index.

2014: Invalid record index at descriptor.

Cause Invalid record index.

Action Check the descriptor record index.

2015: Client was unable to establish connection.

Cause Cannot connect to the server.

Action Verify that the server is running, and check the DB connection settings.

2016: OCIServer or OCISession is not set in OCISvcCtx.

Cause Server or session handle is not registered as an attribute of OCISvcCtx.

Action Verify that the OCISvcCtx handle is correctly created.

2017: Open connection already exists.

Cause Already connected to the server.

Action Disconnect the server and retry, or continue with desired actions.

2018: No open connection.

Cause Not connected to the server.

Action Reconnect to the server and try action again.

2019: Program type out of range.

Cause The SQL_C type is not supported.

Action Check the SQL_C type and change it.

2020: Invalid SQL data type.

Cause Unsupported SQL data type.

Action Check the SQL data type and change it.

2021: Associated statement is not prepared.

Cause SQL statement has not been prepared.

Action Execute when SQL statement is prepared.

2022: Invalid use of null pointer.

Cause Invalid null pointer was used.

Action Check the null pointer.

2023: Invalid argument type.

Cause Invalid argument type.

Action Check the argument type.

2024: Invalid argument value.

Cause Invalid argument value.

Action Check the argument value.

2025: Function sequence error.

Cause Invalid function sequence.

Action Check the sequence of functions.

2026: Attribute was not set.

Cause Failed to set attributes.

Action Check the attributes.

2027: Invalid transaction operation.

Cause Invalid transaction operation.

Action Check whether the current transaction operation is valid.

2028: Cannot modify the implementation row descriptor.

Cause Cannot modify IRD (Implementation Row Descriptor).

Action Check the target descriptor type to modify.

2029: Invalid use of an automatically allocated descriptor handle.

Cause Invalid use of an automatically allocated descriptor handle.

Action Create a new descriptor handle.

2030: Inconsistent descriptor information.

Cause Invalid descriptor information.

Action Check the binding descriptor.

2031: Invalid attribute value.

Cause Invalid attribute value.

Action Confirm that the value can be specified for the current attribute.

2032: Invalid string or buffer length.

Cause Invalid length of character string.

Action Change the length of the string.

2033: Invalid descriptor field identifier.

Cause The descriptor field identifier is undefined or not implemented.

Action Check the descriptor field identifier.

2034: Invalid descriptor field identifier.

Cause The specified descriptor field is read-only.

Action Check the attributes of the descriptor field.

2035: Invalid attribute/option identifier.

Cause Invalid attribute or option.

Action Recheck the attribute or option.

2036: Invalid parameter index.

Cause Invalid parameter index.

Action Check the parameter index.

2037: Invalid parameter type.

Cause Invalid parameter type.

Action Check the parameter type.

2038: Invalid cursor position.

Cause Invalid cursor position.

Action Verify that the cursor position is correct.

2039: Optional feature not yet implemented.

Cause The function has not yet been implemented.

Action Use an alternative function.

2040: Invalid cursor state.

Cause Invalid cursor state.

Action Check the cursor state.

2041: Required indicator variable was not specified.

Cause No indicator has been specified.

Action Specify the indicator.

2042: Savepoint exception.

Cause Invalid name for the savepoint.

Action Check the name of the savepoint.

2043: Duplicate cursor name exists.

Cause Duplicate cursor name detected.

Action Change the cursor name.

2044: Invalid cursor name.

Cause Invalid cursor name

Action Change the cursor name.

2045: Invalid record index number.

Cause Invalid diagnostics record index

Action Check the diagnostics record index.

2046: Not yet implemented.

Cause The function has not been implemented.

Action Use an alternative function.

2047: Attribute has not been implemented.

Cause The attribute has not been implemented.

Action Use an alternative attribute.

2048: Data source was not found.

Cause Unable to find DSN.

Action Check whether DSN configuration is valid.

2049: Invalid offset for LOB.

Cause Invalid offset value for large object (LOB).

Action Check the offset value of LOB.

2050: Invalid length for LOB.

Cause Invalid LOB length

Action Check the LOB length.

2051: Invalid authorization.

Cause Not authorized to perform this task.

Action Check the user name and password.

2052: Invalid parameter.

Cause Invalid environment parameter type.

Action Check the environment parameter type.

2053: Invalid plan executed.

Cause Invalid plan was executed.

Action Check whether the plan ID is valid.

2054: Cursor is already open.

Cause The cursor is already open.

Action Check the cursor state.

2055: Cursor is not open.

Cause Cursor is not open.

Action Check the cursor state.

2056: Specified SQL statement is NULL.

Cause Executed SQL statement is NULL.

Action Check the SQL statement again.

2057: Invalid scroll option.

Cause Invalid scrollable cursor fetch.

Action Check whether the cursor type is scrollable.

2058: Invalid data type.

Cause Data type is unsupported by server.

Action Check the data type again.

2059: Invalid data length.

Cause Exceeds the maximum data length supported by server.

Action Check the data length.

2060: Invalid diagnostics index.

Cause Invalid diagnostics index

Action Check the diagnostics index.

2061: Data type is currently unsupported.

Cause Data type is currently unsupported.

Action Use an alternative data type.

2062: Type casting is not allowed.

Cause Unable to change the data type.

Action Check the data type.

2063: Invalid parameter in/out mode.

Cause Invalid parameter mode.

Action Check the parameter mode.

2064: Trailing NULL missing from string bind value.

Cause There is no NULL at the end of string bind value.

Action Check the bind value.

2065: Data was truncated.

Cause Data was too long and was truncated.

Action Check the data length.

2067: Index out of range.

Cause Index value was out of range.

Action Check the index.

2068: Invalid indicator type.

Cause Invalid indicator type.

Action Check the indicator type.

2069: I/O read error.

Cause There is a problem reading from the server.

Action Check the connection.

2070: I/O write error.

Cause There is a problem writing to the server.

Action Check the connection.

2071: I/O close error.

Cause There is a problem closing the communication with server.

Action Check the connection.

2072: Invalid buffer length.

Cause Invalid buffer length.

Action Check the buffer length.

2073: Invalid handle.

Cause Invalid handle.

Action Check whether the handle is valid.

2074: Invalid handle type.

Cause Invalid handle type.

Action Check whether or not the handle type is valid.

2075: Invalid DBC handle.

Cause Invalid connection handle.

Action Check the connection handle.

2076: Invalid statement handle.

Cause Invalid statement handle.

Action Check the statement handle.

2077: Failed to initialize the handle manager.

Cause Failed to initialize the handle manager.

Action Check the handle allocation.

2080: CLI Driver manager has not been initialized.

Cause CLI Driver manager has not been initialized.

Action Initialize the CLI Driver Manager.

2081: Invalid attempt to fetch before the first row of the result set.

Cause The specified fetch location is before the first record of the result set.

Action Specify a valid fetch location.

2082: Invalid socket file descriptor.

Cause Invalid socket file descriptor.

Action Check the connection with the server.

2083: Failed to close socket.

Cause Failed to close socket.

Action Verify the connection with the server is still available.

2084: Invalid protocol.

Cause Invalid server connection protocol.

Action Check the condition of the server and clients.

2085: Invalid LOB locator from server.

Cause Invalid LOB locator received from server.

Action Check the LOB locator.

2086: No data.

Cause No data.

Action Check the fetch state.

2087: Data is needed.

Cause The server requires some data.

Action Ensure the data to be sent is available.

2088: Connection failed.

Cause Failed to connect to server.

Action Check the server state.

2089: Failed to disconnect.

Cause Failed to disconnect.

Action Check the server state.

2090: Execution failed.

Cause Failed to execute SQL statements.

Action Recheck the SQL statements.

2091: Fetching failed.

Cause Failed to fetch.

Action Check the cursor state.

2092: Preparation failed.

Cause Failed to prepare a statement.

Action Check the execution statement.

2093: Failed to close the cursor.

Cause Failed to close the cursor.

Action Check the cursor state.

2094: Failed to commit.

Cause Failed to commit.

Action Check the transaction state.

2095: Failed to close session.

Cause Failed to close the session.

Action Check the server state.

2096: Session kill failed.

Cause Failed to end the session.

Action Check the server state.

2097: Rollback failed.

Cause Failed to roll back.

Action Check the transaction state.

2098: Savepoint failed.

Cause Failed to set a savepoint.

Action Check the transaction state.

2099: Put data failed.

Cause Failed to transfer the data.

Action Verify the data is valid.

2100: Cancel failed.

Cause Failed to cancel.

Action Check the transaction state.

2101: Failed to get the length of LOB.

Cause Failed to obtain the LOB type length.

Action Check the LOB locator.

2102: Failed to read LOB data.

Cause Failed to read LOB data.

Action Check the LOB locator.

2103: Failed to write LOB data.

Cause Failed to write LOB data.

Action Check the LOB locator.

2104: Failed to truncate LOB data.

Cause Failed to truncate LOB data.

Action Check the LOB locator.

2105: Unable to find specified cursor.

Cause Unable to find a cursor with the specified name.

Action Verify the cursor is valid.

2107: DPL is unprepared.

Cause Failed to prepare DPL.

Action Verify the operation is valid.

2108: Failed to load stream.

Cause DPL load stream operation failed.

Action Verify the operation is valid.

2109: Failed to save data.

Cause DPL data save operation failed.

Action Verify the operation is valid.

2110: Failed to abort

Cause DPL abort operation failed.

Action Verify the operation is valid.

2111: Failed to finish.

Cause DPL finish operation failed.

Action Verify the operation is valid.

2112: Failed to flush rows.

Cause Failed to flush a particular record.

Action Verify the operation is valid.

2113: More rows needed after loadstream().

Cause Additional data is needed after DPL load stream operation.

Action Provide the necessary data.

2114: No rows to be inserted after loadstream().

Cause No data has been inserted after DPL load stream operation.

Action Verify the data is valid.

2115: Failed to read DSN info from ODBC.INI.

Cause Failed to read DSN information from ODBC.INI.

Action Check the DSN information.

2116: Completed row delivery to users.

Cause Data fetch process is complete.

Action Perform the next required action.

Cause Invalid communication ID.

Action Check the communication ID.

2119: Shutdown failed.

Cause Failed to shut down.

Action Check the server state.

2120: Unable to get information about the last SQL statement.

Cause Failed to obtain information on the last executed SQL statement.

Action Check whether the operation was valid.

2121: Duplicate request exists.

Cause The request is a duplicate.

Action Verify the operation is valid.

2122: Handle is in use.

Cause The handle is in use.

Action Check the handle state.

2123: No accessible element exists in data structure.

Cause There is no error of the descriptor.

Action Check the index.

2127: Invalid chunk index.

Cause The chunk index is invalid.

Action Check the chunk index.

2131: Generic I/O error.

Cause There is a problem communicating with the server.

Action Check the connection with the server.

2133: Specified index is greater than number of diagnostics records.

Cause There are more indexes than diagnostics records.

Action Check the diagnostics record index.

2134: More data exists for this column.

Cause There is additional data for the column.

Action Receive the remaining data by calling the SQLGetData() function.

2135: Current cursor is not updatable.

Cause The cursor is not updatable.

Action Change to an updatable cursor and retry.

2136: Row index is out of range.

Cause The record index is out of range.

Action Specify a record index smaller than the total number of records in the result set.

2137: Invalid integer buffer size.

Cause An invalid size was specified for the integer buffer.

Action Choose a value between 1 to 8 bytes.

2138: Invalid floating point buffer size.

Cause An invalid size was specified for the floating point buffer.

Action Choose a value between 4 and 8 bytes.

2139: Connection to server was interrupted but the fail-over successfully reconnected.

Cause The server connection was terminated but a new connection was made to a server instance

with the same DNS name.

Action The job being executed by the user was canceled and must be restarted.

2140: Unable to connect to unsupported DBMS server.

Cause An attempt was made to connect to a server that is not supported by the current client.

Action Use a client that supports connections to this server.

2141: IP address specified in DSN file is too long: cannot be longer than 128 bytes.

Cause The length of the IP address in the DSN file is longer than 128 bytes.

Action Check the length of the IP address.

2142: Invalid date/time format.

Cause Invalid date/time format.

Action Check the date/time format.

2143: Out of range for numeric.

Cause Out of range for numeric.

Action Check the buffer size or the data type.

2144: Invalid bookmark value.

Cause Invalid bookmark value.

Action Check if the bookmark value is null or a valid value.

2145: Invalid fetch direction for the current cursor type.

Cause Invalid fetch direction for the current cursor type.

Action Verify the cursor type is scrollable.

2146: Current result set cursor type downgraded.

Cause The current cursor type does not support this query type. The query type will be changed.

Action Check the query type.

2147: Fractional truncation.

Cause The numbers after the decimal point are truncated.

Action Check the buffer size or the data type.

2148: Invalid character value for casting the type.

Cause Invalid character string value for changing the type.

Action Verify the character string is valid to change to the specified type.

2149: No available connection exists in the connection pool.

Cause No available connection exists in the connection pool.

Action Modify the parameter to change the number of connections available in the connection

pool.

2150: Failed to create a daemon thread.

Cause Failed to create a daemon thread.

Action Internal error. Contact the technical support team.

2151: Failed to detach the daemon thread.

Cause Failed to detach the daemon thread.

Action Internal error. Contact the technical support team.

2152: Invalid descriptor index.

Cause Invalid descriptor index.

Action Check if the column/parameter exists for the descriptor index.

2153: Date/time field overflow.

Cause Invalid date type value.

Action Check the data value of the date type.

2154: Invalid chunk index.

Cause The chunk index is invalid.

Action Check the chunk index.

2155: Option value changed.

Cause The specified option is not supported. The option value has been changed to other one.

Action Check the option value.

2156: Cannot find connection information of JEPA (JAVA External Procedure Agent).

Cause Cannot find connection information of JEPA.

Action Check the dsn file in the 'client/config' directory under the database home directory.

2157: Failed to execute psm.

Cause Failed to execute psm.

Action Internal error. Contact the technical support team.

2158: Cannot set the size of TCP Send Buffer.

Cause Failed to set the size of TCP Send Buffer.

Action Contact the technical support team.

2159: Cannot set the size of TCP Receive Buffer.

Cause Failed to set the size of TCP Receive Buffer.

Action Contact the technical support team.

2160: Unable to set the size of TCP Send Buffer.

Cause Failed to set the size of TCP Send Buffer.

Action Contact the technical support team.

2161: Unable to set the size of TCP Receive Buffer.

Cause Failed to set the size of TCP Receive Buffer.

Action Contact the technical support team.

2162: Unable to get the size of TCP Send Buffer.

Cause Failed to get the size of TCP Send Buffer.

Action Contact the technical support team.

2163: Unable to get the size of TCP Receive Buffer.

Cause Failed to get the size of TCP Receive Buffer.

Action Contact the technical support team.

2164: Unable to set the size of TCP Send Buffer.

Cause Failed to set the size of TCP Send Buffer.

Action Contact the technical support team.

2165: Unable to set the size of TCP Receive Buffer.

Cause Failed to set the size of TCP Receive Buffer.

Action Contact the technical support team.

2166: Unable to get the size of TCP Send Buffer.

Cause Failed to get the size of TCP Send Buffer.

Action Contact the technical support team.

2167: Unable to get the size of TCP Receive Buffer.

Cause Failed to get the size of TCP Receive Buffer.

Action Contact the technical support team.

2168: Unable to determine the speed of data transmission between server and client.

Cause Failed to determine the speed of data transmission between server and client.

Action Contact the technical support team.

2169: Multi thread mode is not set.

Cause Multi thread mode is not set.

Action Use the SQLAllocHandle2 or SQLAllocEvn2 API with a true value in the last argument

when allocating the env handle.

2170: The necessary attributes are not set in subs handle.

Cause Topic, callback functions, and listen port information are not set in subscription.

Action Set all the necessary attributes for the subscription.

2171: The subscription topic has already been registered.

Cause A client tried to register the same topic using the same DBC handle.

Action Registering the same topic in the same dbc handle is not allowed.

2172: The subscription topic has not been registered.

Cause The topic to unregister is not in the list of subscriptions.

Action Register the topic first.

2173: Unable to find the listener.

Cause There is no listener listening for the port of the unregistering subscription.

Action Check if the port of the subscription and the subscription are registered.

Cause An I/O error occurred during select failover.

Action Try again later.

2175: Failed to fetch a row.

Cause Application fetched too many rows.

Action Reduce the number of fetch request.

2176: Unable to use the parallel DPL option.

Cause The current server does not support the parallel DPL option.

Action Use the latest version of the server.

2177: The password has expired(grace).

Cause The password has expired(grace).

Action Update the password and then try again.

2178: Unable to fetch subsequent rows.

Cause Failover was not able to restore the result set to its original state to continue fetching rows.

Action Re-execute the query to fetch from the first row.

2179: Invalid subscription name.

Cause The subscription name is invalid or too long.

Action Use a valid subscription name.

2180: Failed to register the subscription.

Cause An unregistered subscription name is used or there is a server error.

Action Use a valid subscription name and check if TQ can be used on the server.

2181: Failed to unregister the subscription.

Cause There is a server error.

Action Check if TQ can be used on the server.

2182: DSN configuration is invalid or incomplete .

Cause Connection information is incorrect or insufficient.

Action Check if the DSN configuration is incorrect or incomplete.

2183: Unable to handle unexpected incoming message type %1$d.

Cause An unexpected protocol was received.

Action Check that the protocol is from a valid context.

2184: Cannot read a LOB object in a remote server.

Cause Cannot read a LOB object in a remote server.

Action Change the query.

2185: The password will expire within %1$s days.

Cause The password will expire within %1$s days.

Action Update the password.

2186: Failed to compress batch update messages.

Cause Failed to compress batch update messages.

Action Check the client library.

2187: Failed to compress DPL messages.

Cause Failed to compress DPL messages.

Action Check the client library.

2188: Too many rows returned on exact fetch mode.

Cause Too many rows returned on exact fetch mode.

Action Check the requested rows.

2189: Information type out of range.

Cause Information type is not valid.

Action Check the information type.

2190: Ending byte of string is invalid.

Cause Character set cannot interpret the ending of string.

Action Check the client charset.

2191: Kerberos authentication failed.

Cause Establishing a GSS-API context was unsuccessful.

Action Check the kerberos configuration and the service name in the DSN file.