How to get last updated date of the table
Hello Experts, I am looking for the date, when is the last update (delete, truncate and reinsert) was made on the table I came across SYS.DM_DB_INDEX_USAGE_STATS table with LAST_USER_UPDATE column, but sometime it returns NULL, Shall I believe on it gives me what I am looking for Regards, Amitdate data type to a datetime data type resulted in an out-of-range value
I've a 3rd party reporting software using SQL as the database. During ETL, I saw this error: "System.Exception: "The statement has been terminated.". Description: The conversion of a date data type to a datetime data type resulted in an out-of-range value." Is there any adjustment require at SQL?
Open reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's like https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage at https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport might be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URL https://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?
SQL Server Reporting Services - Visual Studio Compatibility
Let me preface this with some details. I wrote a report in SQL Server Reporting Services under and old version using the SSRS Design Manager some years ago. I am now running that report in SQL Server 2019 without any problems. However, I wanted to make some updates to the report when I discovered a problem. In my Tablix on the Detail Row I control the Visibility property with an expression. Now I'm using Visual Studio 2022 Community Edition with the Reporting Services Add-in. When I look at the report in Design View, and look at the Properties for the Tablix Detail Row, the Visibility property is showing "FALSE". However, when I view the XML Code the expression is there: IIF(FIRST(Fields!QUICK_SPEC_SHOW_DETL_FLG.Value, "RUNTIME_PARAMS")<>"Y",TRUE,FALSE) So I tried to copy and paste the formula into the Properties - Visibility and it accepted it and I was able to save the report. I was also able to BUILD the report without error. But when I tried to deploy the report to the server I received the error message: Severity Code Description Project File Line Suppression State Error The definition of the report '\B_v_A_Custom.rdl' is invalid. 0 Can anyone explain to me what I going on, why old reports run perfectly fine but when I try to edit them I am getting errors? And how to I get around this problem? Thanks David R.Report Server Web Service URL not working
I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also. I got the report server to say it is "Report Service Status: Started". When I try to access the Web Service URL I get an HTTP Error 500. I can access the Web Portal URL with no problems. I setup the Service Account to use the built-account "Network Service". The Database is using the Login: NT Authority\NetworkService. This is an error I found in the Log file. "library!DefaultDomain!63cc! 10/29/2022-16:29:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Invalid PBI Configuration, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; appdomainmanager!DefaultDomain!69ec! 10/29/2022-16:30:04:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_2' (id = '4') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!69ec! 10/29/2022-16:30:07:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_2' (id = '4') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!69ec! 10/29/2022-16:30:08:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_2' (id = '4') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!69ec! 10/29/2022-16:30:09:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_2' (id = '4') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!42a4! 10/29/2022-16:30:19:: i INFO: Registering AppDomain: type='ReportServer'; id='5'; Name='ReportServer_SSRS_0-1-133115490192369210' appdomainmanager!DefaultDomain!42a4! 10/29/2022-16:30:19:: i INFO: Creating a new AppDomainLifeCycleManagementEntry for AppDomain id '5' appdomainmanager!DefaultDomain!42a4! 10/29/2022-16:30:19:: i INFO: Appdomain STARTED: id='5'; name='ReportServer_SSRS_0-1-133115490192369210' appdomainmanager!DefaultDomain!42a4! 10/29/2022-16:30:19:: e ERROR: AppDomain ReportServer_SSRS_0 failed to start. Error: Access to the path 'D:\Programs\Microsoft SQL Server Reporting Services\SSRS\ReportServer\RSTempFiles\~AspAccessCheck_78e10b4617060.tmp' is denied. library!DefaultDomain!42a4! 10/29/2022-16:30:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_SSRS_0. ---> System.UnauthorizedAccessException: Access to the path 'D:\Programs\Microsoft SQL Server Reporting Services\SSRS\ReportServer\RSTempFiles\~AspAccessCheck_78e10b4617060.tmp' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)" Any ideas what is wrong.
SSRS Randomly Splitting Last Row onto New Page
I have a basic report with a Tablix, 1 Group (2 Group Header, Details (2), 3 Group Footers). If I run this report for random Transactions (in my case Purchase Orders), some will print properly ie rows go to the bottom then continue on the next page, followed by the group footers (depending on line notes and text wrapping some print 30 items on page 1, some 24 etc. I run the exact same report for another PO and it'll go 17 items, then #18 on second page followed by group footers, another PO will go 23 items then item #24 on page 2 followed by group footers. I've checked the data and there is nothing different between rows of data that split and those that do not. It seems completely random. I am at a complete loss as running these types of reports in Crystal from the same data has zero issues. I have nothing in the properties for page breaks, max records etc.
