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 MessageNo 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.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Commerce | Sterling B2B Integrator | Mapping and Translation | |||
| Commerce | Sterling Gentran:Server for UNIX | Mapping and Translation | |||
| Commerce | Sterling Gentran:Server for Microsoft Windows | Mapping and Translation |
Historical Number
NFX2631
Product Alias/Synonym
Severity
Normal
Was this topic helpful?
Document Information
Modified date:
12 October 2021
UID
ibm10764685