Informix Troubleshooting Guide | Collate Support

​

Troubleshooting

​

Workflow Deployment Error

• You can then Edit the Ingestion Pipeline and Deploy it again.
• From the Connection tab, you can also Edit the Service if needed.

​

Connector Debug Troubleshooting

​

How to Enable Debug Logging for Any Ingestion

1. Navigate to Services Go to Settings > Services > Service Type (e.g., Database) in the Collate UI.
2. Select a Service Choose the specific service for which you want to enable debug logging.
3. Access Ingestion Tab Go to the Ingestion tab and click the three-dot menu on the right-hand side of the ingestion type, and select Edit.
4. Enable Debug Logging In the configuration dialog, enable the Debug Log option and click Next.
5. Schedule and Submit Configure the schedule if needed and click Submit to apply the changes.

​

Permission Issues

​

Connection Failed

Error: [Informix][Informix ODBC Driver]Connection could not be established

​

Resolution

1. Verify Host and Port: Ensure the hostname and port are correct (e.g., localhost:9088).
2. Check Server Name: Verify that the Server Name matches the value in your sqlhosts file or INFORMIXSERVER environment variable.
3. Network Access: Ensure the system running the ingestion can reach the Informix server on the specified port.
4. Firewall Rules: Check that the Informix port (typically 9088) is not blocked by firewalls.
5. Server Status: Verify that the Informix server is running using onstat - command.

​

Authentication Failed

Error: [Informix][Informix ODBC Driver]Incorrect password or user <username> is not known on the database server

​

Resolution

1. Verify Credentials: Double-check that the username and password are correct.
2. User Exists: Confirm the user exists in the Informix database:
   SELECT username FROM sysusers WHERE username = '<username>';
   
3. Password Reset: If needed, reset the password using:
   ALTER USER '<username>' WITH PASSWORD '<new_password>';
   

​

Permission Denied on System Catalogs

Error: [Informix][Informix ODBC Driver]No SELECT permission on systables

​

Resolution

-- Grant SELECT on system catalog tables
GRANT SELECT ON systables TO '<username>';
GRANT SELECT ON syscolumns TO '<username>';
GRANT SELECT ON sysviews TO '<username>';
GRANT SELECT ON sysprocedures TO '<username>';

​

Database Does Not Exist

Error: [Informix][Informix ODBC Driver]Database '<database_name>' not found

​

Resolution

1. Verify Database Name: Check that the database name is spelled correctly and exists:
   SELECT name FROM sysdatabases;
   
2. Database Access: Ensure the user has access to the database:
   GRANT CONNECT TO '<username>' ON '<database_name>';
   

​

SSL Connection Failed

Error: [Informix][Informix ODBC Driver]SSL connection failed

​

Resolution

1. Verify SSL Mode: Ensure the SSL Mode is set correctly (require, verify-ca, or verify-full).
2. Check CA Certificate: For verify-ca or verify-full modes, ensure the CA certificate is correctly provided.
3. Server SSL Configuration: Verify that the Informix server is configured for SSL connections.
4. Certificate Format: Ensure certificates are in PEM format.

​

SQLTRACE Access Denied

Error: [Informix][Informix ODBC Driver]No SELECT permission on sysmaster:syssqltrace

​

Resolution

1. Grant Permission: Grant SELECT on the SQL trace table:
   GRANT SELECT ON sysmaster:syssqltrace TO '<username>';
   
2. Enable SQL Tracing: Ensure SQL tracing is enabled (run as DBA):
   ONMODE -Y 2
   
3. Verify Trace Status: Check that SQL tracing is active:
   SELECT * FROM sysmaster:syssqltrace LIMIT 1;
   

​

SQLTRACE Table Too Large

Warning: syssqltrace table has exceeded recommended size

​

Resolution

1. Flush Old Entries: Periodically truncate the SQL trace table after successful ingestion:
   -- Disable SQL tracing
   ONMODE -Y 0
   -- Truncate will happen automatically when tracing is re-enabled
   -- Re-enable SQL tracing
   ONMODE -Y 2
   
2. Lower Trace Level: Consider using SQLTRACE level 1 instead of 2 if full coverage isn’t required.
3. Schedule Regular Cleanup: Set up a scheduled task to flush the trace table periodically.

​

Connection Timeout

Error: [Informix][Informix ODBC Driver]Connection timeout

​

Resolution

1. Check Network Latency: Verify network connectivity between the ingestion system and Informix server.
2. Server Load: Check if the Informix server is under heavy load using onstat -g act.
3. Increase Timeout: If using a slow network, consider increasing connection timeout settings.
4. Server Resources: Ensure the Informix server has adequate resources (CPU, memory, disk I/O).

​

No Tables Found

Warning: No tables found in database

​

Resolution

1. Verify Database Contents: Confirm the database contains tables:
   SELECT tabname FROM systables WHERE tabtype = 'T';
   
2. Check Table Filters: Review the Table Filter Pattern to ensure it’s not excluding all tables.
3. User Permissions: Verify the user has SELECT access to the tables you want to ingest.