Re: Oracle Error no descriptor for this position
Nope, not here, but thanks for the idea. Chris Norloff -- Original Message -- from: Deanna Schneider [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 22 Oct 2002 13:08:03 -0500 I've been trying to trudge through my memory about this one, since I used to get it and don't anymore. I think it was this issue: There was one app where I was using translate() in a query. I updated all the data to do what the translate was doing, and haven't had a problem since. You wouldn't happen to be using that function, would you? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Oracle Error no descriptor for this position
Translate()? I don't even know what that does. ;p I'm pretty sure it's not in use in this application. I've been trying to trudge through my memory about this one, since I used to get it and don't anymore. I think it was this issue: There was one app where I was using translate() in a query. I updated all the data to do what the translate was doing, and haven't had a problem since. You wouldn't happen to be using that function, would you? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Oracle Error no descriptor for this position
I was just about to post this myself when I noticed the thread. I have this same issue. Win2k/CF5 - Win2k/Oracle 8.0.5 Happens fairly frequently. Much too often basically, but only on larger queries. I also get Timeout while trying to obtain Oracle statement lock. Just started researching this. Any progress here? Yes, we did that; no change. I wonder if LoadRunner is keeping the user sessions straight? thanks, Chris Norloff -- Original Message -- from: Deanna Schneider [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 18 Oct 2002 08:59:16 -0500 Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Oracle Error no descriptor for this position
No, no progress on no descriptor - we're looking at a number of things. It's intermittent, showing up only occasionally when when the server is under load testing. And I keep getting more number 1 priorities. sheesh. The Oracle statement lock problem sounds like Oracle needs more connections between CF and Oracle (or whatever they're called). Chris Norloff -- Original Message -- from: Tony Schreiber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 22 Oct 2002 11:00:59 -0400 (EDT) I was just about to post this myself when I noticed the thread. I have this same issue. Win2k/CF5 - Win2k/Oracle 8.0.5 Happens fairly frequently. Much too often basically, but only on larger queries. I also get Timeout while trying to obtain Oracle statement lock. Just started researching this. Any progress here? Yes, we did that; no change. I wonder if LoadRunner is keeping the user sessions straight? thanks, Chris Norloff -- Original Message -- from: Deanna Schneider [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 18 Oct 2002 08:59:16 -0500 Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Oracle Error no descriptor for this position
I've been trying to trudge through my memory about this one, since I used to get it and don't anymore. I think it was this issue: There was one app where I was using translate() in a query. I updated all the data to do what the translate was doing, and haven't had a problem since. You wouldn't happen to be using that function, would you? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Oracle Error no descriptor for this position
We're getting the Oracle error ORA-24334: no descriptor for this position with the following query. Not having much luck finding out what's going on, or getting info from the MM CF forum, CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on Solaris 8, Oracle 8i db, with 8.1.7 client) thanks, Chris Norloff SELECT job_id, provider_code, NVL(financial_no, '0') financial_no, mailing_facility, job_title, process_category, class, local_permit_no, permit_type, total_piece, total_weight, cqt_total_pieces, cqt_weight, location_zip, owner_name, gca_version FROM m_job_summary WHERE job_id = 'QD2AES_1' AND provider_code = 'QUAD' AND mailing_facility = '22203-1553' Oracle's description of the error: ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Oracle Error no descriptor for this position
I'm not sure that this is the problem, but could the following be causing a cyclical redundancy error: NVL(financial_no, '0') financial_no Some DB platforms don't let you assign an alias name that is the same as the column to which it is being assigned. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Chris Norloff [mailto:cnorloff;norloff.com] Sent: Friday, October 18, 2002 9:39 AM To: CF-Talk Subject: Oracle Error no descriptor for this position We're getting the Oracle error ORA-24334: no descriptor for this position with the following query. Not having much luck finding out what's going on, or getting info from the MM CF forum, CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on Solaris 8, Oracle 8i db, with 8.1.7 client) thanks, Chris Norloff SELECT job_id, provider_code, NVL(financial_no, '0') financial_no, mailing_facility, job_title, process_category, class, local_permit_no, permit_type, total_piece, total_weight, cqt_total_pieces, cqt_weight, location_zip, owner_name, gca_version FROM m_job_summary WHERE job_id = 'QD2AES_1' AND provider_code = 'QUAD' AND mailing_facility = '22203-1553' Oracle's description of the error: ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Oracle Error no descriptor for this position
Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Oracle Error no descriptor for this position
Oracle doesn't have an issue with alias names being the same as the column name you're aliasing. It handles that just fine. I do it in exactly that kind of way, where you're not really changing the meaning of the column, just verifying non-null-ness. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Oracle Error no descriptor for this position
Oracle's Metalink has an article about a problem with Cold Fusion, Oracle and Bullseye conflict causing this error. Doc ID: 171452.995 Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Chris Norloff To: CF-Talk [EMAIL PROTECTED] cnorloff@norl cc: off.com Subject: Oracle Error no descriptor for this position 10/18/2002 08:39 AM Please respond to cf-talk We're getting the Oracle error ORA-24334: no descriptor for this position with the following query. Not having much luck finding out what's going on, or getting info from the MM CF forum, CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on Solaris 8, Oracle 8i db, with 8.1.7 client) thanks, Chris Norloff SELECT job_id, provider_code, NVL(financial_no, '0') financial_no, mailing_facility, job_title, process_category, class, local_permit_no, permit_type, total_piece, total_weight, cqt_total_pieces, cqt_weight, location_zip, owner_name, gca_version FROM m_job_summary WHERE job_id = 'QD2AES_1' AND provider_code = 'QUAD' AND mailing_facility = '22203-1553' Oracle's description of the error: ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Oracle Error no descriptor for this position
Good to know. Thanks Deanna. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Deanna Schneider [mailto:deanna.schneider;ces.uwex.edu] Sent: Friday, October 18, 2002 10:24 AM To: CF-Talk Subject: Re: Oracle Error no descriptor for this position Oracle doesn't have an issue with alias names being the same as the column name you're aliasing. It handles that just fine. I do it in exactly that kind of way, where you're not really changing the meaning of the column, just verifying non-null-ness. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Oracle Error no descriptor for this position
Yes, we did that; no change. I wonder if LoadRunner is keeping the user sessions straight? thanks, Chris Norloff -- Original Message -- from: Deanna Schneider [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 18 Oct 2002 08:59:16 -0500 Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Oracle Error no descriptor for this position
Thanks. That response seems to be the Standard Oracle Tech Support Response, though if you don't run BullsEye it doesn't seem very relevant ... We're getting this error only under load, but not consistently. It's also popped up in other places in the past (from checking the old log files). Strange. thanks, Chris Norloff -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 18 Oct 2002 09:29:13 -0500 Oracle's Metalink has an article about a problem with Cold Fusion, Oracle and Bullseye conflict causing this error. Doc ID: 171452.995 Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Chris Norloff To: CF-Talk [EMAIL PROTECTED] cnorloff@norl cc: off.com Subject: Oracle Error no descriptor for this position 10/18/2002 08:39 AM Please respond to cf-talk We're getting the Oracle error ORA-24334: no descriptor for this position with the following query. Not having much luck finding out what's going on, or getting info from the MM CF forum, CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on Solaris 8, Oracle 8i db, with 8.1.7 client) thanks, Chris Norloff SELECT job_id, provider_code, NVL(financial_no, '0') financial_no, mailing_facility, job_title, process_category, class, local_permit_no, permit_type, total_piece, total_weight, cqt_total_pieces, cqt_weight, location_zip, owner_name, gca_version FROM m_job_summary WHERE job_id = 'QD2AES_1' AND provider_code = 'QUAD' AND mailing_facility = '22203-1553' Oracle's description of the error: ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Oracle Error no descriptor for this position
Yes, we did that; no change. I wonder if LoadRunner is keeping the user sessions straight? thanks, Chris Norloff -- Original Message -- from: Deanna Schneider [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 18 Oct 2002 08:59:16 -0500 Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm