Oracle Rdb view error on Itanium.

[Thomson, Martyn]

We're porting a Powerhouse app from Alpha to Itanium. Because of an unrelated issue (different rounding results!) I decided to drop all Oracle Rdb views and recreate them. The one shown here is fine on the Alpha but generates a cryptic message on Itanium. I believe the error message is misleading.

SQL> create view ACCOUNT_INTEREST_INACTIVEA_VIEW
cont>     (ROYALTY_PAYOR,
cont>      ACCOUNT_DESCRIPTION,
cont>      STATEMENT_DATE) as
cont>     (select
cont>         C2.ROYALTY_PAYOR,
cont>         'Interest',
cont>         max(C2.STATEMENT_DATE)
cont>     from ACCOUNT_INTEREST C2
cont>     where (C2.TRANSACTION_TYPE = 'IN04')
cont>     group by C2.ROYALTY_PAYOR);

SQL> create view ACCOUNT_INTEREST_INACTIVEB_VIEW
cont>     (ROYALTY_PAYOR,
cont>      ACCOUNT_DESCRIPTION,
cont>      STATEMENT_DATE,
cont>      CLOSING_BALANCE) as
cont>     (select
cont>         C2.ROYALTY_PAYOR,
cont>         C2.ACCOUNT_DESCRIPTION,
cont>         C2.STATEMENT_DATE,
cont>         sum(C3.TRANSACTION_AMOUNT)
cont>     from ACCOUNT_INTEREST_INACTIVEA_VIEW C2, ACCOUNT_INTEREST C3
cont>     where ((C2.ROYALTY_PAYOR = C3.ROYALTY_PAYOR)
cont>         and (C3.STATEMENT_DATE <= C2.STATEMENT_DATE))
cont>     group by C2.ROYALTY_PAYOR, C2.ACCOUNT_DESCRIPTION, C2.STATEMENT_DATE);

%RDB-E-NO_META_UPDATE, metadata update failed
-RDB-E-INVALID_BLR, request BLR is incorrect at offset 203

Could it be a recursion issue since the ACCOUNT_INTEREST table is used in both views?

Regards,
Martyn Thomson
Senior Technical Analyst, Development Services
Information Technology Services
HP Advanced Solutions Inc.

OpenVMS V8.4
PowerHouse 8.40G
Oracle Rdb V7.3-100
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150921/b330cebf/attachment.htm>