This article describes possible solutions when running the "Item Purchase History" report results in Everest processing for a few minutes before failing with the error message shown below:
Error Number : 588
Error Message : Error : 723 Error in File
<path to a temporary File> :
Failed to retrieved data from the database.
Details: [ Database Vendor Code : 3621 ]
This issue occurs when the stored procedure called by the report fails to execute successfully. This can be checked by calling
FETCH_ITEM_PURCHASE_HISTORY stored procedure using the parameters given and confirm that it is failing due to 'truncation error'.
This can be resolved in either of the two ways described below:
- Non-SQL Server access
- Find the document that caused the error and change the references field. It is possible the length of the reference field is larger than 20, which is allowed since a reference field in the PO table is 40 characters.
- SQL Server Access
- Modify the @TEMPDOC table declaration on the Reference field to have more than 20 characters.
Users should be able to print and export the "Item Purchase History" report without errors.
Please sign in to leave a comment.