Hello, I have a question: When using hploader i get the this kind of
messages...

Table 'fact_serv_om' will be read-only until level 0 archive

Database Load Completed -- Processed 8823643 Records
Records Inserted-> 8823643
Detected Errors--> 0
Engine Rejected--> 0

Wed Nov 10 09:08:19 2004


Job Completed Successfully ... connection closed

The problem is that my unload file has 8823564 lines... so rows are
missing !! 8 time out 10 its equal so could someone explain why rows
are missing ?

Thank you

"spare" <stephane.pare@bell.ca> wrote in message
news:8eb0e43f.0411100644.79805319@posting.google.c om...
> Hello, I have a question: When using hploader i get the this kind of
> messages...
>
> Table 'fact_serv_om' will be read-only until level 0 archive
>
> Database Load Completed -- Processed 8823643 Records
> Records Inserted-> 8823643
> Detected Errors--> 0
> Engine Rejected--> 0
>
> Wed Nov 10 09:08:19 2004
>
>
> Job Completed Successfully ... connection closed
>
> The problem is that my unload file has 8823564 lines... so rows are
> missing !! 8 time out 10 its equal so could someone explain why rows
> are missing ?
>
> Thank you

It could also mean that there are 10 rows which have embedded new lines in them.
Look for those lines which have back slash (\) as the last character of the line.

On 10 Nov 2004 06:44:31 -0800, stephane.pare@bell.ca (spare) wrote:

>Hello, I have a question: When using hploader i get the this kind of
>messages...
>
>Table 'fact_serv_om' will be read-only until level 0 archive
>
>Database Load Completed -- Processed 8823643 Records
>Records Inserted-> 8823643
>Detected Errors--> 0
>Engine Rejected--> 0
>
>Wed Nov 10 09:08:19 2004
>
>
>Job Completed Successfully ... connection closed
>
>The problem is that my unload file has 8823564 lines... so rows are
>missing !! 8 time out 10 its equal so could someone explain why rows
>are missing ?
>
>Thank you

What does "Select count(*) from fact_serv_om" say?

JWC

Is this 9.40 by any chance?
If so you might have hit a little bugette. Would be worth a call to
your support provider.


John Carlson <jwcarlson1@yahoo.com.invalid> wrote in message news:<c9o5p0pm278t182hb00n6jev2iclepbapk@4ax.com>. ..
> On 10 Nov 2004 06:44:31 -0800, stephane.pare@bell.ca (spare) wrote:
>
> >Hello, I have a question: When using hploader i get the this kind of
> >messages...
> >
> >Table 'fact_serv_om' will be read-only until level 0 archive
> >
> >Database Load Completed -- Processed 8823643 Records
> >Records Inserted-> 8823643
> >Detected Errors--> 0
> >Engine Rejected--> 0
> >
> >Wed Nov 10 09:08:19 2004
> >
> >
> >Job Completed Successfully ... connection closed
> >
> >The problem is that my unload file has 8823564 lines... so rows are
> >missing !! 8 time out 10 its equal so could someone explain why rows
> >are missing ?
> >
> >Thank you
>
> What does "Select count(*) from fact_serv_om" say?
>
> JWC

spare wrote:
>
> Hello, I have a question: When using hploader i get the this kind of
> messages...
>
> Table 'fact_serv_om' will be read-only until level 0 archive

OK
This is because of the fragment append which HPL
does when loading in express mode.

>
> Database Load Completed -- Processed 8823643 Records
> Records Inserted-> 8823643
> Detected Errors--> 0
> Engine Rejected--> 0
>
> Wed Nov 10 09:08:19 2004
>
> Job Completed Successfully ... connection closed
>
> The problem is that my unload file has 8823564 lines... so rows are

8823564 < 8823643
Your unload has more 'lines' than you have records

> missing !! 8 time out 10 its equal so could someone explain why rows
> are missing ?
>
> Thank you

What do I miss here?

HPL Records Inserted: 8823643
This is more by 100 than you have 'unloaded'.

How did you unload and how did you get the no of
unloaded lines. What is a line?
Are you sure that 1 line equals 1 record?

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe