Smart Reporting KPI Reports shows no data in all OOTB Reports |
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers. The possible cause for this case might be Flashboards are not collecting data history. Request you to execute below query at DB end that shows the number of Flashboard variables created in the system: As per the OOTB design, 21 variables are made available in Smart Reporting. "select dv.Name,COUNT(fb.History_ID) from Data_Visualization_Definition dv inner join FB_History fb on (fb.Variable_System_ID = dv.GUID) group by dv.Name" Execute below query at DB end and verify whether flashboard variables are collecting the data. #select * from FB_History #select dv.Name,fb.Group_x,count(fb.History_ID) from Data_Visualization_Definition dv inner join FB_History fb on(fb.Variable_System_ID = dv.GUID) group by dv.Name,fb.Group_x order by name If the records are blank then enable the data collection from developer studio. The same can be performed by login into Dev Studio-> Flashboard variables-> open the variable that we located from DB-> Expand the Data Collection menu-> & can enable the data collection by checking the 'Collect Data' check box-> Save the Variable. Restart the BMC Remedy Flashboard server services. Also kindly follow the below link to setup the row-level security for variables: https://docs.bmc.com/docs/display/public/itsm90/Setting+row-level+security+for+variables ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- If the above queries return some amount of records then would request you to follow the below steps: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Please follow below steps in order to reset Application service password for Flashboard. https://docs.bmc.com/docs/display/public/ars91/Resetting+the+Application+Service+password ++++++++++++++++++++++ 1) Stop Flashboard service. 2) Open command prompt and browse to Flashboard installation dir and run C:\Program Files\BMC Software\ARSystem\flashboards>java -classpath arutil91_build001.jar;flashd91_build001.jar; -DflashInstallPath="C:\Program Files\BMC Software\ARSystem\flashboards" FBDriver Flashboard Driver Password Misc ---------- -------- set (spw) quit (q) Enter the command : spw SET PASSWORD New Password :<Enter new password> Successfully set password. Enter the command :q (Hit Enter) ++++++++++++++++++++++++++++++++ Then open arserver.conf file and confirm below parameters are present or not. ARServerTcpPort=0 RMIRegistryPort=1150 Password=<Encrypted password> ARServerName=<Server Connect Name> Start Flashboard service. |