See below ...
On 3/9/06, Wayne Graham <[EMAIL PROTECTED]> wrote:
This makes my head hurt just reading about it ;)
Hah, well if it helps it hurts my head anytime I see an error message from it or do not get the nightly successful email from it.
There could be any number of things going on here. These are some things
you can do to troubleshoot (not in any type of order). Do you have a dev
box with 6.1 on it that you can recreate this on (to rule out server
configurations)?
This is still on the dev server, production has had to stay on CF5 this entire time because of this one process. The dev server is 6.1 and to the best of my knowledge has all the latest 6.1 updates. The database is on a separate box. I can run it off of my laptop, which is running CF7 and it will not crash but will eat up all of the resources for quite sometime but the difference is more than likely the fact my laptop is not a server in a shared hosting environment being used for other things beyond the test. I think I tried it with
6.1 on the laptop long ago. Also did this on the shared hosting servers down here and the ones up in Dallas.
Have you tried serializing the LDAP results before
parsing them?
Are you referring to making sure the values past on the URL to the web service are in a valid XML format? If so, yes, well at least on the fields found to get invalid characters. Or am I reading that question wrong?
Have you tried using try/catch blocks in your code?
Oh yeah, there are a few in there depending on what is being done. For example if one letter fails it shoots off an email due to the catch but will continue onto the next letter.
Do you
have variables that might be rewriting themselves (like multiple dc
entries)?
I never really thought about this one but yeah there are some variables that rewrite themselves as the data is being manipulated.
Have you refactored your code so there
are fewer loops (or at least factoring a loop into a function)?
Oh yeah, when I got to this page it actually was even worse. My guess is due to the amount of loops it had it was doing at least 200k queries. I got it down to that 67k or so via one SP call that happens after all the records are inserted.
Is there
code in the loops to keep you out of an infinite loop?
Yes, I'd be more than happy to email this code to someone off list although there would not be a way to really test it since it connects to a private LDAP server.
Anyway this is OT for a CFC list, my original involvement was because of the GC mentioning.
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
