Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error while inserting row no. 219701

  1. #1
    Join Date
    Aug 2007
    Posts
    151

    Question Error while inserting row no. 219701

    Hi all! This one baffles me:

    1. I've used the copy tables wizard to copy aroundo 50 tables from Oracle to Postgres.
    2. While processing, the job stops in error at table no. 28, having processed not only all the other 27 tables, but having also processed some 200,000 records before this one.
    3. I can't find any big difference from the other rows and the one issuing the error, except that the two last columns doesn't seem to have been pulled from source (no problem here, since there are a lot of records where those two fields are empty).

    I have once come upon an error like that I have solved changing table from set UTF8 to Latin1, but I can't do this now and it wouldn't make sense to do so, since everything seem to be ok.

    Can anybody help me? Any clues of what may be causing this?

    === ERROR ===

    2008/09/04 15:39:28 - read from [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - linenr 200000
    2008/09/04 15:39:30 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - linenr 200000
    2008/09/04 15:39:34 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Because of an error, this step can't continue:
    2008/09/04 15:39:34 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Error batch inserting rows into table [SSDSPU.SIAPA2Q_RESPONSAVEL].
    2008/09/04 15:39:34 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Errors encountered (first 10):
    2008/09/04 15:39:34 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Batch entry 8 INSERT INTO "SSDSPU.SIAPA2Q_RESPONSAVEL"(ID_RESP, ID_CPF_CGC, DS_RESP, ID_COD_TP_PESSOA, ID_COD_MUN, ID_CEP_RESP, CO_TIPO_LOGR_END_RESP, DS_LOGR_END_RESP, ID_END_RESP, DS_COMPL_END_RESP, DS_BAIRRO_END_RESP, ID_CEP_END_RESP) VALUES ( 387570, 24999863871, VENCESLAU GOMES DA SILVA, 1, 4123, 30190090, NULL, RUA MARTIN DE CARVALHO, 66, APTO 402 2008/09/04 15:39:34 - read from [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - Finished reading query, closing connection.
    2008/09/04 15:39:34 - write to [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - Finished processing (I=0, O=219799, R=219800, W=219700, U=0, E=1)
    2008/09/04 15:39:34 - read from [SSDSPU.SIAPA2Q_RESPONSAVEL].0 - Finished processing (I=229701, O=0, R=0, W=229699, U=0, E=0)
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Errors detected!
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - ERROR (version 3.0.3, build 569 from 2008/04/25 14:30:04) : Errors detected!
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - Transformation detected 1 steps with errors!
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - Transformation is killing the other steps!
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - Looking at step: read from [SSDSPU.SIAPA2Q_RESPONSAVEL]
    2008/09/04 15:39:34 - copy [SPU Homologacao].[SSDSPU.SIAPA2Q_RESPONSAVEL] to [SPU PostgreSQL] - Looking at step: write to [SSDSPU.SIAPA2Q_RESPONSAVEL]
    2008/09/04 15:39:34 - Copiar SPU Oracle para Postgres - !Job.Log.FinishedJobEntry!

  2. #2
    Join Date
    Jul 2006
    Posts
    20

    Default

    There's a problem with reading the data from that row. Perhaps the data has the wrong format. Check the data from that row.
    Best Regards,

    Check out my blog

  3. #3
    Join Date
    Aug 2007
    Posts
    151

    Smile Thanks!

    Thank you very much! I am going to check it. How did you suspect that? (I am asking so I can learn what to look for when dealing with errors like that).

    Fabio

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.