ORA-01460: unimplemented or unreasonable conversion requested

jperreault's Avatar

jperreault

15 Mar, 2011 11:26 PM

Hi, we started to see this error today:

ORA-01460: unimplemented or unreasonable conversion requested

I don't really know what to make of it. It happens when a current-page index block is used on certain pages. We have narrowed it down to an "IN" statement in oracle which is too long. Do you have any suggestions as to what we can do?

Here is the entire error message:

2011-03-15 16:04:33,962 WARN  [JDBCExceptionReporter] : SQL Error: 1460, SQLState: 72000
2011-03-15 16:04:33,962 ERROR [JDBCExceptionReporter] : ORA-01460: unimplemented or unreasonable conversion requested

2011-03-15 16:04:33,966 ERROR [CascadeExceptionHandler] : {User: dpye, id: 85bee7867f000001015063db3cd74e4e, type: page} An error occurred: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select foldercont0_.id as id20_, foldercont0_.name as name20_, foldercont0_.lockId as lockId20_, foldercont0_.isCurrentVersion as isCurren5_20_, foldercont0_.versionDate as versionD6_20_, foldercont0_.metadataId as metadataId20_, foldercont0_.permissionsId as permissi8_20_, foldercont0_.workflowId as workflowId20_, foldercont0_.isWorkingCopy as isWorki10_20_, foldercont0_.parentFolderId as parentF11_20_, foldercont0_.relativeOrder as relativ12_20_, foldercont0_.cachePath as cachePath20_, foldercont0_.isRecycled as isRecycled20_, foldercont0_.recycleRecordId as recycle15_20_, foldercont0_.workflowComment as workflo16_20_, foldercont0_.draftUserId as draftUs17_20_, foldercont0_.siteId as siteId20_, foldercont0_.prevVersionId as prevVer19_20_, foldercont0_.nextVersionId as nextVer20_20_, foldercont0_.originalCopyId as origina21_20_, foldercont0_.workingCopyId as working22_20_, foldercont0_.displayName as display23_20_, foldercont0_.title as title20_, foldercont0_.summary as summary20_, foldercont0_.teaser as teaser20_, foldercont0_.keywords as keywords20_, foldercont0_.description as descrip28_20_, foldercont0_.author as author20_, foldercont0_.startDate as startDate20_, foldercont0_.endDate as endDate20_, foldercont0_.reviewDate as reviewDate20_, foldercont0_.metadataSetId as metadat33_20_, foldercont0_.expirationNoticeSent as expirat34_20_, foldercont0_.firstExpirationWarningSent as firstEx35_20_, foldercont0_.secondExpirationWarningSent as secondE36_20_, foldercont0_.expirationFolderId as expirat37_20_, foldercont0_.fileRewriteFileContents as fileRew38_20_, foldercont0_.maintainAbsoluteLinks as maintai39_20_, foldercont0_.fileBlobId as fileBlobId20_, foldercont0_.shouldBeIndexed as shouldB41_20_, foldercont0_.shouldBePublished as shouldB42_20_, foldercont0_.lastDatePublished as lastDat43_20_, foldercont0_.lastPublishedBy as lastPub44_20_, foldercont0_.byteLength as byteLength20_, foldercont0_.draftOriginalId as draftOr46_20_, foldercont0_.xmlId as xmlId20_, foldercont0_.symlinkLink as symlink48_20_, foldercont0_.folderIsRoot as folderI49_20_, foldercont0_.folderPublishMergeFolderId as folderP50_20_, foldercont0_.folderWorkflowInheritDefs as folderW51_20_, foldercont0_.folderWorkflowRequire as folderW52_20_, foldercont0_.structuredDataDefinitionId as structu53_20_, foldercont0_.pageConfigurationSetId as pageCon54_20_, foldercont0_.pageDefaultConfigurationId as pageDef55_20_, foldercont0_.structuredDataId as structu56_20_, foldercont0_.pageStructuredDataVersion as pageStr57_20_, foldercont0_.contentTypeId as content58_20_, foldercont0_.referenceBlockId as referen59_20_, foldercont0_.referenceFileId as referen60_20_, foldercont0_.referenceFolderId as referen61_20_, foldercont0_.referencePageId as referen62_20_, foldercont0_.referenceTemplateId as referen63_20_, foldercont0_.referenceStylesheetId as referen64_20_, foldercont0_.referenceSymlinkId as referen65_20_, foldercont0_.templateStylesheetId as templat66_20_, foldercont0_.templateTargetId as templat67_20_, foldercont0_.blockIndexedFolderId as blockIn68_20_, foldercont0_.blockIndexedContentTypeId as blockIn69_20_, foldercont0_.blockType as blockType20_, foldercont0_.indexBlockType as indexBl71_20_, foldercont0_.blockFeedURL as blockFe72_20_, foldercont0_.blockIndexTypesBitmask as blockIn73_20_, foldercont0_.blockIndexContentBitmask as blockIn74_20_, foldercont0_.blockIndexOtherBitmask as blockIn75_20_, foldercont0_.blockSortOption as blockSo76_20_, foldercont0_.blockSortOrder as blockSo77_20_, foldercont0_.blockDepthOfIndex as blockDe78_20_, foldercont0_.blockIncludePageXML as blockIn79_20_, foldercont0_.blockMaxRenderedEntities as blockMa80_20_, 1 as formula0_, 1 as formula2_, 1 as formula3_, 1 as formula4_, foldercont0_.assetType as assetType20_ from CASCADE.cxml_foldercontent foldercont0_ where foldercont0_.isCurrentVersion=1 and foldercont0_.isWorkingCopy=0 and foldercont0_.isRecycled=0 and (foldercont0_.cachePath in (? , ?)) and foldercont0_.siteId='18cb76db7f0000010104957650b3d5a1']; SQL state [72000]; error code [1460]; ORA-01460: unimplemented or unreasonable conversion requested
; nested exception is java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select foldercont0_.id as id20_, foldercont0_.name as name20_, foldercont0_.lockId as lockId20_, foldercont0_.isCurrentVersion as isCurren5_20_, foldercont0_.versionDate as versionD6_20_, foldercont0_.metadataId as metadataId20_, foldercont0_.permissionsId as permissi8_20_, foldercont0_.workflowId as workflowId20_, foldercont0_.isWorkingCopy as isWorki10_20_, foldercont0_.parentFolderId as parentF11_20_, foldercont0_.relativeOrder as relativ12_20_, foldercont0_.cachePath as cachePath20_, foldercont0_.isRecycled as isRecycled20_, foldercont0_.recycleRecordId as recycle15_20_, foldercont0_.workflowComment as workflo16_20_, foldercont0_.draftUserId as draftUs17_20_, foldercont0_.siteId as siteId20_, foldercont0_.prevVersionId as prevVer19_20_, foldercont0_.nextVersionId as nextVer20_20_, foldercont0_.originalCopyId as origina21_20_, foldercont0_.workingCopyId as working22_20_, foldercont0_.displayName as display23_20_, foldercont0_.title as title20_, foldercont0_.summary as summary20_, foldercont0_.teaser as teaser20_, foldercont0_.keywords as keywords20_, foldercont0_.description as descrip28_20_, foldercont0_.author as author20_, foldercont0_.startDate as startDate20_, foldercont0_.endDate as endDate20_, foldercont0_.reviewDate as reviewDate20_, foldercont0_.metadataSetId as metadat33_20_, foldercont0_.expirationNoticeSent as expirat34_20_, foldercont0_.firstExpirationWarningSent as firstEx35_20_, foldercont0_.secondExpirationWarningSent as secondE36_20_, foldercont0_.expirationFolderId as expirat37_20_, foldercont0_.fileRewriteFileContents as fileRew38_20_, foldercont0_.maintainAbsoluteLinks as maintai39_20_, foldercont0_.fileBlobId as fileBlobId20_, foldercont0_.shouldBeIndexed as shouldB41_20_, foldercont0_.shouldBePublished as shouldB42_20_, foldercont0_.lastDatePublished as lastDat43_20_, foldercont0_.lastPublishedBy as lastPub44_20_, foldercont0_.byteLength as byteLength20_, foldercont0_.draftOriginalId as draftOr46_20_, foldercont0_.xmlId as xmlId20_, foldercont0_.symlinkLink as symlink48_20_, foldercont0_.folderIsRoot as folderI49_20_, foldercont0_.folderPublishMergeFolderId as folderP50_20_, foldercont0_.folderWorkflowInheritDefs as folderW51_20_, foldercont0_.folderWorkflowRequire as folderW52_20_, foldercont0_.structuredDataDefinitionId as structu53_20_, foldercont0_.pageConfigurationSetId as pageCon54_20_, foldercont0_.pageDefaultConfigurationId as pageDef55_20_, foldercont0_.structuredDataId as structu56_20_, foldercont0_.pageStructuredDataVersion as pageStr57_20_, foldercont0_.contentTypeId as content58_20_, foldercont0_.referenceBlockId as referen59_20_, foldercont0_.referenceFileId as referen60_20_, foldercont0_.referenceFolderId as referen61_20_, foldercont0_.referencePageId as referen62_20_, foldercont0_.referenceTemplateId as referen63_20_, foldercont0_.referenceStylesheetId as referen64_20_, foldercont0_.referenceSymlinkId as referen65_20_, foldercont0_.templateStylesheetId as templat66_20_, foldercont0_.templateTargetId as templat67_20_, foldercont0_.blockIndexedFolderId as blockIn68_20_, foldercont0_.blockIndexedContentTypeId as blockIn69_20_, foldercont0_.blockType as blockType20_, foldercont0_.indexBlockType as indexBl71_20_, foldercont0_.blockFeedURL as blockFe72_20_, foldercont0_.blockIndexTypesBitmask as blockIn73_20_, foldercont0_.blockIndexContentBitmask as blockIn74_20_, foldercont0_.blockIndexOtherBitmask as blockIn75_20_, foldercont0_.blockSortOption as blockSo76_20_, foldercont0_.blockSortOrder as blockSo77_20_, foldercont0_.blockDepthOfIndex as blockDe78_20_, foldercont0_.blockIncludePageXML as blockIn79_20_, foldercont0_.blockMaxRenderedEntities as blockMa80_20_, 1 as formula0_, 1 as formula2_, 1 as formula3_, 1 as formula4_, foldercont0_.assetType as assetType20_ from CASCADE.cxml_foldercontent foldercont0_ where foldercont0_.isCurrentVersion=1 and foldercont0_.isWorkingCopy=0 and foldercont0_.isRecycled=0 and (foldercont0_.cachePath in (? , ?)) and foldercont0_.siteId='18cb76db7f0000010104957650b3d5a1']; SQL state [72000]; error code [1460]; ORA-01460: unimplemented or unreasonable conversion requested
; nested exception is java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
    at com.hannonhill.cascade.model.dao.hibernate.BatchedParameterHelper.returnList(BatchedParameterHelper.java:56)
    at com.hannonhill.cascade.model.dao.hibernate.HibernateFolderContentsDAO$4.doInHibernate(HibernateFolderContentsDAO.java:233)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
    at com.hannonhill.cascade.model.dao.hibernate.HibernateFolderContentsDAO.getLinkableByPath(HibernateFolderContentsDAO.java:222)
    at sun.reflect.GeneratedMethodAccessor751.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.DAOAspectLogger.logDAOMethodCall(DAOAspectLogger.java:40)
    at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy68.getLinkableByPath(Unknown Source)
    at com.hannonhill.cascade.model.service.LocatorServiceImpl.locateLinkableByPath(LocatorServiceImpl.java:161)
    at sun.reflect.GeneratedMethodAccessor750.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionEncoderAspect.process(TransactionalExceptionEncoderAspect.java:86)
    at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionTimer.doSomething(TransactionTimer.java:46)
    at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionDecoderAspect.process(TransactionalExceptionDecoderAspect.java:42)
    at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.RetryTransactionAspect.doTransaction(RetryTransactionAspect.java:59)
    at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionExceptionAspect.doTransaction(TransactionExceptionAspect.java:50)
    at sun.reflect.GeneratedMethodAccessor126.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.ServiceAspectLogger.logServiceMethodCall(ServiceAspectLogger.java:39)
    at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy106.locateLinkableByPath(Unknown Source)
    at com.hannonhill.cascade.model.render.string.MatchStringRewriter.rewrite(MatchStringRewriter.java:70)
    at com.hannonhill.cascade.model.render.page.StringRewriteModuleImpl.rewriteMatches(StringRewriteModuleImpl.java:214)
    at com.hannonhill.cascade.model.render.page.StringRewriteModuleImpl.rewrite(StringRewriteModuleImpl.java:98)
    at com.hannonhill.cascade.model.render.task.PageRewriteTask.transformString(PageRewriteTask.java:653)
    at com.hannonhill.cascade.model.render.task.PageRewriteTask.rewrite(PageRewriteTask.java:141)
    at com.hannonhill.cascade.model.render.task.PageRewriteTask.execute(PageRewriteTask.java:114)
    at com.hannonhill.cascade.model.service.TaskServiceImpl.executeTask(TaskServiceImpl.java:45)
    at com.hannonhill.cascade.model.service.TaskServiceImpl.executeTaskWithReadOnlyTransaction(TaskServiceImpl.java:28)
    at sun.reflect.GeneratedMethodAccessor366.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionEncoderAspect.process(TransactionalExceptionEncoderAspect.java:86)
    at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionTimer.doSomething(TransactionTimer.java:46)
    at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionDecoderAspect.process(TransactionalExceptionDecoderAspect.java:42)
    at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.RetryTransactionAspect.doTransaction(RetryTransactionAspect.java:59)
    at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionExceptionAspect.doTransaction(TransactionExceptionAspect.java:50)
    at sun.reflect.GeneratedMethodAccessor126.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.ServiceAspectLogger.logServiceMethodCall(ServiceAspectLogger.java:39)
    at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy180.executeTaskWithReadOnlyTransaction(Unknown Source)
    at com.hannonhill.cascade.model.task.TaskManager.executeTransactionally(TaskManager.java:281)
    at com.hannonhill.cascade.model.task.TaskManager.execute(TaskManager.java:219)
    at com.hannonhill.cascade.model.task.TaskManager.execute(TaskManager.java:176)
    at com.hannonhill.cascade.model.task.TaskManager.start(TaskManager.java:78)
    at com.hannonhill.cascade.model.service.TaskBasedRenderServiceImpl.renderPage(TaskBasedRenderServiceImpl.java:49)
    at sun.reflect.GeneratedMethodAccessor800.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionEncoderAspect.process(TransactionalExceptionEncoderAspect.java:86)
    at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionTimer.doSomething(TransactionTimer.java:46)
    at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionalExceptionDecoderAspect.process(TransactionalExceptionDecoderAspect.java:42)
    at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.RetryTransactionAspect.doTransaction(RetryTransactionAspect.java:59)
    at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.TransactionExceptionAspect.doTransaction(TransactionExceptionAspect.java:50)
    at sun.reflect.GeneratedMethodAccessor126.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
    at com.hannonhill.cascade.aspect.ServiceAspectLogger.logServiceMethodCall(ServiceAspectLogger.java:39)
    at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy119.renderPage(Unknown Source)
    at com.hannonhill.cascade.view.struts.action.render.RenderPageAction.renderPage(RenderPageAction.java:90)
    at com.hannonhill.cascade.view.struts.action.render.RenderPageAction.getRenderResult(RenderPageAction.java:56)
    at com.hannonhill.cascade.view.struts.action.render.CascadeRenderAction.execute(CascadeRenderAction.java:46)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.hannonhill.cascade.view.struts.request.SiteFilter.doFilter(SiteFilter.java:67)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.hannonhill.cascade.view.struts.security.AuthProtectFilter.doFilter(AuthProtectFilter.java:142)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.hannonhill.cascade.view.struts.request.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:47)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.hannonhill.cascade.view.struts.request.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:922)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1122)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:973)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1244)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3469)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3514)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2213)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at com.hannonhill.cascade.model.dao.hibernate.BatchedParameterHelper$1.doInHibernate(BatchedParameterHelper.java:64)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    ... 274 more
  1. 1 Posted by jperreault on 16 Mar, 2011 12:01 AM

    jperreault's Avatar

    Inexplicably, the error went away after about an hour. Is there a process rebuilding indexes periodically?

  2. 2 Posted by Bradley Wagner on 29 Mar, 2012 09:50 PM

    Bradley Wagner's Avatar

    Unfortunately, we don't have a mechanism for scheduled re-indexing.

  3. Bradley Wagner closed this discussion on 29 Mar, 2012 09:50 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac