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