Export to PDF functionality in Automation services having a data connector exports a blank PDF.

Export to PDF functionality in Automation services having a data connector exports a blank PDF.

The "Export to PDF" functionality in Automation services having a data connector is exporting a blank PDF. The analysis file based on the data connection successfully opens in the web player but, however,  it prompts for the credentials of the data source. Because the credentials are not saved, the query is not executed at the back end when the automation service job is executed on server. This results in the blank export of the pdf file. To avoid this, you may have to change the authentication mode. By default, all Spotfire connectors are listed in the configuration file, Spotfire.Dxp.Worker.Host.exe.config, and all connectors use Prompt as authentication mode.

You can replace the default authentication mode from prompt to the following modes according to the need:
1) ServiceAccount
2) Kerberos
3) WebConfig

The detailed description of these modes is given in the following documentation:

https://docs.tibco.com/pub/spotfire_server/7.8.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-2034E6E4-74C5-4E10-9580-A8C593BA9187.html

So we will have to export the configuration and then change the authentication mode and then import it back. Here are the steps to achieve it:

1) Export the configuration using the following command (in <server installation dir>/tomcat/bin):

config export-service-config --capability=AUTOMATION_SERVICES --deployment-area=Production

2) Edit the Spotfire.Dxp.Worker.Host.exe.config file and change the authentication mode of the desired connector and save the file.

3) Again import this configuration by using the following command:

config import-service-config --config-name=ServiceConfiguration

Once you import the configuration, make sure to select that configuration from (browse to Spotfire server URL >> Nodes & services >> select Automation Services >> Edit >> under 'Configuration' select the one which you have imported). Wait for the service to start again.

Refer the following link for detailed description of export-import command:

https://docs.tibco.com/pub/spotfire_server/7.8.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-958A3AB5-7243-4837-9AEA-78AA274A6F7E.html