Search code examples
spotfire

Spotfire: Some part of the data table "sp_XXXX" could not be loaded. A data source may be missing or has been changed


I have created a spotfire visualization and saved it . However when it is tried accessing through web link I am getting below error

Some part of the data table "XXXXxxxxx" could not be loaded. A data source may be missing or has been changed. enter image description here

I have done below settings :

1) The data is loaded as "Linked to source". 2) Data connections Properties -->Data connections Settings -->data Source--> --> Credentials--> credentials is given (Profile credentials has been shared) 3) I have used an Stored procedure and it is been created under the database which has spotfire access (including schema).

Please help me to solve the issue.


Solution

  • This issue has been resolved . This is due to the temp tables used in the query, it acts weirdly when the temp table used in the stored procedure (as per my observation)