Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Data truncation

  1. #1

    Default Data truncation

    Tengo el siguiente problema, cuando realizo la consulta sql, paso un valor integer a string asi

    CASEWHEN ope.num_imo_numero
    IS
    NULLTHEN"SIN DESCRIPCION" ELSECONVERT ( VARCHAR(60) ,ope.num_imo_numero)
    ENDAS CodigoOnu

    2010/02/11 13:20:12 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened.
    2010/02/11 13:20:12 - Spoon - Launching transformation [Mercancias]...
    2010/02/11 13:20:12 - Spoon - Started the transformation execution.
    2010/02/11 13:20:12 - Mercancias - Dispatching started for transformation [Mercancias]
    2010/02/11 13:20:12 - Mercancias - Natural sort of steps executed in 0ms (5 time previous steps calculated)
    2010/02/11 13:20:12 - Mercancias - This transformation can be replayed with replay date: 2010/02/11 13:20:12
    2010/02/11 13:20:12 - Table output.0 - Connected to database [ConexionChewbacca] (commit=1000)
    2010/02/11 13:22:05 - MercanciasPeligrosas Input.0 - Finished reading query, closing connection.
    2010/02/11 13:22:05 - MercanciasPeligrosas Input.0 - Finished processing (I=90, O=0, R=0, W=90, U=0, E=0)
    2010/02/11 13:22:05 - Select values.0 - Finished processing (I=0, O=0, R=90, W=90, U=0, E=0)
    2010/02/11 13:22:05 - Add sequence.0 - Finished processing (I=0, O=0, R=90, W=90, U=0, E=0)
    2010/02/11 13:22:05 - Select values 2.0 - Finished processing (I=0, O=0, R=90, W=90, U=0, E=0)
    2010/02/11 13:22:05 - Table output.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected batch update error committing the database connection.
    2010/02/11 13:22:05 - Table output.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2010/02/11 13:22:05 - Table output.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error updating batch
    2010/02/11 13:22:05 - Table output.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Data truncation

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    El error es " Data truncation". Significa que estas enviando a la tabla un registro donde al menos una de las columnas tiene mayor longitud que lo esperado. Puede ser pero no necesariamente es esta columna que estas mencionando.
    Trata de ejecutar la transformation con nivel de log Debug, asi ves exactamente que datos estas tratando de insertar. O si no, podes manejar errores (Table Output --> boton derecho --> Definir manejo de errores)

    saludos
    m

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.