Posted by
–
Datastage jobs are failing when running a query against the Azure SQL Server database with the error: SQLSTATE = 08S01, Native Error Code = 0, Message = [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver] Socket closed.
The maximum network packet size for encrypted connections for SQL Server, which is 16,383 bytes, was probably being exceeded.
Set PacketSize=0 to use the server default or use a fixed packet size such as PacketSize=32.
Ansible Playbook for Patching & Upgrading Different Services Azure CLI -Command Line Interface Azure Databricks Azure Data Lake Storage Gen2 (ADLS Gen2) Azure Data Storage and Azure Data Lake Azure DevOps – Different Use Case Direct access and access through Azure Active Directory (AD) groups Git Undoing How to Install Ansible How to install providers (Part-3) How to List Azure role assignments using Azure PowerShell How to mount cloud object storage (ADLS) on Azure Databricks How to push/pull and clone files between Local machine and GitHub How to Start and Install Terraform How to use Azure Key Vault for Azure Data Factory? Install Package in Ansible Kill and stop the Docker image Log Analytics Login Failed Log Rotation in Linux Microsoft Fabric OneLake Oracle GoldenGate Query to Retrieve User Access Details from Azure SQL Database Using Log Analytics Terraform Pipeline Terraform Templates Top Linux Troubleshooting Commands with Examples Understanding Git Concepts What is CrowdStrike Workspace identity