TheForce
Member
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
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