HP Loader problems !
A poster using hploader saw 8,823,643 records inserted without errors while the unload file had 8,823,564 lines. rkusenet suggested rows with embedded newlines, John Carlson suggested select count(*), and Richard Kofler noted the loaded count exceeded the line count by about 100 and asked how lines were counted and whether one line equals one record. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.com... > 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
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