3 Replies Latest reply on Jun 24, 2014 1:43 PM by t.g.webfirst

    Sandbox security denying CFINDEX from indexing a collection (Solr/CF9)

    WolfShade Level 4

      Hello, everyone.

       

      I did fix the last Sandbox security related issue with Solr collections - it was in the "Files/Dir" section, I had to put everything under C:\ColdFusion9\wwwroot.

       

      Now, I'm facing yet another Sandbox related issue with collections.

       

      I have one reindex script that has NO ISSUES when pulling data from a database and indexing a collection from that.

       

      I have another reindex script that will not index a collection from a query, unless Sandbox is disabled.  I will try to give some pseudo code.

       

      <cfquery name="search_results" datasource="documents">
        SELECT DOC_ID, DOC_NAME, DOC_DESCRIPTION
        FROM DOC
        WHERE DOC_ID in (<cfqueryparam value="#thisList#" cfsqltype="CF_SQL_VARCHAR" list="yes">)
      </cfquery>
      
      <cftry>
        <cfindex action="refresh" collection="collection_name" key="DOC_DESCRIPTION" type="custom" title="DOC_DESCRIPTION" query="search_results" body="DOC_ID, DOC_NAME, DOC_DESCRIPTION" status="results" />
        <cfcatch><cfdump var="#cfcatch#"></cfcatch>
      </cftry>
      

      The query will retrieve 15 records, with or without Sandbox.  But the CFINDEX will not work if Sandbox is enabled.

       

      The other reindex script is not affected, either way.

       

      What could be causing the CFINDEX to fail?

       

      Thank you,

       

      ^_^