not seeing all warning messages in job log

Rob4732 · Post by **Rob4732** » Wed Oct 13, 2010 5:14 pm

Hello All,

I am loading a sql server table with 8000 records. A unique index exists on this table(based on 4 columns). When I load the same 8000 records again(with no limit on warnings), only 46 warning messages appear in the log:

(ODBC_INSERT_TABLE_STG,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.TABLE' with unique index 'TABLE_U1'.)

No additional records are loaded into the target table on second run and only 44 warnings in log. Job finishes ok(w/warnings). In theory I would expect to see 8000 warnings in the log.

If run again with warning limit set to 40, I get 40 warnings and then job aborts, as expected.

No show stoppers, but curious why all warning messages are not being captured.

Thx

Robert

bobyon · Post by **bobyon** » Wed Oct 13, 2010 5:25 pm

Did you double click the message to display it in a popup window? Sometimes a single line in the msg log actually represents LOTS of similar msgs.

Rob4732 · Post by **Rob4732** » Wed Oct 13, 2010 5:43 pm

Yes. I opened each message in it's own window and used Next to get to next message. All warnings are the same.

Also the data is static. One thing that occured to me was that maybe a time component of a timestamp was changing each time I ran, but the date is not derived, it is a static value. This date is one of the columns in the Unique index.

Thx