Skip to Content
0

SAP Data Services throws a communication error while executing a job

Mar 13, 2017 at 07:13 PM

543

avatar image

Hi all

I recently developed a job which works in 2 steps:

1) Extraction from SAP ECC tables (and one table from SAP F&R) as Data Source, into SQL Server 2008 R2 tables. In this step we filter the data read from SAP ECC in order to have data sets containing just data relevant to the process we implement.

2) Validation of the data extracted into SQL Server, based on business rules in order to find data that fails to fit such Business Rules. For doing so, we perform some steps according to specific logic depending on the data we want to validate. Most of the steps involve using Query Transforms. Some of these joins process huge amounts of data since we read large tables from ECC, such as MARC, WLK1 and the table MATLOC from F&R.

The job has been tested properly in the DEV environment, which has the following features

DS Server:

Windows Server 2008 R2 Standard

DS 4.2 SP 06 Patch 02

SQL Server Native Client 10.0 and 11.0 installed (not sure why there are 2 versions in the server)

SQ Server

SQL Server 2008 R2

After testing in DEV, we move the developed objects into the PROD environment (we have not a QA environment in place at this time). PROD environment has the following features

DS Server:

Windows Server 2008 R2 Standard

DS 4.2 SP 06 Patch 02

SQL Server Native Client 10.0 installed

SQ Server

SQL Server 2008 R2

When we tried to run the job, it worked properly for the Extraction from SAP ECC into SQL Server 2008 R2 tables. However, when the job started to work in the Analysis of the extracted data (in SQL Server 2008), we got an error:

(14.2) 03-08-17 14:18:40 (R) (12000:7256) DBS-070401: |Data flow DF_VI_R01_01_01_Obtener_Material_Centro|Reader Query_WLK1_Filtrar_Vigencias

ODBC data source <CorpDatosSAP> error message for operation <SQLFetchScroll>: <[Microsoft][SQL Server Native Client 10.0]TCP

Provider: An existing connection was forcibly closed by the remote host.

[Microsoft][SQL Server Native Client 10.0]Communication link failure

[Microsoft][SQL Server Native Client 10.0]Protocol error in TDS stream

[Microsoft][SQL Server Native Client 10.0]Protocol error in TDS stream>.

(14.2) 03-08-17 14:18:40 (E) (12000:7256) DBS-070401: |Data flow DF_VI_R01_01_01_Obtener_Material_Centro|Reader Query_WLK1_Filtrar_Vigencias

ODBC data source <CorpDatosSAP> error message for operation <SQLFetchScroll>: <*****>. This message contains some internal

system details which have been hidden for security. If you need to see the full contents of the original message, ask your

administrator to assign additional privileges to your account.

(14.2) 03-08-17 14:18:40 (R) (21392:10436) DBS-070401: |Data flow DF_VI_R05_01_01_Obtener_Material_Centro|Reader Query_WLK1_Filtrar_Vigencias

ODBC data source <CorpDatosSAP> error message for operation <SQLFetchScroll(rowStsArray[])>: <[Microsoft][SQL Server Native

Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host.

[Microsoft][SQL Server Native Client 10.0]Communication link failure

[Microsoft][SQL Server Native Client 10.0]Communication link failure>.

We have already tried the following steps:

1) We disabled the Antivirus software in the DS PROD environment and ran the job server and it didn’t help, we got the same result

2) We executed some of the queries used in the validation phase, directly on the SQL Server database engine (within the DS PROD server). They ran without any problem.

3) We copied the SQL Server database into another Server and tried to run the job using such new Database. We got the same results. The extraction part works well but then the validation part crashes.

4) We configured a new data store in the repository for the DS DEV environment pointing to the new SQL Server DB and then we executed the job. It worked properly.

We think the problem might be something related to the SQL Server DB in PROD, but we are still wondering why the extraction part works with no issues (the data read from ECC gets stored properly into the SQL Server tables). It is just when the validation starts that we see the communication error

But then we have seen that executing the Job from the DS DEV environment works fine.

So we are still lost on whether the problem is related to the PROD database or the DS PROD repository, or maybe it is related to the communication between the DS PROD Server and the SQL Server DB for PROD.

Any help would be much appreciated

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Carlos Alberto Ron Mar 14, 2017 at 12:34 AM
0

Hello Gabriel this issue is cause by an specific configuration at operative system level, please check out this article:

https://support.microsoft.com/es-es/help/951037/information-about-the-tcp-chimney-offload,-receive-side-scaling,-and-network-direct-memory-access-features-in-windows-server-2008

BR, Carlos.


Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Mar 14, 2017 at 09:28 AM
0

Gabriel,

Start with the basic level of troubleshooting.

The error takes us to the Data flow DF_VI_R01_01_01_Obtener_Material_Centro and under Query Trasnform Query_WLK1_Filtrar_Vigencias.

Check the mapping in this query transform. If everything looks fine then refer SAP Note

1478133 - How to analyze connection problems to database server

Also refer to KBA mentioned by Carlos.

Regards

Arun Sasi


Share
10 |10000 characters needed characters left characters exceeded
Luis Darui
Mar 14, 2017 at 03:54 PM
0

Seems like you're facing disconnecting problems.

Besides updating the SQL Server software (both client and server), try following this troubleshooting guide from Microsoft:

https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

Share
10 |10000 characters needed characters left characters exceeded