DTP Load Error ( ASSIGN_TYPE_CONFLICT)

[Former Member]

Hi All,

I have added new field in Open Hub table then I tried to load the data to Open Hub table.

DTP, I have filter selections based on CALMONTH = 201409

I am getting dump  -- ASSIGN_TYPE_CONFLICT

Please help me..!

Thanks

Prakash

[RamanKorrapati]

if your dtp is delta one or full load?

if its dleta one then have you inited based on same selections?

As my guess your delta was exist without any selections and now your running delta dtp with selections. in such cases above error will occurd.

if you need run dleta dtp with seletions then first you need run init dtp with same selections(201409).

[Former Member]

Hi  Ramanjaneyulu,

Thanks for the reply...

My DTP Load is "FULL" Load with selection CALMONTH = 201409 (OLAP Variable) this is running daily basis in P as per the requirement I have added new field and triggered load but I checked data in cube level same selection I found no data but I am getting error message ASSIGN_TYPE_CONFLICT Dump(ST22)

Please help me

Thanks

Prakash

[RamanKorrapati]

You only one dtp or have multiple dtps for your target?

if yes then please check about selections(existing dtp form same source to same target),

As you said its full dtp then remove selections try to run dtp, whether its five error or not.

if not giving then issue with selections.

[Former Member]

I have only one DTP (Full) load available to Open Hub

I have created new DTP (Full & Delta) without any selections and triggered the load but still I am getting same error message..

do i need to check any thing in Open Hub level ...I have added new field "Job Grade" in open hub table same field which is already exist in Cube level....

Please help me..

Thanks

Prakash

[Former Member]

HI Prakash,

Check this thread:-

reactivating the transformation, DTP and checking the semantics solved the issue.

Regards,

Sakthi

[RamanKorrapati]

Try to activate your open hub, transformations and dtp.

later try to execute your full dtp and see.

[Former Member]

Hi Sakthi and Ramanjaneyulu

Thanks for the reply..!!

I reactivated complete flow and Open Hub. then executed the DTP now it fetched records.

I am wonder... is there any dependency to reactive complete flow for this?

Thanks

Prakash

[RamanKorrapati]

You changed your open hub by adding one field, that might be caused.

you didn't activated properly. so that's may caused some inconsistencies at target table.

if you done above actiavtion at prod then nothing is required.

if you done at bwq or bwd then you need to the same at bwp.