Error: "3927: Response Parcel requested a max byte count less than 256"

Database

Error: "3927: Response Parcel requested a max byte count less than 256"

HI,

I have just started using Teradata.

I am trying to create a simple Stored Procedure in Teradata 12 server machine in SQL Assiatance using 'dbadmin' user, but i am getting the below error message:

"3927: Response Parcel requested a max byte count less than 256"

Below is the Stored Procedure:

CREATE PROCEDURE MyFirstProc (IN emp_number INTEGER,

                                             IN dept_number INTEGER,

                                             OUT dept_name CHAR(10),

                                             INOUT errstr VARCHAR(30))

BEGIN

        INSERT INTO Employee (EmpNo, DeptNo )

        VALUES (emp_number, dept_number);

        SELECT DeptName INTO dept_name FROM Department

        WHERE DeptNo = dept_number;

END;

Please let me know how i can resolve this issue.

Thanks in advance.

4 REPLIES
Enthusiast

Re: Error: "3927: Response Parcel requested a max byte count less than 256"

Hello Teradata experts!

I also have some problem with the error 3927. I'm currently adapting a program that works on the oracle db for the teradata. 

The program connects the DB using jdbc (the teradata version is 13.10.00.05, the teradata jdbc driver version is 14.00.00.37). The program executes SELECT- query, which returns 6 rows. The fetch size = 4. When resultSet.next() is executed for the first 4 rows, it works fine. When trying to get the fifth row it returns an error "[Error 3927] [SQLState HY000] Response Parcel requested a max byte count less than 256."

What is a possible reason? Small fetch size? Which other reasons could cause such a problem?

Thank you for any hint!

Enthusiast

Re: Error: "3927: Response Parcel requested a max byte count less than 256"

small update here: when I increase the fetch size to 100, it works...  but I think, it is not a normal behaviour?

Teradata Employee

Re: Error: "3927: Response Parcel requested a max byte count less than 256"

That problem is likely to be too difficult to troubleshoot on this forum. We would need to examine the Teradata JDBC Driver debug log in order to determine what is occurring.

If you are a customer, then please open a customer incident. If you are not a customer, then please try upgrading to a newer version of the Teradata Database. The fetch size feature was originally introduced in Teradata Database 13.10, and there were some bugs in the feature in early Teradata Database 13.10 releases like the one that you are using.

Enthusiast

Re: Error: "3927: Response Parcel requested a max byte count less than 256"

Thank you for a fast reply! We will try to get a newer version and double check these problems.