January 18, 2011 at 11:19 am
How would you troubleshoot INSERT errors when dealing with a large data-set (100+ fields)?
January 18, 2011 at 11:21 am
navecomp (1/18/2011)
How would you troubleshoot INSERT errors when dealing with a large data-set (100+ fields)?
Practically, I copy the DDL to a new table, point the insert at that, and then halve the fields via comments until I find the problem field(s). That's assuming you're getting a data error like 'can't conver to numeric' and not something for 'duplicated primary key' inserts, which is a whole different issue.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2011 at 9:40 am
I do something like Craig, except I halve the rows returned to find rows that cause the problem and then I identify the column(s) that are causing it. Usually identifying the column is pretty easy.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2011 at 9:47 am
Thanks both of you for the quick response.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply