- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.7K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.5K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Receiving "Data Access Error" during Export
Im working on FDM18.104.22.168 and my scenario is like: In my source file, i dont have currency column but its there in my target system(i.e., Essbase). So in my Import Formats, i added a currency column and gave "0" as the field number and number of fileds and always my target currency would be "LCProd" so i provided it in the expression column. In the mappings section, for currency, we have "Like" type mapping with source and target as "*".
Now, in the workflow, im able to Import and Validate the data and i receive Orange fish there and during the Export, it throws an error message saying "Error: Data Access Error" but i receive orange fish eventhough.
When i retrieve data from Smartview connecting to the target Essbase Application, there is no data, even i append or replace during the FDM Export.
Please guide me on this.