Prognosis Advanced Reporting has components on both a Prognosis server and an SQL server. What diagnostics should I obtain if I need help with an Advanced Reporting issue?
Solved! Go to Solution.
In addition to getting an IRFAX from the Prognosis server side, the ARFAX is a diagnostic of the SQL side of Prognosis Advanced Reporting - BigDataInsight / BusinessInsight versions 11.0, 11.3, 11.4 and 11.5. An ARFAX can be generated by downloading and running the attached 'arfax11.5.sql.txt' SQL script and directing the output into a text file. The Microsoft 'sqlcmd.exe' command line utility can be used as described below.
option 1 - as 'SA' SQL user:
In a command prompt, in the directory where 'arfax11.5.sql.txt' is downloaded to:
"SQLCMD.EXE" -S <hostname>\<instance> -U SA -P <password> -d <BigDataInsight-DB-name> -W -s, -i arfax11.5.sql.txt -o arfax.csv
option 2 - as 'domain\user' NT authentication:
runas /user:domain\user cmd.exe
Then in the new launched command prompt in the directory where 'arfax11.5.sql' is downloaded to:
"SQLCMD.EXE" -S <hostname>\<instance> -d <BigDataInsight-DB-name> -W -s, -i arfax11.5.sql.txt -o arfax.csv
Here is a short video example of option 2 and on the Prognosis server.
Steps in the Video:
1. Copy the commands into a text editor; then determine the variables from Prognosis Client and fill in the variables.
2. NT user - Properties of a BigDataInsight databases; File > Create Document > Database Collection , select Format tab, note the passwordkey, then get the NT user from that passwordkey in PASSWORDS configuration.
3. SQL server hostname and instance name - in the database properties, use the server name (or IP address) and instance name (or if it is a blank instance)
4. SQL database name - Open "ODBC Data Sources 32-bit" console (or 64-bit) > "System DSN" > the ODBC object name > flick through Configuration options find for example BigDataInsightUCSource, then DB name is , example BigDataInsightUC.
5. run the commands;
6. Inspect the resulting file to confirm that it contains diagnostics.
Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.
Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.Join webinar