" /> Issue installing ETL against Oracle - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Issue installing ETL against Oracle  (Read 5237 times)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Issue installing ETL against Oracle
« on: January 16, 2014, 01:54:06 PM »
Advertisement
Hi guys,
I'm doing a fresh installation of ETL 7.6.100.08 on Windows against an Oracle 11g.
As usual run the script create_db.bat (tables created)
However, after that, when running ETL service it shows an error like if it is trying to recreate the tables again...

[quote]
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 15:41:00.830 Main ETL Runtime, Version: 7.6.100.08, Build: 2012/01/07 12:34 (C) Copyright 1994-2010 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only: 15:41:01.110 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Java\jre1.5.0_22\bin, java.vm.version=1.5.0_22-b03, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=BR, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files (x86)\GCTI\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.5.0_22-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Java\jre1.5.0_22\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Windows\TEMP\, line.separator=<CR><LF>, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows Server 2008 R2, sun.jnu.encoding=Cp1252, java.library.path=C:\Windows\SysWOW64;.;C:\Windows\system32;C:\Windows;C:\oracle\app\product\11.2.0\client_1\bin\bin;C:\oracle\app\product\11.2.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Java\jdk1.5.0_22\jre\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\, user.timezone=America/Sao_Paulo, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, java.class.path=transform.jar, user.name=GRUMIUM1$, java.vm.specification.version=1.0, java.home=C:\Java\jre1.5.0_22, sun.arch.data.model=32, user.language=pt, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.5.0_22, java.ext.dirs=C:\Java\jre1.5.0_22\lib\ext, sun.boot.class.path=C:\Java\jre1.5.0_22\lib\rt.jar;C:\Java\jre1.5.0_22\lib\i18n.jar;C:\Java\jre1.5.0_22\lib\sunrsasign.jar;C:\Java\jre1.5.0_22\lib\jsse.jar;C:\Java\jre1.5.0_22\lib\jce.jar;C:\Java\jre1.5.0_22\lib\charsets.jar;C:\Java\jre1.5.0_22\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
ETL_Trans_Only: 15:41:01.110 Main.Options Options: {user=GENESYS_DM, dba_pass=*****, CfgUser=default, CfgAppName=ETL_Proxy, CfgUserPassword=password, CfgAppPassword=, dropTransferredTables=, pass=*****, dba_user=GENESYS_DM, jdbcurl=jdbc:oracle:thin:@10.23.14.3:1521:genesysdb}
ETL_Trans_Only: 15:41:01.266 Main TRANSFORM started
ETL_Trans_Only: 15:41:02.280 SqlExec processing: sql/upgrade_ORACLE_.sql
ETL_Trans_Only: 15:41:02.296 SqlExec exception during execution of: create table PURGING_LOG (    PURGE_ID            NUMBER                not null,    REP_VIEW_ID        INTEGER                not null,    PURGE_START_TIME    DATE                  not null,    PURGE_END_TIME      DATE                  null    ,    PURGE_TILL_TIME    DATE                  not null,    NUM_OF_FACT_ROWS    NUMBER                null    ,    constraint PK_PURGING_LOG primary key (PURGE_ID) )
ETL_Trans_Only: 15:41:02.296 SqlExec location: file sql/upgrade_ORACLE_.sql
ETL_Trans_Only: 15:41:02.296 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only: 15:41:02.296 Main Stack Trace:
ETL_Trans_Only: 15:41:02.296 Main common.TransformError: Error during upgrade
ETL_Trans_Only: 15:41:02.296 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:172)
ETL_Trans_Only: 15:41:02.296 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 15:41:02.296 Main at ETL.Transformer.main(Transformer.java:200)
ETL_Trans_Only: 15:41:02.296 Main Caused by:
ETL_Trans_Only: 15:41:02.296 Main SQLState: 42000
ETL_Trans_Only: 15:41:02.296 Main Vendor:  955
ETL_Trans_Only: 15:41:02.296 Main Stack Trace:
ETL_Trans_Only: 15:41:02.296 Main java.sql.SQLException: ORA-00955: name is already used by an existing object
ETL_Trans_Only:
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
ETL_Trans_Only: 15:41:02.296 Main at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
ETL_Trans_Only: 15:41:02.296 Main at ETL.SqlExec.executeOne(SqlExec.java:93)
ETL_Trans_Only: 15:41:02.296 Main at ETL.SqlExec.executeAll(SqlExec.java:51)
ETL_Trans_Only: 15:41:02.296 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:153)
ETL_Trans_Only: 15:41:02.296 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 15:41:02.296 Main at ETL.Transformer.main(Transformer.java:200)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2014-01-13 15:41:02 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 3
[/quote]


If I drop the tables then I get a message (obviously) that tables do not exist...

[quote]
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 11:50:00.551 Main ETL Runtime, Version: 7.6.100.08, Build: 2012/01/07 12:34 (C) Copyright 1994-2010 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only: 11:50:00.551 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Java\jre1.5.0_22\bin, java.vm.version=1.5.0_22-b03, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=BR, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files (x86)\GCTI\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.5.0_22-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Java\jre1.5.0_22\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Windows\TEMP\, line.separator=<CR><LF>, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows Server 2008 R2, sun.jnu.encoding=Cp1252, java.library.path=C:\Windows\SysWOW64;.;C:\Windows\system32;C:\Windows;C:\oracle\app\product\11.2.0\client_1\bin\bin;C:\oracle\app\product\11.2.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Java\jdk1.5.0_22\jre\bin;, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=6.1, user.home=C:\, user.timezone=America/Sao_Paulo, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, java.class.path=transform.jar, user.name=GRUMIUM1$, java.vm.specification.version=1.0, java.home=C:\Java\jre1.5.0_22, sun.arch.data.model=32, user.language=pt, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.5.0_22, java.ext.dirs=C:\Java\jre1.5.0_22\lib\ext, sun.boot.class.path=C:\Java\jre1.5.0_22\lib\rt.jar;C:\Java\jre1.5.0_22\lib\i18n.jar;C:\Java\jre1.5.0_22\lib\sunrsasign.jar;C:\Java\jre1.5.0_22\lib\jsse.jar;C:\Java\jre1.5.0_22\lib\jce.jar;C:\Java\jre1.5.0_22\lib\charsets.jar;C:\Java\jre1.5.0_22\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
ETL_Trans_Only: 11:50:00.551 Main.Options Options: {user=GENESYS_DM, dba_pass=*****, CfgUser=default, CfgAppName=ETL_Proxy, CfgUserPassword=password, CfgAppPassword=, dropTransferredTables=, pass=*****, dba_user=GENESYS_DM, jdbcurl=jdbc:oracle:thin:@10.23.14.3:1521:genesysdb}
ETL_Trans_Only: 11:50:00.707 Main TRANSFORM started
ETL_Trans_Only: 11:50:01.767 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only: 11:50:01.767 Main Stack Trace:
ETL_Trans_Only: 11:50:01.767 Main common.TransformError: Error during upgrade
ETL_Trans_Only: 11:50:01.767 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:172)
ETL_Trans_Only: 11:50:01.767 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:50:01.767 Main at ETL.Transformer.main(Transformer.java:200)
ETL_Trans_Only: 11:50:01.767 Main Caused by:
ETL_Trans_Only: 11:50:01.767 Main SQLState: 42000
ETL_Trans_Only: 11:50:01.767 Main Vendor:  942
ETL_Trans_Only: 11:50:01.767 Main Stack Trace:
ETL_Trans_Only: 11:50:01.767 Main java.sql.SQLException: ORA-00942: table or view does not exist
ETL_Trans_Only:
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:852)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1477)
ETL_Trans_Only: 11:50:01.767 Main at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:392)
ETL_Trans_Only: 11:50:01.767 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:137)
ETL_Trans_Only: 11:50:01.767 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:50:01.767 Main at ETL.Transformer.main(Transformer.java:200)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2014-01-16 11:50:01 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 3
[/quote]


What am I missing here?

Permissions for user is all, can create/delete/etc...
Logged

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Issue installing ETL against Oracle
« Reply #1 on: January 16, 2014, 02:34:12 PM »
And all database objects (tables,view, indexes) were created properly during running create_db script? What about tablespace, are there free space? Are required roles and permission granted to the DM database account?

I always run the create_db script just once at the start of deployment and afterthat I always change DB credentials in this script.
« Last Edit: January 16, 2014, 02:56:05 PM by Kubig »
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Issue installing ETL against Oracle
« Reply #2 on: January 16, 2014, 04:23:33 PM »
Yeah, no errors. I can create tables manually with that user, so permissions is not an issue...
Logged

Offline Timur Karimov

  • Sr. Member
  • ****
  • Posts: 415
  • Karma: 2
Re: Issue installing ETL against Oracle
« Reply #3 on: January 17, 2014, 08:35:04 AM »
Hi there
"I'm doing a fresh installation of ETL    7.6.100.08 on Windows against an Oracle 11g."
So -  It's realy new fresh install? I mean  - no prevision version of ETL is running agains it's Oracle DB Server ?
WBR Tim
Logged

Offline Fra

  • Hero Member
  • *****
  • Posts: 856
  • Karma: -3
Re: Issue installing ETL against Oracle
« Reply #4 on: January 17, 2014, 10:22:27 AM »
I'm on the same page of Timur's: can you check whether the DM_VALUE field of the DM_PROPERTY table exists / contains any value?

Fra
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Issue installing ETL against Oracle
« Reply #5 on: January 17, 2014, 05:45:46 PM »
Yep,
100% sure guys.
New DB, new Genesys, fresh install...no upgrade no nothing no migration.
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Issue installing ETL against Oracle
« Reply #6 on: January 17, 2014, 08:05:39 PM »
Double checks and yes, tables are empty
Logged

Offline genesysguru

  • Sr. Member
  • ****
  • Posts: 293
  • Karma: 12
    • Genesys Guru Blog
Re: Issue installing ETL against Oracle
« Reply #7 on: January 18, 2014, 09:57:51 AM »
Mmm ... looks like time for some hacking! My next step would be to review contents of upgrade_ORACLE_.sql and if your existing PURGING_LOG table matches just delete the bit where it tries to recreate it and restart ETL.
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Issue installing ETL against Oracle
« Reply #8 on: January 20, 2014, 12:56:34 PM »
Yeah, being doing that but no luck yet on finding the upgrade_ORACLE_.sql, any clue where it could be created?
I have been deleting the tables and allowing Transform to create them but I think is not the best way because if later we do an upgrade will have to do the same thing again...so my goal is to find the exact root cause for this strange behavior. On this scenario this works but I do know it is not OK at all.
Logged

Offline Fra

  • Hero Member
  • *****
  • Posts: 856
  • Karma: -3
Re: Issue installing ETL against Oracle
« Reply #9 on: January 20, 2014, 02:44:13 PM »
In the ETL_runtime folder, locate transform.jar.
Open it up and you'll find the upgrade_ORACLE_.sql in the sql folder.

Fra
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Issue installing ETL against Oracle
« Reply #10 on: January 20, 2014, 03:48:53 PM »
[quote author=Fra link=topic=8173.msg35996#msg35996 date=1390229053]
In the ETL_runtime folder, locate transform.jar.
Open it up and you'll find the upgrade_ORACLE_.sql in the sql folder.

Fra
[/quote]

Nice!
Logged
Pages: [1]   Go Up
« previous next »