How to generate an ARFAX when no access to SQL server

[GeraldC1]

When I try generate an ARFAX I run the arfax.bat 

Prognosis\Server\Configuration\BigDataInsight\<Solution>\ARFAX.bat

But it fails and the output diagnostic ARFAX.csv has only 1 line with a "login failed" error like this. 

"Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user"

This is because my Windows account does not have access to the SQL server. 

Is there a way that I can still generate an ARFAX when no access to SQL server?

[GeraldC1 · Accepted solution]

Yes. There is a way to do that with a batch file of a command utilising the SQL credentials in Prognosis.

Here's a short video and steps on how to set up the batch file.

Step 1: Create a batch file "run_ARFAX.bat" in Prognosis\Server\Configuration
Step 2: In Notepad Paste this text into it:

echo off
cls
HOSTNAME
..\ircnfutl list_conf PASSWORDS | findstr /i Command: | find /v "COMMANDROGNOSIS"
dir /a:d /b BigDataInsight\* | find /v "Solutions" | find /v "Utils"
..\ircmdgwy -n \HOSTNAME -d Shell -t 1260 -p UC -c "cd BigDataInsight\UC && Arfax.bat"
pause

Step 3: Save the file but keep Notepad open

Step 4: Run the "run_ARFAX.bat"

Step 5: Copy the 3 parameters into the ircmdgwy command in Notepad: replace HOSTNAME, replace "UC" with the solution name, replace the "BigDataInsight\UC" with the correct folder name.

Step 6: Save the file, run it, check the Prognosis\Sever\Configuration\BigDataInsight\<solution> folder to see if the arfax.csv is created and contains several MB of data successfully.