June 16, 2009 at 8:59 am
I recieved an email from a JDEdwards developer with the error messages below which was fired by a built-in JDE procedure. Neither he nor I have seen this particular one before. Has anyone seen anything similar?? Any pointers would be appreciated.
Jun 11 09:53:16.090001Jdbodbc.c7858
ODB0000164 - STMT:00 [42000][8003] [Microsoft][ODBC SQL Server Driver][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.
3132/400 WRK:Starting jdeCallObject Thu Jun 11 09:53:16.090002Jdb_drvm.c1096
JDB9900401 - Failed to execute db request
3132/400 MAIN_THREAD Thu Jun 11 09:53:27.450000ipcmisc.c299
API ipcSawUnregisterProcV1 : process 3132 unregistered in entry 20
3132/400 MAIN_THREAD Thu Jun 11 09:53:27.465000zdrv.cpp389
Terminating Z driver
3132/400 MAIN_THREAD Thu Jun 11 09:53:27.465001zdrv.cpp406
Calling freeSession
June 16, 2009 at 9:31 am
It is related to the size of the data passed if it is more than the column definition you get this error, check below for Microsoft solution if that is not relevant to you then run a search for the TDS(Tabular data stream) part of the error.
Kind regards,
Gift Peddie
June 16, 2009 at 10:36 am
Well that article, while interesting, does not quite address my problem. The article is about improper data size/length whereas my error indicates too many parameters with no mention of data/column length.
Thanks anyway!
Anyone else????
June 16, 2009 at 10:42 am
It is actually the size of the data passed in as parameter to the TDS protocol which is Microsoft data transfer protocol adding up to more than what is defined in your column to accept the parameters.
Kind regards,
Gift Peddie
June 16, 2009 at 10:55 am
I suppose you could be right. Trouble is that I don't really understand what you mean. (This is new territory for me so I apologise for what may seem silly questions.) When you say '....column to accept the parameters', what column do you mean? Where can I find it?
Thanks again...
June 16, 2009 at 11:07 am
JDE is not .NET but in .NET say you are using Decimal with precision and scale SQL Server pass in the data without the decimal point. And if you are in a Java application it may be you are using 2000 JDBC instead of the 2005 JDBC driver. Something is passing data more than the SQL Server column can accept. Tell your developer to debug the code to see the actual size of the parameter as it is passed in on this connection.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply