Loading ...
Sorry, an error occurred while loading the content.

OWB Runtime Assitant Problem (release 9.2)

Expand Messages
  • ryevenes_2000
    Hi Friends, I have a follow problem when i try to create a Runtime Repository with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i): - I put all data
    Message 1 of 8 , May 27, 2004
    • 0 Attachment
      Hi Friends,

      I have a follow problem when i try to create a Runtime Repository
      with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i):

      - I put all data that the wizard ask me, so in the process to
      create the repository OWB Runtime Assitant Crash on 60% .... I look
      the log in \owb\rtasst\log.txt.0 file and the java trace is:

      =========== enter file: ../../rtasst/wb_rt_seed_service_nodes.sql
      oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
      PL/SQL: numeric or value error: character to number conversion error
      oracle.wh.util.DebugUtility: ORA-06512:
      at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
      oracle.wh.util.DebugUtility: ORA-06512: at line 19
      oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
      PL/SQL: numeric or value error: character to number conversion error
      oracle.wh.util.DebugUtility: ORA-06512:
      at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
      oracle.wh.util.DebugUtility: ORA-06512: at line 19
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1744)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1905)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.driver.OracleStatement.executeNonQuery
      (OracleStatement.java:2132)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.driver.OracleStatement.doExecuteOther
      (OracleStatement.java:2015)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
      (OracleStatement.java:2877)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
      (OraclePreparedStatement.java:608)
      oracle.wh.util.DebugUtility: at
      oracle.jdbc.driver.OraclePreparedStatement.execute
      (OraclePreparedStatement.java:684)
      oracle.wh.util.DebugUtility: at
      oracle.wh.ui.install.reposinst.RuntimeInstaller.runSqlScript
      (RuntimeInstaller.java:364)
      oracle.wh.util.DebugUtility: at
      oracle.wh.ui.install.reposinst.ReposInstMain.processSQLToken
      (ReposInstMain.java:2592)
      oracle.wh.util.DebugUtility: at
      oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile
      (ReposInstMain.java:2326)
      oracle.wh.util.DebugUtility: at
      oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask
      (ReposInstMain.java:1824)
      oracle.wh.util.DebugUtility: at
      oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
      oracle.wh.util.DebugUtility: at
      oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
      oracle.wh.util.DebugUtility: at
      oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
      oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.doRun
      (Unknown Source)
      oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.run(Unknown
      Source)
      oracle.wh.util.DebugUtility: at java.lang.Thread.run
      (Thread.java:484)


      Thanks in advance for any help or idea,
      Rodrigo
    • robgof
      Try to modify the Regional Settings Language to English (United States) on the OWB Client or on the Windows settings. ...maybe run!! Roberto. ... Repository
      Message 2 of 8 , May 28, 2004
      • 0 Attachment
        Try to modify the Regional Settings Language to English (United
        States) on the OWB Client or on the Windows settings.

        ...maybe run!!

        Roberto.


        --- In OracleWarehouseBuilder@yahoogroups.com, "ryevenes_2000"
        <ryevenes@h...> wrote:
        > Hi Friends,
        >
        > I have a follow problem when i try to create a Runtime
        Repository
        > with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i):
        >
        > - I put all data that the wizard ask me, so in the process to
        > create the repository OWB Runtime Assitant Crash on 60% .... I
        look
        > the log in \owb\rtasst\log.txt.0 file and the java trace is:
        >
        > =========== enter
        file: ../../rtasst/wb_rt_seed_service_nodes.sql
        > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
        > PL/SQL: numeric or value error: character to number conversion
        error
        > oracle.wh.util.DebugUtility: ORA-06512:
        > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
        > oracle.wh.util.DebugUtility: ORA-06512: at line 19
        > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
        > PL/SQL: numeric or value error: character to number conversion
        error
        > oracle.wh.util.DebugUtility: ORA-06512:
        > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
        > oracle.wh.util.DebugUtility: ORA-06512: at line 19
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1744)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch
        (OCIDBAccess.java:1905)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.driver.OracleStatement.executeNonQuery
        > (OracleStatement.java:2132)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.driver.OracleStatement.doExecuteOther
        > (OracleStatement.java:2015)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
        > (OracleStatement.java:2877)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
        > (OraclePreparedStatement.java:608)
        > oracle.wh.util.DebugUtility: at
        > oracle.jdbc.driver.OraclePreparedStatement.execute
        > (OraclePreparedStatement.java:684)
        > oracle.wh.util.DebugUtility: at
        > oracle.wh.ui.install.reposinst.RuntimeInstaller.runSqlScript
        > (RuntimeInstaller.java:364)
        > oracle.wh.util.DebugUtility: at
        > oracle.wh.ui.install.reposinst.ReposInstMain.processSQLToken
        > (ReposInstMain.java:2592)
        > oracle.wh.util.DebugUtility: at
        > oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile
        > (ReposInstMain.java:2326)
        > oracle.wh.util.DebugUtility: at
        > oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask
        > (ReposInstMain.java:1824)
        > oracle.wh.util.DebugUtility: at
        > oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
        > oracle.wh.util.DebugUtility: at
        > oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
        > oracle.wh.util.DebugUtility: at
        > oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
        > oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.doRun
        > (Unknown Source)
        > oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.run
        (Unknown
        > Source)
        > oracle.wh.util.DebugUtility: at java.lang.Thread.run
        > (Thread.java:484)
        >
        >
        > Thanks in advance for any help or idea,
        > Rodrigo
      • hiranya_sen
        Hi Can u tell me the Oracle 9i version, if it is 9.2.0.1 then u have to upgrade the database to 9.2.0.4 before u install the OWB Runtime. There is a patch
        Message 3 of 8 , May 28, 2004
        • 0 Attachment
          Hi

          Can u tell me the Oracle 9i version, if it is 9.2.0.1 then u have
          to upgrade the database to 9.2.0.4 before u install the OWB Runtime.
          There is a patch called Oracle 9.2.0.4 (about 250 MB) for this.U can
          download it from Oracle site.
          I think this can be the problem.

          Thanks
          Hiranya.


          --- In OracleWarehouseBuilder@yahoogroups.com, "robgof"
          <robgof@l...> wrote:
          > Try to modify the Regional Settings Language to English (United
          > States) on the OWB Client or on the Windows settings.
          >
          > ...maybe run!!
          >
          > Roberto.
          >
          >
          > --- In OracleWarehouseBuilder@yahoogroups.com, "ryevenes_2000"
          > <ryevenes@h...> wrote:
          > > Hi Friends,
          > >
          > > I have a follow problem when i try to create a Runtime
          > Repository
          > > with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i):
          > >
          > > - I put all data that the wizard ask me, so in the process to
          > > create the repository OWB Runtime Assitant Crash on 60% .... I
          > look
          > > the log in \owb\rtasst\log.txt.0 file and the java trace is:
          > >
          > > =========== enter
          > file: ../../rtasst/wb_rt_seed_service_nodes.sql
          > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
          > > PL/SQL: numeric or value error: character to number conversion
          > error
          > > oracle.wh.util.DebugUtility: ORA-06512:
          > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
          > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
          > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
          > > PL/SQL: numeric or value error: character to number conversion
          > error
          > > oracle.wh.util.DebugUtility: ORA-06512:
          > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
          > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1744)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch
          > (OCIDBAccess.java:1905)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.driver.OracleStatement.executeNonQuery
          > > (OracleStatement.java:2132)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.driver.OracleStatement.doExecuteOther
          > > (OracleStatement.java:2015)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
          > > (OracleStatement.java:2877)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
          > > (OraclePreparedStatement.java:608)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.jdbc.driver.OraclePreparedStatement.execute
          > > (OraclePreparedStatement.java:684)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.wh.ui.install.reposinst.RuntimeInstaller.runSqlScript
          > > (RuntimeInstaller.java:364)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.wh.ui.install.reposinst.ReposInstMain.processSQLToken
          > > (ReposInstMain.java:2592)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile
          > > (ReposInstMain.java:2326)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask
          > > (ReposInstMain.java:1824)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
          > > oracle.wh.util.DebugUtility: at
          > > oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
          > > oracle.wh.util.DebugUtility: at
          oracle.ewt.timer.Timer.doRun
          > > (Unknown Source)
          > > oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.run
          > (Unknown
          > > Source)
          > > oracle.wh.util.DebugUtility: at java.lang.Thread.run
          > > (Thread.java:484)
          > >
          > >
          > > Thanks in advance for any help or idea,
          > > Rodrigo
        • ryevenes_2000
          Thanks Hiranya, Roberto ... Roberto: I did modify the regional settings but this not work ... Hiranya: my oracle version is 9.2.0.1 and run on Windows 2000
          Message 4 of 8 , May 28, 2004
          • 0 Attachment
            Thanks Hiranya, Roberto ...

            Roberto: I did modify the regional settings but this not work ...

            Hiranya: my oracle version is 9.2.0.1 and run on Windows 2000
            Proffesional Edition. I did try to download the patch for upgrade to
            9.2.0.4, but i don't have account for metalink site, and this site
            requires CIS support ID ....

            you know another site for download the patch ??? ...

            thanks in advance ....

            --- In OracleWarehouseBuilder@yahoogroups.com, hiranya_sen
            <no_reply@y...> wrote:
            > Hi
            >
            > Can u tell me the Oracle 9i version, if it is 9.2.0.1 then u have
            > to upgrade the database to 9.2.0.4 before u install the OWB Runtime.
            > There is a patch called Oracle 9.2.0.4 (about 250 MB) for this.U
            can
            > download it from Oracle site.
            > I think this can be the problem.
            >
            > Thanks
            > Hiranya.
            >
            >
            > --- In OracleWarehouseBuilder@yahoogroups.com, "robgof"
            > <robgof@l...> wrote:
            > > Try to modify the Regional Settings Language to English (United
            > > States) on the OWB Client or on the Windows settings.
            > >
            > > ...maybe run!!
            > >
            > > Roberto.
            > >
            > >
            > > --- In OracleWarehouseBuilder@yahoogroups.com, "ryevenes_2000"
            > > <ryevenes@h...> wrote:
            > > > Hi Friends,
            > > >
            > > > I have a follow problem when i try to create a Runtime
            > > Repository
            > > > with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i):
            > > >
            > > > - I put all data that the wizard ask me, so in the process to
            > > > create the repository OWB Runtime Assitant Crash on 60% .... I
            > > look
            > > > the log in \owb\rtasst\log.txt.0 file and the java trace is:
            > > >
            > > > =========== enter
            > > file: ../../rtasst/wb_rt_seed_service_nodes.sql
            > > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
            > > > PL/SQL: numeric or value error: character to number conversion
            > > error
            > > > oracle.wh.util.DebugUtility: ORA-06512:
            > > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
            > > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
            > > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-06502:
            > > > PL/SQL: numeric or value error: character to number conversion
            > > error
            > > > oracle.wh.util.DebugUtility: ORA-06512:
            > > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
            > > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1744)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch
            > > (OCIDBAccess.java:1905)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.driver.OracleStatement.executeNonQuery
            > > > (OracleStatement.java:2132)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.driver.OracleStatement.doExecuteOther
            > > > (OracleStatement.java:2015)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
            > > > (OracleStatement.java:2877)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
            > > > (OraclePreparedStatement.java:608)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.jdbc.driver.OraclePreparedStatement.execute
            > > > (OraclePreparedStatement.java:684)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.wh.ui.install.reposinst.RuntimeInstaller.runSqlScript
            > > > (RuntimeInstaller.java:364)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.wh.ui.install.reposinst.ReposInstMain.processSQLToken
            > > > (ReposInstMain.java:2592)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile
            > > > (ReposInstMain.java:2326)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask
            > > > (ReposInstMain.java:1824)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
            > > > oracle.wh.util.DebugUtility: at
            > > > oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
            > > > oracle.wh.util.DebugUtility: at
            > oracle.ewt.timer.Timer.doRun
            > > > (Unknown Source)
            > > > oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.run
            > > (Unknown
            > > > Source)
            > > > oracle.wh.util.DebugUtility: at java.lang.Thread.run
            > > > (Thread.java:484)
            > > >
            > > >
            > > > Thanks in advance for any help or idea,
            > > > Rodrigo
          • Fahd Saeed
            I m loading some flat files using OWB9.2 s Flat File Wizard. I m looking at the ctl file it generates and it dosnt write TRAILING NULLCOLS and thus caused my
            Message 5 of 8 , May 28, 2004
            • 0 Attachment
              I'm loading some flat files using OWB9.2's Flat File Wizard. I'm looking
              at the ctl file it generates and it dosnt write TRAILING NULLCOLS and
              thus caused my map execution process to crash with the following error:

              Record 15: Rejected - Error on table "DUP"."PERSONADDRESS", column
              FILLER_PERSON_UNIT_NUMBER.
              Column not found before end of logical record (use TRAILING NULLCOLS)

              Below I have given two sample CTL files. One was written by me for
              SQLLOADER, the other was written using OWB's Flat File Wizard.

              My question is where in OWB's Flat File Wizard does it indicate to use
              TRAILING NULLCOLS like the above error suggest I do. I tried manually
              entering that line in the OWB generated CTL file but when I execute the
              map the CTL is generated again and it reverts back to the orignal file
              with that TRAILING NULLCOLS omission.

              Any help would be much appreciated. Also everyone enjoy your 3day
              weekend. Thanks in advance.

              -Fahd

              --======================================
              --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
              --======================================

              LOAD DATA
              INFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.txt'
              BADFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.bad'
              DISCARDFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.dsc'

              INSERT
              INTO TABLE "V_DESCHUTES"
              FIELDS TERMINATED BY X'9'
              TRAILING NULLCOLS
              (PERSONID,
              FIRSTNAME,
              MIDDLENAME,
              LASTNAME,
              SUFFIXNAME,
              DOB DATE "MM/DD/YYYY",
              RES_STREETNUM,
              RES_SUFFIXNUM,
              RES_PREDIR,
              RES_STREETNAME,
              RES_STREETTYPE,
              RES_POSTDIR,
              RES_UNITNUM,
              RES_UNITTYPE,
              RES_CITY,
              RES_ZIP,
              RES_ZIPPLUS,
              DIST1,
              DIST2,
              DIST3,
              DIST4,
              DIST5,
              DIST6,
              DIST7,
              DIST8,
              DIST9,
              DIST10,
              DIST11,
              DIST12,
              DIST13,
              DIST14,
              DIST15,
              DIST16,
              DIST17
              )
              --======================================
              --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
              --======================================



              --
              /***********************************************************************
              *****
              -- Oracle Warehouse Builder
              -- Generator Version : 9.2.0.2.8
              -- Created Date : Fri May 28 16:03:57 PDT 2004
              -- Modified Date : Fri May 28 16:03:57 PDT 2004
              -- Created By : repoass
              -- Modified By : repoass
              -- Generated Object Type : SQL*Loader Control File
              -- Generated Object Name : JUNE_GILLIAM_TST

              -- C 2003 Oracle Corporation. All Rights Reserved.
              --
              ************************************************************************
              ****/

              OPTIONS ( ERRORS=50, BINDSIZE=50000, ROWS=200, READSIZE=65536)
              LOAD DATA
              CHARACTERSET WE8MSWIN1252
              INFILE 'D:\OCVR\JuneFlatFiles\gilliam_dup2.txt'
              INTO TABLE "DUP"."PERSONADDRESS"
              APPEND
              REENABLE DISABLED_CONSTRAINTS

              FIELDS
              TERMINATED BY X'09'
              OPTIONALLY ENCLOSED BY '"'

              (
              "OLD_PERSON_ID" POSITION (1) CHAR ,
              "FIRSTNAME" CHAR ,
              "MIDDLENAME" CHAR ,
              "LASTNAME" CHAR ,
              "SUFFIXNAME" CHAR ,
              "BIRTHDATE" CHAR ,
              "REGDATE" CHAR ,
              FILLER_PERSON_STREET_NUMBER FILLER CHAR ,
              FILLER_PERSON_STREET_NUMBER_SFX FILLER CHAR ,
              FILLER_PERSON_PRE_DIRECTION FILLER CHAR ,
              FILLER_PERSON_NAME FILLER CHAR ,
              FILLER_PERSON_STREET_TYPE FILLER CHAR ,
              FILLER_PERSON_POST_DIRECTION FILLER CHAR ,
              FILLER_PERSON_UNIT_NUMBER FILLER CHAR ,
              FILLER_PERSON_UNIT_TYPE FILLER CHAR ,
              FILLER_City FILLER CHAR ,
              FILLER_ZIP_LEFT FILLER INTEGER EXTERNAL ,
              FILLER_ZIP_RIGHT FILLER CHAR ,
              FILLER_Precinct_# FILLER CHAR ,
              FILLER_DISTRICT_NUMBER FILLER CHAR ,
              "COUNTY_ID" CONSTANT 11,
              "NEW_PERSON_ID" EXPRESSION "DUP_VOTERID.NEXTVAL"
              )






              [Non-text portions of this message have been removed]
            • ryevenes_2000
              Friends, Thanks for all yor help, the problem is solved with the OWB10g version. Regards, Rodrigo ... to ... have ... Runtime. ... to ... I ... conversion ...
              Message 6 of 8 , May 28, 2004
              • 0 Attachment
                Friends,

                Thanks for all yor help, the problem is solved with the OWB10g
                version.

                Regards,
                Rodrigo

                --- In OracleWarehouseBuilder@yahoogroups.com, "ryevenes_2000"
                <ryevenes@h...> wrote:
                > Thanks Hiranya, Roberto ...
                >
                > Roberto: I did modify the regional settings but this not work ...
                >
                > Hiranya: my oracle version is 9.2.0.1 and run on Windows 2000
                > Proffesional Edition. I did try to download the patch for upgrade
                to
                > 9.2.0.4, but i don't have account for metalink site, and this site
                > requires CIS support ID ....
                >
                > you know another site for download the patch ??? ...
                >
                > thanks in advance ....
                >
                > --- In OracleWarehouseBuilder@yahoogroups.com, hiranya_sen
                > <no_reply@y...> wrote:
                > > Hi
                > >
                > > Can u tell me the Oracle 9i version, if it is 9.2.0.1 then u
                have
                > > to upgrade the database to 9.2.0.4 before u install the OWB
                Runtime.
                > > There is a patch called Oracle 9.2.0.4 (about 250 MB) for this.U
                > can
                > > download it from Oracle site.
                > > I think this can be the problem.
                > >
                > > Thanks
                > > Hiranya.
                > >
                > >
                > > --- In OracleWarehouseBuilder@yahoogroups.com, "robgof"
                > > <robgof@l...> wrote:
                > > > Try to modify the Regional Settings Language to English (United
                > > > States) on the OWB Client or on the Windows settings.
                > > >
                > > > ...maybe run!!
                > > >
                > > > Roberto.
                > > >
                > > >
                > > > --- In OracleWarehouseBuilder@yahoogroups.com, "ryevenes_2000"
                > > > <ryevenes@h...> wrote:
                > > > > Hi Friends,
                > > > >
                > > > > I have a follow problem when i try to create a Runtime
                > > > Repository
                > > > > with the OWB Runtime Assitant (release 9.2, Oracle DB is 9i):
                > > > >
                > > > > - I put all data that the wizard ask me, so in the process
                to
                > > > > create the repository OWB Runtime Assitant Crash on 60% ....
                I
                > > > look
                > > > > the log in \owb\rtasst\log.txt.0 file and the java trace is:
                > > > >
                > > > > =========== enter
                > > > file: ../../rtasst/wb_rt_seed_service_nodes.sql
                > > > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-
                06502:
                > > > > PL/SQL: numeric or value error: character to number
                conversion
                > > > error
                > > > > oracle.wh.util.DebugUtility: ORA-06512:
                > > > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
                > > > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
                > > > > oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-
                06502:
                > > > > PL/SQL: numeric or value error: character to number
                conversion
                > > > error
                > > > > oracle.wh.util.DebugUtility: ORA-06512:
                > > > > at "OWBRUN.WB_RT_INTEGER_VERSION_NUMBER", line 15
                > > > > oracle.wh.util.DebugUtility: ORA-06512: at line 19
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.dbaccess.DBError.throwSqlException
                (DBError.java:134)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.oci8.OCIDBAccess.check_error
                (OCIDBAccess.java:2337)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.oci8.OCIDBAccess.executeFetch
                (OCIDBAccess.java:1744)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch
                > > > (OCIDBAccess.java:1905)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.driver.OracleStatement.executeNonQuery
                > > > > (OracleStatement.java:2132)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.driver.OracleStatement.doExecuteOther
                > > > > (OracleStatement.java:2015)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
                > > > > (OracleStatement.java:2877)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
                > > > > (OraclePreparedStatement.java:608)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.jdbc.driver.OraclePreparedStatement.execute
                > > > > (OraclePreparedStatement.java:684)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.wh.ui.install.reposinst.RuntimeInstaller.runSqlScript
                > > > > (RuntimeInstaller.java:364)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.wh.ui.install.reposinst.ReposInstMain.processSQLToken
                > > > > (ReposInstMain.java:2592)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile
                > > > > (ReposInstMain.java:2326)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask
                > > > > (ReposInstMain.java:1824)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
                > > > > oracle.wh.util.DebugUtility: at
                > > > > oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
                > > > > oracle.wh.util.DebugUtility: at
                > > oracle.ewt.timer.Timer.doRun
                > > > > (Unknown Source)
                > > > > oracle.wh.util.DebugUtility: at oracle.ewt.timer.Timer.run
                > > > (Unknown
                > > > > Source)
                > > > > oracle.wh.util.DebugUtility: at java.lang.Thread.run
                > > > > (Thread.java:484)
                > > > >
                > > > >
                > > > > Thanks in advance for any help or idea,
                > > > > Rodrigo
              • kamal kamal
                hi saeed we can set trailing null columns while configuring the mapping for SQL loader. after the mapping is done go to the project and right clik on the map.
                Message 7 of 8 , May 28, 2004
                • 0 Attachment
                  hi saeed

                  we can set trailing null columns while configuring the mapping for SQL loader.
                  after the mapping is done
                  go to the project and right clik on the map.
                  then click configure
                  then go to sources and targets at the bottom and then open sql loader properties and there u can set trailing null columns...

                  hope this helps
                  kamal

                  Fahd Saeed <fsaeed@...> wrote:
                  I'm loading some flat files using OWB9.2's Flat File Wizard. I'm looking
                  at the ctl file it generates and it dosnt write TRAILING NULLCOLS and
                  thus caused my map execution process to crash with the following error:

                  Record 15: Rejected - Error on table "DUP"."PERSONADDRESS", column
                  FILLER_PERSON_UNIT_NUMBER.
                  Column not found before end of logical record (use TRAILING NULLCOLS)

                  Below I have given two sample CTL files. One was written by me for
                  SQLLOADER, the other was written using OWB's Flat File Wizard.

                  My question is where in OWB's Flat File Wizard does it indicate to use
                  TRAILING NULLCOLS like the above error suggest I do. I tried manually
                  entering that line in the OWB generated CTL file but when I execute the
                  map the CTL is generated again and it reverts back to the orignal file
                  with that TRAILING NULLCOLS omission.

                  Any help would be much appreciated. Also everyone enjoy your 3day
                  weekend. Thanks in advance.

                  -Fahd

                  --======================================
                  --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
                  --======================================

                  LOAD DATA
                  INFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.txt'
                  BADFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.bad'
                  DISCARDFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.dsc'

                  INSERT
                  INTO TABLE "V_DESCHUTES"
                  FIELDS TERMINATED BY X'9'
                  TRAILING NULLCOLS
                  (PERSONID,
                  FIRSTNAME,
                  MIDDLENAME,
                  LASTNAME,
                  SUFFIXNAME,
                  DOB DATE "MM/DD/YYYY",
                  RES_STREETNUM,
                  RES_SUFFIXNUM,
                  RES_PREDIR,
                  RES_STREETNAME,
                  RES_STREETTYPE,
                  RES_POSTDIR,
                  RES_UNITNUM,
                  RES_UNITTYPE,
                  RES_CITY,
                  RES_ZIP,
                  RES_ZIPPLUS,
                  DIST1,
                  DIST2,
                  DIST3,
                  DIST4,
                  DIST5,
                  DIST6,
                  DIST7,
                  DIST8,
                  DIST9,
                  DIST10,
                  DIST11,
                  DIST12,
                  DIST13,
                  DIST14,
                  DIST15,
                  DIST16,
                  DIST17
                  )
                  --======================================
                  --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
                  --======================================



                  --
                  /***********************************************************************
                  *****
                  -- Oracle Warehouse Builder
                  -- Generator Version : 9.2.0.2.8
                  -- Created Date : Fri May 28 16:03:57 PDT 2004
                  -- Modified Date : Fri May 28 16:03:57 PDT 2004
                  -- Created By : repoass
                  -- Modified By : repoass
                  -- Generated Object Type : SQL*Loader Control File
                  -- Generated Object Name : JUNE_GILLIAM_TST

                  -- C 2003 Oracle Corporation. All Rights Reserved.
                  --
                  ************************************************************************
                  ****/

                  OPTIONS ( ERRORS=50, BINDSIZE=50000, ROWS=200, READSIZE=65536)
                  LOAD DATA
                  CHARACTERSET WE8MSWIN1252
                  INFILE 'D:\OCVR\JuneFlatFiles\gilliam_dup2.txt'
                  INTO TABLE "DUP"."PERSONADDRESS"
                  APPEND
                  REENABLE DISABLED_CONSTRAINTS

                  FIELDS
                  TERMINATED BY X'09'
                  OPTIONALLY ENCLOSED BY '"'

                  (
                  "OLD_PERSON_ID" POSITION (1) CHAR ,
                  "FIRSTNAME" CHAR ,
                  "MIDDLENAME" CHAR ,
                  "LASTNAME" CHAR ,
                  "SUFFIXNAME" CHAR ,
                  "BIRTHDATE" CHAR ,
                  "REGDATE" CHAR ,
                  FILLER_PERSON_STREET_NUMBER FILLER CHAR ,
                  FILLER_PERSON_STREET_NUMBER_SFX FILLER CHAR ,
                  FILLER_PERSON_PRE_DIRECTION FILLER CHAR ,
                  FILLER_PERSON_NAME FILLER CHAR ,
                  FILLER_PERSON_STREET_TYPE FILLER CHAR ,
                  FILLER_PERSON_POST_DIRECTION FILLER CHAR ,
                  FILLER_PERSON_UNIT_NUMBER FILLER CHAR ,
                  FILLER_PERSON_UNIT_TYPE FILLER CHAR ,
                  FILLER_City FILLER CHAR ,
                  FILLER_ZIP_LEFT FILLER INTEGER EXTERNAL ,
                  FILLER_ZIP_RIGHT FILLER CHAR ,
                  FILLER_Precinct_# FILLER CHAR ,
                  FILLER_DISTRICT_NUMBER FILLER CHAR ,
                  "COUNTY_ID" CONSTANT 11,
                  "NEW_PERSON_ID" EXPRESSION "DUP_VOTERID.NEXTVAL"
                  )






                  [Non-text portions of this message have been removed]


                  Yahoo! Groups SponsorADVERTISEMENT


                  ---------------------------------
                  Yahoo! Groups Links

                  To visit your group on the web, go to:
                  http://groups.yahoo.com/group/OracleWarehouseBuilder/

                  To unsubscribe from this group, send an email to:
                  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

                  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



                  ---------------------------------
                  Do you Yahoo!?
                  Friends. Fun. Try the all-new Yahoo! Messenger

                  [Non-text portions of this message have been removed]
                • Fahd Saeed
                  kamal, that worked great. Thanks for your help. =) fahd ... From: kamal kamal [mailto:datawarekamal@yahoo.com] Sent: Friday, May 28, 2004 5:23 PM To:
                  Message 8 of 8 , Jun 1, 2004
                  • 0 Attachment
                    kamal, that worked great. Thanks for your help. =)

                    fahd


                    -----Original Message-----
                    From: kamal kamal [mailto:datawarekamal@...]
                    Sent: Friday, May 28, 2004 5:23 PM
                    To: OracleWarehouseBuilder@yahoogroups.com
                    Subject: Re: [OracleWarehouseBuilder] OWB FLAT FILES TRALING NULLCOLS


                    hi saeed

                    we can set trailing null columns while configuring the mapping for
                    SQL loader.
                    after the mapping is done
                    go to the project and right clik on the map.
                    then click configure
                    then go to sources and targets at the bottom and then open sql loader
                    properties and there u can set trailing null columns...

                    hope this helps
                    kamal

                    Fahd Saeed <fsaeed@...> wrote:
                    I'm loading some flat files using OWB9.2's Flat File Wizard. I'm looking
                    at the ctl file it generates and it dosnt write TRAILING NULLCOLS and
                    thus caused my map execution process to crash with the following error:

                    Record 15: Rejected - Error on table "DUP"."PERSONADDRESS", column
                    FILLER_PERSON_UNIT_NUMBER.
                    Column not found before end of logical record (use TRAILING NULLCOLS)

                    Below I have given two sample CTL files. One was written by me for
                    SQLLOADER, the other was written using OWB's Flat File Wizard.

                    My question is where in OWB's Flat File Wizard does it indicate to use
                    TRAILING NULLCOLS like the above error suggest I do. I tried manually
                    entering that line in the OWB generated CTL file but when I execute the
                    map the CTL is generated again and it reverts back to the orignal file
                    with that TRAILING NULLCOLS omission.

                    Any help would be much appreciated. Also everyone enjoy your 3day
                    weekend. Thanks in advance.

                    -Fahd

                    --======================================
                    --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
                    --======================================

                    LOAD DATA
                    INFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.txt'
                    BADFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.bad'
                    DISCARDFILE 'C:\DUPCHECK\Deschutes\Deschutes_20040113.dsc'

                    INSERT
                    INTO TABLE "V_DESCHUTES"
                    FIELDS TERMINATED BY X'9'
                    TRAILING NULLCOLS
                    (PERSONID,
                    FIRSTNAME,
                    MIDDLENAME,
                    LASTNAME,
                    SUFFIXNAME,
                    DOB DATE "MM/DD/YYYY",
                    RES_STREETNUM,
                    RES_SUFFIXNUM,
                    RES_PREDIR,
                    RES_STREETNAME,
                    RES_STREETTYPE,
                    RES_POSTDIR,
                    RES_UNITNUM,
                    RES_UNITTYPE,
                    RES_CITY,
                    RES_ZIP,
                    RES_ZIPPLUS,
                    DIST1,
                    DIST2,
                    DIST3,
                    DIST4,
                    DIST5,
                    DIST6,
                    DIST7,
                    DIST8,
                    DIST9,
                    DIST10,
                    DIST11,
                    DIST12,
                    DIST13,
                    DIST14,
                    DIST15,
                    DIST16,
                    DIST17
                    )
                    --======================================
                    --MANUALLY WRITTEN CTL FILE FOR SQLLOADER
                    --======================================



                    --
                    /***********************************************************************
                    *****
                    -- Oracle Warehouse Builder
                    -- Generator Version : 9.2.0.2.8
                    -- Created Date : Fri May 28 16:03:57 PDT 2004
                    -- Modified Date : Fri May 28 16:03:57 PDT 2004
                    -- Created By : repoass
                    -- Modified By : repoass
                    -- Generated Object Type : SQL*Loader Control File
                    -- Generated Object Name : JUNE_GILLIAM_TST

                    -- C 2003 Oracle Corporation. All Rights Reserved.
                    --
                    ************************************************************************
                    ****/

                    OPTIONS ( ERRORS=50, BINDSIZE=50000, ROWS=200, READSIZE=65536)
                    LOAD DATA
                    CHARACTERSET WE8MSWIN1252
                    INFILE 'D:\OCVR\JuneFlatFiles\gilliam_dup2.txt'
                    INTO TABLE "DUP"."PERSONADDRESS"
                    APPEND
                    REENABLE DISABLED_CONSTRAINTS

                    FIELDS
                    TERMINATED BY X'09'
                    OPTIONALLY ENCLOSED BY '"'

                    (
                    "OLD_PERSON_ID" POSITION (1) CHAR ,
                    "FIRSTNAME" CHAR ,
                    "MIDDLENAME" CHAR ,
                    "LASTNAME" CHAR ,
                    "SUFFIXNAME" CHAR ,
                    "BIRTHDATE" CHAR ,
                    "REGDATE" CHAR ,
                    FILLER_PERSON_STREET_NUMBER FILLER CHAR ,
                    FILLER_PERSON_STREET_NUMBER_SFX FILLER CHAR ,
                    FILLER_PERSON_PRE_DIRECTION FILLER CHAR ,
                    FILLER_PERSON_NAME FILLER CHAR ,
                    FILLER_PERSON_STREET_TYPE FILLER CHAR ,
                    FILLER_PERSON_POST_DIRECTION FILLER CHAR ,
                    FILLER_PERSON_UNIT_NUMBER FILLER CHAR ,
                    FILLER_PERSON_UNIT_TYPE FILLER CHAR ,
                    FILLER_City FILLER CHAR ,
                    FILLER_ZIP_LEFT FILLER INTEGER EXTERNAL ,
                    FILLER_ZIP_RIGHT FILLER CHAR ,
                    FILLER_Precinct_# FILLER CHAR ,
                    FILLER_DISTRICT_NUMBER FILLER CHAR ,
                    "COUNTY_ID" CONSTANT 11,
                    "NEW_PERSON_ID" EXPRESSION "DUP_VOTERID.NEXTVAL"
                    )






                    [Non-text portions of this message have been removed]


                    Yahoo! Groups SponsorADVERTISEMENT


                    ---------------------------------
                    Yahoo! Groups Links

                    To visit your group on the web, go to:
                    http://groups.yahoo.com/group/OracleWarehouseBuilder/

                    To unsubscribe from this group, send an email to:
                    OracleWarehouseBuilder-unsubscribe@yahoogroups.com

                    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



                    ---------------------------------
                    Do you Yahoo!?
                    Friends. Fun. Try the all-new Yahoo! Messenger

                    [Non-text portions of this message have been removed]



                    Yahoo! Groups Sponsor

                    ADVERTISEMENT

                    <http://rd.yahoo.com/SIG=1296o2s3b/M=295196.4901138.6071305.3001176/D=gr
                    oups/S=1705115368:HM/EXP=1085880204/A=2128215/R=0/SIG=10se96mf6/*http://
                    companion.yahoo.com> click here

                    <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
                    s/S=:HM/A=2128215/rand=191200110>


                    _____

                    Yahoo! Groups Links


                    * To visit your group on the web, go to:
                    http://groups.yahoo.com/group/OracleWarehouseBuilder/


                    * To unsubscribe from this group, send an email to:
                    OracleWarehouseBuilder-unsubscribe@yahoogroups.com
                    <mailto:OracleWarehouseBuilder-unsubscribe@yahoogroups.com?subject=Unsub
                    scribe>


                    * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
                    Service <http://docs.yahoo.com/info/terms/> .




                    [Non-text portions of this message have been removed]
                  Your message has been successfully submitted and would be delivered to recipients shortly.