IV19483: PE 7.8 UNDER WINDOWS 7 GETS COLUMN AMBIGUOUSLY DEFINED UNDER WORK REQUEST QUERY

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

  • In TRIRIGA Professional Edition 7.8 under Windows 7
    environemtn with Oracle you get error that column
    is ambiguouslly defined when trying to query a Work Request.
    
    In the same environment under under MS SQL Server it gives a
    message '...same
    expolsed names. Use correlation names to distinguish..."
    It is not an issue with Adaptive Serv
    
    THis issue can be seen when trying to recall a request from the
    Query tab of the Submit Work Request window or when recalling a
    Work Request from the Work Request of the Call Center window.
    

Local fix

  • NA
    

Problem summary

  • In PE 7.8 - Data Window Error when using Query Work Requests.
    Get DataWindow Error: "Select Error: ORA-00918:
    column ambiguously define
    

Problem conclusion

  • Power builder runtime was not translating correctly oracle SQL
    when left and right joins are used.
    Made data window (w_request_entry) every join to left outer
    join.  This fixed the problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV19483

  • Reported component name

    TRI WKPLC OPS M

  • Reported component ID

    5725F25OM

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-11

  • Closed date

    2012-05-15

  • Last modified date

    2012-05-15

  • 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

    TRI WKPLC OPS M

  • Fixed component ID

    5725F25OM

Applicable component levels

  • R970 PSN

       UP

  • RA00 PSN

       UP

  • RA10 PSN

       UP

  • RA20 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM TRIRIGA Workplace Operations Manager
IBM TRIRIGA Workplace Operations Manager

Software version:

A10

Reference #:

IV19483

Modified date:

2012-05-15

Translate my page

Machine Translation

Content navigation