|
|
oracle上无误，在sqlserver上分配权限报错，前台报错
后台报错如下，应该是sql问题，望解决
</action><action direct-execute="false" process="/OA/knowledge/process/simpleFolderSet/simpleFolderSetProcess" activity="informFDSetActivity" action-flag="__action_1__" executor="" execute-context="" name="updateAllSubFDRightsSetAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="folderID"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[inform]]></xbiz:simple></parameter></parameters></action></actions>com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) 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 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:857) 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:595)Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.justep.system.action.Engine.invokeActions(Native Method) ... 21 moreCaused by: com.justep.model.exception.ModelException: 执行ksql:delete from OA_KM_Rights OA_KM_Rights where OA_KM_Rights.fFolderID in (select c.fID from (SELECT c1 AS fID,c1.fParent,c1.fRebuildRight,c1.fIsInheritRights,c1.fFullID AS fFullID from OA_KM_Folder c1) c join (select p1 as fID,p1.fRebuildRight AS fRebuildRight from OA_KM_Folder p1) p on c.fParent = p.fID and c.fRebuildRight = 1 and p.fRebuildRight = 0 and c.fIsInheritRights = 1 and c.fFullID like 'public/inform%') and (select Max(CONCAT(t.fIsInherit , t.fID)) from (select tt as fID,tt.fIsInherit,tt.fFolderID,tt.fKWID,tt.fKWKind,tt.fOrgFID from OA_KM_Rights tt) t where COALESCE(t.fFolderID, '-') = COALESCE(OA_KM_Rights.fFolderID, '-') and COALESCE(t.fKWID, '-') = COALESCE(OA_KM_Rights.fKWID, '-') and t.fOrgFID = OA_KM_Rights.fOrgFID and t.fKWKind = OA_KM_Rights.fKWKind ) <> (CONCAT(OA_KM_Rights.fIsInherit , OA_KM_Rights)) and OA_KM_Rights.fKWKind = 'Folder'时出错！ at com.justep.system.data.impl.TableUtilsImplement.ksqlDelete(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source) at com.justep.system.data.KSQL.executeUpdate(Unknown Source) at KMFolder.rebuildRights(KMFolder.java:586) at KMFolder.updateAllSubFDRightsSet(KMFolder.java:536) ... 26 moreCaused by: com.justep.model.exception.ModelException: 执行sql：DELETE FROM OA_KM_Rights WHERE (OA_KM_Rights.FFOLDERID IN (SELECT c.fID AS fID FROM (SELECT c1.fID AS fID, c1.fParent AS fParent, c1.FREBUILDRIGHT AS fRebuildRight, c1.FISINHERITRIGHTS AS fIsInheritRights, c1.FFULLID AS fFullID FROM OA_KM_Folder c1) c JOIN (SELECT p1.fID AS fID, p1.FREBUILDRIGHT AS fRebuildRight FROM OA_KM_Folder p1) p ON (c.fParent = p.fID) AND (c.fRebuildRight = ?) AND (p.fRebuildRight = ?) AND (c.fIsInheritRights = ?) AND (c.fFullID LIKE ?) )) AND ((SELECT MAX(t.fIsInherit + t.fID) FROM (SELECT tt.fID AS fID, tt.FISINHERIT AS fIsInherit, tt.FFOLDERID AS fFolderID, tt.fKWID AS fKWID, tt.FKWKIND AS fKWKind, tt.FORGFID AS fOrgFID FROM OA_KM_Rights tt) t WHERE (COALESCE(t.fFolderID, ?) = COALESCE(OA_KM_Rights.FFOLDERID, ?)) AND (COALESCE(t.fKWID, ?) = COALESCE(OA_KM_Rights.fKWID, ?)) AND (t.fOrgFID = OA_KM_Rights.FORGFID) AND (t.fKWKind = OA_KM_Rights.FKWKIND) ) <> OA_KM_Rights.FISINHERIT + OA_KM_Rights.fID) AND (OA_KM_Rights.FKWKIND = ?) , binds:[1, 0, 1, public/inform%, -, -, -, -, Folder]出错！ at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source) ... 31 moreCaused by: java.sql.SQLException: 将 varchar 值 '0F7B52FC1B444A6F92C78308403C2120' 转换为数据类型为 int 的列时发生语法错误。 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
|
|
IP卡
狗仔卡
发表于 2013-9-6 10:39:51
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2013-9-6 11:00:50
楼主
