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.