AnsweredAssumed Answered

Unable to see defects - Database corrupted (TESS 4.5)

Question asked by defus on Jun 18, 2013
Latest reply on Jun 27, 2013 by defus
Hi everybody. Can some one help me with this incident. it seems that the database mees some tables.

Do i have to manualy create the table ts_defects_20130429 that inherits from ts_defects ?

2013-06-04 13:01:00,871 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <Started collecting stats >
2013-06-04 13:01:00,873 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <Statistics download starting...>
2013-06-04 13:01:00,941 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <List size 1 for the TIM 174072828>
2013-06-04 13:01:00,968 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <file name to process..2013-06-04-11-00.1370343600.stats>
2013-06-04 13:01:00,969 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.handler.StatsCollectionDataHandler] - <SessionId Encryption Required is : true>
2013-06-04 13:01:01,013 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.service.Service] - <File '2013-06-04-11-00.1370343600.stats' read, length=0>
2013-06-04 13:01:01,013 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <result for the file 2013-06-04-11-00.1370343600.stats null>
2013-06-04 13:01:01,016 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <Monitor Update Successful>
2013-06-04 13:01:01,016 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <Hourly stats completed : Count : 0>
2013-06-04 13:01:01,017 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.services.managers.UserManager] - <0 rows deleted from user session map>
2013-06-04 13:01:01,017 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <Statistics download finished.>
2013-06-04 13:01:01,017 [StatsCollectionThreadPool-1] INFO [com.timestock.tess.framework.task.StatsCollectionTask] - <End collecting stats >
2013-06-04 13:01:44,618 [Thread-7] INFO [com.timestock.tess.services.processors.DefectProcessor] - <BizEventAgeoutThread: aged out 0 of 0 biz events>
2013-06-04 13:02:44,630 [Thread-7] INFO [com.timestock.tess.services.processors.DefectProcessor] - <BizEventAgeoutThread: aged out 0 of 0 biz events>
2013-06-04 13:02:58,717 [Thread-5] INFO [com.timestock.introscope.IntroscopeManager] - <Number of traces in the queue=0>
2013-06-04 13:03:10,354 [Thread-20] INFO [com.timestock.tess.services.processors.BizEventProcessor] - <Checking Pending BizEvents>
2013-06-04 13:03:10,356 [Thread-20] INFO [com.timestock.tess.services.processors.BizEventProcessor] - <Finished Checking Pending BizEvents>
2013-06-04 13:03:44,641 [Thread-7] INFO [com.timestock.tess.services.processors.DefectProcessor] - <BizEventAgeoutThread: aged out 0 of 0 biz events>
2013-06-04 13:03:58,899 [Timer-5] INFO [com.timestock.tess.services.scheduler.AgeoutSessionsTask] - <aged out 0 sessions>
2013-06-04 13:04:44,653 [Thread-7] INFO [com.timestock.tess.services.processors.DefectProcessor] - <BizEventAgeoutThread: aged out 0 of 0 biz events>
2013-06-04 13:05:00,585 [Timer-8] INFO [com.timestock.tess.services.scheduler.DefectAggregationTask] - <aggregating defects from 29-Apr-2013 20:00...>
2013-06-04 13:05:00,626 [Timer-8] ERROR [com.timestock.tess.services.scheduler.DefectAggregationTask] - <Defect aggregation failed>
org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.loader.Loader.doList(Loader.java:2214)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)

at org.hibernate.loader.Loader.list(Loader.java:2090)

at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)

at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)

at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)

at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)

at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:804)

at com.timestock.tess.services.scheduler.DefectAggregationTask.countDefects(DefectAggregationTask.java:357)

at com.timestock.tess.services.scheduler.DefectAggregationTask.aggregateAnInterval(DefectAggregationTask.java:236)

at com.timestock.tess.services.scheduler.DefectAggregationTask.run(DefectAggregationTask.java:159)

at com.timestock.tess.services.scheduler.BaseSchedulerTask.run(BaseSchedulerTask.java:41)

at com.timestock.tess.services.scheduler.SchedulerTimerTask.run(SchedulerTimerTask.java:25)

at java.util.TimerThread.mainLoop(Timer.java:512)

at java.util.TimerThread.run(Timer.java:462)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "ts_defects_20130429" does not exist

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)

at org.hibernate.loader.Loader.doQuery(Loader.java:662)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

at org.hibernate.loader.Loader.doList(Loader.java:2211)

... 14 more


Regard's
Landry DEFO KUATE

Outcomes