Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Log file errors "Query Error occured in conversion of filter"

Highlighted
Rory Emmans
Member

Log file errors "Query Error occured in conversion of filter"

Since we upgraded to SD 4.5 SP19 we have seen these errors in our log files. Does anybody have an idea what these errors mean? They are in the log file every 8 to 15 minutes and it does not seem to happen exactly when a ticket is created. Possible issue in SQL?

Sun, 17/09/2006 19:20:39 Query Error occurred in conversion of filter - CI;Status equals 281478266224787OR281478266224775OR281478266224785OR281478266224767OR281478266224779OR281478266224769OR281478266224773OR281478266224781OR281478266224765OR281478266224771OR281478266224777OR281478266224783 with exception: java.lang.NullPointerException
Sun, 17/09/2006 19:20:39 Query Error occurred in conversion of filter - CI;Status equals 281478266224787OR281478266224775OR281478266224785OR281478266224767OR281478266224779OR281478266224769OR281478266224773OR281478266224781OR281478266224765OR281478266224771OR281478266224777OR281478266224783 with exception: java.lang.NullPointerException
Sun, 17/09/2006 19:20:39 Query Error occurred in conversion of filter - Organizations;Category not equal to 281478235750592 with exception: java.lang.NullPointerException
Sun, 17/09/2006 19:20:39 Query Error occurred in conversion of filter - CI;Status equals 281478266224787OR281478266224775OR281478266224785OR281478266224767OR281478266224779OR281478266224769OR281478266224773OR281478266224781OR281478266224765OR281478266224771OR281478266224777OR281478266224783 with exception: java.lang.NullPointerException
Sun, 17/09/2006 19:20:39 Query Error occurred in conversion of filter - To;Status equals 281478266224787OR281478266224775OR281478266224785OR281478266224767OR281478266224779OR281478266224769OR281478266224773OR281478266224781OR281478266224765OR281478266224771OR281478266224777OR281478266224783 with exception: java.lang.NullPointerException
Sun, 17/09/2006 19:20:40 Query Error occurred in conversion of filter - Created is between null To null with exception: java.lang.NullPointerException
2 REPLIES
Radoslav Krochm
Frequent Visitor

Re: Log file errors "Query Error occured in conversion of filter"

Hi Rory and all SD guys,

any news regarding to your problem, because one of our customer has the same problem:

Mon, 28/05/2007 13:17:21 Query Error occurred in conversion of filter -
System equals No with exception: java.lang.NullPointerException

Mon, 28/05/2007 13:17:21 Query Error occurred in conversion of filter - Text
starts with Hromadn? incident with exception: java.lang.NullPointerException

Server: Solaris
SD: SP19
DB: Oracle 9

BR, frodo
Rory Emmans
Member

Re: Log file errors "Query Error occured in conversion of filter"

No HP wanted us to send a copy of our DB and for security reasons we couldnt so we are stuck with the errors until we decide to upgrade our Service Packs again
//Add this to "OnDomLoad" event