Re: Oracle Error
On 6/23/05, Simon Whittaker <[EMAIL PROTECTED]> wrote: > Has anyone ever experienced this error: > > [Oracle][ODBC][Ora]ORA-12163: TNS:connect descriptor is too long http://www.stanford.edu/dept/itss/docs/oracle/9i/em.920/a96676/trouble.htm#630120 HTH -- Eddie. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210465 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Oracle error
> We have an Oracle 8.15 database. We have recently been experiencing periodic error meesage when some of our CF scripts try to execute an insert statement. The error that is returned is > > Error Message: Oracle Error Code = 1704ORA-01704: string literal too long > > When I copy and paste the SQL insert statement into SQLPlus it inserts teh data, no problem. > > This is only happening with long strings of data (varchar(4000)). The one change I do make when I paste it into sqlplus is that I insert carriage returns into any single line that is too long. This is because SQLPlus has issues with lines that are too long and if I dont put these in then SQLPlus gives me a different error indicating it can't handle the length. > > Has anyone seen this behavior before? If not, does anyone know of a way to add line breaks into a string every 90 charachters or so (reemembering that the line breaks can't occur in the middle of a word) > For strings that long, use cfqueryparam with the cf_sql_longvarchar type. We use CLOBs on CF 4.5 using cfqueryparam (11K, 12K, etc) with no problem. Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137428 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
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=lists&body=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=lists&body=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'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=lists&body=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
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=lists&body=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 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=lists&body=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
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=lists&body=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
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]> > > >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=lists&body=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=lists&body=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
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=lists&body=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'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]> 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=lists&body=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
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=lists&body=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
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=lists&body=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
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=lists&body=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 about extending tablespace..
check the disk space on the drive on which the table resides. you may be out. christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 2:15 PM To: CF-Talk Subject: Oracle Error about extending tablespace.. Hi all, I don't know Oracle very well, and a client is getting this error from a website I built for them that uses Oracle. Oracle Error Code = 1653 ORA-01653: unable to extend table Timentry.tabledetails by 41 in tablespace TIMENTRY This is happening whenever someone tries to add a new record to the database. The tabledetails table takes very high traffic and can potentially have errrm..maybe thousands of records in a very short time. Any ideas? Hewp! 0_0 -Gel __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Error
First I'd add a bunch of cftry/catch statements to catch the database errors so CF isn't crashing all the time. Then I'd work with the DBA's and the settings in CFadmin's Native Drivers (or you might be using ODBC, but I think Native Drivers are better). We use no limit to connections, we maintain database connections, we do not timeout connections [these are the default settings for our Oracle Native Drivers]. Chris Norloff -- Original Message -- From: Debbie McDaniel <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Feb 2002 10:57:46 -0500 >Hi everyone, >I keep getting these weird errors with Oracle 8i that of course are being >blamed on ColdFusion. Here goes. >Our webserver sits in the DMZ and our database server is inside the >firewall. All traffic going from the webserver goes through the firewall to >talk to the database. >I seem to be able to access the database through coldfusion 90% of the time, >but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to >connect to destination error, both of which result in massive errors in the >application and the eventual rebooting of the machine. >I am thinking it may be a network issue, but because coldfusion is new to >this company they want to blame it. If I log in with sql+ (an oracle client) >I can access the datasource w/o trouble, although cf can't even verify the >datasource. This usually happens after several moderate hits to the >datasource. >We are running CF 4.5.2 with all the appropriate patches applied on a Compaq >Windows 2000 machine with all the appropriate service packs applied to >Win2K. Our database is Oracle 8i - anyone have some suggestions? >Greatly appreciated! >Debbie M. >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error
Just some places to look, -Are the threads to the database set up to be kept alive in the CF Admin? -Is TNS configured to disconnect inactive DB threads? -There may be problems with the DNS server. -Also, if 8i works like an Application Server, you may need to check the port range for which it communicates to make sure it has an adequate range to speak through. Greg McDaniel -Original Message- > From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 10:58 AM > To: CF-Talk > Subject: Oracle Error > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error
See if you can get the networking people to configure the firewall to log all traffic, both allowed and disallowed, from the CF server to the Oracle db, for a period of time that includes success and CF errors; that is likely to show something interesting. Without specific configuration, the Oracle client on the CF server may try to use different ports on the server side, which could confuse the firewall or be rejected. > -Original Message- > From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 10:58 AM > To: CF-Talk > Subject: Oracle Error > > > Hi everyone, > I keep getting these weird errors with Oracle 8i that of > course are being > blamed on ColdFusion. Here goes. > Our webserver sits in the DMZ and our database server is inside the > firewall. All traffic going from the webserver goes through > the firewall to > talk to the database. > I seem to be able to access the database through coldfusion > 90% of the time, > but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to > connect to destination error, both of which result in massive > errors in the > application and the eventual rebooting of the machine. > I am thinking it may be a network issue, but because > coldfusion is new to > this company they want to blame it. If I log in with sql+ (an > oracle client) > I can access the datasource w/o trouble, although cf can't > even verify the > datasource. This usually happens after several moderate hits to the > datasource. > We are running CF 4.5.2 with all the appropriate patches > applied on a Compaq > Windows 2000 machine with all the appropriate service packs applied to > Win2K. Our database is Oracle 8i - anyone have some suggestions? > Greatly appreciated! > Debbie M. > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Error
Have you checked the limitations on your firewall? We ran into a similar situation (with a similar network configuration), and we discovered that it was because our firewall (Raptor) only supported 30 concurrent Oracle connections at a time, which essentially made all of our DMZ CF/Oracle sites non-functional. To alleviate the situation, we used Connection Manager to set up the connections, and everything has been fine since. Debbie McDaniel -line.com> cc: Subject: Oracle Error 02/07/2002 09:57 AM Please respond to cf-talk Hi everyone, I keep getting these weird errors with Oracle 8i that of course are being blamed on ColdFusion. Here goes. Our webserver sits in the DMZ and our database server is inside the firewall. All traffic going from the webserver goes through the firewall to talk to the database. I seem to be able to access the database through coldfusion 90% of the time, but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to connect to destination error, both of which result in massive errors in the application and the eventual rebooting of the machine. I am thinking it may be a network issue, but because coldfusion is new to this company they want to blame it. If I log in with sql+ (an oracle client) I can access the datasource w/o trouble, although cf can't even verify the datasource. This usually happens after several moderate hits to the datasource. We are running CF 4.5.2 with all the appropriate patches applied on a Compaq Windows 2000 machine with all the appropriate service packs applied to Win2K. Our database is Oracle 8i - anyone have some suggestions? Greatly appreciated! Debbie M. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle error ORA-24334
> Has anyone else seen an Oracle error "ORA-24334 no descriptor for this > position" ? I'm getting it very rarely with a query that generally works ok. > CF 4.51 SP2, oracle client 8.1.6, Oracle server 8.0.4.4. Martin, I haven't seen this one in particular, but I have seen and heard of lots of problems with Oracle unless you upgrade to the latest client software on the CF Server machine. We use 8i with V8.1.7 drivers, and STILL can't get CLOBs to work properly with CF4.5.1SP2, but that's our only problem since the upgrade. Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. Want truly advanced ColdFusion 5 training? Register for the Advanced Bootcamp for ColdFusion 5, Database, and Javascript at http://www.ColdFusionTraining.com! http://www.CommerceBlocks.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error 936 missing expression?? Query problem?
What about: WHERElive = YES and top = NO My understanding is that with Boolean characters, you don't put in an apostrophe If your designations aren't Boolean, try: WHERElive = 'YES' and top = 'NO' Regards, Derek IT Star Web Design, Hosting, Database Integration and Internet Marketing http://www.itstar.co.uk/ [EMAIL PROTECTED] -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: 27 March 2001 15:19 To: CF-Talk Subject: Oracle Error 936 missing expression?? Query problem? Hello All, I have a simple query, for an oracle database and I keep getting an error message. What the heck is wrong with my query! SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC I've tried everything in there. It seems to be an error with syntax and the WHERE line. Any hints, clues or great answers are much appreciated! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Error 936 missing expression?? Query problem?
Shouldn't that be WHERE live = 'YES' and top = 'NO' Tim P. - Original Message - From: "Jeff Fongemie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 27, 2001 9:18 AM Subject: Oracle Error 936 missing expression?? Query problem? > Hello All, > > I have a simple query, for an oracle database and I keep getting an > error message. What the heck is wrong with my query! > > SELECT > headline, news, blurb, date_entered, newsID, live, top > FROM news > WHERE(live = 'YES') and (WHERE top = 'NO') > > ORDER by date_entered DESC > > > I've tried everything in there. It seems to be an error with syntax > and the WHERE line. > > Any hints, clues or great answers are much appreciated! > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > > Internet Guns For Hire > (603) 356-0768 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Error 936 missing expression?? Query problem?
Remove the parens and the second WHERE from your where statement. You dont' need them. WHERE live = 'YES' AND top = 'NO' Dave - Original Message - From: "Jeff Fongemie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 27, 2001 9:18 AM Subject: Oracle Error 936 missing expression?? Query problem? > Hello All, > > I have a simple query, for an oracle database and I keep getting an > error message. What the heck is wrong with my query! > > SELECT > headline, news, blurb, date_entered, newsID, live, top > FROM news > WHERE(live = 'YES') and (WHERE top = 'NO') > > ORDER by date_entered DESC > > > I've tried everything in there. It seems to be an error with syntax > and the WHERE line. > > Any hints, clues or great answers are much appreciated! > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > > Internet Guns For Hire > (603) 356-0768 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error 936 missing expression?? Query problem?
Shouldn't it read: SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE live = 'YES' and top = 'NO' ORDER by date_entered DESC Alec Lamon > -Original Message- > From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 9:19 AM > To: CF-Talk > Subject: Oracle Error 936 missing expression?? Query problem? > > > Hello All, > > I have a simple query, for an oracle database and I keep getting an > error message. What the heck is wrong with my query! > > SELECT > headline, news, blurb, date_entered, newsID, live, top > FROM news > WHERE(live = 'YES') and (WHERE top = 'NO') > > ORDER by date_entered DESC > > > I've tried everything in there. It seems to be an error with syntax > and the WHERE line. > > Any hints, clues or great answers are much appreciated! > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > > Internet Guns For Hire > (603) 356-0768 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: oracle error
Jason, What kind of firewall? Regards Stew I have just recently moved from test to acceptance... we also moved the database from the DMZ to inside the firewall... I seem to be able to access the database through coldfusion 90% of the time, but sometimes I will get an ora 0 error or the such... included is the error that is logged. I am thinking it may be a network issue, but because coldfusion is new to this company they want to blame it. If I log in with sql+ (an oracle client) I can access the datasource w/o trouble, although cf can't even verify the datasource. This usually happens after several moderate hits to the datasource. We are running on sun with oracle 8i - anyone have some suggestions? Greatly appreciated! Jason Egan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error Code = 3113 and 3114
most likely a networking problem; these are variants of " help, i can't find the server". -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 2:48 PM To: CF-Talk Subject: OT:Oracle Error Code = 3113 and 3114 Any one seen an Oracle Error Code = 3113 or 3114? Anyidea how to fix? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: oracle error
Woo hoo! Thanks. I knew it must be something simple. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: oracle error
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_01BFCA69.CA642360 Content-Type: text/plain; charset="iso-8859-1" what does your schema look like for this table? I dunno if those '' are being interpretted as NULLS, so check to see if linkpage and imagename allow nulls or not also, you may have to surround your dates in single quotes too. just things to try really. Oracle error messages are usually a joke. post your schema and I will see if I can spot anything --b -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 30, 2000 2:54 PM To: [EMAIL PROTECTED] Subject: oracle error I'm relatively new to oracle. I've looked at the oracle site and not been able to figure this out. Help anyone? The oracle site says that the error usually means a column name was used in the "values" section of an insert query, but none of those values are also column names... Oracle Error Code = 984 ORA-00984: column not allowed here SQL = "INSERT INTO coopep.coopwebnews(articleid, headline, fulltext, linkpage, imagename, publishdate, archivedate, sortorder) VALUES (4, 'Test Insert Article', 'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsakjfdlaskjdflka sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlajsld;fjalskfjd lsakjfdlaskjfdlskajfdThisistheend.', '', '', 04-Apr-2000, 10-Oct-2000, 3)" Data Source = "d815a" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (17:1) to (17:91). Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFCA69.CA642360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: oracle error what does your schema look like for this table? = I dunno if those '' are being interpretted as NULLS, so check to see if = linkpage and imagename allow nulls or not also, you may have to surround your dates in single = quotes too. just things to try really. Oracle error = messages are usually a joke. post your schema and I will see if I can spot = anything --b -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]">mailto:deanna.schneider@ce= s.uwex.edu] Sent: Tuesday, May 30, 2000 2:54 PM To: [EMAIL PROTECTED] Subject: oracle error I'm relatively new to oracle. I've looked at the = oracle site and not been able to figure this out. Help anyone? The oracle = site says that the error usually means a column name was used in the = "values" section of an insert query, but none of those values are also column = names... Oracle Error Code =3D 984 ORA-00984: column not allowed here SQL =3D "INSERT INTO = coopep.coopwebnews(articleid, headline, fulltext, linkpage, imagename, publishdate, archivedate, = sortorder) VALUES (4, 'Test Insert Article', 'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsak= jfdlaskjdflka sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlaj= sld;fjalskfjd lsakjfdlaskjfdlskajfdThisistheend.', '', '', = 04-Apr-2000, 10-Oct-2000, 3)" Data Source =3D "d815a" The error occurred while processing an element with a = general identifier of (CFQUERY), occupying document position (17:1) to = (17:91). Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing = Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ---= --- Archives: http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body. --_=_NextPart_001_01BFCA69.CA642360-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: oracle error
Oracle wants dates enclosed in single quotes ('04-Apr-2000' instead of 04-Apr-2000) and is trying to interpret 04-Apr-2000 as a column name since it doesn't think it's a date value. -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 30, 2000 2:54 PM To: [EMAIL PROTECTED] Subject: oracle error I'm relatively new to oracle. I've looked at the oracle site and not been able to figure this out. Help anyone? The oracle site says that the error usually means a column name was used in the "values" section of an insert query, but none of those values are also column names... Oracle Error Code = 984 ORA-00984: column not allowed here SQL = "INSERT INTO coopep.coopwebnews(articleid, headline, fulltext, linkpage, imagename, publishdate, archivedate, sortorder) VALUES (4, 'Test Insert Article', 'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsakjfdlaskjdflka sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlajsld;fjalskfjd lsakjfdlaskjfdlskajfdThisistheend.', '', '', 04-Apr-2000, 10-Oct-2000, 3)" Data Source = "d815a" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (17:1) to (17:91). Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.