$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

Data source Migration Issue

Oct 28, 2016 at 01:33 PM

141

avatar image

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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

9 Answers

Gajesh Nagesh Nov 01, 2016 at 01:44 PM
0

Hi,

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

Regards

Gajesh

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Ganesh,

The data source is attribute of material master data.

Thanks,

Ipsita

0
Raman Korrapati Oct 31, 2016 at 09:40 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Ipsita Kundu Nov 01, 2016 at 09:43 AM
0

Can anyone help me on this issue....

Share
10 |10000 characters needed characters left characters exceeded
Raman Korrapati Nov 02, 2016 at 02:51 PM
0

Hi,

please share your data source fields screen shot.

Thanks

Share
10 |10000 characters needed characters left characters exceeded
Raman Korrapati Nov 03, 2016 at 09:07 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Raman Korrapati Nov 03, 2016 at 09:45 AM
0

Hi,

previous data source is working well at production???

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

Thanks

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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

capture.png (43.7 kB)
0

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

0

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.

0
Raman Korrapati Nov 03, 2016 at 10:42 AM
0

Hi,

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

Thanks

Share
10 |10000 characters needed characters left characters exceeded
John Hawk Nov 03, 2016 at 01:17 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
John Hawk Nov 03, 2016 at 02:17 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0