I.T. Co. established common IT-infrastructure for the Razgulay Group


I.T. Co. established common IT-infrastructure for the Razgulay Group
I.T. Co. has completed the project in Razgulay Group on establishment of IT-infrastructure based on Microsoft technologies. For the purpose of efficient interaction between all agricultural holding’ companies the common information space has been arranged. Project implementation resulted in increased manageability and security of agricultural holding IT-infrastructure, as well as lower total cost of ownership.

Razgulay Group specializes in the sphere of production, processing and sale of agricultural products and operates in 18 constituents of the Russian Federation. It is quite difficult to develop under conditions of strong competitiveness and to automatize management processes with such territorial structure of agricultural holding assets. That is why the Group management decided on establishment of modern standardized infrastructure, capable to meet at most the current and future demands.

The choice of software platform was predetermined, as the existing infrastructure of the Razgulay Group corporate centre was already based on Microsoft technologies. In order to select the Executor, agroholding held a content, which was attended by several major Microsoft partners. Razgulay Group entrusted I.T. Co. the project implementation following the aggregate of estimated parameters.

I.T. Co. engineers together with Razgulay Group IT-professionals created the core of common IT-infrastructure based on Microsoft Windows Server 2008 R2. Common directory service was based on hierarchical approach and provides centralized control over infrastructure of Razgulay Group disbursed companies. The second project stage was the introduction of e-mail system Microsoft Exchange Server 2010. It provided agroholding employees with reliable service of messages exchange and team-work, including task formulation, meetings assignment, use of calendars and common list of addresses. IT-infrastructure provided the possibility of its modification at changes in agricultural holding business. Razgulay will be able to change a composition of structural divisions and add new services, in particular, develop possibilities of employees’ team-work. Today Razgulay Group is the largest Russian agricultural holding, managed to establish a modern infrastructure for introduction of ERP-system.

Following the project results, Alexander Krasnov, deputy general director of Razulay Group information technologies, marked: “Created infrastructure became the foundation for introduction of ERP-system and other modern IT-solutions. Common information space will significantly simplify communication between employees. Introduced rights management system for access to the data (AD RMS) will provide a secure exchange of confidential information by e-mail, its storage on a networked drives, without fear of unauthorized access, and unification of workplaces will optimize the operation of IT-management Group by 20 percent. All of this will allow increasing manageability, security and fault-tolerance of IT-infrastructure in whole”.

About Razgulay Group
Razgulay Group is the largest national agricultural holding, consolidating three industry-specific lines: sugar, agricultural and grain, as well as division for interaction with retail chains. The holding includes 12 elevators, 7 flour-milling plants, 3 cereals plants, 10 sugar plants and milk canning plant. More than 460 thousand ha of land, including 338 thousand ha under tillage in 2011, are under the holding control. Agroholding operates in 18 constituents of the Russian Federation, including the North-West and Central Chernozem regions of Russia, the Upper and Middle Volga region, the Northern Caucasus, Southern Urals and Western Siberia. More information is available on web-site   

Module: advertising
Class: CAdvBanner
File: /var/www/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 943
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'en') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'en') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '7') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '7') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3698/index.php' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/en/media-center/news/3698/index.php' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/en/media-center/news/3698/index.php' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/en/media-center/news/3698/index.php' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Incorrect key file for table '/tmp/#sql_3a9_0.MYI'; try to repair it]

DB query error.
Please try later.