Table of contents
- 1. Measures not ordered
- 1.1. Review details problem
- 1.1.1. Solution(s)
- 1.1. Review details problem
- 2. Operations Reports / By Transaction (table) doesn't display the measures
- 2.1. Review details problem
- 2.1.1. Solution(s)
- 2.1. Review details problem
- 3. Evolution min / avg / max missing
- 3.1. Review details problem
- 3.1.1. Solution(s)
- 3.1. Review details problem
- 4. Error in "Operating Reports" after install Patch 2.2.1 CU5 Build001
- 4.1. Review details problem
- 4.1.1. Solution(s)
- 4.1. Review details problem
- 5. rsProcessingAborted
- 5.1. Review details problem
- 5.1.1.
- 5.1.2. Solution(s)
- 5.1. Review details problem
- 6. No measure for a scenario
- 6.1. Review details problem
- 6.1.1. Solution(s)
- 6.1. Review details problem
- 7. Invalid length parameter passed to the SUBSTRING function
- 7.1. Review details problem
- 7.1.1. Solution(s)
- 7.1. Review details problem
- 8. x-axis unreadable
- 8.1. Review details problem
- 8.1.1. Solution(s)
- 8.1. Review details problem
- 9. Server error in '/'
- 9.1. Review details problem
- 9.1.1. Solution(s)
- 9.1. Review details problem
- 10. Could not find a part of the path 'C:\Windows\system32\ITO
- 10.1. Review details problem
- 10.1.1. Solution(s)
- 10.1. Review details problem
- 11. Reporting is not working after a fresh installation 221 build 3
- 11.1. Review details problem
- 11.1.1. Solution(s)
- 11.1. Review details problem
- 12. Newtest NRS browser settings IE11
- 12.1. Review details problem
- 12.1.1. Solution(s)
- 12.1. Review details problem
- 13. See also
Measures not ordered
Review details problem
Context: migration 211 -> 221
Solution(s)
Measures were not ordered after migration from 211 to 221 because the MSR_PATH field of each measure were NULL and our ps_Web_MSR_Select stored procedure sort measures from this field.
run nrs_datatransfer
Operations Reports / By Transaction (table) doesn't display the measures
Review details problem
library!ReportServer_0-3!2dac!03/28/2013-15:41:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Le chemin d'accès de l'élément '/Newtest/ITO/DTL-SUM-EXP-003,' n'est pas valide. Le chemin complet ne doit pas dépasser 260 caractères. D'autres restrictions s'appliquent. Si le serveur de rapports est en mode natif, le chemin doit commencer par une barre oblique.;
Solution(s)
You can not select a large number of measures in the "By Transaction Reports Operations / (table)" report because Microsoft limits the queries to 260 characters. This is not a Newtest limitation.
Evolution min / avg / max missing
Review details problem
Context: 2110R0
The report ITO-TIM-EVL-001 don't display the max value
Solution(s)
We don't reproduce this problem in 211R1 version.
We invite you to upgrade with the latest patch avalaible.
Error in "Operating Reports" after install Patch 2.2.1 CU5 Build001
Review details problem
Context: NRS_221R5_Build001
The error is:
Query execution failed for dataset 'dsData'. (rsErrorExecutingCommand)Could not find server 'DTW_ORACLE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. But we have "DTW_SQLSERVER" as linked server because the Datawarehouse is SQL Server 2008.
processing!ReportServer_0-1!7b0!03/26/2013-11:41:31:: e ERROR: An exception has occurred in data set 'dsData'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dsData'. ---> System.Data.SqlClient.SqlException: Impossible de trouver le serveur 'DTW_ORACLE' dans sysservers. Vérifiez que le nom du serveur correct a été spécifié. Si nécessaire, exécutez la procédure stockée sp_addlinkedserver pour ajouter ce serveur à sysservers. processing!ReportServer_0-1!7b0!03/26/2013-11:41:31:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ... processing!ReportServer_0-1!7b0!03/26/2013-11:41:31:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dsData'. ---> System.Data.SqlClient.SqlException: Impossible de trouver le serveur 'DTW_ORACLE' dans sysservers. Vérifiez que le nom du serveur correct a été spécifié. Si nécessaire, exécutez la procédure stockée sp_addlinkedserver pour ajouter ce serveur à sysservers.
--- End of inner exception stack trace ---;
C:\Newtest_log\Newtest Reporting 2.2.1 R5\Setup_1903131138.log
Extract: 02_NewtestReporting_WebLabel_v221.sql... 100%
Extract: 03_NewtestReporting_Procedures_v221.sql... 100%
Extract: 04_NewtestReporting_Procedures_Report_ORA_v221.sql... 100%
Extract: 04_NewtestReporting_Procedures_Report_SQL_v221.sql... 100%
Output folder: C:\NewtestReporting\SQL\Update (v221r5)
Output folder: C:\NewtestReporting\Reports
C:\Newtest_log\Newtest Reporting 2.2.1 R5\ps_QueryDS.txt
DTW_SQLSERVER
alpha\newtest
C:\NewtestReporting\SQL\Update
(v221r5)\04_NewtestReporting_Procedures_Report_ORA_v221.sql
Solution(s)
The stored procedures are false in the build 1, the fix is available in NRS 221R5_Build002
rsProcessingAborted
Review details problem
Une erreur s'est produite lors du traitement du rapport. Query execution failed for data set 'dsData'. Invalid length parameter passed to the SUBSTRING function.
Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) Query execution failed for data set 'dsData'. (rsErrorExecutingCommand) Conversion failed when converting the nvarchar value '[Measurment.[Hierarchy.&[1' to data type int.
Solution(s)
- Connect through remote desktop to the NRS server and try to make your actions in local to see if we get more logs.
- Look at SSRS logs which should be stored in a path like "C:\Program Files\Microsoft SQL Server\MSRS10_50.NEWTEST\Reporting Services\LogFiles".
- Check if the account Newtest_Rep is db_owner of the Newtest_Reporting database (in SSMS on the reporting server, unfold localhost\newtest,Security,Logins,Server_name and click on the properties of NEWTEST_REP then go to User Mapping, select NewtestReporting database and check the database role membership.
If you are using a domain account instead of Newtest_Rep, check also if it's db_owner of the Newtest_Reporting database.
- Is-it a SQL or an Oracle datawarehouse ? We can check if the stored procedures used for the operations reports are corrects:
Unfold localhost\newtest,NewtestReporting,Programmability,Stored Procedures right click on ps_REPORT_DTL-MES-TDR-001 and modify, check on the description if the version is correct according to your datawarehouse type (Desc : Report DTL-MES-TDR-001 procedure (dtw_newtest SQLServer))
- Check if the linked server is properly defined:
select * from sys.servers
Unflod localhost\newtest,Server Objects,Linked Servers and test the connection of your link server.
If the problem still occurs, we can delete and create a new linked server.
Backup the linked server:
Right click on your linked server, Script Linked Server as,Create to, New Query Editor Windows
Delete it and create a new one.
No measure for a scenario
Review details problem
Measures from only one scenario are not displayed in the NRS.
Solution(s)
Check that the script is attached to a business hierarchy in the NMC (configuration / scenario)
Check the configuration of the data source NewtestDW in Analysis Services, use localhost instead of the machine name.
Invalid length parameter passed to the SUBSTRING function
Review details problem
Context: 2.1.1 R1
We get the following error on two scenarios when using the report Operations Reports/Unavailability Ranges
Solution(s)
Are there some responses times visible in the NMC interface under overview/graph.
Fix in 221
x-axis unreadable
Review details problem
Solution(s)
This problem (x-axis unreadable) occurs because Report Server don't interpret the parameters that NRS send to it (with SQL server 2008 r2).
What is the version of Newtest Reporting Service/SQL server ?
In SQL Server Mangement Studio
In order to fix this display, you have to install the service pack 2 of SQL server. Then you will have to publish all ip-label reports:
Rename INSTALL_DIR_NewtestReporting\Reports\PublishReports.rss by PublishReports.rss_old
and PublishReports.rss_sav by PublishReports.rss
Run a command windows and go to INSTALL_DIR_NewtestReporting\Reports and call PublishReports.bat, it will publish all the ip-label reports.
Rollback the name of these files:
We recommand also to use a resolution of 1280x1024, otherwise you can try to display the same report by reducing the left pannel.
Server error in '/'
Review details problem
Solution(s)
- Update the web.config file from INSTALL_DIR\NewtestReporting\ in order to access to report server (loaded frame in NRS):
- Check if SQL Reporting service is started
Could not find a part of the path 'C:\Windows\system32\ITO
Review details problem
Could not find a part of the path 'C:\Windows\system32\ITO
C:\NewtestReporting\Reports\PublishReports.bat
Solution(s)
Publish all the reports
Rename PublishReports.rss_sav in PublishReports.rss and run C:\NewtestReporting\Reports\PublishReports.bat to publish all the reports (The PublishReports.rss file didn't contain the publication of all the reports, it's just an update of some reports).
Reporting is not working after a fresh installation 221 build 3
Review details problem
Context: "2.21.0.0003" build 3
You use the NMC "2.21.0.0003" build 3 to install the NEP.
Solution(s)
In this version there was a missing parameter (Data Source=) in C:\Newtest\SSIS\DataTransfer SQLSERVER\DataTransfer_SQL.dtsConfig, that was your problem.
The build 4 is available since 12.09.2012 and correct this error. Due to this error, the calendar wasn't generated.
Newtest NRS browser settings IE11
Review details problem
Reports are permanently loading IE 11.
Solution(s)
Comments