Initializing the Data Mart - MSSQL EXPRESS

[cavagnaro]

It will depend on DMA templates
Again, have you tried as I told you? Let Genesys do it?

[fnunezsa]

Last guess.... would you please try adding the TCP port to the connection string? That is supposed to be an optional parameter, but I guess it's worth guiving it a shot

[genecool]

Yes, I have already tried to append the TCP port :

[quote]
Find the results bellow :

jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart;instance=SQLEXPRESS
  --> Exception : java.sql.SQLException: Server localhost has no instance named SQLEXPRESS
jdbcurl=jdbc:jtds:sqlserver://localhost/sqlexpress;DatabaseName=DataMart
  --> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
jdbcurl=jdbc:jtds:sqlserver://localhost/SQLEXPRESS;DatabaseName=DataMart
  --> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
jdbcurl=jdbc:jtds:sqlserver://localhost/SQLEXPRESS
  --> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
jdbcurl=jdbc:jtds:sqlserver://[b]localhost:1433[/b];DatabaseName=DataMart;instance=SQLEXPRESS
  --> Exception : java.sql.SQLException: Server localhost has no instance named SQLEXPRESS
jdbcurl=jdbc:jtds:sqlserver://[b]localhost:1433[/b];DatabaseName=DataMart
  --> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
jdbcurl=jdbc:jtds:sqlserver://localhost;DatabaseName=DataMart
  --> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
[/quote]



Finally, I have tried to let Genesys do it. I could see into the log files :
[code]
2011-03-28 11:01:00 ETLStarter: Executing "java -jar transform.jar -conf etl.properties"
2011-03-28 11:01:00 ETLStarter: Mon Mar 28 11:01:00 2011 ETL_Trans_Only will be started on Mon Mar 28 11:02:00 2011 start in 60 seconds
2011-03-28 11:01:00 ETLStarter: Process list has changed.
2011-03-28 11:01:00 ETLStarter: Updating pipe list...
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 11:01:00.687 Main
ETL_Trans_Only: Usage: java -jar transform.jar [transform options]
ETL_Trans_Only:
ETL_Trans_Only: where 'transform options' include:
ETL_Trans_Only:
ETL_Trans_Only:    -conf=<properties file name> - specify file with transform options
ETL_Trans_Only:  OR/AND:
ETL_Trans_Only:    -user=<username>    - database username
ETL_Trans_Only:    -pass=<password>    - database password
ETL_Trans_Only:    -jdbcurl=<jdbc url>  - string like: 'jdbc:oracle:thin:@host:port:dbname'
ETL_Trans_Only:                          provided to JDBC driver for connect to dest.database
ETL_Trans_Only:    -log=<log file name> - name of the log file [default=<STDOUT>]
ETL_Trans_Only:    -levelOfLog=<logger:level,...> - log level [default=.:INFO]
ETL_Trans_Only:                                    with logger like:
ETL_Trans_Only:                          'Main', 'Write.Job.Trans', Src.ChunkData', '.', etc
ETL_Trans_Only:                                      and level like:
ETL_Trans_Only:                          'ALL', 'OFF', 'FINE', 'FINER', 'FINEST', 'CONFIG',
ETL_Trans_Only:                          'INFO', 'SEVERE', 'WARNING' or an integer;
ETL_Trans_Only:    -createdb              - will create database schema, populate it
ETL_Trans_Only:                            by meta-data and templates info and exit
ETL_Trans_Only:    -agg                  - will do aggregation for all defined report views
ETL_Trans_Only:    -aggOnly              - will do only aggregation (no chunk transfer)
ETL_Trans_Only:    -transOnce            - will exit after transformation of all chunks (this option can not be combined with agg/aggOnly)
ETL_Trans_Only:
ETL_Trans_Only: 11:01:00.687 Main Stack Trace:
ETL_Trans_Only: 11:01:00.687 Main common.TransformError: Required parameter is missing
ETL_Trans_Only: 11:01:00.687 Main at DataMart.Options.<clinit>(Options.java:33)
ETL_Trans_Only: 11:01:00.687 Main at ETL.Transformer.setDistConnectObject(Transformer.java:53)
ETL_Trans_Only: 11:01:00.687 Main at ETL.Transformer.main(Transformer.java:187)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2011-03-28 11:01:00 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 1
[/code]


So, I have configured etl.properties file as following :
[code]
user=sa
pass=password
jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart;
[/code]

The log files showed :
[code]
2011-03-28 11:07:00 ETLStarter: Executing "java -jar transform.jar -conf etl.properties"
2011-03-28 11:07:00 ETLStarter: Mon Mar 28 11:07:00 2011 ETL_Trans_Only will be started on Mon Mar 28 11:08:00 2011 start in 60 seconds
2011-03-28 11:07:00 ETLStarter: Process list has changed.
2011-03-28 11:07:00 ETLStarter: Updating pipe list...
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 11:07:00.656 Main ETL Runtime, Version: 7.6.000.10, Build: 2010/10/26 12:34 (C) Copyright 1994-2010 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only: 11:07:00.656 Main.Env Runtime info: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=19.1-b02, 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=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files\GCTI\Data Mart\DataMart\etl_runtime, java.runtime.version=1.6.0_24-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre6\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:\WINDOWS\system32\WindowsPowerShell\v1.0;c:\Program Files\Microsoft SQL Server\90\Tools\binn\, 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:\Documents and Settings\Default User, user.timezone=Europe/Berlin, 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\jre6, 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, sharing, java.version=1.6.0_24, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\lib\modules\jdk.boot.jar;C:\Program Files\Java\jre6\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:07:00.656 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart, user=sa, pass=*****}
ETL_Trans_Only: 11:07:00.734 Main TRANSFORM started
ETL_Trans_Only: 11:07:01.921 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only: 11:07:01.921 Main Stack Trace:
ETL_Trans_Only: 11:07:01.921 Main common.TransformError: Error during upgrade
ETL_Trans_Only: 11:07:01.921 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:172)
ETL_Trans_Only: 11:07:01.921 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:07:01.921 Main at ETL.Transformer.main(Transformer.java:200)
ETL_Trans_Only: 11:07:01.921 Main Caused by:
ETL_Trans_Only: 11:07:01.921 Main SQLState: 08S01
ETL_Trans_Only: 11:07:01.921 Main Vendor:  0
ETL_Trans_Only: 11:07:01.921 Main Stack Trace:
ETL_Trans_Only: 11:07:01.921 Main java.sql.SQLException: Network error IOException: Connection refused: connect
ETL_Trans_Only: 11:07:01.921 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
ETL_Trans_Only: 11:07:01.921 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
ETL_Trans_Only: 11:07:01.921 Main at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
ETL_Trans_Only: 11:07:01.921 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:07:01.921 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:07:01.921 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:243)
ETL_Trans_Only: 11:07:01.921 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:205)
ETL_Trans_Only: 11:07:01.921 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:130)
ETL_Trans_Only: 11:07:01.921 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:07:01.921 Main at ETL.Transformer.main(Transformer.java:200)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2011-03-28 11:07:01 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 3
[/code]


Then, I have appended "instance=SQLEXPRESS" to the string connection :
[code]
user=sa
pass=password
jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart;instance=SQLEXPRESS
[/code]

Log files show the same result that run-createddb.bat batch script :
[code]
2011-03-28 11:09:00 ETLStarter: Executing "java -jar transform.jar -conf etl.properties"
2011-03-28 11:09:00 ETLStarter: Mon Mar 28 11:09:00 2011 ETL_Trans_Only will be started on Mon Mar 28 11:10:00 2011 start in 60 seconds
2011-03-28 11:09:01 ETLStarter: Process list has changed.
2011-03-28 11:09:01 ETLStarter: Updating pipe list...
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 11:09:00.640 Main ETL Runtime, Version: 7.6.000.10, Build: 2010/10/26 12:34 (C) Copyright 1994-2010 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only: 11:09:01.015 Main.Env Runtime info: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=19.1-b02, 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=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files\GCTI\Data Mart\DataMart\etl_runtime, java.runtime.version=1.6.0_24-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre6\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:\WINDOWS\system32\WindowsPowerShell\v1.0;c:\Program Files\Microsoft SQL Server\90\Tools\binn\, 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:\Documents and Settings\Default User, user.timezone=Europe/Berlin, 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\jre6, 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, sharing, java.version=1.6.0_24, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\lib\modules\jdk.boot.jar;C:\Program Files\Java\jre6\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:09:01.015 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart;instance=SQLEXPRESS, user=sa, pass=*****}
ETL_Trans_Only: 11:09:01.015 Main TRANSFORM started
ETL_Trans_Only: 11:09:01.062 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only: 11:09:01.062 Main Stack Trace:
ETL_Trans_Only: 11:09:01.062 Main common.TransformError: Error during upgrade
ETL_Trans_Only: 11:09:01.062 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:172)
ETL_Trans_Only: 11:09:01.062 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:09:01.062 Main at ETL.Transformer.main(Transformer.java:200)
ETL_Trans_Only: 11:09:01.062 Main Caused by:
ETL_Trans_Only: 11:09:01.062 Main SQLState: 08003
ETL_Trans_Only: 11:09:01.062 Main Vendor:  0
ETL_Trans_Only: 11:09:01.062 Main Stack Trace:
ETL_Trans_Only: 11:09:01.062 Main java.sql.SQLException: Server localhost has no instance named SQLEXPRESS.
ETL_Trans_Only: 11:09:01.062 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:281)
ETL_Trans_Only: 11:09:01.062 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
ETL_Trans_Only: 11:09:01.062 Main at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
ETL_Trans_Only: 11:09:01.062 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:09:01.062 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:09:01.062 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:243)
ETL_Trans_Only: 11:09:01.062 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:205)
ETL_Trans_Only: 11:09:01.062 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:130)
ETL_Trans_Only: 11:09:01.062 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:09:01.062 Main at ETL.Transformer.main(Transformer.java:200)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2011-03-28 11:09:01 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 3
[/code]


The result is the same with "instance=EXPRESS" :
[code]
2011-03-28 11:25:00 ETLStarter: Executing "java -jar transform.jar -conf etl.properties"
2011-03-28 11:25:00 ETLStarter: Mon Mar 28 11:25:00 2011 ETL_Trans_Only will be started on Mon Mar 28 11:26:00 2011 start in 60 seconds
2011-03-28 11:25:00 ETLStarter: Process list has changed.
2011-03-28 11:25:00 ETLStarter: Updating pipe list...
ETL_Trans_Only: Time        Origin                    Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 11:25:00.671 Main ETL Runtime, Version: 7.6.000.10, Build: 2010/10/26 12:34 (C) Copyright 1994-2010 Genesys Telecommunications Laboratories, Inc.
ETL_Trans_Only: 11:25:00.875 Main.Env Runtime info: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=19.1-b02, 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=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Program Files\GCTI\Data Mart\DataMart\etl_runtime, java.runtime.version=1.6.0_24-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre6\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:\WINDOWS\system32\WindowsPowerShell\v1.0;c:\Program Files\Microsoft SQL Server\90\Tools\binn\, 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:\Documents and Settings\Default User, user.timezone=Europe/Berlin, 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\jre6, 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, sharing, java.version=1.6.0_24, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\lib\modules\jdk.boot.jar;C:\Program Files\Java\jre6\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:25:00.875 Main.Options Options: {jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart;instance=EXPRESS, user=sa, pass=*****}
ETL_Trans_Only: 11:25:00.875 Main TRANSFORM started
ETL_Trans_Only: 11:25:00.921 Main Unhandled exception happened. Exiting ...
ETL_Trans_Only: 11:25:00.921 Main Stack Trace:
ETL_Trans_Only: 11:25:00.921 Main common.TransformError: Error during upgrade
ETL_Trans_Only: 11:25:00.921 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:172)
ETL_Trans_Only: 11:25:00.921 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:25:00.921 Main at ETL.Transformer.main(Transformer.java:200)
ETL_Trans_Only: 11:25:00.921 Main Caused by:
ETL_Trans_Only: 11:25:00.921 Main SQLState: 08003
ETL_Trans_Only: 11:25:00.921 Main Vendor:  0
ETL_Trans_Only: 11:25:00.921 Main Stack Trace:
ETL_Trans_Only: 11:25:00.921 Main java.sql.SQLException: Server localhost has no instance named EXPRESS.
ETL_Trans_Only: 11:25:00.921 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:281)
ETL_Trans_Only: 11:25:00.921 Main at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
ETL_Trans_Only: 11:25:00.921 Main at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
ETL_Trans_Only: 11:25:00.921 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:25:00.921 Main at java.sql.DriverManager.getConnection(Unknown Source)
ETL_Trans_Only: 11:25:00.921 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:243)
ETL_Trans_Only: 11:25:00.921 Main at DataMart.ConnectObject.createConnection(ConnectObject.java:205)
ETL_Trans_Only: 11:25:00.921 Main at ETL.UpgradeOfficer.approve(UpgradeOfficer.java:130)
ETL_Trans_Only: 11:25:00.921 Main at ETL.Transformer.start(Transformer.java:77)
ETL_Trans_Only: 11:25:00.921 Main at ETL.Transformer.main(Transformer.java:200)
ETLStarter: Waiting for process [ETL_Trans_Only] to exit...
2011-03-28 11:25:00 ETLStarter: Process [ETL_Trans_Only] has terminated with exit code 3
[/code]

[cavagnaro]

Can you post a screenshot of your DAP config?

[genecool]

No I don't have any repository for pictures...   

[cavagnaro]

There are many online for free, try googling it

[nishantank]

Hi
I have used SQLExpress in the past to host Genesys dataabses and what I found was that the connection string should have the syntaz
<hostname>\SQLExpress as the database name.

I know this is a very old post, but thought of sharing the experience. Isnt that what this forum is all about :-)

.....

Nishant.