Search code examples
xquerymarklogic

TDE template derived from Person example fails

I am using MarkLogic 9 and following the tutorial about SQL Datamodeling Guide ( https://docs.marklogic.com/guide/sql/intro ) Al pre conditions are met:

  1. Installing MarkLogic 9 on Cent Os (Done without errors )
  2. Create forests (Done without errors )
  3. Create databases (Done without errors )
  4. Insert data (Done without errors )

Until i reach to create a template view ( https://docs.marklogic.com/guide/sql/setup#id_14127 ) When i execute the statement in the query console i got the following error:

[1.0-ml] SVC-FILOPN: File open error: open '/MarkLogic/tde.xqy': No 

such file or directory
Stack Trace

At line 2 column 0:
In xdmp:eval("xquery version &quot;1.0-ml&quot;; &#10;import module namespace ...", (), <options xmlns="xdmp:eval"><database>18182129315596444747</database>...</options>)
1. xquery version "1.0-ml"; 
2. import module namespace tde = "http://marklogic.com/xdmp/tde" 
3. at "/MarkLogic/tde.xqy";

The files of MarkLogic are placed in the folder ./opt/MarkLogic and the directory has the folow

erik@marklogic-vm /opt/MarkLogic $ ls -l
total 460
drwxr-xr-x  5 root root  53248 Apr 14 19:40 Admin
drwxr-xr-x 15 root root   4096 Apr 14 19:40 Apps
drwxr-xr-x  4 root root   4096 Apr 14 19:40 Assets
drwxr-xr-x  2 root root   4096 Apr 14 19:40 bin
drwxr-xr-x  3 root root  20480 Apr 14 19:40 Config
drwxr-xr-x  5 root root   4096 Apr 14 19:40 Converters
drwxr-xr-x  2 root root   4096 Apr 14 19:40 Docs
drwxr-xr-x  3 root root   4096 Apr 14 19:40 FlexRep
-rw-r--r--  1 root root  35147 Apr 11 09:08 GPL.txt
drwxr-xr-x  2 root root   4096 Apr 14 19:40 HealthCheck
drwxr-xr-x  2 root root   4096 Apr 14 19:40 include
drwxr-xr-x 12 root root   4096 Apr 14 19:40 Installer
drwxr-xr-x  3 root root   4096 Apr 14 19:40 java
drwxr-xr-x  2 root root  12288 Apr 14 19:40 Lang
-rw-r--r--  1 root root 250564 Apr 11 09:08 LEGALNOTICES.txt
-rw-r--r--  1 root root  18416 Apr 11 09:08 LGPL21.txt
-rw-r--r--  1 root root   7639 Apr 11 09:08 LGPL30.txt
drwxr-xr-x  2 root root   4096 Apr 14 19:40 lib
drwxr-xr-x  2 root root   4096 Apr 14 19:40 Messages
drwxr-xr-x  7 root root   4096 Apr 14 19:40 mlcmd
drwxr-xr-x  3 root root   4096 Apr 14 19:40 Modules
drwxr-xr-x  2 root root   4096 Apr 11 09:58 Plugins
drwxr-xr-x  8 root root   4096 Apr 14 19:40 Samples

Have you any idea what goes wrong ?

Manny thanks

Erik

Solution

  • Erik - when using the tde:template-insert() function in your Query Console, make sure that you have your 'content' database selected (in your case this would be the SQLData) and not the SQLSchema database. Executing the template-insert() function against the SQLData database will insert the template to the SQLSchema database.

    Also, please make sure that your SQLData database has the SQLSchema database associated with it.

    We, at MarkLogic, have also just recently released a 4 hour, self-paced course on all new MarkLogic 9 features - including TDE. Please take a look at it - http://www.marklogic.com/training-courses/whats-new-marklogic-9/ - it will definitely help you to get up to speed with the latest additions to the database. (You can also get an assessment done at the end of the course).