This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Environment: Maximo 6.2 , Oracle 9.2 , Actuate 8.0 Windows Server 2003
Here is the complete error which i copy from the command prompt.
> >
> > D:\Maximo6\Maximo\tools\maximo>
> > D:\Maximo6\Maximo\tools\maximo>configdb
> > Wed Jul 27 10:40:59 GMT+05:00 2011 --- Starting ----
> > Reading properties file : maximo.properties
> > RestoreFromBackup started for schema MAXIMO Wed Jul 27 10:41:00 GMT+05:00
2011
> > RestoreFromBackup connected to database
jdbc:oracle:thin:@pkueta02psge:1521:maxi
> > mo Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB started for schema MAXIMO Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB connected to database jdbc:oracle:thin:@pkueta02psge:1521:maximo
Wed Ju
> > l 27 10:41:00 GMT+05:00 2011
> > java.sql.SQLException: ORA-00942: table or view does not exist
> >
> > at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
> > :112)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
> > at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:
> > 790)
> > at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
> > nt.java:1039)
> > at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
> > a:830)
> > at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> > nt.java:1132)
> > at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
> > 1272)
> > at psdi.configure.Util.rowFound(Util.java:11764)
> > at psdi.configure.ConfigDB.checkForBackup(ConfigDB.java:283)
> > at psdi.configure.ConfigDB.process(ConfigDB.java:201)
> > at psdi.configure.ConfigDB.main(ConfigDB.java:2356)
> > ORA-00942: table or view does not exist
> > Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB completed with errors Wed Jul 27 10:41:00 GMT+05:00 2011
> > RestoreFromBackup completed Wed Jul 27 10:41:00 GMT+05:00 2011
> > D:\Maximo6\Maximo\tools\maximo>
Please help
Amir
Somehow one of the tables MAXIMO knows about is no longer in the Database.
I suggest you try and run the integrity checker from the
D:\Maximo6\tools\maximo directory - it should advise you of the missing
table as well as tables that should not be there.
Regards
Peter
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Amir
Sent: Sunday, 11 September 2011 2:40 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] my Configdb cannot run error is ORA-00942: table or
view does not exist
Environment: Maximo 6.2 , Oracle 9.2 , Actuate 8.0 Windows Server 2003
Here is the complete error which i copy from the command prompt.
> >
> > D:\Maximo6\Maximo\tools\maximo>
> > D:\Maximo6\Maximo\tools\maximo>configdb
> > Wed Jul 27 10:40:59 GMT+05:00 2011 --- Starting ----
> > Reading properties file : maximo.properties
> > RestoreFromBackup started for schema MAXIMO Wed Jul 27 10:41:00
GMT+05:00
2011
> > RestoreFromBackup connected to database
jdbc:oracle:thin:@pkueta02psge:1521:maxi
> > mo Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB started for schema MAXIMO Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB connected to database
jdbc:oracle:thin:@pkueta02psge:1521:maximo
Wed Ju
> > l 27 10:41:00 GMT+05:00 2011
> > java.sql.SQLException: ORA-00942: table or view does not exist
> >
> > at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
> > :112)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
> > at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:
> > 790)
> > at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
> > nt.java:1039)
> > at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
> > a:830)
> > at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> > nt.java:1132)
> > at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
> > 1272)
> > at psdi.configure.Util.rowFound(Util.java:11764)
> > at psdi.configure.ConfigDB.checkForBackup(ConfigDB.java:283)
> > at psdi.configure.ConfigDB.process(ConfigDB.java:201)
> > at psdi.configure.ConfigDB.main(ConfigDB.java:2356)
> > ORA-00942: table or view does not exist
> > Wed Jul 27 10:41:00 GMT+05:00 2011
> > ConfigDB completed with errors Wed Jul 27 10:41:00 GMT+05:00 2011
> > RestoreFromBackup completed Wed Jul 27 10:41:00 GMT+05:00 2011
> > D:\Maximo6\Maximo\tools\maximo>
Please help
I see that RestoreFromBackup was called just prior to the failure. I would
look in MAXTABLECFG to identify which tables are waiting to be restored from
backups. You can do that with this sql.
*Identify tables to be restored*
select * from maxtablecfg where restoredata = 1
*Identify tables to be restored that no longer have the associated backup
table*
select * from maxtablecfg where restoredata = 1 and tablename not in (select
table_name from user_tables where tablename like 'XX%')
If its not a table waiting to be restored and an actual table that is
missing you can find it with the following SQL.
*Identify missing tables*
select * from maxtablecfg where tablename not in (select table_name from
user_tables)
If it is a view that is missing you can flag it to be recreated since it is
defined in the metadata. If it is a table that is missing I don't know any
other option other than restoring from a backup unless the table was a new
table or contained no data previously.
If we had your ConfigDb.log and the RestoreFromBackup.log files we should be
able to properly identify what the real culprit behind the issue is.
I would also do as Peter suggested. Run the integrity checker (if available)
with the repair option disabled. If you have it, it should be located at
D:\Maximo6\tools\maximo\integrityui.bat
On Sun, Sep 11, 2011 at 12:39 AM, Amir <ashahzad.1978@yahoo.com> wrote:
> **
>
>
> Environment: Maximo 6.2 , Oracle 9.2 , Actuate 8.0 Windows Server 2003
>
> Here is the complete error which i copy from the command prompt.
> > >
> > > D:\Maximo6\Maximo\tools\maximo>
> > > D:\Maximo6\Maximo\tools\maximo>configdb
> > > Wed Jul 27 10:40:59 GMT+05:00 2011 --- Starting ----
> > > Reading properties file : maximo.properties
> > > RestoreFromBackup started for schema MAXIMO Wed Jul 27 10:41:00
> GMT+05:00
> 2011
> > > RestoreFromBackup connected to database
> jdbc:oracle:thin:@pkueta02psge:1521:maxi
> > > mo Wed Jul 27 10:41:00 GMT+05:00 2011
> > > ConfigDB started for schema MAXIMO Wed Jul 27 10:41:00 GMT+05:00 2011
> > > ConfigDB connected to database jdbc:oracle:thin:@pkueta02psge
> :1521:maximo
> Wed Ju
> > > l 27 10:41:00 GMT+05:00 2011
> > > java.sql.SQLException: ORA-00942: table or view does not exist
> > >
> > > at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
> > > :112)
> > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> > > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> > > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
> > > at
> oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:
> > > 790)
> > > at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
> > > nt.java:1039)
> > > at
> oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
> > > a:830)
> > > at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> > > nt.java:1132)
> > > at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
> > > 1272)
> > > at psdi.configure.Util.rowFound(Util.java:11764)
> > > at psdi.configure.ConfigDB.checkForBackup(ConfigDB.java:283)
> > > at psdi.configure.ConfigDB.process(ConfigDB.java:201)
> > > at psdi.configure.ConfigDB.main(ConfigDB.java:2356)
> > > ORA-00942: table or view does not exist
> > > Wed Jul 27 10:41:00 GMT+05:00 2011
> > > ConfigDB completed with errors Wed Jul 27 10:41:00 GMT+05:00 2011
> > > RestoreFromBackup completed Wed Jul 27 10:41:00 GMT+05:00 2011
> > > D:\Maximo6\Maximo\tools\maximo>
>
> Please help
>
>
>
--
Thanks,
Matt Holland