[WebDNA] Processor Maxing out
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104909
interpreted = N
texte = All,=20Okay, I was working on a file that would create a CSV file and attach it =to an email so the customer could import it into WorldShip from USP to =handle shipping. I found some code on the archive (Thanks for that. I =was making it way too hard) and it works. Since then, the processor is =pegged. I've seen it do this once before and Donovan just had me restart =the triggers and it stopped. I've read through the talk archive on =processor maxing out and here's what I've tried:checked for large files, made sure all the logging is turned off, =stopped and restarted Webcatalog using webcatalogctl, restarted the =machine, stopped and restarted email and triggers in sandbox admin, =restarted emailer from CGI RestartEmailer.tpl, made sure the safe =database write is on, looked at the orders.db and LineItems.db (the two =databases I am currently working in/on) for bad lines and still the =processor is pegged.The sites are working, but something is wrong and I'm not sure where to =start looking. I'm just starting to work with nested searches and =founditems. Maybe someone with more experience can see something I'm =missing. I am doing a replace in the LineItems.db to mark the exported =records. Should I be doing a commit before I do that replace? I've =edited some of the extraneous fields to shorten the code:=[text]emailserial=3D[random][random][random][random][random][random][/text=][text]headline=3DWorldShip File Contents[/text][text]line_ending=3D%0D%0A[/text][!]=3D=3D=3D=3D=3D=3D=3D Write results of new files to be exported to =var 'body' =3D=3D=3D=3D=3D[/!][text]body=3DShipFromComp,,[!][/!][ListFields db=3DOrders.db][FieldName],[/ListFields][!][/!]Ref1,ref2,BillOption[UnURL][line_ending][/UnURL][!][/!][founditems][search =db=3DLineItems.db&eqcartdata=3D[eqcartdatarq]&rank=3Doff][/search][!] [/!][HideIf [Status]!Approved][!] [/!][HideIf [Action]!Sale][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems][!] [/!][HideIf [exported]=3DYes][!] [/!]Sterzing Food Company,1819 Charles =St.,Burlington,IA,52601,[country],CP,5,[!] =[/!][cart],[Date],[Time],[Email],[PayMethod],************[getchars =start=3D1&end=3D4&from=3Dend][AccountNum][/getchars],[!] [/!]More fields here,[!] =[/!][taxExempt],[resellerNumber],[transactionIndex],[relatedTransaction],[=!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][=!] [/!]Cart:[getchars =start=3D1&end=3D5&from=3Dend][cart][/getchars] [founditems][!] [/!](#[sku]-[textA])[!] [/!][/founditems][!] [/!][/search],,SHP[UnURL][line_ending][/UnURL][!][/!][/HideIf][!][/!][/founditems][!][/!][/search][!][/!][/HideIf][!][/!][/HideIf][!][/!][/founditems][!][/!][/text][!]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DWrite contents of 'body' to a =file called 'WorldShip.txt'=3D=3D=3D=3D=3D=3D=3D=3D=3D[/!][WriteFile ^/WorldShip.txt][body][/WriteFile][!]=3D=3D=3D=3D=3D=3D Waits for WorldShip.txt file and reports error if =it doesn't get written =3D=3D=3D=3D=3D=3D=3D[/!][text]succeeded=3DF[/text][WaitForFile file=3D^/WorldShip.txt] File was found!
[text]succeeded=3DT[/text][/WaitForFile][ShowIf [succeeded]=3DT] The WorldShip.txt file was written so I'll move =along!
[/ShowIf][ShowIf [succeeded]=3DF] WARNING! File was not found! You may have to =try again.
[/ShowIf][!]=3D=3D=3D=3D=3D=3D=3D Write listing of contents of WorldShip.txt to =var 'message' for email body =3D=3D=3D=3D=3D[/!][text]message=3DThe daily list has been processed. File is attached.Here is a report of items in today's manifest:[headline][founditems][!][/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!][/!][founditems][HideIf [exported]=3DYes][HideIf =[Status]!Approved][HideIf [Action]!Sale][!][/!][getchars start=3D1&end=3D5&from=3Dend][cart][/getchars] - =[ShipToName] [ShipToAddress1] [ShipToCity] [ShipToState] [ShipToZip] =[ShipToEmail] [Header1][!][/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!][/!][founditems](#[sku]-[textA]-[!] [/!][search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff][!] [/!][founditems][title] - [weight]-lbs)[/founditems][/search][!][/!][/founditems][/search][Replace =db=3DLineItems.db&eqCARTdata=3D[cart]]exported=3DYes[/Replace][/HideIf][/HideIf][/HideIf][/founditems][/search][!][/!][/founditems][!][ListFields db=3DLineItems.db][FieldName],[/ListFields] [search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff] [founditems][weight][/founditems][/search][/!]Your Friendly eCommerce Server[/text][sendmail =To=3Dme@domain.com,minime@domain.com&From=3Dyou@domain.com&Subject=3DWorld=Ship [date %x] processed at [time %I:%M =%p]&Content-Type=3Dmultipart/mixed;boundary=3D"[emailserial]"&MIME-version=3D1.0]]--[emailserial]Content-type: text/plain; charset=3D"US-ASCII"Content-transfer-encoding: 7bit[convertchars][message][/convertchars]--[emailserial]Content-Type: text/plain; name=3D"WorldShip.txt"Content-Disposition: attachmentContent-Transfer-Encoding: base64[encrypt method=3Dbase64&file=3D^/WorldShip.txt&emailformat=3DT][/encrypt]=--[emailserial]--[/sendmail]The file was sent.
OS X.4.11 ServerCommerce Edition 6.0aSite is a SiteBuilder site running with a sandboxWebDNA server is running as rootThanks in advanceTony Miller
Associated Messages, from the most recent to the oldest:
All,=20Okay, I was working on a file that would create a CSV file and attach it =to an email so the customer could import it into WorldShip from USP to =handle shipping. I found some code on the archive (Thanks for that. I =was making it way too hard) and it works. Since then, the processor is =pegged. I've seen it do this once before and Donovan just had me restart =the
triggers and it stopped. I've read through the talk archive on =processor maxing out and here's what I've tried:checked for large files, made sure all the logging is turned off, =stopped and restarted Webcatalog using webcatalogctl, restarted the =machine, stopped and restarted email and
triggers in sandbox admin, =restarted emailer from CGI RestartEmailer.tpl, made sure the safe =database write is on, looked at the orders.db and LineItems.db (the two =databases I am currently working in/on) for bad lines and still the =processor is pegged.The sites are working, but something is wrong and I'm not sure where to =start looking. I'm just starting to work with nested searches and =founditems. Maybe someone with more experience can see something I'm =missing. I am doing a replace in the LineItems.db to mark the exported =records. Should I be doing a commit before I do that replace? I've =edited some of the extraneous fields to shorten the code:=
[text]emailserial=3D
[random][random][random][random][random][random][/text=]
[text]headline=3DWorldShip File Contents[/text]
[text]line_ending=3D%0D%0A[/text]
[!]=3D=3D=3D=3D=3D=3D=3D Write results of new files to be exported to =var 'body' =3D=3D=3D=3D=3D[/!]
[text]body=3DShipFromComp,,
[!][/!][ListFields db=3DOrders.db][FieldName],[/ListFields]
[!][/!]Ref1,ref2,BillOption
[unurl][line_ending][/UnURL]
[!][/!]
[founditems][search =db=3DLineItems.db&eqcartdata=3D[eqcartdatarq]&rank=3Doff][/search]
[!] [/!][HideIf [Status]!Approved]
[!] [/!][HideIf [Action]!Sale]
[!] [/!][search db=3DLineItems.db&eqcartdata=3D
[cart]&rank=3Doff]
[!] [/!]
[founditems][!] [/!][HideIf [exported]=3DYes]
[!] [/!]Sterzing Food Company,1819 Charles =St.,Burlington,IA,52601,[country],CP,5,
[!] =[/!]
[cart],
[date],
[time],[Email],[PayMethod],************[getchars =start=3D1&end=3D4&from=3Dend][AccountNum][/getchars],
[!] [/!]More fields here,
[!] =[/!][taxExempt],[resellerNumber],[transactionIndex],[relatedTransaction],[=!] [/!][search db=3DLineItems.db&eqcartdata=3D
[cart]&rank=3Doff][=!] [/!]Cart:[getchars =start=3D1&end=3D5&from=3Dend]
[cart][/getchars]
[founditems][!] [/!](#[sku]-[textA])
[!] [/!][/founditems]
[!] [/!][/search],,SHP
[unurl][line_ending][/UnURL]
[!][/!][/HideIf]
[!][/!][/founditems]
[!][/!][/search]
[!][/!][/HideIf]
[!][/!][/HideIf]
[!][/!][/founditems]
[!][/!][/text]
[!]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DWrite contents of 'body' to a =file called 'WorldShip.txt'=3D=3D=3D=3D=3D=3D=3D=3D=3D[/!][WriteFile ^/WorldShip.txt][body][/WriteFile]
[!]=3D=3D=3D=3D=3D=3D Waits for WorldShip.txt file and reports error if =it doesn't get written =3D=3D=3D=3D=3D=3D=3D[/!]
[text]succeeded=3DF[/text][WaitForFile file=3D^/WorldShip.txt] File was found!
[text]succeeded=3DT[/text][/WaitForFile][ShowIf [succeeded]=3DT] The WorldShip.txt file was written so I'll move =along!
[/ShowIf][ShowIf [succeeded]=3DF] WARNING! File was not found! You may have to =try again.
[/ShowIf]
[!]=3D=3D=3D=3D=3D=3D=3D Write listing of contents of WorldShip.txt to =var 'message' for email body =3D=3D=3D=3D=3D[/!]
[text]message=3DThe daily list has been processed. File is attached.Here is a report of items in today's manifest:[headline]
[founditems][!][/!][search db=3DLineItems.db&eqcartdata=3D
[cart]&rank=3Doff]
[!][/!]
[founditems][HideIf [exported]=3DYes][HideIf =[Status]!Approved][HideIf [Action]!Sale]
[!][/!][getchars start=3D1&end=3D5&from=3Dend]
[cart][/getchars] - =[ShipToName] [ShipToAddress1] [ShipToCity] [ShipToState] [ShipToZip] =[ShipToEmail] [Header1]
[!][/!][search db=3DLineItems.db&eqcartdata=3D
[cart]&rank=3Doff]
[!][/!]
[founditems](#[sku]-[textA]-
[!] [/!][search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff]
[!] [/!]
[founditems][title] - [weight]-lbs)[/founditems][/search]
[!][/!][/founditems][/search][Replace =db=3DLineItems.db&eqCARTdata=3D
[cart]]exported=3DYes[/Replace][/HideIf][/HideIf][/HideIf][/founditems][/search]
[!][/!][/founditems]
[!][ListFields db=3DLineItems.db][FieldName],[/ListFields] [search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff]
[founditems][weight][/founditems][/search][/!]Your Friendly eCommerce Server[/text][sendmail =To=3Dme@domain.com,minime@domain.com&From=3Dyou@domain.com&Subject=3DWorld=Ship [date %x] processed at [time %I:%M =%p]&Content-Type=3Dmultipart/mixed;boundary=3D"[emailserial]"&MIME-version=3D1.0]]--[emailserial]Content-type: text/plain; charset=3D"US-ASCII"Content-transfer-encoding: 7bit
[convertchars][message][/convertchars]--[emailserial]Content-Type: text/plain; name=3D"WorldShip.txt"Content-Disposition: attachmentContent-Transfer-Encoding: base64[encrypt method=3Dbase64&file=3D^/WorldShip.txt&emailformat=3DT][/encrypt]=--[emailserial]--[/sendmail]The file was sent.
OS X.4.11 ServerCommerce Edition 6.0aSite is a SiteBuilder site running with a sandboxWebDNA server is running as rootThanks in advanceTony Miller
Tony Miller
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
A multi-processor savvy WebCatalog? (1997)
Great product and great job ! (1997)
Hard Questions ? (1997)
A multi-processor savvy WebCatalog? (1997)
ANNC:DUH!! The address would be helpful! (2000)
MasterCounter Weirdness -Resolved! (1997)
Looking for WebSTAR bomb at startup (2000)
WebDNA Speed Test (2008)
Urgent help needed (2003)
WC2.0 Memory Requirements (1997)
WebCat2 - [format thousands] (1997)
ACGI processing for .html (1997)
Limiting user access to .tmpl files (1997)
Re:WebCatalog/WebMerchant III (1998)
Starting WebCatalog on Linux (2000)
[WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault! (2011)
problems with 2 tags shakur (1997)
[date format] w/in sendmail (1997)
WebCat Hosting (1998)
advise!! (2001)