Kh?c ph?c: Thng bo l?i khi b?n s? d?ng b? i?u h?p BizTalk cho DB2 ? g?i m?t DB2 lu tr? th? t?c: "SQLSTATE: 42884, SQLCODE:-440"

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2590912 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

B?n s? d?ng Microsoft BizTalk Adapter cho DB2 ? g?i m?t th? t?c IBM DB2 ?c lu tr?. Khi tn c?a cc th? t?c ?c lu tr? c m?t s? nh nhn v?t th? hai (v d?, E1SPNAME), b?n nh?n ?c sau khi thng bo l?i:
SQLSTATE: 42884
SQLCODE:-440
Gi tr? SQLSTATE ch? ra r?ng khng c thi quen ? ?c t?m th?y v?i ? ch? r? tn v l?p lu?n tng thch.
Chu yV?n ? ny c?ng c th? x?y ra khi b?n s? d?ng b?t k? nh cung c?p DB2 ?c bao g?m trong Microsoft my ch? lu tr? tch h?p my ch? 2009.

GI?I PHP

Hotfix gi?i quy?t v?n ? ny ?c bao g?m trong Cumulative Update 1 cho my ch? lu tr? tch h?p my ch? 2009.

? bi?t thm chi ti?t v? lm th? no ? c ?c gi cumulative update, nh?p vo s? bi vi?t sau y ? xem bi vi?t trong c s? ki?n th?c Microsoft:
2587090 Tch l?y gi 1 cho my ch? lu tr? tch h?p my ch? 2009

CCH GI?I QUY?T KHC

? lm vi?c xung quanh v?n ? ny, c th? ?i tn c?a th? t?c DB2 ?c lu tr? ? cc k? t? th? hai c?a n g?m m?t k? t? th? t? ch? ci thay v? s?.

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

THNG TIN THM

V?n ? ny x?y ra ch? khi m?t trong nh?ng nh cung c?p c?a Microsoft DB2 hay Adapter BizTalk cho DB2 s? g?i m?t hai ph?n tn cho IBM DB2. V d?, cc l?i x?y ra n?u cc ?nh d?ng sau y ?c g?i ?n IBM DB2 c?a tn th? t?c, quy?n ch? huy Execute SQL statement (EXCSQLSTT):
SCHEMA_NAME.SP_NAME
Chu yTrong ?nh d?ng ny, vi?c gi? ch? SCHEMA_NAME ?i di?n cho tn l?c ? b?n c?u h?nh trong chu?i k?t n?i, v vi?c gi? ch? SP_NAME ?i di?n cho tn c?a th? t?c DB2 ?c lu tr?.

Khi ch? tn DB2 lu tr? th? t?c (c ngh?a l, m?t ph?n m?t trong nh?ng tn) ?c g?i ?n IBM DB2 c?a tn th? t?c, quy?n ch? huy Execute SQL statement (EXCSQLSTT), l?i khng x?y ra b?i v? tn ng th? t?c ?c lu tr? ?c g?i. V d?, cc l?i x?y ra khi b?n s? d?ng m?t my ch? lin k?t v?i SQL Server ? g?i m?t th? t?c DB2 ?c lu tr? b?ng cch s? d?ng cc Microsoft OLE DB Provider cho DB2.

Thu?c tnh

ID c?a bi: 2590912 - L?n xem xt sau cng: 13 Thang Chin 2011 - Xem xt l?i: 1.0
p d?ng
  • Microsoft Host Integration Server 2009
  • Microsoft BizTalk Adapters for Host Systems 2.0
T? kha:
kbqfe kbfix kbexpertiseinter kbsurveynew kbbug kberrmsg kbmt KB2590912 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:2590912

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com