Skip to Content
0
Jan 16, 2023 at 07:48 AM

SAP BODS - SQL Server 2019 hosted on Azure Cloud Execution error

268 Views Last edit Jan 16, 2023 at 08:45 AM 2 rev

Dear All,

We have SAP BODS 4.2 SP14 Patch 24 (latest patch - 1) installed and running on Windows in our environment. One of the job is configured to load data to SQL Server 2019 hosted on Azure Cloud.

1. Data Store is properly configured and successful to the target SQL Server 2019 on Azure

2. Table import within ETL is working fine from target database SQL Server 2019 on Azure

3. But whenever we try to view the table data using Table -- > Right click -- > View Data, we receive the error attached.

4. As per the SAP recommendation, We have used ODBC drivers (Data Direct ODBC drivers v8.0 SP2) and tried using other drivers as well (SQL Server, SQL Server Native Client 11, ODBC driver 13 for SQL server)

5. ODBC configuration is working fine to the target SQL Server 2019 on Azure (for the above listed ODBC drivers)

5. We have checked the number of connections occuring in the target database and it is just one connection when we try to read the table data.

Could you please advise what we need to check further on this ?

image.png

image.png

Attachments

image.png (63.2 kB)
image.png (18.5 kB)