Data source Migration Issue

[former_member206066]

I was migrating one data source (data source for master data attribute) from 3.x to 7.x.

But the data source got inactive giving the error "Field_1 :Missing currency field / unit field FIXCUKY".

Can anyone help me .

[john_hawk]

Hi Ipsita,

You need to add some conditional logic in your transformation rules to populate the amount fields.

If CURRENCY = USD then KF1 = AMOUNT else KF1 = 0

If CURRENCY = EUR then KF2 = AMOUNT else KF2 = 0

If CURRENCY = GBP then KF3 = AMOUNT else KF3 = 0

Don't forget to record your final solution.

John Hawk

[former_member206066]

Hello John,

What do you mean by conditional logic.

Are you suggesting me to use routine or formula or anything else to incorporate this logic in the transformation.

Thanks,

Ipsita

[john_hawk]

Hi Ipsita,

Review the key figure InfoObjects which contain FIXCUKY.

It appears that one or more require a fixed currency, but none has been defined in the InfoObject.

John Hawk

[former_member206066]

Hello John,

There are 3 key figure info objects.

In key figure property ,fixed currency of the 1st info-object is USD, for 2nd it is EUR and ,for 3rd it is GBP.

Thanks,

Ipsita

[RamanKorrapati]

Hi,

What info objects you used for your fields(2,3 and 4) at data source level?

Thanks

[RamanKorrapati]

Hi,

previous data source is working well at production???

previous data source is active at your present system and worked well?

Thanks

[former_member206066]

Hello Raman,

The error is showing in the production but loading is also running perfectly everyday and it is in 3.x version in production.

But when I am migrating this data source from 3.x to 7.x ,it is getting inactive showing the message mentioned above.

Thanks,

Ipsita

[RamanKorrapati]

Hi,

as per your screen shot, You have fields and curr/unit but no info objects which need to hold amount value along with currency and hence you are getting above error.

so please assign required info objects for amounts and check it.

The error is showing in the production??

What does it mean, have you transported your migrated data source to production? or your migrating to 7.x directly at production system??

Thanks

[former_member206066]

Hello Raman,

No my changes are not moved.

In production it is still in 3.x and when I clicked on check button of the data source the same error is showing in production but data is loading perfectly in production.

Info-Objects are also there I have hided that in my previous screenshot.

Find the attached screenshot.

capture.png

Thanks,

Ipsita

[RamanKorrapati]

Hi ipsita,

Thank you for clarification.

please try to do below suggestion at dev system.

i assumed as your 3 assigned info objects are amount related and assigned fixed currency at info object maintenance level. if yes then please remove FIXCUKY object from under curr/unit column. save and activate your data source. later test your data source functionality and see. whether it pulls data same as previous data source or not. if it pulls same as old data source then just continue to go ahead.

Thanks

[former_member206066]

Hello Raman,

I have deleted FIXCUKY but getting the same error message.

But when I am changing data type of these 3 info-objects from "CURR" to "CUKY",it is deleting the "FIXCUKY" from cur/unit column automatically showing the message "FIXCUKY is obsolete type " and working fine.

But we can not change the data type of the Info-Objects as we need to migrate it only.

[RamanKorrapati]

Hi,

As per your data source, which info objects are you assigned to your field,3 and 4 records?

Am unable to see assign info objects at your screen.

Actually when we create amount or quantity info objects at RSA1, we assign related currency/units field there itself(Tab type/unit).

So at data source curr/unit column - you don't need to enter any objects there.

Thanks

[former_member206066]

hello Raman,

I was just migrating the data source.

Previously the info objects were created and FIXCUKY is assigned to that info-object's curr/unit column already.

I think I should not change it as I am only migrating it.

Thanks,

Ipsita

[RamanKorrapati]

Hi,

please share your data source fields screen shot.

Thanks

[former_member186399]

Hi,

Can you let me know which is the datasource you are trying to migrate.

Regards

Gajesh

[former_member206066]

Hello Ganesh,

The data source is attribute of material master data.

Thanks,

Ipsita

[former_member206066]

Can anyone help me on this issue....

[RamanKorrapati]

Hi,

Seems like one currency/unit field was inactive or not part of your data source. please activate or add required field and later you can migrate Your data source to 7.x.

please check your 3.x data source have Amount/Quantity objects along currency/units objects.

Thanks

[former_member206066]

Hello Raman,

I have checked the info Objects assigned to the fields are active.

But the info object's cur/unit column is FIXCUKY. Is there any table to check FIXCUKY??

Please see the screenshot.

data are like that:

Field Description Data Type Length Format Cur/Unit

Field1 Desc1 CHAR 18 xternal

Field 2 Desc2 CURR 17 External FIXCUKY

Field 3 Desc3 CURR 17 External FIXCUKY

Thanks,

Ipsita.