IBM Support

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

Troubleshooting


Problem

Publish failing for all apps in the environment

Symptom

From console error details:

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

From the .out file in the temp directory:

ORA-12154: TNS:could not resolve the connect identifier specified

Cause

The Oracle bulk load utility, sqlldr, could not successfully connect to the oracle instance.

Environment

Oracle

Resolving The Problem

During the publish process, a series of files are created in the TEMP directory on the job server that is processing the publish. If you open the .cmd file in the TEMP directory, you should see the sqlldr command that is being executed. Try running that same command in a command prompt on that server (to simulate what happens during a publish. If the command doesn't work when you try to run it manually, that could indicate an issue with the Oracle SQLLDR utility. A common problem is the @ symbol in either the oracle username or password - that's valid in other parts of Oracle, but will cause the sqlldr utility to fail.

[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1037914

Document Information

Modified date:
15 June 2018

UID

swg21347615

Page Feedback