When trying to open the Scheduled Updates configuration in the TIBCO Spotfire Web Player, the following error is displayed: 'The Library item 6fdbc6a1-a719-465b-b6ef-94261459a497 does not exist'.
Article ID: KB0083787
Updated On:
| Products | Versions |
|---|---|
| Spotfire Web Player | 7.0 and lower |
| Not Applicable | - |
Description
When trying to open the Scheduled Updates configuration page in the TIBCO Spotfire Web Player, the following error is displayed:
- 'The Library item 6fdbc6a1-a719-465b-b6ef-94261459a497 does not exist'.
In the TIBCO Spotfire Server logs, you will see an error resembling the following:
- WARN 2O15:01:01T12:00:00,00000 (myUser, *100) ws.library.LibraryService: An exception occurred in method saveItem.
com.spotfire.ws.library.StorageException: com.microsoft.sqlserver.jdbc.SQL.ServerException: ERR-50005 - The item with ID 6fdbc6a1-a719-465b-b6ef-94261459497
SQLServerException: ERR-50005 - The item with ID 6fdbc6a1-a719-465b-b6ef-94261459497 does not exist., ITEM_DOES_NOT_EXIST, 6fdbc6a1-a719-465b-b6ef-94261459497
If in the Web Player web.config you set useLibrary="false", as shown here:
- <scheduledUpdates enabled="true" useLibrary="false" libraryFileName="ScheduledUpdates" settingsFile="App_Data\ScheduledUpdates.xml" concurrentUpdates="2" updateIntervalSeconds="60">
then the Scheduled Updates feature will work as expected, as the local ScheduledUpdates.xml file is used and the Web Player does not attempt to save the Scheduled Updates plan to the Spotfire database.
Resolution
The item with GUID 6fdbc6a1-a719-465b-b6ef-94261459a497 is a hidden system folder in the LIbrary called 'Tasks' which is used to store the Scheduled Updates plan in the database. If this folder is deleted for some reason then Scheduled Updates will not be able to be saved to the database.
To resolve, restore or reinstall the TIBCO Spotfire application database to a working state in which the 'Tasks' folder exists. For example, the 'Tasks' folder in the Spotfire database should have values similar to this in the LIB_ITEMS table:
To resolve, restore or reinstall the TIBCO Spotfire application database to a working state in which the 'Tasks' folder exists. For example, the 'Tasks' folder in the Spotfire database should have values similar to this in the LIB_ITEMS table:
Query:
SELECT * FROM LIB_ITEMS WHERE ITEM_ID='6fdbc6a1-a719-465b-b6ef-94261459a497'
Results:
ITEM_ID TITLE DESCRIPTION ITEM_TYPE FORMAT_VERSION CREATED_BY CREATED MODIFIED_BY MODIFIED ACCESSED CONTENT_SIZE PARENT_ID HIDDEN 6fdbc6a1-a719-465b-b6ef-94261459a497 Tasks NULL 4f83cd41-71b5-11dd-050e-00100a64217d 11.0 NULL 2014-10-01 10:21:02.050 af75b52d-a031-482a-a623-786f63005db1 2015-03-05 16:32:59.910 NULL 0 4dad81b0-4e2b-44ff-9a6d-ff7b5c862649 1
Issue/Introduction
When trying to open the Scheduled Updates configuration in the TIBCO Spotfire Web Player, the following error is displayed: 'The Library item 6fdbc6a1-a719-465b-b6ef-94261459a497 does not exist'.
Feedback
Yes
No
Powered by
