Insight mapping to Focal Point - field length limit?
My team is mapping a custom Focal Point workspace into Insight, and we've used Configuration Manager to generate an XDC file and to map the fields into the Insight fields. When opening the auto-generated XDC files in the XML Data Configuration tool, we have several errors along these lines, where the value in single quotes is the Focal Point field name:
CRRRE1604E: The database name of TableColumn: The 'value_FW_Uncommitted_Total__115' field name exceeds the maximum length of 30..
Is this a limitation Insight puts on field length, or a REST API limitation? I notice that when I put the REST query for this Focal Point module in the browser it crashes so it seems like it may be more than an Insight limitation, but I need more information to go back to my Focal Point team to discuss. Thanks!
CRRRE1604E: The database name of TableColumn: The 'value_FW_Uncommitted_Total__115' field name exceeds the maximum length of 30..
Is this a limitation Insight puts on field length, or a REST API limitation? I notice that when I put the REST query for this Focal Point module in the browser it crashes so it seems like it may be more than an Insight limitation, but I need more information to go back to my Focal Point team to discuss. Thanks!
3 answers
The maximum length of the table column name is set in the XDC tool.
But the configuration manager should not generate a xdc file with an invalid length of the table column name. This should be an issue in the Configuration Manager.
To work around it, you can modify the related table column names through XDC tool manually.
But the configuration manager should not generate a xdc file with an invalid length of the table column name. This should be an issue in the Configuration Manager.
To work around it, you can modify the related table column names through XDC tool manually.
My team is mapping a custom Focal Point workspace into Insight, and we've used Configuration Manager to generate an XDC file and to map the fields into the Insight fields. When opening the auto-generated XDC files in the XML Data Configuration tool, we have several errors along these lines, where the value in single quotes is the Focal Point field name:
CRRRE1604E: The database name of TableColumn: The 'value_FW_Uncommitted_Total__115' field name exceeds the maximum length of 30..
Is this a limitation Insight puts on field length, or a REST API limitation? I notice that when I put the REST query for this Focal Point module in the browser it crashes so it seems like it may be more than an Insight limitation, but I need more information to go back to my Focal Point team to discuss. Thanks!