LI77257: STRING INDEX OUT OF RANGE: -1 ERROR RECEIVED WHILE INSERTING A DATE WITHOUT TIME VALUE TO A DATETIME DB FIELD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Inserting a datetime value without time in to a DATETIME type
    field in to a Oracle table fails with the error message:
    String index out of range: -1
    This issue is seen across all databases.
    
    For example:
    
    Inserting 2013-02-05 value in to a DATETIME type column in a
    Oracle table fails with this error.
    

Local fix

  • The workaround is to append the data value with a dummy time
    string to provide datetime value as an input.  For
    example : Append the date 2013-02-05 with the time string
    T00:00:00T00:00:00.000Z
    

Problem summary

  • Inserting a date value without time in to a DATE type field in
    to a Oracle table fails with the error message: String index out
    of range: -1
    
    For example:
    Inserting 2013-02-05 value in to a DATE type column in a
    Oracle table fails with this error.
    
    This was occurring due to an error when handling the date and
    date/time formats when performing database update activities.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    LI77257

  • Reported component name

    WCI HV DEV ENTP

  • Reported component ID

    5725C1201

  • Reported release

    630

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-12

  • Closed date

    2013-03-19

  • Last modified date

    2013-03-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WCI HV DEV ENTP

  • Fixed component ID

    5725C1201

Applicable component levels

  • R630 PSY

       UP



Document information


More support for:

WebSphere Cast Iron Hypervisor Edition Enterprise

Software version:

630

Reference #:

LI77257

Modified date:

2013-03-20

Translate my page

Content navigation