error in SQL Monitoring screen 11.2.0.3.4

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Mon, 11 Mar 2013 13:46:55 -0700 (PDT)
Message-ID: <1363034815.6806.YahooMailClassic_at_web181205.mail.ne1.yahoo.com>



Anyone seen this?

I have a query that uses a text index ( catsearch ). When it gets picked up for real time SQL Monitoring in 11.2.0.3.4 and you click on the sqlid ... OEM screen throws an error and does not display the SQL and of course does not display the SQL monitoring report.

Works just fine in 11.1.0.7.12 ( really all the 11.1.0.7.x versions ).

Text returned in OEM monitoring screen looks like this:

java.sql.SQLException: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00225: end-element tag "bind" does not match start-element tag "query" Error at line 1

ORA-06512: at "SYS.DBMS_SQLTUNE", line 13969
ORA-06512: at "SYS.DBMS_SQLTUNE", line 14265
ORA-06512: at line 1

SQL involved looks like this:
SELECT /*+ index(VS_CUSTOMER CUSTOMER_SX1) */ IMAGE_RECNBR, CUSTOMER_ID, CONTROL_SEQ_ID, CUSTOMER_ID_NEW, NAME_LAST, NAME_FIRST, ADDRESS_1, ADDRESS_2, ADDRESS_3, CITY, STATE, ZIP, QTY_FIXTIME_INQUIRY, AB_COVER, FDX_SIGNATURE_RELEASE, DATE_SHIP_FIRST, GOOD_RISK, OPT_IN_OUT, COD_RISK, CATALOG_PREF_1, CATALOG_PREF_2, CATALOG_PREF_3, CATALOG_PREF_4, CATALOG_PREF_5, CATALOG_PREF_6, FLAG_SHIP_PREF, DATE_MAIL_ORDER_FIRST, WEB_ONLY, LANGUAGE, AREA_CODE, PHONE_NBR, COUNTRY_ID, TAX_EXEMPT_ID, SOURCE_CODE_FIRST, SOURCE_CODE_LAST, DATE_TRANSACTION_FIRST, DATE_TRANSACTION_LAST, CNT_ORDER, TOT_NET_ORDER_AMT, FLAG_ORDER_TYPE, FLAG_NIXIE, FLAG_NOMAIL, FLAG_PROMO, FLAG_FRAUD, FLAG_COD, FLAG_REFUSED, FLAG_CATALOG, FLAG_SHIP_TO, FLAG_DELETE, FLAG_BUSINESS_CUSTOMER, FLAG_CASH_CHECK FROM sre_corp.VS_CUSTOMER
WHERE ((catsearch(NAME_LAST,:"SYS_B_0",NULL) > :"SYS_B_1")) ORDER BY IMAGE_RECNBR

***

I have a bad feeling I need to submit an SR ... dang!

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 11 2013 - 21:46:55 CET

Original text of this message