Troubleshooting > Troubleshooting DataConnect > Error writing file or closing command object
Was this helpful?
Error writing file or closing command object
 
Error Code
27
Error Message
Error writing File - Closing Command Object.
Description
Dynamic 365: An error returned from an HTTP write operation.
Excel: To initialize new sheet Before transformation event is required. This error may be displayed for connectors like Excel 2007, Excel 2010, and Excel xlsx.
Cause/Solution for Dynamic 365 connector
Not known.
Cause/Solution for Excel connectors
Cause: Microsoft Excel supports 1,048,576 rows and 16,384 columns.
Solution: You can write 1,048,576 rows at a time:
1. Click the Configuration Tab.
2. Expand “Map Events”.
3. Add “TransformationStarted” map event.
4. Add Table operation Drop and create.
5. Run the transformation.
Related Information
Last modified date: 08/04/2024