Reporting

work4u

I have installed TeamSite 7.0 successfully and its working great. However I am not able to bring up the reproting screen. Every time I access the url I get the following error:

------------------------------------------------------------------------
type Status report

message /iw-advancedreportcenter/flow.html

description The requested resource (/iw-advancedreportcenter/flow.html) is not available.

--------------------------------------------------------------------------
In addition I see the following in the server.log file under \Interwoven\ApplicationContainer\server\default\log
-------------------------------------------------------------------------
2009-12-09 16:30:17,125 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/iw-dcf]] Command servlet started.
2009-12-09 16:30:17,218 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

--- Incompletely deployed packages ---
org.jboss.deployment.DeploymentInfo@35cd516c { url=file:/E:/Interwoven/ApplicationContainer/server/default/deploy/iw-advancedreportcenter.war }
deployer: MBeanProxyExt[jboss.web:service=WebServer]
status: Deployment FAILED reason: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp6313167701829106289iw-advancedreportcenter-exp.war/ deployment failed
state: FAILED
watch: file:/E:/Interwoven/ApplicationContainer/server/default/deploy/iw-advancedreportcenter.war
altDD: null
lastDeployed: 1260397731593
lastModified: 1260397729734
mbeans:

org.jboss.deployment.DeploymentInfo@40304d60 { url=file:/E:/Interwoven/ApplicationContainer/server/default/deploy/iw-basicreportcenter.war }
deployer: MBeanProxyExt[jboss.web:service=WebServer]
status: Deployment FAILED reason: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp4222643071616995127iw-basicreportcenter-exp.war/ deployment failed
state: FAILED
watch: file:/E:/Interwoven/ApplicationContainer/server/default/deploy/iw-basicreportcenter.war
altDD: null
lastDeployed: 1260397756406
lastModified: 1260397755953
mbeans:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.web.deployment:war=iw-advancedreportcenter.war,id=902648172
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp6313167701829106289iw-advancedreportcenter-exp.war/ deployment failed

ObjectName: jboss.web.deployment:war=iw-basicreportcenter.war,id=1076907360
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp4222643071616995127iw-basicreportcenter-exp.war/ deployment failed

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.web.deployment:war=iw-basicreportcenter.war,id=1076907360
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp4222643071616995127iw-basicreportcenter-exp.war/ deployment failed

ObjectName: jboss.web.deployment:war=iw-advancedreportcenter.war,id=902648172
State: FAILED
Reason: org.jboss.deployment.DeploymentException: URL file:/E:/Interwoven/ApplicationContainer/server/default/tmp/deploy/tmp6313167701829106289iw-advancedreportcenter-exp.war/ deployment failed
-------------------------------------------------------------------------
Also in the iwjboss_server_out.log I see the following

-------------------------------------------------------------------------
16:28:53,187 INFO [[/iw-advancedreportcenter]] Loading Spring root WebApplicationContext
16:29:05,937 INFO [STDOUT] 16:29:05,906 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 'schedulingReportOptionsDeleteListener' while setting bean property 'repositoryListeners' with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportOptionsDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.xml]: Cannot resolve reference to bean 'reportOptionsSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportOptionsDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.xml]: Cannot resolve reference to bean 'reportOptionsSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-options.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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
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.s
16:29:05,937 INFO [STDOUT] pringframework.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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
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: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
Caused by:
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE cannot be specified on a READ ONLY cursor. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: FOR UPDATE cannot be specified on a READ ONLY cursor.]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:674)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:574)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
----------------------------------------------------------------------

Any ideas on what is causing this issue.
Appreciate the help

Adam Stoller

It looks like something didn't get fully / properly installed - since 7.0 is still not a generally released version you'll have to go through Support (or your local Autonomy Interwoven representative) to get assistance, but my guess would be that you're going to have to re-install - potentially from scratch.