ETL Transfer problem

[Marty]

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(TM) 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(TM) 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=<CR><LF>, 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.

[Fra]

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

[Marty]

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.

[tony]

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

[Sylvainsjc]

Have you a DAP connection in your ETL Application

[victor]

Hi,


here is the problem:

[color=red]ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F[/color]

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!

[Sylvainsjc]

Good job victor, i already have this problem to

You can look the joined attachment for the solution

[Johnny]

Hi Sylvainsjc, Victor,

We have the same issue here.

1 out of our 2 lab setup has the "[color=red]ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F[/color]" 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 [color=red]genesys_ods.ol_db_properties [/color] and [color=red]genesys_datamart.dm_property [/color] tables and the BRAND value does not match for the setup with the "[color=red]ODS brand, 66CD430D, does not correspond to that of DataMart, 2AF245F[/color]" error.


[b]My question would be... what exactly is your recommended solution to this issue?[/b]

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

[Sylvainsjc]

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