Correction of wet milk 1s. The most common fixes of 1C and methods for correcting them. Correction of in-line flow at b_k change

There are faults in the work of databases that arise from a variety of reasons, starting with an electrical disconnection and ending with a breakdown of the equipment, affecting both the account manager and the system administrator. And if the user just knows that the program allows, for example, to re-engage, otherwise close it and not exit, the administrator will joke around and fight with them.

The first suggestion of the skin doctor in such a situation would be to update the backup copy. Since there is no such thing and it is outdated, it will be necessary to carry out a number of cumbersome actions, for example, to protest the 1C database. In this article, we will look at just one of the mechanisms for searching for and removing data from 1C databases, as well as the features of this search engine.

We will look at the testing and correction of the 1C information base using the example configuration of 1C Accounting edition 3.0 (release – 3.0.54.20), platform - 8.3.10.2561. For older editions and other configurations, and platform version 8.2, the operating algorithm of this utility is similar.

It is worth mentioning from our general knowledge that before ANY manipulations with the 1C configurator, including before testing and correcting the 1C 8.3 database, it is recommended to create a backup copy of the database with which Mother's going to the right.

The required mode of operation, creation, to protest the 1C database and correct the detected errors, available in the configurator, in the “Administration” menu section.

Having launched the utility, we will now see:

It is important to change the verification of modes, as well as testing methods. We're talking about the skin of them.

Reindexing IB tables– when checking this box, the table will be re-indexed. This is the process of completely rebuilding the indexes on the database table. Reindexation will greatly reduce the productivity and speed of 1C systems.

Controlling the logical integrity of IB– a mechanism for checking the organization of data, as well as finding solutions to the logical and structural integrity of the database being monitored.

The integrity of IB is possible- checks the IB for the presence of “broken” or “empty” messages, which appear when information is processed incorrectly, and most often when data is deleted or data exchange is incorrectly configured.

Change of pouches, We understand what we are dealing with in 1C registers. This table of results, collected data, makes it easier and faster to analyze without looking at the entire register. The procedure is designed to increase the speed of the database.

Embossed table IB- Changes to the database. On the right, when objects are deleted from the database, 1C does not delete them at all, but only marks them as deleted. Tobto. the smell will be lost from the database, but not available from the robot. While such data is not removed by special processing, it is removed when the IB table is compressed. For the same effect, before speaking, you can access the database file.

Restructuring of IB tables– during this process, the system recreates the database tables. Please note that this will be displayed when changes are made to the configuration metadata structure. The process can take a trivial hour.

At the bottom of the list there is a field for selecting the type of testing: either we pass simply testing, in which the system will show obvious errors, but they are not correctable, or testing with further corrections. In this case, the system is designed to correct all known errors.

Even lower are the options for working with “broken” messages and with frequent data loss. Three options are available:

• Create objects– the system creates an empty element that can be filled with data manually.
• Cleanse the area– “beats” sent and objects with partial data will be deleted.
• Don't change it- The system will not change the objects if you have shown your benefits.

The first remaining area of ​​our window is the ability to slow down and continue to interrupt testing. On the right, in real databases the process of testing and correction can take three hours (from 1-2 to 20-30 years). If you suspect that the system has been performing verification for a long time, you can check the box “Stop verification after” and set a time interval after any verification will be interrupted.

After checking the “Continue interrupted testing earlier” checkbox, press the “Visit” button and continue testing from scratch.

chdbfl.exe utility

For a number of reasons, we cannot access the configurator - we do not have rights to launch, for example, we can quickly access the “chdbfl.exe” utility. This, in essence, is analogous to testing and correcting a file (not suitable for SQL) information base. You should check the physical integrity of the database. Let's take a look at how and how to profit from it.

We go to the folder with the installed platform. There is no need to encrypt the file.

After launching, we will soon see:

You need to indicate the path to the database file and confirm (or not forbid anyone) the need to correct the detected errors. The path to the database file can be found in the list of databases.

After the verification is completed, the system will notify you that a compromise has been found.

1C experts reveal how to correct government payments, allowances from the accounting and tax authorities from the income tax.

Let's look at how the program "1C: Accounting 8" edition 3.0 can correct a technical error that was allowed during the registration of the document.

butt

Spend on renting office space from the program for additional documents Entry (act, invoice) at a glance at the operation Service (act). It is likely that access to all documents is provided in the section Purchases. As a result of the document, accounting entries were generated, as well as records from special resources for the purpose of filing a tax account for accounts with the sign of a tax account (NU):

Debit 60.01 Credit 60.02 - for the amount of the insured prepayment for rent (76,700 krb.); Debit 26 Credit 60.01 – for payment of rent (65,000 rub.); Debit 19.04 Credit 60.01 - the amount of maximum allowance (11,700 krb.).

The document was registered on the document stand Rakhunok-texture of omissions, and the maximum allowance was accepted before retirement at full expense during the period of service. These records have been entered into the accounting register and special registers for the PDV area.

To display the approvals in the form, allowed by the client during the registration hour, the original documents and invoices were withdrawn from the postal owner, follow the quick document processing of the cloud system Koriguvannya nahodzhennya. The document must be completely deposited on the document stand Entry (act, invoice). For which you need to press the button Enter on the platform(available both in the form of the receipt document and in the form of the list of documents of receipt) and select the command Koriguvannya nahodzhennya.

Document form Koriguvannya nahodzhennya on deposit Golovne is modified depending on the selected type of operation, as well as the period of making changes to the base document.

Subject to paragraph 6 of PBO 22/2010, the acknowledgment of a significant fate is revealed after the completion of this fate, and before the date of signing the accounting records for this period, the accountant must correct the records for the following sections I thank you for the bosom of this fateful fate. There is a document in our vipadka Koriguvannya nahodzhennya date date 2015 (field view).

On stock Golovne in the field type of operation The following operations are available:

• Correction of the original documents - Vikory is used to reflect the correction of approvals made by the postal owner at the time of registration of documents. Corrections in the original documents are not independent and are carried forward to the same period as the document itself that is being corrected. The postal clerk, correcting the original documents, inserts the corrected invoice;
• Correction for weather conditions - registers the agreement between the seller and the buyer for the change in price before the goods are sold, and the service works so that it is independent from the production line. The postal worker always displays a customized rakhunok-texture;
• - is intended for correcting amendments to the entry of data allowed by the court during the registration of the original documents and (or) the withdrawal of the invoice details, which allows for correcting the amended entry of the details of the invoice, including soum indications. Correction is carried out to the same period that the document itself was entered incorrectly.

Pieces behind the minds of Priklad 1 in the form of the organization was allowed a technical clearance, then it is necessary to select the type of operation Correction of moisture mixture(Fig. 1).

Small 1. Document “Koriguvannya nakhodzhennya”, tab “Golovne”

Depends on the set value of the details Represent the original design The document can display changes in two ways:

• In all sections the appearance(You need to deselect this option);
• Lishe in the guise of PDV.

Peremikach Variation of income and expenditure in Appendix 1, set the position Bring the same shell as the servants (20, 26, 44,...).

Table parts Productsі Services automatically register for the document entered in the field Falling asleep. The skin row of the output document is indicated by two rows of the document editing (Fig. 2):

• before change;
• after change.

Small 2. Document “Koriguvannya nakhodzhenya”, tab “Services”

Have a row before change A certain amount of money is transferred from the output document, and this row is not edited. Row after change the beginning is filled with the same values, in a row before change. In a row after change It is necessary to indicate corrected sums.

On the document stand Koriguvannya nahodzhennya It is necessary to register the corrected version of the document Rakhunok-texture of otrimanias behind the button Register.

After completing the document Koriguvannya nahodzhennya The following accounting entries will be generated:

Debit 60.02 Credit 60.01 - for the amount of the advance payment made to the postal owner (35,400 rubles), paid for the rent; REVERSE Debit 68.02 Credit 19.04 - for the entire amount of PDV (11,700 rubles), which was previously received in advance for recovery according to the “wrong” invoice, which furthers the cancellation in the purchase book; Debit 68.02 Credit 19.04 - for the deposit amount of the maximum allowance (RUB 6,300); REVERSE Debit 19.04 Credit 60.01 - at the settlement, the sum of the presented maximum allowance (5400 rub.); REVERSAL Debit 26 Credit 60.01 – on the settlement of zavishennia vartosti orendi primіshchenya (30,000 rubles).

For the purposes of the tax contribution to the income tax, the corresponding amounts are also recorded in the resources Suma NU Dtі Suma NU Kt for racks with the sign of a subductive obliku (NU). The difference (permanent (PR) and time-hour (TP)) between the accounting and tax data does not vary.

Without blame, all records are dated 12/31/2015. After Vikonannya obrobki Closed month(divided Operations) with automatic completion of the accounting and tax reporting data, it will be applied both to the accounting reporting and to the organization’s income tax declaration for 2015. And the clarified declaration of income tax for 9 months of 2015 will have to be completed manually. For the Central Establishment of the TSOO, the reservations are firmly firmatic of the row 040 “INFORMATION Vitrati-VSOO” Dodatka No. 2 to Arkush 02 Declarats for the erthum (approved by the PNP of the Federal Tax Service on 11/26/2014 No. MMV-7-3/600@), Slid Zmenschet for 30,000 rub.

After completing the document Koriguvannya nahodzhennya In addition to the entries in the accounting register, corrective entries are entered before the accumulation registers Maximum permissible limit (maximum permissible limit)і MPE for purchases. If the price of additional goods and services changes, the additional entry of the purchase book for the third quarter of 2015 will be formed automatically. The additional ark will display the following entries:

• reversal - the amount of the PDV is registered for the milkova;
• the amount of maximum allowance, which is accepted before recovery, is presented behind the invoice from the postal clerk.

Operations from the correction of moisture and from the recovery of maximum permissible income from rent will be automatically reflected in the clarification of the declaration from maximum permissible income for the third quarter of 2015:

• in Section 3 “Rozrakhunok sum up the donation, which extends the payment to the budget...”;
• Section 8 “Views from the purchase book...”;
• Addendum No. 1 “Videomosti from supplementary sheets of the purchase book” to Section 8 of the declaration of MDV (approved by the order of the Federal Tax Service of Russia dated October 29, 2014 No. ММВ-7-3/558@).

It is likely that the organization can independently calculate and pay penalties, since the due amounts of taxes are paid at a later date in accordance with the legislation established on taxes and collection lines (clause 1 of Article 75 of the Tax Code of the Russian Federation).

To disburse the amount of money that the tax payer may pay as a penalty, you can quickly use the procedure for distributing the fine from the section “Targets and Deposits” in IS 1C:ITS.

The functioning of programs may be disrupted due to an emergency operation of the robot, for example, when the power is turned off. Then the database cannot be accessed.

Any program that is running may show incorrect results. There are documents in this list; when you try to open a document, the program freezes, and different results appear. All these “glitches” are fixed after testing and correction of 1C.

Repairs may appear not only crudely, but also as a result of inaccuracies and drive “repair work”.

Reasons that lead to problems:

• Emergency operation of robots (Raptove vimknennya zhizlennya);
• Physical wear of the hard disk;
• Computer malfunctions.

Before correcting the database, make a backup copy

Before testing the database, it is imperative to create a backup copy.

It is possible to make direct copies of the catalog containing the information base. If you cannot go into the Configurator, you can only make a copy in this way.

If you managed to get to the Configurator, you need to select the Administration → Vivantize information base option in the menu as in Fig. 1. In the window you need to specify the directory for recording the backup copy and the name of the file in which the archive will be saved.

Before testing and correcting the copy, it is necessary to work hard, and irrevocable changes to the data will be made during the time of correction. Sometimes (even more rarely) smells can fill up and ruin the data base.

During normal operation, backup copies need to be run regularly, preferably daily. In order for this robot to be configured automatically, install a cost-free program Backup-1C Accounting backup copies.

The best way to save backup copies is not to destroy the database itself. A flash drive, an Internet connection, or another hard drive will do. Sometimes data loss is associated with physical wear and tear on the hard drive.

The availability of backup copies is insurance against data loss. However, you cannot guarantee that everything is perfect in the backup copies, so the relevance of the Testing and Correction option does not change.

Small 1. Vivantage of data.

Let's summarize the pouch:

• Backups need to be performed regularly;
• Save backup copies on another device;
• For automation there is a program Backup-1C Backup copies of accounting;
• Before testing and correction, it is obligatory to make a copy of the database.

Correction of the information base using internal program methods

After the backup copy has been created, we open the database in Configurator mode. Select the menu option Administration → Testing and updating the information base.

You need to check the box (Fig. 2).

Or better yet, do not work: not all operations listed in the menu are required for repairs after an accident.

Fig.2. It is possible to test and correct 1з8 with ticks placed on all items. So there is NO REQUIREMENT:

Once all the points have been checked, a trivial process will begin. The results of testing and correction are displayed in the lower part of the window. After selecting the action, you need to press the button Shut up.

Vikonati everything is not the best option! Qualified professionals will finish the process step by step and selectively.

Stage of management

Let's take a look at all the items in the Testing and Correction menu.

• Reindexing table of information base;
• Checking logical consistency;
• Check the integrity of the message;
• Change of pouches;
• Embossed table;
• Restructuring the table.

The first stage, re-indexing the information base table, helps to resolve 90% of problems. What does the re-indexing process involve?

The entry of data to the documents, the creation of new documents is accompanied by their automatic ordering. Namely check for the alphabet, documents – for dates, etc. In this case, the physical order of the records is not changed. Records are displayed on the screen in order, as they are assigned numbers (indexes), and the assignment of the index to the physical number of the record is located in the index tables.

Indexes are very important:

• There are more searches in indexed tables than in non-indexed ones;
• Index number – this is a unique code for a record; the indexes are followed by links between records from different tables;
• Index tables are the framework of the information base; Without them, the 1C program does not work.

The destruction of index tables leads to chaos for submitted documents. For example, a document may appear showing the daily names of goods, and their number.

Each new record is accompanied by changes in the index tables: for example, after making a record before the editor that begins with the letter A, it will be assigned one of the first indexes, and the decision of all index numbers will be changed . The short pause that occurs after making a new entry is due to the re-inventing of indexes; The larger the base, the shorter the pause.

The creation of a document and records from a new person gives rise to a number of index tables (sometimes several dozen). In fact, the re-indexing of table 1c is carried out steadily while working with the data. In operational mode, only one or a few tables are indexed, but when tested and corrected, all tables are indexed again, and this process for large databases takes three hours.

Also, when re-indexing the following processes occur:

• The records are re-ranked and re-ordered;
• Links between tables and other objects are updated;
• In many cases, the robot program is updated.

After re-indexing, you can check whether the database has become useful.

The offensive stage is a reversal of logical integrity. The authenticity of the real structure of the information base and the description of the configuration are checked (the presence of objects, the presence of connections between objects). This recheck often informs the base about amends, which is why they should not panic with such information. However, there is a reason to seek consultation before filing.

Checking the integrity of the message “rings through” connections between objects. Sometimes in the table the message is sent to a particular object, for example, a deleted document. It is customary to manually verify the completeness of the list and remove it as a result of verification. Sometimes the complete integrity is destroyed on “backed-up plots” - old, outdated documents. They simply don’t have any respect for them.

Rearrangement of pouches – the procedure was trival and rizikovana. In 1c, the results are re-arranged in the normal mode, but not every hour, but every month. The bag values ​​are stored in the registers, which speeds up the work. Yakshcho Uvimknuti harekhunki PIDSUMKIV at the Tesmanni regime, then the hazelnuts of the basis of the basis of the storage of the base, the priestly taggage of the regіstriv can be “Plisti” through the long -vileal “rear number” of the document. As a result, the robot did not bring the corista.

Since there is no need, it’s easier to get rid of the results.

A cramped table is a procedure for physically deleting records that have been deleted and are no longer displayed on the screen. There could be a lot of such records, the stench without the bark will permeate the database.

The compressed table is a useful function, although it is not too tight.

Restructuring the table is an operation that is relevant during the transition to a new version of the program. During restructuring, empty tables are created with the format specified in the configuration, and the information from the old tables is transferred, record by record. New tables may have expanded fields, and new fields have been added. Restructuring is an operation that can prepare the information base for work in a new way, and it is absolutely necessary for updating.

If the previous versions have not been changed, then restructuring is not necessary, this procedure does not add anything and does not change anything.

Also, when correcting the programs that failed, the necessary and useful options are:

• Reindexing table of information base
• Checking logical consistency
• Check the integrity of the message

Why bother if you can’t start testing and correcting?

If the database is severely corrupted and the configurator cannot be accessed, another option to update is lost: use the chdbfl.exe utility. The file can be found in the Bin folder in the installation directory (Fig. 3).

Small 3. Select utility chdbfl.exe

According to the command line entry shown in Fig. 3, it is clear that the path to the file lies through the directory 1cv8.2, or 1cv8.3, in short, apparently, through the program directory. You may be able to get it from the Program Files folder or another folder. You need to know where to expand the catalog and open it. In the middle of the directory, open the Bin folder,

After launching the file, select the database that supports correction, and allow correction of errors detected (Fig. 4)

Fig.4. Vikno program chdbfl.exe

Let's bring the pouches. If the program does not start after an emergency interruption, you need to do the following:

• Create a backup copy;
• Try logging in through the Configurator and quickly access the Test and Correction option;
• If the configurator does not allow you to go, find the exe program and try to save data for other programs;
• If all your attempts do not yield results, you should turn to the fakers for help;
• In case of unexpected loss of data, install a valid backup copy;
• If the backup copy was not compiled, please update the data on the original documents and paper distributions.

There will be no further updates of these data in the future. Insurance against loss of data is a good backup: if the information base is corrupted, you can go back to the day before and quickly renew the loss of the record.

vk.com/buhcenter VKontakte group.
1-bc.ru is the company’s website, where you can learn about its services.
 Reindexing the information base table.
To quickly search for information, additional tables are added to the main table with the main data, in which the data is sorted according to the specified fields of the main table - the indexing table. By storing the indexing table, the productivity of 1C increases significantly, since there is no need to iterate through the entire main table of data for selection, you can quickly access the index file and select the necessary records.
When data is written to the main data table, the indexing table will also be filled in. For various technical reasons, indices can become erratic, which can lead to errors. To correct this class of errors, when testing and correcting the 1s 8.3 base is completed, you must check the box next to this menu item.
 Verification of the logical integrity of the information base
At the time of creation of new objects in the 1c configuration, new tables are created in the database, which contain links to other database tables. For various reasons, connections may become incorrect (for example, due to incorrect updating or failure to connect the electrical system at the time of recording). To correct this kind of mess, select this menu item.
 Checking the integrity of the information base.
Surely, you have had occasion to experience “beats sent” in 1c configurations. If you don’t, then you’re lucky!
To identify and correct these cuts, select this menu item, which will activate the options for processing such cuts (see above). We can choose how to correct amends for the appearance of messages on non-essential objects: close the objects, clear the message, do not change it; And for frequent wasting of data: create objects, delete objects, do not change.
 Change of bags
To create a quick selection of data from the 1c database, create tables with processed data over a monthly period. When we search for these data, they are not collected from the main tables (it would take a lot of hours), but the table of bags appears directly from them. Obviously, for this mechanism to work, it is necessary to replace the correct bags over the past period. Therefore, if 1c “deceives” the stars, then such deceit is corrected by this menu item.
 Condensed table of information base
For remote objects in the database - the operation is to add a hose and trival, in configurations 1c the process of dividing into 2 stages. If you delete objects from the configuration, the 1c data in the database is cleared and therefore takes part in subsequent operations, if you physically lose your home. To clean the tables from these records, perform testing and correction of the 1s 8.3 database using the menu item “Clean information base table”.
 Restructuring the information base table
When changing the details of any metadata object in the 1C database, it is necessary to supplement all tables of the changed object with new records. This involves restructuring the database table. During the restructuring process, copies of the database table are created from the flow configuration structure, after which the data is transferred to the created table. Once the details are added to the 1c metadata, an empty column will be created for it in the new table; If the details have been deleted, the column under this detail will not be created in the new table, and, apparently, it will not be transferred.
During the restructuring process, all tables in the database will be rebuilt, so this operation is a find one.

In this article we look at the system utility “Testing and correction of the information base” in 1C 8.3 and its features.

Before carrying out any operations necessary!

Testing and correction of the 1C information base

The testing and correction mode is selected in the 1C 8.3 system configurator by selecting the menu Administration - Testing and correction.

Verification and modes

This window displays a list of necessary checks and modes that will be implemented as a result of the utility. Let's take a look at the skin tick in the report:

Watch 267 video lessons from 1C free of charge:

• Reindexing table of information base— once this ensign is installed, the table will be re-indexed. Re-Indexation - re-installation of indexes for table tasks. Reindexation significantly improves the productivity of the storage system. This procedure will by no means result in greater system productivity.
• Verification of the logical integrity of the information base- The system is able to check the logical and structural integrity of the database, identifying errors in the organization of data (for example, the pages of a file).
• Verification of the integrity of the information base— a sub-item of logical verification, which checks the information in the database for the presence of “broken” messages. “Bits” sent appear in the database through incorrect processing of information by the distributor, most often due to inaccurate data collection or incorrectly configured data exchange. If any damages are detected, you can choose 3 options: Create objects the system creates placeholder elements that can then be filled with necessary information, Cleanse the area- “beats” sent will be cleaned, Don't change it- the system will no longer show you the benefits.
• Change of pouches- The 1C platform has the concept of bags. Accounts - a table of insurance results, from which you can view and analyze the entire register of accounts. As a rule, changing the bags increases the productivity of the system.
• Compressed table of information base- once this ensign is installed, it will be compressed and change in communication. This is due to the fact that when deleting data from the database, 1C does not physically delete the objects, but rather “marks” them for deletion. Tobto. Koristuvach don’t smell it, but it stinks :). The compression of the database itself leaves such records residual. The same effect can be achieved by viewing the database file (*.dt).
• Restructuring the information base table- The process by which the system rebuilds the database table, causing this procedure to be called when changes are made to the configuration metadata structure. Restructuring the entire database is a long process, be respectful.

If, for whatever reason, testing and correction does not help, or you do not have access to the configurator, use the utility.