环境信息：Windows server 2008+Sqlserver 2012
问题描述：在Governor点击审计任务管理报错：
[2017-11-21 15:34:52,222][ERROR][com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor:371] error [com.primeton.esb.sam.audit.AuditTaskMgr.flow?_flowKey=fc0d0ac7-9282-450f-a0b2-74c934bdf754.null] ErrCode: 13106090 Message: 任务调度出错。 at com.primeton.common.schedule.impl.SchedulerFacade.addTask(SchedulerFacade.java:544) at com.primeton.common.schedule.impl.SchedulerFacade.addTask(SchedulerFacade.java:523) at com.primeton.common.schedule.impl.SchedulerFacade.addTask(SchedulerFacade.java:505) at com.primeton.ext.common.schedule.ScheduleManager.addTask(ScheduleManager.java:397) at com.eos.foundation.eoscommon.ScheduleUtil.add(ScheduleUtil.java:261) at com.primeton.esb.sam.audit.samaudittaskbiz.initSamAuditTask_biz.invokePojo0(initSamAuditTask_biz.java:207) at com.primeton.esb.sam.audit.samaudittaskbiz.initSamAuditTask_biz.__choiceinvokePojo0(initSamAuditTask_biz.java:704) at com.primeton.esb.sam.audit.samaudittaskbiz.initSamAuditTask_biz.__invokeBiz(initSamAuditTask_biz.java:640) at com.primeton.esb.sam.audit.samaudittaskbiz.initSamAuditTask_biz._invoke(initSamAuditTask_biz.java:553) at com.primeton.esb.sam.audit.samaudittaskbiz.initSamAuditTask_biz.invoke(initSamAuditTask_biz.java:589) at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223) at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112) at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80) at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100) at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183) at com.primeton.esb.sam.audit.samaudittaskbiz.getSamAuditTask_biz.subprocess0(getSamAuditTask_biz.java:256) at com.primeton.esb.sam.audit.samaudittaskbiz.getSamAuditTask_biz.__choicesubprocess0(getSamAuditTask_biz.java:492) at com.primeton.esb.sam.audit.samaudittaskbiz.getSamAuditTask_biz.__invokeBiz(getSamAuditTask_biz.java:429) at com.primeton.esb.sam.audit.samaudittaskbiz.getSamAuditTask_biz._invoke(getSamAuditTask_biz.java:342) at com.primeton.esb.sam.audit.samaudittaskbiz.getSamAuditTask_biz.invoke(getSamAuditTask_biz.java:378) at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223) at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112) at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80) at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100) at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183) at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50) at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36) at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130) at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32) at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57) at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60) at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53) at $Proxy11.invoke(Unknown Source) at com.primeton.esb.sam.audit.AuditTaskMgr_flow.subprocess5(AuditTaskMgr_flow.java:120) at com.primeton.esb.sam.audit.AuditTaskMgr_flow._action0(AuditTaskMgr_flow.java:334) at com.primeton.esb.sam.audit.AuditTaskMgr_flow.process(AuditTaskMgr_flow.java:2094) at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325) at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330) at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112) at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:122) at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56) at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:722) Caused by: org.quartz.JobPersistenceException: Couldn't store job: 操作数类型冲突: varbinary 与 text 不兼容 [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: 操作数类型冲突: varbinary 与 text 不兼容] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:857) at org.quartz.impl.jdbcjobstore.JobStoreCMT.storeJob(JobStoreCMT.java:312) at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:687) at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:261) at com.primeton.common.schedule.impl.SchedulerFacade.addTask(SchedulerFacade.java:585) at com.primeton.common.schedule.impl.SchedulerFacade.addTask(SchedulerFacade.java:541) ... 72 more
解决方案：用《0-coframe-create-sqlserver.sql》中的sql脚本替换安装包\Primeton_ESB_6.6_Governor_Windows_64\installer\lib\com.primeton.esb.install-6.6.0.0.jar\\META-INF\scripts\server\Sqlserver中同名sql文件，重新初始化governor数据库脚本即可
PS：ESB6.6标准产品没有基于sqlserver2012做过测试，建议使用sqlserver2008。