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
