How to resolve "Could not write job information to file: bad reply.json path. Job failed." when executing TIBCO Statistica data function via TIBCO Spotfire Web Player?

How to resolve "Could not write job information to file: bad reply.json path. Job failed." when executing TIBCO Statistica data function via TIBCO Spotfire Web Player?

book

Article ID: KB0075364

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.6
Spotfire Server 10.3 and higher

Description

If the Statistica data function fails with "Server report:job failed; no additional information." on the web player and in Spotfire Analyst only when the data function is executed on the Server engine, take a look at the Statistica service logs. See : https://support.tibco.com/s/article/How-to-view-the-Statistica-service-log
User-added image

If the Statistica service logs indicate the error as "Could not write job information to file: bad reply.json path. Job failed." the cause of this error is usually that the service account that runs node manager services is longer than 8 characters. In this case, please proceed to follow the instructions below that will help resolve this error.

PREREQUISITES :
Administrator privileges on Spotfire Administrator console.
Ability to remote into Spotfire Node Manager Server as a system Administrator.

Issue/Introduction

How to resolve "Could not write job information to file: bad reply.json path. Job failed." when executing TIBCO Statistica data function via TIBCO Spotfire Web Player?

Resolution

NOTE : It is sufficient to implement one of the workarounds detailed below to resolve the above error.

WORKAROUND 1:
Since the cause is the length of the service account that runs the node manager service , one option is to change the service account to be <8 characters. 

1. Remote into the server that has the Node Manager service. Find the service named "TIBCO Spotfire Node Manager" .
2. Right click on the service, click on properties. Select the Log on tab and change the Service account to be an account that is less than 8 characters.
User-added image

3. Restart the Service. The Statistica data function should now work on WebPlayer and Spotfire Analyst on the Server Engine.

If this workaround cannot be implemented, proceed to WORKAROUND 2 listed below :

WORKAROUND 2:

1. Login to Spotfire Administrator Console>>Nodes and Services.
2.  Stop the Statistica Service on the Spotfire server.
3.  Remote into the Server with Spotfire Node Manager and create a directory of your choosing for the Statistica Service to use as a work directory. For this example, we will use 'C:\tmp\statisticaservice'

4.  Open the 'startStatistica.bat' file in the Statistica Service installation directory and open it for editing.  The directory is typically C:\tibco\tsnm\[Spotfire Server Version]\nm\services\Statistica Service-13.6.0.74-72a25484-663d-4dfe-a043-5e3ffa804019\

5.  Scroll down to roughly line 49. You should see the following line (easier to open in Notepad++):
SET COMMAND=..\..\..\jdk\bin\java -Dlog4j.configurationFile=%LOG4J% .... (line continues)

6.  On this line, after "java" but before "-Dlog4j.configurationFile", paste a new property:
    -Djava.io.tmpdir=C:\tmp\statisticaservice 
 
    So that the line now looks like this:
    SET COMMAND=..\..\..\jdk\bin\java -Djava.io.tmpdir=C:\tmp\statisticaservice -Dlog4j.configurationFile=%LOG4J% .... (line continues)

User-added image
 
7.  Save the file to the desktop location.  Back up the original file and the copy/paste the new file into the same directory
8. Restart the Statistica Service from the Spotfire Administrator Console . The Statistica data function should now work on WebPlayer and Spotfire Analyst on the Server Engine.