Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problems with Insert/Update

  1. #1

    Default Problems with Insert/Update

    I'm trying to do an Insert/Update in a Oracle Base, but I recive the next message: ORA-01400: no se puede realizar una inserción NULL en ("CAIXA"."DADES_AUXILIARS"."ID_AUXILIAR". I have four fields: ID_AUXILIAR, VALOR_1, VALOR_2 and VALOR_3. The first and the second camps are primary keys. What's it happend?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    You tried to insert a NULL or empty string in a non-nullable column. Find your NULL

    Regards,
    Sven

  3. #3

    Default

    All my fields are string and they are full. I put ID_AUXILIAR AND VALOR_1 in the keys to look up the value(s):
    ID_AUXILIAR=ID_AUXILIAR
    VALOR_1=VALOR_1
    In the update fields:
    VALOR_2 VALOR_2
    VALOR_3 VALOR_3
    My variables have the same name in the table that in stream.
    Thank you

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    First verify ... by replacing database output by file output that you don't have NULLs or empty strings.

    If that's not the case then you either have non-nullable extra columns (without defaults) in your table, or your table is a view on a bigger table containing non-nullable columns, ... It probably could even be a trigger writing to some other table (and being triggered by your insertion).

    Regards,
    Sven

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.