Question

SQL* Loader 500, 553, 509 Error

Asked by: mdhingra

We are using Oracle 8.17 and I am trying to load data into a oracle table.  Data starts going into the table and then when a commit point reached -logical record count 13077.  There should be 13077 records in the file, but I still get the following error:

SQL* Loader 500: Unable to open file
SQL* Loader 553: File not found
SQL* Loader 509: System error: The system can not find the file specified.

When I count the record in the table, there is actually 11,564 records.

This is my command line that I am executing to load the data:
cd c:\uploads\BODint\software\
sqlldr <username>/<password>@<connection> control=bod.ctl log=c:bod.log

This is my control file:
load data
INFILE 'C:\uploads\BODInt\Data\bod.dat'
infile 'bod.dat'
badfile 'bod.bad'
discardfile 'bod.dsc'
replace
into table bodtemp
when (7) !='"'
fields terminated by ',' optionally enclosed by '"'
(bdtp_usage_code            CHAR NULLIF bdtp_usage_code= BLANKS,
bdtp_effective_date         CHAR NULLIF bdtp_effective_date= BLANKS)
into table bodtemp
when (7) ='"' and (48) !='C'  
fields terminated by ',' optionally enclosed by '"'
(bdtp_cost_cntr_ref        POSITION(2:6)   CHAR NULLIF bdtp_cost_cntr_ref= BLANKS,
bdtp_level                 POSITION(10:11)   CHAR NULLIF bdtp_level= BLANKS,
bdtp_cost_cntr_desc        POSITION(15:44)   CHAR NULLIF bdtp_cost_cntr_desc= BLANKS,
bdtp_open_closed_flag      POSITION(48:48)   CHAR NULLIF bdtp_open_closed_flag=BLANKS,
bdtp_parent_cost_cntr_ref  POSITION(52:56)   CHAR NULLIF bdtp_parent_cost_cntr_ref=BLANKS)

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2003-02-13 at 12:08:15ID20513076
Tags

file

,

open

,

unable

Topic

Databases Miscellaneous

Participating Experts
3
Points
20
Comments
5

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. using sql loader
    How can i load the data from txt files to oracle db tables uslng sql loader or any anoter simple way ?
  2. SQL LOADER
    hello friends, I have a database in oracle 8i and i have to laod some data files they have extension .cvs. I have tried using sqlldr command but it give me a protocol adapter error. This machine has both sql and oracle database so the sql loader initially goes to the sql serv...
  3. Sql loader
    Index Search Add FAQ Ask Question Oracle SQL*Loader FAQ $Date: 09-Jul-2005 $ $Revision: 1.30 $ $Author: Frank Naudé $ Topics What is SQL*Loader and what is it used for? How does one use the SQL*Loader utility? Is there a SQL*Unloader to download data to a flat ...
  4. SQL loader question.
    We have Oracle 9i. There are unix scripts which invoke the sqlplus and load the data in Oracle using the sql loader. I am concerned about the performance of this data load. The load type is conventional data load. The commit point reached after say 50 to 60 records, which i ...
  5. SQL * Loader
    Hi, Iam new to SQL * Loader. I need to populate data from CSV file to Oracle table <mytable>. CSV file has fields such as emp_id integer,date_from date/time,emp_desc varchar. In Oracle table i have the data type as integer,sysdate and varchar2(25) respectively. Thanks
  6. SQl Loader Commiting two frequently
    while loading a Data Using Sql Loader, I found that First time 12011 rows are commited and and immediatly around only 48 rows are commited. Is anybody have any idea why it is so ? My commad for sql loader and Output is as below. c:\ sqlldr hamilton/********@opprod control=...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: DonFreemanPosted on 2003-02-13 at 12:42:31ID: 7944837

Oracle 8.1.7 on what platform? Is it creating the log file? Is it actually loading anything?

 

by: mdhingraPosted on 2003-02-13 at 13:07:49ID: 7944994

Oracle 817 is running on a Win NT platform. Yes, it is  creating a log file, and yes data is being loaded howevere only 11564 of the 13077 records are going in.  In the DOS Box the commit point reaches -logical record count 13077, but he count on the table only has 11564 records.  The log file is difficult to read.

[b]This is the log file:

SQL*Loader: Release 8.1.7.0.0 - Production on Thu Feb 13 12:29:59 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Control File:   bod.ctl

There are 2 data files:
Data File:      C:\uploads\BODInt\Data\bod.dat
  Bad File:     bod.bad
  Discard File:  none specified
 
 (Allow all discards)
Data File:      bod.dat
  Bad File:     bod.bad
  Discard File: bod.dsc
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 65536 bytes
Continuation:    none specified
Path used:      Conventional

Table BODTEMP, loaded when 7:7 != 0X22(character '"')
Insert option in effect for this table: REPLACE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
BDTP_USAGE_CODE                     FIRST     *   ,  O(") CHARACTER            
    NULL if BDTP_USAGE_CODE = BLANKS
BDTP_EFFECTIVE_DATE                  NEXT     *   ,  O(") CHARACTER            
    NULL if BDTP_EFFECTIVE_DATE = BLANKS

Table BODTEMP, loaded when 7:7 = 0X22(character '"')
                  and 48:48 != 0X43(character 'C')
Insert option in effect for this table: REPLACE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
BDTP_COST_CNTR_REF                    2:6     5   ,  O(") CHARACTER            
    NULL if BDTP_COST_CNTR_REF = BLANKS
BDTP_LEVEL                          10:11     2   ,  O(") CHARACTER            
    NULL if BDTP_LEVEL = BLANKS
BDTP_COST_CNTR_DESC                 15:44    30   ,  O(") CHARACTER            
    NULL if BDTP_COST_CNTR_DESC = BLANKS
BDTP_OPEN_CLOSED_FLAG               48:48     1   ,  O(") CHARACTER            
    NULL if BDTP_OPEN_CLOSED_FLAG = BLANKS
BDTP_PARENT_COST_CNTR_REF           52:56     5   ,  O(") CHARACTER            
    NULL if BDTP_PARENT_COST_CNTR_REF = BLANKS


Data File C:\uploads\BODInt\Data\bod.dat -

Record 365: Discarded - failed all WHEN clauses.
Record 2542: Discarded - failed all WHEN clauses.
Record 3932: Discarded - failed all WHEN clauses.
Record 4077: Discarded - failed all WHEN clauses.
Record 4078: Discarded - failed all WHEN clauses.
Record 4079: Discarded - failed all WHEN clauses.
Record 4082: Discarded - failed all WHEN clauses.
Record 4084: Discarded - failed all WHEN clauses.
Record 4097: Discarded - failed all WHEN clauses.
Record 4098: Discarded - failed all WHEN clauses.
Record 4104: Discarded - failed all WHEN clauses.
Record 4111: Discarded - failed all WHEN clauses.
Record 4115: Discarded - failed all WHEN clauses.
Record 4220: Discarded - failed all WHEN clauses.
Record 4221: Discarded - failed all WHEN clauses.
Record 4337: Discarded - failed all WHEN clauses.
Record 4341: Discarded - failed all WHEN clauses.
Record 4347: Discarded - failed all WHEN clauses.
Record 4349: Discarded - failed all WHEN clauses.
Record 4350: Discarded - failed all WHEN clauses.
Record 4351: Discarded - failed all WHEN clauses.
Record 4352: Discarded - failed all WHEN clauses.
Record 4353: Discarded - failed all WHEN clauses.
Record 4355: Discarded - failed all WHEN clauses.
Record 4791: Discarded - failed all WHEN clauses.
Record 4935: Discarded - failed all WHEN clauses.
Record 4968: Discarded - failed all WHEN clauses.
Record 5000: Discarded - failed all WHEN clauses.
Record 5026: Discarded - failed all WHEN clauses.
Record 5029: Discarded - failed all WHEN clauses.
Record 5073: Discarded - failed all WHEN clauses.
Record 5076: Discarded - failed all WHEN clauses.
Record 5123: Discarded - failed all WHEN clauses.
Record 5128: Discarded - failed all WHEN clauses.
Record 5132: Discarded - failed all WHEN clauses.
Record 5135: Discarded - failed all WHEN clauses.
Record 5150: Discarded - failed all WHEN clauses.
Record 5165: Discarded - failed all WHEN clauses.
Record 5167: Discarded - failed all WHEN clauses.
Record 5284: Discarded - failed all WHEN clauses.
Record 5302: Discarded - failed all WHEN clauses.
Record 5324: Discarded - failed all WHEN clauses.
Record 5325: Discarded - failed all WHEN clauses.
Record 5326: Discarded - failed all WHEN clauses.
Record 5399: Discarded - failed all WHEN clauses.
Record 5445: Discarded - failed all WHEN clauses.
Record 5448: Discarded - failed all WHEN clauses.
Record 5449: Discarded - failed all WHEN clauses.
Record 5451: Discarded - failed all WHEN clauses.
Record 5492: Discarded - failed all WHEN clauses.
Record 5571: Discarded - failed all WHEN clauses.
Record 5574: Discarded - failed all WHEN clauses.
Record 5618: Discarded - failed all WHEN clauses.
Record 5621: Discarded - failed all WHEN clauses.
Record 5647: Discarded - failed all WHEN clauses.
Record 5648: Discarded - failed all WHEN clauses.
Record 5663: Discarded - failed all WHEN clauses.
Record 5720: Discarded - failed all WHEN clauses.
Record 5721: Discarded - failed all WHEN clauses.
Record 5757: Discarded - failed all WHEN clauses.
Record 5787: Discarded - failed all WHEN clauses.
Record 5793: Discarded - failed all WHEN clauses.
Record 5825: Discarded - failed all WHEN clauses.
Record 5841: Discarded - failed all WHEN clauses.
Record 5845: Discarded - failed all WHEN clauses.
Record 5864: Discarded - failed all WHEN clauses.
Record 5870: Discarded - failed all WHEN clauses.
Record 5876: Discarded - failed all WHEN clauses.
Record 5879: Discarded - failed all WHEN clauses.
Record 5930: Discarded - failed all WHEN clauses.
Record 5936: Discarded - failed all WHEN clauses.
Record 5943: Discarded - failed all WHEN clauses.
Record 5944: Discarded - failed all WHEN clauses.
Record 5948: Discarded - failed all WHEN clauses.
Record 5982: Discarded - failed all WHEN clauses.
Record 5992: Discarded - failed all WHEN clauses.
Record 5994: Discarded - failed all WHEN clauses.
Record 6091: Discarded - failed all WHEN clauses.
Record 6164: Discarded - failed all WHEN clauses.
Record 6196: Discarded - failed all WHEN clauses.
Record 6200: Discarded - failed all WHEN clauses.
Record 6211: Discarded - failed all WHEN clauses.
Record 6411: Discarded - failed all WHEN clauses.
Record 6438: Discarded - failed all WHEN clauses.
Record 6462: Discarded - failed all WHEN clauses.
Record 6466: Discarded - failed all WHEN clauses.
Record 6562: Discarded - failed all WHEN clauses.
Record 6578: Discarded - failed all WHEN clauses.
Record 6600: Discarded - failed all WHEN clauses.
Record 6605: Discarded - failed all WHEN clauses.
Record 6607: Discarded - failed all WHEN clauses.
Record 6636: Discarded - failed all WHEN clauses.
Record 6660: Discarded - failed all WHEN clauses.
Record 6664: Discarded - failed all WHEN clauses.
Record 6670: Discarded - failed all WHEN clauses.
Record 6678: Discarded - failed all WHEN clauses.
Record 6705: Discarded - failed all WHEN clauses.
Record 6718: Discarded - failed all WHEN clauses.
Record 6746: Discarded - failed all WHEN clauses.
Record 6838: Discarded - failed all WHEN clauses.
Record 6876: Discarded - failed all WHEN clauses.
Record 6885: Discarded - failed all WHEN clauses.
Record 6886: Discarded - failed all WHEN clauses.
Record 6899: Discarded - failed all WHEN clauses.
Record 6901: Discarded - failed all WHEN clauses.
Record 6907: Discarded - failed all WHEN clauses.
Record 6943: Discarded - failed all WHEN clauses.
Record 6945: Discarded - failed all WHEN clauses.
Record 6967: Discarded - failed all WHEN clauses.
Record 7007: Discarded - failed all WHEN clauses.
Record 7055: Discarded - failed all WHEN clauses.
Record 7063: Discarded - failed all WHEN clauses.
Record 7081: Discarded - failed all WHEN clauses.
Record 7083: Discarded - failed all WHEN clauses.
Record 7088: Discarded - failed all WHEN clauses.
Record 7093: Discarded - failed all WHEN clauses.
Record 7095: Discarded - failed all WHEN clauses.
Record 7100: Discarded - failed all WHEN clauses.
Record 7101: Discarded - failed all WHEN clauses.
Record 7126: Discarded - failed all WHEN clauses.
Record 7129: Discarded - failed all WHEN clauses.
Record 7160: Discarded - failed all WHEN clauses.
Record 7212: Discarded - failed all WHEN clauses.
Record 7250: Discarded - failed all WHEN clauses.
Record 7405: Discarded - failed all WHEN clauses.
Record 7410: Discarded - failed all WHEN clauses.
Record 7493: Discarded - failed all WHEN clauses.
Record 7508: Discarded - failed all WHEN clauses.
Record 7623: Discarded - failed all WHEN clauses.
Record 7651: Discarded - failed all WHEN clauses.
Record 7669: Discarded - failed all WHEN clauses.
Record 7671: Discarded - failed all WHEN clauses.
Record 7747: Discarded - failed all WHEN clauses.
Record 7750: Discarded - failed all WHEN clauses.
Record 7945: Discarded - failed all WHEN clauses.
Record 7954: Discarded - failed all WHEN clauses.
Record 7984: Discarded - failed all WHEN clauses.
Record 8168: Discarded - failed all WHEN clauses.
Record 8237: Discarded - failed all WHEN clauses.
Record 8245: Discarded - failed all WHEN clauses.
Record 8268: Discarded - failed all WHEN clauses.
Record 8271: Discarded - failed all WHEN clauses.
Record 8273: Discarded - failed all WHEN clauses.
Record 8279: Discarded - failed all WHEN clauses.
Record 8280: Discarded - failed all WHEN clauses.
Record 8281: Discarded - failed all WHEN clauses.
Record 8285: Discarded - failed all WHEN clauses.
Record 8289: Discarded - failed all WHEN clauses.
Record 8290: Discarded - failed all WHEN clauses.
Record 8291: Discarded - failed all WHEN clauses.
Record 8306: Discarded - failed all WHEN clauses.
Record 8317: Discarded - failed all WHEN clauses.
Record 8318: Discarded - failed all WHEN clauses.
Record 8326: Discarded - failed all WHEN clauses.
Record 8335: Discarded - failed all WHEN clauses.
Record 8337: Discarded - failed all WHEN clauses.
Record 8353: Discarded - failed all WHEN clauses.
Record 8354: Discarded - failed all WHEN clauses.
Record 8443: Discarded - failed all WHEN clauses.
Record 8444: Discarded - failed all WHEN clauses.
Record 8472: Discarded - failed all WHEN clauses.
Record 8473: Discarded - failed all WHEN clauses.
Record 8474: Discarded - failed all WHEN clauses.
Record 8475: Discarded - failed all WHEN clauses.
Record 8476: Discarded - failed all WHEN clauses.
Record 8477: Discarded - failed all WHEN clauses.
Record 8479: Discarded - failed all WHEN clauses.
Record 8481: Discarded - failed all WHEN clauses.
Record 8483: Discarded - failed all WHEN clauses.
Record 8493: Discarded - failed all WHEN clauses.
Record 8501: Discarded - failed all WHEN clauses.
Record 8503: Discarded - failed all WHEN clauses.
Record 8504: Discarded - failed all WHEN clauses.
Record 8505: Discarded - failed all WHEN clauses.
Record 8506: Discarded - failed all WHEN clauses.
Record 8507: Discarded - failed all WHEN clauses.
Record 8509: Discarded - failed all WHEN clauses.
Record 8510: Discarded - failed all WHEN clauses.
Record 8511: Discarded - failed all WHEN clauses.
Record 8512: Discarded - failed all WHEN clauses.
Record 8513: Discarded - failed all WHEN clauses.
Record 8514: Discarded - failed all WHEN clauses.
Record 8515: Discarded - failed all WHEN clauses.
Record 8518: Discarded - failed all WHEN clauses.
Record 8520: Discarded - failed all WHEN clauses.
Record 8538: Discarded - failed all WHEN clauses.
Record 8548: Discarded - failed all WHEN clauses.
Record 8549: Discarded - failed all WHEN clauses.
Record 8561: Discarded - failed all WHEN clauses.
Record 8567: Discarded - failed all WHEN clauses.
Record 8568: Discarded - failed all WHEN clauses.
Record 8574: Discarded - failed all WHEN clauses.
Record 8575: Discarded - failed all WHEN clauses.
Record 8586: Discarded - failed all WHEN clauses.
Record 8609: Discarded - failed all WHEN clauses.
Record 8610: Discarded - failed all WHEN clauses.
Record 8611: Discarded - failed all WHEN clauses.
Record 8652: Discarded - failed all WHEN clauses.
Record 8660: Discarded - failed all WHEN clauses.
Record 8665: Discarded - failed all WHEN clauses.
Record 8670: Discarded - failed all WHEN clauses.
Record 8671: Discarded - failed all WHEN clauses.
Record 8672: Discarded - failed all WHEN clauses.
Record 8676: Discarded - failed all WHEN clauses.
Record 8678: Discarded - failed all WHEN clauses.
Record 8689: Discarded - failed all WHEN clauses.
Record 8691: Discarded - failed all WHEN clauses.
Record 8696: Discarded - failed all WHEN clauses.
Record 8745: Discarded - failed all WHEN clauses.
Record 8750: Discarded - failed all WHEN clauses.
Record 8778: Discarded - failed all WHEN clauses.
Record 8779: Discarded - failed all WHEN clauses.
Record 8824: Discarded - failed all WHEN clauses.
Record 8827: Discarded - failed all WHEN clauses.
Record 8828: Discarded - failed all WHEN clauses.
Record 8831: Discarded - failed all WHEN clauses.
Record 8856: Discarded - failed all WHEN clauses.
Record 8872: Discarded - failed all WHEN clauses.
Record 8895: Discarded - failed all WHEN clauses.
Record 8917: Discarded - failed all WHEN clauses.
Record 8941: Discarded - failed all WHEN clauses.
Record 8945: Discarded - failed all WHEN clauses.
Record 8972: Discarded - failed all WHEN clauses.
Record 8973: Discarded - failed all WHEN clauses.
Record 8974: Discarded - failed all WHEN clauses.
Record 9029: Discarded - failed all WHEN clauses.
Record 9068: Discarded - failed all WHEN clauses.
Record 9086: Discarded - failed all WHEN clauses.
Record 9091: Discarded - failed all WHEN clauses.
Record 9105: Discarded - failed all WHEN clauses.
Record 9162: Discarded - failed all WHEN clauses.
Record 9165: Discarded - failed all WHEN clauses.
Record 9168: Discarded - failed all WHEN clauses.
Record 9169: Discarded - failed all WHEN clauses.
Record 9170: Discarded - failed all WHEN clauses.
Record 9171: Discarded - failed all WHEN clauses.
Record 9172: Discarded - failed all WHEN clauses.
Record 9173: Discarded - failed all WHEN clauses.
Record 9174: Discarded - failed all WHEN clauses.
Record 9175: Discarded - failed all WHEN clauses.
Record 9176: Discarded - failed all WHEN clauses.
Record 9177: Discarded - failed all WHEN clauses.
Record 9178: Discarded - failed all WHEN clauses.
Record 9179: Discarded - failed all WHEN clauses.
Record 9180: Discarded - failed all WHEN clauses.
Record 9181: Discarded - failed all WHEN clauses.
Record 9182: Discarded - failed all WHEN clauses.
Record 9183: Discarded - failed all WHEN clauses.
Record 9184: Discarded - failed all WHEN clauses.
Record 9185: Discarded - failed all WHEN clauses.
Record 9186: Discarded - failed all WHEN clauses.
Record 9187: Discarded - failed all WHEN clauses.
Record 9188: Discarded - failed all WHEN clauses.
Record 9189: Discarded - failed all WHEN clauses.
Record 9190: Discarded - failed all WHEN clauses.
Record 9191: Discarded - failed all WHEN clauses.
Record 9192: Discarded - failed all WHEN clauses.
Record 9193: Discarded - failed all WHEN clauses.
Record 9194: Discarded - failed all WHEN clauses.
Record 9195: Discarded - failed all WHEN clauses.
Record 9196: Discarded - failed all WHEN clauses.
Record 9197: Discarded - failed all WHEN clauses.
Record 9198: Discarded - failed all WHEN clauses.
Record 9199: Discarded - failed all WHEN clauses.
Record 9200: Discarded - failed all WHEN clauses.
Record 9201: Discarded - failed all WHEN clauses.
Record 9202: Discarded - failed all WHEN clauses.
Record 9203: Discarded - failed all WHEN clauses.
Record 9204: Discarded - failed all WHEN clauses.
Record 9205: Discarded - failed all WHEN clauses.
Record 9206: Discarded - failed all WHEN clauses.
Record 9207: Discarded - failed all WHEN clauses.
Record 9208: Discarded - failed all WHEN clauses.
Record 9209: Discarded - failed all WHEN clauses.
Record 9210: Discarded - failed all WHEN clauses.
Record 9212: Discarded - failed all WHEN clauses.
Record 9213: Discarded - failed all WHEN clauses.
Record 9218: Discarded - failed all WHEN clauses.
Record 9219: Discarded - failed all WHEN clauses.
Record 9223: Discarded - failed all WHEN clauses.
Record 9224: Discarded - failed all WHEN clauses.
Record 9225: Discarded - failed all WHEN clauses.
Record 9226: Discarded - failed all WHEN clauses.
Record 9227: Discarded - failed all WHEN clauses.
Record 9228: Discarded - failed all WHEN clauses.
Record 9229: Discarded - failed all WHEN clauses.
Record 9230: Discarded - failed all WHEN clauses.
Record 9231: Discarded - failed all WHEN clauses.
Record 9232: Discarded - failed all WHEN clauses.
Record 9235: Discarded - failed all WHEN clauses.
Record 9236: Discarded - failed all WHEN clauses.
Record 9237: Discarded - failed all WHEN clauses.
Record 9238: Discarded - failed all WHEN clauses.
Record 9239: Discarded - failed all WHEN clauses.
Record 9240: Discarded - failed all WHEN clauses.
Record 9241: Discarded - failed all WHEN clauses.
Record 9242: Discarded - failed all WHEN clauses.
Record 9243: Discarded - failed all WHEN clauses.
Record 9244: Discarded - failed all WHEN clauses.
Record 9245: Discarded - failed all WHEN clauses.
Record 9246: Discarded - failed all WHEN clauses.
Record 9247: Discarded - failed all WHEN clauses.
Record 9248: Discarded - failed all WHEN clauses.
Record 9249: Discarded - failed all WHEN clauses.
Record 9250: Discarded - failed all WHEN clauses.
Record 9251: Discarded - failed all WHEN clauses.
Record 9252: Discarded - failed all WHEN clauses.
Record 9253: Discarded - failed all WHEN clauses.
Record 9254: Discarded - failed all WHEN clauses.
Record 9255: Discarded - failed all WHEN clauses.
Record 9256: Discarded - failed all WHEN clauses.
Record 9257: Discarded - failed all WHEN clauses.
Record 9259: Discarded - failed all WHEN clauses.
Record 9330: Discarded - failed all WHEN clauses.
Record 9339: Discarded - failed all WHEN clauses.
Record 9340: Discarded - failed all WHEN clauses.
Record 9349: Discarded - failed all WHEN clauses.
Record 9350: Discarded - failed all WHEN clauses.
Record 9351: Discarded - failed all WHEN clauses.
Record 9352: Discarded - failed all WHEN clauses.
Record 9353: Discarded - failed all WHEN clauses.
Record 9354: Discarded - failed all WHEN clauses.
Record 9374: Discarded - failed all WHEN clauses.
Record 9378: Discarded - failed all WHEN clauses.
Record 9379: Discarded - failed all WHEN clauses.
Record 9380: Discarded - failed all WHEN clauses.
Record 9381: Discarded - failed all WHEN clauses.
Record 9382: Discarded - failed all WHEN clauses.
Record 9383: Discarded - failed all WHEN clauses.
Record 9384: Discarded - failed all WHEN clauses.
Record 9385: Discarded - failed all WHEN clauses.
Record 9386: Discarded - failed all WHEN clauses.
Record 9387: Discarded - failed all WHEN clauses.
Record 9388: Discarded - failed all WHEN clauses.
Record 9389: Discarded - failed all WHEN clauses.
Record 9390: Discarded - failed all WHEN clauses.
Record 9391: Discarded - failed all WHEN clauses.
Record 9392: Discarded - failed all WHEN clauses.
Record 9393: Discarded - failed all WHEN clauses.
Record 9394: Discarded - failed all WHEN clauses.
Record 9397: Discarded - failed all WHEN clauses.
Record 9398: Discarded - failed all WHEN clauses.
Record 9399: Discarded - failed all WHEN clauses.
Record 9400: Discarded - failed all WHEN clauses.
Record 9401: Discarded - failed all WHEN clauses.
Record 9402: Discarded - failed all WHEN clauses.
Record 9403: Discarded - failed all WHEN clauses.
Record 9404: Discarded - failed all WHEN clauses.
Record 9405: Discarded - failed all WHEN clauses.
Record 9406: Discarded - failed all WHEN clauses.
Record 9407: Discarded - failed all WHEN clauses.
Record 9408: Discarded - failed all WHEN clauses.
Record 9409: Discarded - failed all WHEN clauses.
Record 9410: Discarded - failed all WHEN clauses.
Record 9411: Discarded - failed all WHEN clauses.
Record 9412: Discarded - failed all WHEN clauses.
Record 9413: Discarded - failed all WHEN clauses.
Record 9414: Discarded - failed all WHEN clauses.
Record 9415: Discarded - failed all WHEN clauses.
Record 9416: Discarded - failed all WHEN clauses.
Record 9417: Discarded - failed all WHEN clauses.
Record 9418: Discarded - failed all WHEN clauses.
Record 9419: Discarded - failed all WHEN clauses.
Record 9420: Discarded - failed all WHEN clauses.
Record 9421: Discarded - failed all WHEN clauses.
Record 9422: Discarded - failed all WHEN clauses.
Record 9423: Discarded - failed all WHEN clauses.
Record 9424: Discarded - failed all WHEN clauses.
Record 9425: Discarded - failed all WHEN clauses.
Record 9426: Discarded - failed all WHEN clauses.
Record 9427: Discarded - failed all WHEN clauses.
Record 9428: Discarded - failed all WHEN clauses.
Record 9429: Discarded - failed all WHEN clauses.
Record 9430: Discarded - failed all WHEN clauses.
Record 9431: Discarded - failed all WHEN clauses.
Record 9432: Discarded - failed all WHEN clauses.
Record 9433: Discarded - failed all WHEN clauses.
Record 9434: Discarded - failed all WHEN clauses.
Record 9435: Discarded - failed all WHEN clauses.
Record 9437: Discarded - failed all WHEN clauses.
Record 9462: Discarded - failed all WHEN clauses.
Record 9463: Discarded - failed all WHEN clauses.
Record 9466: Discarded - failed all WHEN clauses.
Record 9478: Discarded - failed all WHEN clauses.
Record 9479: Discarded - failed all WHEN clauses.
Record 9480: Discarded - failed all WHEN clauses.
Record 9483: Discarded - failed all WHEN clauses.
Record 9484: Discarded - failed all WHEN clauses.
Record 9485: Discarded - failed all WHEN clauses.
Record 9486: Discarded - failed all WHEN clauses.
Record 9487: Discarded - failed all WHEN clauses.
Record 9488: Discarded - failed all WHEN clauses.
Record 9489: Discarded - failed all WHEN clauses.
Record 9490: Discarded - failed all WHEN clauses.
Record 9491: Discarded - failed all WHEN clauses.
Record 9495: Discarded - failed all WHEN clauses.
Record 9496: Discarded - failed all WHEN clauses.
Record 9497: Discarded - failed all WHEN clauses.
Record 9498: Discarded - failed all WHEN clauses.
Record 9500: Discarded - failed all WHEN clauses.
Record 9501: Discarded - failed all WHEN clauses.
Record 9502: Discarded - failed all WHEN clauses.
Record 9521: Discarded - failed all WHEN clauses.
Record 9574: Discarded - failed all WHEN clauses.
Record 9576: Discarded - failed all WHEN clauses.
Record 9578: Discarded - failed all WHEN clauses.
Record 9580: Discarded - failed all WHEN clauses.
Record 9581: Discarded - failed all WHEN clauses.
Record 9582: Discarded - failed all WHEN clauses.
Record 9586: Discarded - failed all WHEN clauses.
Record 9588: Discarded - failed all WHEN clauses.
Record 9596: Discarded - failed all WHEN clauses.
Record 9610: Discarded - failed all WHEN clauses.
Record 9611: Discarded - failed all WHEN clauses.
Record 9612: Discarded - failed all WHEN clauses.
Record 9613: Discarded - failed all WHEN clauses.
Record 9614: Discarded - failed all WHEN clauses.
Record 9618: Discarded - failed all WHEN clauses.
Record 9619: Discarded - failed all WHEN clauses.
Record 9623: Discarded - failed all WHEN clauses.
Record 9626: Discarded - failed all WHEN clauses.
Record 9630: Discarded - failed all WHEN clauses.
Record 9633: Discarded - failed all WHEN clauses.
Record 9634: Discarded - failed all WHEN clauses.
Record 9635: Discarded - failed all WHEN clauses.
Record 9637: Discarded - failed all WHEN clauses.
Record 9642: Discarded - failed all WHEN clauses.
Record 9644: Discarded - failed all WHEN clauses.
Record 9645: Discarded - failed all WHEN clauses.
Record 9647: Discarded - failed all WHEN clauses.
Record 9649: Discarded - failed all WHEN clauses.
Record 9651: Discarded - failed all WHEN clauses.
Record 9652: Discarded - failed all WHEN clauses.
Record 9654: Discarded - failed all WHEN clauses.
Record 9662: Discarded - failed all WHEN clauses.
Record 9666: Discarded - failed all WHEN clauses.
Record 9668: Discarded - failed all WHEN clauses.
Record 9669: Discarded - failed all WHEN clauses.
Record 9670: Discarded - failed all WHEN clauses.
Record 9671: Discarded - failed all WHEN clauses.
Record 9672: Discarded - failed all WHEN clauses.
Record 9675: Discarded - failed all WHEN clauses.
Record 9678: Discarded - failed all WHEN clauses.
Record 9679: Discarded - failed all WHEN clauses.
Record 9688: Discarded - failed all WHEN clauses.
Record 9691: Discarded - failed all WHEN clauses.
Record 9692: Discarded - failed all WHEN clauses.
Record 9693: Discarded - failed all WHEN clauses.
Record 9694: Discarded - failed all WHEN clauses.
Record 9695: Discarded - failed all WHEN clauses.
Record 9698: Discarded - failed all WHEN clauses.
Record 9704: Discarded - failed all WHEN clauses.
Record 9707: Discarded - failed all WHEN clauses.
Record 9721: Discarded - failed all WHEN clauses.
Record 9723: Discarded - failed all WHEN clauses.
Record 9726: Discarded - failed all WHEN clauses.
Record 9727: Discarded - failed all WHEN clauses.
Record 9728: Discarded - failed all WHEN clauses.
Record 9729: Discarded - failed all WHEN clauses.
Record 9730: Discarded - failed all WHEN clauses.
Record 9733: Discarded - failed all WHEN clauses.
Record 9735: Discarded - failed all WHEN clauses.
Record 9736: Discarded - failed all WHEN clauses.
Record 9737: Discarded - failed all WHEN clauses.
Record 9739: Discarded - failed all WHEN clauses.
Record 9740: Discarded - failed all WHEN clauses.
Record 9745: Discarded - failed all WHEN clauses.
Record 9746: Discarded - failed all WHEN clauses.
Record 9748: Discarded - failed all WHEN clauses.
Record 9749: Discarded - failed all WHEN clauses.
Record 9750: Discarded - failed all WHEN clauses.
Record 9751: Discarded - failed all WHEN clauses.
Record 9752: Discarded - failed all WHEN clauses.
Record 9753: Discarded - failed all WHEN clauses.
Record 9755: Discarded - failed all WHEN clauses.
Record 9759: Discarded - failed all WHEN clauses.
Record 9760: Discarded - failed all WHEN clauses.
Record 9763: Discarded - failed all WHEN clauses.
Record 9764: Discarded - failed all WHEN clauses.
Record 9770: Discarded - failed all WHEN clauses.
Record 9776: Discarded - failed all WHEN clauses.
Record 9780: Discarded - failed all WHEN clauses.
Record 9783: Discarded - failed all WHEN clauses.
Record 9785: Discarded - failed all WHEN clauses.
Record 9788: Discarded - failed all WHEN clauses.
Record 9789: Discarded - failed all WHEN clauses.
Record 9792: Discarded - failed all WHEN clauses.
Record 9794: Discarded - failed all WHEN clauses.
Record 9795: Discarded - failed all WHEN clauses.
Record 9796: Discarded - failed all WHEN clauses.
Record 9797: Discarded - failed all WHEN clauses.
Record 9798: Discarded - failed all WHEN clauses.
Record 9799: Discarded - failed all WHEN clauses.
Record 9800: Discarded - failed all WHEN clauses.
Record 9801: Discarded - failed all WHEN clauses.
Record 9804: Discarded - failed all WHEN clauses.
Record 9805: Discarded - failed all WHEN clauses.
Record 9807: Discarded - failed all WHEN clauses.
Record 9809: Discarded - failed all WHEN clauses.
Record 9811: Discarded - failed all WHEN clauses.
Record 9812: Discarded - failed all WHEN clauses.
Record 9814: Discarded - failed all WHEN clauses.
Record 9816: Discarded - failed all WHEN clauses.
Record 9820: Discarded - failed all WHEN clauses.
Record 9821: Discarded - failed all WHEN clauses.
Record 9822: Discarded - failed all WHEN clauses.
Record 9823: Discarded - failed all WHEN clauses.
Record 9824: Discarded - failed all WHEN clauses.
Record 9828: Discarded - failed all WHEN clauses.
Record 9829: Discarded - failed all WHEN clauses.
Record 9832: Discarded - failed all WHEN clauses.
Record 9833: Discarded - failed all WHEN clauses.
Record 9834: Discarded - failed all WHEN clauses.
Record 9835: Discarded - failed all WHEN clauses.
Record 9836: Discarded - failed all WHEN clauses.
Record 9837: Discarded - failed all WHEN clauses.
Record 9838: Discarded - failed all WHEN clauses.
Record 9839: Discarded - failed all WHEN clauses.
Record 9840: Discarded - failed all WHEN clauses.
Record 9841: Discarded - failed all WHEN clauses.
Record 9842: Discarded - failed all WHEN clauses.
Record 9843: Discarded - failed all WHEN clauses.
Record 9844: Discarded - failed all WHEN clauses.
Record 9845: Discarded - failed all WHEN clauses.
Record 9846: Discarded - failed all WHEN clauses.
Record 9848: Discarded - failed all WHEN clauses.
Record 9853: Discarded - failed all WHEN clauses.
Record 9854: Discarded - failed all WHEN clauses.
Record 9855: Discarded - failed all WHEN clauses.
Record 9856: Discarded - failed all WHEN clauses.
Record 9857: Discarded - failed all WHEN clauses.
Record 9863: Discarded - failed all WHEN clauses.
Record 9864: Discarded - failed all WHEN clauses.
Record 9865: Discarded - failed all WHEN clauses.
Record 9867: Discarded - failed all WHEN clauses.
Record 9870: Discarded - failed all WHEN clauses.
Record 9871: Discarded - failed all WHEN clauses.
Record 9876: Discarded - failed all WHEN clauses.
Record 9878: Discarded - failed all WHEN clauses.
Record 9888: Discarded - failed all WHEN clauses.
Record 9889: Discarded - failed all WHEN clauses.
Record 9890: Discarded - failed all WHEN clauses.
Record 9891: Discarded - failed all WHEN clauses.
Record 9893: Discarded - failed all WHEN clauses.
Record 9895: Discarded - failed all WHEN clauses.
Record 9896: Discarded - failed all WHEN clauses.
Record 9899: Discarded - failed all WHEN clauses.
Record 9900: Discarded - failed all WHEN clauses.
Record 9903: Discarded - failed all WHEN clauses.
Record 9904: Discarded - failed all WHEN clauses.
Record 9905: Discarded - failed all WHEN clauses.
Record 9907: Discarded - failed all WHEN clauses.
Record 9909: Discarded - failed all WHEN clauses.
Record 9911: Discarded - failed all WHEN clauses.
Record 9914: Discarded - failed all WHEN clauses.
Record 9915: Discarded - failed all WHEN clauses.
Record 9917: Discarded - failed all WHEN clauses.
Record 9919: Discarded - failed all WHEN clauses.
Record 9920: Discarded - failed all WHEN clauses.
Record 9922: Discarded - failed all WHEN clauses.
Record 9924: Discarded - failed all WHEN clauses.
Record 9925: Discarded - failed all WHEN clauses.
Record 9927: Discarded - failed all WHEN clauses.
Record 9930: Discarded - failed all WHEN clauses.
Record 9931: Discarded - failed all WHEN clauses.
Record 9932: Discarded - failed all WHEN clauses.
Record 9936: Discarded - failed all WHEN clauses.
Record 9937: Discarded - failed all WHEN clauses.
Record 9938: Discarded - failed all WHEN clauses.
Record 9946: Discarded - failed all WHEN clauses.
Record 9947: Discarded - failed all WHEN clauses.
Record 9948: Discarded - failed all WHEN clauses.
Record 9949: Discarded - failed all WHEN clauses.
Record 9952: Discarded - failed all WHEN clauses.
Record 9954: Discarded - failed all WHEN clauses.
Record 9955: Discarded - failed all WHEN clauses.
Record 9956: Discarded - failed all WHEN clauses.
Record 9958: Discarded - failed all WHEN clauses.
Record 9959: Discarded - failed all WHEN clauses.
Record 9960: Discarded - failed all WHEN clauses.
Record 9963: Discarded - failed all WHEN clauses.
Record 9966: Discarded - failed all WHEN clauses.
Record 9968: Discarded - failed all WHEN clauses.
Record 9969: Discarded - failed all WHEN clauses.
Record 9970: Discarded - failed all WHEN clauses.
Record 9971: Discarded - failed all WHEN clauses.
Record 9972: Discarded - failed all WHEN clauses.
Record 9975: Discarded - failed all WHEN clauses.
Record 9976: Discarded - failed all WHEN clauses.
Record 9977: Discarded - failed all WHEN clauses.
Record 9978: Discarded - failed all WHEN clauses.
Record 9979: Discarded - failed all WHEN clauses.
Record 9980: Discarded - failed all WHEN clauses.
Record 9981: Discarded - failed all WHEN clauses.
Record 9982: Discarded - failed all WHEN clauses.
Record 9984: Discarded - failed all WHEN clauses.
Record 9985: Discarded - failed all WHEN clauses.
Record 9986: Discarded - failed all WHEN clauses.
Record 9987: Discarded - failed all WHEN clauses.
Record 9988: Discarded - failed all WHEN clauses.
Record 9989: Discarded - failed all WHEN clauses.
Record 9990: Discarded - failed all WHEN clauses.
Record 9991: Discarded - failed all WHEN clauses.
Record 9992: Discarded - failed all WHEN clauses.
Record 9993: Discarded - failed all WHEN clauses.
Record 9995: Discarded - failed all WHEN clauses.
Record 9997: Discarded - failed all WHEN clauses.
Record 9998: Discarded - failed all WHEN clauses.
Record 9999: Discarded - failed all WHEN clauses.
Record 10000: Discarded - failed all WHEN clauses.
Record 10001: Discarded - failed all WHEN clauses.
Record 10002: Discarded - failed all WHEN clauses.
Record 10004: Discarded - failed all WHEN clauses.
Record 10005: Discarded - failed all WHEN clauses.
Record 10006: Discarded - failed all WHEN clauses.
Record 10007: Discarded - failed all WHEN clauses.
Record 10008: Discarded - failed all WHEN clauses.
Record 10009: Discarded - failed all WHEN clauses.
Record 10010: Discarded - failed all WHEN clauses.
Record 10011: Discarded - failed all WHEN clauses.
Record 10012: Discarded - failed all WHEN clauses.
Record 10013: Discarded - failed all WHEN clauses.
Record 10014: Discarded - failed all WHEN clauses.
Record 10015: Discarded - failed all WHEN clauses.
Record 10016: Discarded - failed all WHEN clauses.
Record 10017: Discarded - failed all WHEN clauses.
Record 10018: Discarded - failed all WHEN clauses.
Record 10019: Discarded - failed all WHEN clauses.
Record 10020: Discarded - failed all WHEN clauses.
Record 10021: Discarded - failed all WHEN clauses.
Record 10022: Discarded - failed all WHEN clauses.
Record 10023: Discarded - failed all WHEN clauses.
Record 10024: Discarded - failed all WHEN clauses.
Record 10025: Discarded - failed all WHEN clauses.
Record 10026: Discarded - failed all WHEN clauses.
Record 10027: Discarded - failed all WHEN clauses.
Record 10028: Discarded - failed all WHEN clauses.
Record 10029: Discarded - failed all WHEN clauses.
Record 10031: Discarded - failed all WHEN clauses.
Record 10032: Discarded - failed all WHEN clauses.
Record 10033: Discarded - failed all WHEN clauses.
Record 10034: Discarded - failed all WHEN clauses.
Record 10035: Discarded - failed all WHEN clauses.
Record 10036: Discarded - failed all WHEN clauses.
Record 10037: Discarded - failed all WHEN clauses.
Record 10038: Discarded - failed all WHEN clauses.
Record 10039: Discarded - failed all WHEN clauses.
Record 10040: Discarded - failed all WHEN clauses.
Record 10041: Discarded - failed all WHEN clauses.
Record 10042: Discarded - failed all WHEN clauses.
Record 10044: Discarded - failed all WHEN clauses.
Record 10045: Discarded - failed all WHEN clauses.
Record 10046: Discarded - failed all WHEN clauses.
Record 10047: Discarded - failed all WHEN clauses.
Record 10049: Discarded - failed all WHEN clauses.
Record 10053: Discarded - failed all WHEN clauses.
Record 10054: Discarded - failed all WHEN clauses.
Record 10056: Discarded - failed all WHEN clauses.
Record 10057: Discarded - failed all WHEN clauses.
Record 10059: Discarded - failed all WHEN clauses.
Record 10061: Discarded - failed all WHEN clauses.
Record 10062: Discarded - failed all WHEN clauses.
Record 10063: Discarded - failed all WHEN clauses.
Record 10064: Discarded - failed all WHEN clauses.
Record 10066: Discarded - failed all WHEN clauses.
Record 10067: Discarded - failed all WHEN clauses.
Record 10068: Discarded - failed all WHEN clauses.
Record 10069: Discarded - failed all WHEN clauses.
Record 10070: Discarded - failed all WHEN clauses.
Record 10071: Discarded - failed all WHEN clauses.
Record 10072: Discarded - failed all WHEN clauses.
Record 10073: Discarded - failed all WHEN clauses.
Record 10074: Discarded - failed all WHEN clauses.
Record 10075: Discarded - failed all WHEN clauses.
Record 10076: Discarded - failed all WHEN clauses.
Record 10078: Discarded - failed all WHEN clauses.
Record 10098: Discarded - failed all WHEN clauses.
Record 10099: Discarded - failed all WHEN clauses.
Record 10102: Discarded - failed all WHEN clauses.
Record 10103: Discarded - failed all WHEN clauses.
Record 10104: Discarded - failed all WHEN clauses.
Record 10105: Discarded - failed all WHEN clauses.
Record 10106: Discarded - failed all WHEN clauses.
Record 10107: Discarded - failed all WHEN clauses.
Record 10108: Discarded - failed all WHEN clauses.
Record 10109: Discarded - failed all WHEN clauses.
Record 10110: Discarded - failed all WHEN clauses.
Record 10111: Discarded - failed all WHEN clauses.
Record 10112: Discarded - failed all WHEN clauses.
Record 10113: Discarded - failed all WHEN clauses.
Record 10114: Discarded - failed all WHEN clauses.
Record 10115: Discarded - failed all WHEN clauses.
Record 10116: Discarded - failed all WHEN clauses.
Record 10117: Discarded - failed all WHEN clauses.
Record 10118: Discarded - failed all WHEN clauses.
Record 10119: Discarded - failed all WHEN clauses.
Record 10120: Discarded - failed all WHEN clauses.
Record 10121: Discarded - failed all WHEN clauses.
Record 10122: Discarded - failed all WHEN clauses.
Record 10123: Discarded - failed all WHEN clauses.
Record 10124: Discarded - failed all WHEN clauses.
Record 10125: Discarded - failed all WHEN clauses.
Record 10126: Discarded - failed all WHEN clauses.
Record 10128: Discarded - failed all WHEN clauses.
Record 10129: Discarded - failed all WHEN clauses.
Record 10130: Discarded - failed all WHEN clauses.
Record 10132: Discarded - failed all WHEN clauses.
Record 10136: Discarded - failed all WHEN clauses.
Record 10138: Discarded - failed all WHEN clauses.
Record 10139: Discarded - failed all WHEN clauses.
Record 10140: Discarded - failed all WHEN clauses.
Record 10141: Discarded - failed all WHEN clauses.
Record 10142: Discarded - failed all WHEN clauses.
Record 10143: Discarded - failed all WHEN clauses.
Record 10144: Discarded - failed all WHEN clauses.
Record 10146: Discarded - failed all WHEN clauses.
Record 10147: Discarded - failed all WHEN clauses.
Record 10148: Discarded - failed all WHEN clauses.
Record 10149: Discarded - failed all WHEN clauses.
Record 10150: Discarded - failed all WHEN clauses.
Record 10151: Discarded - failed all WHEN clauses.
Record 10152: Discarded - failed all WHEN clauses.
Record 10154: Discarded - failed all WHEN clauses.
Record 10157: Discarded - failed all WHEN clauses.
Record 10158: Discarded - failed all WHEN clauses.
Record 10159: Discarded - failed all WHEN clauses.
Record 10161: Discarded - failed all WHEN clauses.
Record 10162: Discarded - failed all WHEN clauses.
Record 10163: Discarded - failed all WHEN clauses.
Record 10164: Discarded - failed all WHEN clauses.
Record 10165: Discarded - failed all WHEN clauses.
Record 10166: Discarded - failed all WHEN clauses.
Record 10168: Discarded - failed all WHEN clauses.
Record 10169: Discarded - failed all WHEN clauses.
Record 10171: Discarded - failed all WHEN clauses.
Record 10172: Discarded - failed all WHEN clauses.
Record 10173: Discarded - failed all WHEN clauses.
Record 10174: Discarded - failed all WHEN clauses.
Record 10175: Discarded - failed all WHEN clauses.
Record 10177: Discarded - failed all WHEN clauses.
Record 10178: Discarded - failed all WHEN clauses.
Record 10179: Discarded - failed all WHEN clauses.
Record 10180: Discarded - failed all WHEN clauses.
Record 10181: Discarded - failed all WHEN clauses.
Record 10182: Discarded - failed all WHEN clauses.
Record 10183: Discarded - failed all WHEN clauses.
Record 10184: Discarded - failed all WHEN clauses.
Record 10186: Discarded - failed all WHEN clauses.
Record 10187: Discarded - failed all WHEN clauses.
Record 10188: Discarded - failed all WHEN clauses.
Record 10189: Discarded - failed all WHEN clauses.
Record 10190: Discarded - failed all WHEN clauses.
Record 10191: Discarded - failed all WHEN clauses.
Record 10192: Discarded - failed all WHEN clauses.
Record 10193: Discarded - failed all WHEN clauses.
Record 10194: Discarded - failed all WHEN clauses.
Record 10195: Discarded - failed all WHEN clauses.
Record 10196: Discarded - failed all WHEN clauses.
Record 10197: Discarded - failed all WHEN clauses.
Record 10198: Discarded - failed all WHEN clauses.
Record 10199: Discarded - failed all WHEN clauses.
Record 10200: Discarded - failed all WHEN clauses.
Record 10201: Discarded - failed all WHEN clauses.
Record 10202: Discarded - failed all WHEN clauses.
Record 10203: Discarded - failed all WHEN clauses.
Record 10204: Discarded - failed all WHEN clauses.
Record 10205: Discarded - failed all WHEN clauses.
Record 10206: Discarded - failed all WHEN clauses.
Record 10207: Discarded - failed all WHEN clauses.
Record 10208: Discarded - failed all WHEN clauses.
Record 10210: Discarded - failed all WHEN clauses.
Record 10211: Discarded - failed all WHEN clauses.
Record 10212: Discarded - failed all WHEN clauses.
Record 10215: Discarded - failed all WHEN clauses.
Record 10216: Discarded - failed all WHEN clauses.
Record 10218: Discarded - failed all WHEN clauses.
Record 10219: Discarded - failed all WHEN clauses.
Record 10220: Discarded - failed all WHEN clauses.
Record 10223: Discarded - failed all WHEN clauses.
Record 10224: Discarded - failed all WHEN clauses.
Record 10225: Discarded - failed all WHEN clauses.
Record 10226: Discarded - failed all WHEN clauses.
Record 10230: Discarded - failed all WHEN clauses.
Record 10232: Discarded - failed all WHEN clauses.
Record 10240: Discarded - failed all WHEN clauses.
Record 10241: Discarded - failed all WHEN clauses.
Record 10242: Discarded - failed all WHEN clauses.
Record 10243: Discarded - failed all WHEN clauses.
Record 10245: Discarded - failed all WHEN clauses.
Record 10246: Discarded - failed all WHEN clauses.
Record 10248: Discarded - failed all WHEN clauses.
Record 10254: Discarded - failed all WHEN clauses.
Record 10255: Discarded - failed all WHEN clauses.
Record 10258: Discarded - failed all WHEN clauses.
Record 10262: Discarded - failed all WHEN clauses.
Record 10263: Discarded - failed all WHEN clauses.
Record 10264: Discarded - failed all WHEN clauses.
Record 10265: Discarded - failed all WHEN clauses.
Record 10266: Discarded - failed all WHEN clauses.
Record 10267: Discarded - failed all WHEN clauses.
Record 10268: Discarded - failed all WHEN clauses.
Record 10269: Discarded - failed all WHEN clauses.
Record 10270: Discarded - failed all WHEN clauses.
Record 10271: Discarded - failed all WHEN clauses.
Record 10272: Discarded - failed all WHEN clauses.
Record 10273: Discarded - failed all WHEN clauses.
Record 10274: Discarded - failed all WHEN clauses.
Record 10275: Discarded - failed all WHEN clauses.
Record 10276: Discarded - failed all WHEN clauses.
Record 10277: Discarded - failed all WHEN clauses.
Record 10278: Discarded - failed all WHEN clauses.
Record 10279: Discarded - failed all WHEN clauses.
Record 10280: Discarded - failed all WHEN clauses.
Record 10281: Discarded - failed all WHEN clauses.
Record 10282: Discarded - failed all WHEN clauses.
Record 10283: Discarded - failed all WHEN clauses.
Record 10284: Discarded - failed all WHEN clauses.
Record 10285: Discarded - failed all WHEN clauses.
Record 10286: Discarded - failed all WHEN clauses.
Record 10287: Discarded - failed all WHEN clauses.
Record 10288: Discarded - failed all WHEN clauses.
Record 10289: Discarded - failed all WHEN clauses.
Record 10290: Discarded - failed all WHEN clauses.
Record 10291: Discarded - failed all WHEN clauses.
Record 10292: Discarded - failed all WHEN clauses.
Record 10293: Discarded - failed all WHEN clauses.
Record 10294: Discarded - failed all WHEN clauses.
Record 10295: Discarded - failed all WHEN clauses.
Record 10296: Discarded - failed all WHEN clauses.
Record 10297: Discarded - failed all WHEN clauses.
Record 10300: Discarded - failed all WHEN clauses.
Record 10303: Discarded - failed all WHEN clauses.
Record 10306: Discarded - failed all WHEN clauses.
Record 10307: Discarded - failed all WHEN clauses.
Record 10308: Discarded - failed all WHEN clauses.
Record 10309: Discarded - failed all WHEN clauses.
Record 10310: Discarded - failed all WHEN clauses.
Record 10311: Discarded - failed all WHEN clauses.
Record 10313: Discarded - failed all WHEN clauses.
Record 10316: Discarded - failed all WHEN clauses.
Record 10317: Discarded - failed all WHEN clauses.
Record 10318: Discarded - failed all WHEN clauses.
Record 10319: Discarded - failed all WHEN clauses.
Record 10321: Discarded - failed all WHEN clauses.
Record 10324: Discarded - failed all WHEN clauses.
Record 10325: Discarded - failed all WHEN clauses.
Record 10326: Discarded - failed all WHEN clauses.
Record 10327: Discarded - failed all WHEN clauses.
Record 10328: Discarded - failed all WHEN clauses.
Record 10331: Discarded - failed all WHEN clauses.
Record 10332: Discarded - failed all WHEN clauses.
Record 10333: Discarded - failed all WHEN clauses.
Record 10334: Discarded - failed all WHEN clauses.
Record 10335: Discarded - failed all WHEN clauses.
Record 10336: Discarded - failed all WHEN clauses.
Record 10339: Discarded - failed all WHEN clauses.
Record 10340: Discarded - failed all WHEN clauses.
Record 10341: Discarded - failed all WHEN clauses.
Record 10342: Discarded - failed all WHEN clauses.
Record 10343: Discarded - failed all WHEN clauses.
Record 10344: Discarded - failed all WHEN clauses.
Record 10345: Discarded - failed all WHEN clauses.
Record 10348: Discarded - failed all WHEN clauses.
Record 10349: Discarded - failed all WHEN clauses.
Record 10352: Discarded - failed all WHEN clauses.
Record 10354: Discarded - failed all WHEN clauses.
Record 10355: Discarded - failed all WHEN clauses.
Record 10356: Discarded - failed all WHEN clauses.
Record 10357: Discarded - failed all WHEN clauses.
Record 10358: Discarded - failed all WHEN clauses.
Record 10359: Discarded - failed all WHEN clauses.
Record 10360: Discarded - failed all WHEN clauses.
Record 10361: Discarded - failed all WHEN clauses.
Record 10362: Discarded - failed all WHEN clauses.
Record 10363: Discarded - failed all WHEN clauses.
Record 10365: Discarded - failed all WHEN clauses.
Record 10366: Discarded - failed all WHEN clauses.
Record 10367: Discarded - failed all WHEN clauses.
Record 10368: Discarded - failed all WHEN clauses.
Record 10372: Discarded - failed all WHEN clauses.
Record 10375: Discarded - failed all WHEN clauses.
Record 10379: Discarded - failed all WHEN clauses.
Record 10381: Discarded - failed all WHEN clauses.
Record 10389: Discarded - failed all WHEN clauses.
Record 10390: Discarded - failed all WHEN clauses.
Record 10393: Discarded - failed all WHEN clauses.
Record 10396: Discarded - failed all WHEN clauses.
Record 10397: Discarded - failed all WHEN clauses.
Record 10400: Discarded - failed all WHEN clauses.
Record 10405: Discarded - failed all WHEN clauses.
Record 10406: Discarded - failed all WHEN clauses.
Record 10414: Discarded - failed all WHEN clauses.
Record 10415: Discarded - failed all WHEN clauses.
Record 10430: Discarded - failed all WHEN clauses.
Record 10435: Discarded - failed all WHEN clauses.
Record 10437: Discarded - failed all WHEN clauses.
Record 10439: Discarded - failed all WHEN clauses.
Record 10440: Discarded - failed all WHEN clauses.
Record 10446: Discarded - failed all WHEN clauses.
Record 10448: Discarded - failed all WHEN clauses.
Record 10449: Discarded - failed all WHEN clauses.
Record 10450: Discarded - failed all WHEN clauses.
Record 10451: Discarded - failed all WHEN clauses.
Record 10452: Discarded - failed all WHEN clauses.
Record 10453: Discarded - failed all WHEN clauses.
Record 10455: Discarded - failed all WHEN clauses.
Record 10475: Discarded - failed all WHEN clauses.
Record 10606: Discarded - failed all WHEN clauses.
Record 10616: Discarded - failed all WHEN clauses.
Record 10617: Discarded - failed all WHEN clauses.
Record 10622: Discarded - failed all WHEN clauses.
Record 10635: Discarded - failed all WHEN clauses.
Record 10636: Discarded - failed all WHEN clauses.
Record 10637: Discarded - failed all WHEN clauses.
Record 10638: Discarded - failed all WHEN clauses.
Record 10639: Discarded - failed all WHEN clauses.
Record 10640: Discarded - failed all WHEN clauses.
Record 10641: Discarded - failed all WHEN clauses.
Record 10643: Discarded - failed all WHEN clauses.
Record 10649: Discarded - failed all WHEN clauses.
Record 10650: Discarded - failed all WHEN clauses.
Record 10652: Discarded - failed all WHEN clauses.
Record 10653: Discarded - failed all WHEN clauses.
Record 10654: Discarded - failed all WHEN clauses.
Record 10665: Discarded - failed all WHEN clauses.
Record 10667: Discarded - failed all WHEN clauses.
Record 10670: Discarded - failed all WHEN clauses.
Record 10674: Discarded - failed all WHEN clauses.
Record 10679: Discarded - failed all WHEN clauses.
Record 10681: Discarded - failed all WHEN clauses.
Record 10689: Discarded - failed all WHEN clauses.
Record 10703: Discarded - failed all WHEN clauses.
Record 10704: Discarded - failed all WHEN clauses.
Record 10705: Discarded - failed all WHEN clauses.
Record 10706: Discarded - failed all WHEN clauses.
Record 10707: Discarded - failed all WHEN clauses.
Record 10708: Discarded - failed all WHEN clauses.
Record 10709: Discarded - failed all WHEN clauses.
Record 10711: Discarded - failed all WHEN clauses.
Record 10712: Discarded - failed all WHEN clauses.
Record 10713: Discarded - failed all WHEN clauses.
Record 10714: Discarded - failed all WHEN clauses.
Record 10715: Discarded - failed all WHEN clauses.
Record 10716: Discarded - failed all WHEN clauses.
Record 10717: Discarded - failed all WHEN clauses.
Record 10718: Discarded - failed all WHEN clauses.
Record 10720: Discarded - failed all WHEN clauses.
Record 10721: Discarded - failed all WHEN clauses.
Record 10722: Discarded - failed all WHEN clauses.
Record 10723: Discarded - failed all WHEN clauses.
Record 10724: Discarded - failed all WHEN clauses.
Record 10725: Discarded - failed all WHEN clauses.
Record 10726: Discarded - failed all WHEN clauses.
Record 10727: Discarded - failed all WHEN clauses.
Record 10728: Discarded - failed all WHEN clauses.
Record 10731: Discarded - failed all WHEN clauses.
Record 10732: Discarded - failed all WHEN clauses.
Record 10733: Discarded - failed all WHEN clauses.
Record 10734: Discarded - failed all WHEN clauses.
Record 10735: Discarded - failed all WHEN clauses.
Record 10736: Discarded - failed all WHEN clauses.
Record 10737: Discarded - failed all WHEN clauses.
Record 10738: Discarded - failed all WHEN clauses.
Record 10739: Discarded - failed all WHEN clauses.
Record 10740: Discarded - failed all WHEN clauses.
Record 10743: Discarded - failed all WHEN clauses.
Record 10744: Discarded - failed all WHEN clauses.
Record 10751: Discarded - failed all WHEN clauses.
Record 10752: Discarded - failed all WHEN clauses.
Record 10753: Discarded - failed all WHEN clauses.
Record 10754: Discarded - failed all WHEN clauses.
Record 10755: Discarded - failed all WHEN clauses.
Record 10756: Discarded - failed all WHEN clauses.
Record 10757: Discarded - failed all WHEN clauses.
Record 10759: Discarded - failed all WHEN clauses.
Record 10760: Discarded - failed all WHEN clauses.
Record 10762: Discarded - failed all WHEN clauses.
Record 10775: Discarded - failed all WHEN clauses.
Record 10778: Discarded - failed all WHEN clauses.
Record 10791: Discarded - failed all WHEN clauses.
Record 10800: Discarded - failed all WHEN clauses.
Record 10801: Discarded - failed all WHEN clauses.
Record 10812: Discarded - failed all WHEN clauses.
Record 10813: Discarded - failed all WHEN clauses.
Record 10843: Discarded - failed all WHEN clauses.
Record 10844: Discarded - failed all WHEN clauses.
Record 10855: Discarded - failed all WHEN clauses.
Record 10875: Discarded - failed all WHEN clauses.
Record 10876: Discarded - failed all WHEN clauses.
Record 10879: Discarded - failed all WHEN clauses.
Record 10881: Discarded - failed all WHEN clauses.
Record 10884: Discarded - failed all WHEN clauses.
Record 10885: Discarded - failed all WHEN clauses.
Record 10886: Discarded - failed all WHEN clauses.
Record 10887: Discarded - failed all WHEN clauses.
Record 10898: Discarded - failed all WHEN clauses.
Record 10902: Discarded - failed all WHEN clauses.
Record 10907: Discarded - failed all WHEN clauses.
Record 10908: Discarded - failed all WHEN clauses.
Record 10909: Discarded - failed all WHEN clauses.
Record 10914: Discarded - failed all WHEN clauses.
Record 10917: Discarded - failed all WHEN clauses.
Record 10918: Discarded - failed all WHEN clauses.
Record 10922: Discarded - failed all WHEN clauses.
Record 10923: Discarded - failed all WHEN clauses.
Record 10924: Discarded - failed all WHEN clauses.
Record 10929: Discarded - failed all WHEN clauses.
Record 10930: Discarded - failed all WHEN clauses.
Record 10931: Discarded - failed all WHEN clauses.
Record 10933: Discarded - failed all WHEN clauses.
Record 10934: Discarded - failed all WHEN clauses.
Record 10935: Discarded - failed all WHEN clauses.
Record 10936: Discarded - failed all WHEN clauses.
Record 10937: Discarded - failed all WHEN clauses.
Record 10939: Discarded - failed all WHEN clauses.
Record 10946: Discarded - failed all WHEN clauses.
Record 10953: Discarded - failed all WHEN clauses.
Record 10954: Discarded - failed all WHEN clauses.
Record 10962: Discarded - failed all WHEN clauses.
Record 10974: Discarded - failed all WHEN clauses.
Record 10976: Discarded - failed all WHEN clauses.
Record 10983: Discarded - failed all WHEN clauses.
Record 10995: Discarded - failed all WHEN clauses.
Record 10996: Discarded - failed all WHEN clauses.
Record 10998: Discarded - failed all WHEN clauses.
Record 11005: Discarded - failed all WHEN clauses.
Record 11006: Discarded - failed all WHEN clauses.
Record 11007: Discarded - failed all WHEN clauses.
Record 11008: Discarded - failed all WHEN clauses.
Record 11015: Discarded - failed all WHEN clauses.
Record 11026: Discarded - failed all WHEN clauses.
Record 11028: Discarded - failed all WHEN clauses.
Record 11036: Discarded - failed all WHEN clauses.
Record 11037: Discarded - failed all WHEN clauses.
Record 11040: Discarded - failed all WHEN clauses.
Record 11041: Discarded - failed all WHEN clauses.
Record 11042: Discarded - failed all WHEN clauses.
Record 11043: Discarded - failed all WHEN clauses.
Record 11044: Discarded - failed all WHEN clauses.
Record 11045: Discarded - failed all WHEN clauses.
Record 11050: Discarded - failed all WHEN clauses.
Record 11055: Discarded - failed all WHEN clauses.
Record 11057: Discarded - failed all WHEN clauses.
Record 11061: Discarded - failed all WHEN clauses.
Record 11064: Discarded - failed all WHEN clauses.
Record 11069: Discarded - failed all WHEN clauses.
Record 11070: Discarded - failed all WHEN clauses.
Record 11074: Discarded - failed all WHEN clauses.
Record 11075: Discarded - failed all WHEN clauses.
Record 11076: Discarded - failed all WHEN clauses.
Record 11077: Discarded - failed all WHEN clauses.
Record 11079: Discarded - failed all WHEN clauses.
Record 11081: Discarded - failed all WHEN clauses.
Record 11082: Discarded - failed all WHEN clauses.
Record 11083: Discarded - failed all WHEN clauses.
Record 11089: Discarded - failed all WHEN clauses.
Record 11092: Discarded - failed all WHEN clauses.
Record 11107: Discarded - failed all WHEN clauses.
Record 11109: Discarded - failed all WHEN clauses.
Record 11125: Discarded - failed all WHEN clauses.
Record 11132: Discarded - failed all WHEN clauses.
Record 11133: Discarded - failed all WHEN clauses.
Record 11136: Discarded - failed all WHEN clauses.
Record 11139: Discarded - failed all WHEN clauses.
Record 11140: Discarded - failed all WHEN clauses.
Record 11141: Discarded - failed all WHEN clauses.
Record 11149: Discarded - failed all WHEN clauses.
Record 11150: Discarded - failed all WHEN clauses.
Record 11151: Discarded - failed all WHEN clauses.
Record 11153: Discarded - failed all WHEN clauses.
Record 11154: Discarded - failed all WHEN clauses.
Record 11167: Discarded - failed all WHEN clauses.
Record 11168: Discarded - failed all WHEN clauses.
Record 11173: Discarded - failed all WHEN clauses.
Record 11176: Discarded - failed all WHEN clauses.
Record 11179: Discarded - failed all WHEN clauses.
Record 11180: Discarded - failed all WHEN clauses.
Record 11183: Discarded - failed all WHEN clauses.
Record 11184: Discarded - failed all WHEN clauses.
Record 11188: Discarded - failed all WHEN clauses.
Record 11196: Discarded - failed all WHEN clauses.
Record 11197: Discarded - failed all WHEN clauses.
Record 11198: Discarded - failed all WHEN clauses.
Record 11199: Discarded - failed all WHEN clauses.
Record 11201: Discarded - failed all WHEN clauses.
Record 11203: Discarded - failed all WHEN clauses.
Record 11204: Discarded - failed all WHEN clauses.
Record 11206: Discarded - failed all WHEN clauses.
Record 11207: Discarded - failed all WHEN clauses.
Record 11208: Discarded - failed all WHEN clauses.
Record 11209: Discarded - failed all WHEN clauses.
Record 11210: Discarded - failed all WHEN clauses.
Record 11211: Discarded - failed all WHEN clauses.
Record 11212: Discarded - failed all WHEN clauses.
Record 11213: Discarded - failed all WHEN clauses.
Record 11214: Discarded - failed all WHEN clauses.
Record 11217: Discarded - failed all WHEN clauses.
Record 11218: Discarded - failed all WHEN clauses.
Record 11220: Discarded - failed all WHEN clauses.
Record 11221: Discarded - failed all WHEN clauses.
Record 11222: Discarded - failed all WHEN clauses.
Record 11223: Discarded - failed all WHEN clauses.
Record 11224: Discarded - failed all WHEN clauses.
Record 11225: Discarded - failed all WHEN clauses.
Record 11226: Discarded - failed all WHEN clauses.
Record 11227: Discarded - failed all WHEN clauses.
Record 11229: Discarded - failed all WHEN clauses.
Record 11231: Discarded - failed all WHEN clauses.
Record 11244: Discarded - failed all WHEN clauses.
Record 11245: Discarded - failed all WHEN clauses.
Record 11251: Discarded - failed all WHEN clauses.
Record 11254: Discarded - failed all WHEN clauses.
Record 11258: Discarded - failed all WHEN clauses.
Record 11260: Discarded - failed all WHEN clauses.
Record 11272: Discarded - failed all WHEN clauses.
Record 11278: Discarded - failed all WHEN clauses.
Record 11283: Discarded - failed all WHEN clauses.
Record 11284: Discarded - failed all WHEN clauses.
Record 11288: Discarded - failed all WHEN clauses.
Record 11289: Discarded - failed all WHEN clauses.
Record 11299: Discarded - failed all WHEN clauses.
Record 11308: Discarded - failed all WHEN clauses.
Record 11314: Discarded - failed all WHEN clauses.
Record 11319: Discarded - failed all WHEN clauses.
Record 11329: Discarded - failed all WHEN clauses.
Record 11333: Discarded - failed all WHEN clauses.
Record 11337: Discarded - failed all WHEN clauses.
Record 11345: Discarded - failed all WHEN clauses.
Record 11398: Discarded - failed all WHEN clauses.
Record 11416: Discarded - failed all WHEN clauses.
Record 11428: Discarded - failed all WHEN clauses.
Record 11429: Discarded - failed all WHEN clauses.
Record 11430: Discarded - failed all WHEN clauses.
Record 11433: Discarded - failed all WHEN clauses.
Record 11434: Discarded - failed all WHEN clauses.
Record 11488: Discarded - failed all WHEN clauses.
Record 11491: Discarded - failed all WHEN clauses.
Record 11493: Discarded - failed all WHEN clauses.
Record 11498: Discarded - failed all WHEN clauses.
Record 11502: Discarded - failed all WHEN clauses.
Record 11505: Discarded - failed all WHEN clauses.
Record 11506: Discarded - failed all WHEN clauses.
Record 11507: Discarded - failed all WHEN clauses.
Record 11508: Discarded - failed all WHEN clauses.
Record 11509: Discarded - failed all WHEN clauses.
Record 11510: Discarded - failed all WHEN clauses.
Record 11511: Discarded - failed all WHEN clauses.
Record 11512: Discarded - failed all WHEN clauses.
Record 11520: Discarded - failed all WHEN clauses.
Record 11522: Discarded - failed all WHEN clauses.
Record 11523: Discarded - failed all WHEN clauses.
Record 11525: Discarded - failed all WHEN clauses.
Record 11528: Discarded - failed all WHEN clauses.
Record 11529: Discarded - failed all WHEN clauses.
Record 11530: Discarded - failed all WHEN clauses.
Record 11532: Discarded - failed all WHEN clauses.
Record 11534: Discarded - failed all WHEN clauses.
Record 11535: Discarded - failed all WHEN clauses.
Record 11537: Discarded - failed all WHEN clauses.
Record 11552: Discarded - failed all WHEN clauses.
Record 11561: Discarded - failed all WHEN clauses.
Record 11563: Discarded - failed all WHEN clauses.
Record 11568: Discarded - failed all WHEN clauses.
Record 11578: Discarded - failed all WHEN clauses.
Record 11582: Discarded - failed all WHEN clauses.
Record 11586: Discarded - failed all WHEN clauses.
Record 11588: Discarded - failed all WHEN clauses.
Record 11596: Discarded - failed all WHEN clauses.
Record 11597: Discarded - failed all WHEN clauses.
Record 11598: Discarded - failed all WHEN clauses.
Record 11619: Discarded - failed all WHEN clauses.
Record 11621: Discarded - failed all WHEN clauses.
Record 11628: Discarded - failed all WHEN clauses.
Record 11629: Discarded - failed all WHEN clauses.
Record 11631: Discarded - failed all WHEN clauses.
Record 11632: Discarded - failed all WHEN clauses.
Record 11633: Discarded - failed all WHEN clauses.
Record 11634: Discarded - failed all WHEN clauses.
Record 11635: Discarded - failed all WHEN clauses.
Record 11639: Discarded - failed all WHEN clauses.
Record 11640: Discarded - failed all WHEN clauses.
Record 11641: Discarded - failed all WHEN clauses.
Record 11642: Discarded - failed all WHEN clauses.
Record 11646: Discarded - failed all WHEN clauses.
Record 11649: Discarded - failed all WHEN clauses.
Record 11654: Discarded - failed all WHEN clauses.
Record 11655: Discarded - failed all WHEN clauses.
Record 11657: Discarded - failed all WHEN clauses.
Record 11658: Discarded - failed all WHEN clauses.
Record 11660: Discarded - failed all WHEN clauses.
Record 11662: Discarded - failed all WHEN clauses.
Record 11664: Discarded - failed all WHEN clauses.
Record 11675: Discarded - failed all WHEN clauses.
Record 11676: Discarded - failed all WHEN clauses.
Record 11681: Discarded - failed all WHEN clauses.
Record 11682: Discarded - failed all WHEN clauses.
Record 11685: Discarded - failed all WHEN clauses.
Record 11688: Discarded - failed all WHEN clauses.
Record 11695: Discarded - failed all WHEN clauses.
Record 11696: Discarded - failed all WHEN clauses.
Record 11701: Discarded - failed all WHEN clauses.
Record 11702: Discarded - failed all WHEN clauses.
Record 11703: Discarded - failed all WHEN clauses.
Record 11705: Discarded - failed all WHEN clauses.
Record 11706: Discarded - failed all WHEN clauses.
Record 11708: Discarded - failed all WHEN clauses.
Record 11709: Discarded - failed all WHEN clauses.
Record 11711: Discarded - failed all WHEN clauses.
Record 11712: Discarded - failed all WHEN clauses.
Record 11717: Discarded - failed all WHEN clauses.
Record 11718: Discarded - failed all WHEN clauses.
Record 11723: Discarded - failed all WHEN clauses.
Record 11727: Discarded - failed all WHEN clauses.
Record 11729: Discarded - failed all WHEN clauses.
Record 11730: Discarded - failed all WHEN clauses.
Record 11731: Discarded - failed all WHEN clauses.
Record 11734: Discarded - failed all WHEN clauses.
Record 11739: Discarded - failed all WHEN clauses.
Record 11744: Discarded - failed all WHEN clauses.
Record 11745: Discarded - failed all WHEN clauses.
Record 11747: Discarded - failed all WHEN clauses.
Record 11749: Discarded - failed all WHEN clauses.
Record 11750: Discarded - failed all WHEN clauses.
Record 11753: Discarded - failed all WHEN clauses.
Record 11754: Discarded - failed all WHEN clauses.
Record 11758: Discarded - failed all WHEN clauses.
Record 11759: Discarded - failed all WHEN clauses.
Record 11762: Discarded - failed all WHEN clauses.
Record 11763: Discarded - failed all WHEN clauses.
Record 11765: Discarded - failed all WHEN clauses.
Record 11775: Discarded - failed all WHEN clauses.
Record 11776: Discarded - failed all WHEN clauses.
Record 11781: Discarded - failed all WHEN clauses.
Record 11799: Discarded - failed all WHEN clauses.
Record 11800: Discarded - failed all WHEN clauses.
Record 11801: Discarded - failed all WHEN clauses.
Record 11802: Discarded - failed all WHEN clauses.
Record 11804: Discarded - failed all WHEN clauses.
Record 11805: Discarded - failed all WHEN clauses.
Record 11806: Discarded - failed all WHEN clauses.
Record 11816: Discarded - failed all WHEN clauses.
Record 11820: Discarded - failed all WHEN clauses.
Record 11821: Discarded - failed all WHEN clauses.
Record 11826: Discarded - failed all WHEN clauses.
Record 11828: Discarded - failed all WHEN clauses.
Record 11830: Discarded - failed all WHEN clauses.
Record 11832: Discarded - failed all WHEN clauses.
Record 11833: Discarded - failed all WHEN clauses.
Record 11835: Discarded - failed all WHEN clauses.
Record 11836: Discarded - failed all WHEN clauses.
Record 11837: Discarded - failed all WHEN clauses.
Record 11844: Discarded - failed all WHEN clauses.
Record 11861: Discarded - failed all WHEN clauses.
Record 11863: Discarded - failed all WHEN clauses.
Record 11865: Discarded - failed all WHEN clauses.
Record 11869: Discarded - failed all WHEN clauses.
Record 11871: Discarded - failed all WHEN clauses.
Record 11872: Discarded - failed all WHEN clauses.
Record 11873: Discarded - failed all WHEN clauses.
Record 11875: Discarded - failed all WHEN clauses.
Record 11876: Discarded - failed all WHEN clauses.
Record 11879: Discarded - failed all WHEN clauses.
Record 11880: Discarded - failed all WHEN clauses.
Record 11882: Discarded - failed all WHEN clauses.
Record 11883: Discarded - failed all WHEN clauses.
Record 11884: Discarded - failed all WHEN clauses.
Record 11885: Discarded - failed all WHEN clauses.
Record 11886: Discarded - failed all WHEN clauses.
Record 11902: Discarded - failed all WHEN clauses.
Record 11905: Discarded - failed all WHEN clauses.
Record 11906: Discarded - failed all WHEN clauses.
Record 11908: Discarded - failed all WHEN clauses.
Record 11909: Discarded - failed all WHEN clauses.
Record 11916: Discarded - failed all WHEN clauses.
Record 11917: Discarded - failed all WHEN clauses.
Record 11918: Discarded - failed all WHEN clauses.
Record 11923: Discarded - failed all WHEN clauses.
Record 11924: Discarded - failed all WHEN clauses.
Record 11925: Discarded - failed all WHEN clauses.
Record 11926: Discarded - failed all WHEN clauses.
Record 11930: Discarded - failed all WHEN clauses.
Record 11933: Discarded - failed all WHEN clauses.
Record 11936: Discarded - failed all WHEN clauses.
Record 11937: Discarded - failed all WHEN clauses.
Record 11938: Discarded - failed all WHEN clauses.
Record 11939: Discarded - failed all WHEN clauses.
Record 11948: Discarded - failed all WHEN clauses.
Record 11951: Discarded - failed all WHEN clauses.
Record 11953: Discarded - failed all WHEN clauses.
Record 11954: Discarded - failed all WHEN clauses.
Record 11956: Discarded - failed all WHEN clauses.
Record 11957: Discarded - failed all WHEN clauses.
Record 11958: Discarded - failed all WHEN clauses.
Record 11959: Discarded - failed all WHEN clauses.
Record 11960: Discarded - failed all WHEN clauses.
Record 11966: Discarded - failed all WHEN clauses.
Record 11971: Discarded - failed all WHEN clauses.
Record 11972: Discarded - failed all WHEN clauses.
Record 11973: Discarded - failed all WHEN clauses.
Record 11974: Discarded - failed all WHEN clauses.
Record 11975: Discarded - failed all WHEN clauses.
Record 11976: Discarded - failed all WHEN clauses.
Record 11978: Discarded - failed all WHEN clauses.
Record 11979: Discarded - failed all WHEN clauses.
Record 11997: Discarded - failed all WHEN clauses.
Record 11998: Discarded - failed all WHEN clauses.
Record 11999: Discarded - failed all WHEN clauses.
Record 12002: Discarded - failed all WHEN clauses.
Record 12024: Discarded - failed all WHEN clauses.
Record 12025: Discarded - failed all WHEN clauses.
Record 12052: Discarded - failed all WHEN clauses.
Record 12054: Discarded - failed all WHEN clauses.
Record 12068: Discarded - failed all WHEN clauses.
Record 12079: Discarded - failed all WHEN clauses.
Record 12081: Discarded - failed all WHEN clauses.
Record 12091: Discarded - failed all WHEN clauses.
Record 12092: Discarded - failed all WHEN clauses.
Record 12093: Discarded - failed all WHEN clauses.
Record 12098: Discarded - failed all WHEN clauses.
Record 12099: Discarded - failed all WHEN clauses.
Record 12104: Discarded - failed all WHEN clauses.
Record 12105: Discarded - failed all WHEN clauses.
Record 12107: Discarded - failed all WHEN clauses.
Record 12113: Discarded - failed all WHEN clauses.
Record 12139: Discarded - failed all WHEN clauses.
Record 12165: Discarded - failed all WHEN clauses.
Record 12204: Discarded - failed all WHEN clauses.
Record 12206: Discarded - failed all WHEN clauses.
Record 12226: Discarded - failed all WHEN clauses.
Record 12227: Discarded - failed all WHEN clauses.
Record 12251: Discarded - failed all WHEN clauses.
Record 12252: Discarded - failed all WHEN clauses.
Record 12254: Discarded - failed all WHEN clauses.
Record 12269: Discarded - failed all WHEN clauses.
Record 12271: Discarded - failed all WHEN clauses.
Record 12272: Discarded - failed all WHEN clauses.
Record 12273: Discarded - failed all WHEN clauses.
Record 12275: Discarded - failed all WHEN clauses.
Record 12276: Discarded - failed all WHEN clauses.
Record 12277: Discarded - failed all WHEN clauses.
Record 12278: Discarded - failed all WHEN clauses.
Record 12279: Discarded - failed all WHEN clauses.
Record 12280: Discarded - failed all WHEN clauses.
Record 12281: Discarded - failed all WHEN clauses.
Record 12294: Discarded - failed all WHEN clauses.
Record 12296: Discarded - failed all WHEN clauses.
Record 12298: Discarded - failed all WHEN clauses.
Record 12307: Discarded - failed all WHEN clauses.
Record 12321: Discarded - failed all WHEN clauses.
Record 12322: Discarded - failed all WHEN clauses.
Record 12323: Discarded - failed all WHEN clauses.
Record 12324: Discarded - failed all WHEN clauses.
Record 12326: Discarded - failed all WHEN clauses.
Record 12327: Discarded - failed all WHEN clauses.
Record 12332: Discarded - failed all WHEN clauses.
Record 12337: Discarded - failed all WHEN clauses.
Record 12338: Discarded - failed all WHEN clauses.
Record 12339: Discarded - failed all WHEN clauses.
Record 12341: Discarded - failed all WHEN clauses.
Record 12344: Discarded - failed all WHEN clauses.
Record 12348: Discarded - failed all WHEN clauses.
Record 12350: Discarded - failed all WHEN clauses.
Record 12351: Discarded - failed all WHEN clauses.
Record 12353: Discarded - failed all WHEN clauses.
Record 12360: Discarded - failed all WHEN clauses.
Record 12361: Discarded - failed all WHEN clauses.
Record 12363: Discarded - failed all WHEN clauses.
Record 12367: Discarded - failed all WHEN clauses.
Record 12369: Discarded - failed all WHEN clauses.
Record 12371: Discarded - failed all WHEN clauses.
Record 12372: Discarded - failed all WHEN clauses.
Record 12373: Discarded - failed all WHEN clauses.
Record 12374: Discarded - failed all WHEN clauses.
Record 12375: Discarded - failed all WHEN clauses.
Record 12378: Discarded - failed all WHEN clauses.
Record 12381: Discarded - failed all WHEN clauses.
Record 12388: Discarded - failed all WHEN clauses.
Record 12400: Discarded - failed all WHEN clauses.
Record 12410: Discarded - failed all WHEN clauses.
Record 12415: Discarded - failed all WHEN clauses.
Record 12420: Discarded - failed all WHEN clauses.
Record 12431: Discarded - failed all WHEN clauses.
Record 12445: Discarded - failed all WHEN clauses.
Record 12450: Discarded - failed all WHEN clauses.
Record 12471: Discarded - failed all WHEN clauses.
Record 12472: Discarded - failed all WHEN clauses.
Record 12473: Discarded - failed all WHEN clauses.
Record 12474: Discarded - failed all WHEN clauses.
Record 12481: Discarded - failed all WHEN clauses.
Record 12486: Discarded - failed all WHEN clauses.
Record 12487: Discarded - failed all WHEN clauses.
Record 12488: Discarded - failed all WHEN clauses.
Record 12489: Discarded - failed all WHEN clauses.
Record 12490: Discarded - failed all WHEN clauses.
Record 12498: Discarded - failed all WHEN clauses.
Record 12499: Discarded - failed all WHEN clauses.
Record 12500: Discarded - failed all WHEN clauses.
Record 12503: Discarded - failed all WHEN clauses.
Record 12512: Discarded - failed all WHEN clauses.
Record 12514: Discarded - failed all WHEN clauses.
Record 12516: Discarded - failed all WHEN clauses.
Record 12518: Discarded - failed all WHEN clauses.
Record 12519: Discarded - failed all WHEN clauses.
Record 12521: Discarded - failed all WHEN clauses.
Record 12525: Discarded - failed all WHEN clauses.
Record 12541: Discarded - failed all WHEN clauses.
Record 12542: Discarded - failed all WHEN clauses.
Record 12557: Discarded - failed all WHEN clauses.
Record 12558: Discarded - failed all WHEN clauses.
Record 12567: Discarded - failed all WHEN clauses.
Record 12569: Discarded - failed all WHEN clauses.
Record 12577: Discarded - failed all WHEN clauses.
Record 12585: Discarded - failed all WHEN clauses.
Record 12588: Discarded - failed all WHEN clauses.
Record 12589: Discarded - failed all WHEN clauses.
Record 12593: Discarded - failed all WHEN clauses.
Record 12594: Discarded - failed all WHEN clauses.
Record 12595: Discarded - failed all WHEN clauses.
Record 12598: Discarded - failed all WHEN clauses.
Record 12599: Discarded - failed all WHEN clauses.
Record 12600: Discarded - failed all WHEN clauses.
Record 12603: Discarded - failed all WHEN clauses.
Record 12604: Discarded - failed all WHEN clauses.
Record 12605: Discarded - failed all WHEN clauses.
Record 12606: Discarded - failed all WHEN clauses.
Record 12607: Discarded - failed all WHEN clauses.
Record 12610: Discarded - failed all WHEN clauses.
Record 12611: Discarded - failed all WHEN clauses.
Record 12614: Discarded - failed all WHEN clauses.
Record 12616: Discarded - failed all WHEN clauses.
Record 12619: Discarded - failed all WHEN clauses.
Record 12624: Discarded - failed all WHEN clauses.
Record 12625: Discarded - failed all WHEN clauses.
Record 12626: Discarded - failed all WHEN clauses.
Record 12628: Discarded - failed all WHEN clauses.
Record 12639: Discarded - failed all WHEN clauses.
Record 12652: Discarded - failed all WHEN clauses.
Record 12654: Discarded - failed all WHEN clauses.
Record 12658: Discarded - failed all WHEN clauses.
Record 12659: Discarded - failed all WHEN clauses.
Record 12660: Discarded - failed all WHEN clauses.
Record 12667: Discarded - failed all WHEN clauses.
Record 12668: Discarded - failed all WHEN clauses.
Record 12670: Discarded - failed all WHEN clauses.
Record 12673: Discarded - failed all WHEN clauses.
Record 12675: Discarded - failed all WHEN clauses.
Record 12680: Discarded - failed all WHEN clauses.
Record 12682: Discarded - failed all WHEN clauses.
Record 12687: Discarded - failed all WHEN clauses.
Record 12690: Discarded - failed all WHEN clauses.
Record 12695: Discarded - failed all WHEN clauses.
Record 12704: Discarded - failed all WHEN clauses.
Record 12706: Discarded - failed all WHEN clauses.
Record 12708: Discarded - failed all WHEN clauses.
Record 12711: Discarded - failed all WHEN clauses.
Record 12712: Discarded - failed all WHEN clauses.
Record 12723: Discarded - failed all WHEN clauses.
Record 12724: Discarded - failed all WHEN clauses.
Record 12726: Discarded - failed all WHEN clauses.
Record 12735: Discarded - failed all WHEN clauses.
Record 12750: Discarded - failed all WHEN clauses.
Record 12754: Discarded - failed all WHEN clauses.
Record 12764: Discarded - failed all WHEN clauses.
Record 12765: Discarded - failed all WHEN clauses.
Record 12766: Discarded - failed all WHEN clauses.
Record 12767: Discarded - failed all WHEN clauses.
Record 12768: Discarded - failed all WHEN clauses.
Record 12778: Discarded - failed all WHEN clauses.
Record 12783: Discarded - failed all WHEN clauses.
Record 12791: Discarded - failed all WHEN clauses.
Record 12792: Discarded - failed all WHEN clauses.
Record 12799: Discarded - failed all WHEN clauses.
Record 12806: Discarded - failed all WHEN clauses.
Record 12809: Discarded - failed all WHEN clauses.
Record 12810: Discarded - failed all WHEN clauses.
Record 12811: Discarded - failed all WHEN clauses.
Record 12812: Discarded - failed all WHEN clauses.
Record 12813: Discarded - failed all WHEN clauses.
Record 12815: Discarded - failed all WHEN clauses.
Record 12819: Discarded - failed all WHEN clauses.
Record 12821: Discarded - failed all WHEN clauses.
Record 12822: Discarded - failed all WHEN clauses.
Record 12823: Discarded - failed all WHEN clauses.
Record 12825: Discarded - failed all WHEN clauses.
Record 12829: Discarded - failed all WHEN clauses.
Record 12831: Discarded - failed all WHEN clauses.
Record 12835: Discarded - failed all WHEN clauses.
Record 12837: Discarded - failed all WHEN clauses.
Record 12841: Discarded - failed all WHEN clauses.
Record 12843: Discarded - failed all WHEN clauses.
Record 12845: Discarded - failed all WHEN clauses.
Record 12846: Discarded - failed all WHEN clauses.
Record 12850: Discarded - failed all WHEN clauses.
Record 12852: Discarded - failed all WHEN clauses.
Record 12853: Discarded - failed all WHEN clauses.
Record 12904: Discarded - failed all WHEN clauses.
Record 12906: Discarded - failed all WHEN clauses.
Record 12908: Discarded - failed all WHEN clauses.
Record 12922: Discarded - failed all WHEN clauses.
Record 12931: Discarded - failed all WHEN clauses.
Record 12932: Discarded - failed all WHEN clauses.
Record 12933: Discarded - failed all WHEN clauses.
Record 13004: Discarded - failed all WHEN clauses.
Record 13014: Discarded - failed all WHEN clauses.
Record 13041: Discarded - failed all WHEN clauses.
Record 13063: Discarded - failed all WHEN clauses.
Record 13068: Discarded - failed all WHEN clauses.
Record 13070: Discarded - failed all WHEN clauses.
SQL*Loader-500: Unable to open file (bod.dat)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified. [/b]

 

by: DonFreemanPosted on 2003-02-13 at 13:31:57ID: 7945169

What does the data in the table look like?  It doesn't look like it is opening the data file at all. I would truncate the table and try again. It looks to me like there is more than one problem.

I haven't used the infile parameter. I would simplify it and pass all the parameters in the command line:
sqlldr  <connectstring>  ctl=bod.ctl data=bod.dta log=bod.log bad=bod.bad and start sqlldr from the directory where the datafile is located. Somehow it doesn't seem to like the path to the file.  If it was unix I would say you don't have permission on the file.

 

by: imranrashidPosted on 2003-02-13 at 23:55:45ID: 7948040

To me, it seems like two seperate problems.
First one regarding the difference in number of records you are actually getting in the table and number of records sql loader is reporting to load. As far as this problem is concerned, I think that problem lies in the when clause of your control file. The conditions you have specified does not allow all the rows to be loaded in the table. For that, you can check the discard file and you will see all the discarded records there. Now either you can change your condition or your records to meet your condition.

Second problem seems like it is not able to open some specific file. You have specified two input files in your control file. After loading one file, maybe, it is unable to open the second file. If you really want to load two files, then make sure that it resides on the proper path as you have not mentioned the path for the second file. Or if you have specified it by mistake, then just remove it from the control file and you wont see the message of File Not Found.
Hope that solves the problem.

 

by: joekendallPosted on 2003-09-29 at 06:36:04ID: 9451351

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered by: imranrashid

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Joe
EE Cleanup Volunteer

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...