Hi,
I have an error installing ODS Framework version 2.2.1_git755/2022-04-11 on Windows the error is:
PL LOG: SR013: Function get_keyword needs a string or an array as argument 2, not an arg of type INTEGER (189)
Any ideas to solve the issue, I am testing a Free Trial 8.3 version. I have tried to upload online version of ODS but not working because different version ( SQ111: No table DB.DBA.SYS_HTTP_SPONGE).
LOG:
10:33:58 PL LOG: Installing ODS Framework version 2.2.1_git755/2022-04-11 16:00 (DAV)
10:33:58 Checkpoint started
10:33:59 Checkpoint finished, log reused
10:34:11 PL LOG: SR013: Function get_keyword needs a string or an array as argument 2, not an arg of type INTEGER (189)
while executing the following statement:
–no_c_escapes-
wa_services_upgrade ()
in file:
/DAV/VA
10:34:20 PL LOG: Errors were detected during installation of “ODS Framework”.
10:34:20 PL LOG: The installation of this VAD package has failed.
10:34:20 PL LOG: Please delete the transaction file
10:34:20 PL LOG: C:\Program Files\OpenLink Software\Virtuoso 8.3\database/virtuoso.trx
10:34:20 PL LOG: and then restart your database server.
10:34:20 PL LOG: Note: Your database will be in its pre VAD installation
10:34:20 PL LOG: state after you restart.
10:34:23 Server shutdown complete
Thanks.
Regards.
What is the version and gitid of the Virtuoso binary being used, which can be obtained detailed here ?
I can installed the version of the VAD ie ODS Framework version 2.2.1_git755/2022-04-11 against the Virtuoso 08.03.3323 build it shipped with and is the current release available for download:
21:20:46 PL LOG: Installing ODS Framework version 2.2.1_git755/2022-04-11 16:00 (DAV)
21:20:46 Checkpoint started
21:20:46 Checkpoint finished, log reused
21:20:53 Checkpoint started
21:20:53 Checkpoint finished, log reused
21:20:53 PL LOG: Installing ODS Weblog version 2.2.1_git755/2022-04-11 16:00 (DAV)
21:20:53 Checkpoint started
21:20:53 Checkpoint finished, log reused
What other VADs do you have installed, which can be obtained by running the vad_list_packages(); command ?
SPARQL | HTML5 table
| name |
version |
build_date |
thread |
opsys |
| OpenLink Virtuoso VDB Server |
08.03.3323 |
Apr 22 2022 |
-threads |
Win64 |
SQL> vad_list_packages();
Connected to OpenLink Virtuoso
Driver: 08.03.3323 OpenLink Virtuoso ODBC Driver
name title version build_date install_date
VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR
OAT OAT Release 2.9.12 2012-05-07 2022-08-30 08:45
VAL Virtuoso Authentication Layer 2.2.3_git360 2022-04-08 15:53 2022-08-30 08:44
cartridges Linked Data Cartridges 1.101_git336 2022-04-06 14:34 2022-08-30 14:05
conductor Virtuoso Conductor 1.00.8842 2022-04-18 16:52 2022-08-30 08:42
rdb2rdf RDB2RDF support 1.00.284 2022-04-07 12:00 2022-08-30 09:55
5 Rows. – 16 msec.
I have installed the Virtuoso in another PC and the installation was fine. This time I installed first ODS.
I will update you.
So, I have installed again Virtuoso on my PC and now the installation of ODS went fine.
Still not understanding previous problem.
Thanks.
Regards.
I can successfully installed the same VADs as you have installed on the same Windows Virtuoso build:
SQL> vad_list_packages();
name title version build_date install_date
VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR
_______________________________________________________________________________
Framework ODS Framework 2.2.1_git755 2022-04-11 16:00 2022-08-30 16:53
OAT OAT Release 2.9.12 2012-05-07 2022-08-30 16:51
VAL Virtuoso Authentication Layer 2.2.3_git360 2022-04-08 15:53 2022-08-30 16:51
cartridges Linked Data Cartridges 1.101_git336 2022-04-06 14:34 2022-08-30 16:51
conductor Virtuoso Conductor 1.00.8842 2022-04-18 16:52 2022-08-30 16:50
rdb2rdf RDB2RDF support 1.00.284 2022-04-07 12:00 2022-08-30 16:52
6 Rows. -- 0 msec.
SQL> status();
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso VDB Server
Version 08.03.3323-threads for Win64 as of Apr 22 2022
Can you please provide a copy of your “virtuoso.log” file for review ?
This, is part of the LOG:
10:30:27 SQL Optimizer enabled (max 1000 layouts)
10:30:28 Compiler unit is timed at 0.000170 msec
10:30:29 Roll forward started
10:30:29 Roll forward complete
10:30:30 Checkpoint started
10:30:30 Checkpoint finished, log reused
10:30:30 HTTP Server threads exceed the number of licensed connections. Setting to 1
10:30:30 HTTP/WebDAV server online at 8890
10:30:30 HTTPS server online at :443
10:30:30 Server online at 1111 (pid 14308)
10:30:31 ZeroConfig registration ZNAME
10:30:51 PL LOG: Installing ODS Framework version 2.2.1_git755/2022-04-11 16:00 (DAV)
10:30:51 Checkpoint started
10:30:51 Checkpoint finished, log reused
10:31:03 PL LOG: SR013: Function get_keyword needs a string or an array as argument 2, not an arg of type INTEGER (189)
while executing the following statement:
–no_c_escapes-
wa_services_upgrade ()
in file:
/DAV/VA
10:31:13 PL LOG: Errors were detected during installation of “ODS Framework”.
10:31:13 PL LOG: The installation of this VAD package has failed.
10:31:13 PL LOG: Please delete the transaction file
10:31:13 PL LOG: C:\Program Files\OpenLink Software\Virtuoso 8.3\database/virtuoso.trx
10:31:13 PL LOG: and then restart your database server.
10:31:13 PL LOG: Note: Your database will be in its pre VAD installation
10:31:13 PL LOG: state after you restart.
10:31:16 Server shutdown complete
Regards.
What Virtuoso license do you have in place as I see the message HTTP Server threads exceed the number of licensed connections. Setting to 1 in the log which indicates your HTTP threads (MaxClientConnections in the INI file) is higher than the license allows ?
The log snippet is too small, you should provide it from at least when the server last started up so we can see the version details and license file in use.
Is the 08.03.3323 Apr 22 2022 binary the only one you have used on this Virtuoso setup or might you have possibly used a previous version of the binary ?
Hi ,
in my Window PC I have the Free Trial license and also I have the installed the Virtuoso Open Source:
I think maybe there is a problem with the license is not working proprely. Sometimes I have errors like this:
Error HTTP/1.1 503 Service Unavailable
License has expired URI = ‘/DAV/VAD/conductor/cont_page.vspx’
But License is active until 30-Set-2022…
How can I check if the license is correctly installed ?
Virtuoso version:
More details:
As asked previously what is the output in the “virtuoso.log” file from the time of last startup, as that will show, what if any license has been found or not, in which case the Virtuoso built-in demo license would be activated with restrictions one of which is that it expires after 10mins of use …
Yes,
but during the installation I have put the license , why is not working…?
Problem solved the license must by named only: virtuoso.lic and during the installation if you give another name no error was prompt .
Now, the installation is ok:
