Hi Sunday, Running from command line does not report errors in the script being run, so you should connect to isql and use the load command to run you script and see what errors it reports ie
isql 1111
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> load VirtuosoUserCreateQuery.sql;
You should also check the “virtuoso.log” file to see if any errors are reported
there. Note the “trace_on();” command can also be used to write more verbose
server activity to the log file as detailed at:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html
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 28 Feb 2016, at 21:44, Sunday Ayandokun <sunday.ayando...@gmail.com> wrote:
>
> Hello Hugh,
>
> Thanks for your response.
>
> I am sorry for the early conclusion.
>
> I have an sql file with about 100,000 records to insert new user.
>
> The first time I tried using this: isql-vt 1111 dba dba 'EXEC=status()’
> VirtuosoUserCreateQuery.sql
>
> The query was successful. And when I did select count(*) from sys_users;, I
> got 3050.
>
> I tried this for about 3 times same result, definitely am missing something.
>
> Kindly point me to the best approach to creating multiples users.
>
>
> Thanks
> Sunday
>
>> On Feb 28, 2016, at 11:24 PM, Hugh Williams <hwilli...@openlinksw.com
>> <mailto:hwilli...@openlinksw.com>> wrote:
>>
>> Hi Sunday,
>>
>> How have you concluded there is a 3050 user limit, as we have system
>> in-house with 80K+ users ?
>>
>> SQL> select count(*) from sys_users;
>> count
>> INTEGER
>> _______________________________________________________________________________
>>
>> 88016
>>
>> 1 Rows. -- 72 msec.
>> SQL>
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> <http://www.openlinksw.com/>
>> Weblog -- http://www.openlinksw.com/blogs/
>> <http://www.openlinksw.com/blogs/>
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> <http://www.linkedin.com/company/openlink-software/>
>> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
>> Google+ -- http://plus.google.com/100570109519069333827/
>> <http://plus.google.com/100570109519069333827/>
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> <http://www.facebook.com/OpenLinkSoftware>
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>
>>
>>> On 28 Feb 2016, at 17:37, Sunday Ayandokun <sunday.ayando...@gmail.com
>>> <mailto:sunday.ayando...@gmail.com>> wrote:
>>>
>>> Hello all,
>>>
>>> I am working on my Master Thesis, as part of my experimentation I have a
>>> Use Case that requires creating about 100,000 users on the Virtuoso
>>> conductor.
>>>
>>> I found out that, I can only create 3050 users.
>>>
>>> My questions:
>>>
>>> 1. Can this limit be increased?
>>> 2. If yes, where can I do that.
>>>
>>>
>>> Kind regards.
>>> Sunday
>>> ------------------------------------------------------------------------------
>>> 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&iu=/4140
>>> <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140>
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> <mailto: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&iu=/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&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
