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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
