KnowledgeBase Content Details

October 20, 2015

Question:

TIBCO Spotfire Server upgrade tool fails with, "Unable to rewrite data sources using DataDirect and NTLM authentication" in the case of external library storage.

Answer:

The following workaround can be used to upgrade in case of external library storage.

--------------------------------
1.) Make backup of Spotfire DB.
2). Make backup of Spotfire library stored in shared file system.
3). Run following SQL statements on the Spotfire Database.


    --------------------------    

    -- create new 'temporary' library type
    insert into LIB_ITEM_TYPES (TYPE_ID, LABEL, LABEL_PREFIX, DISPLAY_NAME, IS_CONTAINER, FILE_SUFFIX, MIME_TYPE) 
        values ('e3fd56ff-07a1-4a09-b05b-1d148f1f6786', 'datasourcetmp', 'spotfire', 'datasourcetmp', 0, null, null);
 
    -- Change all datasources to the temporary data type.
    update lib_items set item_type = 'e3fd56ff-07a1-4a09-b05b-1d148f1f6786' where item_type = 'e3fd5644-07a1-4a09-b05b-1d148f1f6786';
 
    -- Verify that they have changed.
    select * from lib_items where item_type = 'e3fd56ff-07a1-4a09-b05b-1d148f1f6786';


    ------------------------

4). Run upgrade tool (upgradetool.bat).

5). Run the following SQL to rollback the temporary changes performed at step 3.


     -------------------------
     -- Move back to the proper datasource type.
     update lib_items set item_type = 'e3fd5644-07a1-4a09-b05b-1d148f1f6786' where item_type = 'e3fd56ff-07a1-4a09-b05b-1d148f1f6786';
 
     -- Show the datasources.
     select * from lib_items where item_type = 'e3fd5644-07a1-4a09-b05b-1d148f1f6786';
 
     -- Show the temporary library type.
     select *  from lib_item_types where type_id = 'e3fd56ff-07a1-4a09-b05b-1d148f1f6786';
 
     -- Remove the temporary library type.
     delete from lib_item_types where type_id = 'e3fd56ff-07a1-4a09-b05b-1d148f1f6786';
 
     -- Verify that there is only one type starting with e3fd56.
     select * from lib_item_types where type_id like 'e3fd56%'
 
     -- If upgrade has succeeded to 7.0, this should show 60.
      select * from sn_version;
     ---------------------------

Back to KnowledgeBase