Re: Library form problem

From: Andrew Hardy <junkmail_at_[127.0.0.1]>
Date: Thu, 23 Feb 2006 15:35:42 +0000
Message-ID: <dtkkoe$e4g$1_at_sun-cc204.lut.ac.uk>


Pascal wrote:
> OK. now we're getting places. After running all the scripts you
> suggested and re-compiling, the library does upload without error. Also
> some of the forms that there were giving these errors on startup no
> longer do so:
> ORA-00942 Table or view does not exist (repeated several times)
> FRM-18108 Failed to load the following objects
>
> Unfortunatly the triggers and blocks referenced in the library still
> cannot be found at compilation (they are marked red in the object
> navigator)
>
> Also some of the other forms are still giving these errors when loaded
> FRM-10081: Cannot retreive in AGSD_IPS module
> FRM-10043: Cannot open file

Urgh...

I *think* that there were some issues with upgrading library forms. It was something to do with when the FMB was upgraded, it read the reference information from the old version of tables and stored this in the generated file. When that form, or one that referenced it, was opened the forms expected the reference information to be stored in the new version of tables.

The solution used to be to convert the libary form to an .INP (using the old forms developer tools), upgrade that and then install it.

I have no idea if this will be at all relevant to your problem!

-- 
Andy

Opinions are mine and do not necessarily reflect those of Advantica 
Technologies
Received on Thu Feb 23 2006 - 16:35:42 CET

Original text of this message