The request failed because the PowerHouse Web Server Connection Timeout has expired

[Thomson, Martyn]

Hey Listers!
I have a PH Web screen (8.40G) using a union view of several tables/views that somehow trips up the PH Web server. Here is the generalised view definition:

create view LINKAGE_UNION_VIEW
    (FLD1,
     FLD2,
     EFFECTIVE_YYMM,
     TERMINATE_YYMM,
     DB_PERCENT,
     CURRENT_FLAG) as
    select C2.FLD1, C2.FLD2, C2.EFFECTIVE_YYMM, C2.TERMINATE_YYMM,
        C2.DB_PERCENT, C2.CURRENT_FLAG
        from CURRENT_VIEW C2
    union distinct
    select C3.FLD1, C3.FLD2, C3.EFFECTIVE_YYMM, C3.TERMINATE_YYMM,
        C3.DB_PERCENT, C3.CURRENT_FLAG
        from TERMINATED_VIEW C3
    union distinct
    select C4.FLD1, C4.FLD2, C4.EFFECTIVE_YYMM, C4.TERMINATE_YYMM,
        C4.DB_PERCENT, 'C'
        from LINKAGE_1_TABLE C4
        where (C4.TERMINATE_YYMM <= '000000')
    union distinct
    select C5.FLD1, C5.FLD2, C5.EFFECTIVE_YYMM, C5.TERMINATE_YYMM,
        C5.DB_PERCENT, 'T'
        from LINKAGE_1_TABLE C5
        where (C5.TERMINATE_YYMM > '000000')
    union distinct
    select C6.FLD1, C6.FLD2, C6.EFFECTIVE_YYMM, C6.TERMINATE_YYMM,
        C6.DB_PERCENT, 'C'
        from LINKAGE_2_TABLE C6
        where (C6.TERMINATE_YYMM <= '000000')
    union distinct
    select C7.FLD1, C7.FLD2, C7.EFFECTIVE_YYMM, C7.TERMINATE_YYMM,
        C7.DB_REPORTING_PERCENT, 'T'
        from LINKAGE_2_TABLE C7
        where (C7.TERMINATE_YYMM > '000000')
    order by 2 asc, 6 asc, 1 asc;

Data is retrieved by providing a value for FLD2.
CURRENT_VIEW and TERMINATED_VIEW  are both views of a third table, differentiated on TERMINATE_YYMM.
The corresponding attributes of each table/view are the same and use the same domain definitions.
Whenever there's data originating from table LINKAGE_1_TABLE  it always gives the connection timeout error.

Things I've tried:

1.      The error has nothing to do with amount of data returned. So long as there's none from LINKAGE_1_TABLE the view works for one or hundreds of rows;

2.      changed order of tables in view definition. No effect;

3.      For a FLD2 value with no LINKAGE_2_TABLE data, moved data from table  LINKAGE_1_TABLE to LINKAGE_2_TABLE. Still get error;

4.      For a FLD2 value with no LINKAGE_1_TABLE data, moved data from table  LINKAGE_2_TABLE to LINKAGE_1_TABLE. No error;

5.      3 and 4 imply data is corrupted. Used DUMP/REC to look at LINKAGE_1_TABLE in Hex. Nothing unusual about it;

6.      This is the only PH Web screen we have using data from LINKAGE_1_TABLE;

7.      The protection on LINKAGE_1_TABLE is no different than the other tables;

8.      Same view used in QUICK, QUIZ or SQL has no problem retrieving data. Only PowerHouse Web server coughs.

Anyone seen this before? Is it because each of 3 tables is defined twice in the view?
Losing hair here! Any suggestions much appreciated.

Using PH 8.4G, OpenVMS 8.3, Oracle Rdb SQL V7.2
Regards,
Martyn Thomson
Senior Technical Analyst, Development Services
Information Technology Services
HP Advanced Solutions Inc.
phone: 250.405.4555 | fax: 250.405.4422
email:martyn.thomson at hpadvancedsolutions.com<mailto:martyn.thomson at hpadvancedsolutions.com>
web:  www.hpadvancedsolutions.com<http://www.hpadvancedsolutions.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20140815/da4e8544/attachment.html>