Error in ETL

[arcoquel]

Hi all,

I have an error in the ETL:

Starter: Starting 'ETL_Trans_Only' on  Fri May 23 17:24:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -dropTransferredTables -setFirstDayOfWeek=2 -jdbcurl=jdbc:jtds:sqlserver://UIOCO10:1433;DatabaseName=DBDM -user=srv_genesys -passEncrypted=******"
Starter: Pipe 248 "\\.\pipe\023640000023159_CCA" and Event 92 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 248.
Starter: client connected to the pipe 248.
Starter: Fri May 23 17:24:00 2008 [ETL_Trans_Only] will be started on Fri May 23 17:25:00 2008 start in 60 seconds
ETL_Trans_Only*:* Time         Origin                     Message
ETL_Trans_Only*:* ------------ -------------------------- ----------------------------------------
ETL_Trans_Only*:* 17:24:01.001 Main ETL Runtime, Version: 7.2.002.02, Build: 2006/10/23 12:34 (C) Copyright 1994-2005 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only*:* 17:24:01.407 Main.Env Runtime info: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre1.6.0_03\bin, java.vm.version=1.6.0_03-b05, 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=EC, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=E:\Program Files\GCTI\DataMart\etl_runtime, java.runtime.version=1.6.0_03-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.6.0_03\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 2003, sun.jnu.encoding=Cp1252, java.library.path=C:\WINDOWS\system32;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.2, user.home=C:\WINDOWS\system32\config\systemprofile, user.timezone=GMT-05:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, java.class.path=transform.jar, user.name=SYSTEM, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre1.6.0_03, sun.arch.data.model=32, user.language=es, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_03, java.ext.dirs=C:\Program Files\Java\jre1.6.0_03\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.6.0_03\lib\resources.jar;C:\Program Files\Java\jre1.6.0_03\lib\rt.jar;C:\Program Files\Java\jre1.6.0_03\lib\sunrsasign.jar;C:\Program Files\Java\jre1.6.0_03\lib\jsse.jar;C:\Program Files\Java\jre1.6.0_03\lib\jce.jar;C:\Program Files\Java\jre1.6.0_03\lib\charsets.jar;C:\Program Files\Java\jre1.6.0_03\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*:* 17:24:01.407 Main.Options Options: {reverse_password=off, updateStatsForLevel0Views=, setFirstDayOfWeek=2, tenants_shortcut=off, updateStatsForTablesAndIndexes=, CfgUserPasswordEncrypted=CDF4EC815DB4C7D4, passEncrypted=38C72436BC1380ACA2CDEDEAB9D5644B, user=srv_genesys, dba_pass=*****, CfgUser=default, CfgAppName=ETL_Proxy, dropTransferredTables=, dba_user=, jdbcurl=jdbc:jtds:sqlserver://UIOCO10:1433;DatabaseName=DBDM}
ETL_Trans_Only*:* 17:24:01.423 Main TRANSFORM started
ETL_Trans_Only*:* 17:24:01.657 Write.Heartbeat Pulse: 2008/05/23, GMT-05:00, 900, 4.9M
ETL_Trans_Only*:* 17:24:01.720 LFolder Connected database: Microsoft SQL Server, version: 09.00.2047, driver: 1.2
ETL_Trans_Only*:* 17:24:02.001 LFolder views OK in LayoutFolder[l:1_1,f:1]
ETL_Trans_Only*:* 17:24:02.017 LFolder views OK in LayoutFolder[l:1_2,f:2]
ETL_Trans_Only*:* 17:24:02.032 LFolder views OK in LayoutFolder[l:1_4,f:41]
ETL_Trans_Only*:* 17:24:02.048 LFolder views OK in LayoutFolder[l:1_5,f:42]
ETL_Trans_Only*:* 17:24:02.048 LFolder views OK in LayoutFolder[l:1_6,f:81]
ETL_Trans_Only*:* 17:24:02.064 LFolder views OK in LayoutFolder[l:1_7,f:121]
ETL_Trans_Only*:* 17:24:02.064 LFolder views OK in LayoutFolder[l:1_8,f:122]
ETL_Trans_Only*:* 17:24:02.064 LFolder views OK in LayoutFolder[l:1_9,f:123]
ETL_Trans_Only*:* 17:24:02.079 LFolder views OK in LayoutFolder[l:1_10,f:124]
ETL_Trans_Only*:* 17:24:02.079 LFolder views OK in LayoutFolder[l:1_11,f:125]
ETL_Trans_Only*:* 17:24:02.095 LFolder views OK in LayoutFolder[l:1_12,f:126]
ETL_Trans_Only*:* 17:24:02.095 LFolder views OK in LayoutFolder[l:1_13,f:161]
ETL_Trans_Only*:* 17:24:02.110 LFolder views OK in LayoutFolder[l:1_14,f:162]
ETL_Trans_Only*:* 17:24:02.110 LFolder views OK in LayoutFolder[l:1_16,f:163]
ETL_Trans_Only*:* 17:24:02.126 LFolder views OK in LayoutFolder[l:1_17,f:164]
ETL_Trans_Only*:* 17:24:02.142 Source.SourceDef starting monitoring: DatabaseAccessPoint[ name:source#1, ConnectObject[ url:jdbc:jtds:sqlserver://UIOCO10:1433;DatabaseName=DBODS, user: srv_genesys, pass: ***** ] ], Database: Microsoft SQL Server, Version: 09.00.2047, Driver: 1.2
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for RP_DHL_1
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for GRAGS_DHL
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for ROUTEPOINT
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for QUEUE
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for PLACE
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for AGENT
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for Q_DHL_1
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for AGENT_DHL1
ETL_Trans_Only*:* 17:24:17.249 LFolder.SynonymRegister aliases are OK for GROUP_DHL1
ETL_Trans_Only*:* 17:24:17.468 LFolder.TableRegister creating new SYNONYM: T_AGENT_TEL_QUARTER
ETL_Trans_Only*:* 17:24:17.468 LFolder.TableRegister creating new SYNONYM: V_AGENT_TEL_WEEK
ETL_Trans_Only*:* 17:24:17.468 LFolder.TableRegister failed sql: create view V_AGENT_TEL_WEEK AS SELECT TIME_KEY, OBJECT_ID ,TN_ABANDON_INB_60S,TN_ABANDON_INB_M60,TT_ANSW_INBOUND,AT_RINGING_INB,TN_ANSW_INB_PU,TN_CALL_INBOUND,TN_ANSW_INB_5S,TN_ANSW_INBOUND,TT_AGENT_READY,TN_CALL_DIAL,TN_ABANDON_INB_10S,TT_ACW_AGENT_STAT,TT_AGENT_LOGIN,AT_ANSW_INB,TN_ANSW_INB_30S,TN_CALL_CONSULT,TN_ANSW_INB_M60S,MXT_CALL_ANSW,TN_ABANDON_INB_30S,TT_CALL_RINGING,TN_ANSW_INB_60S,TN_ANSW_INB_OTRO,TN_HOLD_60S,AT_RINGING,TN_ABANDON_INB_5S,TN_AGENT_READY,TN_ABANDON_INB,TT_ABANDON_INB,TN_AGENT_NOTREADY,TN_ANSW_INB_RAS,TN_TRANSFERT_M,TN_ANSW_INB_10S,AT_CONSULT,AT_ABANDON_INB,TN_TRANSFERT_R,TN_CALL_ABANDON,TT_CALL_DIALING,TT_CALL_INTERNAL,TN_HOLD_M60S,TN_CALL_INTERNAL,TT_CALL_CONSULT,TN_CALL_HOLD,TN_ACW_AGENT_STAT,AT_HOLD,TT_CALL_HOLD,TN_HOLD_10S,TN_ANSW_INB_PAC,MXN_CALL_ANSW,AT_INTERNAL_CALL,TOTALCALLSABANDONE,TT_CALL_INBOUND,TN_HOLD_5S,TT_AGENT_NOTREADY,TN_AGENT_CALLS,TN_HOLD_30S FROM ( SELECT TIME_KEY, OBJECT_ID ,SUM(TN_ABANDON_INB_60S) TN_ABANDON_INB_60S,SUM(TN_ABANDON_INB_M60) TN_ABANDON_INB_M60,SUM(TT_ANSW_INBOUND) TT_ANSW_INBOUND,CURR(AT_RINGING_INB) AT_RINGING_INB,SUM(TN_ANSW_INB_PU) TN_ANSW_INB_PU,SUM(TN_CALL_INBOUND) TN_CALL_INBOUND,SUM(TN_ANSW_INB_5S) TN_ANSW_INB_5S,SUM(TN_ANSW_INBOUND) TN_ANSW_INBOUND,SUM(TT_AGENT_READY) TT_AGENT_READY,SUM(TN_CALL_DIAL) TN_CALL_DIAL,SUM(TN_ABANDON_INB_10S) TN_ABANDON_INB_10S,SUM(TT_ACW_AGENT_STAT) TT_ACW_AGENT_STAT,SUM(TT_AGENT_LOGIN) TT_AGENT_LOGIN,CURR(AT_ANSW_INB) AT_ANSW_INB,SUM(TN_ANSW_INB_30S) TN_ANSW_INB_30S,SUM(TN_CALL_CONSULT) TN_CALL_CONSULT,SUM(TN_ANSW_INB_M60S) TN_ANSW_INB_M60S,MAX(MXT_CALL_ANSW) MXT_CALL_ANSW,SUM(TN_ABANDON_INB_30S) TN_ABANDON_INB_30S,SUM(TT_CALL_RINGING) TT_CALL_RINGING,SUM(TN_ANSW_INB_60S) TN_ANSW_INB_60S,SUM(TN_ANSW_INB_OTRO) TN_ANSW_INB_OTRO,SUM(TN_HOLD_60S) TN_HOLD_60S,CURR(AT_RINGING) AT_RINGING,SUM(TN_ABANDON_INB_5S) TN_ABANDON_INB_5S,SUM(TN_AGENT_READY) TN_AGENT_READY,SUM(TN_ABANDON_INB) TN_ABANDON_INB,SUM(TT_ABANDON_INB) TT_ABANDON_INB,SUM(TN_AGENT_NOTREADY) TN_AGENT_NOTREADY,SUM(TN_ANSW_INB_RAS) TN_ANSW_INB_RAS,SUM(TN_TRANSFERT_M) TN_TRANSFERT_M,SUM(TN_ANSW_INB_10S) TN_ANSW_INB_10S,CURR(AT_CONSULT) AT_CONSULT,CURR(AT_ABANDON_INB) AT_ABANDON_INB,SUM(TN_TRANSFERT_R) TN_TRANSFERT_R,SUM(TN_CALL_ABANDON) TN_CALL_ABANDON,SUM(TT_CALL_DIALING) TT_CALL_DIALING,SUM(TT_CALL_INTERNAL) TT_CALL_INTERNAL,SUM(TN_HOLD_M60S) TN_HOLD_M60S,SUM(TN_CALL_INTERNAL) TN_CALL_INTERNAL,SUM(TT_CALL_CONSULT) TT_CALL_CONSULT,SUM(TN_CALL_HOLD) TN_CALL_HOLD,SUM(TN_ACW_AGENT_STAT) TN_ACW_AGENT_STAT,CURR(AT_HOLD) AT_HOLD,SUM(TT_CALL_HOLD) TT_CALL_HOLD,SUM(TN_HOLD_10S) TN_HOLD_10S,SUM(TN_ANSW_INB_PAC) TN_ANSW_INB_PAC,MAX(MXN_CALL_ANSW) MXN_CALL_ANSW,CURR(AT_INTERNAL_CALL) AT_INTERNAL_CALL,SUM(TOTALCALLSABANDONE) TOTALCALLSABANDONE,SUM(TT_CALL_INBOUND) TT_CALL_INBOUND,SUM(TN_HOLD_5S) TN_HOLD_5S,SUM(TT_AGENT_NOTREADY) TT_AGENT_NOTREADY,SUM(TN_AGENT_CALLS) TN_AGENT_CALLS,SUM(TN_HOLD_30S) TN_HOLD_30S FROM ( SELECT TIME_KEY, OBJECT_ID ,TN_ABANDON_INB_60S,TN_ABANDON_INB_M60,TT_ANSW_INBOUND,NULL AT_RINGING_INB,NULL TN_ANSW_INB_PU,TN_CALL_INBOUND,NULL TN_ANSW_INB_5S,TN_ANSW_INBOUND,TT_AGENT_READY,TN_CALL_DIAL,TN_ABANDON_INB_10S,TT_ACW_AGENT_STAT,TT_AGENT_LOGIN,NULL AT_ANSW_INB,NULL TN_ANSW_INB_30S,TN_CALL_CONSULT,NULL TN_ANSW_INB_M60S,MXT_CALL_ANSW,TN_ABANDON_INB_30S,TT_CALL_RINGING,NULL TN_ANSW_INB_60S,NULL TN_ANSW_INB_OTRO,TN_HOLD_60S,NULL AT_RINGING,TN_ABANDON_INB_5S,TN_AGENT_READY,TN_ABANDON_INB,TT_ABANDON_INB,TN_AGENT_NOTREADY,NULL TN_ANSW_INB_RAS,TN_TRANSFERT_M,NULL TN_ANSW_INB_10S,NULL AT_CONSULT,NULL AT_ABANDON_INB,TN_TRANSFERT_R,TN_CALL_ABANDON,TT_CALL_DIALING,NULL TT_CALL_INTERNAL,TN_HOLD_M60S,TN_CALL_INTERNAL,TT_CALL_CONSULT,TN_CALL_HOLD,TN_ACW_AGENT_STAT,NULL AT_HOLD,TT_CALL_HOLD,TN_HOLD_10S,NULL TN_ANSW_INB_PAC,MXN_CALL_ANSW,NULL AT_INTERNAL_CALL,TOTALCALLSABANDONE,TT_CALL_INBOUND,TN_HOLD_5S,TT_AGENT_NOTREADY,TN_AGENT_CALLS,TN_HOLD_30S FROM R_211_STAT_RES UNION ALL SELECT TIME_KEY, OBJECT_ID ,TN_ABANDON_INB_60S,TN_ABANDON_INB_M60,TT_ANSW_INBOUND,AT_RINGING_INB,TN_ANSW_INB_PU,TN_CALL_INBOUND,TN_ANSW_INB_5S,TN_ANSW_INBOUND,TT_AGENT_READY,TN_CALL_DIAL,TN_ABANDON_INB_10S,TT_ACW_AGENT_STAT,TT_AGENT_LOGIN,AT_ANSW_INB,TN_ANSW_INB_30S,TN_CALL_CONSULT,TN_ANSW_INB_M60S,MXT_CALL_ANSW,TN_ABANDON_INB_30S,TT_CALL_RINGING,TN_ANSW_INB_60S,TN_ANSW_INB_OTRO,TN_HOLD_60S,AT_RINGING,TN_ABANDON_INB_5S,TN_AGENT_READY,TN_ABANDON_INB,TT_ABANDON_INB,TN_AGENT_NOTREADY,TN_ANSW_INB_RAS,TN_TRANSFERT_M,TN_ANSW_INB_10S,AT_CONSULT,AT_ABANDON_INB,TN_TRANSFERT_R,TN_CALL_ABANDON,TT_CALL_DIALING,TT_CALL_INTERNAL,TN_HOLD_M60S,TN_CALL_INTERNAL,TT_CALL_CONSULT,TN_CALL_HOLD,TN_ACW_AGENT_STAT,AT_HOLD,TT_CALL_HOLD,TN_HOLD_10S,TN_ANSW_INB_PAC,MXN_CALL_ANSW,AT_INTERNAL_CALL,NULL TOTALCALLSABANDONE,TT_CALL_INBOUND,TN_HOLD_5S,TT_AGENT_NOTREADY,TN_AGENT_CALLS,TN_HOLD_30S FROM R_218_STAT_RES UNION ALL SELECT TIME_KEY, OBJECT_ID ,TN_ABANDON_INB_60S,TN_ABANDON_INB_M60,TT_ANSW_INBOUND,AT_RINGING_INB,TN_ANSW_INB_PU,TN_CALL_INBOUND,TN_ANSW_INB_5S,TN_ANSW_INBOUND,TT_AGENT_READY,TN_CALL_DIAL,TN_ABANDON_INB_10S,TT_ACW_AGENT_STAT,TT_AGENT_LOGIN,AT_ANSW_INB,TN_ANSW_INB_30S,TN_CALL_CONSULT,TN_ANSW_INB_M60S,MXT_CALL_ANSW,TN_ABANDON_INB_30S,TT_CALL_RINGING,TN_ANSW_INB_60S,TN_ANSW_INB_OTRO,TN_HOLD_60S,AT_RINGING,TN_ABANDON_INB_5S,TN_AGENT_READY,TN_ABANDON_INB,TT_ABANDON_INB,TN_AGENT_NOTREADY,TN_ANSW_INB_RAS,TN_TRANSFERT_M,TN_ANSW_INB_10S,AT_CONSULT,AT_ABANDON_INB,TN_TRANSFERT_R,TN_CALL_ABANDON,TT_CALL_DIALING,TT_CALL_INTERNAL,TN_HOLD_M60S,TN_CALL_INTERNAL,TT_CALL_CONSULT,TN_CALL_HOLD,TN_ACW_AGENT_STAT,AT_HOLD,TT_CALL_HOLD,TN_HOLD_10S,TN_ANSW_INB_PAC,MXN_CALL_ANSW,AT_INTERNAL_CALL,NULL TOTALCALLSABANDONE,TT_CALL_INBOUND,TN_HOLD_5S,TT_AGENT_NOTREADY,TN_AGENT_CALLS,TN_HOLD_30S FROM R_225_STAT_RES ) zx GROUP BY zx.TIME_KEY, zx.OBJECT_ID ) xz
ETL_Trans_Only*:* 17:24:17.484 LFolder.SynonymRegister Error during alias creation
ETL_Trans_Only*:* SQLState: 42000
ETL_Trans_Only*:* Vendor:   195
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: 'CURR' is not a recognized built-in function name.
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
ETL_Trans_Only*:* at DataMart.SqlMacro.executeDDL(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.TableRegister.createTables(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.SynonymRegister.createSynonymsForTemplate(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.SynonymRegister.createSynonyms(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.LayoutFolderMonitor.executeCommand(Unknown Source)
ETL_Trans_Only*:* at ETL.Threads.BasicMonitor.run(Unknown Source)
ETL_Trans_Only*:* at java.lang.Thread.run(Unknown Source)
ETL_Trans_Only*:* Caused by:
ETL_Trans_Only*:* SQLState: S1000
ETL_Trans_Only*:* Vendor:   102
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: Incorrect syntax near 'zx'.
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
ETL_Trans_Only*:* at DataMart.SqlMacro.executeDDL(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.TableRegister.createTables(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.SynonymRegister.createSynonymsForTemplate(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.SynonymRegister.createSynonyms(Unknown Source)
ETL_Trans_Only*:* at ETL.LFolder.LayoutFolderMonitor.executeCommand(Unknown Source)
ETL_Trans_Only*:* at ETL.Threads.BasicMonitor.run(Unknown Source)
ETL_Trans_Only*:* at java.lang.Thread.run(Unknown Source)


Does anyone know about that, and how to solve.

Regards

[René]

Hi,

The error is really strange. I've installed ETL on SQL Server 2005 several times and never saw such error.

I don't see any relation to your error but ETL requires Java version 1.4.x while you are using Java 1.6. Could you try to install version 1.4.x and run ETL again?

R.

[arcoquel]

I found the error.

A template layout was the problem.
So I have to delete all entries in the database relating to this layout.


Now i have an other problem, no more data are stored in the etl. It stops the 21, date of creation of the faulty layout.
Any idea to solve that.

thanks
arnaud

[victor]

Hi,

let me try to recreate the problem, but my guess would be is that you have different template ids for the new report

after you re-installed the templates, what sort of log do you get with your datasourcer and etl?

The best way to fix it would be actually to re-create DB from scratch, can you do it? If not, let me try to re-create the problem here and get back to you.

Best regards,
Vic

[oratan]

Hi,
Perhaps there seems to be a problem for a name made in Inner Stored Procedure.

As René says, please change a version of JRE into 1.4.
And please rebuild DB.

Please update a patch of the DBMS if an error is still given.
There are a lot of examples that were similar when I search it in the next keyword.
MSDN SQLState 42000

Best regards,
oratan

[borkokrz]

Statistics with statistical categories like Current and Average must not be used in Historical reporting layouts since it can not be aggregated.
(what is aggregation of Current ? :-). If you still want to store NO_AGG data of those statistics just replace aggregation process for them by MIN, MAX, SUM or AVG. But you should know that in any case you will not get the correct statistics values for higher aggregation levels (Hour, Day). To do that just stop ETL and in DataMart execute this sql's:

update statistic set stat_category_func='AVG' where stat_category_func='CURR';
commit;

[victor]

Were you able to fix it?

[borkokrz]

Yes, this is official solution from Genesys Support. I'm using statistic with category AverageOfCurrentNumber to store 15-min statistics of IVR port usage.