Error while trying to insert into Netezza

Reply
Frequent Contributor
Posts: 82

Error while trying to insert into Netezza

I am trying to insert into netezza database using proc append. I get error:

 

ERROR: Error terminating Netezza load: Operation canceled : ERROR:  External Table : count of bad input rows reached maxerrors limit

 

I checked the usual suspects. Whether I was trying to insert a null value into a non null field, whether I was trying to insert a character into a numeric field, whether I was trying to insert a duplicate in a unique field, but they are all good.

 

What is the cause of this error?

Contributor dkb
Contributor
Posts: 53

Re: Error while trying to insert into Netezza

Ask a Question
Discussion stats
  • 1 reply
  • 584 views
  • 0 likes
  • 2 in conversation