Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01410: invalid ROWID (Oracle 10g R2, Solaris)
ORA-01410: invalid ROWID [message #407821] Thu, 11 June 2009 15:17 Go to next message
mysteriousman5578
Messages: 1
Registered: June 2009
Junior Member
Hi Friends,
I am getting this error "ORA-01410: invalid ROWID" in any of my several tasks that are being executed in our BATCH. Batch is the application batch. The tasks are SQL select or update statements. The most important thing is Rerunning the same failed task once again resolves the issue. The first thing that could come to your mind is whether any other job was running in parallel, the answer is no. The query that failed is as below and it failed after some time.
UPDATE
  /*+ BYPASS_UJVC */
  (SELECT Fct_Mitigants.n_basel_coll_type_skey AS T0
  , CASE
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL049'))
      THEN '7.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL013'))
      THEN '2.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL054'))
      THEN '8.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL020'))
      THEN '5.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL017'))
      THEN '1.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL048'))
      THEN '6.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL002'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL003'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL004'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL005'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL006'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_reord_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL048'))
      THEN '6.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL002'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL003'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL004'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL005'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL006'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL007'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL008'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL011'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL022'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL023'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL024'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL026'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL027'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL028'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL030'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL031'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL032'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL033'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL035'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL037'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL038'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL039'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL042'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL044'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL046'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL047'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL051'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL014'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL052'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL053'))
        OR ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL057'))
      THEN '13.000000'
      WHEN ( (
        CASE
          WHEN Dim_Mitigant_Type.f_latest_record_indicator = 'Y'
          THEN Dim_Mitigant_Type.v_mitigant_type
        END = 'COLL')
        AND (
        CASE
          WHEN Dim_Collateral.f_latest_record_indicator = 'Y'
          THEN Dim_Collateral.v_coll_type
        END = 'CL001'))
      THEN '10.000000'
      ELSE TO_CHAR (Fct_Mitigants.n_basel_coll_type_skey)
    END AS COND0
  , 1
  FROM FCT_MITIGANTS
  LEFT OUTER JOIN DIM_BASEL_ISSUER_TYPE
  ON FCT_MITIGANTS.n_basel_issuer_type_skey = DIM_BASEL_ISSUER_TYPE.n_basel_issuer_type_skey
  LEFT OUTER JOIN DIM_BASEL_COLLATERAL_TYPE
  ON FCT_MITIGANTS.n_basel_coll_type_skey = DIM_BASEL_COLLATERAL_TYPE.n_basel_coll_type_skey
  LEFT OUTER JOIN dim_mitigant
  ON fct_mitigants.n_mitigant_skey = dim_mitigant.n_mitigant_skey
  LEFT OUTER JOIN dim_collateral
  ON (dim_mitigant.v_mitigant_code               = dim_collateral.v_coll_id
    AND dim_collateral.f_latest_record_indicator = 'Y')
  LEFT OUTER JOIN DIM_MITIGANT_TYPE
  ON FCT_MITIGANTS.n_mitigant_type_skey = DIM_MITIGANT_TYPE.n_mitigant_type_skey
  LEFT OUTER JOIN DIM_ISSUER
  ON DIM_ISSUER.n_issuer_skey = FCT_MITIGANTS.n_issuer_skey
  LEFT OUTER JOIN DIM_BASEL_CREDIT_RAT


[formatted code to spare my poor aching eyes]

[Updated on: Fri, 12 June 2009 02:58] by Moderator

Report message to a moderator

Re: ORA-01410: invalid ROWID [message #407823 is a reply to message #407821] Thu, 11 June 2009 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

You won't get a meaningful response until/unless present readable post.
Re: ORA-01410: invalid ROWID [message #407828 is a reply to message #407823] Thu, 11 June 2009 15:32 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I think people might actually risk a chance of becoming blind looking at that code.
Re: ORA-01410: invalid ROWID [message #407859 is a reply to message #407828] Fri, 12 June 2009 00:56 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And we are lucky OP tried to post his query in orange.

Regards
Michel
Previous Topic: Calling java function from remote unix server
Next Topic: Table partitioning
Goto Forum:
  


Current Time: Thu Dec 08 08:15:19 CST 2016

Total time taken to generate the page: 0.11406 seconds