[cfaussie] Re: CFINDEX java.lang.NullPointerException

Joel Tue, 18 Apr 2006 21:55:32 -0700

Hi,

Try…

Run a simple query and try and index it and leave out the custom1 field
if that works add custom1 field in for the same query as in point 1

I think the “uniqueFileName” is empty/NULL

hth

Joel

From: [email protected] [mailto:[email protected]] On Behalf Of Taco Fleur
Sent: Wednesday, 19 April 2006 2:31 PM
To: [email protected]
Subject: [cfaussie] Re: CFINDEX java.lang.NullPointerException

Hi Joel,

I know what you're saying, yes it could be something obvious, but I can't see the obvious if that's the case, I went over the columns one by one.

<cfquery
   name="rsResume"
   datasource="#application.datasource#">
   SELECT    R.resumeIdentity
       , R.candidateIdentity
       , R.resumeAsText
       , R.uniqueFileName
       , R.fileExtension
       , R.originalFileName
       , R.dateStamp
       , S.salutationTitle
       , P.firstName
       , P.lastName
       , CONCAT( S.salutationTitle, " ", P.firstName , " ", P.lastName ) AS fullName
   FROM    db_au_com_exclaimit.tbl_resume R
   LEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate C
   ON     R.candidateIdentity = C.candidateIdentity
   LEFT OUTER JOIN db_au_com_exclaimit.tbl_person P
   ON     C.personIdentity = P.personIdentity
   LEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation S
   ON     P.salutationIdentity = S.salutationIdentity;
  </cfquery>
  
  <cftry>
   <cfindex
    action=""
    collection="col_au_com_exclaimit_query_new"
    key="candidateIdentity"
    type="custom"
    title="fullName"
    query="rsResume"
    body="resumeAsText,fullName,originalFileName"
    custom1="uniqueFileName" />
   <cfcatch>
    <cfset request.Error.doAppendErrorMessage( "There was an error updating the collection" ) />
   </cfcatch>
  </cftry>

On 4/19/06, Joel Cass <[EMAIL PROTECTED]> wrote:

Are all fields valid? Did you make any changes to the tables/query? Null pointer is usually an undefined or "null" variable (that's my limited knowledge anyway), so maybe something in the input query is missing?

Usually if you can't find it on google it means it never happened before or the solution is so obvious that you'll be kicking yourself later.

-----Original Message-----
From: [email protected] [mailto:[email protected]]On Behalf Of Taco Fleur
Sent: Wednesday, 19 April 2006 1:37 PM
To: [email protected]
Subject: [cfaussie] CFINDEX java.lang.NullPointerException

I am getting a java.lang.NullPointerException error when updating a collection that is currently completely empty for some reason, and I cannot get it to populate again. When I run the following cfindex I get a java.lang.NullPointerException error. I've tried everything from restarting the machine, deleting the collection, renaming it, etc. Can't find any info in Google either.

Any help would be much appreciated.

An error occurred while performing an operation in the Search Engine native library.
java.lang.NullPointerException

The error occurred in D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\candidate\resume\upload\index.cfm: line 124 Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\onRequestEnd.cfm: line 40 Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\OnRequestEnd.cfm: line 1
122 : query="rsResume" 123 : body="resumeAsText" 124 : custom1="uniqueFileName"> 125 : <cfset application.information.verity.refresh = false /> 126 : <cfset request.Message.doAppendMessage( "You have successfully updated the collection" ) />

--
Taco Fleur - http://www.pacificfox.com.au
Web Design, Web development, Graphic Design and Complete Internet Solutions
an industry leader with commercial IT experience since 1994 …

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

[cfaussie] Re: CFINDEX java.lang.NullPointerException

An error occurred while performing an operation in the Search Engine native library.

Reply via email to