Hi Komathie,



Your post was rejected because it was too large. Please try to keep them to
around 100Kb.

Sid may want to see a full copy of the errlog, I suggest compressing it
first before mailing it directly to him.



This is an Ingres issue not related to OpenROAD as far as I can tell. I've
forwarded your mail to info-ingres (comp.databases.ingres )

I suggest you log a support call directly with Ingres corp to make sure you
don't lose data.





anyway, here is my feedback.





The top part of your errlog.log shows that machine was shutdown suddenly
without a formal ingres shutdown.

That has left the iidbdb database inconsistent with an open count
discrepancy.

See this line from your errlog.log



komathi-::[II\INGRES\b58 , 00a94c20]: Wed Oct 28 17:37:09 2009 E_US002B
Could not open the iidbdb database.

komathi-::[II\INGRES\b58 , 00a94c20]: Wed Oct 28 17:37:09 2009
E_DM0100_DB_INCONSISTENT Database is inconsistent.



I can't explain these other errors. It looks like you are trying to operate
on the installation using a non-ingres account.

The missing charset file is a worry. Are you sure your disks are working?



komathi-::[II\NMSVR\830 , 00000002]: Wed Oct 28 17:50:45 2009
E_GC0155_GCN_SRV_FAILURE Registered server failure: class IUSVR,
address II\IUSVR\9f8

komathi-::[II\NMSVR\830 , 00000007]: Wed Oct 28 17:50:47 2009
E_GC003F_PM_NOPERM User does not have the required permission in the
config.dat file for the requested operation.

komathi-::[IIGCN , 00000000]: Wed Oct 28 17:54:24 2009
E_GC0105_GCN_CHAR_INIT Error while processing character set
attribute file.

007f0100 Wed Oct 28 17:55:00 2009
E_UL0016_CHAR_INIT Error while processing character set attribute
file.

open() failed with operating system error 2 (The system cannot find the file
specified.)

komathi-::[IIGCN , 00000000]: Wed Oct 28 18:04:35 2009
E_GC0105_GCN_CHAR_INIT Error while processing character set
attribute file.

007f0100 Wed Oct 28 18:05:10 2009
E_UL0016_CHAR_INIT Error while processing character set attribute
file.

open() failed with operating system error 2 (The system cannot find the file
specified.)







You will probably just want to rollforwarddb iidbdb from the last valid
checpoint. (You have been backing up regularly and you have you have a
recent checkpoint and all the appropriate journals) At this point you
should obtain the services of a qualified Ingres DBA or open a support call
with Ingres Corp to make sure you don't lose important data.



kind regards



Paul







From: Komathi [mailto:komathie (AT) myworkplace (DOT) com.au]
Sent: Thursday, 29 October 2009 2:00 PM
To: openroad-users (AT) googlegroups (DOT) com
Subject: RE: [openroad-users] Re: Urgent - Help.



Hi Sidney, Thanks for the mail - this is my errorlog file line.





komathi-::[II\DASVR\86c , 00000000]: Tue Oct 27 19:30:19 2009
E_GC4802_LOAD_CONFIG Finished loading configuration parameters for
configuration '(DEFAULT)' of server type 'GCD'.

komathi-::[II\DASVR\86c , 00000000]: Tue Oct 27 19:30:19 2009
E_GC4800_STARTUP Data Access Server normal startup.

komathi-::[II\NMSVR\1e0 , 00000005]: Tue Oct 27 19:30:19 2009
E_GC0153_GCN_SRV_STARTUP Server Registration: class RMCMD, address
II\RMCMD\8a0

komathi-::[II\NMSVR\884 , 00000000]: Wed Oct 28 09:04:10 2009
E_GC0151_GCN_STARTUP Name Server normal startup.

komathi-::[II\NMSVR\884 , 00000000]: Wed Oct 28 09:04:10 2009
E_GC0159_GCN_BCHK_FAIL Removing server registration: class
IUSVR, address