[cfaussie] Re: CFINDEX java.lang.NullPointerException

Tue, 18 Apr 2006 21:45:37 -0700

Hmm.. Doesn't seem obvious. I haven't had any issues with verity since MX so I'm a bit in the dark here
 
Perhaps, see if other collections can be indexed, if so create a new, differently named index and run the process on that index. If that fails, there might be something in the data that is upsetting verity. You could go through a process of elimination.
 
Otherwise, if none of the collections can be indexed, check configuration or reinstall server? Someone out there must know what's going on.. Perhaps try the macromedia forums...
 
That's about all I can offer.. back to work
Joel
-----Original Message-----
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>
  <!--- update database collection --->
  <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.

<cfindex
     action=""
     collection="col_au_com_exclaimit_query"
     key="candidateIdentity"
     type="custom"
     title="fullName"
     query="rsResume"
     body="resumeAsText"
     custom1="uniqueFileName">
 

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 …





--
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to