IMB CDC Flat File w/ DataStage Issues

[Tornquist]

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

[max.madsen]

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

[Tornquist]

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

[max.madsen]

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

[Tornquist]

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.

[max.madsen]

All CDC jobs aborting with this same error?

[Tornquist]

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

[SURA]

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.

[Tornquist]

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.