getting XDMP-RIDXNOTFOUND error while running the SQL query from Marklogic
<p>I recently got to work on setting up of MarkLogic server on my local Windows machine and trying the <em>SQL</em> to <em>MarkLogic</em> setup.</p>

<p>I was following the help document "<a href="https://docs.marklogic.com/guide/sql/setup#id_51442" rel="nofollow noreferrer">https://docs.marklogic.com/guide/sql/setup#id_51442</a>" and tried creating views using curl.</p>

<p>Now when I run the query <code>Select * from employees</code> it gives me the following error:</p>

<blockquote>
  <p>xdmp:sql("SELECT * from employees WHERE employees MATCH "Manager"...",
  ()) -- SQL error: sqlite3-step() failed due to error 'VIEW-INVALID:
  Illegal view specification: view specification is invalid:
  XDMP-RIDXNOTFOUND: No int range index for EmployeeID
  XDMP-RIDXNOTFOUND: No string range index for FirstName
  XDMP-RIDXNOTFOUND: No string range index for LastName
  <a href="http://marklogic.com/collation" rel="nofollow noreferrer">http://marklogic.com/collation</a>..."</p>
</blockquote>

<p>It is asking me to create the range indexes, but I have no idea how to create this. </p>

<p>Can anyone please help me on this?</p>

<p>Regards,
Sendhil</p>