samerzohdi

Hi, I am using JS 4.1 with SQL Server 2005 Thanks, Samer

nsgarvind > Thank you very very very much for your support and help now I got connection passd./tools/fckeditor/editor/images/smiley/msn/regular_smile.gif really thank you /tools/fckeditor/editor/images/smiley/msn/thumbs_up.gif Samer

Thank you for your response. This is what are in my files: hibernate.properties metadata.hibernate.dialect=com.jaspersoft.ji.hibernate.dialect.SQLServerUnicodeDialect and in default_master.properties dbType=sqlserver what do you think??

Hi, I deploied jasper server with JBoss and MS SQl correctly, but I am gitting this error when I tried to login JS... 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.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 '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) Can any one help me? thanks,

what are the exactly configrantions in the default_master file? I can connect to iReport but I can't deploy JS. this is my confg in iReport: JDBC Driver: MS SQLServer (net.sourceforge.jtds.jdbc.Driver) JDBC URL : jdbc:jtds:sqlserver://localhost:1217/MyDB in the defult master file: # app server root directory appServerDir = D:\\jboss-4.2.1.GA # actual db we're using dbType=sqlserver dbUsername=sa dbPassword= dbHost=localhost # other params have defaults in db props file but can be overridden here dbPort=1217 Thanks, Samer

:( no replay yet. How can I work with Jasper Server 3.5 and MS SQL???? :((

Hi ALL, Jasper Server 3.5 + JBoos + SQL server 2000 ??? is there any tutorial? Thanks, Samer

Thanks ernestoo and lhp. I will try your suggestions.

Hi, we tried to export the reports to pdf, excel... operators are observing much delay in hours times to have the reports data download.!!! it's still terribly slow or imposible to produce....!! we are using: JS 3.5 RAM : 36GB OS Version : Red Hat Enterprise Linux Server release 5.3 (Tikanga) JBoss Oracle DB jdk1.5.0_06 Any advice for this? Thanks, Samer

I am upgrading from 3.0 to 3.5. The `js-ant import-upgrade-ce` seems to only be importing some of the zip file. During the import, I get the following error: [java] 10:37:04,948 ERROR BaseExportImportCommand:45 - java.lang.NullPointerException [java] java.lang.NullPointerException [java] at java.util.zip.ZipFile.getInputStream(ZipFile.java:286) [java] at com.jaspersoft.jasperserver.export.io.ZipFileInput.getFileInputStream(ZipFileInput.java:70) [java] at com.jaspersoft.jasperserver.export.io.BaseImportInput.getFileInputStream(BaseImportInput.java:37) [java] at com.jaspersoft.jasperserver.export.modules.BaseImporterModule.getFileInput(BaseImporterModule.java:124) [java] at com.jaspersoft.jasperserver.export.modules.BaseImporterModule.deserialize(BaseImporterModule.java:99) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.readResourceBean(ResourceImporter.java:374) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:316) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:125) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95) [java] at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) [java] at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) [java] at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) [java] Java Result: 255 could you please helpe me? Samer

Thanks Matt.

Hi ALL, How can I delete the comma from CSV format? I got extra comma don NOT need them in the result, notice the extra comma in red at the end of HEADER and FOOTER lines: HEADER,62,,,, AP001,AP,001,1,88,200911 AP004,AP,004,1,38,200911 FOOTER,155,,,, Can you please helpe me ASAP? Thanks, Samer

Hi All, where I can find jasperserver-pro-3.7-bin for war file?? Samer

can we provide number of max reporting GUI users? please helpe me. Thanks, Samer

Hi, I am using jasperServer 3.5 with Oracle 10g on windows xp and JBoss, whan I running the reports the JS is very slow, and most reports are still stuck. note : the query due to a large volume of data in the database (8 million records) Thanks Samer Zohdi