JDE 8.12 SQL Trigger BUG With Business function

[TheForce]

Hi Everyone !!
we have a problem here !
we have a business function with a SQL trigger.
Its working but as soon as it finish i lost all connexion and JDE is not working anymore
i have to logoff and login to restore the connexion

This is the JDE.log
1324/3536 MAIN_THREAD Wed Sep 03 21:24:23.410000 SpecUtil.c2443
JDESPEC0000022 - Invalid TEMPER parent type!

2588/860 WRK:Starting jdeCallObject Wed Sep 03 21:25:10.943000 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1

2588/860 WRK:Starting jdeCallObject Wed Sep 03 21:25:10.943001 Odbc_u1.c901
ODB0000164 - STMT:00 [HY000][0] [Microsoft][SQL Native Client]Connection is busy with results for another command

IF we run the trigger inside a program it works !

This is our system
Jde 8.12 with the most recent tools release.
the snac client is up to date.
we are windows 2003 with sql 2005 sp2 cum6

Thanks for your help

 

[pshearer]

SQL triggers are evil! Avoid them whenever possible. I've personally experiance much pain at their hand.

http://jde.informedcio.com/2008/09/06/how-to-identify-a-blocking-condition-within-sql-server.aspx

-Paul