Records are missing if I use navigational attributes in a query

[former_member532796]

Hello Gurus,

I am facing an issue in one BEx report with the navigational attributes in a DSO (call it A). This DSO (A) holds material information & Nav Attr are turned on at DSO level. The source for this DSO is an Infoset (Infoset is based on 3 InfoObjects).

Issue:

For example When I query it based on DSO A & if I include only material in the query I get 200records. Once I include the navigational attributes of material i.e. Material Type, etc into the output the record count remains same in sandbox system but not in quality system. Around half of the records are missing in quality where as in sandbox the count remains same. I have verified the material data and the missing data does exist in quality.

I wonder what could be the issue here. Any help is aprpeciated.

Thanks.

MSR

[former_member182470 · Accepted solution]

You need to load master data for your material characteristic in quality system. It clearly says that master data is partially missing in qua, whereas it is perfect in sandbox. Load master data and run Attribute change run in Qua. Then, you will see same counts in both systems..

Your Infoset will only load data to your Key and Data fields through transformation/DTP. But the nav attrs of your DSO will be loaded through master data load only. So master data loading is must in any system..

[former_member532796 · Accepted solution]

Thank you Suman. I have already loaded the master data in Quality system but the issue still exist. I found an issue with the count in P table to the X table of material IO, they are not matching. This issue exist in production environment as well. I am not sure how can this issue be solved. Any thoughts?

Thank you.

[former_member182470 · Accepted solution]

Hi,

You are getting confused by getting unnecessarily into master data tables.

P table is nothing but Time-independent Display Attribute table

X table is nothing but Time-independent Navigational Attribute table. You should not compare these two tables which does not hold same kind of data.

Delete master data from this IO and reload freshly. Then, the data gets automatically stored into above tables. Please run Attribute Change Run.

Regards,

Suman

[former_member532796 · Accepted solution]

Thankyou Suman.

Actually I have reloaded the master data freshly but looks like SID table is corrupted. When I verified the RSRV I got the error saying the P & X tables are not of same size for IO. I tried to fix it and now it is working fine.

[former_member182470 · Accepted solution]

Good to hear that. Please close the thread..