IBM Support

No more field mappings can be created" - when selecting fields in a code list to be mapped to fields in map *|* -04A6B545

Question & Answer


Question

No more field mappings can be created" - when selecting fields in a code list to be mapped to fields in map *|* -04A6B54521B8AD8A85257917007A3E6B- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

"No more field mappings can be created" - when selecting fields in a code list to be mapped to fields in map

Symptom

On the Select Standard rule that utilizes a Code list?where you can specify the parameters (Sender Code Receiver Code Description Text1 - Text9) and map the values contained in?these fields?from the code list?to fields within the map a pop-up box is displayed stating "No more field mappings can be created" (when attempting to map the ninth field).? Also a Service Error is generated in the Business Process.? ?

Error Message

No more field mappings can be created
A Service Error may be generated on the business process.


Resolving the problem

The SELECT Standard rule using a Code List has a limit on the number of fields that can be mapped.? The map editor will display the error "No more field mappings can be created" on the ninth field attempted.
Though the Map Editor will allow you to highlight and map eight fields before displaying the error not all values will?be mapped to the fields selected.??Up to six fields will properly execute all remaining will be dropped.

A workaround would be to change the rule to an extended rule like the example below.
?
SELECT TEXT1 TEXT2 TEXT3 TEXT4 TEXT5 TEXT6 TEXT7 TEXT8 TEXT9
INTO #CodeListText1 #CodeListText2 #CodeListText3 #CodeListText4 #CodeListText5 #CodeListText6 #CodeListText7 #CodeListText8 #CodeListText9
FROM CODELIST
WHERE NAME = "<name of code list>"
AND SENDERCODE = <sender code>;
//both "name of code list" and "sender code" can be a reference to a string field string variable or a hard-coded value.

For more information about standard or extended rules please see the Map Editor?Help.

Cross reference information
SegmentProductComponentPlatformVersionEdition
CommerceSterling B2B IntegratorMapping and Translation
CommerceSterling Gentran:Server for UNIXMapping and Translation
CommerceSterling Gentran:Server for Microsoft WindowsMapping and Translation

Historical Number

NFX2631

Product Alias/Synonym

Severity


Normal

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10764685