Service Desk Practitioners Forum
cancel

JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

Highlighted
Vijay Kavrani
Outstanding Contributor.

JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

Hi,
We are on SD4.5 SP20. We took a DB copy from some other system (which was also on SP20 and working fine) and are trying to use it straight away. The database connection and repository connection are successful from Server Setting Editor. But SD application server start fails. Log file shows:

Tue, 19/06/2007 12:23:04 Getting system information from database.
Tue, 19/06/2007 12:23:04 JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier
, SQL state: 42000 for query: select sys_version, sys_site from ifc_systemjava.sql.SQLException: ORA-00904: "SYS_SITE": invalid identifier

Tue, 19/06/2007 12:23:04 Wrong database user defined for repository: table ifc_system not found
Tue, 19/06/2007 12:23:04 End session.
Tue, 19/06/2007 12:23:04 Starting scheduled rule actions queue.
Tue, 19/06/2007 12:23:04 Unable to start serverjava.lang.ExceptionInInitializerError: The repository is not loaded
at com.hp.ifc.bus.AppSrvDispatch.invoke(Unknown Source)
at com.hp.ifc.rep.AppRepository.refresh(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.initialize(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.initialize(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.(Unknown Source)
at com.hp.ifc.bus.AppServer.startup(Unknown Source)
at com.hp.ifc.bus.AppServer.main(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.hp.startup.Bootstrap.runprogram(Unknown Source)
at com.hp.startup.Bootstrap.main(Unknown Source)

When we try database ugrade utility, following is the error in long file:

Tue, 19/06/2007 13:45:28 Database Upgrade started.
Tue, 19/06/2007 13:45:28 java.lang.NumberFormatException: 0.000
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.hp.ifc.install.database.AppUpgradeDatabase.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Please help.
6 REPLIES
Tim Schmitt_4
Honored Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

In the application server, can you perform a successful test connection to the database using the Server settings wizard?

The error "Wrong database user defined for repository: table ifc_system not found" seems to imply that the user settings are not configured correctly.

Raman Shcharbak
Honored Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

yes.. try to login to Db using sqlplus and corresponding username and password, check that SD tables are fully accessible
Vijay Kavrani
Outstanding Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

Yes, I can make the connection to DB successfully from Server Settings Editor and I can also access DB using sqlplus or Toad.
As far as I know the user settings are also correct. Can someone please tell me at what all places shall I look for user settings?
Raman Shcharbak
Honored Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

Try to execute
select sys_version, sys_site from ifc_system
in toad or sqlplus
Check that sys_site column really exists
Check that your user is using correct schema
Vijay Kavrani
Outstanding Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

error 904: ORA-00904: "SYS_SITE": invalid identifier

What I could understand from this error message that column SYS_SITE is not available in the table IFC_SYSTEM. And it actually is not there in this table, verified from Toad. Surprisingly, this column is also not available in the other database from where I have copied this current database.

Hence, I tried database upgrade utility and as I mentioned earlier it resulted in a datatype conversion exception.
Vijay Kavrani
Outstanding Contributor.

Re: JDBC error 904: ORA-00904: "SYS_SITE": invalid identifier

error 904: ORA-00904: "SYS_SITE": invalid identifier

What I could understand from this error message that column SYS_SITE is not available in the table IFC_SYSTEM. And it actually is not there in this table, verified from Toad. Surprisingly, this column is also not available in the other database from where I have copied this current database and that environment is working fine.

Hence, I tried database upgrade utility and as I mentioned earlier it resulted in a datatype conversion exception.