Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem when extracting from oracle 10g to AS400 U

  1. #1
    Join Date
    Sep 2008
    Posts
    21

    Default Problem when extracting from oracle 10g to AS400 U

    Hi i'm testing pentaho for our futur needs , and i tried to extract an oracle 10 g table to load as400 table.
    I create the as400 by the automatic button sql in "Load a table"
    but i always have this error

    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) : Error batch inserting rows into table [ARDTEST].
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) : Errors encountered (first 10):
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) : [SQL7008] Table ARDTEST de U201307 incorrecte pour cette opération.
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) :
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) :
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) : Error updating batch
    2008/12/04 10:54:26 - Insertion dans table.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 12:14:00) : [SQL7008] Table ARDTEST de U201307 incorrecte pour cette opération.


    This is my as400 structure :

    Nom champ Type Longueur Précision Étape origine
    MVOP Integer 3 0
    MVCPT Integer 10 0
    MVMTFR Number 13 2
    MVVAL Integer 6 0
    MVREF String 6 -
    MVTXCO String 1 -
    FIELD1 String 1 -
    MVDESC String 20 -
    MVDEV Integer 2 0
    MVMTDV Number 13 2
    MVDIV Integer 1 0
    MVPERI String 1 -
    MVRENV Integer 4 0
    MVPASS String 1 -
    MVCOUR Number 8 5
    MVHIST String 1 -
    MVFAV Integer 6 0
    MVEXTR String 1 -
    MVTXD Number 8 5
    MVPREV Integer 1 0
    MVECH Integer 8 0
    MVGL Integer 3 0
    MVNOST Integer 10 0
    MVIN Integer 10 0
    MVOUT Integer 10 0
    MVBRK Integer 2 0
    MVTYPE Integer 3 0
    MVCOR String 1 -
    FIELD2 String 1 -
    FIELD3 String 1 -
    MVDC Integer 1 0
    MVTJJ Integer 1 0
    FIELD4 String 1 -
    MVDATO Integer 6 0
    MVNUOP Integer 7 0
    TYPEG String 2 -
    MVASTE String 1 -

    And this is my oracle strucutre

    Nom champ Type Longueur Précision Étape origine
    MVOP Integer 3 0
    MVCPT Integer 10 0
    MVMTFR Number 13 2
    MVVAL Integer 6 0
    MVREF String 6 -
    MVTXCO String 1 -
    FIELD1 String 1 -
    MVDESC String 20 -
    MVDEV Integer 2 0
    MVMTDV Number 13 2
    MVDIV Integer 1 0
    MVPERI String 1 -
    MVRENV Integer 4 0
    MVPASS String 1 -
    MVCOUR Number 8 5
    MVHIST String 1 -
    MVFAV Integer 6 0
    MVEXTR String 1 -
    MVTXD Number 8 5
    MVPREV Integer 1 0
    MVECH Integer 8 0
    MVGL Integer 3 0
    MVNOST Integer 10 0
    MVIN Integer 10 0
    MVOUT Integer 10 0
    MVBRK Integer 2 0
    MVTYPE Integer 3 0
    MVCOR String 1 -
    FIELD2 String 1 -
    FIELD3 String 1 -
    MVDC Integer 1 0
    MVTJJ Integer 1 0
    FIELD4 String 1 -
    MVDATO Integer 6 0
    MVNUOP Integer 7 0
    TYPEG String 2 -
    MVASTE String 1 -

    there are the same if you have an idea it's great!!

    thanks

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

    Default

    Talk to your DBA ... "SQL7008 is most of the time caused by trying to update a file that is not journaled or you do not have authority to its journal. Journal the file using command STRJRNPF (files on iSeries are not automatically journaled unless defined by using SQL).

    If the file is created by you on a libray it is not auto-journaled, try to create the file in a schema (i.e create schema "myschema" and create table in "myschema"). "

    You need some extra options activated on the AS400 side on that table.

    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.