Spotfire Server 404 Error

[Natsuki Nakagawa]

Hi

I'm upgrading spotfire from 7.1010.3.1.

After running the upgrading tool, start the spotfire server service(10.3.1).

But "HTTP 404" error has occurred.

Maybe tomcat has not strated normally.

-------

[server.log]

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.spotfire.server.LifecycleManager]: Constructor threw exception; nested exception is com.spotfire.server.ServerInitializationException: TIBCO Spotfire Server will not be started. Database consistency verification failed. Errors found:

Unexpected index for table ROUTING_RULES: OracleDatabaseIndex[

name: ROUTING_RULES_UC2

uniqueness: UNIQUE

]

-------

Please give me some advice.

[Najim Momin]

This database constraints issue will be seen if the Spotfire database user (as specified in the bootstrap.xml) has access to multiple schemas in the Oracle database. To verify, run the following query as the Spotfire database user:

-------

select * from all_constraints where constraint_name = 'ROUTING_RULES_UC2'

-------

If you get multiple results back, then you need to remove the access to the old database for the Spotfire database user or create a new user with only access to the currently needed schema. Once that is done, restart the TIBCO Spotfire Server.

 

If you have multiple constraints missing in your Spotfire DB, then I think to resolve this you need to create missing constraints with the help of your DBA.

As you are upgrading from 7.10 to 10.3.1, so you can refer DB script that comes bundled with 10.3.1 for oracle (create_server_db.sql). Using this create db script you need to create missing db constraints with the help of your DBA.

[Natsuki Nakagawa]

Thank you for your advice !

 

"If  you have multiple constraints missing in your Spotfire DB, then I think to resolve this you need to create missing constraints with the help of your DBA."

 

Upgrade tool was successed. So I think the constraints are sufficient.

 

Do you have any other ideas

 

 

[Najim Momin]

Are you still getting "Database consistency verification failed" error

What error you are getting in Spotfire server logs while browsing Spotfire server URLMaybe capturing fresh Spotfire server logs after service restart would also help to understand current issue.

[Natsuki Nakagawa]

 

 

"Are you still getting "Database consistency verification failed" error "

 

It continues to appear yet.

 

Is it necessary to restart the machine (server)

[Najim Momin]

No need to restart machine but Spotfire server service from services panel (services.msc).

If you still getting Database consistency error then as I mentioned earlier please check ifthe Spotfire database user (as specified in the bootstrap.xml) has access to multiple schemas in the Oracle database. To verify, run the following query as the Spotfire database user:

-------

select * from all_constraints where constraint_name = 'ROUTING_RULES_UC2'

-------

If you get multiple results back, then you need to remove the access to the old database for the Spotfire database user or create a new user with only access to the currently needed schema. Once that is done, restart the TIBCO Spotfire Server.

If you have multiple constraints missing in your Spotfire DB, then I think to resolve this you need to create missing constraints with the help of your DBA.

As you are upgrading from 7.10 to 10.3.1, so you can refer DB script that comes bundled with 10.3.1 for oracle (create_server_db.sql). Using this create db script you need to create missing db constraints with the help of your DBA.

[Natsuki Nakagawa]

This problem has beenresolved by dropping the index 'ROUTING_RULES_UC2'.

Thank you for your advice.