Multi step OLEDB error
“Error while running Re-Formatter: The multi step OLEDB operation generated error. Check each OLEDB status value if available.”
Most of the times this errors implies wrong database structure for destination company database. In particular, check the table structure of GL00100 and GL00105. Each of these tables should have as many account number columns as the maximum segments allowed in the framework. Also the length of each account number column should be 1 more than the maximum segment length for each column. For example if the maximum length of a segment is 5, the related account number field length should be 6.
If the structure of any of these tables is wrong, please delete the company from Great Plains and re-create the company using Great Plains utilities. No changes should be made to table structures through SQL Server.
0 Comments