tabular data stream (TDS) remote procedure call (RPC) Error

dataservices job design
1

DS version 12.2.1.3
db - SQL SERVER 2008

ODBC data source error message for operation : <[Microsoft][SQL Server Native Client 10.0][SQL Server]The
DBS-070401 incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 17 (""): Data type 0x2A
DBS-070401 has an invalid precision or scale.>.

If i change the driver to Sql server 2005 the DF works fine .
Datatype which is giving the error is a datetime of length 8

Any ideas would be appreciated…?

Thanks,
Raj

jar80 (BOB member since 2005-10-06)

2

I noticed this is due to a datetime column.

If the DS is set to sql server 2005 it works fine but set to 2008 , DF gives the above error.

jar80 (BOB member since 2005-10-06)

3

We’ve had all sorts of problems with datetime fields with DI 12.2 after upgrading to SQL 2008.

From what we can tell… It seems as though if DI detects the database as SQL 2008, it tries to force the datatype to always be a datetime2, which is too big for the database field of datetime. I think it’s trying to be too clever.

Even if the database server is set to 2005 compatibility mode, if it’s on a 2008 server, it seems to behave this way. (DI must be checking the server version, rather than the database version, defined in the datastore.) And even if you leave the datastore connection type as SQL 2005 (And don’t change to SQL 2008.

dnewton :us: (BOB member since 2004-01-30)

4

Thanks for your reply dnewton.

I was able to trace the SQL which inserts in to the table which is trying to
use SMALLDATETIME in 2008

exec sp_prepare @p1 output,N’@P1 varchar(21),@P2 varchar(21),@P3 varchar(101),@P4 varchar(201),@P5 int,@P6 varchar(1001),@P7
smalldatetime’,N’ ',1
select @p1

when i use SQL SERVER 2005 As my database version it uses datetime and works fine.

declare @p1 int
set @p1=1
exec sp_prepare @p1 output,N’@P1 varchar(21),@P2 varchar(21),@P3 varchar(101),@P4 varchar(201),@P5 int,@P6 varchar(1001),@P7 datetime’,N’ ',1
select @p1

jar80 (BOB member since 2005-10-06)

5

I would open a case with tech support about this.

dnewton :us: (BOB member since 2004-01-30)

6

Done that a week before …

jar80 (BOB member since 2005-10-06)