Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledgebase
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Spotfire Server library import performance is very slow

Kisiel, Pawel
  • Updated
Problem Summary:
When large amount of data is imported into Spotfire Server Library, import process performance can be very slow, including very long pauses, as could be seen in Spotfire Server's impex.log file:
 
[2024-04-15T22:06:29,283-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, Starting import of: library_data.part0.zip"
[2024-04-15T22:07:33,085-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, Found 3341 items to import."
[2024-04-15T22:17:53,147-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 100 of 3341 items inserted."
...
[2024-04-15T23:11:19,173-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 1100 of 3341 items inserted."
...
[2024-04-16T01:16:17,914-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 1400 of 3341 items inserted."
...
[2024-04-16T03:15:24,226-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 1900 of 3341 items inserted."
...
[2024-04-16T05:30:18,842-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 2500 of 3341 items inserted."
...
[2024-04-16T08:26:00,090-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, 3300 of 3341 items inserted."
[2024-04-16T08:41:09,882-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, All 3341 items inserted."
[2024-04-16T08:41:09,883-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, Handling dependencies."
[2024-04-16T08:43:20,034-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, Post processing 4771 imported items of types: join, datasource, procedure, query, column, filter."
...
[2024-04-16T09:32:23,878-0700] "jobid:ff9bf19a-ab4c-45bd-add5-81cd0cba1d8c, Import done"
 
Solution:
 
In some situations, it's possible that "check for LDAP external users" configuration option could cause significant import process slowdowns. To resolve the issue, this LDAP check for external users should be disabled:
 
1. On Spotfire Server, open Spotfire Server Configuration Tool.
2. From System Status -> "Specify Configuration" section, use "Export configuration from database" to export the latest server configuration.
3. Open the exported configuration.xml file in a text editor.
4. Locate 'check-external-users' element:
   <check-external-users>true</check-external-users>
 Set it to 'false':
   <check-external-users>false</check-external-users>
5. Save the configuration file.
6. Load the modified configuration.xml file using Spotfire Server Configuration Tool (System Status -> "Specify Configuration" -> "Load configuration from file").
7. Save the configuration to the database (Configuration > "Save configuration").
8. Restart the Spotfire Server service and run import process again.
 

 

Related articles

Comments

0 comments

Article is closed for comments.