|
Problem IC78077
|
Status: Closed |
IBM DATA SERVER PROVIDER FOR .NET TEST FAILS USING SSIS PACKAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem exist in DB2 version 9.5 Fixpack 4 and first fixed in
DB2 version 9.5 Fixpack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.08.2011
21.10.2011
21.10.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP4,
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
