Oracle Error
All, Has anyone ever experienced this error: [Oracle][ODBC][Ora]ORA-12163: TNS:connect descriptor is too long I am working with CF5 on windows using Oracle 8i drivers connecting to a 9i database - the error happens intermittently and I am having trouble replicating it for the client. I am seeing some things in the application.log which are causing some concern ie %20%20VALUE%20%20 but I am unclear as to why this would be causing an error when sending data. Any advice much appreciated Cheers Simon ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210455 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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
CF / Oracle Error : maximum cursors
I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has 294. It gets to about 190-200 rows before crapping out on me. Cold Fusion reports maximum opened cursors exceeded. I did some research and checked with our DBA.. Our cursor limit is set at 1500. I've looked over my code and cant see an issue with it. I uploaded 2 documents each with 1 row without a problem. I've uploaded 1 document with 800+ rows without a problem. I've uploaded a document of 1600 rows with no problem. It's real odd, when I get the Error, if I click on the link to take me back to the page and try again.. it works.. but then if I follow it with another file.. it bombs out on me. Has anyone seen this before and can anyone suggest an idea. I'd like to ask for an increase of the cursor limit as a last resort. code cfset isProblem = no cftransaction action=begin cftry cfquery name=getSweepID datasource=#application.config.getDSN()# SELECT seq_sweep_id.nextval AS id FROM DUAL /cfquery !--- insert main record --- cfquery name=sweepInsert datasource=#application.config.getDSN()# INSERT INTO SWEEP_MAIN ( SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID ) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfqueryparam value=#form.phoneid# cfsqltype=cf_sql_numeric, cfqueryparam value=#session.user.emplid# cfsqltype=cf_sql_varchar, sysdate, cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric ) /cfquery !--- get table name --- cfquery name=getTable datasource=#application.config.getDSN()# SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP WHERE category_id = cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric /cfquery !--- get table columns --- cfquery name=getCols datasource=#application.config.getDSN()# SELECT collate(t.column_name) as columns FROM all_tab_columns t WHERE t.table_name= '#getTable.tbl_name#' ORDER BY column_id /cfquery !--- loop over record and insert into table --- cfset strLen = ListLen(getCols.columns,',') cfset counter = 1 cfoutputPlease Wait Loading...br//cfoutput cffile action=read file=#cffile.serverDirectory#\#cffile.serverFile# variable=fileData cfloop index=record list=#fileData# delimiters=#chr(10)##chr(13)# cfif counter gt 1 cfquery name=qryInsert datasource=#application.config.getDSN()# INSERT INTO #getTable.tbl_name# (#getCols.columns#) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfloop from=1 to=#strLen-2# index=i cfoutput'#replace(evaluate(listgetat(record,#i#,chr(9))),'','',all)#'/cfoutput, /cfloop '#evaluate(listgetat(record,#strLen-1#,chr(9)))#' ) /cfquery /cfif cfset counter = counter + 1 /cfloop CFCATCH type=Any cfoutput h3Oops, There's been an error/h3 Please try again, if the problem persists br/ notify the administratorbr/ Message :#CFCATCH.message#p Type :#CFCATCH.type#p cfset isProblem = yes piRolling back the attempted transaction/i/p cftransaction action=ROLLBACK / cfquery name=delFile datasource=#application.config.getDSN()# DELETE FROM DOCUMENTS WHERE DOCID = cfqueryparam cfsqltype=cf_sql_numeric value=#docid# /cfquery /cfoutput /CFCATCH /cftry cfif isproblem eq no cftransaction action=COMMIT / script language=Javascript !-- alert(Finished: cfoutput#counter-2#/cfoutput rows added); location.href=../upload/ -- /script /cfif /cftransaction /cfif /code -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:
Re: CF / Oracle Error : maximum cursors
The problem isnt with Oracle.. I wrote 2 non-dynamic queries and uploaded several documents in a row. So it has to be within the query and the building of the dynamic query structure. On Thu, 11 Nov 2004 07:07:20 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has 294. It gets to about 190-200 rows before crapping out on me. Cold Fusion reports maximum opened cursors exceeded. I did some research and checked with our DBA.. Our cursor limit is set at 1500. I've looked over my code and cant see an issue with it. I uploaded 2 documents each with 1 row without a problem. I've uploaded 1 document with 800+ rows without a problem. I've uploaded a document of 1600 rows with no problem. It's real odd, when I get the Error, if I click on the link to take me back to the page and try again.. it works.. but then if I follow it with another file.. it bombs out on me. Has anyone seen this before and can anyone suggest an idea. I'd like to ask for an increase of the cursor limit as a last resort. code cfset isProblem = no cftransaction action=begin cftry cfquery name=getSweepID datasource=#application.config.getDSN()# SELECT seq_sweep_id.nextval AS id FROM DUAL /cfquery !--- insert main record --- cfquery name=sweepInsert datasource=#application.config.getDSN()# INSERT INTO SWEEP_MAIN ( SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID ) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfqueryparam value=#form.phoneid# cfsqltype=cf_sql_numeric, cfqueryparam value=#session.user.emplid# cfsqltype=cf_sql_varchar, sysdate, cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric ) /cfquery !--- get table name --- cfquery name=getTable datasource=#application.config.getDSN()# SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP WHERE category_id = cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric /cfquery !--- get table columns --- cfquery name=getCols datasource=#application.config.getDSN()# SELECT collate(t.column_name) as columns FROM all_tab_columns t WHERE t.table_name= '#getTable.tbl_name#' ORDER BY column_id /cfquery !--- loop over record and insert into table --- cfset strLen = ListLen(getCols.columns,',') cfset counter = 1 cfoutputPlease Wait Loading...br//cfoutput cffile action=read file=#cffile.serverDirectory#\#cffile.serverFile# variable=fileData cfloop index=record list=#fileData# delimiters=#chr(10)##chr(13)# cfif counter gt 1 cfquery name=qryInsert datasource=#application.config.getDSN()# INSERT INTO #getTable.tbl_name# (#getCols.columns#) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfloop from=1 to=#strLen-2# index=i cfoutput'#replace(evaluate(listgetat(record,#i#,chr(9))),'','',all)#'/cfoutput, /cfloop '#evaluate(listgetat(record,#strLen-1#,chr(9)))#' ) /cfquery /cfif cfset counter = counter + 1 /cfloop CFCATCH type=Any cfoutput h3Oops, There's been an error/h3 Please try again, if the problem persists br/ notify the administratorbr/ Message :#CFCATCH.message#p Type :#CFCATCH.type#p cfset isProblem = yes piRolling back the attempted transaction/i/p cftransaction action=ROLLBACK / cfquery name=delFile datasource=#application.config.getDSN()# DELETE FROM DOCUMENTS WHERE DOCID = cfqueryparam cfsqltype=cf_sql_numeric value=#docid# /cfquery /cfoutput /CFCATCH /cftry cfif isproblem eq no cftransaction action=COMMIT / script language=Javascript !-- alert(Finished: cfoutput#counter-2#/cfoutput rows added); location.href=../upload/ -- /script /cfif /cftransaction /cfif /code -- Auxilium meum a Domino -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
Re: CF / Oracle Error : maximum cursors
Well maybe the problem is with Oracle but the root of it isnt Oracle.. it's something with the way CF builds those queries and loads those files. On Thu, 11 Nov 2004 07:48:11 -0600, Greg Morphis [EMAIL PROTECTED] wrote: The problem isnt with Oracle.. I wrote 2 non-dynamic queries and uploaded several documents in a row. So it has to be within the query and the building of the dynamic query structure. On Thu, 11 Nov 2004 07:07:20 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has 294. It gets to about 190-200 rows before crapping out on me. Cold Fusion reports maximum opened cursors exceeded. I did some research and checked with our DBA.. Our cursor limit is set at 1500. I've looked over my code and cant see an issue with it. I uploaded 2 documents each with 1 row without a problem. I've uploaded 1 document with 800+ rows without a problem. I've uploaded a document of 1600 rows with no problem. It's real odd, when I get the Error, if I click on the link to take me back to the page and try again.. it works.. but then if I follow it with another file.. it bombs out on me. Has anyone seen this before and can anyone suggest an idea. I'd like to ask for an increase of the cursor limit as a last resort. code cfset isProblem = no cftransaction action=begin cftry cfquery name=getSweepID datasource=#application.config.getDSN()# SELECT seq_sweep_id.nextval AS id FROM DUAL /cfquery !--- insert main record --- cfquery name=sweepInsert datasource=#application.config.getDSN()# INSERT INTO SWEEP_MAIN ( SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID ) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfqueryparam value=#form.phoneid# cfsqltype=cf_sql_numeric, cfqueryparam value=#session.user.emplid# cfsqltype=cf_sql_varchar, sysdate, cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric ) /cfquery !--- get table name --- cfquery name=getTable datasource=#application.config.getDSN()# SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP WHERE category_id = cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric /cfquery !--- get table columns --- cfquery name=getCols datasource=#application.config.getDSN()# SELECT collate(t.column_name) as columns FROM all_tab_columns t WHERE t.table_name= '#getTable.tbl_name#' ORDER BY column_id /cfquery !--- loop over record and insert into table --- cfset strLen = ListLen(getCols.columns,',') cfset counter = 1 cfoutputPlease Wait Loading...br//cfoutput cffile action=read file=#cffile.serverDirectory#\#cffile.serverFile# variable=fileData cfloop index=record list=#fileData# delimiters=#chr(10)##chr(13)# cfif counter gt 1 cfquery name=qryInsert datasource=#application.config.getDSN()# INSERT INTO #getTable.tbl_name# (#getCols.columns#) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfloop from=1 to=#strLen-2# index=i cfoutput'#replace(evaluate(listgetat(record,#i#,chr(9))),'','',all)#'/cfoutput, /cfloop '#evaluate(listgetat(record,#strLen-1#,chr(9)))#' ) /cfquery /cfif cfset counter = counter + 1 /cfloop CFCATCH type=Any cfoutput h3Oops, There's been an error/h3 Please try again, if the problem persists br/ notify the administratorbr/ Message :#CFCATCH.message#p Type :#CFCATCH.type#p cfset isProblem = yes piRolling back the attempted transaction/i/p cftransaction action=ROLLBACK / cfquery name=delFile datasource=#application.config.getDSN()# DELETE FROM DOCUMENTS WHERE DOCID = cfqueryparam cfsqltype=cf_sql_numeric value=#docid# /cfquery /cfoutput /CFCATCH /cftry cfif isproblem eq no cftransaction action=COMMIT / script language=Javascript !-- alert(Finished:
Re: CF / Oracle Error : maximum cursors
We turned off 'maintain connections' for the DSN for this app and bamm! workie works! Doug On Thu, 11 Nov 2004 07:53:39 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Well maybe the problem is with Oracle but the root of it isnt Oracle.. it's something with the way CF builds those queries and loads those files. On Thu, 11 Nov 2004 07:48:11 -0600, Greg Morphis [EMAIL PROTECTED] wrote: The problem isnt with Oracle.. I wrote 2 non-dynamic queries and uploaded several documents in a row. So it has to be within the query and the building of the dynamic query structure. On Thu, 11 Nov 2004 07:07:20 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has 294. It gets to about 190-200 rows before crapping out on me. Cold Fusion reports maximum opened cursors exceeded. I did some research and checked with our DBA.. Our cursor limit is set at 1500. I've looked over my code and cant see an issue with it. I uploaded 2 documents each with 1 row without a problem. I've uploaded 1 document with 800+ rows without a problem. I've uploaded a document of 1600 rows with no problem. It's real odd, when I get the Error, if I click on the link to take me back to the page and try again.. it works.. but then if I follow it with another file.. it bombs out on me. Has anyone seen this before and can anyone suggest an idea. I'd like to ask for an increase of the cursor limit as a last resort. code cfset isProblem = no cftransaction action=begin cftry cfquery name=getSweepID datasource=#application.config.getDSN()# SELECT seq_sweep_id.nextval AS id FROM DUAL /cfquery !--- insert main record --- cfquery name=sweepInsert datasource=#application.config.getDSN()# INSERT INTO SWEEP_MAIN ( SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID ) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfqueryparam value=#form.phoneid# cfsqltype=cf_sql_numeric, cfqueryparam value=#session.user.emplid# cfsqltype=cf_sql_varchar, sysdate, cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric ) /cfquery !--- get table name --- cfquery name=getTable datasource=#application.config.getDSN()# SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP WHERE category_id = cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric /cfquery !--- get table columns --- cfquery name=getCols datasource=#application.config.getDSN()# SELECT collate(t.column_name) as columns FROM all_tab_columns t WHERE t.table_name= '#getTable.tbl_name#' ORDER BY column_id /cfquery !--- loop over record and insert into table --- cfset strLen = ListLen(getCols.columns,',') cfset counter = 1 cfoutputPlease Wait Loading...br//cfoutput cffile action=read file=#cffile.serverDirectory#\#cffile.serverFile# variable=fileData cfloop index=record list=#fileData# delimiters=#chr(10)##chr(13)# cfif counter gt 1 cfquery name=qryInsert datasource=#application.config.getDSN()# INSERT INTO #getTable.tbl_name# (#getCols.columns#) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfloop from=1 to=#strLen-2# index=i cfoutput'#replace(evaluate(listgetat(record,#i#,chr(9))),'','',all)#'/cfoutput, /cfloop '#evaluate(listgetat(record,#strLen-1#,chr(9)))#' ) /cfquery /cfif cfset counter = counter + 1 /cfloop CFCATCH type=Any cfoutput h3Oops, There's been an error/h3 Please try again, if the problem persists br/ notify the administratorbr/ Message :#CFCATCH.message#p Type :#CFCATCH.type#p cfset isProblem = yes piRolling back the attempted transaction/i/p cftransaction action=ROLLBACK / cfquery name=delFile datasource=#application.config.getDSN()# DELETE FROM DOCUMENTS WHERE DOCID =
CF / Oracle Error...
I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has 294. It gets to about 190-200 rows before crapping out on me. Cold Fusion reports maximum opened cursors exceeded. I did some research and checked with our DBA.. Our cursor limit is set at 1500. I've looked over my code and cant see an issue with it. I uploaded 2 documents each with 1 row without a problem. I've uploaded 1 document with 800+ rows without a problem. It only occurs when it's documents around 300 rows each. Has anyone seen this before and can anyone suggest an idea. I'd like to ask for an increase of the cursor limit as a last resort. code cfset isProblem = no cftransaction action=begin cftry cfquery name=getSweepID datasource=#application.config.getDSN()# SELECT seq_sweep_id.nextval AS id FROM DUAL /cfquery !--- insert main record --- cfquery name=sweepInsert datasource=#application.config.getDSN()# INSERT INTO SWEEP_MAIN ( SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID ) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfqueryparam value=#form.phoneid# cfsqltype=cf_sql_numeric, cfqueryparam value=#session.user.emplid# cfsqltype=cf_sql_varchar, sysdate, cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric ) /cfquery !--- get table name --- cfquery name=getTable datasource=#application.config.getDSN()# SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP WHERE category_id = cfqueryparam value=#form.category_id# cfsqltype=cf_sql_numeric /cfquery !--- get table columns --- cfquery name=getCols datasource=#application.config.getDSN()# SELECT collate(t.column_name) as columns FROM all_tab_columns t WHERE t.table_name= '#getTable.tbl_name#' ORDER BY column_id /cfquery !--- loop over record and insert into table --- cfset strLen = ListLen(getCols.columns,',') cfset counter = 1 cfoutputPlease Wait Loading...br//cfoutput cffile action=read file=#cffile.serverDirectory#\#cffile.serverFile# variable=fileData cfloop index=record list=#fileData# delimiters=#chr(10)##chr(13)# cfif counter gt 1 cfquery name=qryInsert datasource=#application.config.getDSN()# INSERT INTO #getTable.tbl_name# (#getCols.columns#) VALUES ( cfqueryparam value=#getSweepId.id# cfsqltype=cf_sql_numeric, cfloop from=1 to=#strLen-2# index=i cfoutput'#replace(evaluate(listgetat(record,#i#,chr(9))),'','',all)#'/cfoutput, /cfloop '#evaluate(listgetat(record,#strLen-1#,chr(9)))#' ) /cfquery /cfif cfset counter = counter + 1 /cfloop CFCATCH type=Any cfoutput h3Oops, There's been an error/h3 Please try again, if the problem persists br/ notify the administratorbr/ Message :#CFCATCH.message#p Type :#CFCATCH.type#p cfset isProblem = yes piRolling back the attempted transaction/i/p cftransaction action=ROLLBACK / cfquery name=delFile datasource=#application.config.getDSN()# DELETE FROM DOCUMENTS WHERE DOCID = cfqueryparam cfsqltype=cf_sql_numeric value=#docid# /cfquery /cfoutput /CFCATCH /cftry cfif isproblem eq no cftransaction action=COMMIT / script language=Javascript !-- alert(Finished: cfoutput#counter-2#/cfoutput rows added); location.href=../upload/ -- /script /cfif /cftransaction /cfif /code -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183909 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
Re: Strange Oracle Error
Check your logs. I think we've found that we often get these following another error that's tying up Oracle. To all you oracle guru's out there, can any of you shed some light for me? A client sent me this error, they could not get a screen shot of the error so I am not 100% positive that this is worded correctly as I have never seen this error before? Oracle Error Code=0 Timeout while obtaining Oracle statement lock. ...identifier of (CFQuery) occupying doc position (401:5) to (401:97). This error is on a page that performs many queries and can be slow at times.The code has been running good until recently.There have been no changes, other that the database growing in size. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Strange Oracle Error
I've seen that error when I've done soemthing in the DB and did not commit the changes. On Wed, 25 Aug 2004 09:20:37 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: Check your logs. I think we've found that we often get these following another error that's tying up Oracle. To all you oracle guru's out there, can any of you shed some light for me? A client sent me this error, they could not get a screen shot of the error so I am not 100% positive that this is worded correctly as I have never seen this error before? Oracle Error Code=0 Timeout while obtaining Oracle statement lock. ...identifier of (CFQuery) occupying doc position (401:5) to (401:97). This error is on a page that performs many queries and can be slow at times.The code has been running good until recently.There have been no changes, other that the database growing in size. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Strange Oracle Error
I have too but this is all through coldfusion and sp's should I have to commit or close any connections when executing via CF5.0? Thanks, David -Original message- From: Greg Morphis [EMAIL PROTECTED] Date: Wed, 25 Aug 2004 11:25:56 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Strange Oracle Error I've seen that error when I've done soemthing in the DB and did not commit the changes. On Wed, 25 Aug 2004 09:20:37 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: Check your logs. I think we've found that we often get these following another error that's tying up Oracle. To all you oracle guru's out there, can any of you shed some light for me? A client sent me this error, they could not get a screen shot of the error so I am not 100% positive that this is worded correctly as I have never seen this error before? Oracle Error Code=0 Timeout while obtaining Oracle statement lock. ...identifier of (CFQuery) occupying doc position (401:5) to (401:97). This error is on a page that performs many queries and can be slow at times.The code has been running good until recently.There have been no changes, other that the database growing in size. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Strange Oracle Error
To all you oracle guru's out there, can any of you shed some light for me? A client sent me this error, they could not get a screen shot of the error so I am not 100% positive that this is worded correctly as I have never seen this error before? Oracle Error Code=0 Timeout while obtaining Oracle statement lock. ...identifier of (CFQuery) occupying doc position (401:5) to (401:97). This error is on a page that performs many queries and can be slow at times.The code has been running good until recently.There have been no changes, other that the database growing in size. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Strange Oracle Error
To all you oracle guru's out there, can any of you shed some light for me? A client sent me this error, they could not get a screen shot of the error so I am not 100% positive that this is worded correctly as I have never seen this error before? Oracle Error Code=0 Timeout while obtaining Oracle statement lock. ...identifier of (CFQuery) occupying doc position (401:5) to (401:97). This error is on a page that performs many queries and can be slow at times.The code has been running good until recently.There have been no changes, other that the database growing in size. I'm no Oracle guru, but in any relational database you may have problems with lock contention. It sounds to me like some of your queries are taking long enough that they're blocking other queries from running. You may want to reexamine your indexing strategy. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Strange Oracle Error
Does anyone have any insights to the following oracle error? Error Diagnostic Information ODBC Error Code = S1000 (General error) [Oracle][ODBC][Ora]ORA-02041: client database did not begin a transaction SQL = select MYFIELD from MYVIEW Data Source = MYDATASOURCE The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:51) in the template file . Here's the strange part. When I use SQL+ to access the oracle view, the query returns data. Specs: Cold Fusion 5 Oracle 8i Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 = 1704PORA-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) thanks for any help Ricki ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137425 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
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 = 1704PORA-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: Coldfusion Message - Oracle Error Code = 0
Sounds to me like there weren't enough database connections available, and CF timed out while waiting to get a lock (or handle, or thread) to talk to Oracle. Chris Norloff -- Original Message -- from: Gary Groomer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 28 Oct 2002 19:45:50 -0800 The company that I am working for, is periodically, bombarded with the following error message: Coldfusion Error Type - DATABASE Coldfusion Message - Oracle Error Code = 0 Timeout while obtaining an Oracle connection lock They are running CF 5 with Oracle 8i on the backend and are using the native drivers to connect to Oracle. I have searched high and low, but have not been able to find a definitive solution. Has anyone run into this error and found a solution? Gary Groomer ~| 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.
Coldfusion Message - Oracle Error Code = 0
The company that I am working for, is periodically, bombarded with the following error message: Coldfusion Error Type - DATABASE Coldfusion Message - Oracle Error Code = 0 Timeout while obtaining an Oracle connection lock They are running CF 5 with Oracle 8i on the backend and are using the native drivers to connect to Oracle. I have searched high and low, but have not been able to find a definitive solution. Has anyone run into this error and found a solution? Gary Groomer ~| 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
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
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 Timentrytabledetails 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 errrmmaybe thousands of records in a very short time Any ideas? Hewp! 0_0 -Gel __ 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://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
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
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
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 debbie.mcdaniel@dataTo: CF-Talk [EMAIL PROTECTED] -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
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
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 msg snipped __ 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
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 Herbener Kentucky Department of Education ~~ 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 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
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! CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC /CFQUERY 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! CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC /CFQUERY 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! CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC /CFQUERY 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! CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC /CFQUERY 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?
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! CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" SELECT headline, news, blurb, date_entered, newsID, live, top FROM news WHERE(live = 'YES') and (WHERE top = 'NO') ORDER by date_entered DESC /CFQUERY 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
wierd oracle error
We recently went from native drivers to odbc. I currently have a wierd error that is occurring: ODBC Error Code = 37000 (Syntax error or access violation) [Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable conversion requested SQL = "ep_upd_Employment" Has anyone seen this before? John ~~ 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
Strange Oracle error
Anyone seen this error from Oracle - ODBC Error Code = S1000 (General error)P [Oracle][ODBC][Ora]ORA-24357: internal error while converting from to OCIDate. It is happening on a VERY simple query with NO dates in the query, but when it happens CF locks up tight. There is nothing on it on the support forums, and the Oracle "action" for that error message is "contact customer support" which our DBA is doing. Just hoping someone has seen it and fixed it already? Dan The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. ~~ 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]
Intermittent Oracle error msg
This is a strange problem, which I haven't found in the Allaire Knowledge Base or HouseOfFusion Archives, so here goes: After several months of successfully running CF Server 4.0.1 on Solaris, we are experiencing episodes during which there is an Oracle error message on every query, as follows: Oracle Error Code = 12154 ORA-12154 TNS:could not resolve service name Yet, when the same SQL is pasted into SQL*Plus on my PC, the query executes fine! I've seen this error message on a PC before, when "SQL Net Easy Configuration" had missing or incorrect settings. This doesn't explain the intermittent nature of this problem, or how to ultimately fix it. Our DBA can find nothing wrong. Has anyone else experienced this phenomenon? Any recommendation to solve it? Thanks much, Kevin Carlson Quality Systems Engineer ATT Wireless Services -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Intermittent Oracle error msg
Are the database definitions in the local tnsnames.ora file? Or is that local file pointing at another server to get the database definitions? We had problems with the local tnsnames.ora file pointing at another server to find out where the databases were. Everytime that server was rebooted, etc., we got the same message. We got the DBAs to push the tnsnames.ora file out to our web servers whenever they made changes and we've been fine since. Dan -Original Message- From: Carlson, Kevin To: '[EMAIL PROTECTED]' Sent: 7/17/2000 5:46 PM Subject: Intermittent Oracle error msg This is a strange problem, which I haven't found in the Allaire Knowledge Base or HouseOfFusion Archives, so here goes: After several months of successfully running CF Server 4.0.1 on Solaris, we are experiencing episodes during which there is an Oracle error message on every query, as follows: Oracle Error Code = 12154 ORA-12154 TNS:could not resolve service name Yet, when the same SQL is pasted into SQL*Plus on my PC, the query executes fine! I've seen this error message on a PC before, when "SQL Net Easy Configuration" had missing or incorrect settings. This doesn't explain the intermittent nature of this problem, or how to ultimately fix it. Our DBA can find nothing wrong. Has anyone else experienced this phenomenon? Any recommendation to solve it? Thanks much, Kevin Carlson Quality Systems Engineer ATT Wireless Services -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Oracle error 01000
My CF app users have also been getting the Oracle error "ORA-01000: maximum open cursors exceeded" occasionally. My Oracle DBA tells me my cursor-related parameters are currently: close_cached_open_cursors (currently = FALSE) cursor_space_for_time (currently = FALSE) open_cursors (currently = 50) Forgive my Oracle ignorance, but do we need to set the open_cursors parameter high enough to accommodate the maximum number of simultaneous users at my site? Or...? CF Enterprise 4.5.1 Oracle native CF driver to an Oracle 7.3 db NT 4.0, SP 6 Ricq Pattay [EMAIL PROTECTED] Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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=listsbody=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=listsbody=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=listsbody=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=listsbody=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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: oracle error/TITLE /HEAD BODY PFONT SIZE=3D2what does your schema look like for this table?nbsp; = I dunno if those '' are being interpretted as NULLS, so check to see if = linkpage and imagename allow nulls or not/FONT/P PFONT SIZE=3D2also, you may have to surround your dates in single = quotes too./FONT /P PFONT SIZE=3D2just things to try really.nbsp; Oracle error = messages are usually a joke./FONT /P PFONT SIZE=3D2post your schema and I will see if I can spot = anything/FONT /P PFONT SIZE=3D2--b/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Deanna L. Schneider [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:deanna.schneider@ce= s.uwex.edu/A]/FONT BRFONT SIZE=3D2Sent: Tuesday, May 30, 2000 2:54 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: oracle error/FONT /P BR PFONT SIZE=3D2I'm relatively new to oracle. I've looked at the = oracle site and not been/FONT BRFONT SIZE=3D2able to figure this out. Help anyone? The oracle = site says that the error/FONT BRFONT SIZE=3D2usually means a column name was used in the = quot;valuesquot; section of an insert/FONT BRFONT SIZE=3D2query, but none of those values are also column = names.../FONT /P PFONT SIZE=3D2Oracle Error Code =3D 984/FONT /P PFONT SIZE=3D2ORA-00984: column not allowed here/FONT /P BR BR PFONT SIZE=3D2SQL =3D quot;INSERT INTO = coopep.coopwebnews(articleid, headline, fulltext,/FONT BRFONT SIZE=3D2linkpage, imagename, publishdate, archivedate, = sortorder) VALUES (4, 'Test/FONT BRFONT SIZE=3D2Insert Article',/FONT BRFONT = SIZE=3D2'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsak= jfdlaskjdflka/FONT BRFONT = SIZE=3D2sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlaj= sld;fjalskfjd/FONT BRFONT SIZE=3D2lsakjfdlaskjfdlskajfdThisistheend.', '', '', = 04-Apr-2000, 10-Oct-2000, 3)quot;/FONT /P PFONT SIZE=3D2Data Source =3D quot;d815aquot;/FONT /P PFONT SIZE=3D2The error occurred while processing an element with a = general identifier of/FONT BRFONT SIZE=3D2(CFQUERY), occupying document position (17:1) to = (17:91)./FONT /P BR BR BR PFONT = SIZE=3D2/F= ONT BRFONT SIZE=3D2Deanna Schneider/FONT BRFONT SIZE=3D2Interactive Media Developer/FONT BRFONT SIZE=3D2UWEX Cooperative Extension El
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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.