Python Data Function (PyDf) - Error in Executing Function Call

[Paul See]

Hi TIBCO Community,

 

I am facing challenges in running python scripts within the Spotfire Platform. I have installed and uploaded the 2 .spk files associated to the PyDf in my Development Area:

 

SpotfirePS.DataFunctions.Python*.spk

SpotfirePS.DataFunctions.PythonForms.*.spk

 

 

I have also added my python executable file in my PATH environment variable and all relevant modules (numpy, pandas,etc) were installed in the python environment seperately beforehand. As far as I am concerned, I have followed all the installation guidelines.

 

However, unfortunately, when running some scripts from the Spotfire Platform using PyDf, I am facing the following error:

Codes:

from Python_Data_Function import *

import numpy as np

import pandas as pd

df = it

cols = df.columns

names = cols

where, it = input data table

names = outut data table

Error:

File not found: C:UsersAppDataLocalTemptmp1A64.stdf

at Spotfire.Dxp.Data.Import.FileDataSource..ctor(String filePath, String[] additionalFilePaths)

at SpotfirePS.DataFunctions.Python.PythonDataFunctionExcecutor.d__2.MoveNext()

at Spotfire.Dxp.Application.Extension.CustomDataFunctionExecutor.d__5.MoveNext()

at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.d__3.MoveNext()

 

I do not see any import error, thus I do not believe there is any problem with my python environment and its associated modules.

I have also checked other similar posts on this error, however, none of the solutions worked for me.

I would really appreciate any help in resolving this issue.

 

Best,

Paul

[Shandilya Peddi]

A user on the community was able to resolve a similar issue after defining all the required input parameters,

https://community.spotfire.com/questions/python-data-function-temp-file-not-found-python-engine-version-change

Can you check if there are any mismatch between the parameters and make any changes as needed to see if it helps

[Luke George]

I also have the same issue, and it's not due to any mismatch between parameters. 

[Christian Blumenroehr]

Any update on this I have the same issue. All works fine when I use Anaconda 2.7.16, but when using Anaconda 3.7.6 I get the same "File not found" error:

 

 

As can be seen in the image above there is actually a stdf file created at the same time (tmpFC34.stdf) but Spotfire looks for another file tmpFC32.stdf that only exists as tmpFC32.tmp file.