OK, here's the situation: I have ColdFusion 5. I'm accessing an Access database.
My Intranet has been running fine for awhile now, but, recently we started getting the Locaiton Code: 26 and Windows NT Error 1450.
The funny thing is that it doesn't occur on the entire site. So far it is just in two particular scenarios.
For example I have a page called "jobs.cfm". This shows you all open jobs in the database. Since there are over 700 jobs, I break them out 50 at a time. However, there still some individuals that would like to see all 700 (don't ask me why, typical user mentality). Well, anyway, for these individuals, there is a link called "ShowAll" which will display all the jobs on one page. Well, there lies the problem. When they click on Show All, we receive the Location 26. Note: It is ONLY when Show All is cliked, under no other cirucmstance we get that error on this particular page. It doesn't matter if they resort, go to another page, etc, only when they click "Show All".
In the second scenario it is even more particular. I have another form that I'll call New_Job. When the form is blank, no problem. However, when I pass on the JOBID for a modification, Location 26 again. I've stripped everything in the body and no error. I've narrowed down the possible culprit in this case to the CF_TWOSELECTSRELATED. If I remove them, it works. Funny thing is that if that the only thing in the body, it works.
I'm at the point that I want to throw in the towel and come up with an alternative to the CF_TWOSELECTSRELATED so that my users can do modifications. However, that doesn't solve the problem with the SHOW ALL.
I've searched all over the Internet and I can't seem to find an answer. The closest that I came was to a problem with the registry size (since I'm storying the variables there I figured that could be the issue); however, I noticed what was the size (25mb) compared to what is the max(55mb), so, I don't think this is an issue.
I've also played with the timeouts within CFAdministrator, but, they don't seem to have any affect.
I've monitored the TaskManager, memory is OK, hard drive has space. The only thing that I'm thinking is that there is a setting somewhere that I'm missing and it's preventing CFSERVER.EXE from running as much as it should. What I mean by this, I've submitted the page in question, watch CFSERVER.EXE take some CPU time, but, before it's even done, it realeses the CPU, then I get the error. Well, it's just a theory.
I'm starting to get desperate here. So, if anyone has any suggestions whatsoever I would really appreciate it.
My Intranet has been running fine for awhile now, but, recently we started getting the Locaiton Code: 26 and Windows NT Error 1450.
The funny thing is that it doesn't occur on the entire site. So far it is just in two particular scenarios.
For example I have a page called "jobs.cfm". This shows you all open jobs in the database. Since there are over 700 jobs, I break them out 50 at a time. However, there still some individuals that would like to see all 700 (don't ask me why, typical user mentality). Well, anyway, for these individuals, there is a link called "ShowAll" which will display all the jobs on one page. Well, there lies the problem. When they click on Show All, we receive the Location 26. Note: It is ONLY when Show All is cliked, under no other cirucmstance we get that error on this particular page. It doesn't matter if they resort, go to another page, etc, only when they click "Show All".
In the second scenario it is even more particular. I have another form that I'll call New_Job. When the form is blank, no problem. However, when I pass on the JOBID for a modification, Location 26 again. I've stripped everything in the body and no error. I've narrowed down the possible culprit in this case to the CF_TWOSELECTSRELATED. If I remove them, it works. Funny thing is that if that the only thing in the body, it works.
I'm at the point that I want to throw in the towel and come up with an alternative to the CF_TWOSELECTSRELATED so that my users can do modifications. However, that doesn't solve the problem with the SHOW ALL.
I've searched all over the Internet and I can't seem to find an answer. The closest that I came was to a problem with the registry size (since I'm storying the variables there I figured that could be the issue); however, I noticed what was the size (25mb) compared to what is the max(55mb), so, I don't think this is an issue.
I've also played with the timeouts within CFAdministrator, but, they don't seem to have any affect.
I've monitored the TaskManager, memory is OK, hard drive has space. The only thing that I'm thinking is that there is a setting somewhere that I'm missing and it's preventing CFSERVER.EXE from running as much as it should. What I mean by this, I've submitted the page in question, watch CFSERVER.EXE take some CPU time, but, before it's even done, it realeses the CPU, then I get the error. Well, it's just a theory.
I'm starting to get desperate here. So, if anyone has any suggestions whatsoever I would really appreciate it.