Description of the problem: Suddenly all the outsourcing processing into the library can not be reviewed, but can save the on-site processing: the problem does exist on the client computer test problem, replace a computer to replace the operator problem is still the same, the server operation is the same, restart the server problem did not solve the background processing: suspect that there is a problem with the background database, check ICShop_Item The maximum value of FinterID Consume in the consume table is 77497. Check the maximum value of FMaxNum consume in the ICMaxNum table corresponding to ICShop_ItemConsume table is 77496. The two maximum values are inconsistent. Make the two maximum values consistent, the problem is solved, the specific operations and SQL statements are as follows:
Back up the ledger before background data processing
Perform operations on the SSMS platform of the server
SA System administrator account Logs in to the database
This page is based on experience
Select the account in question for a full backup operation, preferably at the end of the day
Open the SSMS platform
Select the sa user to log in to the database
Select the database entity in question
Enter the SQL statement :select*from ICMaxNum where FTableName like 'ICShop_ItemConsume' to find out that the ICMaxNum value of the current account is 77496select *from Update ICMaxNum set FMaxNum = 77497 where FTableName like. Icmaxnum set fmaxnum = 77497 where ftablename like 'ICShop_ItemConsume' Updates the ICMaxNum value to 77497 to ensure that the maximum values of the two tables are consistent
After the modification, the outsourcing processing receipt of WWJGLK17-02-14004 has been successfully audited, and subsequent material acquisition and verification operations can be carried out!
When the product receipt cannot be audited, this method can also be used to solve the problem
Background data modification is risky, please back up the account and be operated by professionals
The outsourcing processing documents cannot be audited, which will affect the material inventory and subsequent material requisition, and also affect the verification operation of the outsourcing processing warehouse receipt
Keep a record of all the processes in case of query, you may also encounter this kind of problem