IBM Support

InfoSphere DataStage job aborts with "Failed to create Control File" error when loading to Sybase IQ using Sybase Enterprise stage

Troubleshooting


Problem

Parallel job bulk loading to Sybase IQ using Sybase Enterprise stage fails with error message: "Sybase_Enterprise,0: Failed to create Control File"

Symptom

The following error messages for target Sybase Enterprise stage appears in the job log.


Item #: 15
Event ID: 72
Timestamp: 2010-10-14 16:45:16
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: Failed to create Control File

Item #: 16
Event ID: 73
Timestamp: 2010-10-14 16:45:16
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: Error in runSybWriteSource Function

Item #: 17
Event ID: 74
Timestamp: 2010-10-14 16:45:16
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: The runLocally() of the operator failed.

Item #: 18
Event ID: 75
Timestamp: 2010-10-14 16:45:16
Type: Info
User Name: dsadm
Message: Sybase_Enterprise,0: Input 0 consumed 0 records.

Item #: 19
Event ID: 76
Timestamp: 2010-10-14 16:45:16
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: processing failed for input /tmp/aptfc2.16530.4cb6b50b.0, $SybWriteFifoConnection: exit status = 255.Sybase_Enterprise

Item #: 20
Event ID: 77
Timestamp: 2010-10-14 16:45:16
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: The runLocally() of the operator failed.

Item #: 21
Event ID: 78
Timestamp: 2010-10-14 16:45:16
Type: Info
User Name: dsadm
Message: Sybase_Enterprise,0: Input 0 consumed 0 records.

Item #: 22
Event ID: 79
Timestamp: 2010-10-14 16:45:22
Type: Fatal
User Name: dsadm
Message: Sybase_Enterprise,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

Item #: 23
Event ID: 80
Timestamp: 2010-10-14 16:45:22
Type: Fatal
User Name: dsadm
Message: main_program: Step execution finished with status = FAILED.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;11.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21450235