| FDM Validate Fails for ICP Transaction Module FM11i-G5-D, "Error: Export failed. Detail: Type mismatch At Line: 267 ..." | |||||
|
|
|||||
| Modified 24-JAN-2011 | |||||
Applies to:
Hyperion FDM IC HFM Adaptor - Version: 11.1.1.3.00 to 11.1.2.0.00 - Release: 11.1 to 11.1Information in this document applies to any platform.
Symptoms
When executing the validate step of the workflow using the FM11iG5D intercompany adapter an error occurs. The user error log contains the following error message:ERROR
Code............................................. 13
Description...................................... Type mismatch
At Line: 267
Procedure........................................ clsBlockProcessor.ActExport
Component........................................ upsWBlockProcessorDM
Version.......................................... 1111
Thread........................................... 6324
The issue can be reproduced with the following steps:
1. Click on the validate fish in the FDM Workflow to execute the validate step
2. Error "Error: Export failed. Detail: Type mismatch At Line: 267, as shown in the screen shot below:
Cause
This issue is caused due to the Unpublished Bug 10363412 - ERROR: EXPORT FAILED ON EXTRACT PHASE OF FDQM VS ICP TRANSACTION MODULE
Note: in previous HFM IC adapters, the Conversion Rate and Entity Amount were calculated in the Export action of the adapter. Unpublished Bug# 6733047, which was fixed in 11.1.2, required some changes to the Export process. As of now the conversion rate and entity amount are not calculated in the adapter Export action.It is up to the user to calculate those values (in the Import Format or must be provided in the source file).
Solution
Unpublished BUG 10363412 ERROR: EXPORT FAILED ON EXTRACT PHASE OF FDQM VS ICP TRANSACTION MODULE -> will be fixed in the Intercompany Adapter shipped with FDM 11.1.2.1.Workaround:
Download the latest adapter FM11X-G5-D, which was released in FDM 11.1.2.0.00 and update the adapter Export Action. As needed to add "TransAmt" to the column order in the header of the exported file.
The result is that the column order is correct but it is commented, so if you need to uncomment the column order. Then, convert this in the Adapter code:
'remove the last ;
strColumnOrder = Left(strColumnOrder, Len(strColumnOrder) - 1)
objFile.WriteLine(strColumnOrder)
To this:
strColumnOrder = strColumnOrder & “TransAmt”
objFile.WriteLine(strColumnOrder)
Note:
- In the latest adapter FM11X-G5-D, which was released in FDM 11.1.2.0.00, you will see that this behavior has changed. We no longer perform the conversion happening on line “267” instead we simply write out the contents of each dimension, if available, otherwise we default to specific, dimension relative, values.
- The behavior has changed in this version of the adapter. While the default enabled dimensions remain the same, the behavior for Conversion Rate and Entity Amount has changed. The customer will need to be aware of this information and plan accordingly (i.e. update Import Format).
- In the latest adapter FM11X-G5-D, which was released in FDM 11.1.2.0.00, you will see that this behavior has changed. We no longer perform the conversion happening on line “267” instead we simply write out the contents of each dimension, if available, otherwise we default to specific, dimension relative, values.
- The behavior has changed in this version of the adapter. While the default enabled dimensions remain the same, the behavior for Conversion Rate and Entity Amount has changed. The customer will need to be aware of this information and plan accordingly (i.e. update Import Format).
GKontos
Comments