Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: genecool on March 24, 2011, 09:26:27 AM
-
Hi,
Using the Genesys documentation, I try to initialize my Data Mart on a Windows platform. I use an SQL EXPRESS Database.
So, I change database initialization parameters as following : jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart;instance=SQLEXPRESS
Then I run the run-createdb.bat batch script.
However, an errors occur, into the log file : java.sql.SQLException: Server localhost has no instance named SQLEXPRESS.
Does anyone have an idea, please?
-
1. SQL Express is not supported and is a terrible idea to use it due limitations
2. Is the services up?
3. Check with a Enterprise Manager the name of your instance.
4. Why /datamart in the server name?
-
1. I use SQL Express to a laboratory so the limits are not a problem.
2. Services are up (SQL Server and SQL Server Browser Service)
3. With MS SQL Server Management Studio Express I can see localhost\EXPRESS as the server name.
4. DataMart is the name of my Data Mart database.
-
Try removing the /Datamart.
try instance as localhost/sqlexpress
-
Find the results bellow :
[list]
[li]jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart;instance=SQLEXPRESS[/li][/list]
--> Exception : java.sql.SQLException: Server localhost has no instance named SQLEXPRESS
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost/sqlexpress;DatabaseName=DataMart[/li][/list]
--> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost/SQLEXPRESS;DatabaseName=DataMart[/li][/list]
--> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost/SQLEXPRESS[/li][/list]
--> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart;instance=SQLEXPRESS[/li][/list]
--> Exception : java.sql.SQLException: Server localhost has no instance named SQLEXPRESS
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=DataMart[/li][/list]
--> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
[list][li]jdbcurl=jdbc:jtds:sqlserver://localhost;DatabaseName=DataMart[/li]
[/list]
--> Exception : java.sql.SQLException: Network error IOException: Connection refused: connect
-
why don't you:
1. Create DataMart DAP:
Type: MSSQL
DBName: DataMart
user: genesys
pass: xxxxx
2. Create ETL app
3. Associate them
4. Start ETL service
That should work in the same way
-
It's done, but to use my data mart database I must initialize it before with the run-createdb.bat batch script
-
[quote]With MS SQL Server Management Studio Express I can see localhost\EXPRESS as the server name.[/quote]
Try:
jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart;instance=EXPRESS
Removing "SQL" from the instance name.
-
Ah...good eye :)
-
enable tcp/ip connections on your silly m$ sql express thing....
real solution: use oracle
-
Real solution:
Know your platform...
Informix, DB2, Oracle, MSSQL or Sybase are good BD, the fact that you prefer Oracle because you are more familiar with it has no point here.
Obviously TCP/IP is enabled, otherwise he wouldn't get MSSQL specific messages, so connection is good.
-
Thanks for your interest.
I tried "jdbcurl=jdbc:jtds:sqlserver://localhost;DatabaseName=DataMart;instance=EXPRESS" and "jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart;instance=EXPRESS".
The returned message is the same for both : java.sql.SQLException: Server localhost not named instance EXPRESS.
For your information, TCP/IP connections are already enabled
-
Have you tried with Genesys objects directly as I mentioned?
-
Do you have more than one SQL instance on that server? If not, you can remove the instance property and try:
jdbcurl=jdbc:jtds:sqlserver://localhost/DataMart
-
Yes I know. I have already tried this.
Nothing works! Does anyone know the structure of the Data Mart database so I can initialize it myself?
-
It will depend on DMA templates
Again, have you tried as I told you? Let Genesys do it?
-
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
-
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]
-
Can you post a screenshot of your DAP config?
-
No I don't have any repository for pictures... :-[
-
There are many online for free, try googling it
-
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.