Error while accessing 'Create Customer Product Authorization(s)' Application in Portal

[Dheerendra]

Hi There,

We are trying to access 'Create Customer Product Authorization' application through Portal and getting below error.

Root Cause:

The initial exception that caused the request to fail, was:

com.sap.mdm.MdmIllegalArgumentException: Field with ID 'F604_349645' was not populated or does not exist in repository for table 'T76'

Shall we need to check the custom code? I am new to MDM area, so plz help me in this regard.

Any suggestion are most welcome.

Thanks

Dheerendra

[Former Member · Accepted solution]

Hello Dheerendra,

Looks like, you have not populated mandatory field in your application.

Can you give more detail on filed where you are passing value?

What kind of field it is and what values you are passing.

Thanks,
Manisha

[Dheerendra · Accepted solution]

Hi Manisha,

Thanks for reply.

Below is the Error description, what we are getting on portal side, when run the apps(product authorization):

------------------------

com.sap.mdm.MdmIllegalArgumentException: Field with ID 'F604_349645' was not populated or does not exist in repository for table 'T76'

at com.sap.mdm.internal.data.RecordImpl.getFieldData(RecordImpl.java:1089)

at com.sap.mdm.internal.data.RecordImpl.getFieldValue(RecordImpl.java:211)

at com.millercoors.mdm.products.util.ProcessResultSet.processOrderTool(ProcessResultSet.java:472)

at com.millercoors.mdm.products.model.ProductMaster.getOrderTools(ProductMaster.java:73)

at millercoors.com.mdm.products.wdmodel.searchmodel.WdSearchModel.getOrderTools(WdSearchModel.java:1626)

at millercoors.com.mdm.products.wdmodel.searchmodel.wdp.InternalWdSearchModel.getOrderTools(InternalWdSearchModel.java:700)

-----------------------

I checked the code & it seems fieldvalue are coming dynamically from schema. see below code snippet.

------

ArrayList valueList = null;

Record[] recordArray = resultSet.getRecords();

TableSchema orderToolSchema = LoadMDMTableSchema.orderToolSchema;

FieldId[] fieldIDs = OrderableSKUAuthorizationFieldIDs.getOrderToolFieldIds(orderToolSchema);

if (recordArray != null && recordArray.length > 0) {

valueList = new ArrayList();

for (int i = 0; i < recordArray.length; i++) {

OrderTool or= new OrderTool();

Record currRecord = recordArray[i];

or.setOrderToolId(currRecord.getFieldValue(fieldIDs[0]).toString());

or.setOrderToolName(currRecord.getFieldValue(fieldIDs[1]).toString()); ....and so on....

------

Any suggestion are most welcome.

Thanks

Dheerendra

[Former Member · Accepted solution]

com.sap.mdm.MdmIllegalArgumentException: Field with ID 'F604_349645' was not populated or does not exist in repository for table 'T76'

at com.sap.mdm.internal.data.RecordImpl.getFieldData(RecordImpl.java:1089)

at com.sap.mdm.internal.data.RecordImpl.getFieldValue(RecordImpl.java:211)

at com.millercoors.mdm.products.util.ProcessResultSet.processOrderTool

1. ArrayList valueList = null;
2. Record[] recordArray = resultSet.getRecords();
3. TableSchema orderToolSchema = LoadMDMTableSchema.orderToolSchema;
4. FieldId[] fieldIDs = OrderableSKUAuthorizationFieldIDs.getOrderToolFieldIds(orderToolSchema);
5. if (recordArray != null && recordArray.length > 0) {
6. valueList = new ArrayList();
7. for (int i = 0; i < recordArray.length; i++) {
8. OrderTool or= new OrderTool();
9. Record currRecord = recordArray[i];
10. or.setOrderToolId(currRecord.getFieldValue(fieldIDs[0]).toString());
11. or.setOrderToolName(currRecord.getFieldValue(fieldIDs[1]).toString()); ....and so on....

Hi Dheerendra,

After looking into error (bolded above), i feel that line 10 and 11 is causing error.

Looks like Data value for field id  'F604_349645' is indirectly getting populated from OrderableSKUAuthorizationFieldIDs.getOrderToolFieldIds(orderToolSchema); (line4).

Please check the data you are providing for "OrderableSKUAuthorizationFieldIDs.getOrderToolFieldIds(orderToolSchema)".

Just to make sure you can try to hard code this value in Portal and if it runs successfully, you will need to check the value for and concept for line 4.

Thanks,
Manisha

[Dheerendra · Accepted solution]

Hi Manisha,

Thanks for your reply..

fyi:

There was no issue with the coding.

our Problem got solved after Portal Server Re-Start.

Thanks

Dheerendra