Hi Jakub:
You can try running the DB.DBA.RDF_AUDIT_METADATA() function as detailed at:
http://docs.openlinksw.com/virtuoso/fn_rdf_audit_metadata.html
to clear the "22023: SR512: JSO ..." error although I doubt this is the cause
of the problem with http_client.
Can you please enable the following two params in the "[Parameters]" section of
the INI file and restart Virtuoso:
CallStackOnException = 1
PLDebug = 2
as detailed at:
http://docs.openlinksw.com/virtuoso/handlingplcondit.html#stacktracesql
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ptunemetricdiagsqlissues
which may provide more information in the client side and possibly in the
Virtuoso Server log as to why this http_client error is occurring.
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 5 May 2014, at 15:43, Jakub Káňa <jakubk...@gmail.com> wrote:
> Hello when I try to get content of html page using http_client function I am
> still getting 0 back and I am getting an error which I really dont know how
> to fix it.
>
> My procedure so far
>
> create procedure
> POD.DBA.PRODUCT_OPEN_DATA(
> IN new_origin_uri VARCHAR
> )
> {
> --IN graph_iri VARCHAR,
>
> --IN dest VARCHAR,
> --INOUT content any
> --INOUT async_queue any,
> --INOUT ping_service any,
> --INOUT api_key any,
> --INOUT opts any
>
> DECLARE TMP, URL, CONTENT, XT any;
> DECLARE LISTNUM INTEGER;
> LISTNUM := 0;
>
> --ERROR HANDLING
> DECLARE EXIT HANDLER FOR SQLSTATE '*'
> {
> RETURN 0;
> };
>
> IF (new_origin_uri LIKE 'http://www.product-open-data.com/brand-list-%/') {
> TMP:=
> sprintf_inverse(new_origin_uri,'http://www.product-open-data.com/brand-list-%s/'
> ,0);
>
> LISTNUM := trim(TMP[0], '/');
>
> if (LISTNUM is null or LISTNUM > 27) {
> return 0;
> } else {
> URL := sprintf ('http://www.product-open-data.com/brand-list-%s/', LISTNUM);
>
> }
>
> CONTENT := http_client (URL=>url, http_method=>'GET', timeout=>20);
> return CONTENT;
> --XT := xtree_doc(CONTENT, parser_mode => 0, content_encoding => 'UTF-8');
> --XT := DB.DBA.RDF_MAPPER_XSLT (registry_get ('_rdf_mappers_path_') ||
> --'xslt/main/pod2rdf.xsl', XD, vector ('baseUri', new_origin_uri));
> --XD := serialize_to_UTF8_xml (XT);
> }
>
> You can try it e.g. with http://www.product-open-data.com/brand-list-16/
>
> It is weird because it worked two days ago???
>
> c:\Program Files\virtuoso-opensource\database>virtuoso-t -f &
>
> Mon May 05 2014
> 16:36:55 [Using virtuoso.ini in c:\Program Files\virtuoso-opensource\database]
> 16:36:55 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
> 16:36:55 WikiV version 0.6 from OpenLink Software
> 16:36:55 Support functions for WikiV collaboration tool
> 16:36:55 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
> 16:36:55 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
> 16:36:55 MediaWiki version 0.1 from OpenLink Software
> 16:36:55 Support functions for MediaWiki collaboration tool
> 16:36:55 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
> 16:36:55 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
> 16:36:55 CreoleWiki version 0.1 from OpenLink Software
> 16:36:55 Support functions for CreoleWiki collaboration tool
> 16:36:55 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
> 16:36:55 { Loading plugin 4: Type `plain', file `im' in `../hosting'
> 16:36:55 IM version 0.6 from OpenLink Software
> 16:36:55 Support functions for Image Magick 6.6.7
> 16:36:55 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
> 16:36:55 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
> 16:36:55 WBXML2 version 0.9 from OpenLink Software
> 16:36:55 Support functions for WBXML2 0.10.7 Library
> 16:36:55 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
> 16:36:56 OpenLink Virtuoso Universal Server
> 16:36:56 Version 07.10.3207-threads for Win64 as of Feb 17 2014
> 16:36:56 uses parts of OpenSSL, PCRE, Html Tidy
> 16:36:56 Database version 3126
> 16:36:56 SQL Optimizer enabled (max 1000 layouts)
> 16:36:57 Compiler unit is timed at 0.000225 msec
> 16:36:57 built-in procedure "EXEC_STMT" overruled by the RDBMS
> 16:36:58 built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST" overruled by the
> RD
> BMS
> 16:36:58 built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH" overruled by the RDBMS
> 16:36:58 built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI" overruled by the
> RDBMS
>
> 16:36:58 built-in procedure "repl_undot_name" overruled by the RDBMS
> 16:36:58 Roll forward started
> 16:36:59 158 transactions, 151649 bytes replayed (100 %)
> 16:36:59 Roll forward complete
> 16:36:59 Error executing a server init statement : 22023: SR512: JSO instance
> IR
> I <sys:qmv-61cd3e6adf1391ecab642314a7013344> does not exist --
> DB.DBA.RDF_QUAD_
> FT_UPGRADE ()
>
> 16:36:59 Checkpoint started
> 16:36:59 Checkpoint finished, log reused
> 16:36:59 HTTP/WebDAV server online at 8890
> 16:36:59 Server online at 1111 (pid 10908)
>
>
> ------------------------------------------------------------------------------
> Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
> • 3 signs your SCM is hindering your productivity
> • Requirements for releasing software faster
> • Expert tips and advice for migrating your SCM now
> http://p.sf.net/sfu/perforce_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
