Hello everyone, I’m trying to acces the the WebDav interface via conductor, but I’m having trouble, 'cause when I click the ‘WebDAV Browser’ I’m getting the following message:
|Function sprintf needs an integer as argument 2, not an arg of type DB_NULL (204)|
I don’t know why I’m having this trouble. If anyone can help me, I would appreciate.
What are the version details of the Virtuoso server being used ?
Do you have any other Virtuoso VAD or other packages/components installed ?
Are any errors reported in the virtuoso.log file locate in the database directory by default ?
Helo, Hugh, thanks for the answer!
Let me answer your questions:
What are the version details of the Virtuoso server being used ?
R = I’m in 07.20.3237 version.
Do you have any other Virtuoso VAD or other packages/components installed ?
No, I haven’t installed any components or package from VAD.
Are any errors reported in the virtuoso.log file locate in the database directory by default ?
This is my log, when I try to access the WebDav Browser on Virtuoso. It is seeming that isn’t any error at all. I don’t know what’s the problem. :
Tue Dec 19 2023
11:07:40 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
11:07:40 WikiV version 0.6 from OpenLink Software
11:07:40 Support functions for WikiV collaboration tool
11:07:40 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
11:07:40 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
11:07:40 MediaWiki version 0.1 from OpenLink Software
11:07:40 Support functions for MediaWiki collaboration tool
11:07:40 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
11:07:40 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
11:07:40 CreoleWiki version 0.1 from OpenLink Software
11:07:40 Support functions for CreoleWiki collaboration tool
11:07:40 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
11:07:40 { Loading plugin 4: Type `plain', file `im' in `../hosting'
11:07:40 IM version 0.62 from OpenLink Software
11:07:40 Support functions for Image Magick 6.9.9
11:07:40 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
11:07:40 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
11:07:40 WBXML2 version 0.9 from OpenLink Software
11:07:40 Support functions for WBXML2 0.9.2 Library
11:07:40 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
11:07:40 { Loading plugin 6: Type `plain', file `proj4' in `../hosting'
11:07:40 plain version 1.1.3237 from OpenLink Software
11:07:40 Cartographic Projections support based on Frank Warmerdam's proj4 library
11:07:40 SUCCESS plugin 6: loaded from ..\hosting\proj4.dll }
11:07:40 { Loading plugin 7: Type `plain', file `geos' in `../hosting'
11:07:40 plain version 1.2.3237 from OpenLink Software
11:07:40 GEOS plugin based on Geometry Engine Open Source library from Open Source Geospatial Foundation
11:07:40 SUCCESS plugin 7: loaded from ..\hosting\geos.dll }
11:07:40 { Loading plugin 8: Type `plain', file `shapefileio' in `../hosting'
11:07:40 ShapefileIO version 0.1virt71 from OpenLink Software
11:07:40 Shapefile support based on Frank Warmerdam's Shapelib
11:07:40 SUCCESS plugin 8: loaded from ..\hosting\shapefileio.dll }
11:07:40 { Loading plugin 9: Type `plain', file `graphql' in `../hosting'
11:07:40 GraphQL/SPARQL Bridge version 0.9.3 (000000) from OpenLink Software
11:07:40 Support functions for GraphQL/SPARQL Bridge
11:07:40 SUCCESS plugin 9: loaded from ..\hosting\graphql.dll }
11:07:40 OpenLink Virtuoso Universal Server
11:07:40 Version 07.20.3237-threads for Win64 as of Jun 7 2023 (000000)
11:07:40 uses OpenSSL 1.1.1u 30 May 2023
11:07:40 uses parts of PCRE, Html Tidy
11:07:40 Database version 3126
11:07:40 SQL Optimizer enabled (max 1000 layouts)
11:07:41 Compiler unit is timed at 0.000191 msec
11:07:42 Roll forward started
11:07:42 Roll forward complete
11:07:45 Checkpoint started
11:07:45 Checkpoint finished, log reused
11:07:45 HTTP/WebDAV server online at 8890
11:07:45 Server online at 1050 (pid 8796)
I’m thinking of going to install the latter version of Virtuoso and test if the problem would be resolved.
Thanks for your help. If I have any new results, I will post them here!
OK, please let us know if the problem occurs with the latest Virtuoso Open Source Windows build, starting with an empty database, as that works for me.
Hello, Huge, I’ve already installed the Virtuoso 8, and now I have succeeded well on tranforming my SQL to XML files, but, I’m uploading my files in CSV format, in UTF-8 format. Before, this operation was ok, the special characters, in Portuguese like ´ `, ~, and others was showing like I was expecting. But, now, I’m obtaining results like these. Do you know how should I handle with this issue? :
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DE MATO GROSSO</NO_IES>
<CO_IES>1</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE DE BRASÃÂLIA</NO_IES>
<CO_IES>2</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DE SERGIPE</NO_IES>
<CO_IES>3</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DO AMAZONAS</NO_IES>
<CO_IES>4</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DO PIAUÃÂ</NO_IES>
<CO_IES>5</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DE OURO PRETO</NO_IES>
<CO_IES>6</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DE SÃO CARLOS</NO_IES>
<CO_IES>7</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DE VIÇOSA</NO_IES>
<CO_IES>8</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE ESTADUAL DE LONDRINA</NO_IES>
<CO_IES>9</CO_IES>
</ies>
<ies>
<NO_IES>PONTIFÃÂCIA UNIVERSIDADE CATÓLICA DO PARANÃÂ</NO_IES>
<CO_IES>10</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE CATÓLICA DE PERNAMBUCO</NO_IES>
<CO_IES>11</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE FEDERAL DO RIO GRANDE</NO_IES>
<CO_IES>12</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE DE CAXIAS DO SUL</NO_IES>
<CO_IES>13</CO_IES>
</ies>
<ies>
<NO_IES>UNIVERSIDADE DO VALE DO RIO DOS SINOS</NO_IES>
Another problem I’m having is: when I try to run some quary with XML Query Model, I’m getting the result message:
<ies>
<!-- ERROR SQLState: HT424 SQLMessage: Unsupported protocol -->
</ies>
The code I’ve tried to run was:
for $i in document("ies2.xml")//Doc_Ies
return
<Doc_Ies>
{
$i/CO_IES,
$i/NO_IES/text()
}
</Doc_Ies>
This topic is about WebDAV access to the conductor interface, which seems to have been resolved with your Virtuoso 8 commercial installation.
If you are now have a SQL to XML problem then a new topic/post should be created detailing this specific steps for recreating the issue being reported, including any documentation links being followed etc