Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / August 2006

Tip: Looking for answers? Try searching our database.

upgradefe on r3 3.0.1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Borbiro - 23 Aug 2006 00:14 GMT
Yikes! I'm back on a project that had been put to sleep for a while,
and has now been woken up again....

converting a database and its ABF applications to run under Linux:
SUSE Linux Enterprise Server 9
Ingres r3 3.0.1 (int.lnx/00)

Ingres insatlled OK,
Database reloads OK (was exported originally with unloaddb -c ),
ABF compiles OK (thanks Paul M for previous help with all this).

But sreport gives an error:

E_UI0029 Cannot start program; must upgrade catalogs
   This program cannot run against this database because some of the INGRES
   catalogs need to be upgraded.

    To upgrade the catalogs, run the command:

    upgradefe school INGRES

E_RW13E8 Error connecting with database school. Processing stops.

On running the upgradefe as suggested:

 (module CORE version 2 is already installed)
 Upgrading to front-end module APPLICATION_DEVELOPMENT_1 version 5 . . .
E_US1264 The query has been aborted.
   (Wed Aug 23 09:06:48 2006)
E_DD0026 Cannot upgrade to module APPLICATION_DEVELOPMENT_1 version 5.
   Error 1 occurred trying to upgrade to this front-end catalog module.
   Check if this error number is an operating system error. If not, then it
   is an internal Ingres error. Contact your site technical contact for
   assistance.

E_DD0009 Cannot install product INGRES version 4.

Can anybody suggest a solution please?

(I also tried createdb school -f nofeclients before reloading the data,
but still no joy.)

Thanx,
Bob Borbiro.
vdohnal@uniscomp.cz - 23 Aug 2006 07:13 GMT
Hello,
I think you must increase logfile. Check the size of ii_rcommands -
this table must be altered during upgradefe and may have many rows.
Bob Borbiro - 24 Aug 2006 00:15 GMT
Problem solved.
Thank you (and also to Leandro) for your help.

The solution...

Increased Tx log size to 512 KB (was 32KB),

createdb dbname

Removed  inclusion of iiud.scr & iiud65.scr from the copy.in

reload.ing

upgradefe dbname INGRES

and now imageapp & sreport & vifred all work again.

Bob Borbiro.

> Hello,
> I think you must increase logfile. Check the size of ii_rcommands -
> this table must be altered during upgradefe and may have many rows.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.