BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Apr 4.

Protocol error in TDS stream


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
searchforarun
Senior Member
Senior Member



Joined: 09 Oct 2012

Posts: 36
Location: Pune,India


flag
PostPosted: Wed Nov 21, 2012 12:30 am 
Post subject: Protocol error in TDS stream

Hi Folks,

We have two of Source databases which are configured as a Linked Server. We receive this error when our production job is running in BODS 4.0

The database error message is <SQL submitted to ODBC data source <VNHQPSQL01v\bobjpro> resulted in error [Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "SQLNCLI10" for linked server "CORE" returned message "Protocol error in TDS stream".>

I checked the connectivity of the Linked Server and it is working fine. Also checked the TCP/IP and Named Pipe protocol which are set in the SQL Server Configuration Manager

Our Environment: BODS 4.0 SP2
DB: SQL Server 2008 R2
Datastore connection Type: OLEDB

Does anybody have any idea where is this error coming from. Is it something to do with the connection between Linked Server and Target database

Regards
Arun Sasi
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
PostPosted: Wed Nov 21, 2012 12:02 pm 
Post subject: Re: Protocol error in TDS stream

I don't know the SQL Server communication stack as well as I would like to but when I am forced to use SQL Server I always make sure I am connecting using the native client, not ODBC or OLEDB (I never have to configure a DSN). In your Datastore is your Database type ODBC or Microsoft SQL Server? What is the Database version set to in the Datastore?

Is your SQL Server client software up to date? This could be the root of your problem as MS has identified a bug that is related to this error. However, your client software would have to be very old. Since you are on DS 4.0 I doubt this is the case unless you are using a very old O/S install.

And finally, according to a Google search this error can occur when the network is very busy and/or the amount of data to be transferred is very large.

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
searchforarun
Senior Member
Senior Member



Joined: 09 Oct 2012

Posts: 36
Location: Pune,India


flag
PostPosted: Wed Nov 21, 2012 11:33 pm 
Post subject: Re: Protocol error in TDS stream

Hi Jim,

Thanks for the reply.

Here are the answers to your questions

In your Datastore is your Database type ODBC or Microsoft SQL Server?
Microsoft SQL Server
What is the Database version set to in the Datastore?
SQL Server 2008 R2
Microsoft SQL Server Enterprise Edition (64-bit) Ver: 10.50.1600.1

Is your SQL Server client software up to date?
We havent installed any Service Pack or Fix Pack on top of the SQL Server 2008 R2 installation.

It might be possible that the error occurs whenever there is a heavy network traffic as one of our Source database has the maximum number of hits.

Would appreciate if you could let me know the fix for the bug in SQL Server 2008 R2 if there are any.

Regards
Arun Sasi
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
PostPosted: Mon Nov 26, 2012 10:26 am 
Post subject: Re: Protocol error in TDS stream

searchforarun wrote:
Is your SQL Server client software up to date?
We havent installed any Service Pack or Fix Pack on top of the SQL Server 2008 R2 installation.


Check the version of the client software that run on the Job Server O/S.

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
searchforarun
Senior Member
Senior Member



Joined: 09 Oct 2012

Posts: 36
Location: Pune,India


flag
PostPosted: Tue Nov 27, 2012 1:20 am 
Post subject: Re: Protocol error in TDS stream

Hey Jim,

The version of the BODS client software running on the Job Server O/S is 14.0.2.322 and BODS Server version is 14.0.2.197.

The only relevant post I found was below

http://www.windowsitpro.com/article/john-savills-windows-faqs/i-am-getting-a-message-protocol-error-in-tds-datastream-from-a-sql-server-query-

I also checked the log files on Job Server and it only states that

DBS-070404: |Data flow DF_STAGE_TPRODUCTATTRIBUTEVALUE_ALL|Reader Query
SQL submitted to ODBC data source <VNHQPSQL01v\bobjpro> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL
Server]OLE DB provider "SQLNCLI10" for linked server "CORE" returned message "Protocol error in TDS stream".>

Although the query is not complicated it fails even while executing simple data flows.

Ran a diagnostic utility called sqldiag but could not find anything related to
the error.

Thanks!!

Regards
Arun Sasi
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
PostPosted: Tue Nov 27, 2012 10:24 am 
Post subject: Re: Protocol error in TDS stream

No, you need to check the version of the database client software. I think you can get the version by looking for a file that is named sqlncli*.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
searchforarun
Senior Member
Senior Member



Joined: 09 Oct 2012

Posts: 36
Location: Pune,India


flag
PostPosted: Wed Nov 28, 2012 1:22 am 
Post subject: Re: Protocol error in TDS stream

Hi Jim,


SQL Server Client version is:

Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514

Regards
Arun Sasi
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
PostPosted: Wed Nov 28, 2012 10:37 am 
Post subject: Re: Protocol error in TDS stream

That version is fairly new so I doubt that the bug they had identified is in there. It was a very old client version that had the problem.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
searchforarun
Senior Member
Senior Member



Joined: 09 Oct 2012

Posts: 36
Location: Pune,India


flag
PostPosted: Thu Nov 29, 2012 1:43 am 
Post subject: Re: Protocol error in TDS stream

Ok Jim!!

No problem. We have reported the Protocol error to our client and very soon this issue will be sorted out by their in house DBA.

Regards
Arun Sasi
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0314 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0280)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo