Database migration

[panchonet]

Hi,

I have to migrate the databases of our Genesys environment from SQL Server 2000 to SQL Server 2005. I'm doing the tests in a lab environment, and I have the next problem: ETL Runtime doesn't transfer data from ODS to Datamart. The log of ETL Runtime shows the next lines:

ETL_Trans_Only*:* 22:26:06.944 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
Starter: Process [ETL_Trans_Only] is still running [PID=17704], skipping the start point  Wed Nov 04 22:31:00 2009
Starter: Wed Nov 04 22:31:00 2009 [ETL_Trans_Only] will be started on Wed Nov 04 22:46:00 2009 start in 900 seconds
ETL_Trans_Only*:* 22:31:05.055 Write.Heartbeat Pulse: 2009/11/04, CET, 900, 1.9M
ETL_Trans_Only*:* 22:31:06.962 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
ETL_Trans_Only*:* 22:36:06.995 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
ETL_Trans_Only*:* 22:41:07.012 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
Starter: Process [ETL_Trans_Only] is still running [PID=17704], skipping the start point  Wed Nov 04 22:46:00 2009
Starter: Wed Nov 04 22:46:00 2009 [ETL_Trans_Only] will be started on Wed Nov 04 23:01:00 2009 start in 900 seconds
ETL_Trans_Only*:* 22:46:05.107 Write.Heartbeat Pulse: 2009/11/04, CET, 900, 1.9M
ETL_Trans_Only*:* 22:46:07.045 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
ETL_Trans_Only*:* 22:51:07.062 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
ETL_Trans_Only*:* 22:56:07.095 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
Starter: Process [ETL_Trans_Only] is still running [PID=17704], skipping the start point  Wed Nov 04 23:01:00 2009
Starter: Wed Nov 04 23:01:00 2009 [ETL_Trans_Only] will be started on Wed Nov 04 23:16:00 2009 start in 900 seconds
ETL_Trans_Only*:* 23:01:05.159 Write.Heartbeat Pulse: 2009/11/04, CET, 900, 1.9M
ETL_Trans_Only*:* 23:01:07.112 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used
ETL_Trans_Only*:* 23:06:07.208 Source.SourceDef ODS 1 seems to be assigned to multiple DataMarts, or multiple times to the same DataMart, and will not be used

I have added with ETL Assistant the new ODS source (and I have left the old database source).

Can anyone one help me with this issue?

Thanks

[catanirex]

Please check table DM_PROPERTY/SOURCE  i DataMart and table OL_DB_PROPERTIES in ODS1, to see if srcID in ODS1 corresponds with value in DataMart

[panchonet]

Hi,

The brand in the table DM_PROPERTY of Datmart is the same as the brand in the table OL_DB_PROPERTIES in ODS.

Regards

[borkokrz]

[quote]
I have added with ETL Assistant the new ODS source (and I have left the old database source).
[/quote]

What is your test scenario in lab environment ? Do you have backup of production databases or just some lab data in DM and ODS ? Why do you add new ODS source and what this source contains ? Is this a copy of old database source ??

Can you post an extract of DM / Source table ?

[borkokrz]

If you have ETL version 7.2.000.15+ then according to Release Notes:
[quote]
In previous releases of Data Mart, if you assigned the same ODS source to a Data Mart more than once, reports against the Data Mart would yield erroneous results. Now, ETL Runtime will not connect to duplicate instances of the same ODS.
[/quote]

So please check that all srcID's in ODS / OL_DB_PROPERTIES are unique and corresponding to SOURCE_ID of DATAMART / SOURCE. Also check brand field in ODS / OL_DB_PROPERTIES and DATAMART / DM_PROPERTY - they should be the same.

[panchonet]

[quote author=borkokrz link=topic=4851.msg21749#msg21749 date=1257833631]
[quote]
I have added with ETL Assistant the new ODS source (and I have left the old database source).
[/quote]

What is your test scenario in lab environment ? Do you have backup of production databases or just some lab data in DM and ODS ? Why do you add new ODS source and what this source contains ? Is this a copy of old database source ??

Can you post an extract of DM / Source table ?
[/quote]

Hi Borkokrz,

I checked the table Source of Datamart and was pointing to the old ODS (although I had modified the ODS Source with ETL Assistant). I modified the table directly and the ETL Runtime began to aggregate data and transfer them to ODS.

Thank you very much