D
D
Dmitry Gavrilenko2017-06-01 10:50:09
Stored procedures
Dmitry Gavrilenko, 2017-06-01 10:50:09

What is the cause of Ms Sql error 8052?

Hello. There is a program that calls the stored procedure n1, receives a DataSet from it, then sends this DataSet to another stored procedure n2, and it is passed as a parameter as a table value (TVP)
The program performs in 40 threads the "task" to transfer data from one to another.
From n1 to n2 - where the storages n1 and n2 are different for each thread. Those. in fact, there are 40 transfers from 40 different places.
So, everything was fine until one of these "tasks" was given a message

Invalid incoming tabular data (TDS) RPC stream. Table-valued parameter 1 ("@srctab"), row 0, column 0: For data type 0xF3 (user-defined table type), the timestamp column must be the default column.

This happens when the program has read data from n1, and sent the data to n2. In the @srctab error, this is just the input table parameter for n2 storage.
Tell me how to solve this issue?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question