Reason of record not merged? IPLOAD reported "rejected by engine"
Posted in 1998
Update on records not merged: I looked at the violation tables and there are two of the 70 records which were not merged there. To summarize: -Tried to merge 154 records with High performance Loader -84 merged -2 Went to violation table -70 were not merged and are not on the violation table either Any ideas? I found the area of the manual that talks about rejected records. The only thing I found was the mention of the two tables and the filter constraint which HPL activates while loading. ->jparker wrote: Check the violations tables. If you did not name them specifically they will have a name of table_vio and table_dia in your database - these should have the rows (in the vio table) and the reason (in thedia table). You can join the two tables using the tuple_id and look up the reason from the HPL manual. --> Francisco Reyes Wrote I was merging a table with the Hight Performance Loader (deluxe mode) and about 40% of the records were not merged. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet