nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Exception in server.log file

Santhosh979

The server.log file present in the location "/usr/iw-home/ApplicationContainer/server/default/log/", is having lot of SQL Exceptionss,

Could you please let me know what need to be done to fix the issue?

1=> SQL Exception "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist"

2011-08-01 05:07:42,370 INFO [STDOUT] 05:07:42,365 ERROR ContextLoader,main:205 - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting bean property 'repositoryListeners' with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
[See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
]]

Any help on this regard would be very helpful.

Regards
Santhosh

Find more posts tagged with

Comments

Pawan

Hi Santosh,

Do you know when do these error logs get generated in the server.log file? on which event?

Whether these are showing up suddenly? Also, please check for the same logs on your other TS servers i.e. dev, QA, etc.

listANDtable.PNG

Santhosh979

Hi Pawan,

We are getting the below exception during the serve startup. We installed the TeamSite on the production server recently and we are getting this error now.

Regards
Santhosh

Capture.PNG

Pawan

Since you are not getting these errors on other boxes, it is difficult to troubleshoot. You should open a case with Support and find out the severity of these error logs and how to fix them.

Santhosh979

Hi Pawan.

Do you have any idea on where the DataBase information is configured for this Spring application ?

Regards
Santhosh

John742

What components did you install with Teamsite? 7.2.1 ? Judging from the application container directory.
What Teamsite and component version's did you install?
Sounds like one of the schema's did not complete being created, was the install sucessfull?
Post your install log so we can check for schema creation errors. Also what type of access do your DB sid or application ids have? What DB are you using?