Jump to content
We've recently updated our Privacy Statement, available here ×

samerzohdi

Members
 View Profile  See their activity

  • Posts

    21

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by samerzohdi

    Jasperserver not working !!!

    in Products

    Posted

    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??

     

    Jasperserver not working !!!

    in Products

    Posted

    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,

     

    SQL SERVER 2000 JTDS JDBC Driver Configuration

    in Products

    Posted

    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

    a lot of Time to Export Reports>!!!??

    in Products

    Posted


    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

    Error Import

    in Products

    Posted

    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

    comma in CSV

    in Products

    Posted

    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

     

     

    Query filtered by LoggedInUser.getUsername()

    in Products

    Posted

    Hi,

     - defined new parameter and named username, and set Parameter Class Tyape: java.lang.String, and set Use as aPrompt:True

    and set Default Value Expression: $P{LoggedInUser}.getFullName(), then click OK.

     - use '$P!{username}' in query.  where user.name = '$P!{username}'

    it should work, I tried it. :)

     

    Samer

    internationalization >> help me please..

    in Products

    Posted

    thanks, I got it and I put key and values under the default language.

    But I got the ERROR:

    ErrorÂfillingÂprint...ÂCan'tÂfindÂbundleÂforÂbaseÂnameÂApplicationResources,ÂlocaleÂen_US

    java.util.MissingResourceException:ÂCan'tÂfindÂbundleÂforÂbaseÂnameÂApplicationResources,ÂlocaleÂen_USÂ ÂÂÂÂatÂjava.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:836)Â ÂÂÂÂatÂjava.util.ResourceBundle.getBundleImpl(ResourceBundle.java:726)Â ÂÂÂÂatÂjava.util.ResourceBundle.getBundle(ResourceBundle.java:699)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.util.JRResourcesUtil.loadResourceBundle(JRResourcesUtil.java:572)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.util.JRResourcesUtil.loadResourceBundle(JRResourcesUtil.java:510)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.loadResourceBundle(JRFillDataset.java:533)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:568)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1222)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:853)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251)Â ÂÂÂÂatÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:896)Â ÂÂÂÂatÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)Â ÂÂÂÂatÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)Â

    Print not filled. Try to use an EmptyDataSource...

     

    what I should do?

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore