列'nvcName'不属于表bts_party_sendport。 [英] Column 'nvcName' does not belong to table bts_party_sendport.

问题描述

Hello

尝试删除应用程序，获取错误"列'nvcName'不属于表bts_party_sendport。"

原因是，此应用程序中的一个发送端口列在Party的聚合发送端口中（双击协议，甲方 - >乙方，交换设置，发送端口，发送端口列在右侧） 。一旦我从
列表中删除了发送端口，我就可以删除该应用程序。

有没有更好的方法来实现这一目标？如脚本或api等，一旦安装/导入应用程序，应再次将此发送端口添加到协议中。


（这是X12协议）

谢谢

解决方案

< blockquote>

我编写了一些命令行实用程序来操作BizTalk工件。  Microsoft.BizTalk.ExplorerOM.dll提供了一个api，它可以提供一种可编写脚本的方法来完成此任务。 我没有为缔约方提供实用工具，但它应该是相对
直接开发一个。 下面的示例代码段会将应用程序引用添加到另一个应用程序。 通过一些研究，您应该能够写一些内容来删除派对中的发送端口。

注意：Microsoft.BizTalk.ExplorerOM.dll仅支持32位，所以make确保以32位模式编译实用程序。

从注册表中读取连接信息： SOFTWARE \ Microsoft \ BizTalk Server \3.0 \Administration

 static void Main（string [] args）
 {
 try 
 {
 using（BtsCatalogExplorer） catalog = new BtsCatalogExplorer（））
 {
 catalog.ConnectionString = @" Server = myServer; Initial Catalog = myCatalog; Integrated Security = SSPI;" ;; 
 catalog.Applications [args [0]]。AddReference（catalog.Applications [args [1]]）; 
 catalog.SaveChanges（）; 
} 
} 
 catch（例外e）
 {
 Console.WriteLine（" Error"）; 
} 
} 

Hello

Trying to delete to an application, getting the error "Column 'nvcName' does not belong to table bts_party_sendport."

Reason is, one of the send ports in this application are listed in Party's aggrement's Send Ports(double click on agreement, Party A -> Party B, Interchange Settings, Send ports, send port is listed on the right). Once I remove the send port from the list, I can delete the application.

Is there a better way to achieve this? like scripted or api etc,again this send port should be added to the agreement again once the application is installed/imported.
(It is an X12 agreement)

Thanks

解决方案

I have written a few command line utilities to operate on BizTalk Artifacts.  Microsoft.BizTalk.ExplorerOM.dll provides an api that may provide a scriptable way of accomplishing this.  I don't have a utility for Parties, but it should be relatively straight forward to develop one.  The sample code snippet below adds an application reference to another application.  With a bit of research you should be able to write something to remove send ports from parties.

NOTE: Microsoft.BizTalk.ExplorerOM.dll is only supported for 32-bit, so make sure you compile your utilities in 32-bit only mode.

The connection information is read from the registry: SOFTWARE\Microsoft\BizTalk Server\3.0\Administration

        static void Main(string[] args)
        {
            try
            {
                using (BtsCatalogExplorer catalog = new BtsCatalogExplorer())
                {
                    catalog.ConnectionString = @"Server=myServer;Initial Catalog=myCatalog;Integrated Security=SSPI;";
                    catalog.Applications[args[0]].AddReference(catalog.Applications[args[1]]);
                    catalog.SaveChanges();
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Error");
            }
        }

这篇关于列'nvcName'不属于表bts_party_sendport。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！