Some UBE don't work on SQL2005

Some UBE don\'t work on SQL2005

We installed JDE_PRODUCTION database on SQL2005 SP2, all other databases stay on SQL2000 SP4. Now some UBE end with error - DataBase connection lost. Our configuration is OneWorld Xe SP23_Q1, Native SQL Client.

Jdedebug.log On SQL2005:

Jul 30 15:43:36 ** 2136/2368 ODBC:S DBInitRequest(new) conn=03A516F0 hd=0458F4A8 dr=043F5878 ENTERPRISE A (JDE@Business Data - PROD)
Jul 30 15:43:40 ** 2136/2368 SELECT T0.SAKCOO, T0.SADOCO, T0.SADCTO, T0.SALNID, T0.SAMCU, T0.SADC, T0.SAPA8, T0.SAAN8, T0.SAALPH, T0.SASHAN, T0.SAALPHNM, T0.SAPSEVDO, T0.SAALPHPS, T0.SAADDJ, T0.SAIVD, T0.SAITM, T0.SAAITM, T0.SALNTY, T0.SADSC1, T0.SADSC2, T0.SASRP0, T0.SASSRP0, T0.SASRP1, T0.SASSRP1, T0.SAPRP0, T0.SASPRP0, T0.SASRP4, T0.SASSRP4, T0.SAPRP1, T0.SAUOM, T0.SASUOM1, T0.SASRTX, T0.SASOQS, T0.SARYIN, T0.SASRYIN, T0.SAURCD, T0.SADCT, T0.SADOC, T0.SAKCO, T0.SACRCD, T0.SARCD, T0.SASRCD1, T0.SAAN81, T0.SAALPH1, T0.SAAN83, T0.SAALPH3, T0.SAAN86, T0.SAALPH6, T0.SAAC01, T0.SASAC01, T0.SAFEAF, T0.SAAEXPF, T0.SAFEAUSD, T0.SAFUP, T0.SAUPRC, T0.SARZ, T0.SAFRZ, T0.SARZRUR, T0.SAKTLN, T0.SACOMM, T0.SAAT1, T0.SACPNT, T0.SAAC03, T0.SAAC23, T0.SATAXC, T0.SARP03, T0.SASAC03, T0.SAADD1, T0.SAADD2, T0.SACITY, T0.SAVR02, T0.SAIVI, T0.SAURAT, T0.SAUSER, T0.SAUPMJ, T0.SATDAY, T0.SAYN, T1.ABAN8, T1.ABAN84, T2.ABAN8, T2.ABALPH, T2.ABAN84 FROM ( ( PRODDTA.F59L4211 T0 LEFT OUTER JOIN PRODDTA.F0101 T1 ON T0.SAAN8 = T1.ABAN8 ) LEFT OUTER JOIN PRODDTA.F0101 T2 ON T1.ABAN84 = T2.ABAN8 ) WHERE ( ( T0.SAKCOO = '00020' AND T0.SAADDJ >= 107182 AND T0.SAADDJ <= 107211 AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' OR T0.SAIVD >= 107182 AND T0.SAIVD <= 107211 AND T0.SAADDJ = 0 AND T0.SAKCOO = '00020' AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' ) ) ORDER BY T0.SAKCOO ASC,T0.SADOCO ASC,T0.SADCTO ASC

Jdedebug.log On SQL2000

Jul 30 15:43:36 ** 2136/2368 ODBC:S DBInitRequest(new) conn=03A516F0 hd=0458F4A8 dr=043F5878 ENTERPRISE A (JDE@Business Data - PROD)
Jul 30 15:43:40 ** 2136/2368 SELECT T0.SAKCOO, T0.SADOCO, T0.SADCTO, T0.SALNID, T0.SAMCU, T0.SADC, T0.SAPA8, T0.SAAN8, T0.SAALPH, T0.SASHAN, T0.SAALPHNM, T0.SAPSEVDO, T0.SAALPHPS, T0.SAADDJ, T0.SAIVD, T0.SAITM, T0.SAAITM, T0.SALNTY, T0.SADSC1, T0.SADSC2, T0.SASRP0, T0.SASSRP0, T0.SASRP1, T0.SASSRP1, T0.SAPRP0, T0.SASPRP0, T0.SASRP4, T0.SASSRP4, T0.SAPRP1, T0.SAUOM, T0.SASUOM1, T0.SASRTX, T0.SASOQS, T0.SARYIN, T0.SASRYIN, T0.SAURCD, T0.SADCT, T0.SADOC, T0.SAKCO, T0.SACRCD, T0.SARCD, T0.SASRCD1, T0.SAAN81, T0.SAALPH1, T0.SAAN83, T0.SAALPH3, T0.SAAN86, T0.SAALPH6, T0.SAAC01, T0.SASAC01, T0.SAFEAF, T0.SAAEXPF, T0.SAFEAUSD, T0.SAFUP, T0.SAUPRC, T0.SARZ, T0.SAFRZ, T0.SARZRUR, T0.SAKTLN, T0.SACOMM, T0.SAAT1, T0.SACPNT, T0.SAAC03, T0.SAAC23, T0.SATAXC, T0.SARP03, T0.SASAC03, T0.SAADD1, T0.SAADD2, T0.SACITY, T0.SAVR02, T0.SAIVI, T0.SAURAT, T0.SAUSER, T0.SAUPMJ, T0.SATDAY, T0.SAYN, T1.ABAN8, T1.ABAN84, T2.ABAN8, T2.ABALPH, T2.ABAN84 FROM ( ( PRODDTA.F59L4211 T0 LEFT OUTER JOIN PRODDTA.F0101 T1 ON T0.SAAN8 = T1.ABAN8 ) LEFT OUTER JOIN PRODDTA.F0101 T2 ON T1.ABAN84 = T2.ABAN8 ) WHERE ( ( T0.SAKCOO = '00020' AND T0.SAADDJ >= 107182 AND T0.SAADDJ <= 107211 AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' OR T0.SAIVD >= 107182 AND T0.SAIVD <= 107211 AND T0.SAADDJ = 0 AND T0.SAKCOO = '00020' AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' ) ) ORDER BY T0.SAKCOO ASC,T0.SADOCO ASC,T0.SADCTO ASC
Jul 30 15:44:01 ** 2136/2368 Data selection processed with high concurrency option.
Jul 30 15:44:01 ** 2136/2368 SELECT T0.SAKCOO, T0.SADOCO, T0.SADCTO, T0.SALNID, T0.SAMCU, T0.SADC, T0.SAPA8, T0.SAAN8, T0.SAALPH, T0.SASHAN, T0.SAALPHNM, T0.SAPSEVDO, T0.SAALPHPS, T0.SAADDJ, T0.SAIVD, T0.SAITM, T0.SAAITM, T0.SALNTY, T0.SADSC1, T0.SADSC2, T0.SASRP0, T0.SASSRP0, T0.SASRP1, T0.SASSRP1, T0.SAPRP0, T0.SASPRP0, T0.SASRP4, T0.SASSRP4, T0.SAPRP1, T0.SAUOM, T0.SASUOM1, T0.SASRTX, T0.SASOQS, T0.SARYIN, T0.SASRYIN, T0.SAURCD, T0.SADCT, T0.SADOC, T0.SAKCO, T0.SACRCD, T0.SARCD, T0.SASRCD1, T0.SAAN81, T0.SAALPH1, T0.SAAN83, T0.SAALPH3, T0.SAAN86, T0.SAALPH6, T0.SAAC01, T0.SASAC01, T0.SAFEAF, T0.SAAEXPF, T0.SAFEAUSD, T0.SAFUP, T0.SAUPRC, T0.SARZ, T0.SAFRZ, T0.SARZRUR, T0.SAKTLN, T0.SACOMM, T0.SAAT1, T0.SACPNT, T0.SAAC03, T0.SAAC23, T0.SATAXC, T0.SARP03, T0.SASAC03, T0.SAADD1, T0.SAADD2, T0.SACITY, T0.SAVR02, T0.SAIVI, T0.SAURAT, T0.SAUSER, T0.SAUPMJ, T0.SATDAY, T0.SAYN, T1.ABAN8, T1.ABAN84, T2.ABAN8, T2.ABALPH, T2.ABAN84 FROM ( ( PRODDTA.F59L4211 T0 (NOLOCK) LEFT OUTER JOIN PRODDTA.F0101 T1 (NOLOCK) ON T0.SAAN8 = T1.ABAN8 ) LEFT OUTER JOIN PRODDTA.F0101 T2 (NOLOCK) ON T1.ABAN84 = T2.ABAN8 ) WHERE ( ( T0.SAKCOO = '00020' AND T0.SAADDJ >= 107182 AND T0.SAADDJ <= 107211 AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' OR T0.SAIVD >= 107182 AND T0.SAIVD <= 107211 AND T0.SAADDJ = 0 AND T0.SAKCOO = '00020' AND T0.SASRP0 = '401' AND T0.SAPRP0 = '04' ) ) ORDER BY T0.SAKCOO ASC,T0.SADOCO ASC,T0.SADCTO ASC

On SQL2000 query runs twice, second time it runs with option "high concurrency" and successful result, but on SQL2005 only one query and database connection lost.

Does Anybody know this issue?

Re: Some UBE don\'t work on SQL2005

Hello dem,
I upgraded a client to websphere6, sql2005 and tr8.96.1.4 this weekend and I am having the same problem for one of their UBEs.
We are on 8.10

Running the UBE on fat client takes a long time (query timeout about 15-16 times in the log), but in the end the high concurrency query is used and then the UBE finishes as expected

Re: Some UBE don\'t work on SQL2005

as a workaround: in the activity monitor of the sql server, we saw 1 blocking thread and another thread in 'suspended' state, which was blocked by the other process. By killing the blocking process, the UBE finished as expected...
So if your UBE seems to be stuck, go look for an inactive process that is blocking the others.

We have other complaints that might all point to this problem and a case was logged with peoplesoft. If they can provide more information, we will let you know

Re: Some UBE don\'t work on SQL2005

which tools release are you using, dem?

Re: Some UBE don\'t work on SQL2005

I am sorry for a wait, I had a rest )
Tools version - OneWorld Xe SP23_Q1

Re: Some UBE don\'t work on SQL2005

Anyone knows the solution for this issue? I upgraded to sql 2005 sp2. Some ube's are not ending. The process in SQL 2005 is suspended.