Performing update handlers does not end. Data processing procedures

17.04.2018

New Release 3.1.60.46

Software users' ailant: housing and utilities management "is available for downloading a new release 3.1.60.46 dated 04/17/2018. We remind you that users of the editorial staff 2.0 and 3.0 of the software product before installing this release should make sure that the set of transition to the edit is purchased 3.1. Otherwise, the activation of the software product will not be possible.

Update files are designed to update with releases. 3.1.59.45

NOTE:Before upgrading On the release of 3.1.60.46 of the program "Ailant: Housing Management Manager" you need to check whether the procedures for updating the previous release are made, and, if necessary, execute them.

To do this, under the administrator, go to the menu / Administration / Maintenance / Results of the program update / update results and additional data processing. If the link indicates that not all procedures are executed, that is, there is no message "All update procedures are successful", then it is necessary:

1. Create at least one employee in the "Employees" directory.

2. Start updating additional data processing procedures. To do this, under the administrator, go to the menu / Administration / Maintenance / Results of the program update / update results and additional data processing. Click on the link indicating the number of completed update procedures.

The "Advanced Data Procedures" window opens. At the bottom of the window, click the "Run" button.

After close the "Advanced data processing procedures" window, close the program update results window. Re-click on the link "Update Results and Additional Data Processing" link. There should be a link "All update procedures successfully". After that, you can update to the next release 3.1.60.46.

Basic version

Creating data as a processing process, provides for their education as a result of a certain algorithm and further use for transformations at a higher level. The modification of the data is associated with the display of changes in the real object area carried out by incorporating new data and removing unnecessary.

Control, security and integrity are aimed at adequately displaying the real state of the subject area in the information model and provide protection for information from unauthorized access (safety) and from failures and damage to technical and software. The search for information stored in the computer's memory is carried out as an independent action when performing answers to various requests and as an auxiliary operation when processing information. Solution support is the most important action performed when processing information. A wide alternative to the decisions made leads to the need to use a variety of mathematical models.

Creating documents, reports, reports is to convert information in forms suitable for reading both both a person and a computer. Operations such as processing, reading, scanning and sorting documents are connected with this action.

When converting information, its transfer is carried out from one form of representation or existence to another, which is determined by the needs arising in the process of implementing information technology. The implementation of all actions performed in the process of information processing is carried out using a variety of software. The most common area of \u200b\u200bapplication of technological operation processing information is decision-making. Decision making in conditions of certainty. In this problem, the model of the object and control system is considered specified, and the effect of the external environment is irrelevant. Therefore, between the selected strategy for the use of resources and the end result, there is a unambiguous connection, whence it follows that in conditions of certainty, it suffices to use a decisive rule to assess the utility of solution options, taking as optimal that leads to the greatest effect. If there are several such strategies, then all of them are equivalent. To search for solutions under conditions of certainty, methods of mathematical programming are used.

Making decisions under risk. In contrast to the previous case, for decision-making under risk conditions, it is necessary to take into account the influence of the external environment, which is not amenable to exact forecast, and only the probabilistic distribution of its states is known. Under these conditions, the use of the same strategy can lead to different outcomes, the probabilities of which are considered specified or can be determined. Evaluation and selection of strategies are carried out using a decisive rule that takes into account the likelihood of achieving the final result. Decision making in conditions of uncertainty. As in the previous task between the choice of strategy and the end result, there is no unambiguous relationship. In addition, the probabilities of the appearance of end results are also unknown, which can either be determined or do not have in the context of meaningful meaning. Each pair "Strategy - the end result" corresponds to some external evaluation in the form of a win. The most common is the use of the criterion for obtaining the maximum guaranteed winnings.

Decision making under multicitality conditions. In any of the tasks listed above, multi-characterity occurs in the case of several independent, not converted to another target. The presence of a large number of solutions complicates the assessment and selection of the optimal strategy. One of the possible ways to solve is the use of modeling methods. The solution of tasks with the help of artificial intelligence is to reduce the extinguishing options when searching for a solution, while the programs implement the same principles that use people in the process of thinking.

The expert system enjoys the knowledge with which it possesses in its narrow area to limit the search on the way to solve the problem by gradually narrowing the circle of options.

To solve problems in expert systems use:

the method of logical output based on the technique of evidence, called the resolution and using the denial of denial (the proof of "from the contrary");

the structural induction method based on building solutions to determine objects from a large number of data at the entrance;

the method of heuristic rules based on the use of expert experience, and not on the abstract rules of formal logic;

machinery method based on the presentation of information on compared objects in a convenient form, for example, in the form of data structures called frames.

Sources of "Intellect", manifested in solving a problem, may be useless or useful or economical depending on the specific properties of the area in which the task is set. Based on this, a choice of a method for constructing an expert system or using a finished software product can be carried out. The process of developing a solution based on primary data can be divided into two stages: the production of permissible solutions by mathematical formalization using a variety of models and the choice of optimal solution based on subjective factors.

The information needs of decision makers are in many cases aimed at integral technical and economic indicators that can be obtained as a result of processing primary data reflecting the current activities of the enterprise. Analyzing the functional relationships between final and primary data, you can construct the so-called information scheme, which reflects the processes of information aggregation. Primary data is usually extremely diverse, the intensity of their receipt is high, and the total volume on the interval of interest is great. On the other hand, the composition of integral indicators is relatively small, and the required period of their updating can be significantly shorter than the period of change in primary data - arguments.

To support decision-making, the presence of the following components is mandatory:

* generalizing analysis;
* forecasting;
* Situational modeling.

Currently, it is customary to allocate two types of decision-making information systems. DSS Decision Support Support Systems (Decision Support System) Selection and analysis of data on various characteristics and include funds:

* access to databases;
* extracting data from heterogeneous sources;
* modeling rules and business strategies;
* Business charts to represent the results of the analysis;
* Analysis "If that";
* Artificial intelligence at the level of expert systems.

OLAP Operational Analytical Processing Systems (Online Analysis Processing) Use the following tools for decision-making:

* Powerful multiprocessor computing equipment in the form of special OLAP servers;
* Special methods of multidimensional analysis;
* Special data warehouses Data Warehouse.

Implementation of the decision-making process is to build information applications. We select typical functional components in the information application sufficient to form any database-based application.

PS (Presentation Services) - Presentation tools. Provided by devices hosting input from user and displaying what reports to it component of the PL view logic component, plus the corresponding software support. It may be a text terminal or an X-terminal, as well as a personal computer or a workstation in a software emulation mode of a terminal or a X-terminal.

PL (Presentation Logic) - Presentation logic. Manages interaction between user and computer. Processes user actions for choosing an alternative to the menu, by pressing the button or select the item from the list.

BL (Business O Application Logic) - Application Logic. A set of rules for making decisions, calculations and operations to execute the application.

DL (Data Logic) - data management logic. SELECT, UPDATE and INSERT SQL Operators, which need to be performed to implement the application management logic logic.

DS (Data Services) - operations with a database. DBMS actions caused to perform data management logic, such as data manipulation, data definition, fixation or transaction rollback, etc. DBMS usually compiles SQL applications.

FS (File Services) - File operations. Disc operations read and write data for DBMS and other components. Usually are OS functions.

Among the development of information applications, the following main groups can be distinguished:

* Traditional programming systems;
* Tools for creating file-server applications;
* Means for developing applications "Client-server";
* means of automation of office work and document management;
* Internet development tools / intrinsing applications;
* Application Design Automation Means. (4.Anthopolsky A.B. - Russian information resources: scientific and methodological guide.)

transport Coding Road Iron

The kraft system is built on the client-server technology and uses the Firebird Relational DBMS (or Oracle). This means that data processing is basically carried out on the database server, which significantly diminishes the process.

Working with data in the Kraft system is based on the patented Sybase DataWindow technology, which provides powerful tools for processing, filtering, sorting information, as well as on the built-in K-Script programming language. Consider the main types of data processing in the system and how they are executed.

Reading data

Usually reading data is performed when opening any window with data (for example, a directory or document log). Depending on how a specific object is designed, the data is presented in a linear or hierarchical form. Wherever the storage of large amounts of data is assumed, the use of a hierarchical scheme is recommended for ease of navigation and data search. In the case of documents, special measures are also applied for optimal data organization, including pre-installed filters for documents logs. Using Sybase DataWindow technology allows you to achieve an unprecedented speed when reading data that is limited only by network bandwidth. See also Data organization for greater information.

Report execution

The report is a type of reading data presented in a special form. In the Kraft system, any report is a configuration object with a specified SQL query and data presentation format. Unlike some other information systems, there is no intermediate processing of the report data after issuing them the database server! This means that the speed of execution of any reports in the craft is limited only by the performance of the server equipment and practically does not depend on the power of the workstation (that is, the advantages of SQL and client-server technology are fully implemented). In the Kraft system, the time to perform even the most complex reports does not exceed 30 seconds (usually not more than 5-10 seconds).

Entering and changing data

Entering and changing data occurs mainly through the input forms assigned to the relevant business objects. Using Sybase DataWindow technology provides high data change operations. When entering and changing data, the Firebird transaction mechanism (Oracle) is fully supported, which guarantees the reliability of data recording in the database. When modifying the system documents (as complex objects) in the Kraft system, the lock mode can additionally be used at the level of user sessions, which makes it possible to eliminate the possibility of simultaneously editing the document by different users.

Processing business logic objects

When entering and changing these complex objects, such as documents, associated business logic procedures can be performed. The Kraft system for the configuration of application modules is most often used 3-link implementation of business logic processing, as shown in the figure below.

Using the intermediate level of business logic allows you to select this layer into a separate process on the application server (if any), which significantly speeds up the execution of procedures, since most of the algorithm that does not depend on the interface part can be transferred there. Also, the most "heavy" part of the data processing algorithm itself is often placed in stored procedures on the database server. With this processing scheme, business procedures achieves the optimal distribution of the load between the client and the server and the maximum speed.

Perform complex data processing procedures

These include for example, the procedures for mass transfer of documents or audit of data. All such procedures (as well as the procedures of any other business logic modules) are implemented on the built-in K-Script configuration language. Here, the developer provides ample opportunities to choose an implementation. The presence of embedded SQL support in the K-Script language (including cursors) allows you to fully write data processing of any complexity in the configuration procedure. At the same time, in addition to SQL operators (INSERT, UPDATE, DELETE) and SQL cursors, it is also possible to use "dynamic" SQL operators ("on the fly" in the program code), as well as a special built-in data buffer object - Data Store. However, the optimal solution is often the separation of the actual business logic and algorithmically loaded parts to the client and server part, where the server part is implemented as stored procedures on the database server called from the configuration procedure in the built-in system.

Typical configurations of Kraft modules offered by BINO SOFT are optimized to speed data processing and maximize the advantages of the Kraft system technologies.

Today we want to tell you about using additional reports and treatments, and especially configuration extensions in the service model. Technologies are not in place, the maintenance of 1c bases in the cloud is becoming more and more attractive service. What you need to know that the functionality needs for your company has been implemented in a rented base, and how this process looks like a service provider - it will be possible to learn about it under the cut.

What is external reports and processing

Treatments 1C are different, but in any case they expand the configuration functionality and allow you to get quick access to the information stored in the database, without changing the configuration and remove from support. They can be built directly into the configuration, added as a configuration extension or being external files.

The processing functionality is divided into those that can change data and those that simply analyze the information and output the result in a user-friendly form (reports). In order not to change the standard layouts of printing documents, external printed form are being developed. Also, external processing can be performed according to a specified schedule on the 1C application server - these are regulatory tasks.

The button has developed several dozens of treatments, allowing to use our accountants "practical magic". For example, for analyzing the correctness of accounting in the button, an external report "Auto Audit Baz" is used. In convenient for perception, the tables displays an analysis of 120 points of balances and revolutions on accounts, the compliance of data from tax declarations and accounting information, the analysis of fixed assets and so on.

An example of the external printed form of a "loan agreement" in the form developed by our lawyers. There are cases when an entrepreneur takes careless loan from his company as an individual, or vice versa, lists own funds from the company, then there is an opportunity to immediately print the contract.

Opened form to fill the necessary details:

And the printed form of the contract is displayed:

Scheduled processing (regulatory tasks) We use, for example, to correct the extract. The button for integration with the main banks and special robots are loaded directly to 1C. Thanks to machine learning technology, the percentage of errors when conducting an extract managed to reduce up to 3%. But as always, there are exceptions, for example, customers who use the agency scheme for the sale of goods in this case, the rules for holding a bank statement individual. In order not to reprogram the robot for a particular case, until the configuration extensions appear, the regulatory task was used to correct an extract for a robot once every 10 minutes.

What is the configuration expansion

Extension is a mini configuration that inherits objects from the main database configuration and contains code with additions or fixes of objects and modules. In this case, the main configuration remains on support, it is not necessary to include the ability to edit, which greatly facilitates the update process.

The mechanism involves three types of use, which, in fact, are indicated in the "Purpose" field, when creating expansion:

The central component of technology is Service ManagerHe stores all information about subscribers, users, applications, information bases and connections between them, with its help and management of external processing and configuration extensions.

All files with processing are loaded into the Special Catalog of the Service Manager. But before downloading the file to the catalog, in other words "publish in service", it must be specially prepared.

Preparation of external reports and handling for publication in the service model

An additional report or processing is created in the "1C: Enterprise 8 configurator" as standard external reports and processing and are stored in a file with extension - .epf (for additional processing) or.erf (for additional reports).

The object module must have procedures and functions to determine the registration parameters.

Please note that an important parameter is the "version". If you have made changes to the processing, which has already been previously downloaded to the service manager directory, be sure to change the version number, otherwise the service manager refuses to download this file. When developing a report or processing, it should be borne in mind that users work in a service model through a Web client (good article in 1C blog). If the processing contains forms, they must work in a Web client under all Web browsers that are supported by the 1C: Enterprise 8 technological platform.

According to 1cfresh.com service standards, an additional report or processing must be fully operational when executed in safe mode, that is, to work without accessing external to the configuration objects.

An additional report or processing should be prepared for download to the service kit. The package is the archive (zip file) containing:

additional report or processing file;
the XML file of the manifesto, in which the additional meta information is located, the required service manager for publishing an additional report or processing in the service.

Preparation is performed in a locally deployed information database of the configuration for which an additional report or processing is intended. We use a special assistant to create a set of delivery, external processing of preparations for the fulfillment-projobotocomputer. More details you can read in the documentation on the technology of publishing 1C Fresh solutions.

Installing additional reports and processing in the service model

A distinctive feature of 1C Fresh technology is that an external report or processing cannot be loaded directly to the data area. Adding is only a service administrator through the service manager. After the zip archive with the processing file is prepared, it is necessary to download it to the Catalog of the Service Manager and install for a specific subscriber of the service.

Service Subscriber is a group of users united by any principle. Accordingly, informational bases available for a specific group of users are called subscriber applications.

Applications may have different configurations 1C (enterprise accounting, salary and personnel management, management of our company, etc.), for which it is possible to use in the service model. An additional report or processing can be installed only in the subscriber application, which is specified when downloading the file.

This is how the form of the properties of an additional report with the versions looks like. By hyperlink "Install / Deleting", we fall into the list of applications and choose the necessary bases.

After the processing is loaded and selected the application, the service manager is drawn at the application address and gives the command to install it in the information base.

Run the processing on schedule

When working with a large number of accounting bases, some processing must be performed periodically. For example, once a month or once a few minutes. It is also important to automate manual and typical operations of users. For this, actively use regulatory tasks.

Processing that will be executed on schedule do not have forms. All logic is prescribed in the object module and is as follows.

When preparing a supplies set, we ask a schedule. Now our processing will be performed every hour.

Conclusion

There are many different opinions about the use of extensions and external reports / treatments. Relying on our experience, we are two hands "for" expansion. This is a modern and more adaptive technology, it has much more opportunities, and their publication is more easier. Only the necessary part of the code is placed in the extension, there is also no need to further prescribe procedures and functions to determine the registration parameters, monitor the versions and create a package.

You can use multiple extensions for one data area.
For the specifics of 1C Fresh work in data separation mode (one configuration, many independent areas), the extension method is a great output.

2019-03-13T12: 14: 01 + 00: 00

What kind of handlers are we talking about?

After each database update, it will start updates in order to make the manipulation database data required in connection with the changed configuration.

Such handlers are 2 types: maintenance and delay.

Their essence is one, but deferred handlers, unlike basic, can be performed after all updates, in the background, in the course of the user's work.

The default update and other handlers in their update cycle immediately.

And it is right, as often several updates apply. And if you do not perform update handlers right there - then it can be done very problematic (errors will occur).

What if the update is talking about unfulfilled postponed update handlers?

In this menu, expand the "Processing" section:

And find and open the sub-clause "program update results" subparagraph:

In this processing, you can see information about the handlers performed and possible problems with them:

And if not all handlers were performed - this will be reflected in this window. Then you can open them on the link and run on the re-execution (usually through the context menu by right-click).

Execution of deferred update IB

In some cases, it may be necessary to forced launch of the regulations "Deferred IB Update".

To do this, go to the menu in the user mode again ( It can be hidden from the menu, about how to show it.):

In the dialog that opens, expand the "Processing" section. Find and open the following item there:

In the Regulatory Tasks window, find "Delayed UP Update", highlight it and click the "Run Now" button:

A separate case is when you do not manage to perform problem handlers even in manual mode. Usually this means that:

or update developers made an error in the problem processor code
either there are problems in the database at the data level (filling on directories, registers and documents) that require a specialist intervention

Yours faithfully, Vladimir Milkin (teacher and developer