dem
Member
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?
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?