Troubleshooting a Failed Data Load into the Sybase IQ Database

Manually troubleshoot a failed market data load into the Sybase IQ database.

Problem: Market data has failed to load into the Sybase IQ database.

Solution: Locate the file, connect to the Sybase IQ database using a SQL client, and execute two statements to specify where the market data will load.

  1. Check the primary or overflow location of the Sybase IQ Output adapter for the file that failed to load.
  2. Use a SQL client to connect to the Sybase IQ database table to which the market data should be loaded.
  3. Execute the following statement:
    set temporary option Core_Options13 = 0
  4. In the same connection, construct and execute the following statement (columns should be listed in the same order as they appear in the corresponding ESP schema):
    LOAD TABLE "<schema>"."<tablename>" ( "<colname 1>" BINARY WITH NULL BYTE, ... , "<colname n>" BINARY WITH NULL BYTE )
FROM '<fileName>' FORMAT BINARY QUOTES OFF ESCAPES OFF PREVIEW ON

    Because the data was manually loaded, the Sybase IQ Output adapter File Activity Report in the Sybase Control Center will not show that the file was loaded, and will continue to indicate the data load as having failed.

Parent topic: Troubleshooting