NOTE: This page has been translated automatically from Russian to English. Original page.



Common mistakes 1C and general methods for their solution

This article is intended primarily for those who are not a lot of work with 1C and did not have time to fill the cones at a meeting with frequent errors. Usually, you can determine for itself several actions to help if the problem is just a few minutes, or require additional analysis will be solved can be determined. For the first time confronted with simple mistakes I spent a lot of time trying to deal with them. Of course, the Internet helps a lot in such matters, but do not always have the opportunity to use it. So I hope that this article will help anyone save time.

The information bases on 1C platform may have many different error:

violation of the logical / physical database integrity, user error, "curve" developer code and much more.

The reasons can be many: turned off the light, and there was not an uninterruptible power supply, or the Friday evening was a success, and the user already can not remember on Monday that he had done this.

Firstly, it is necessary to ask a few clarifying questions to the user:

1) Releases platform / configuration.

2) The full text of the error message. Users have the annoying property is not entirely read such messages, and perhaps it contains a recommendation to solve the problem.

3) How long have there and under what circumstances there. Not repeatable errors which we have not previously encountered, we can fix navryadli.

4) Whether there is if you run from another computer 1c / from another user? This will give us food for thought - can you help clearing the cache, setting rights, or clear the user settings.

Now a little about themselves and error how to solve them.

Total:
Part of the errors occur when using unlicensed software (windows, 1C etc.).

A common example - a broken platform. One of the patches, hacks particular version of the platform, so after installing a new version of the platform and try to go to the database, you can see the box "Do not free the license was found."

If you encountered an error for the first time - perhaps someone has already met her -

look in the google, maybe someone has experienced this and has solved the problem, and you do not spend the extra couple of hours of his time.

Release configurations must be current (primarily for configurations of which shall regulated reporting), in consultation with an ulterior motive line almost always offer a first update, and then look no further.

The current release of the platform - each configuration is written, a platform release is recommended for use with this configuration.

Technology allows you to log all log events of the 1C: Enterprise (or a part of using a filter).
About him can be read here and here .

!!!IMPORTANT

Before any action with the base - to make a backup copy of!

If the database does not open in the configurator - copy the folder with the database and perform all operations on the copy!

1) The base does not offer any user-mode or in the configurator.

  • The fastest thing you can do - clean up temporary files (remove the base from the database list, and re-connect)

    This action does not delete the temporary files (cache), and create a new folder for the temporary database files, delete files, you can:
    In Windows 7 in C: \ Users \ username \ AppData \ Roaming \ 1C \ 1Cv8x
    In Windows XP C: \ Documents and Settings \ username \ Application Data \ 1C \ 1Cv8h
  • You can also try to log in from another user base.
  • If the file database, you should run the utility for testing physical database chdbfl integrity. It is located in the folder:
    C: \ Program Files (x86) \ 1cv8 \ 8.xxxxx \ bin \ chdbfl.exe
  • If the database sql-tion the test sql means.
  • If neither one nor the other does not work, you can update the platform (see. For a working platform release)

  • If you do not get anything from the above, you can use the applets Tool_1CD. Link.

2) If you run the database goes to the dump.

  • Disable hardware-accelerated video card:

In Windows XP:

  1. Open the properties of the screen. This can be done through the Control Panel or simply by right clicking on any place of your desktop free of windows and icons, and choosing the "Properties" context menu item.
  2. In the Display Settings window that opens, click on the tab "Settings" and click "Advanced".
  3. In the Properties window, click the video tab "Diagnostics".
  4. Move the cursor "Acceleration" in the leftmost position ( "no") and click "Apply" or "OK". Hardware acceleration disabled. Changes will take effect after reboot.

In Windows 7:

  1. Open the Control Panel (Start - Control Panel).
  2. Locate and open the item "Display".
  3. The left side of the window that opens, click on the link "Adjusting the Screen Settings".
  4. click on "Advanced Settings" in the window that opens.
  5. Click the "Diagnostics" and click "Edit settings."
  6. In the window that opens, move the slider to the left ( "no") and click "OK". If UAC is enabled, it is necessary to confirm that the change of authorized users. Hardware acceleration disabled. Changes will take effect after reboot.

In Windows 7 in some cases the button "Modify" will be inactive. In this case, disable hardware acceleration is not possible, as the video card and its driver does not support hardware acceleration manipulation.

Details: http://www.kakprosto.ru/kak-2210-kak-otklyuchit-apparatnoe-uskorenie#ixzz331zNZKaX

  • If Kaspersky Anti-Virus, you can try to disable self-defense and to rename kloehk.dll mzvkbd3.dll and files in the folder Kaspersky. (The error occurs on older versions of 2011, but still sometimes occur)
  • Check that the platform / release configuration.
  • Try to go to the base of the other platforms.

3) The base opens in the configurator, but does not want to go into user mode.

  • Cleaning temporary files
  • Trying to go for another user
  • chdbfl / sql means testing
  • Testing and correction of IB:
    The configurator Administration testing and correction - tick as appropriate.
  • Unloading in * .dt and loading in a "clean" database
  • Try to create others. Users with full rights and go away.
  • Try to move to another PC, and open there, maybe something with a PC.

4) If some action throws on the code in the configurator.

  • To check is to clear the cache.
  • If that fails then most likely an error in the code - especially important for non-standard configurations and samopisnyh, but is sometimes found in the standard.

If the configuration is atypical, here or update it was incorrect or modifies the configuration of the developer has not provided all the possibilities of user error - foolproof (if possible!).

If typical, perhaps a bug in the release.

In any case it is necessary to run the debugger and see what is wrong.

5) under one user gives something to do, there is a different.

  • Setting user rights.
  • User Settings.
  • Clear the cache.

6) With a PC goes down, the other not.

  • Check whether the database sees the conductor - is to a database is not provided shared folder.
  • Clear the cache.
  • Enter by another user.

7) I did not do anything / I did but I still broke

  • If you can tell that it is "not done", and when, you can use
  • magazine with the selection and registration is possible to know what the problem is.
  • The log can be found in the configurator:
  • Administration - log.

    Alternatively, a user-mode - the location depends on the configuration.

8) Not enough memory.

I had a case, the client has come, said at the closing of the month takes off error "Out of memory". I took over this problem. I thought that it is easy, first added RAM - a mistake. It was 2 GB, 4 was, and still 1c-ke little. paging file size changes - error, reinstall the system (set of Windows 7) gave only a temporary result, somewhere in the week. I tried everything. After some time, the solution was found.

Decision

On the client computer to run a command prompt as an administrator, to register it as follows:

BCDEdit / set increaseuserva xxxx - xxxx instead write the amount of virtual address space in megabytes, that is, how much memory you need for your applications. Default 2 gig. In general, the 32-bit operating systems is allocated 4 GB: 2 - 2 at the application and the needs of the operating system itself. I chose 3000 (ie CDEdit / set increaseuserva 3000). However, the system may be a bit flaky. Especially if you have 2 gigabytes of RAM, as I have. This is for the Windows Vista family, 7, Windows 2008,.

For Windows XP \ Windows 2003 write
/ 3GB / userva = xxxx (xxxx in MB in the range 2048 - 3072) in the boot.ini file, the recommended maximum values userva 2900-3030.

Link to this error http://infostart.ru/public/147631/

9) forms elements nalezayut at each other and have the wrong location.

  • Clear the cache.

10) Database Error Internal error dbeng8 components

  • The error is related to the difference between different versions of the platform code when users attempt to use the file option. For client-server options when you start going control and work with different versions of the platform, in principle, impossible.

Solution: upgrade to the current release in all workplaces.

If does not work, then do the following:

  • Testing and correction

    chdbfl

  • Unloading in * .dt and loading in a "clean" database

11) An error in the platform 8.3.4.428

  • In version 8.3.4.428 platform "1C: Enterprise" discovered a critical bug with data restructuring. This error is localized and will be fixed in the next version of the platform.

12) Conflict locks when the transaction:


Microsoft OLE DB Provider for SQL Server: Could not continue scan with NOLOCK due to data movement.
HRESULT = 80040E14, SQLSrvr: SQLSTATE = 42000, state = 3, Severity = C, native = 601, line = 1

"How to check (restore) database to MS SQL Server server resources
Check the logical integrity of the need to perform regular means of 1C: Enterprise (Testing and correction IB). If this check fails, the physical integrity check MS SQL database means. To check the integrity of the MS SQL tools necessary to execute the following command:
Code:
DBCC CHECKDB ( "", REPAIR_REBUILD)
Before executing this command, you need to convert the database in "single user" mode:
Code:
sp_dboption "", "single user", true
In operation, the DBCC CHECKDB errors can be detected and the part can be immediately corrected. If the error persists, it is likely they can not be restored without loss of some data. In this case, you need to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS option (before starting is desirable to make a copy of the database files).
Code:
DBCC CHECKDB ( "", REPAIR_ALLOW_DATA_LOSS)
After the DBCC CHECKDB must not forget to return to normal operation (exit "single user"):
Code:
sp_dboption "", "single user" , false "( Taken from the website http://1c-esse.buter.ru )

Of course the list is not complete, so I will be happy if its complement in the comments.

1C:Enterprise Developer's Community