IBM InfoSphere Streams Version 4.1.0

Database Toolkit operator runtime error conditions

SPL standard and specialized toolkits > com.ibm.streams.db 1.5.0 > Database Toolkit operator runtime error conditions

When run time errors occur while you are using Database Toolkit operators, an error message is generated in the processing element log.

The OCBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2SplitDB, DB2PartitionedAppend, NetezzaLoad, and NetezzaPrepareLoad operators automatically respond to error conditions.

When the following conditions occur during the operator run time, the operator takes action (if applicable) and error messages are written in the processing element log:
  • Unable to allocate ODBC environment handle
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2SplitDB, DB2PartitionedAppend, NetezzaLoad
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to allocate ODBC connection handle
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2SplitDB, DB2PartitionedAppend, NetezzaLoad
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to connect to database
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2SplitDB, DB2PartitionedAppend, NetezzaLoad
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to allocate SQL statement
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2SplitDB, DB2PartitionedAppend, NetezzaLoad
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to set isolation level
    • Operators: ODBCEnrich, ODBCRun, ODBCSource
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to prepare SQL statement
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2PartitionedAppend, NetezzaLoad
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to bind SQL parameters
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2PartitionedAppend
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to set AutoCommit
    • Operators: ODBCAppend, ODBCRun, DB2PartitionedAppend
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator.
  • Unable to run SQL INSERT statement
    • Operators: ODBCAppend, DB2PartitionedAppend
    • System action: If the optional output error stream is specified, a tuple is generated on this stream.
  • Unable to run SQL SELECT statement
    • Operators: ODBCEnrich, ODBCSource
    • System action: The operator retries the operation based on the value specified in the reconnectionPolicy parameter of the operator. If the optional output error stream is specified, a tuple that contains the SQL error information is generated on this stream.
  • Unable to run SQL statement
    • Operators: ODBCRun
    • System action: If the optional error stream is specified, a tuple is generated on this stream.
  • Unable to determine number of statement result columns
    • Operators: ODBCAppend, ODBCEnrich, ODBCRun, ODBCSource, DB2PartitionedAppend
    • System action: If the optional error stream is specified, a tuple is generated on this stream.
  • Unable to fetch SQL SELECT results
    • Operators: ODBCEnrich, ODBCRun, ODBCSource
    • System action: Not applicable.
  • Unable to close SQL SELECT results cursor
    • Operators: ODBCEnrich, ODBCRun, ODBCSource
    • System action: Not applicable.
  • Unable to determine partition information for a tuple.
    • Operators: DB2SplitDB
    • System action: Not applicable.
  • XML value is too large for the database column that is specified in the access specification.
    • Operators: NetezzaPrepareLoad
    • System action: If the optional error stream is specified, a tuple is generated on this stream.
  • Error creating internal FIFO
    • Operators: NetezzaLoad
    • System action: Not applicable
  • Error opening internal FIFO
    • Operators: NetezzaLoad
    • System action: Not applicable
  • Unexpected pipe communication error
    • Operators: NetezzaLoad
    • System action: Not applicable
  • Unable to derive location of the nzbad file
    • Operators: NetezzaLoad
    • System action: Not applicable. Tuples cannot be sent to the optional error stream when a load error occurs.
  • Unable to open the nzbad file
    • Operators: NetezzaLoad
    • System action: Not applicable. Tuples cannot be sent to the optional error stream when a load error occurs.

For more information about the circumstance of the error, analyze the processing element log.