Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1003014L | Error | 20186 | QHA14 | No message | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1004000L | Error | 20209 | QIA00 | "The number of connections in the connection pool have exceeded the upper limit" | The number of connections in the connection pool have exceeded the total number of connections allowed in the connection pool. No more connections can be allocated. Click here for a list of possible parameters and odbc states. |
| -1004001L | Error | 20210 | QIA01 | "Number of unused connections exceeded the maximum number of unused connections in the connection pool" | The number of unused connections in the connection pool has exceeded the maximum number of unused connections in the connection pool. Click here for a list of possible parameters and odbc states. |
| -1004003L | Error | 20212 | QIA03 | "Timeout period should be greater than or equal to the heartbeat frequency" | All the timeout periods should be greater than or equal to the heartbeat frequency. Click here for a list of possible parameters and odbc states. |
| -1004004L | Error | 20215 | QIA04 | "No connection found for the server id %1 on the coordinator" | A secondary node with the given server id does not exist on the coordinator connection list Click here for a list of possible parameters and odbc states. |
| -1004005L | Error | 20216 | QIA05 | "Timeout period should be multiple of the Heartbeat Frequency" | All the timeout periods of INC(e.g.,AUTOEXCLUDE,LIVENESS,IDLE_CONNECTION) requires to be multiple of the Heartbeat Frequency. Click here for a list of possible parameters and odbc states. |
| -1004006L | Error | 20217 | QIA06 | "Unused Connection Pool size should be always less than the Maximum Connection Pool size" | Unused Connection pool size can not be greater can not be greater than the maximum allowable size of the Connection pool Click here for a list of possible parameters and odbc states. |
| -1004007L | Error | 20218 | QIA07 | "Unable to acquire a pooled connection to the coordinator node" | There are no empty pooled connections on the secondary node and also no new connections can be established because the total number of connections has exceeded the maximum capacity of the connection pool Click here for a list of possible parameters and odbc states. |
| -1004008L | Error | 20219 | QIA08 | "Coordinator node is offline" | Coordinator node is offline and hence, all the suspended commands on the suspended connections will be terminated Click here for a list of possible parameters and odbc states. |
| -1004009L | Error | 20220 | QIA09 | "INC communication failure %1" | INC communication failure. This can happen if either the coordinator or the secondary node is restarted or shutdown down when the other node is trying to connect to it Click here for a list of possible parameters and odbc states. |
| -1004010L | Error | 20221 | QIA10 | "Error in getting current user information" | Error returned while trying to find out the current user connected to the given node Click here for a list of possible parameters and odbc states. |
| -1004011L | Error | 21222 | QIA11 | "Coordinator node not responding" | Coordinator node is not responding. Check to see if the Coordinator is running Click here for a list of possible parameters and odbc states. |
| -1004012L | Error | 21223 | QIA12 | "INC communication between coordinator and secondary failed due to : %2 %1" | INC communication failed between coordinator and secondary nodes. The error returned from target node is also displayed. This connection is similar to a client connection. Click here for a list of possible parameters and odbc states. |
| -1004013L | Error | 21224 | QDD08 | "Cannot drop multiplex server %2 as it holds freelist. %1" | If a writer holds a freelist, it cannot be dropped. If the writer can be started, start it. This is because a startup or a clean shutdown will clear the freelist. If the writer cannot be restarted, restart the coordinator with -iqmpx_reclaimwriterfreelist <server name> server switch to force the coordinator to reset the writer freelist. Click here for a list of possible parameters and odbc states. |
| -1004014L | Error | 20225 | QIA14 | "Trying to execute an unknown SQL type over the INC connection" | The node is trying to execute an unknown SQL over the dblib connections Click here for a list of possible parameters and odbc states. |
| -1004015L | Error | 21225 | QIA15 | "Permission denied: Command not allowed on Multiplex %2 servers. %1" | The command is not permitted on current multiplex node Click here for a list of possible parameters and odbc states. |
| 1004060L | Warning | 20211 | 01A60 | "Warning: Heartbeat frequency should be less than or equal to other timeout periods" | The heartbeat frequency should always be less than or equal to other timeout period. This is to make sure that the time lag between the timeout occurring and the time when it is detected is minimal. Click here for a list of possible parameters and odbc states. |
| 1004061L | Warning | 20213 | QIA61 | "Warning: All INC timeout periods should be multiple of Heartbeat frequency" | All the timeout periods of INC(e.g.,AUTOEXCLUDE,LIVENESS,IDLE_CONNECTION) requires to be multiple of the Heartbeat Frequency. Click here for a list of possible parameters and odbc states. |
| -1005000L | Error | 20154 | QTA00 | "Bind parameters are not supported in data flow query processing" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005001L | Error | 20155 | QTA01 | "Query has exceeded the supported maximum number of tables that can be joined. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |