Loading ...
Sorry, an error occurred while loading the content.

Re: PeopleSoft DBA Forum peoplecode fails after upgrading 10.2.0.3

Expand Messages
  • sat17singh
    We had a situation where nested sub-queries were giving ORA-600 error messages on 10.2.0.3 whereas on 9.2.0.6 they worked fine. The work round is to set the
    Message 1 of 4 , Jun 13, 2007
    • 0 Attachment
      We had a situation where nested sub-queries were giving ORA-600
      error messages on 10.2.0.3 whereas on 9.2.0.6 they worked fine. The
      work round is to set the hidden init.ora parameter
      _optimizer_cost_based_transformation=off. I have a bug (number
      6075238) logged against this with Oracle.

      Also from customer connection note 4 it says it to set
      _gby_hash_aggregation_enabled=false

      Regards
      Satbinder

      --- In psftdba@yahoogroups.com, "David Kurtz" <info2@...> wrote:
      >
      > It would be helpful if you posted the specific PeopleCode and SQL
      statement
      > that is causing the problem.
      >
      > regards
      > _________________________
      > David Kurtz
      > Go-Faster Consultancy Ltd.
      > tel: +44 (0)7771 760660
      > fax: +44 (0)7092 348865
      > mailto:david.kurtz@...
      > web: www.go-faster.co.uk
      > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
      > The PeopleSoft DBA Blog: http://psftdba.blogspot.com
      > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
      > ________________________________
      >
      > From: psftdba@yahoogroups.com
      [mailto:psftdba@yahoogroups.com] On
      > Behalf Of Bhimsingh Wadhwa
      > Sent: Tuesday, June 12, 2007 6:24 PM
      > To: psftdba@yahoogroups.com
      > Subject: PeopleSoft DBA Forum peoplecode fails after
      upgrading
      > 10.2.0.3
      >
      >
      >
      > Hi,
      > We upgraded our oracle database from 10.1.0.4 to
      > 10.2.0.3. in our TimeAdmin batch jobs, All peoplecode
      > fails.
      > Do we have to do anything with peoplecode when we
      > upgrade the database.
      > see the errror below , it works find with 10.1.0.4
      > database.
      >
      > 15.28.21 ......(TL_SCHRES_AE.RSLV01.Step42) (Call
      > Section TL_SCHRES_AE.RSLV03)
      >
      > -- 15.28.21 .......(TL_SCHRES_AE.RSLV03.Step01)
      > (PeopleCode)
      > -- 15.28.21 Program Skipping Step due to non-zero
      > return code from PeopleCode at
      > TL_SCHRES_AE.RSLV03.Step01
      >
      > -- 15.28.21 ......(TL_SCHRES_AE.RSLV01.Step42) (Do
      > Fetch)
      > -- Buffers:
      > -- 1) 0000-0630
      > -- 2) 1901-01-01
      > -- 3) 1
      > -- 4) 0000-0630
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.