Toad World® Forums

Toad for Oracle Automation Designer extract to csv and dat files missing rows of data

Hi forum

I have urgent requirement to sort this issue out as a client came back reporting missing data. I have a query that when run directly against an oracle database in toad, it returns close to 1 million rows. I am using automation designer to extract this data to csv and data files. When I compare the result-set run from running the query directly and the csv extract, the csv extract is missing about 8 thousand rows. Is there a toad limitation of some kind to this effect? How can I resolve this?

Your help will greatly be appreciated :slight_smile:

Regards

marko

Hi Marko,
Could it be that in the meantime (when you get data in grid and when you run report), someone has deleted those records from database?
Grid should then show old data and report will have new one.
Brg
Damir

Hi Damir

Thanks for your response. No the data isnt getting changed at all. In production, this extract is ran weekly on Sundays at midday. However, adhoc run of the extract from automation designer and adhoc run of the query directly against the database still shows this anomaly.

Have we double checked the instance that Automation Designer is running under?
Not sure if you posted already, but it might help if we could see the two scripts (or the one script) LOL

and and any system info displayed across the top banner when you run the automation designer and when you run the adhoc.

Thanks

On Thu, Jul 20, 2017 at 9:09 PM, lombani bounce-lombani@toadworld.com wrote:

RE: Toad for Oracle Automation Designer extract to csv and dat files missing rows of data

Reply by lombani
Hi Damir

Thanks for your response. No the data isnt getting changed at all. In production, this extract is ran weekly on Sundays at midday. However, adhoc run of the extract from automation designer and adhoc run of the query directly against the database still shows this anomaly.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


Gene L. Bradley Jr.

Systems Analyst

Office of Information Technology

Jackson State University

1400 J R Lynch Street

P.O. Box 17750

Jackson, MS 39217

ph 601.979.1042

fax 601.371.9146

email gbradley@jsums.edu

*In God we trust; all others bring data. * ~W.E. Deming

CONFIDENTIALITY STATEMENT

This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.

Thanks Gene

There is no messages of any kind across the top banner. Just so that we are on the same page, which top banner are you referring to really? Otherwise I do not see any kinds of important messages in any banner at the top or bottom

the banner across the top of the toad window. It should read username @instancename.
That and it seems like AD is set to only test the first x rows.

On Jul 20, 2017 10:18 PM, “lombani” bounce-lombani@toadworld.com wrote:

RE: Toad for Oracle Automation Designer extract to csv and dat files missing rows of data

Reply by lombani

Thanks Gene

There is no messages of any kind across the top banner. Just so that we are on the same page, which top banner are you referring to really? Otherwise I do not see any kinds of important messages in any banner at the top or bottom

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Hi,

I work with many features from Toad, and I assure you that there is no bug in the area you are assuming.

  1. Give us exact
  • Toad version,
  • Ora client version
  • Oracle database version (maybe you are using really old and unsupported Toad version?)
  1. Windows or Oracle envs are may be different. Same db and that you have same session parameters (i.e. differnt date format may cause retriving different results)

  2. show us a sql that is retrieving data (or send to me by mail…it is easy to find mine mail)

  3. can you spool result from that query from SQL*Plus in file and recheck number of rows (outside of Toad).

Brg

Damir

Brg

Damir