IBM Support

IV95450: RUNNING MSSQL,SETVARCHARCOLSTONUMERIC_MSSS.SQL + SETVARCHARCOLSTONUMERIC_MSSS_PUBLISH_BO.SQL SCRIPTS IN 3521

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as documentation error.

Error description

  • PROBLEM DESCRIPTION:
    
    TRI 3.5.2.1 - How to run MSSQL, SetVarcharColsToNumeric_MSSS.sql
    and SetVarcharColsToNumeric_MSSS_Publish_BO.sql scripts after
    upgrade to 3.5.2.1 ?
    
    ENVIRONMENT:
    
    Application: 10.4
    Platform: 3.5.2.1
    Middleware: WebSphere Application Server
    
    STEPS TO REPRODUCE/EXTENDED PROBLEM DESCRIPTION:
    
    According to the 10.5.2 & 3.5.2 release notes:
    
    "There are two scripts for MSSQL,
    SetVarcharColsToNumeric_MSSS.sql and
    SetVarcharColsToNumeric_MSSS_Publish_BO.sql.
    Run SetVarcharColsToNumeric_MSSS.sql first. When it completes,
    run SetVarcharColsToNumeric_MSSS_Publish_BO.sql. "
    
    "Run the script PRIOR to installation of IBM TRIRIGA Application
    Platform version 3.5.0. NEVER run the script after upgrading to
    3.5.0"
    
    The Application is 10.4 and the Platform is 3.5.2.1, how can the
    SQL script to update the system fields with sub-attribute type
    of CreatedDateTime to CreatedDateTime (Number) and
    ModifiedDateTime to ModifiedDateTime (Number) be applied?
    

Local fix

  • n/a
    

Problem summary

  • "User can apply the script irrespective of platform build."
    Remove any restriction of platform version number..
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV95450

  • Reported component name

    TRI APPLCATION

  • Reported component ID

    5725F26AB

  • Reported release

    352

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-27

  • Closed date

    2017-04-28

  • Last modified date

    2017-04-28

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

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

Fix information

Applicable component levels



Document information

More support for: IBM TRIRIGA Application Builder
IBM TRIRIGA Application builder

Software version: 352

Reference #: IV95450

Modified date: 28 April 2017