New Era SmartHeapLibrary
Posted in 1998
Topics: High Availability & Replication, SQL Development & Query Writing
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDC625.8A6EB966 Content-Type: text/plain Using WIN95 New Era 2.2 On-Line Dynamic Server & SE Server I have a table join that reads locatn, dinv, minv, product, mfg, outer mat_cnt, outer nsn, outer msds The where clause reads locatn.loc_id=dinv.loc_id and dinv.minv_id=minv.minv_id and minv.prod_id=product.prod_id and product.mfg_id=mfg.mfg_id and minv.matcnt_id=mat_cnt.mat_cnt_id and minv.nsn_id=nsn.nsn_id and product.msds_id = msds.msds_id There are approximately 8000 records involved in a retrieve. The retireve results in SmartHeapLibrary, Out of Memory. Please free some memory, then choose retry. This basically results in a system crash and requires a reboot. I ran some memory diagnostics and the problem seems to be that the NewEra2.2 exe is not using an swap. ANY RESPONSES? Ed Gerving (egerving@htscm.com) Computer Sciences Corporation ------ =_NextPart_001_01BDC625.8A6EB966 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.1960.3"> <TITLE>New Era SmartHeapLibrary</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">Using WIN95</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">New Era 2.2</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">On-Line Dynamic Server & SE Server</FONT> </P> <P> <FONT SIZE=3D2 = FACE=3D"Arial">I have a table join that reads </FONT> <BR> = <FONT SIZE=3D2 FACE=3D"Arial">locatn, = dinv, minv, product, mfg, outer mat_cnt, outer nsn, outer = msds</FONT></P> <P> <FONT SIZE=3D2 = FACE=3D"Arial">The where clause reads</FONT> <BR> = <FONT SIZE=3D2 = FACE=3D"Arial">locatn.loc_id=3Ddinv.loc_id and = dinv.minv_id=3Dminv.minv_id and</FONT></P> <P> = <FONT SIZE=3D2 = FACE=3D"Arial">minv.prod_id=3Dproduct.prod_id and = product.mfg_id=3Dmfg.mfg_id and</FONT></P> <P> = <FONT SIZE=3D2 = FACE=3D"Arial">minv.matcnt_id=3Dmat_cnt.mat_cnt_id and = minv.nsn_id=3Dnsn.nsn_id and</FONT></P> <P> = <FONT SIZE=3D2 = FACE=3D"Arial">product.msds_id =3D msds.msds_id</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">There are approximately 8000 records = involved in a retrieve. The retireve results in SmartHeapLibrary, = Out of Memory. Please free some memory, then choose retry. = </FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">This basically results in a system = crash and requires a reboot. I ran some memory diagnostics and = the problem seems to be that the NewEra2.2 exe is not using an = swap.</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">ANY RESPONSES?</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Tahoma">Ed Gerving = (egerving@htscm.com)</FONT> <BR><FONT SIZE=3D2 FACE=3D"Tahoma">Computer Sciences Corporation</FONT> </P> </BODY> </HTML> ------ =_NextPart_001_01BDC625.8A6EB966--