org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Length or precision specification 0 is invalid.

Pentaho BI Platform Tracking | Somashekar Inguva | 8 months ago
  1. 0

    Column names "Time" and "Name" kettle converts to "time" and "name" - ERROR

    GitHub | 2 years ago | cowabunga1
    org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch Batch entry 0 INSERT INTO "public"."ExtCompositions" ("Mask", "mask_change_owner", "CompositionId", "ParentId", "Node", "time", "name", "Shifr", "Marka", "Volume", "Plast", "Del", "id") VALUES ( 4, 4, 641378322, 0, 0, '2015-04-07 10:04:26.000000 +03:00:00', '6004-004', '00000000002', '00-00000202', 100, 0, 0, 3) was aborted. Call getNextException to see the cause.
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Pentaho Kettle - From JSON Table Output to Postgresql JSONB field

    Stack Overflow | 1 year ago | Paul Thomas
    org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch Batch entry 0 INSERT INTO test_raw_dataj (sensor_readings) VALUES ( '{"data":[{"readings":"[[1325404802000,2.8020381927490234],[1325404812000,2.8020381927490234],[1325404822000,2.817678451538086],[1325404832000,2.817678451538086],[1325404842000,2.8333663940429688],[1325404852000,2.8333663940429688]]","id":"59997f"}]}') was aborted. Call getNextException to see the cause.
  4. 0

    Error al realizar una transformacion con postgresql - Open Business Intelligence

    redopenbi.com | 1 year ago
    org.pentaho.di.core.exception.KettleDatabaseBatchException: 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error updating batch 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettleDatabaseBatchException

      Error updating batch [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Length or precision specification 0 is invalid.

      at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1365)
      2. org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1354)
      3. org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:571)
      4. org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
      4 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame