I'm wondering if it would be possible to make modifications to the Description field to expand its size and then in the config, set
DropExistingTables: False
Regarding the ObjectID error. I highly doubt we're exceeding a BIGINT in size. I believe that's a 64 bit integer field so that's a very large number. I'm wondering if for some reason it's coming through as a string in the CSV instead of an integer. If you look in the CSV, can you see anything unique about those lines that the log is complaining about? For example in your log above one of those lines is referencing row 29:
[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 29, column 1 (ObjectID). (4864);
Original Message:
Sent: 01-17-2020 09:50 PM
From: Ben Gilles
Subject: AC2DB Revision table extract
The connector is creating the meta data for the table. It will give me an error if I try to have a pre-created table
Original Message:
Sent: 01-17-2020 05:02 PM
From: David LeDeaux
Subject: AC2DB Revision table extract
That's curious since the Description field on the revision object is 32,768 characters according to the object model
Original Message:
Sent: 01-17-2020 04:53 PM
From: Ben Gilles
Subject: AC2DB Revision table extract
Yes,
Original Message:
Sent: 01-14-2020 04:35 PM
From: David LeDeaux
Subject: AC2DB Revision table extract
Hi Ben,
This seems to be reporting an issue on the ObjectID column. Do you have the ability to access the database via SQL Management Studio? I'd like to get the Revision table's column definitions.
Original Message:
Sent: 01-14-2020 03:50 PM
From: Ben Gilles
Subject: AC2DB Revision table extract
I am trying to use the AC2DB SQL connector to extract the Revision table from Rally1. I have had success with several other tables so i know that my configuration file is correct. the error that I get is as follows
Problem in copying... [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 18, column 1 (ObjectID). (4864) (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 20, column 1 (ObjectID). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 27, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 29, column 1 (ObjectID). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 35, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 37, column 1 (ObjectID). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 42, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 44, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 46, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 50, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 58, column 6 (Description). (4864); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot bulk load because the maximum number of errors (10) was exceeded. (4865); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. (7399); [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". (7330)
I understand that this table is very big and I need to parse out my query but this seems like either a meta data error or an unintentional SQL injection just based on the error message. can anyone offer up some advice?
------------------------------
Ben Gilles
------------------------------