Error using js-import.sh ( jasper 2.1) on Oracle

[nnspradeep]

hi

i am getting the following error when i am trying to import the reports into the jasper metadata repository which is on oracle10gr2

OS    : AIX 5.3

JasperServer Version:  2.1

Metadata Rep.              : Oracle 10gr2

 

the import starts ... and a few components gets imported. suddenly the following erros comes;

please help me how to fix it.

Error desc:

13:14,165  WARN JDBCExceptionReporter:77 - SQL Error: 1460, SQLState: 72000
13:14,171 ERROR JDBCExceptionReporter:78 - ORA-01460: unimplemented or unreasonable conversion requested

13:14,175 ERROR AbstractFlushingEventListener:301 - Could not synchronize database state with session
.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hi
nate.persistent.RepoFileResource]
     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)
     at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
     at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
     at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:806)
     at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
     at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:804)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:78)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:67)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(Hi
nateRepositoryServiceImpl.java:265)
     at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:618)
     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
     at $Proxy1.saveResource(Unknown Source)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:300)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:118)
     at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:114)
     at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:84)
     at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
     at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:77)
     at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
sed by:
a.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
     at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
     at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
     at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
     at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
     at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
     at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2200)
     ... 31 more
13:14,184 ERROR HibernateDaoImpl:82 - Hibernate DataAccessException
.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibe
te.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.
sistent.RepoFileResource]
sed by:
.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hi
nate.persistent.RepoFileResource]
     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)
     at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
     at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
     at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:806)
     at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
     at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:804)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:78)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:67)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(Hi
nateRepositoryServiceImpl.java:265)
     at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:618)
     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
     at $Proxy1.saveResource(Unknown Source)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:300)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:118)
     at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:114)
     at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:84)
     at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
     at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:77)
     at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
sed by:
a.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
     at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
     at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
     at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
     at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
     at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
     at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2200)
     ... 31 more
13:14,212 ERROR BaseExportImportCommand:46 - com.jaspersoft.jasperserver.api.JSExceptionWrapper: JDBC exception on Hibernate
a access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.ap
etadata.common.service.impl.hibernate.persistent.RepoFileResource]
.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on
bernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasp
erver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
sed by: org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.serv
.impl.hibernate.persistent.RepoFileResource]
     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)
     at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
     at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
     at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:806)
     at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
     at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:804)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:78)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.j
:67)
     at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(Hi
nateRepositoryServiceImpl.java:265)
     at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:618)
     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
     at $Proxy1.saveResource(Unknown Source)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:300)
     at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:118)
     at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:114)
     at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:84)
     at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
     at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:77)
     at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
sed by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

     at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
     at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
     at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
     at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
     at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
     at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
     at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2200)
     ... 31 more

Post Edited by nnspradeep at 04/28/2009 12:25

[nnspradeep]

the error got fixed.

 

I was using wrong ojdbc14.jar.

 

 

[senthilm]

Hi,

      I too getting the same error. Can u tell me how u fixed this?

Thanks & Regards,

senthilm

[senthilm]

i have these files in lib dir,

ojdbc14.jar and ocrs12.zip

and i am trying to use jasper server with oracle 9i in tomcat

 

 

[nnspradeep]

hi senthil

 

my repository was oracle 10 gr 2. so i need the drivers(ojdbc.jar) corresponding to that database.

 

As u are using 9i. try to get the ojdbc.jar of 9i version and replace it in the /lib folder of jasper server.

[senthilm]

Yes pradeep. it is working..

Thank you,

senthilm