Willeam's Blog

最近在使用BizTalk Adapter Pack 2.0連接Oracle Database時,在設定帳號密碼之後,進行connect時出現以下錯誤訊息.


但是我確定你輸入的帳號密碼是正確的,因為在ODBC使用原來的帳號密碼時,是可以登入成功的.
後來透過Google搜尋了一下,才知道這個地方輸入的帳號密碼大小寫是有分別的,後來將帳號全部改成大寫後,果然就真的過了,真是虛驚一場.

當BizTalk 2009在安裝時，若與SQL Server 2008是不同台，則在安裝完後進行configuration時可能會遇到這個錯誤畫面.


看起來似乎是因為BizTalk BAM Archiving的功能需要用到SQL Server的Integration Services功能，導致BizTalk機器上需要安裝此元件才行。
解決的方法主要是在BizTalk主機上安裝SQL Server的Management Tools元件.
The workaround is to install the SQL Server Management Tools component.

· For SQL Server 2008, run setup and choose the Management Tools: Basic and Management Tools: Complete options.

· For SQL Server 2005, run setup and chose the Management Tools option under SQL Server 2005 Client Tools.

在微軟的Troubleshooting BizTalk Server 2009 Setup.docx文件中有說明.
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-tw&FamilyID=9c697e02-d1bc-4684-8748-28b3a292d5bf

在安裝BizTalk 2009後,進行Configuration時須注意一定要勾選BAM Tools,否則BizTalk 2009會裝不起來.
原因是因為BizTalk 2009的AS2有個新功能是可以做到當沒有收到MDN時,可以自動Resend.而這個Resend的功能是去針測BAMPrimaryImport的資料庫,而BAMPrimaxImport資料庫一定要裝BAMTool才要產生,所以,若你想裝BizTalk 2009的EDI/AS2功能的話,記得要連BAM Tools也一起裝.

1. Validate Map取得Xsl檔案




2. 用文字編輯器開啟xsl檔案,移除裡面ns0的字眼,若想連root節點namespace的ns0都移除的話也可以.


3.建立一新Map,此Map的Source與Destination都與原始一模一樣,但是不需要拉線.設定此map的Custom XSL Path屬性,指向上一步驟所修改過的XSL檔案.


4. 再次Test Map即可得到完全不含ns0的XML.


原來含有ns0的輸出XML.

 

裡面可以找到許多BizTalk元件啦,Adapter啦,工具等等,最重要的是一切都是免費的喔.
http://www.codeplex.com/

在EDI的Message Guideline中,常常會提到AN,ID,DT...等的data type,若沒弄清楚的話,可能會對資料的型態產生混淆,底下列出目前EDI裡面常用的一些常見字眼.

目前BizTalk 2006 R2的AS2功能尚未支援自動重送的功能,也就是說,當你透過AS2正確的送出檔案後,若沒有收到正確的MDN時,BizTalk 2006 R2不會自動幫你重送該筆資料,這個功能需要到BizTalk 2009才會加入,底下是摘錄自BizTalk Server 2009 - EDI Product Team Blog.的新功能說明.
http://blogs.msdn.com/biztalkb2b/archive/2009/02/19/what-is-new-for-edi-as2-in-biztalk-2009.aspx

what is new for EDI/AS2 in BizTalk 2009 Below is excerpts from BizTalk 2009 documentation about new features in BizTalk EDI /AS2 (BizTalk 2009):  EDI Enhancements Electronic Data Interchange (EDI) is one of the most prevalent means by which businesses exchange data electronically. It represents approximately 75 percent of all business-to-business electronic transactions and grows at about 5 to 7 percent per year. EDI usage entails message syntax and standards (including ANSI X12 and UN/EDIFACT), messaging protocols, and transports. BizTalk Server 2006 R2 introduced the ability to process EDI messages using EDI pipeline components, as well as AS2 support. BizTalk Server 2009 improves EDI support with the following features: Dynamic EDI Envelope Generation: ·         Override EDI envelope settings at runtime by setting context properties. ·         Values configured in party resolution are used unless the specific value is overridden. Multiple Batches ·         Multiple batch configurations can be created for each party. ·         Batch lifecycle can be managed individually. HIPAA ·         HIPAA schemas now support equivalent segments. AS2 Enhancements Transmitting EDI transactions over the Internet is an increasingly popular alternative to sending and receiving EDI using value-added networks (VANs). Using the Internet for data exchange reduces costs, increases efficiency, and has advantages in terms of redundancy and scalability. To support this growing trend, BizTalk Server 2006 R2 introduced support for EDIINT AS/2 (Applicability Statement 2). AS/2 is a specification that enables transport of business data over the Internet in a safe and reliable manner. BizTalk Server uses AS/2-defined methods to send, receive, encrypt, decrypt, decompress, sign, and verify signatures between partners using HTTP over the Internet. BizTalk Server helps ensure the security of messages through the use of encryption keys, digital signatures, certificates, and non-repudiation. BizTalk Server 2009 introduces the following AS/2 features: ·         Drummond Group certified for multi-file attachment support, file name preservation support and interoperability. ·         Resend messages if an MDN has not been received within a specified time frame. ·         Send and receive multiple file attachments. ·         Preserve attachment file names.

在開發BizTalk AS2專案時,因為通常需要做signing與Encryption,所以需要在BizTalk的主機上註冊Certificate,不同的Certificate需要放到不同的地方,比如:自己的private Key與客戶的public key所放置的地方就不一樣.
下列表格摘錄自微軟網站,主要是說明Certificate的存放地點,還有當需要用來做signing與encrypt時,需要在BizTalk的哪個地方做設定,我個人是覺得滿清楚的啦.
http://msdn.microsoft.com/en-us/library/bb728096.aspx

Certificate Usage	Certificate Type	Pipeline Component	User Context	Certificate Store	Where Defined
Signature (outbound)	Own private key (.pfx)	MIME/SMIME encoder	Account used by the host instance associated with the send handler.	Current User\ Personal store of each BizTalk server that hosts a MIME/SMIME encoder pipeline as each host instance service account	Certificate page of the Group Properties dialog box
Signature verification (inbound)	Trading partner's public key (.cer)	MIME/SMIME decoder	Account used by the host instance associated with the receive handler.	Local computer\Other People store of each BizTalk server that hosts a MIME/SMIME decoder pipeline as each host instance service account	Certificate page of the Party Properties dialog box Note: The certificate used to verify a signature for a party must be unique from the certificates used to verify signatures for other parties.
Encryption (outbound)	Trading partner's public key (.cer)	MIME/SMIME encoder	Account used by the host instance associated with the send handler.	Local computer\Other People store of each BizTalk server that hosts a MIME/SMIME encoder pipeline	Certificate page of the Send Port Properties dialog box
Decryption (inbound)	Own private key (.pfx)	MIME/SMIME decoder	Account used by the host instance associated with the receive handler.	Current User\Personal store of each BizTalk server that hosts a MIME/SMIME decoder pipeline as each host instance service account	The AS2 Decoder will determine the certificate based upon certificate information in the message. For the BizTalk MIME Decoder, the certificate must be in the Certificate page of the host used for receiving the message. This is not necessary for the AS2 Decoder.

 

AS2是一種常被拿來進行跨Internet傳送EDI的通訊協定,由於此通訊協定可以搭配加密或加簽章,因此越來越多公司採用此通訊協定來進行EDI的交易.
但是AS2並不是只能拿來送EDI,你想要送XML或任何檔案都可以,只是拿來傳EDI是大家比較常見的用法.
最近就遇到一位客戶在與國外進行AS2傳送時,同時包含EDI與XML格式的內容,由於EDI與XML訊息的處理方式不一樣,因此,對方要求須要在AS2 Header上面加入檔案的名稱,如此對方才能夠知道收到的檔案是屬於edi或xml格式的檔案,目前BizTalk 2006 R2的AS2架構仍不支援在AS2 Header保存檔名,須到BizTalk 2009 R2才有支援,但是為了達到客戶的需求,無論如何都要在AS2 Header上面加上Content-Disposition的屬性,於是我想到了一個解法,經過驗證後也確定在AS2 Header裡面加上了我需要的Content-Disposition的屬性.
由於BizTalk 2006 R2在AS2傳送的方式是透過HTTP Adapter,因此,我們可以透過在Orchestration的Assignment設定Message裡面關於HTTP Adapter的UserHttpHeaders屬性.



透過這樣的設定之後,就可以在AS2 Header加入Content-Disposition的屬性,得到結果類似下圖.


透過這種方式,或許可以先應付目前BizTalk尚未提供的AS2 Header的問題.

最近遇到EDI的詢問度滿高的,所以收集了目前所有EDI ANSI X.12的訊息名稱,將來要實作EDI的人,應該多少可以知道有哪些訊息可用,或者是每個訊息的用途在哪.

104 Air Shipment Information
110 Air Freight Details and Invoice
120 Vehicle Shipping Order
121 Vehicle Service
124 Property and Casualty Vehicle Damage
125 Multilevel Railcar Load Details
126 Vehicle Application Advice
127 Vehicle Buying Order
128 Dealer Information
129 Vehicle Carrier Rate Update
130 Student Educational Record (Transcript)
131 Student Educational Record (Transcript) Acknowledgment
135 Student Application
139 Student Loan Guarantee Result
140 Product Registration
141 Product Service Claim Response
142 Product Service Claim
143 Product Service Notification
144 Student Loan Transfer and Status Verification
146 Request for Student Educational Record (Transcript)
147 Response to Request for Student Educational Record (Transcript)
148 Report of Injury, Illness or Incident
149 Notice of Tax Adjustment or Assessment
150 Tax Rate Notification
151 Electronic Filing of Tax Return Data Acknowledgment
152 Statistical Government Information
154 Uniform Commercial Code Filing
159 Motion Picture Booking Confirmation
161 Train Sheet
163 Appointment Schedule Information
170 Revenue Receipts Statement
175 Court Notice
176 Court Submission
180 Return Merchandise Authorization and Notification
185 Royalty Regulatory Report
186 Laboratory Reporting
188 Educational Course Inventory
189 Application for Admission to Educational Institutions
190 Student Enrollment Verification
191 Student Loan Preclaims
194 Grant or Assistance Application
195 Federal Communication Commission (FCC) License Application
196 Contractor Cost Data Reporting
197 Real Estate Title Evidence
199 Mortgage Settlement Information
200 Mortgage Credit Report
201 Residential Loan Application
203 Secondary Mortgage Market Investor Report
204 Motor Carrier Shipment Information
206 Real Estate Mortgage Inspection Request
210 Motor Carrier Freight Details and Invoice
213 Motor Carrier Shipment Status Inquiry
214 Transportation Carrier Shipment Stats Message
217 Motor Carrier Loading and Route Guide
218 Motor Carrier Tariff Information
242 Data Status Tracking
250 Loan Purchase Order Shipment Management Document
251 Pricing Support
255 InsuranceUnderwriting Information Services
256 Periodic Annuity Compensation
260 Application for Mortgage Insurance Benefits
261 Residential Appraisal Request
262 Residential Appraisal Report
263 Residential Mortgage Insurance Application Response
264 Mortgage Loan Default Status
265 Real Estate Title Insurance Services Order
266 Mortgage Record Change
270 Health Care Eligibility/Benefit Inquiry
271 Health Care Eligibility/Benefit Information
272 Property and Casualty Loss Notification
273 Insurance/Annuity Application Status
275 Patient Information
276 Health Care Claim Status Request
277 Health Care Claim Status Notification
278 Health Care Service Review Information
288 Wage Determination
290 Cooperative Advertising Agreements
300 Reservation (Booking Request) (Ocean)
301 Freight Receipt and Invoice (Ocean)
303 Booking Cancellation (Ocean)
304 Shipping Instructions
309 wazzu U.S. Customs Manifest
310 Freight Receipt and Invoice (Ocean)
311 Canadian Customs Information
312 Arrival Notice (Ocean)
313 Shipment Status Inquiry (Ocean)
315 Status Details (Ocean)
317 Delivery/Pick-Up Order
319 Terminal Information
322 Terminal Operations and Intermodal Ramp Activity
323 Vessel Schedule and Itinerary (Ocean)
324 Vessel Stow Plan (Ocean)
325 Consolidation of Goods In Container
326 Consignment Summary List
350 U.S. Customs Release Information
352 U.S. Customs Carrier General Order Status
353 U.S. Customs Events Advisory Details
354 U.S. Customs Automated Manifest Archive Status
355 U.S. Customs Manifest Acceptance/Rejection
356 U.S. Customs Permit to Transfer Request
357 U.S. Customs In-Bond Information
358 U.S. Customs Consist Information
361 Carrier Interchange Agreement (Ocean)
362 Cargo Insurance Advice of Shipment
404 Rail Carrier Shipment Information
410 Rail Carier Freight Details and Invoice
414 Rail Carrier Settlements
417 Rail Carrier Waybill Interchange
418 Rail Advance Interchange Consist
419 Advance Car Disposition
420 Car Handling Information
421 Estimated Time of Arrival and Car Scheduling
422 Shipper's Car Order
423 Rail Industrial Switch List
425 Rail Waybill Request
426 Rail Revenue Waybill
429 Railroad Retirement Activity
431 Railroad Station Master File
432 Rail Description
433 Railroad Reciprocal Switch File
435 Standard Transportation Commodity Code Master
436 Locomotive Information
440 Shipment Weights
451 Railroad Event Report
452 Railroad Problem Log Inquiry or Advice
453 Railroad Service Commitment Advice
455 Railroad Parameter Trace Registration
456 Railroad Equipment Inquiry or Advice
466 Rate Request
468 Rate Docket Journal Log
470 Railroad Clearance
475 Rail Route File Maintenance
485 Ratemaking Action
490 Rate Group Definition
492 Miscellaneous Rate
494 Scale Rate Table
501 Vendor Performance Review
503 Pricing History
504 Clauses and Provisions
511 Requisition
517 Material Obligation Validation
527 Material Due-In and Receipt
536 Logistics Reassignment
561 Contract Abstract
567 Contract Completion Status
568 Contract Payment Management Report
601 Shipper's Exports Declaration
602 Transportation Services Tender
715 Intermodal Group Loading Plan
805 Contract Pricing Proposal
806 Project Schedule Reporting
810 Invoice
811 Consolidated Service Invoice/Statement
812 Credit/Debit Adjustment
813 Electronic Filing of Tax Return Data
815 Cryptographic Service Message
816 Organizational Relationship
818 Commission Sales Report
819 Operating Expense Statement
820 Payment Order/Remittance Advice
821 Financial Information Reporting
822 Customer Account Analysis
823 Lockbox
824 Application Advice
826 Tax Information Reporting
827 Financial Payment Return Order/Return Notice
828 Debit Authorization
829 Payment Cancellation Request
830 Planning Schedule with Release Capability
831 Application Control Totals
832 Price/Sales Catalog
833 Mortgage Credit Report Order
834 Benefit Enrollment and Maintenance
835 Health Care Claim Payment/Advice
836 Procurement Notices
837 Health Care Claim
838 Trading Partner Profile
839 Project Cost Reporting
840 Request for Quotation
841 Specifications/Technical Information
842 Nonconformance Report
843 Response to Request for Quotation
844 Product Transfer Account Adjustment
845 Price Authorization Acknowledgement/Status
846 Inventory Inquiry/Advice
847 Material Claim
848 Material Safety Data Sheet
849 Response to Product Transfer Account Adjustment
850 Purchase Order
851 Asset Schedule
852 Product Activity Data
853 Routing and Carrier Instruction
854 Shipment Delivery Discrepancy Information
855 Purchase Order Acknowledgment
856 Shipment Notice/Manifest
857 Shipment and Billing Notice
858 Shipment Information
859 Freight Invoice
860 Purchase Order Change Request - Buyer Initiated
861 Receiving Advice/Acceptance Certificate
862 Shipping Schedule
863 Report of Test Results
864 Text Message
865 Purchase Order Change Acknowledgment/Request - Seller Initiated
866 Production Sequence
867 Product Transfer and Resale Report
868 Electronic Forms Structure
869 Order Status Inquiry
870 Order Status Report
871 Component Parts Content
872 Residential Mortgage Insurance Application
875 Grocery Products Purchase Order
876 Grocery Products Purchase Order Change
877 Manufacturer Coupon Family Code Structure
878 Product Authorization/De-authorization
879 Price Change
880 Grocery Products Invoice
881 Manufacturer Coupon Redemption Detail
882 Direct Store Delivery Summary Information
883 Market Development Fund Allocation
884 Market Development Fund Settlement
885 Store Characteristics
886 Customer Call Reporting
887 Coupon Notification
888 Item Maintenance
889 Promotion Announcement
891 Deduction Research Report
893 Item Information Request
894 Delivery/Return Base Record
895 Delivery/Return Acknowledgment or Adjustment
896 Product Dimension Maintenance
920 Loss or Damage Claim - General Commodities
924 Loss or Damage Claim - Motor Vehicle
925 Claim Tracer
926 Claim Status Report and Tracer Reply
928 Automotive Inspection Detail
940 Warehouse Shipping Order
943 Warehouse Stock Transfer Shipment Advice
944 Warehouse Stock Transfer Receipt Advice
945 Warehouse Shipping Advice
947 Warehouse Inventory Adjustment Advice
980 Functional Group Totals
990 Response to a Load Tender
996 File Transfer
997 Functional Acknowledgment
998 Set Cancellation