Troubleshooting
Problem
While using a map that connects to an external database, the translator errors with "Exception occurred. Property Get Item On Begin Rule, group name = %1".
Cause
The rule did not have the correct column name.
Resolving The Problem
Using the rule from the example documentation,the column name specified is "pub name " (with a space at the end), but the column in the table is "pub name"
strPubName = obRecordset.Fields.Item["pub_name "].Value;
The resolution is to use the correct column name in the obResultset.Fields.Item rule.
One should also be aware that the column format should match the variable type in the map. For instance, in the example rule, the variable strPubName is a string, so the value returned from the Select has to be a char or varchar. If the column is a number type format, the variable declaration should be a Real or Integer type.
( strPubName = obRecordset.Fields.Item["pub_name"].Value; )
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
04 May 2026
UID
ibm17271685