Nulls appear for business key columns on SCD Type1 update

RudreshEswarappa · Post by **RudreshEswarappa** » Wed Oct 01, 2008 3:13 am

Hi,

I am using SCD stage to do type 1 updates on a particular table.The business key field is of type varchar. When changes on the attribute takes place instead of update a new row is inserted but with business key value NULL.

I tried changing the datatype from varchar to integer (since value were compatible for datatype change) and the type1 update was successful. but now i have a table with values that cannot be integer and I cannot find any workaround.

Can anyone help?

Thanks in advance.
Regards

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2008 3:28 am

I wonder if this is related to the known bug in which range lookups work for numeric data types but not for string data types?

Alas I can't help with a solution.

RudreshEswarappa · Post by **RudreshEswarappa** » Wed Oct 01, 2008 3:45 am

Thanks for the response Ray.

What do you suggest... Shall I take it up with the support then? this is something That has to be implimented ASAP...

Can you suggest any workaround.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2008 5:58 am

If it's urgent why are you waiting for my advice? You are paying your support provider; let them earn some of it.

platonfi · Post by **platonfi** » Thu Oct 16, 2008 6:27 am

Support has a client side patch for this known issue.

algfr · Post by **algfr** » Fri Jul 17, 2009 8:01 am

Hello

I think I have this issue, it is a HUGE problem.

I have DS 8.01 FP1a

Could you tell me if this version has the issue or not ? I can't find it on the IBM site.

algfr · Post by **algfr** » Fri Jul 17, 2009 8:08 am

It is a client patch not a server patch ?

algfr · Post by **algfr** » Mon Jul 20, 2009 2:18 am

Nobody has a clue ?

It really surprises me as this bug seems huge (no way to lookup on a varchar)...

I've opened a case at IBM so I'll let you know.

algfr · Post by **algfr** » Tue Jul 28, 2009 5:59 am

IBM says : Appears to be the patch_JR30746v2_client_windows_801fp1.zip on the client side. Don't know if that works yet. It's weird to me a patch can be on the client side...

chulett · Post by **chulett** » Tue Jul 28, 2009 8:01 am

From what I've seen, most patches for 8.x are applied from the client side, that doesn't necessarily make them a 'client patch' however.

algfr · Post by **algfr** » Thu Jul 30, 2009 9:57 am

So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.

Anyway I'll let you know

algfr · Post by **algfr** » Fri Aug 07, 2009 1:58 am

algfr wrote:So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.

Anyway I'll let you know

Ok, this is the correct patch, this works now.