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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Cast Iron Hypervisor Edition Enterprise

Software version:

630

Reference #:

LI77257

Modified date:

2013-03-20

Translate my page

Machine Translation

Content navigation