数据库为postgresql 点击“流程设计”报错 org.postgresql.util.PSQLException: 不良的类型值 long

提问 未结 4 78
上帝说
上帝说 VIP1 2021-10-11 15:08:10   最后修改:2021-10-11 15:10:28
悬赏:20积分 收藏
产品:vue 版本:8.13
at com.jeeplus.modules.flowable.service.FlowableModelService.getModels(FlowableModelService.java:84) ~[classes/:na] at com.jeeplus.modules.flowable.service.FlowableModelService$$FastClassBySpringCGLIB$$11c5a235.invoke(<generated>) ~[classes/:na] img[/userfiles/fly/125a3ac15f8646dc8ee52cd4127c50c0/files/1633936039585.] org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'thumbnail' from result set. Cause: org.postgresql.util.PSQLException: 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082 ; 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082; nested exception is org.postgresql.util.PSQLException: 不良的类型值 long : \x89504e470d0a1a0a0000000d494844520000002d0000002d08060000003a1ae29a000002e04944415478daed58df6b526118dec52efa23ba080aeacff08f48747a5051f157f3d74c10744ca6178a8c5d0b42188b2e4236314b6585919814132744b46a3936e7c19b31aa63fec8aff71d79135dcc73bef38de03c7038777ecf7978bee77d5e1716142850f0ff821072addd6edbb3d9ecab442271eef178c626938968b55ac271dcd4e9740ec3e1f0613299dc82e7f69593cde5720f63b1d8d8e7f391743a4d1a8d06e976bb6430181004befbfd3ed9dbdb23f051c4ebf54efd7e7fc766b35999130672e6783cfe33180c5e109a4c26e4b268b55a24140a4dec76fb07b55a7d8b85ba8bf97cfea5c3e1208542612eb27fa3542a11b3d92cc8aa3a12ae56ab6fdd6e373938382034d0e97408082058add67bb290468591307a9426f0f740ed6f4b4b4b1c750fa3256829fc2fc50d06c31910bf432d25d6d7d787e86139512c1605bd5eff860ae9ededed479812a3d188c80d97cbc54bb609aa8c398cb1c602fbfbfb43c96ae3a4c3cb2725dae605c4200fd3f48668d2389a33990c6189cdcdcd1690be2f9a3476091ccd2c51afd73b40ba209a34969f5eafc79434cff37d207d2c9a34b6b559f961053c0f480f4493c67a7915c0734593361a8d53d64a0b82c04b521ae26ec8dad3a7a7a71f25797a7575f513ebf42897cbcf24a5472a95cab0cee9b5b5b5a2a49c8e4422379797977f319c88039d4ef745d24444acacac7c66d53dc01a5b40f8b5e49667b158d4814060cc40ed3350b9496d198025b42d779fc6fb832aab54aa452aa4d163b884cab5b9409bccc3193d6a9bcb0c1cc7e941f11fb477c49393931ad8e288fa8e38031474332ea1b414478591b046a309c9fadf071ca005d5cf777676be4bb89c671b1b1b0fd012f09898fcc3841e07855e805df866b329cc93c3954ae5317cf43bbc74d43d7c49f277913c54d83e2c0cef6bb5da51b7dbedcd4a16961fec12bbbbbb4fa3d1e873b0d721924575a9a58404af5f07d57c40e6093c5fb1a561bdfcf33ec62e81a359f2a453a0408102050ae4c66fb109509232650d3b0000000049454e44ae426082 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) ~[spring-jdbc-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) ~[mybatis-spring-2.0.5.jar:2.0.5] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.5.jar:2.0.5] at com.sun.proxy.$Proxy88.selectList(Unknown Source) ~[na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) ~[mybatis-spring-2.0.5.jar:2.0.5] at org.flowable.ui.modeler.repository.ModelRepositoryImpl.findModelsByParameters(ModelRepositoryImpl.java:86) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.flowable.ui.modeler.repository.ModelRepositoryImpl.findByModelType(ModelRepositoryImpl.java:50) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.flowable.ui.modeler.service.FlowableModelQueryService.getModels(FlowableModelQueryService.java:111) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.flowable.ui.modeler.service.FlowableModelQueryService$$FastClassBySpringCGLIB$$5d5205bf.invoke(<generated>) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) ~[spring-tx-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.flowable.ui.modeler.service.FlowableModelQueryService$$EnhancerBySpringCGLIB$$77d7d281.getModels(<generated>) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.flowable.ui.modeler.service.FlowableModelQueryService$$FastClassBySpringCGLIB$$5d5205bf.invoke(<generated>) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) ~[spring-tx-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.10.RELEASE.jar:5.2.10.RELEASE] at org.flowable.ui.modeler.service.FlowableModelQueryService$$EnhancerBySpringCGLIB$$2fa30929.getModels(<generated>) ~[flowable-ui-modeler-logic-6.4.2.jar:6.4.2] at com.jeeplus.modules.flowable.service.FlowableModelService.getModels(FlowableModelService.java:84) ~[classes/:na] at com.jeeplus.modules.flowable.service.FlowableModelService$$FastClassBySpringCGLIB$$11c5a235.invoke(<generated>) ~[classes/:na] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.10.RELEASE.jar:5.2.10.RELEASE]
回帖
  • 2021-10-13 09:33:43
    字段类型错误,改下数据库字段类型
    0 回复
  • 2021-10-13 14:57:21
    改成什么类型
    0 回复
  • 2021-10-13 20:24:02
    @上帝说 记不得了 可能是长字符 类型,你看对应哪个。
    0 回复
  • 2021-10-18 15:44:41
    @蓝色忧郁 长字符类型? pg只有varchar ,报错就是因为act_de_model表的thumbnail字段是bytea类型所造成的的, 除了这个地方,大屏设计那里 也是报这个错,,不可能直接把bytea改成 varchar吧,存的是图片编码相当于blob喽
    0 回复