home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC78077 Status: Geschlossen

IBM DATA SERVER PROVIDER FOR .NET TEST FAILS USING SSIS PACKAGE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Environment: 
DB2 runtime client 9.5 FP 4 on Windows XP 
DB2 Connect on W2003  (Gateway) 
DB2 for z/OS v8.1 - z/OS v1.11 
 
Customer uses ADO.NET to connect from runtime Client to Gateway. 
He receives an error running a SSIS package in Visual Studio 
(2005 or 2008). 
 
Customer explained that package run following operations between 
2 databases on same Z/Os but different subsytem: 
1.- Delete from table on target DB2 
2.- Select on table on source DB2 
3.- Insert on table on Target DB2 
 
Customer error: 
 
Error: 0xC0047062 at Data flow Task, ADO NET Destination [16]: 
 
System.ArgumentException: The DB2Parameter with ParameterName 
'?' is 
already contained by this DB2ParameterCollection. 
 
   in IBM.Data.DB2.DB2ParameterCollection.a(Int32 A_0, 
DB2Parameter A_1) 
   in IBM.Data.DB2.DB2ParameterCollection.a(DB2Parameter A_0) 
 
   in IBM.Data.DB2.DB2ParameterCollection.Add(DB2Parameter 
value) 
   in IBM.Data.DB2.DB2ParameterCollection.Add(Object value) 
 
   in 
Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.PreExecute() 
 
   in 
 
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExe 
cute(IDT 
 
SManagedComponentWrapper100 wrapper) 
 
Error: 0xC004701A at Data flow Task, SSIS.Pipeline: Error in the 
 
implementation phase component prior "ADO NET Destination" (16); 
is the 
error code returned 0x80070057.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 on Windows,                                              * 
* component engn_nmp (.NET data provider)                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Running a SSIS package in Visual Studio customer may hit     * 
* error:                                                       * 
* Error: 0xC0047062 at Data flow Task, ADO NET Destination []: * 
*                                                              * 
*                                                              * 
* System.ArgumentException: The DB2Parameter with              * 
* ParameterName '?' is already contained by this               * 
* DB2ParameterCollection.                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.5 Fixpack 9                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem exist in DB2 version 9.5 Fixpack 4 and first fixed in 
DB2 version 9.5 Fixpack 9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.08.2011
21.10.2011
21.10.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP4,
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList