Troubleshooting
Problem
While running overnight macro processes this problem was reported. From the error below it appears to be related to a delay in the response time SQL is providing to handle authentication requests to the SQL Client install on the job servers.
Symptom
Error:
Unable to Bulk Load the data.~~~~Error found in output.
~~~~SQLState = 08001, NativeError = 258~~Error = [Microsoft][SQL Native Client]TCP Provider: Timeout error [258]. ~~SQLState = 08001, NativeError = 258~~Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in login response~~SQLState = S1T00, NativeError = 0~~Error = [Microsoft][SQL Native Client]Login timeout expired
[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.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.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21428682