Data Manager build fails when using bulk load delivery

Troubleshooting

Problem

Data Manager fact build fails when using bulk load delivery to SQL Server 2005 database

Symptom

-----Delivery 'Fact2': BCP Output file-----
SQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
SQLState = 08S01, NativeError = 4
Error = [Microsoft][SQL Native Client]Shared Memory Provider: I/O Error detected in read/write operation [4].
SQLState = 08S01, NativeError = 4
Error = [Microsoft][SQL Native Client]Communication link failure
SQLState = 42000, NativeError = 4060
Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database requested in login '[<database name>]'. Login fails.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","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.

Historical Number

1040248

Was this topic helpful?

Document Information

More support for:
Cognos Business Intelligence

Software version:
8.3

Operating system(s):
Windows

Document number:
370971

Modified date:
08 May 2025

UID

swg21343100

IBM Support

Tips