Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: cavagnaro on January 16, 2014, 01:54:06 PM
-
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...
-
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.
-
Yeah, no errors. I can create tables manually with that user, so permissions is not an issue...
-
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
-
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
-
Yep,
100% sure guys.
New DB, new Genesys, fresh install...no upgrade no nothing no migration.
-
Double checks and yes, tables are empty
-
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.
-
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.
-
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 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!