A delivery error has occurred ssrs. I recently had the same issue with PBI Report Server.
A delivery error has occurred ssrs One of them is the report named: Software 02D - Computers with specific sof I've fixed the problem, by using my machine name and also "localhost" in both the Web Service URL and Web Portal URL. html SSRS Report Server # How to Solve delivery error has occurred in SSRS 2017 Subsciption http://www. This is extremely frustrating. By the mean unknown I mean that it worked on fresh I'd test whether you can write any file to that folder from any source. I have an SSRS report that has been deployed to a SQL 2008R2 Reporting server. I am passing in a DataSet that has the correct data with column names that match the report definition. Firstly, check that the Stored Procedure radio button is selected in the Dataset Properties. Use this article to troubleshoot problems that you encounter when working with Reporting Services report subscriptions, schedules, and delivery. Given that you have copied the query into SQL Server Management Studio and it works, it sounds like a permissions issue - that is, running it in SSMS under your Step 1 : Go To start -> SQL Server Configuration Manager. And worse, I'm unable to create new subscriptions because I keep encountering this error Bonkers! Looks like the issue was a case sensitivity one. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company The default path of rsreportserver. See proposed duplicate. . I can see a list of the migrated subscriptions in the ReportServer database with the This issue is resolved as mentioned in the article: Use the same procedure documented The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM. Giving them access to the dataset fixed the problem and the report now runs for all users. in stored procedure you can directly pass the parameter and split the values using a function inside stored procedure. There's nothing in the SSRS log output that is meaningful or useful. For the release notes for Report Viewer controls, see Release notes for the Report Viewer controls for WebForms and WinForms of SSRS. Clients e. The files should be in ` \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles` On my machine, which has dev instance of SSRS, this is location is: C:\Program Files\Microsoft SQL Server\MSRS10_50. However, sometimes the reference to the shared data source was spelled "mySharedDataSource" instead of "MySharedDataSource" I found a hint of this in the logs, which complained about the first version of the spelling which did not exist on If your SSRS setup similar to the one below. The server got upgraded to 2008 (not R2). check all the parameters value and parameters name as well as check if you are using linked server then user must have the access of that database. File delivery to a third machine. After the schedule, I got the status as Done: 3 processed of 5 total; 2 errors. Open your rsreportsserver. The connection remains valid in the connection pool of your app; as a result, when you pickup the shared connection string and try to execute it's not able to Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. I am creating reports using SSRS connecting to excel datasource (ODBC 32 bit). For me, the issue was that somehow the subscription parameters became invalid. 2,964 questions Hi have upgraded my Reporting Services server to 2016. Mail will After retest, without modification of this file, the subscription work, Windows 2012 R2, SQL 2016 SP CU2, ConfigMgr 1702 This does only handle the last status message so doesn't fully answer the question (I came across this post because I am looking for the same answer), but it does seem to work for me in terms of catching all subscription errors, including file share issues: I tried leaving the file name blank in the subscription so SSRS would create the file name based on the RDL name (idea based on comments in BOL) but this is now a required field. In this moment, we do not know whether your problem originates from the select, the from or the where. SQLSERVER\Reporting Services\LogFiles. 1115. Check for any additional information or warnings that might relate to the issue. SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. I've checked the ReportingServicesService log and noticed for the failed report this error, "Error occurred processing subscription: Failure writing file "my report": Report processing has been canceled by the user". After checking the logs and not finding anything, and putting the report on hold for other priorities, we got back to it and started from the start. After saving this, and trying to resend the report, it gives the error: Failure sending mail: The SMTP server requires a secure connection or the client was not authenticated. "Helpful? Please support The database connection is closed by the database server. Also, did you do something else before reporting the error, such as an upgrade. I migrated reports from 2008 R2 to 2016 reporting services, and when I open the reporting service Web Portal url or reload it, I get this error: The item '/68f0607b-9378-4bbb-9e70-4da3d7d66838' can Sometimes the log files can provide more detailed information on what's wrong. Mail will not be resent. The creds were cache/saved and when in chrome could not make any changes, deletions or adds. log with relevant Date Modified Share Improve this answer For timeout setting in Power BI Report Server, please refer: Server Properties Advanced Page - SQL Server Reporting Services (SSRS) | Microsoft Docs. But now I want to know the detai hi, i'm having an issue with SSRS subscriptions, i used to be able to access the portal UI for them however this week i found i cannot get to the details, each attempt to access "subscriptions" via the portal is resulting in a 20 second SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. On the report Subscriptions page, under "Status" for Last Run, it has the following error: "Failure sending mail: Report processing has been canceled by the user. Refresh your page see your Report will run. " or "The report server has encountered a configuration error. Now, however, these stored procs still run but when I run this report I get the following error: I am running ReportViewer 10 using a local report (rdl) file in an MVC web site. While its runs ok in the report builder, when deploying to the report server 2015 (64 bit), I get the following error: Generally speaking SSRS can be item config set, directory of child items (which may also be more directories), or root directory set. 57 SMTP; Client was SSRS writes to text logs which will very likely contain more details. g. Hello, By some unknown reason we are facing an issue on some (at least 3) Azure AD Joined devices to access Parameters and Subscription of some BI reports. If after following the advice there closely, you are still unable to solve your problem, post a new question, in which you've provided a good minimal reproducible example, along with a precise and detailed explanation of what you've done so far to try to diagnose the exception, what you've learned about the scenario that throws the Unfortunately I can't really show any sample data due to data security issues. It may be that internal reporting services were confused because I'm also using localhost Hello experts, I migrated some SSRS 2012 reports, including some subscriptions, into a new SSRS 2017 instance. A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. However, they can create and delete their subscription. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI When migrating an SSRS instance to SSRS 2019, I kept encountering this error when trying to set up a new subscription: An error has occurred. Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future. In regular SSRS subscriptions with windows file share delivery there is an option to use file share account Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. It is a Windows File Share subscription and the report has three parameters. Meaning in the shared data source it should be I'm trying to run the following query for ssrs reporting services for a data portal in our Prophet 21 database (erp software from Epicor) and I'm running into some errors when trying to input the report in visual basic. It ended up being that the ORACLE provider was commented out in the rsreportsserver. Environment for SQL Server Data Sources and for SSRS Reporting Services is SQL Server 2016 Standard Edition CU 12 for Service Microsoft SQL Server Reporting Services (SSRS) supports extensions by including custom extensions and custom code. When I hit my report server (sql4/reportingserver_sql4) OR in VS 2015 I can run the report by manually entering a parameter and the report returns the correct data and displays the report. Log in or register to rate You rated this post out of 5. I recently had the same issue with PBI Report Server. The summary of instructions are. DEV\Reporting Services\Logfiles` – Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. 2,972 questions Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company I have following system configuration: RAM - 64GB CPU - Intel Xeon OS - 64 Bits Windows Server 2012 R2 I'm developing report in VS Data Tool 2015. Now the reports returns >An error. SSRS catalog on another machine that hosts SQL Server 2016. " On a scheduled reporting services report. edl. On the SSRS machine (the one hosting the Reporting Services service), create a local account. 2,970 questions If your SSRS setup similar to the one below. Mail will not be resent". 96) states following: SQL Server Database Engine (2014 SP3 or later), to store the report server database Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. I open a report file (created in SSRS 2014) in report builder of SSRS 2016 in order to save it into report manager site OR preview it, I get this error: System. A report was working fine in SSRS 2005. When I go to create or modify an existing subscription, I get the error - An error has occurred. A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify. com Current SMTP Delivery How to Solve delivery error has occurred in SSRS 2017 Subsciption http://www. Went down a rabbit hole trying procmon (my own ineptness) but went back to what you said about the sid: I was running reporting services as the network service so once I decoded which sid that was, I went to Computer\HKEY_USERS\S-1-5-20\Software\Microsoft\Avalon. TargetInvocationException: Exception has been thrown by the target of an invocation. The subscriptions were deleted. I did consider the local account permissions, but the report did work when I posted it originally, and I've made no changes to any of the accounts. Start Management Studio and connect to Report Server Instance (make sure you I was setting up a subscription in our Sharepoint-integrated SQL Reporting Services site, and was attending to send the report to our shared group email address. It has 4 subreports, one of which has two subreports. 2,965 questions Databases: SSRS Subscription Error: "Failure sending mail: Report processing has been canceled by the user. The error message I saw is "Failure sending mail: An error has occurred during report processing. Event ID Type Category Source Description; 106: Error: Scheduling: Report Server: SQL Server Agent must be running when you define a scheduled operation (for example, report subscription and delivery). Environment: All machines are Windows Server. x-based assemblies. var The short of it is you cannot have the same shared dataset name across different SSRS Projects that are on the same SSRS server. Add a new DWORD value in the registry path HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters Ok, I found the answer. If that works, try writing a simple file from the same source. However, one report having error: Failure writing file Filename@timestamp : I have a report in SSRS and I scheduled it to trigger via data driven subscription. Asking for help, clarification, or responding to other answers. Hi All, I have been trying to send ssrs report to users via email and i followed all the rules like configuring email settings like below: Sender Address: User@Domain. config file as an administrator. You should copy your custom library to the ReportServer\Bin folder ex: C:\Program Files\Microsoft SQL Server\MSRS10_50. (rsDataExtensionNotFound) 4 SSRS report subscriptions I created weeks ago were working fine until this past weekend our DBA upgraded our SQL Server instance to 2017. Previously this report was running successfully. I am not able to create subscriptions for SSRS reports as it gives the following error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. e ERROR: [wnivykk5]: OData exception occurred: System. There're 2 solutions to this. SSRS SQL Server 2016 version on one machine (SSRS service is the sole process running there). In SQL Server 2014 I have a data driven subscription that is executing successfully, but no file is generated. x assembly. This will also delete the files on your system We have an application server with the following spec’s: • Windows 2008 R2 operating system. This is the scenario. config is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer Refer to the following in the rsreportserver. However, SSRS does not support Microsoft . My report needs to fetch around 700K rows and 135 the next thing I'd do is check the user's query history, to see what role/warehouse/db/schema the session had when the query ran, for some reason the "context" of the user's session seems Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Report data sources must be SQL Server relational databases that run locally in SQL Server Express. C:\Program Files\Microsoft SQL Server\MSSQL. ---> System. I have developed it using VS2015. NET UI and keeping Excel as But when I try to go to the My subscriptions page in the SSRS web portal, I get the error below; No subscriptions are visible on the page; and there is no way to add a Enabled verbose logging on the SSRS instance and walked through reproducing this error several times. ; Delete the report from solutions explorer in Visual Studio. • All prerequisites are configures successfully and correctly: Windows roles, MSDTC and connection to Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Somewhere along the way you have made a mistake - but no one can really tell you where it is from the information you have provided. It's a subscription, no person canceled this. The only log I can Applies to: SQL Server Reporting Services (2017 and later) This article describes changes in SQL Server Reporting Services (SSRS), for versions 2017 and later. All reports are generating PDF files to the given drive. The subscriptions are still In this post we will be discussing about solving A delivery error has occurred in SSRS 2017 when trying to create a Subscription from ASP. 2,958 questions Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; I have a report in SSRS with "Data-driven Subscription" , but sometimes there is errors like below Done: 10 processed of 10 total; 10 errors. My company uses SSRS to deliver reports to users, either by email subscriptions or by the user opening the Report Server page in their browser and clicking on the report they want, which then runs it (rsProcessingAborted) An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services. The problem was chrome and using report manager. codingdefined. R2\Reporting Services\ReportServer\bin SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. config file. What is done here is to combine the join expression with a string splitting function in the dataset that converts the resulting Value1,Value2,Value3 I'm creating an SSRS report using report builder that generated large amount of data based on from to dates parameters. 7. " and the email is not sent. Graphics (that's the network service sid) and granted [the A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. Features Supported by Reporting Services in SQL Server Express. The main landing page generally when connecting in code to SSRS is the point shown above unless you specify in code behind or a config some other starting point. Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. is there any workaround to allow users to edit their subscription or In your Destination ("OLE DB Command"), you are trying to pass a value to the upt_Gender column that does not fit the data type. Therefore, you cannot load a . 2\Reporting Services\LogFiles look for filename: ReportServerService*. I am running Current Branch, version 1606. If I run the report up to 3 months the report works fine, however when gener A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. I enter the creds again An SSRS email subscription did not work this morning. Please try again later. SoapException: Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. config file: I'm seeing the error: "Failure sending mail: Report processing has been canceled by the user. The server response was: 5. I have multiple report running by creating subscription. com/2019/01/how-to-solve-delivery-error-has. Protocols. If the answer is helpful, please click "Accept Answer" and upvote it. The System Requirements section for SSRS 2022 (16. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. html SSRS Report Server # Logon failure: the user has not been granted the requested logon type at this computer . Users can successfully create subscriptions to reports but if they go back to update a parameter (change a date range for example), it throws a "delivery error has occurred" I was getting this message when trying to view subscriptions for an SSRS report. Value > Fields!last_Unsuccesful_run. Previously on our other SCCM 2012 install, we had a few report subscriptions setup on a daily schedule. Running SQL Profiler and seeing what SQL is hitting the server might help. if parameter is directly passed to a sql query instead of stored procedure, then concatenate the parameter values using a join and pass to datasetenter image description here Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. Cheers !! In the properties, you can determine what account is used to connect to SQL. So within our SSRS "repository" we have several different SSRS projects. Regards, Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Went into firefox that I never used to connect to report manager and I allowed me to create a new shared datasource and point the reports to them. I can run the report fine right now. 2,928 questions Hi @Vishal Bhattacharya , Has your issue been resolved? If you have any questions, please feel free to let me know. I'm getting the following error: TITLE: Microsoft SQL Server Report Designer I'm developing an SSRS 2008 report using stored procs. Either an expression is wrong or not. I could set it up to deliver to me and I could forward it, but it Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. V One thing i found was a trigger/procedure referencing incorrect ReportServerTempDB. This may or The subscriptions run most of the time but randomly some of them fail giving the following error in the Subscriptions table "The delivery extension for this subscription could not be loaded. Looks like a bug in SSRS (SQL Server 2017maybe it's fixed in SQL Server 2019) In SQL Server 2008 in addition to the above two options you have a third option to make this setting through SQL Server Management Studio. See SQL Server Reporting Services features supported by editions => Remote and non-SQL data source support => Express: Not supported First you can check the Reporting Services log, the path is generally C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles. NET Framework 4. Provide details and share your research! But avoid . This log records errors that occur in most cases. To open the setting page, try this: start SQL Server Management Studio Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company I am setting up SSRS data driven subscription with windows file share delivery option. When deploying the report, I added access to the site for the user group DOMAIN\user-group with the "System User' role under Site Settin Aruna, similar to the previous problem, you need to narrow the problem space. 2,944 questions This just sounds like a timeout. With SQL Server Express you can only use a Data Source where the database engine is from the same instance running SSRS. Either it's the wrong kind of data, or it's a string that's too long for the column. The free Express Edition of SSRS has several limitation, and access remote data sources is one of it; it's not supported in Express, it can only access the local SQL Server database engine of the same instance. 2,976 questions New Offer! Become a Certified Fabric Data Engineer. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Configuration Windows 10 x64 Pro Visual Studio 2019 (repaired) Extension: Reporting Services Projects (Latest) Extension: Oracle Developer Tools (Latest) Oracle Client: ODAC1931_x64 Problem When using an Oracle Data Source in SSRS, the connection Do me a favor aprem, write up a stored procedure or sql query in the first tab of reporting services and run it using that user. This issue is resolved as mentioned in the article: Use the same procedure documented The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM. You could schedule a daily job to populate a table (or tables) containing this report data and point the report at this table. Hi @ZoeHui-MSFT ,. Now - I figured Microsoft has broken something which SSRS interface needs in windows 10, so I logged onto a Windows 7 machine and using IE11, was able to navigate to report manager site, update the credentials (windows and SQL Server credentials) and the reports run. Web. Then try an Excel file. You have to debug the situation, starting the verifying that the datasource does indeed point to the correct database, and that your report has permissions to access it. Maybe there is a problem with a service. 2,970 questions After that restart the sql server reporting services. For I am new to SSRS and deployed my first report with it. Subscription can’t be Thanks for the input Davos. InvalidOperationException: Sequence contains no matching SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. But even after fixing that, it didn't work and i had to migrate all my reports / datasources from one server to another - there are a few tools out there - ReportSync is one of them, but you might need to change some code if you're using forms authentication on one of That said, the reason you see people using that join expression is because sometimes your query will slow down considerably if your parameter has a lot of potential selections and you data is reasonably large. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; Hi, I am using SSRS 2019 version and noticed the issue that users in the Browser role cannot edit their own created subscription. On the SQL database, ensure that the account used for the data source has the security privileges required to access the database objects used in the query (maybe the tables referenced in the query, or the stored procedure, depending on what the source of your dataset is). I did find some additional leads from your thread though Alex, that did look to deal with failures when using synonyms but I have hit a point where this was supposed to simplify our migration cutover, and have to recognize that because of this snag, it is now looking to be at least as troublesome as updating all the reports and subscriptions. It's very strange that SSRS doesn't tell my expression is wrong somehow, and last but not least, it's very weird that the expression works in all report levels except from the Main report. Hello, I just recently stood up a new Server to host our SCCM environment. and the reason of these errors I think network proble The issue for me was a timeout setting. Im trying to get a colored gauge panel to green/red based on IIF expression for comparing two dates. data data file. SSRS logs can usually be found in a directory like this: C:\Program Files\Microsoft SQL Server\MSRSXX. In the project, all of the reports referred to a shared data source. Add a new DWORD value in the registry path HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. Step 2 : Select SQL Server Services -> Right click on SQL Server Report Services -> Click Restart. Failure sending mail: Report processing has been canceled by the user. You're likely running into a common SSRS Reporting Service Double Hop (aka Negotiate / SPNego / Kerberos/ SSO) issue. Reflection. Services. Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company Plainly, Dataset1's query isn't working. This is my expression: =IIF(Fields!last_Succesful_run. See more If a new owner wants to change anything in their subscription, they will receive an error message: "a delivery error has occured" SSRS logfile entry therefore: We had created over 30 subscriptions in our SQL Server 2017 Reporting Services environment. May I suggest you don't base a SSRS report on a stored proc that takes so long to run. 0. In the report portal in the Report Properties management page the default settings is "Use the system default setting". 1. Make sure you have a backup copy of both report definition and . However it still points to the old SQL Server Database (SQL 2014). If your SSRS setup similar to the one below. This report used a shared dataset and the new users did not have access to the dataset. PCs -> SQL Server A (Hop 1) with SSRS -> SQL Server B (Hop 2) contains DBs where your SSRS data sources are pointing to. ztal pob eua bdwdn fnvny hrsyice ziq zieagsbi ykh lez