JR45744: ORACLE CONNECTOR IMPORT CONNECTOR WIZARD FAILED FOR IMPORT OF SYNONYMS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The "Import Connector Wizard" is launched from DataStage
    Designer.
    The selection of "Include synonyms" at the "Filter" step
    provoked an "Import Failures" when the synonyms covered OWNER
    and TABLE_OWNER
    

Local fix

Problem summary

  • Importing a synonym table definition using the Oracle Connector
    failed with the following error:
    The OCI function OCIDescribeAny returned status -1. Error code:
    1,741, Error message: ORA-01741: illegal zero-length identifier
    

Problem conclusion

  • The list of synonyms was incorrectly generated based on
    TABLE_OWNER field (the owner of the table to which the synonym
    points) instead of OWNER field (the owner of the synonym).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45744

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    870

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-02-25

  • Last modified date

    2013-02-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R870 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere DataStage

Software version:

8.7

Reference #:

JR45744

Modified date:

2013-02-25

Translate my page

Machine Translation

Content navigation