%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%

---+ What is the ShortenLongURIs Virtuoso configuration parameter

---++What?

The <code>ShortenLongURIs</code> parameter is a Virtuoso configuration setting to shorten extremely long URIs in datasets when loading with the RDF Bulk Loader.

---++Why?

Some RDF datasets have long URIs that exceed the Virtuoso internal maximum size of 1900 bytes and thus need to be shortened to avoid errors like:

<verbatim>
SR133: Can not set NULL to not nullable column 'DB.DBA.RDF_QUAD.S' (or .O, or .P)
</verbatim> 

which has been seen loading some of the DBpedia 3.7 datasets, for example.

---++How?

The Virtuoso <code>ShortenLongURIs</code> parameter needs to be set in the [[[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_SPARQL][SPARQL]]] section of the Virtuoso configuration file (virtuoso.ini by default) and restart the Virtuoso Server.

<verbatim>
[SPARQL]
.
.
.
ShortenLongURIs = 1
.
.
.
</verbatim>

<b>Note:</b> The <code>ShortenLongURIs</code> parameter is only in the Virtuoso 06.03.3131+ commercial builds, at the time of writing it is not included in the open source 6.1.4 archives but will be in the next 6.1.5 release. A patch to enable this feature is however available from the [[http://sourceforge.net/tracker/?func=detail&aid=3496331&group_id=161622&atid=820576][Virtuso patches page on source forge]], which can be applied to a 6.1.4 archive from source forge and the Virtuoso server binary rebuilt.



---++Related
   
   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[http://docs.openlinksw.com/virtuoso/rdfinsertmethods.html][RDF Insert Methods in Virtuoso]]