ETL Transfer problem

Hello.

I have new installation and I have problem with ETL Transfer. Data are store in ODS but there aren’t transfer to DM database.
I have MSSQL 2000 SP4 and Microsoft W2003 Enterprise Editon with Service Pack 1.
I’ve reinstall several times ETL_Service with DAP, and also delete DM database but the ETL Transfer still not working.

Starter: Starting ‘ETL_Trans_Only’ on Thu Jul 17 09:40:00 2008
Starter: Current directory is set to .
Starter: Executing "java -jar transform.jar -conf etl.properties -dropTransferredTables -setFirstDayOfWeek=2 -jdbcurl=jdbc:jtds:sqlserver://vmw2003:1433;DatabaseName=g75dm2 -user=g7dm -passEncrypted="
Starter: Pipe 220 “\.\pipe\036720000000177_CCA” and Event 68 created for ETL_Trans_Only
Starter: waiting for a client to connect to the pipe 220.
Starter: client connected to the pipe 220.
Starter: Thu Jul 17 09:40:00 2008 [ETL_Trans_Only] will be started on Thu Jul 17 09:50:00 2008 start in 600 seconds
ETL_Trans_Only: Time Origin Message
ETL_Trans_Only: ------------ -------------------------- ----------------------------------------
ETL_Trans_Only: 09:40:01.046 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*:* 09:40:01.250 Main.Env Runtime info: {java.runtime.name=Java™ 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.1_05\bin, java.vm.version=1.4.1_05-b01, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot™ Client VM, file.encoding.pkg=sun.io, user.country=CZ, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\reph\etl_runtime, java.runtime.version=1.4.1_05-b01, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.1_05\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\WINDOWS\TEMP, line.separator=, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, 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, 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:\Documents and Settings\Default User, user.timezone=Europe/Prague, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1250, 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.1_05, sun.arch.data.model=32, user.language=cs, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.4.1_05, java.ext.dirs=C:\Program Files\Java\j2re1.4.1_05\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.1_05\lib\rt.jar;C:\Program Files\Java\j2re1.4.1_05\lib\i18n.jar;C:\Program Files\Java\j2re1.4.1_05\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.1_05\lib\jsse.jar;C:\Program Files\Java\j2re1.4.1_05\lib\jce.jar;C:\Program Files\Java\j2re1.4.1_05\lib\charsets.jar;C:\Program Files\Java\j2re1.4.1_05\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*:* 09:40:01.250 Main.Options Options: {dropTransferredTables=, jdbcurl=jdbc:jtds:sqlserver://vmw2003:1433;DatabaseName=g75dm2, user=g7dm, passEncrypted=3FC72ED919854F38, setFirstDayOfWeek=2}
ETL_Trans_Only*:* 09:40:01.250 Main TRANSFORM started
ETL_Trans_Only*:* 09:40:01.531 Write.Heartbeat Pulse: 2008/07/17, CEST, 900, 1.9M
ETL_Trans_Only*:* 09:40:01.578 LFolder Connected database: Microsoft SQL Server, version: 08.00.2039, driver: 1.2
ETL_Trans_Only*:* 09:40:01.625 Source.SourceDef ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F
ETL_Trans_Only*:* 09:40:01.625 Thread.DstManager caught an exception. Monitor: SourceDefMonitor Message: SourceDefMonitor: unable to execute command: START
ETL_Trans_Only*:* Stack Trace:
ETL_Trans_Only*:* common.TransformError: No active sources left. Exiting…
ETL_Trans_Only*:* at ETL.SourceDefMonitor.mangeManagers(Unknown Source)
ETL_Trans_Only*:* at ETL.SourceDefMonitor.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*:* 09:40:01.640 Main TRANSFORM finished
Starter: Waiting for process [ETL_Trans_Only] to exit…
Starter: Process [ETL_Trans_Only] has terminated with exit code 0

Thanks for your help.

Hello Marty,

you probably had an ODS and you added a new istance; log in ETL assistant and check if your current ODS is specified as source for Datamart. If you have one already, try to add it again.

Francesco

Hello, I’ve specified ODS again in ETL assistant but it doesn’t help me.

I’ve solved my problem but I don’t know what was the problem. I’ve removed all component for historical reporting include database for ODS and DM. I’ve reinstall java to higher version j2re-1_4_2_17, and setup again the historical reporting.

After this ETL transfer is working, maybe it was by the java, I don’t know.

Hmmm… had a similar problem and found that there is an “English” java version - and a different “US” version, even though the versions were the same…

The recommendation at the time was to install “English”, rather than “US”. I don’t know why, but it helped me…

Tony

Have you a DAP connection in your ETL Application ???

Hi,

here is the problem:

ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F

it happens when you rebuild ODS without re-initializing datamart or do it without ETL Assistant
ETL marks ODS it is using so if you then change ODS table (uhm, rebuild and forget to put the data in ) you get an error like that

There was an old ticket (130797) that mentions that on Genesys Support site, which can be summarized as:
“Customer had reinitialized the ODS, but used the same Data Source in the ETL Assistant.”

Of course, I had this also happen to me quite a few times when I would use different versions of ODS and ETL as well, but I am sure you are much smarter than me, and would not even consider doing that!

Good job victor, i already have this problem to

You can look the joined attachment for the solution

Hi Sylvainsjc, Victor,

We have the same issue here.

1 out of our 2 lab setup has the “ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F” error. (the other genesys setup works)

We got that issue by upgrading the ETL Runtime to 7.2. (ODS is still at 7.1)

I have looked at the genesys_ods.ol_db_properties and genesys_datamart.dm_property tables and the BRAND value does not match for the setup with the “ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F” error.

My question would be… what exactly is your recommended solution to this issue?

I have recreated a new ETL Runtime application in Configuration Manager. That didn’t work.
I have deleted the ETL Assistant Data Source and re-created it. That didn’t work.
I have uninstalled/re-installed ETL Runtime from the add/remove problem. That didn’t work.

Thanks for your help,
Greatly appreciated.
Johnny

The simple way is to update the brand value in ETL database in dm_property
Don’t forget to make a backup of your database(s) before to update and test
Best regards