HomeForum
Welcome, Guest

Incorrect rejected records
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Incorrect rejected records

Incorrect rejected records 1 year, 2 months ago #1831

  • George
  • OFFLINE
  • Junior Boarder
  • Posts: 36
  • Karma: 0
Hello

I've noticed that the reject log and transformation log are not correct...
These are reporting that certain records are not being stored - however, I've checked in the database and they are stored properly, e.g.:

SQL> select destination_Code from atoz where destination_code like '4369%';
DESTINATION_CODE
--------------------
436990
4369901
4369902
4369903
4369904
4369905
4369906
4369907
4369908
4369909
436991
436992
436993
436994
436995
436996
436997
436998
436999
19 rows selected.
SQL> select destination_Code from atoz where destination_code like '43661%';
DESTINATION_CODE
--------------------
43661

This is a fairly major issue as can't work out if any records are genuinely being rejected.


Another issue I've noticed that relates to the unpivot module is that the progress bar doesn't go to the end before processing completes... perhaps due to new unpivot from a single cell functionality?

regards

George

Re: Incorrect rejected records 1 year, 2 months ago #1832

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Reproduced the problem looking at what can be done about it

Peter

Re: Incorrect rejected records 1 year, 2 months ago #1833

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Can you try latest version of Advanced ETL Processor please

www.dbsoftlab.com/etl-tools/advanced-etl...rprise/download.html

Mike

Re: Incorrect rejected records 1 year, 2 months ago #1835

  • George
  • OFFLINE
  • Junior Boarder
  • Posts: 36
  • Karma: 0
Mike

Been out of action last week...
Will let you know the result later today

regards,
George
  • Page:
  • 1
Time to create page: 0.18 seconds

Testimonials

"Using Active Table Editor is the easiest way of editing lookup tables  I've ever seen. A free 30-day trial is available on their Web site; the only issue is that when the 30 days are up, you're going to want to buy it."
- Moo Ling, Software Enginier

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top