A weird problem with Change Capture stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jason2018
Participant
Posts: 5
Joined: Tue Apr 03, 2018 8:39 pm

A weird problem with Change Capture stage

Post by jason2018 »

I design a parallel job with change capture, and my stage properties setting as follow:
exclude values: some fields I don't want to compare
change keys: fields as keys
options:
change mode=Explicit Keys, All Values
other settings as default.
I absolutely assure that I pick up the right fields as the keys, and I check the "key" option of these fields in the columns list.
But when I run the job, I get the error:
Change_Capture: A field cannot be both a key and a value.

If I set
change mode= Explicit Keys & Values
, and explicit the key fields and values fields, it works out.

How could that happen? I've spent nearly all day on that problem. Please help!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome.

I've not used the stage in years so just going by the documentation that says:

Change mode
This mode determines how keys and values are specified. Choose Explicit Keys & Values to specify the keys and values yourself. Choose All keys, Explicit values to specify that value columns must be defined, but all other columns are key columns unless excluded. Choose Explicit Keys, All Values to specify that key columns must be defined but all other columns are value columns unless they are excluded.

I'm wondering if your problem with that last option was the "unless" phrase, was there any overlap between your key and exclude choices?

Edit: after sitting here and staring at my answer while the site slowly attempts to move elsewhere, I'm not sure how helpful it is. Normally I would ask if you've engaged support but if you're really still rocking version 8 of the product, that's not an option for you. Hopefully someone with actual hands-on experience will wander by today. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

chulett wrote:...after sitting here and staring at my answer while the site slowly attempts to move elsewhere...
Just got them to reboot the server. MUCH better now...
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Thanks Andy!

8)

<makes me wonder if there's a memory leak gumming up the works>
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Jason, did you work this out, have a resolution?
-craig

"You can never have too many knives" -- Logan Nine Fingers
jason2018
Participant
Posts: 5
Joined: Tue Apr 03, 2018 8:39 pm

Post by jason2018 »

there is not any overlap between the keys and the values. I've checked
that for several times.
I asked this question on stackoverflow too, but not get a solution until now
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Have you involved your official support provider as well?
-craig

"You can never have too many knives" -- Logan Nine Fingers
jason2018
Participant
Posts: 5
Joined: Tue Apr 03, 2018 8:39 pm

Post by jason2018 »

the official support expired
Post Reply