subject:"Re\: \[Virtuoso\-users\] FCT Faceted Browser"

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

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  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 titleversion  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  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=/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=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

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  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  
> 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 titleversion  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  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=/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=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

Thanks Hugh!

I used the develop branch (version 1.00.8754) and installed fct from
there (version 1.13.83 ). Same versions as you, odd.

I just tried urilbl_ac_init_db(); again and received the same error
message. SQL State 3700 is a syntax error or access issue, right?

Is there a good place to check virtuoso for permission error logs? I'm
thinking the only difference in our versions might be the permissions.

Thanks again,

J Haag

---
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  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 titleversion  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  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=/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=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Hugh Williams

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  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  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  
>> 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 titleversion  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  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!
>>>

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

Thanks Hugh!

I will look at those permissions. I just tried to reinstall fct from
conductor and received the following error:

0 Errors detected
0 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.
0 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  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  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  
>> 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  
>>> 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 titleversion  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  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

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

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  (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

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Hugh Williams

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  wrote:
> 
> Thanks Hugh!
> 
> I will look at those permissions. I just tried to reinstall fct from
> conductor and received the following error:
> 
> 0 Errors detected
> 0 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.
> 0 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  
> 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  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  
>>> 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  
 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 titleversion  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
>

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Haag, Jason

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  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  (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

Re: [Virtuoso-users] FCT Faceted Browser

2016-02-03 Thread Hugh Williams

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 titleversion  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  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=/4140___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



smime.p7s
Description: S/MIME cryptographic signature
--
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=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

Re: [Virtuoso-users] FCT Faceted Browser

9 matches

Site Navigation

Mail list logo

Footer information