测试请假管理时流程无法运行

我在用教学视频进行请假管理设计，流程无法跑通，出现unknown column 'startpoxytime' in 'where clause',改如何解决？

您好，您在的软件后台上选择    同步数据表单    试试

同步成功，但没有作用

您好，麻烦您将Tomcat的报的错误，给过来

2017/8/7 下午1:50:1805:50:18,590 DEBUG InputField:363 - InputField.recalculate
2017/8/7 下午1:50:1805:50:18,591 DEBUG InputField:363 - InputField.recalculate
2017/8/7 下午1:50:1805:50:18,592 DEBUG DateField:347 - DateField.recalculate
2017/8/7 下午1:50:1805:50:18,592 DEBUG DateField:347 - DateField.recalculate
2017/8/7 下午1:50:1805:50:18,593 DEBUG TextareaField:241 - TextareaField.recalculate
2017/8/7 下午1:50:1805:50:18,595  INFO AbstractFlowStateRTDAO:273 - MY SQL: SELECT * FROM OBPM_OA.T_FLOWSTATERT vo WHERE vo.DOCID=? AND vo.FLOWID=?
2017/8/7 下午1:50:1805:50:18,597  INFO AbstractNodeRTDAO:341 - MY SQL: SELECT * FROM OBPM_OA.T_NODERT WHERE FLOWSTATERT_ID=?
2017/8/7 下午1:50:1805:50:18,599  INFO AbstractActorRTDAO:165 - MY SQL: SELECT * FROM OBPM_OA.T_ACTORRT WHERE NODERT_ID=? ORDER BY ID
2017/8/7 下午1:50:1805:50:18,603  INFO AbstractRelationHISDAO:301 - MY SQL: SELECT * FROM OBPM_OA.T_RELATIONHIS vo WHERE vo.DOCID='11e7-7b33-dca68b6f-8d0e-c34ac0ccca91' AND vo.FLOWSTATERT_ID='11e7-7b34-4b106177-8d0e-c34ac0ccca91'  AND ENDNODEID = '1501749036428' ORDER BY actiontime DESC
2017/8/7 下午1:50:1805:50:18,607  INFO AbstractRelationHISDAO:328 - MY SQL: SELECT * FROM OBPM_OA.T_RELATIONHIS vo WHERE vo.DOCID='11e7-7b33-dca68b6f-8d0e-c34ac0ccca91' AND vo.FLOWSTATERT_ID='11e7-7b34-4b106177-8d0e-c34ac0ccca91' AND vo.STARTNODEID IS NOT NULL  ORDER BY vo.actiontime
2017/8/7 下午1:50:1805:50:18,652 DEBUG AbstractWorkflowProxyDAO:308 - MY SQL: SELECT * FROM OBPM_OA.T_FLOW_PROXY WHERE  (DOMAINID ='11e1-81e2-37f74759-9124-47aada6b7467') and STATE='1'  AND STARTPROXYTIME <= ?  AND ENDPROXYTIME >= ? AND OWNER in ( '11e7-4f41-64707696-adce-a3340f1dafde','11e7-2b23-35779b84-9ed6-1f856a1db643','11e7-2af1-fe59c37b-9ed6-1f856a1db643','11e7-4f41-649ae202-adce-a3340f1dafde','11e7-2b2a-411930a3-9ed6-1f856a1db643','11e7-2b29-5cb8fc6e-9ed6-1f856a1db643','11e7-2b2a-93ad2cb4-9ed6-1f856a1db643','11e7-2b3e-32eb5669-9ed6-1f856a1db643','11e7-2b2c-1f9715cc-9ed6-1f856a1db643','11e7-2b2b-4335b20f-9ed6-1f856a1db643','11e7-2b3c-47fa56e2-9ed6-1f856a1db643','11e7-2b2b-040712dd-9ed6-1f856a1db643','11e7-2b3d-b7c9e201-9ed6-1f856a1db643','11e7-2f32-86e89833-9ed6-1f856a1db643','11e7-2b3d-13488b3b-9ed6-1f856a1db643','11e7-2af1-fe8a7083-9ed6-1f856a1db643','11e7-2b23-35eaf60c-9ed6-1f856a1db643','11e7-2af1-fe94d0cb-9ed6-1f856a1db643','11e7-4f41-64b56eee-adce-a3340f1dafde','11e7-2af1-fe4f3c23-9ed6-1f856a1db643','11e7-4ac3-a13e9241-adce-a3340f1dafde','11e7-2b23-35b9d3cc-9ed6-1f856a1db643','11e7-2af1-fe064d13-9ed6-1f856a1db643','11e7-4f41-64d5a12a-adce-a3340f1dafde','11e7-2af1-fe421dbb-9ed6-1f856a1db643','11e7-2af1-fe357383-9ed6-1f856a1db643','11e7-2b23-35dfab64-9ed6-1f856a1db643','11e7-2af1-fe68b7a3-9ed6-1f856a1db643','11e7-2b23-35f640b4-9ed6-1f856a1db643','11e7-2b23-355f3174-9ed6-1f856a1db643','11e7-2b23-35a0cd7c-9ed6-1f856a1db643','11e7-2b23-352c1364-9ed6-1f856a1db643','11e7-2af1-fde46d23-9ed6-1f856a1db643','11e7-2b23-35ae6214-9ed6-1f856a1db643','11e7-2b23-35202c7c-9ed6-1f856a1db643','11e7-2b23-35447d74-9ed6-1f856a1db643','11e7-2b23-34e19cc4-9ed6-1f856a1db643','11e7-2b23-3505c6a4-9ed6-1f856a1db643','11e7-2b23-3538bd9c-9ed6-1f856a1db643','11e7-2af1-fe76734b-9ed6-1f856a1db643','11e7-2b23-3552120c-9ed6-1f856a1db643','11e7-2b23-3590eef4-9ed6-1f856a1db643','11e7-2b23-362259e4-9ed6-1f856a1db643','11e7-2b23-34f6363c-9ed6-1f856a1db643','11e7-2af1-fe2b3a4b-9ed6-1f856a1db643','11e7-2af1-fe11e5db-9ed6-1f856a1db643','11e7-2af1-feb37c6b-9ed6-1f856a1db643','11e7-2af1-fe1c6d33-9ed6-1f856a1db643','11e7-2b3f-fd2cb8bb-9ed6-1f856a1db643','11e7-2b23-35c593a4-9ed6-1f856a1db643','11e7-2af1-fea858d3-9ed6-1f856a1db643','11e7-2b23-360cd604-9ed6-1f856a1db643','11e7-4f41-659e4866-adce-a3340f1dafde','11e7-2b23-3583a97c-9ed6-1f856a1db643','11e7-2b23-3601644c-9ed6-1f856a1db643','11e7-2b23-35d12c6c-9ed6-1f856a1db643','11e7-428a-9d41bae5-adce-a3340f1dafde','11e7-2af1-fdf6477b-9ed6-1f856a1db643','11e7-2b23-36175d5c-9ed6-1f856a1db643','11e7-2b23-356b8d8c-9ed6-1f856a1db643' )
2017/8/7 下午1:50:1805:50:18,654 DEBUG InstructionExecutor:86 - 清空持久化指令队列！
2017/8/7 下午1:50:18com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STARTPROXYTIME' in 'where clause'
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2017/8/7 下午1:50:18        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

2017/8/7 下午1:50:1805:50:18,657  INFO AbstractFlowStateRTDAO:119 - MY SQL: SELECT * FROM OBPM_OA.T_FLOWSTATERT WHERE ID=?
2017/8/7 下午1:50:18com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STARTPROXYTIME' in 'where clause'
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2017/8/7 下午1:50:18        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

kelly 发表于 2017-8-4 18:10
您好，麻烦您将Tomcat的报的错误，给过来

2017/8/7 下午1:50:1805:50:18,590 DEBUG InputField:363 - InputField.recalculate
2017/8/7 下午1:50:1805:50:18,591 DEBUG InputField:363 - InputField.recalculate
2017/8/7 下午1:50:1805:50:18,592 DEBUG DateField:347 - DateField.recalculate
2017/8/7 下午1:50:1805:50:18,592 DEBUG DateField:347 - DateField.recalculate
2017/8/7 下午1:50:1805:50:18,593 DEBUG TextareaField:241 - TextareaField.recalculate
2017/8/7 下午1:50:1805:50:18,595  INFO AbstractFlowStateRTDAO:273 - MY SQL: SELECT * FROM OBPM_OA.T_FLOWSTATERT vo WHERE vo.DOCID=? AND vo.FLOWID=?
2017/8/7 下午1:50:1805:50:18,597  INFO AbstractNodeRTDAO:341 - MY SQL: SELECT * FROM OBPM_OA.T_NODERT WHERE FLOWSTATERT_ID=?
2017/8/7 下午1:50:1805:50:18,599  INFO AbstractActorRTDAO:165 - MY SQL: SELECT * FROM OBPM_OA.T_ACTORRT WHERE NODERT_ID=? ORDER BY ID
2017/8/7 下午1:50:1805:50:18,603  INFO AbstractRelationHISDAO:301 - MY SQL: SELECT * FROM OBPM_OA.T_RELATIONHIS vo WHERE vo.DOCID='11e7-7b33-dca68b6f-8d0e-c34ac0ccca91' AND vo.FLOWSTATERT_ID='11e7-7b34-4b106177-8d0e-c34ac0ccca91'  AND ENDNODEID = '1501749036428' ORDER BY actiontime DESC
2017/8/7 下午1:50:1805:50:18,607  INFO AbstractRelationHISDAO:328 - MY SQL: SELECT * FROM OBPM_OA.T_RELATIONHIS vo WHERE vo.DOCID='11e7-7b33-dca68b6f-8d0e-c34ac0ccca91' AND vo.FLOWSTATERT_ID='11e7-7b34-4b106177-8d0e-c34ac0ccca91' AND vo.STARTNODEID IS NOT NULL  ORDER BY vo.actiontime
2017/8/7 下午1:50:1805:50:18,652 DEBUG AbstractWorkflowProxyDAO:308 - MY SQL: SELECT * FROM OBPM_OA.T_FLOW_PROXY WHERE  (DOMAINID ='11e1-81e2-37f74759-9124-47aada6b7467') and STATE='1'  AND STARTPROXYTIME <= ?  AND ENDPROXYTIME >= ? AND OWNER in ( '11e7-4f41-64707696-adce-a3340f1dafde','11e7-2b23-35779b84-9ed6-1f856a1db643','11e7-2af1-fe59c37b-9ed6-1f856a1db643','11e7-4f41-649ae202-adce-a3340f1dafde','11e7-2b2a-411930a3-9ed6-1f856a1db643','11e7-2b29-5cb8fc6e-9ed6-1f856a1db643','11e7-2b2a-93ad2cb4-9ed6-1f856a1db643','11e7-2b3e-32eb5669-9ed6-1f856a1db643','11e7-2b2c-1f9715cc-9ed6-1f856a1db643','11e7-2b2b-4335b20f-9ed6-1f856a1db643','11e7-2b3c-47fa56e2-9ed6-1f856a1db643','11e7-2b2b-040712dd-9ed6-1f856a1db643','11e7-2b3d-b7c9e201-9ed6-1f856a1db643','11e7-2f32-86e89833-9ed6-1f856a1db643','11e7-2b3d-13488b3b-9ed6-1f856a1db643','11e7-2af1-fe8a7083-9ed6-1f856a1db643','11e7-2b23-35eaf60c-9ed6-1f856a1db643','11e7-2af1-fe94d0cb-9ed6-1f856a1db643','11e7-4f41-64b56eee-adce-a3340f1dafde','11e7-2af1-fe4f3c23-9ed6-1f856a1db643','11e7-4ac3-a13e9241-adce-a3340f1dafde','11e7-2b23-35b9d3cc-9ed6-1f856a1db643','11e7-2af1-fe064d13-9ed6-1f856a1db643','11e7-4f41-64d5a12a-adce-a3340f1dafde','11e7-2af1-fe421dbb-9ed6-1f856a1db643','11e7-2af1-fe357383-9ed6-1f856a1db643','11e7-2b23-35dfab64-9ed6-1f856a1db643','11e7-2af1-fe68b7a3-9ed6-1f856a1db643','11e7-2b23-35f640b4-9ed6-1f856a1db643','11e7-2b23-355f3174-9ed6-1f856a1db643','11e7-2b23-35a0cd7c-9ed6-1f856a1db643','11e7-2b23-352c1364-9ed6-1f856a1db643','11e7-2af1-fde46d23-9ed6-1f856a1db643','11e7-2b23-35ae6214-9ed6-1f856a1db643','11e7-2b23-35202c7c-9ed6-1f856a1db643','11e7-2b23-35447d74-9ed6-1f856a1db643','11e7-2b23-34e19cc4-9ed6-1f856a1db643','11e7-2b23-3505c6a4-9ed6-1f856a1db643','11e7-2b23-3538bd9c-9ed6-1f856a1db643','11e7-2af1-fe76734b-9ed6-1f856a1db643','11e7-2b23-3552120c-9ed6-1f856a1db643','11e7-2b23-3590eef4-9ed6-1f856a1db643','11e7-2b23-362259e4-9ed6-1f856a1db643','11e7-2b23-34f6363c-9ed6-1f856a1db643','11e7-2af1-fe2b3a4b-9ed6-1f856a1db643','11e7-2af1-fe11e5db-9ed6-1f856a1db643','11e7-2af1-feb37c6b-9ed6-1f856a1db643','11e7-2af1-fe1c6d33-9ed6-1f856a1db643','11e7-2b3f-fd2cb8bb-9ed6-1f856a1db643','11e7-2b23-35c593a4-9ed6-1f856a1db643','11e7-2af1-fea858d3-9ed6-1f856a1db643','11e7-2b23-360cd604-9ed6-1f856a1db643','11e7-4f41-659e4866-adce-a3340f1dafde','11e7-2b23-3583a97c-9ed6-1f856a1db643','11e7-2b23-3601644c-9ed6-1f856a1db643','11e7-2b23-35d12c6c-9ed6-1f856a1db643','11e7-428a-9d41bae5-adce-a3340f1dafde','11e7-2af1-fdf6477b-9ed6-1f856a1db643','11e7-2b23-36175d5c-9ed6-1f856a1db643','11e7-2b23-356b8d8c-9ed6-1f856a1db643' )
2017/8/7 下午1:50:1805:50:18,654 DEBUG InstructionExecutor:86 - 清空持久化指令队列！
2017/8/7 下午1:50:18com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STARTPROXYTIME' in 'where clause'
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2017/8/7 下午1:50:18        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

2017/8/7 下午1:50:1805:50:18,657  INFO AbstractFlowStateRTDAO:119 - MY SQL: SELECT * FROM OBPM_OA.T_FLOWSTATERT WHERE ID=?
2017/8/7 下午1:50:18com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STARTPROXYTIME' in 'where clause'
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2017/8/7 下午1:50:18        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2017/8/7 下午1:50:18        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

您好，您先在您的数据库中检查一下用SELECT STARTPROXYTIME  FROM T_FLOW_PROXY ，看看STARTPROXYTIME是否有这个字段，

kelly 发表于 2017-8-7 17:00
您好，您先在您的数据库中检查一下用SELECT STARTPROXYTIME  FROM T_FLOW_PROXY ，看看STARTPROXYTIME是否 ...

STARTPROXYTIME 不存在，我找过

京维智能 发表于 2017-8-7 17:19
STARTPROXYTIME 不存在，我找过

现在看又有了

京维智能 发表于 2017-8-7 17:24
现在看又有了

还是没有，看错数据库了，另一个项目数据库有