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

ismails

Members
  • Posts

    16
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by ismails

  1. I have tried both version(windows exe installer and manual installer) both of them cause exception. For db configuration, I used both bundled and existing db but again with no success. Don't know if it is matter but, I have MAVEN_HOME, ANDROID_HOME, AND JAVA_HOME in my environment variables. thanks in advence

     

  2. It's too late but it may help someone;

    I had faced with the same problem as well, I was calling a stored process which took two parameters. I was sending one parameter. You may be you have the same mistake. by the way in ireport 4.5.1 it gives the warning that you have to give two parameters but ireport 4.8.0 does not give this warning, it just give he null check bla bla error.

    example:

    proper form of function calling => exec sp_myStoredProcess param1 param2(which I forgot to send)

    what was I did in ireport v 4.8.0 => exec sp_myStoredProcess param1

  3. hi poppogbr as a said before use these versions together they work properly, I have looked for 2 weeks but not found any solution

    have nice day

    1. JasperReport 4.5
    2. Tomcat 7
    3. Mysql 5.5

    by the way, if you are suspicious about required existing modules(becaurse of the old versions)  I'm using this system for 5 months without any problem and all required modules are included

  4. Hello everyone I'm in trouble with jasperreport server for 3 weaks. I will be very very greatfull for any idea to solve this problem. Thank you in advance

    I have changed sections that

    type=InnoDB to engine=InnoDB
    and
    maxValue to `maxValue` (this change is needed only in js-create.dll. It's a field in JIDataType table)

    - mysql/js-create.dll and
    - mysql/quartz.dll
    I did this because the word maxValue is a reserved word for many sql servers so I told mysql maxValue is a variable name not comman by backticking it.
    but now I'm getting another error.
    Here is some part of my installation log:

    -java- Imported resource /datasources/JServerJNDIDS
    -java- About to save resource /datasources/repositoryDS
    -java- Imported resource /datasources/repositoryDS
    -java- About to save resource /datatypes/date
    -java- 2012-09-23 21:55:54,299  WARN JDBCExceptionReporter:100 - SQL Error: 1064, SQLState: 42000
    -java- 2012-09-23 21:55:54,301 ERROR JDBCExceptionReporter:101 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'maxValue, strictMin, strictMax, id) values (3, null, null, null, null, null, 0, ' at line 1
    -java- 2012-09-23 21:55:54,303 ERROR HibernateDaoImpl:79 - Hibernate DataAccessException
    -java- org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType]
    -java- at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
    -java- at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    -java- at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
    -java- at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    -java- at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:748)
    -java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$12.execute(HibernateRepositoryServiceImpl.java:459)
    -java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:73)
    -java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64)
    -java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:430)
    -java- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    -java- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    -java- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    -java- at java.lang.reflect.Method.invoke(Method.java:601)
    -java- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    -java- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    -java- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    -java- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    -java- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    -java- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    -java- at $Proxy1.saveResource(Unknown Source)

    (it is very long so I think this is enough)
    Probably, hibernate xml file which is reponsible for filling the table named JIDataType with data has to be fixed too because it sends maxvalue in a way that mysql percieves it as a reserved word again

×
×
  • Create New...