Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Error: Failing rows exceeds max specified Expand / Collapse
Author
Message
Posted Thursday, March 23, 2006 3:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944

Source: SQL Server 2K (Win2k)

Tool: DTS

Destination: DB2 (Linux)

Error Source: Data Pump

Error Message: The failing rows exceeds the maximum specified

Error Code: 80040E53

The thing I find strange is that the destination tab field type show as Graphic in the package. In DB2 they are VARCHAR.

I tried CStr in the transformation. I tried both IBM ODBC and IBM OLE DB Provider.

Any suggestions.

TIA

Post #268083
Posted Monday, March 27, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #268645
Posted Tuesday, October 9, 2007 4:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:54 PM
Points: 14, Visits: 69
Hello, our DB2 was converted to Linux and I am facing exactly the same problem. I replaced Data Pump with ActiveX for now. Did you figure it out? Thanks.
Post #408373
Posted Monday, December 31, 2007 1:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:20 PM
Points: 73, Visits: 31
Some found the solution?

I have the same problem when inserted directly using the OLEDB Connection from an ExecutionTask runs smoothly, but when I have a load from a text file, fails with the same error you.

Plaease, Help me.
Post #437653
Posted Friday, January 4, 2008 10:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:54 PM
Points: 14, Visits: 69
If you are using DB2 Connect to connect to Linux DB2 from DTS package running DTS Data pump it happens because by default StaticCursor is selected and DB2 does not allow StaticCursor for Update\Inser\Delete.
You need to
1. Go to DB2 Connect Configuration Assistant
2. Right click on Alias
3. Select CLI Settings
4. Select SETTINGS tab
5. If you do not have CursorTypes property already click Add and select it from the list uncheking
STATIC checkbox
6. If you have it already click on current value and then uncheck STATIC box on pop up screen.
7. Exit saving everything

There is another way to do it thru DB2CMD utility commands. Change value to 6 or 7. Search for this command syntax on Google...

Note: On my workstation change was in effect imidiately, but on the server it required reboot. I do not know why...

Post #439034
Posted Friday, January 4, 2008 7:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:20 PM
Points: 73, Visits: 31
No, I use DTS SQL Server 2000.

Help meeeeee
Post #439178
Posted Friday, January 4, 2008 7:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:20 PM
Points: 73, Visits: 31
You can share your solution?
Post #439181
Posted Sunday, January 6, 2008 4:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:54 PM
Points: 14, Visits: 69
That is exactly what I am talking about: Data Pump task of DTS SQL server 2000.
It is used to load data between different sources\destination and it is the one that produces this error.
This thread is dedicated to this issue (see the initial post).
You sounded like you have the same problem - in this case solution is listed above, if not - you are on the wrong thread.
Post #439377
Posted Monday, January 7, 2008 11:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:54 PM
Points: 14, Visits: 69
Data Pump = Transform Data Task.
Post #439713
Posted Tuesday, January 8, 2008 7:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:20 PM
Points: 73, Visits: 31
I do not use DB2 Connect for nothing, just use OleDB Provider for IBM DB2 from SQL 2000 DTS Package.
Post #440382
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse