error = [265946] Multiple-step operation completed with one or more errors. Check each status value.

From: Paul Allen <pallen_at_fgcu.edu>
Date: 11 Mar 2004 14:00:17 -0800
Message-ID: <e5f5f221.0403111400.79826d2e_at_posting.google.com>

The little bit of help I can find on this error message "error = [265946] Multiple-step operation completed with one or more errors. Check each status value." is just not helping me figure out why ASP will not process this statement. Looking for help!

Here is my code:

		v_fsyr = "04"
		v_prd = "08"

		' get a db connection
		set con = Server.CreateObject("ADODB.Connection")
		con.Provider = "OraOLEDB.Oracle"
		con.ConnectionString = "USER ID=****;Password=******;Data
Source=****;"
		con.Open
		
		Response.write "<!-- Connection status = " & con.state & "-->"

SQL = ""
SQL = SQL &  " select 	fid, ext_fund, gl_code, ext_pgrm, sum(amt) "
SQL = SQL &  " from ( "
SQL = SQL &  " select 	decode(ftyp1.ftvftyp_ftyp_code_pred, "
SQL = SQL &  " 		'10',decode(substr(fgbgenl_fund_code,1,5),'10001','10001x',


"

SQL = SQL &  " 				decode(fgbgenl_fund_code,'10002',fgbgenl_fund_code,


"

SQL = SQL &  " 					decode(fund3.ftvfund_fund_code_pred,'15000','14000',fund3.ftvfund_fund_code_pred))),


"

SQL = SQL &  " 		'20',fund2.ftvfund_fund_code_pred, "
SQL = SQL &  " 		'40',fund3.ftvfund_fund_code_pred, "
SQL = SQL &  " 		'80',decode(fgbgenl_fund_code,'99004','99004','99005','99005',fund2.ftvfund_fund_code_pred),


"

SQL = SQL &  " 		'90',decode(fgbgenl_fund_code,'51019','51019','51022','51022',


"

SQL = SQL &  " 				decode(fund3.ftvfund_fund_code_pred,'52000','52000','53000','53000','54000','54000')),


"

SQL = SQL &  " 		'94',fgbgenl_fund_code, "
SQL = SQL &  " 		'96',fgbgenl_fund_code, "
SQL = SQL &  " 		'N/A' "
SQL = SQL &  " 	) fid, "
SQL = SQL &  " 	fgbgenl_fund_code level_4, "
SQL = SQL &  " 	fund3.ftvfund_fund_code_pred level_3, "
SQL = SQL &  " 	fund2.ftvfund_fund_code_pred level_2, "
SQL = SQL &  " 	ftyp1.ftvftyp_ftyp_code_pred ftyp1, "
SQL = SQL &  " 	ftyp1.ftvftyp_ftyp_code ftyp2, "
SQL = SQL &  " 	ftyp2.ftvftyp_ftyp_code ext_fund, "
SQL = SQL &  " 	ftvacct_acct_code_pred gl_code, "
SQL = SQL &  " 	null ext_pgrm, "
SQL = SQL &  " 	null pgrm, "
SQL = SQL &  " 	ftvacct_normal_bal nbal, "
SQL = SQL &  " 	decode(ftvacct_normal_bal,'D',"
SQL = SQL &  " 		fgbgenl_sum_periodic_dr - fgbgenl_sum_periodic_cr,"
SQL = SQL &  " 		fgbgenl_sum_periodic_cr - fgbgenl_sum_periodic_dr)

amt "
SQL = SQL & " from fgbgenl, ftvfund fund3, ftvfund fund2, ftvftyp ftyp1, ftvftyp ftyp2, ftvacct"

SQL = SQL &  " where fund3.ftvfund_fund_code 		= fgbgenl_fund_code "
SQL = SQL &  " 	and fund3.ftvfund_nchg_date		= '31-DEC-2099' "
SQL = SQL &  " 	and ftyp1.ftvftyp_ftyp_code		= fund3.ftvfund_ftyp_code


"

SQL = SQL &  " 	and ftyp1.ftvftyp_nchg_date		= '31-DEC-2099' "
SQL = SQL &  " 	and fund2.ftvfund_fund_code 	=
fund3.ftvfund_fund_code_pred "
SQL = SQL &  " 	and fund2.ftvfund_nchg_date		= '31-DEC-2099' "
SQL = SQL &  " 	and ftyp2.ftvftyp_ftyp_code		= fund2.ftvfund_ftyp_code


"

SQL = SQL &  " 	and ftyp2.ftvftyp_nchg_date		= '31-DEC-2099' "
SQL = SQL &  " 	and ftvacct_acct_code			= fgbgenl_acct_code "
SQL = SQL &  " 	and ftvacct_nchg_date			= '31-DEC-2099' "
SQL = SQL &  " 	and (substr(fgbgenl_fund_code,1,5)	= '10001' "
SQL = SQL &  " 		or fgbgenl_fund_code in
('10002','70001','80001','99004','99005') "
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred between '11000' and
'17000' "
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred = '31000' "
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred between '52000' and
'54000' "
SQL = SQL &  " 		or fund2.ftvfund_fund_code_pred between '200' and
'220' "
SQL = SQL &  " 		or fund2.ftvfund_fund_code_pred = '900') "
SQL = SQL &  " 	and (ftvacct_acct_code_pred != '59400' "
SQL = SQL &  " 		and ftvacct_acct_code_pred != '79400' "
SQL = SQL &  " 		and ftvacct_acct_code_pred < '80000')"
SQL = SQL &  " 	and fgbgenl_fsyr_code = '" & v_fsyr & "' "
SQL = SQL &  " 	and fgbgenl_period <= '" & v_prd & "'"
SQL = SQL &  " union all"
SQL = SQL &  " select       decode(ftyp1.ftvftyp_ftyp_code_pred,"
SQL = SQL &  " 		'10',decode(substr(fgbopal_fund_code,1,5),'10001','10001x',"
SQL = SQL &  " 				decode(fgbopal_fund_code,'10002',fgbopal_fund_code,"
SQL = SQL &  " 					decode(fund3.ftvfund_fund_code_pred,'15000','14000',fund3.ftvfund_fund_code_pred))),"
SQL = SQL &  " 		'20',fund2.ftvfund_fund_code_pred,"
SQL = SQL &  " 		'40',fund3.ftvfund_fund_code_pred,"
SQL = SQL &  " 		'80',decode(fgbopal_fund_code,'99004','99004','99005','99005',fund2.ftvfund_fund_code_pred),"
SQL = SQL &  " 		'90',decode(fgbopal_fund_code,'51019','51019','51022','51022',"
SQL = SQL &  " 				decode(fund3.ftvfund_fund_code_pred,'52000','52000','53000','53000','54000','54000')),"
SQL = SQL &  " 		'94',fgbopal_fund_code,"
SQL = SQL &  " 		'96',fgbopal_fund_code,"
SQL = SQL &  " 		'N/A'"
SQL = SQL &  " 	) fid,"
SQL = SQL &  " 	fgbopal_fund_code level_4,"
SQL = SQL &  " 	fund3.ftvfund_fund_code_pred level_3,"
SQL = SQL &  " 	fund2.ftvfund_fund_code_pred level_2,"
SQL = SQL &  " 	ftyp1.ftvftyp_ftyp_code_pred ftyp1,"
SQL = SQL &  " 	ftyp1.ftvftyp_ftyp_code ftyp2,"
SQL = SQL &  " 	ftyp2.ftvftyp_ftyp_code ext_fund,"
SQL = SQL &  " 	ftvacct_acct_code_pred gl_code,"
SQL = SQL &  " 	ftvprog_prog_code_pred ext_pgrm,"
SQL = SQL &  " 	fgbopal_prog_code pgrm,"
SQL = SQL &  " 	ftvacct_normal_bal nbal,"
SQL = SQL &  " 	decode('" & v_prd & "','00',fgbopal_00_ytd_actv,"
SQL = SQL &  " 			'01',fgbopal_01_ytd_actv,"
SQL = SQL &  " 			'02',fgbopal_02_ytd_actv,"
SQL = SQL &  " 			'03',fgbopal_03_ytd_actv,"
SQL = SQL &  " 			'04',fgbopal_04_ytd_actv,"
SQL = SQL &  " 			'05',fgbopal_05_ytd_actv,"
SQL = SQL &  " 			'06',fgbopal_06_ytd_actv,"
SQL = SQL &  " 			'07',fgbopal_07_ytd_actv,"
SQL = SQL &  " 			'08',fgbopal_08_ytd_actv,"
SQL = SQL &  " 			'09',fgbopal_09_ytd_actv,"
SQL = SQL &  " 			'10',fgbopal_10_ytd_actv,"
SQL = SQL &  " 			'11',fgbopal_11_ytd_actv,"
SQL = SQL &  " 			'12',fgbopal_12_ytd_actv,"
SQL = SQL &  " 			'13',fgbopal_13_ytd_actv,"
SQL = SQL &  " 			'14',fgbopal_14_ytd_actv) amt"

SQL = SQL & " from fgbopal, ftvfund fund3, ftvfund fund2, ftvftyp ftyp1, "

SQL = SQL &  " 	ftvftyp ftyp2, ftvacct, ftvprog"
SQL = SQL &  " where fund3.ftvfund_fund_code 		= fgbopal_fund_code"
SQL = SQL &  " 	and fund3.ftvfund_nchg_date		= '31-DEC-2099'"
SQL = SQL &  " 	and ftyp1.ftvftyp_ftyp_code		=
fund3.ftvfund_ftyp_code"
SQL = SQL &  " 	and ftyp1.ftvftyp_nchg_date		= '31-DEC-2099'"
SQL = SQL &  " 	and fund2.ftvfund_fund_code 	=
fund3.ftvfund_fund_code_pred"
SQL = SQL &  " 	and fund2.ftvfund_nchg_date		= '31-DEC-2099'"
SQL = SQL &  " 	and ftyp2.ftvftyp_ftyp_code		=
fund2.ftvfund_ftyp_code"
SQL = SQL &  " 	and ftyp2.ftvftyp_nchg_date		= '31-DEC-2099'"
SQL = SQL &  " 	and ftvacct_acct_code			= fgbopal_acct_code"
SQL = SQL &  " 	and ftvacct_nchg_date			= '31-DEC-2099'"
SQL = SQL &  " 	and ftvprog_prog_code(+)		= fgbopal_prog_code"
SQL = SQL &  " 	and (ftvprog_nchg_date			= '31-DEC-2099'"
SQL = SQL &  " 		or ftvprog_nchg_date is null)"
SQL = SQL &  " 	and (substr(fgbopal_fund_code,1,5)	= '10001'"
SQL = SQL &  " 		or fgbopal_fund_code in
('10002','70001','80001','99004','99005')"
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred between '11000' and
'17000'"
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred = '31000'"
SQL = SQL &  " 		or fund3.ftvfund_fund_code_pred between '52000' and
'54000'"
SQL = SQL &  " 		or fund2.ftvfund_fund_code_pred between '200' and
'220'"
SQL = SQL &  " 		or fund2.ftvfund_fund_code_pred = '900')"
SQL = SQL &  " 	and (ftvacct_acct_code_pred != '59400'"
SQL = SQL &  " 		and ftvacct_acct_code_pred != '79400'"
SQL = SQL &  " 		and ftvacct_acct_code_pred < '80000')"
SQL = SQL &  " 	and fgbopal_fsyr_code = '" & v_fsyr & "'"
SQL = SQL &  " ) "
SQL = SQL &  " group by	fid, ext_fund, gl_code, ext_pgrm "

		set cmd = Server.CreateObject("ADODB.Command")
		cmd.ActiveConnection = con
		cmd.CommandText = SQL
		cmd.CommandType = adCmdText
		

	
		set rs = cmd.Execute
	
		if rs.EOF then
			Response.write "<!-- " & vbCrLf & sql & vbCrLf & " -->" & vbCrLf 
			for each objErr in con.Errors
				Response.write "<!-- error = [" & objErr.number & "] " &
objErr.description & " -->" & vbCrLf
			next
			Response.write "<h3>No records match.</h3>"  & vbCrLf
		else

Always get same error...have tried con.execute...etc.

I have oracle statements processing in ASP that are much larger and more complicated than this one...and the print-out of the sql statment parses and runs in TOAD just fine.

Any hints on what to look for???? Received on Thu Mar 11 2004 - 23:00:17 CET

This message: [ Message body ]
Next message: Mark C. Stock: "Re: SQL*PLUS Tip: Reading other user's tables from SYSDBA/SYSOPER account"
Previous message: etravels: "Oracle forms....creating 'free text' fields"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message