cancel
Showing results for 
Search instead for 
Did you mean: 

what diagnostic to obtain for Advanced Reporting - ARFAX

Community Manager

what diagnostic to obtain for Advanced Reporting - ARFAX

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?

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Manager

Re: what diagnostic to obtain for Advanced Reporting - ARFAX

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.

 

Requirements:

  • permission to read the sys.tables in SQL / system tables

 

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

Note:

  • The full path of 'sqlcmd.exe' may need to be specified. For example:
    "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    or
    "C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE"
  • If successful then the output 'arfax.csv' file size should be larger than 100KB.
  • Arfax does not replace the irfax diagnostic which is still needed for the Prognosis server side of the Prognosis Advanced Reporting.

 

View solution in original post

Highlighted
Community Manager

Re: what diagnostic to obtain for Advanced Reporting - ARFAX

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.

 

View solution in original post

Tags (1)
2 REPLIES 2
Highlighted
Community Manager

Re: what diagnostic to obtain for Advanced Reporting - ARFAX

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.

 

Requirements:

  • permission to read the sys.tables in SQL / system tables

 

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

Note:

  • The full path of 'sqlcmd.exe' may need to be specified. For example:
    "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    or
    "C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE"
  • If successful then the output 'arfax.csv' file size should be larger than 100KB.
  • Arfax does not replace the irfax diagnostic which is still needed for the Prognosis server side of the Prognosis Advanced Reporting.

 

View solution in original post

Highlighted
Community Manager

Re: what diagnostic to obtain for Advanced Reporting - ARFAX

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.

 

View solution in original post

Tags (1)
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar