06 2007 档案

摘要:公司的一台服务器中毒了,满厉害的,许多关键服务起不来,MQ,SMTP,SQL等出问题满严重的,不知道怎么修复,只好重装系统,而且第二天机器要上线,所以就通宵装了. 装之前备份数据就花了5,6个小时.没有办法,已经五年没有重装过服务器了,备份好数据,装上操作系统,差点卡在SQL Server上,最后发现多装了一个Dell 的Open Manage,sql server怎么也无法继续进行安装. Win... 阅读全文
posted @ 2007-06-28 11:53 upzone 阅读(207) 评论(0) 推荐(0)
摘要:做一个Rule Engine 应用的时候,我先检查是否存在某个xml element,如果不存在,则用XmlHelper来添加一个节点,使用Microsoft.RuleEnginee.dll 一开始没有注意,在添加多个节点的时候没有设置他们的优先级,以为是按照rule的排列顺序执行,结果生成出来的xml用xsd校验不通过,xsd设置了sequence,查看test policy的日志,发现执行... 阅读全文
posted @ 2007-06-25 17:18 upzone 阅读(679) 评论(2) 推荐(0)
摘要:其实也不是什么高级的技术了,不过也是才知道,原来SQL Adapter可以接收循环数据(一直以为只能接收单条记录,所以一直搞什么信封拆分,看来是多余的)1.存储过程create procedure ins_sys_SPUser@Name varchar(20),@Password varchar(20),@Email varchar(20)asinsert into sys_SPUser(Name... 阅读全文
posted @ 2007-06-19 22:03 upzone 阅读(1136) 评论(3) 推荐(0)
摘要:关于Execute Receive Pipeline的问题 阅读全文
posted @ 2007-06-19 12:11 upzone 阅读(664) 评论(6) 推荐(0)
摘要:今天做了一个接收文件然后用SQL Adapter调用sp insert的例子 CREATE PROCEDURE SP_Demo @Name varchar(30), @Mail varchar(30) as begin set nocount on; insert into Person(Name,Mail) values(@Name,@Age) select scope_identity()... 阅读全文
posted @ 2007-06-14 14:02 upzone 阅读(779) 评论(2) 推荐(0)
摘要:DataBase Functoids里除了DB Lookup,Error Return和Value Extractor之外还有几个如 Get CommonID,Get CommonValue,Get ApplicationID,Get ApplicationValue,Set CommonID,FormatMessage等等几个 1.Cross Reference表的建立 The c... 阅读全文
posted @ 2007-06-08 18:16 upzone 阅读(628) 评论(2) 推荐(0)
摘要:Lately I tried to redeploy a BizTalk 2006 solution from Visual Studio 2005. Unfortunately I was confronted with the following error message “Could not change the bindings for orchestration '.', Versio... 阅读全文
posted @ 2007-06-08 12:36 upzone 阅读(800) 评论(2) 推荐(0)
摘要:Here are a few scripts / stored procedures that most of the BizTalk newbies would love to know. These scripts are very useful in a development environment to clean up your MessageBox and Tracking dat... 阅读全文
posted @ 2007-06-01 14:03 upzone 阅读(401) 评论(0) 推荐(0)
摘要:流程int g_i = 0; int g_k = 0;Message msg; receive(msg)scope{ body() { scope { body { g_i=1; g_k=1; } Compensation1 { g_k = 2; ... 阅读全文
posted @ 2007-06-01 13:20 upzone 阅读(362) 评论(1) 推荐(0)