Oracle-L: ORA-00600 while running query

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Fri, 15 Mar 2002 07:28:30 -0800
Message-ID: <F001.0042AA2E.20020315072830@fatcity.com>

Hi,

Whenever we try to run the following query we got ora-00600 error: What can be the possible Cause??????

We found out that the following lines from end of query are creating the problem
if we use only one condition out of these two the query works......

AND (anccorpfilter.id_ancestor IN (137,193,219)

OR (anccorpfilter.id_ancestor = 1 and anccorpfilter.num_generations = 1)))

Thanks
--Harvinder

EXTRACT FROM THE USER TRACE FILE

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [sorsik_2], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT

  accstate.status "AccountStatus",
  accstate.vt_end "AccountStatus_EndDate",
  accstate.vt_start "AccountStatus_StartDate",

acc.acc_type "AccountType",

  t_av_contact.c_address1 "address1",
  t_av_contact.c_address2 "address2",
  t_av_contact.c_address3 "address3",
  ancparentmap.nm_login "AncestorAccount",

ancparent.id_ancestor "AncestorAccountID", ancparentmap.nm_space "AncestorAccountNS",

  t_av_internal.c_billable "billable",
  t_av_contact.c_city "city",
  t_av_contact.c_company "company",
  t_av_contact.c_contacttype "contacttype",
  t_av_contact.c_country "country",
  t_av_internal.c_currency "currency",

  uc.day_of_month "DayOfMonth",
  uc.day_of_week "DayOfWeek",
  t_av_contact.c_email "email",
  t_av_contact.c_facsimiletelephonenumber "facsimiletelephonenumber",   uc.first_day_of_month "FirstDayOfMonth",   t_av_contact.c_firstname "firstname",
  t_av_internal.c_folder "folder",

  ancparent.b_children "HasChildren",
  ancparent.vt_end "Hierarchy_EndDate",
  ancparent.vt_start "Hierarchy_StartDate",
  t_av_internal.c_invoicemethod "InvoiceMethod",
  t_av_internal.c_language "Language",

  t_av_contact.c_lastname "lastname",
  t_av_contact.c_middleinitial "middleinitial",   accmap.nm_space "name_space",
  accprmap.nm_login "PayerAccount",
  accprmap.nm_space "PayerAccountNS",
  accpr.id_payer "PayerID",
  t_av_internal.c_paymentmethod "PaymentMethod",   accpr.vt_end "Payment_EndDate",
  accpr.vt_start "Payment_StartDate",
  t_av_contact.c_phonenumber "phonenumber",   t_av_internal.c_pricelist "pricelist",   uc.second_day_of_month "SecondDayOfMonth",   t_av_internal.c_securityanswer "SecurityAnswer",   t_av_internal.c_securityquestion "SecurityQuestion",

  uc.start_day "StartDay",
  uc.start_month "StartMonth",
  uc.start_year "StartYear",
  t_av_contact.c_state "state",
  t_av_internal.c_statusreason "StatusReason",
  t_av_internal.c_statusreasonother "StatusReasonOther",
  t_av_internal.c_taxexempt "taxexempt",
  t_av_internal.c_taxexemptid "TaxExemptID",

  t_av_internal.c_timezoneid "timezoneid",   t_av_internal.c_usagecycletype "usagecycletype",   accmap.nm_login "username",
  t_av_contact.c_zip "zip",
  acc.id_acc "_AccountID"
FROM
  t_account acc
   INNER JOIN t_account_mapper accmap
    ON accmap.id_acc = acc.id_acc
   INNER JOIN t_payment_redirection accpr     ON accpr.id_payee = acc.id_acc
    AND '15-mar-2002'BETWEEN accpr.vt_start AND accpr.vt_end    INNER JOIN t_account_mapper accprmap
    ON accprmap.id_acc = accpr.id_payer and accprmap.nm_space = accmap.nm_space

   INNER JOIN t_account_state accstate
    ON accstate.id_acc = acc.id_acc
    AND '15-mar-2002'BETWEEN accstate.vt_start AND accstate.vt_end    INNER JOIN t_acc_usage_cycle accuc
    ON accuc.id_acc = acc.id_acc
   LEFT OUTER JOIN t_account_ancestor ancparent     ON ancparent.id_descendent = acc.id_acc and ancparent.num_generations = 1

LEFT OUTER JOIN t_account_mapper ancparentmap ON ancparentmap.id_acc = ancparent.id_ancestor and ancparentmap.nm_space = accmap.nm_space

   INNER JOIN t_namespace ns
    ON ns.nm_space = accmap.nm_space
   LEFT OUTER JOIN t_av_contact t_av_contact     ON t_av_contact.id_acc = acc.id_acc
   INNER JOIN t_av_internal t_av_internal     ON t_av_internal.id_acc = acc.id_acc    INNER JOIN t_usage_cycle uc
    ON uc.id_usage_cycle = accuc.id_usage_cycle WHERE
  (ancparent.vt_start IS NULL OR '15-mar-2002'BETWEEN ancparent.vt_start AND ancparent.vt_end)
  AND EXISTS (SELECT null FROM t_account_ancestor anccorpfilter WHERE anccorpfilter.id_descendent = acc.id_acc

AND '15-mar-2002'BETWEEN anccorpfilter.vt_start AND anccorpfilter.vt_end AND (anccorpfilter.id_ancestor IN (137,193,219)

       OR (anccorpfilter.id_ancestor = 1 and anccorpfilter.num_generations = 1)))
  AND lower(accmap.nm_login) like 'ra%'
  AND lower(ns.tx_typ_space) = 'system_mps'   AND rownum <= 11
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 15 2002 - 09:28:30 CST