Railo Collection for Solr/Verity Search

[hofar...@houseoffusion.com]

I have been going round and round trying to create a collection, refresh and
pull data from it..



I couldn't find much help online so I am asking you all.



When I run this code it creates the Collection but also throws an error
saying it can't find the path specified. But I see the collection when I
browse to it on the server.



<cfcollection action="create" name="LogicompPortal_BillHeaders"
collection="LogicompPortal_BillHeaders"
path="C:\home\logicomp.org\subdomains\dev\SearchCollections">



I have tried different paths above the root directory and each one places
the collection on the drive but throws that error.





Continuing on to see if I can refresh (Load the data). I run this. It also
throws the same error but runs the query pulling around 138000 records.



<!--- pull the content --->

<cfquery datasource="#App_DataSource#" name="getContent">

SELECT DISTINCT DATEOFOCCURRENCE, BILLHEADERID, INVOICEDATE,
CLIENTID, LEVEL1, PROVIDERPRACTICENAME,

employeeLastName, EmployeeFirstName

FROM _vPortal_BillHeaders

</cfquery>





<!--- update collection --->

<cflock name="cfindex_lock" type="exclusive" timeout="30">



<cfindex collection="LogicompPortal_BillHeaders"

action="refresh"

type="custom"

query="getContent"

key="BILLHEADERID"

custom1="PROVIDERPRACTICENAME"

custom2="employeeLastName"

custom3="DATEOFOCCURRENCE"

body="DATEOFOCCURRENCE, BILLHEADERID, INVOICEDATE,
CLIENTID, LEVEL1, PROVIDERPRACTICENAME,

employeeLastName, EmployeeFirstName">



</cflock>





Then I run this code to see if there is any data. returns nothing but Does
not error.



<!--- pull the data from collection --->

<cfsearch collection="LogicompPortal_BillHeaders"

name="searchResults" type="simple" startrow="1"

maxrows="200"

criteria="BillHeaderID <> ''"

>





<cfoutput>#searchResults.Recordcount#</cfoutput>





It's MSSQL Server 2012 Express and I created a view for the data.

It's a Railo server 4.1.2.005

Windows Server 2012

It's a VPS



What am I missing? I looked in the railo admin and don't see anything for
collections, Solr or Verity. I am new to this server.



Rick








~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360445

[hofar...@houseoffusion.com]

have you upgraded your jvm by any chance. on cf this causes cf tono longer
be able to see the collections. Maybe the same occurs on Railo.

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360446

[hofar...@houseoffusion.com]

Like I said I am kind of new to the server side of this...

When I look it says Railo Tomcat 7.

Rick

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360447

[hofar...@houseoffusion.com]

Have you checked your permissions, either in Explorer or IIS Manager, on the directory to the collection to make sure it has RWX permissions for both the IIS user account and the user account which runs the Lucee/Railo service?

Jon

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360448

[hofar...@houseoffusion.com]

It's a Hostek VPS server.. they loaded it...

Rick

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360449

[hofar...@houseoffusion.com]

I will check.. but it is creating the collection in the directory.. it just
throws the error.

Rick

-----Original Message-----
From: Jon Clausen [mailto:jon_c...@silowebworks.com]
Sent: Friday, April 10, 2015 10:31 AM
To: cf-talk

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360450

[hofar...@houseoffusion.com]

Worth a check.  The user accounts also need to have read permissions on all folders recursively down to the collection.  I’ve run in to a similar situation before where Windows was able to write to a directory, but certain file read commands failed because the recursive read permissions weren’t in place.

Jon

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360451

[hofar...@houseoffusion.com]

All the permissions look to be setup correctly.

Users I gave read and write to. Railo and IIS have the same.

Rick

-----Original Message-----
From: Jon Clausen [mailto:jon_c...@silowebworks.com]
Sent: Friday, April 10, 2015 10:49 AM
To: cf-talk
Subject: RE: Railo Collection for Solr/Verity Search

Worth a check.  The user accounts also need to have read permissions on all folders recursively down to the collection.  I’ve run in to a similar situation before where Windows was able to write to a directory, but certain file read commands failed because the recursive read permissions weren’t in place.

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360452