Please any body else to help me, i try to configure ETL_runtime but i can't do it, if you can to explain me a few what happen. Thanks
__________________________________________________________
Application name: ETL_Runtime
Application type: DataMart (58)
Command line: starter.exe -service CCADataMart -app ETL_Runtime -host anew-lab01 -port 2020 -sstart
Host name: anew-lab01
DST: TZ = 0, timeb = 0
Time zone: 14400, SA Western Standard Time, SA Western Standard Time
UTC time: 2008-11-12T15:55:43.421
Local time: 2008-11-12T11:55:43.421
Start time (UTC): 2008-11-12T15:55:43
Running time: 0:00:00:00
Host info: Windows 5.2.3790, 2, Service Pack 1, 1.0, 0112, 3
File: (1) C:\Documents and Settings\Administrator\Desktop\Logs\ETL_Runtime\ETL_Runtime.20081112_115543_422.log
11:55:43.421 Trc 04112 The Log Output of type 'C:\Documents and Settings\Administrator\Desktop\Logs\ETL_Runtime\ETL_Runtime' has been created and opened
11:55:43.421 Trc 04110 Option 'buffering' has been set to the value 'yes'
11:55:43.421 Trc 04110 Option 'spool' has been set to the value ''
11:55:43.421 Trc 04110 Option 'keep-startup-file' has been set to the value 'no'
11:55:43.421 Trc 04110 Option 'MessageFile' has been set to the value 'DataMart.lms'
11:55:43.421 Trc 04110 Option 'time-format' has been set to the value 'time'
11:55:43.421 Trc 04110 Option 'time-convert' has been set to the value 'local'
11:55:43.421 Trc 04110 Option 'message-format' has been set to the value 'short'
11:55:43.421 Trc 04110 Option 'memory-storage-size' has been set to the value '2 Mb'
11:55:43.421 Trc 04110 Option 'compatible-output-priority' has been set to the value 'no'
11:55:43.421 Trc 04110 Option 'print-attributes' has been set to the value 'no'
11:55:43.421 Trc 04110 Option 'check-point' has been set to the value '1'
11:55:43.421 Std 04106 Log Messages file 'DataMart.lms' successfully loaded
11:55:43.421 Trc 04112 The Log Output of type 'C:\Documents and Settings\Administrator\Desktop\Logs\ETL_Runtime\ETL_Runtime' has been created and opened
11:55:43.421 Trc 04100 Logging service started
Message Log Opened Successfully!
Starter: Processing start options...
Starter: Added process [ETL_Trans_Only]
Starter: Added process [ETL_Agg_Only]
Starter: Added process [ETL_Tracking]
Starter: Wed Nov 12 11:55:43 2008 [ETL_Trans_Only] will be started on Wed Nov 12 11:56:00 2008 start in 17 seconds
Starter: Wed Nov 12 11:55:43 2008 [ETL_Agg_Only] will be started on Wed Nov 12 12:11:00 2008 start in 917 seconds
Starter: Wed Nov 12 11:55:43 2008 [ETL_Tracking] will be started on Wed Nov 12 12:23:00 2008 start in 1637 seconds
Open LCALayer on port=4999
LCA Library version 7.1.000.00
Starter: SA Western Standard Time, daylight-saving time is not observed
************************************
LCALayer: REventRegistered on LCA...
************************************
Starter: Starting 'ETL_Trans_Only' on Wed Nov 12 11:56:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL -user=sa -passEncrypted=******"
Starter: Pipe 216 "\\.\pipe\030240000002738_CCA" and Event 68 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 216.
Starter: client connected to the pipe 216.
Starter: Wed Nov 12 11:56:00 2008 [ETL_Trans_Only] will be started on Wed Nov 12 11:57:00 2008 start in 60 seconds
ETL_Trans_Only*:* Time Origin Message
ETL_Trans_Only*:* ------------ -------------------------- ----------------------------------------
ETL_Trans_Only*:* 11:56:00.578 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*:* 11:56:00.578 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_18\bin, java.vm.version=1.4.2_18-b06, 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, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\Reporting\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.4.2_18-b06, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_18\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.java2d.fontpath=, java.library.path=C:\WINDOWS\system32;.;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\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\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=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.2, user.home=C:\WINDOWS\system32\config\systemprofile, user.timezone=GMT-04:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, java.class.path=transform.jar, user.name=SYSTEM, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_18, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.2_18, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_18\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_18\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_18\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_18\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_18\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_18\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.cpu.isalist=pentium i486 i386}
ETL_Trans_Only*:* 11:56:00.578 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL, user=sa, passEncrypted=876A6828D29A9D94}
ETL_Trans_Only*:* 11:56:00.578 Main TRANSFORM started
ETL_Trans_Only*:* 11:56:00.734 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* common.TransformError: Error during upgrade
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
ETL_Trans_Only*:* Caused by: java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* ... 3 more
ETL_Trans_Only*:* Caused by:
ETL_Trans_Only*:* SQLState: 42S02
ETL_Trans_Only*:* Vendor: 208
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
Starter: Waiting for process [ETL_Trans_Only] to exit...
Starter: Process [ETL_Trans_Only] has terminated with exit code 3
Starter: Starting 'ETL_Trans_Only' on Wed Nov 12 11:57:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL -user=sa -passEncrypted=******"
Starter: Pipe 216 "\\.\pipe\030240000116059_CCA" and Event 184 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 216.
Starter: client connected to the pipe 216.
Starter: Wed Nov 12 11:57:00 2008 [ETL_Trans_Only] will be started on Wed Nov 12 11:58:00 2008 start in 60 seconds
ETL_Trans_Only*:* Time Origin Message
ETL_Trans_Only*:* ------------ -------------------------- ----------------------------------------
ETL_Trans_Only*:* 11:57:00.578 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*:* 11:57:00.796 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_18\bin, java.vm.version=1.4.2_18-b06, 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, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\Reporting\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.4.2_18-b06, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_18\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.java2d.fontpath=, java.library.path=C:\WINDOWS\system32;.;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\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\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=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.2, user.home=C:\WINDOWS\system32\config\systemprofile, user.timezone=GMT-04:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, java.class.path=transform.jar, user.name=SYSTEM, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_18, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.2_18, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_18\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_18\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_18\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_18\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_18\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_18\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.cpu.isalist=pentium i486 i386}
ETL_Trans_Only*:* 11:57:00.796 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL, user=sa, passEncrypted=876A6828D29A9D94}
ETL_Trans_Only*:* 11:57:00.796 Main TRANSFORM started
ETL_Trans_Only*:* 11:57:00.953 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* common.TransformError: Error during upgrade
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
ETL_Trans_Only*:* Caused by: java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* ... 3 more
ETL_Trans_Only*:* Caused by:
ETL_Trans_Only*:* SQLState: 42S02
ETL_Trans_Only*:* Vendor: 208
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
Starter: Waiting for process [ETL_Trans_Only] to exit...
Starter: Process [ETL_Trans_Only] has terminated with exit code 3
Starter: Starting 'ETL_Trans_Only' on Wed Nov 12 11:58:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL -user=sa -passEncrypted=******"
Starter: Pipe 216 "\\.\pipe\030240000216247_CCA" and Event 68 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 216.
Starter: client connected to the pipe 216.
Starter: Wed Nov 12 11:58:00 2008 [ETL_Trans_Only] will be started on Wed Nov 12 11:59:00 2008 start in 60 seconds
ETL_Trans_Only*:* Time Origin Message
ETL_Trans_Only*:* ------------ -------------------------- ----------------------------------------
ETL_Trans_Only*:* 11:58:00.562 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*:* 11:58:00.578 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_18\bin, java.vm.version=1.4.2_18-b06, 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, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\Reporting\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.4.2_18-b06, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_18\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.java2d.fontpath=, java.library.path=C:\WINDOWS\system32;.;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\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\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=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.2, user.home=C:\WINDOWS\system32\config\systemprofile, user.timezone=GMT-04:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, java.class.path=transform.jar, user.name=SYSTEM, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_18, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.2_18, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_18\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_18\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_18\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_18\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_18\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_18\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.cpu.isalist=pentium i486 i386}
ETL_Trans_Only*:* 11:58:00.578 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL, user=sa, passEncrypted=876A6828D29A9D94}
ETL_Trans_Only*:* 11:58:00.578 Main TRANSFORM started
ETL_Trans_Only*:* 11:58:00.734 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* common.TransformError: Error during upgrade
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
ETL_Trans_Only*:* Caused by: java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* ... 3 more
ETL_Trans_Only*:* Caused by:
ETL_Trans_Only*:* SQLState: 42S02
ETL_Trans_Only*:* Vendor: 208
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
Starter: Waiting for process [ETL_Trans_Only] to exit...
Starter: Process [ETL_Trans_Only] has terminated with exit code 3
Starter: Starting 'ETL_Trans_Only' on Wed Nov 12 11:59:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL -user=sa -passEncrypted=******"
Starter: Pipe 216 "\\.\pipe\030240000311433_CCA" and Event 184 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 216.
Starter: client connected to the pipe 216.
Starter: Wed Nov 12 11:59:00 2008 [ETL_Trans_Only] will be started on Wed Nov 12 12:00:00 2008 start in 60 seconds
ETL_Trans_Only*:* Time Origin Message
ETL_Trans_Only*:* ------------ -------------------------- ----------------------------------------
ETL_Trans_Only*:* 11:59:00.578 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*:* 11:59:00.796 Main.Env Runtime info: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_18\bin, java.vm.version=1.4.2_18-b06, 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, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\Reporting\Data Mart\ETL_Runtime\etl_runtime, java.runtime.version=1.4.2_18-b06, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_18\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.java2d.fontpath=, java.library.path=C:\WINDOWS\system32;.;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\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\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=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.2, user.home=C:\WINDOWS\system32\config\systemprofile, user.timezone=GMT-04:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, java.class.path=transform.jar, user.name=SYSTEM, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_18, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.2_18, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_18\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_18\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_18\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_18\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_18\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_18\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_18\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.cpu.isalist=pentium i486 i386}
ETL_Trans_Only*:* 11:59:00.796 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://anew-lab01:1433;DatabaseName=ETL, user=sa, passEncrypted=876A6828D29A9D94}
ETL_Trans_Only*:* 11:59:00.796 Main TRANSFORM started
ETL_Trans_Only*:* 11:59:00.953 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* common.TransformError: Error during upgrade
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
ETL_Trans_Only*:* Caused by: java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* ... 3 more
ETL_Trans_Only*:* Caused by:
ETL_Trans_Only*:* SQLState: 42S02
ETL_Trans_Only*:* Vendor: 208
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* java.sql.SQLException: Invalid object name 'DM_PROPERTY'.
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.executeSQLQuery(JtdsStatement.java:418)
ETL_Trans_Only*:* at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
ETL_Trans_Only*:* at ETL.UpgradeOfficer.approve(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.start(Unknown Source)
ETL_Trans_Only*:* at ETL.Transformer.main(Unknown Source)
Starter: Waiting for process [ETL_Trans_Only] to exit...
Starter: Process [ETL_Trans_Only] has terminated with exit code 3
