DSXchange

Posted: **Mon Jun 24, 2013 9:29 am**

I am trying to use the IBM CDC tool to send flat files into datastage. I have both my datastores set up correctly, yet after making a subscription the program crashes when I try to map tables.

I receive the following error:

Code: Select all

Updating the tables available for replication...
Loading users...
Loading source tables...
Notifying target of changes to the subscription...
Reloading table mappings...
Mapping source table CREGMT [1/1]...

ERROR:
Could not complete the mapping for target table TS_FLATFILE because the source table is missing on the target datastore. This may be caused by an incomplete describe. Check the event log for related events and a possible cause.

An error has occurred.

Which really doesn't make any sense. I never have the option to select a destination table, nor would I want to. I'm trying to use flat files.

Any suggestions on where to go or look? Sorry if there is a topic on this, search was broken at the time of writing this.

Thanks,

Nathan

Posted: **Mon Jun 24, 2013 12:26 pm**

Do the requested, "Check the event log for related events and a possible cause"

Posted: **Mon Jun 24, 2013 12:29 pm**

I have checked every event log I can find for CDC both on my local install and the server. Neither has recent events.

Posted: **Mon Jun 24, 2013 12:54 pm**

"Neither has recent events", very weird no?
Anyway, in lasteds events, have any helpful message? or unknown?

Posted: **Mon Jun 24, 2013 2:21 pm**

The latest events are days old, they have no relation to the current work. Some of the most recent events I could find are months old.

Posted: **Mon Jun 24, 2013 2:32 pm**

All CDC jobs aborting with this same error?

Posted: **Mon Jun 24, 2013 2:35 pm**

This is the first CDC job my team has dealt with.

Posted: **Mon Jun 24, 2013 7:30 pm**

Tornquist wrote:

Code: Select all

ERROR:
Could not complete the mapping for target table TS_FLATFILE because the source table is missing on the target datastore. This may be caused by an incomplete describe. Check the event log for related events and a possible cause.

An error has occurred.

Code: Select all

I have already fixed the problem. In the Windows Server 2008 machine, when I created Oracle Instance I need IP address for hostname parameter (I use localhost previously).

I read this somewhere else. This may help you.

Posted: **Wed Jun 26, 2013 3:06 pm**

Sura's solution did not apply to my problem. I'm currently working with IBM to resolve the issue, but it looks like there were some configuration errors in the destination datasource. I'll share any helpful information if I am able to.

DSXchange

IMB CDC Flat File w/ DataStage Issues

IMB CDC Flat File w/ DataStage Issues

Re: IMB CDC Flat File w/ DataStage Issues