Skip to Content
0
May 02, 2007 at 02:23 PM

Help please! UD connect datasource can not stay in synch with source table

126 Views

I have been using UD connect to extract data from Sybase table views for 2 years already. As many who have used UD connect know it is very diffcult to get it to work. But I went through all that and at least it has been working fine except sometimes difficulty transporting. And I am aware of all major OSS notes about UD Connect.

However this loading error has been driving me crazy. Almost on a daily basis some data loads would fail with error 'DataSource (datasource name) has to be replicated '.

So I re-generated the datasource and activated infosources, test loaded and it all worked fine. Come next morning it would fail again with the same error.

I talked with DBAs and they swear that no table changes were made overnight. then after it keep happening for several days in a row, I ruled out table change possibilities. Especially when I read this morning the error message:

DataSource (datasource name) does not have the same status as the source system in the Business Information Warehouse.

The time stamp in the source system is 2007.05.01 17:40:59.

The time stamp in the BW system is 2007.05.01 17:39:45.

The timestamp is only less than 2 minute apart.

Can anyone give me any pointers?

I now have a production support problem everyday.

Any help is greatly appreciated!

Julian