Database migration

NICE CXone API & Integrations
1

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

2

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

3

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

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

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 ?

2 Likes
5

If you have ETL version 7.2.000.15+ then according to Release Notes:

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.

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.

6

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

1 Like