When trying to delete unnecessary data, the system may display library procedure errors 5 or 6. Their reasons and solutions are described below.
Error 5: Invalid Data Removal Parameters
If error 5 appears, it means that the dates or the parameter of the correspondent are incorrectly selected.
To solve the problem, make sure that:
- Invoice date of incoming balances is less than Min. date of stored documents. Please note that dates cannot be equal.
- The base date of documents is less than or equal to the Invoice date of incoming balances. To find the base date of documents, do the following:
- Open the Sdbman.exe application
- Go to Maintenance > Execute procedure
- In the window that opens, enter the ShParams value in the Procedure field
- Click Execute
- The base date of the documents is shown in field 110, column 101.
- For the selected Correspondent of incoming balances in the Type 2 field, the Special Correspondent is selected. To determine the type of correspondent:
- Open the SH.exe application
- Go to Dictionaries > Counterparties > Correspondents
- Go to the All correspondents tab
- Find the selected correspondent
- Make sure its Type 2 is special correspondent
Error 6: Deleted and Saved Documents are Linked
If the message about an error in the server library procedure 6 appears, then there are documents in the deleted period that refer to the remaining ones.
Information about such documents is recorded in the server log. If the data for a specific position of the note cannot be deleted, the following is displayed in the log:
- Note number
- Note date
- Product name.
Let's consider the examples of errors in the logs:
10/22/2021 15: 02: 23- Obstructed docs (type 1, 5) 10/22/2021 15: 02: 23- P2w / t763 10/6/2020 Jameson Whiskey 10/22/2021 15: 02: 23- w / t45 1/20/2020 Pine nuts
The Obstructed docs (type 1, 5) error — return of goods to the supplier or return of goods from the buyer refers to the deleted notes (r/n or d/n).
Solution:
- Change the period for deleting documents
- Change document flow — create notes of a different type.
10/22/2021 15:02:23- Obstructed docs (type 9) 10/22/2021 15: 02: 24- P2psn949 12/29/2019
Obstructed docs (type 9) — the expense part of the internal sale is included in the deleted period, and the receipt part of the internal sale belongs to the saved part of the notes.
Solution:
- Change the period for deleting documents
- Change the note date
- Change document flow — create expense and receipt notes.
10/22/2021 15:02:24- Obstructed docs (pdoc refs) 10/22/2021 15: 02: 24- Note No. 27 2/25/2016 10/22/2021 15: 02: 24- p / n8 3/31/2016 10/22/2021 15: 02: 24- p / n8 3/31/2016 10/22/2021 15: 02: 24- p / n37 12/25/2019 10/22/2021 15: 02: 24- p / n36 12/24/2019 10/22/2021 15: 02: 24- p / n38 12/24/2019 10/22/2021 15: 02: 24- p / n39 12/25/2019 10/22/2021 15: 02: 24- p / n36 12/24/2019
Obstructed docs (pdoc refs) error — notes, referenced by payment documents in the saved period, are deleted.
Solution:
- Change the period for deleting documents
- Change payment dates.
10/22/2021 15:02:24 - Obstructed docs (idoc refs) 10/22/2021 15: 02: 24- Note No. 27 2/25/2016
Obstructed docs (idoc refs) error — notes, referenced by invoices in the saved period, are deleted.
Solution:
- Change the period for deleting documents
- Change invoice dates.