SP10-20036项目如何升级到M3-20221，报错是什么原因？

各位亲，我SP10-20036项目如何升级到M3-20221？

我将平台程序进行升级，数据库仍旧用原SP10的库，报以下错误。

1. 13:57:59,787 DEBUG PropertyUtil:136 -  Load properties file successed
   
2. 13:58:04,846 DEBUG MssqlDocStaticTblDAO:101 - MS SQL Server: SELECT TOP 10 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM ( SELECT * FROM (SELECT TOP 2147483647 * FROM (SELECT * FROM (SELECT D.* FROM TLK_教师管理 D WHERE  D.AUTHOR ='11E4-07DC-88C79C52-99E7-E7E2FC0CFC52') D WHERE 1=1) ORDTB) table_0 WHERE table_0.DOMAINID ='11e4-07da-5d475b8c-99e7-e7e2fc0cfc52') TABNIC) TableNickname WHERE ROWNUMBER>0
   
3. 13:58:04,860 DEBUG AbstractDocStaticTblDAO:1158 - MS SQL Server: SELECT COUNT(*)  FROM ( SELECT * FROM (SELECT TOP 2147483647 * FROM (SELECT * FROM (SELECT D.* FROM TLK_教师管理 D WHERE  D.AUTHOR ='11E4-07DC-88C79C52-99E7-E7E2FC0CFC52') D WHERE 1=1) ORDTB) table_0 WHERE table_0.DOMAINID ='11e4-07da-5d475b8c-99e7-e7e2fc0cfc52') doc WHERE doc.DOMAINID ='11e4-07da-5d475b8c-99e7-e7e2fc0cfc52'
   
4. org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of cn.myapps.core.department.ejb.DepartmentVO.orderByNo
   
5.         at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:85)
   
6.         at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
   
7.         at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
   
8.         at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3560)
   
9.         at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:129)
   
10.         at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
    
11.         at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    
12.         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
    
13.         at org.hibernate.loader.Loader.loadEntity(Loader.java:1851)
    
14.         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
    
15.         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
    
16.         at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)
    
17.         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3038)
    
18.         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
    
19.         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
    
20.         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
    
21.         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
    
22.         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
    
23.         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
    
24.         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)

复制代码

报错是什么原因？

你好，SP10升级M3的步骤如下：
1.用M3的程序连接sp10的数据库，启动Web服务器。
2.进入后台软件编辑界面，执行一次【保存】操作。
3.在后台软件编辑界面，执行【同步数据表单】操作。
4.如有前台表单有操作按钮不兼容，可以到后台重新配置操作按钮。

亲，请按这个步骤操作，如中间遇到问题无法执行后续步骤，请留下QQ方便我远程协助解决，谢谢！

亲，我按这个顺序升级后，错误仍存在，表单无法打开。

1. java.lang.NullPointerException        at cn.myapps.core.dynaform.view.action.ViewAction.getSearchDocument(ViewAction.java:581)
   
2.         at cn.myapps.core.dynaform.view.action.ViewAction.displayByView(ViewAction.java:476)
   
3.         at cn.myapps.core.dynaform.view.action.ViewAction.getSuccessResult(ViewAction.java:292)
   
4.         at cn.myapps.core.dynaform.view.action.ViewRunTimeAction.doDisplayView(ViewRunTimeAction.java:141)
   
5.         at sun.reflect.GeneratedMethodAccessor714.invoke(Unknown Source)
   
6.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   
7.         at java.lang.reflect.Method.invoke(Method.java:597)
   
8.         at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
   
9.         at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
   
10.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    
11.         at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    
12.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
13.         at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    
14.         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    
15.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
16.         at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    
17.         at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    
18.         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    
19.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
20.         at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    
21.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
22.         at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    
23.         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    
24.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
25.         at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    
26.         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    
27.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    
28.         at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    
29.         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

复制代码

Q：155133508

1. 14:01:57,193  INFO AbstractNotificationDAO:87 - SELECT doc.DOCID, doc.FORMID, doc.AUDITDATE, doc.FLOWID, doc.DOMAINID, doc.SUMMARY, nrt.NODEID, art.ID ACTORRTID, art.ACTORID, art.DEADLINE FROM t_pending doc INNER JOIN t_nodert nrt ON doc.DOCID = nrt.DOCID INNER JOIN t_actorrt art ON nrt.ID = art.NODERT_ID AND doc.APPLICATIONID = '11e3-7419-e4efc4ff-aa3b-cb0dc2bb665c' AND art.DEADLINE IS NOT NULL AND art.LASTOVERDUEREMINDER IS NULL AND art.DEADLINE <= ?
   
2. java.sql.SQLException: 列名 'LASTOVERDUEREMINDER' 无效。
   
3.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
   
4.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
   
5.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
   
6.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
   
7.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
   
8.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
   
9.         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   
10.         at cn.myapps.core.workflow.notification.dao.AbstractNotificationDAO.queryOverDuePending(AbstractNotificationDAO.java:92)
    
11.         at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.getOverDueNotifications(NotificationProcessBean.java:278)
    
12.         at cn.myapps.core.workflow.notification.ejb.NotificationProcessBean.notifyOverDueAuditors(NotificationProcessBean.java:222)
    
13.         at cn.myapps.core.workflow.notification.ejb.NotificationJob.run(NotificationJob.java:36)
    
14.         at java.util.TimerThread.mainLoop(Timer.java:512)
    
15.         at java.util.TimerThread.run(Timer.java:462)

复制代码

亲，你的QQ号码是多少？我加你qq远程调试一下！

Q：155-133-508

针对Sqlserver数据库，sp10升级到m3步骤如下
1.用M3的程序连接sp10的数据库，启动Web服务器。
2.进入后台软件编辑界面，执行一次【保存】操作。
3.在后台软件编辑界面，执行【同步数据表单】操作。
4.更新系统库t_department表执行以下语句【update T_DEPARTMENT set ORDERBYNO=0 where ORDERBYNO is null】。
5.如有前台表单有操作按钮不兼容，可以到后台重新配置操作按钮。

谢谢，此问题解决，可结贴。

感谢楼主回复，该贴结贴。