Was this page helpful?

Reports

     

    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.

     

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)


    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

    Minmaxmoy.jpg

    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.

     

    Erreur_generation_de_rapport.jpg

    Erreur_generation_de_rapport1.jpg

    725px-TScreenShot018.jpg

    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

    Rsprocessingaborted.jpg

    Solution(s)

    Are there some responses times visible in the NMC interface under overview/graph.

    Fix in 221

    x-axis unreadable

    Review details problem

    Legend.jpg

    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

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)


    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:

     
    Rename PublishReports.rss by PublishReports.rss_sav
    Rename E:\NewtestReporting\Reports\PublishReports.rss_old  by PublishReports.rss
     

    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

    Ssrsnotstarted.jpg

    Erreursurleserveurappication.jpg

    Solution(s)

    1. Update the web.config file from INSTALL_DIR\NewtestReporting\ in order to access to report server (loaded frame in NRS):
    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)
    1. 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

    Publishreports.jpg

    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.

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)

    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.

    nrs.png - Visionneuse de photos Windows.jpg

    Solution(s)

    Solution(s) : 
     
    1 - Open IE11, go to Tools/Internet Options/Security, add he NRS website to the Trusted Sites
     
    2 - Open IE11, go to Tools/Compatibility view settings, add the NRS Website to the compatibility view.

     

     

     

    See also

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    25063 view(s), 25 edit(s) and 16709 character(s)

    Comments

    You must login to post a comment.