HI Magnus,
I do a SPARQL/Update with a large data set (6027 triples) on /sparql-
auth and get the following error:
37000 Error SP031: SPARQL: Internal error: The length of generated
SQL text has exceeded 10000 lines of code
Where in Virtuoso (open-source edition) can I configure this?
At this time there is no runtime setting for this in VOS.
There are two things you can do:
1. Describe your RDF View with more details and/or make your query
more precise.
If you want we can assist you in rewriting your query/view so it
will run better on VOS.
You can send any schema + view information to me vos.ad...@openlinksw.com
and i will have
someone contact you.
Usually fixes like "option(exclusive)" or "option(bijection)"
dramatically cut down on the
number of generated lines.
See also:
http://docs.openlinksw.com/virtuoso/rdfviews.html
http://docs.openlinksw.com/virtuoso/sparqldebug.html
2. Edit libsrc/Wi/sparql2sql.h around line 739 and change
#define SSG_MAX_ALLOWED_LINE_COUNT 10000
to
#define SSG_MAX_ALLOWED_LINE_COUNT 20000
Option 1 is the preferred solution to this problem.
If you try option 2 there is a good chance you will either run out of
MaxMemPoolSize or the generated query does not run in any reasonable
time limit.
Patrick
