I went through all of the post installation steps in Section 16.11.4
(http://docs.openlinksw.com/virtuoso/virtuosospongerfacetinstall.html#virtuosospongerfacetinstallposinst).
All is working now after a clean install. Thanks!
-------------------------------------------------------
Advanced Distributed Learning Initiative
+1.850.266.7100(office)
+1.850.471.1300 (mobile)
jhaag75 (skype)
http://linkedin.com/in/jasonhaag
On Wed, Feb 3, 2016 at 7:10 PM, Haag, Jason <jason.haag....@adlnet.gov> wrote:
> Thanks Hugh. Pasted below. Yes, I'm uninstalling and then reinstalling.
>
> Wed Feb 03 2016
>
> 23:22:26 INFO: { Loading plugin 1: Type `plain', file `wikiv' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:22:26 ERROR: FAILED plugin 1: Unable to locate file }
>
> 23:22:26 INFO: { Loading plugin 2: Type `plain', file `mediawiki' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:22:26 ERROR: FAILED plugin 2: Unable to locate file }
>
> 23:22:26 INFO: { Loading plugin 3: Type `plain', file `creolewiki' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:22:26 ERROR: FAILED plugin 3: Unable to locate file }
>
> 23:22:26 INFO: { Loading plugin 4: Type `plain', file `im' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:22:26 INFO: IM version 0.6 from OpenLink Software
>
> 23:22:26 INFO: Support functions for Image Magick 6.7.7
>
> 23:22:26 INFO: SUCCESS plugin 4: loaded from
> /usr/local/lib/virtuoso-opensource-7/hosting/im.so }
>
> 23:22:26 INFO: OpenLink Virtuoso Universal Server
>
> 23:22:26 INFO: Version 07.20.3215-pthreads for Linux as of Jan 8 2016
>
> 23:22:26 INFO: uses parts of OpenSSL, PCRE, Html Tidy
>
> 23:22:26 INFO: Database version 3126
>
> 23:22:26 INFO: SQL Optimizer enabled (max 1000 layouts)
>
> 23:22:27 INFO: Compiler unit is timed at 0.000424 msec
>
> 23:22:28 DEBUG: built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST"
> overruled by the RDBMS
>
> 23:22:28 DEBUG: built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH"
> overruled by the RDBMS
>
> 23:22:28 DEBUG: built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI"
> overruled by the RDBMS
>
> 23:22:28 INFO: Roll forward started
>
> 23:22:28 INFO: Roll forward complete
>
> 23:22:28 ERROR: Error executing a server init statement : 42000:
> NOINP: Table options specify an non-existent index or index path
> cannot be constructed -- $
>
>
> 23:22:28 INFO: Checkpoint started
>
> 23:22:29 INFO: Checkpoint finished, log reused
>
> 23:22:29 INFO: HTTP/WebDAV server online at 8890
>
> 23:22:29 INFO: Server online at 1111 (pid 4890)
>
> 23:25:17 INFO: PL LOG: Installing Faceted Browser version
> 1.13.83/2016-01-08 21:46 (DAV)
>
> 23:25:17 INFO: Checkpoint started
>
> 23:25:17 INFO: Checkpoint finished, log reused
>
> 23:25:19 INFO: PL LOG: SQ200: Table referenced in contains does not
> have a text index
>
> while executing the following statement:
>
> --no_c_escapes-
>
> create procedure sum_tst (in text_exp varchar, in text_words varchar := null)
>
> {
>
> 23:25:19 INFO: PL LOG: SQ200: Table referenced in contains does not
> have a text index
>
> while executing the following statement:
>
> --no_c_escapes-
>
> create procedure sum_tst_1 (in text_exp varchar, in text_words varchar :=
> null)
>
> 23:25:19 INFO: PL LOG: Errors where detected during installation of
> "Faceted Browser".
>
> 23:25:19 INFO: PL LOG: The installation of this VAD package has failed.
>
> 23:25:19 INFO: PL LOG: Please delete the transaction file
>
> 23:25:19 INFO: PL LOG:
> /usr/local/var/lib/virtuoso-opensource-7/db//usr/local/var/lib/virtuoso-opensource-7/db/virtuoso.trx
>
> 23:25:19 INFO: PL LOG: and then restart your database server.
>
> 23:25:19 INFO: PL LOG: Note: Your database will be in its pre VAD installation
>
> 23:25:19 INFO: PL LOG: state after you restart.
>
> 23:25:22 INFO: Server shutdown complete
>
>
> Wed Feb 03 2016
>
> 23:28:04 INFO: { Loading plugin 1: Type `plain', file `wikiv' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:28:04 ERROR: FAILED plugin 1: Unable to locate file }
>
> 23:28:04 INFO: { Loading plugin 2: Type `plain', file `mediawiki' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:28:04 ERROR: FAILED plugin 2: Unable to locate file }
>
> 23:28:04 INFO: { Loading plugin 3: Type `plain', file `creolewiki' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:28:04 ERROR: FAILED plugin 3: Unable to locate file }
>
> 23:28:04 INFO: { Loading plugin 4: Type `plain', file `im' in
> `/usr/local/lib/virtuoso-opensource-7/hosting'
>
> 23:28:04 INFO: IM version 0.6 from OpenLink Software
>
> 23:28:04 INFO: Support functions for Image Magick 6.7.7
>
> 23:28:04 INFO: SUCCESS plugin 4: loaded from
> /usr/local/lib/virtuoso-opensource-7/hosting/im.so }
>
> 23:28:04 INFO: OpenLink Virtuoso Universal Server
>
> 23:28:04 INFO: Version 07.20.3215-pthreads for Linux as of Jan 8 2016
>
> 23:28:04 INFO: uses parts of OpenSSL, PCRE, Html Tidy
>
> 23:28:04 INFO: Database version 3126
>
> 23:28:04 INFO: SQL Optimizer enabled (max 1000 layouts)
>
> 23:28:05 INFO: Compiler unit is timed at 0.000425 msec
>
> 23:28:06 DEBUG: built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST"
> overruled by the RDBMS
>
> 23:28:06 DEBUG: built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH"
> overruled by the RDBMS
>
> 23:28:06 DEBUG: built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI"
> overruled by the RDBMS
>
> 23:28:06 INFO: Roll forward started
>
> 23:28:06 INFO: Roll forward complete
>
> 23:28:06 ERROR: Error executing a server init statement : 42000:
> NOINP: Table options specify an non-existent index or index path
> cannot be constructed -- $
>
>
> 23:28:06 INFO: Checkpoint started
>
> 23:28:06 INFO: Checkpoint finished, log reused
>
> 23:28:07 INFO: HTTP/WebDAV server online at 8890
>
> 23:28:07 INFO: Server online at 1111 (pid 4913)
>
> -------------------------------------------------------
> Advanced Distributed Learning Initiative
> +1.850.266.7100(office)
> +1.850.471.1300 (mobile)
> jhaag75 (skype)
> http://linkedin.com/in/jasonhaag
>
>
> On Wed, Feb 3, 2016 at 6:09 PM, Hugh Williams <hwilli...@openlinksw.com>
> wrote:
>> Hi Jason,
>>
>> Is there a more detailed error being reported in the “virtuoso.log file ?
>>
>> How are you reinstalling the VAD , I assume you uninstall the existing VAD
>> and then reinstall the same VAD again ?
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> Weblog -- http://www.openlinksw.com/blogs/
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> Twitter -- http://twitter.com/OpenLink
>> Google+ -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>
>>
>>> On 3 Feb 2016, at 23:28, Haag, Jason <jason.haag....@adlnet.gov> wrote:
>>>
>>> Thanks Hugh!
>>>
>>> I will look at those permissions. I just tried to reinstall fct from
>>> conductor and received the following error:
>>>
>>> 00000 Errors detected
>>> 00000 Installation of "Faceted Browser" was unsuccessful.
>>> The installation of this VAD package has failed.
>>> Please delete the transaction file
>>> /usr/local/var/lib/virtuoso-opensource-7/db//usr/local/var/lib/virtuoso-opensource-7/db/virtuoso.trx
>>> and then restart your database server.
>>> Note: Your database will be in its pre VAD installation state
>>> after you restart.
>>> 00000 FATAL
>>>
>>> I removed this log file and restarted, and keep receiving the same
>>> error after trying to reinstall the fct vad from the conductor
>>> interface. I think I'm going to try a new build unless there is an
>>> alternative to updating / reinstall fct.
>>>
>>>
>>> -------------------------------------------------------
>>> Advanced Distributed Learning Initiative
>>> +1.850.266.7100(office)
>>> +1.850.471.1300 (mobile)
>>> jhaag75 (skype)
>>> http://linkedin.com/in/jasonhaag
>>>
>>>
>>> On Wed, Feb 3, 2016 at 5:08 PM, Hugh Williams <hwilli...@openlinksw.com>
>>> wrote:
>>>> Hi Jason,
>>>>
>>>> If RDF_GLOBAL_RESET(0 is run then it will clear all RDF rules and storage
>>>> content, thus the FCT would need to be reinstalled.
>>>>
>>>> I got the same error trying to load a saved faceted view and resolved it
>>>> by granting execute privileges on the function to the the SPARQL user ie
>>>>
>>>> grant execute on "fct_load" to "SPARQL";
>>>>
>>>> Best Regards
>>>> Hugh Williams
>>>> Professional Services
>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>> Weblog -- http://www.openlinksw.com/blogs/
>>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>> Twitter -- http://twitter.com/OpenLink
>>>> Google+ -- http://plus.google.com/100570109519069333827/
>>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>>> Universal Data Access, Integration, and Management Technology Providers
>>>>
>>>>
>>>>
>>>>> On 3 Feb 2016, at 21:01, Haag, Jason <jason.haag....@adlnet.gov> wrote:
>>>>>
>>>>> I'm not sure if this is a result of previously doing a global reset
>>>>> though. I just created a faceted view and when I click on it from the
>>>>> fct featured views, I receive the error:
>>>>>
>>>>> Error 42000
>>>>>
>>>>> SR186:SECURITY: No permission to execute procedure fct_load with user
>>>>> ID 107, group ID 107
>>>>>
>>>>> After reading this post, I think I need to do more homework on fct
>>>>> security :-(
>>>>> https://www.mail-archive.com/virtuoso-users@lists.sourceforge.net/msg05775.html
>>>>>
>>>>> -------------------------------------------------------
>>>>> Advanced Distributed Learning Initiative
>>>>> +1.850.266.7100(office)
>>>>> +1.850.471.1300 (mobile)
>>>>> jhaag75 (skype)
>>>>> http://linkedin.com/in/jasonhaag
>>>>>
>>>>>
>>>>> On Wed, Feb 3, 2016 at 2:31 PM, Haag, Jason <jason.haag....@adlnet.gov>
>>>>> wrote:
>>>>>> It looks like this issue was reported before:
>>>>>> https://github.com/openlink/virtuoso-opensource/issues/245
>>>>>>
>>>>>> I did a global reset recently, but have populated it since then.
>>>>>> -------------------------------------------------------
>>>>>> Advanced Distributed Learning Initiative
>>>>>> +1.850.266.7100(office)
>>>>>> +1.850.471.1300 (mobile)
>>>>>> jhaag75 (skype)
>>>>>> http://linkedin.com/in/jasonhaag
>>>>>>
>>>>>>
>>>>>> On Wed, Feb 3, 2016 at 2:07 PM, Hugh Williams <hwilli...@openlinksw.com>
>>>>>> wrote:
>>>>>>> Hi Jason,
>>>>>>>
>>>>>>> What Virtuoso archive did you build against git develop/7 or stable/7
>>>>>>> , as
>>>>>>> I just built against develop/7 and it works for me:
>>>>>>>
>>>>>>> SQL> RDF_OBJ_FT_RULE_ADD (null, null, 'All');
>>>>>>>
>>>>>>> Done. -- 18 msec.
>>>>>>> SQL> VT_INC_INDEX_DB_DBA_RDF_OBJ ();
>>>>>>>
>>>>>>> Done. -- 50 msec.
>>>>>>> SQL> urilbl_ac_init_db();
>>>>>>>
>>>>>>> Done. -- 20 msec.
>>>>>>> SQL> s_rank();
>>>>>>>
>>>>>>> Done. -- 223 msec.
>>>>>>> SQL> vad_list_packages ();
>>>>>>> name title version build_date install_date
>>>>>>> VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR
>>>>>>> _______________________________________________________________________________
>>>>>>>
>>>>>>> conductor Virtuoso Conductor 1.00.8754 2015-12-30 16:49 2016-01-27
>>>>>>> 15:48
>>>>>>> fct Faceted Browser 1.13.84 2016-02-03 19:49 2016-02-03 20:02
>>>>>>>
>>>>>>> 2 Rows. -- 11 msec.
>>>>>>> SQL>
>>>>>>>
>>>>>>> Also, did you compile your own FCT vad or download it from somewhere ?
>>>>>>>
>>>>>>> Best Regards
>>>>>>> Hugh Williams
>>>>>>> Professional Services
>>>>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>>>>> Weblog -- http://www.openlinksw.com/blogs/
>>>>>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>>>>> Twitter -- http://twitter.com/OpenLink
>>>>>>> Google+ -- http://plus.google.com/100570109519069333827/
>>>>>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>>>>>> Universal Data Access, Integration, and Management Technology Providers
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 3 Feb 2016, at 18:35, Haag, Jason <jason.haag....@adlnet.gov> wrote:
>>>>>>>
>>>>>>> Hi Guys,
>>>>>>>
>>>>>>> I have installed fct. Both the text search and entity URI tabs work
>>>>>>> fine.
>>>>>>> However, the entity label lookup tab doesn't work when any entities are
>>>>>>> typed. I read the post-installation instructions here:
>>>>>>>
>>>>>>> http://docs.openlinksw.com/virtuoso/virtuosospongerfacetinstall.html
>>>>>>>
>>>>>>> Under the section "16.11.4. Post Installation" it states in order to
>>>>>>> activate the Label text box of the Entity Label Lookup tab, to run this
>>>>>>> procedure in iSQL:
>>>>>>>
>>>>>>> urilbl_ac_init_db()
>>>>>>>
>>>>>>> However, when I attempt to run this I receive the following error:
>>>>>>>
>>>>>>> SQLState: 37000
>>>>>>> Message: SQ074: Line 25 (line 24 of "/DAV/VAD/fct/complete_single.sql"):
>>>>>>> SP031: SPARQL compiler: 'define input:inference refers to undefined
>>>>>>> inference rule set "facets"
>>>>>>>
>>>>>>> I'm running VOS on ubuntu, Version: 07.20.3215. Appreciate any tips on
>>>>>>> troubleshooting or enabling this.
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> J Haag
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>>>>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>>>>>> Monitor end-to-end web transactions and take corrective actions now
>>>>>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
>>>>>>> Virtuoso-users mailing list
>>>>>>> Virtuoso-users@lists.sourceforge.net
>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>>>>
>>>>>>>
>>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>> Monitor end-to-end web transactions and take corrective actions now
>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
