As an administrator, you can update the following project settings by using SQL commands.
visualize.xy.new.bubble.algo
Focal Point 6.6 and later uses a new algorithm to render the bubble size in XY charts. To use the old algorithm to view the XY charts, disable the visualize.xy.new.bubble.algo project setting.
SQL command
update projectsetting set value='false' where name='visualize.xy.new.bubble.algo'
search.index.store
By default, the Lucene search in Focal Point uses a database as the predefined search store. In Focal Point 6.6.1.1 and later, filesystems can be used as the Lucene search store.
To switch to a filesystem as the Lucene search store, update the project setting and restart the server. The workspace is automatically reindexed, and the Search functionality can be used after the workspace indexing is complete.
To roll back to using a database as the Lucene search store, update the project setting, restart the server, and manually re‑index all the workspaces.
SQL command
To specify a filesystem as the Lucene search store, run this SQL command:
INSERT INTO projectsetting (pid,name,value) VALUES (-2, 'search.index.store','Valid_Directory_with_writeAccess')
Restart the server after executing the SQL command.
To roll back to using a database as the search store, run this SQL command:
UPDATE projectsetting SET value='DATABASE' WHERE pid=-2 AND name='search.index.store'
Restart the server after executing the SQL command, and then manually re‑index all the workspaces.