Oracle Error

2005-06-23 Thread Simon Whittaker
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

2005-06-23 Thread Eddie
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

2004-11-11 Thread Greg Morphis
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

2004-11-11 Thread Greg Morphis
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

2004-11-11 Thread Greg Morphis
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

2004-11-11 Thread Douglas Knudsen
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...

2004-11-10 Thread Greg Morphis
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

2004-08-25 Thread Deanna Schneider
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

2004-08-25 Thread Greg Morphis
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

2004-08-25 Thread djones
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

2004-08-24 Thread djones
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

2004-08-24 Thread Dave Watts
 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

2003-10-29 Thread Jeremy Brodie
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

2003-09-17 Thread ricki . stern
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

2003-09-17 Thread Dave Carabetta
 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

2002-10-29 Thread Chris Norloff
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

2002-10-28 Thread Gary Groomer
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

2002-10-24 Thread Chris Norloff
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

2002-10-23 Thread Tony Schreiber
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

2002-10-22 Thread Tony Schreiber
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

2002-10-22 Thread Chris Norloff
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

2002-10-22 Thread Deanna Schneider
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

2002-10-18 Thread Chris Norloff
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

2002-10-18 Thread Mosh Teitelbaum
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

2002-10-18 Thread Deanna Schneider
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

2002-10-18 Thread Deanna Schneider
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

2002-10-18 Thread kpeterson
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

2002-10-18 Thread Mosh Teitelbaum
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

2002-10-18 Thread Chris Norloff
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

2002-10-18 Thread Chris Norloff
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

2002-10-18 Thread Chris Norloff
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..

2002-03-01 Thread Angel Stewart

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..

2002-03-01 Thread Christopher Olive

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

2002-02-08 Thread Chris Norloff

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

2002-02-07 Thread Debbie McDaniel

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

2002-02-07 Thread erica . vitina

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

2002-02-07 Thread Herbener, Martin - School Information Technology

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

2002-02-07 Thread Greg McDaniel

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

2001-05-17 Thread mherbene

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

2001-05-17 Thread Adam Phillip Churvis

 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?

2001-03-27 Thread Jeff Fongemie

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?

2001-03-27 Thread Lamon, Alec

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?

2001-03-27 Thread Dave Hannum

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?

2001-03-27 Thread Tim Painter

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?

2001-03-27 Thread Derek Havelock

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

2001-02-08 Thread John Anderson

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

2001-01-18 Thread Dan Haley

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

2000-11-22 Thread Stewart McGowan

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

2000-10-27 Thread mherbene

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

2000-07-17 Thread Carlson, Kevin

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

2000-07-17 Thread Dan Haley

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

2000-06-27 Thread Ricq Pattay

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

2000-05-30 Thread Deanna L. Schneider

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

2000-05-30 Thread mherbene

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

2000-05-30 Thread Bryan Batchelder

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

2000-05-30 Thread Deanna L. Schneider

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.