Re: SQR Error: ORA -1841 Upgrading to Tools 7.05.10

[Kristin Cagan <kristinc@SLAC.STANFORD.EDU>]

Hi Bill,

We had trouble with dates when we upgraded HRMS from 6.11 to 7.0x.   I'm
not sure if it's the same problem you're having, but we received the
following from PeopleSoft as an explanation/fix for the problem.  Maybe it
will be helpful.

Good luck.

KC :)

> Below is the text for Incident T-SAMI SHAIKH-SNT2W. Even though it doesn't
> mention version 6.11, this version was on the list of Tools versions that
> were impacted by this, as documented by related Incident T-HCODY-H6X4U.
>
>
>    ======================
>    In  PT 7.03 and PT 7.52,  the Native-Date for Oracle was changed from
>    DD-MON-YYYY to YYYY-MM-DD to meet needs of International Customers.
>    Although PeopleSoft SQR/SQC's work with this change, Customers are
>    seeing an impact on their Customer SQRs.  To meet the needs of both
>    situations, support for DD-MON-YYYY was added back.  Either Date Formats
>    work with PeopleSoft Date Processing Logic.
>
>    Note:  Support for YYYY-MM-DD is still there for International
>    Customers.  To enable this logic, you must change 2 lines in SETENV.SQC.
>    Here is a cut from the Code that explans this:
>
>    !For Oracle, you have the choice of which date format to use.  Until
PT 6.11, 7.03, 7.52,
>    !DD-MON-YYYY was the only option available.  Due to issues
internationally, support
>    !for YYYY-MM-DD was added. If you are using Oracle with a non-English
locale, it is
>    !recommended to use YYYY-MM-DD.  To change between formats, simply
uncomment the
>    !format you want to use and comment out the other one.  SETUPDB.SQC
will automatically
>    !recognize the change.
>    !
>    !#define Native-DateTime    YYYY-MM-DD_HH:MI:SS
>    #define Native-DateTime    DD-MON-YYYY_HH:MI:SS_AM
>
>    By Default, DD-MON-YYYY will be supported.  By making the change
suggested:
>
>    #define Native-DateTime    YYYY-MM-DD_HH:MI:SS
>    !#define Native-DateTime    DD-MON-YYYY_HH:MI:SS_AM
>    The Date processing will be done using YYYY-MM-DD (International)


At 04:40 PM 10/07/1999 -0400, you wrote:
>Hi All,
>
>We have upgraded our Tools from 7.03 to 7.05.10.  This brings us from SQR 3.0
> to 4.3.4.  We are now getting the error:
>ORA -1841, SQL Eror:  (Full) year must be between -4713 and +9999, and not be
>0.
>
>Has anyone else hit this?  Any resolutions?
>
>Thanks in Advance!
>Bill Hart
>College of the Holy Cross
>