[Spacewalk-list] Installation problems -> ERROR: RHN Entitlement Certificate failed to validate

[Santi Saez]

El 17/10/2008, a las 10:41, Santi Saez escribió:

> Perhaps the problem is something related with Oracle, what about  
> this error?
>
> SQLStatementPrepareError: ('ORA-00942: table or view does not exist 
> \n', 942, 'SELECT id FROM web_customer')

More info.. I get each minute emails with subject "WEB TRACEBACK from  
spacewalk1.xxx.net" and with content:

======================================================================== 
============
org.quartz.JobExecutionException:  
com.redhat.rhn.common.db.WrappedSQLException: ORA-06550: line 1,  
column 7:
PLS-00201: identifier 'RHN_SYNCH_PROBE_STATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
  [See nested exception:  
com.redhat.rhn.common.db.WrappedSQLException: ORA-06550: line 1,  
column 7:
PLS-00201: identifier 'RHN_SYNCH_PROBE_STATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
]
	at com.redhat.rhn.task.SynchProbeState.run(SynchProbeState.java:59)
	at com.redhat.rhn.task.SingleThreadedTask.execute 
(SingleThreadedTask.java:55)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run 
(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
com.redhat.rhn.common.db.WrappedSQLException: ORA-06550: line 1,  
column 7:
PLS-00201: identifier 'RHN_SYNCH_PROBE_STATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

	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:745)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8 
(T4CCallableStatement.java:218)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows 
(T4CCallableStatement.java:969)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout 
(OracleStatement.java:1190)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal 
(OraclePreparedStatement.java:3370)
	at oracle.jdbc.driver.OraclePreparedStatement.execute 
(OraclePreparedStatement.java:3476)
	at oracle.jdbc.driver.OracleCallableStatement.execute 
(OracleCallableStatement.java:4400)
	at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute 
(NewProxyCallableStatement.java:2706)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute 
(NamedPreparedStatement.java:115)
	at  
com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable 
(CachedStatement.java:501)
	at com.redhat.rhn.common.db.datasource.CallableMode.execute 
(CallableMode.java:34)
	at com.redhat.rhn.task.SynchProbeState.run(SynchProbeState.java:52)
	at com.redhat.rhn.task.SingleThreadedTask.execute 
(SingleThreadedTask.java:55)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run 
(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'RHN_SYNCH_PROBE_STATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

	... 18 more
======================================================================== 
============

--
Santi Saez
HOSTALIA
http://www.hostalia.com