Return to Jive Software

Skip navigation
Up to Discussions in Developers
510 Views 6 Replies Last post: Oct 14, 2009 10:06 AM by jbradley RSS
jbradley Novice
jbradley
60 posts since
Mar 24, 2009
Currently Being Moderated

Oct 1, 2009 11:42 AM

ERROR impl.QueryCache - Error loading block

Hi Jive,

 

We've recently released our SBS 3.0.5 community site to production. I am trying to resolve a few recurring complaints from the production logs. I will submit separate cases.

 

Here is the first one; it is a recurring SQL complaint (it is always ObjectType 37, but the ObjectId changes). I've attached the complete stack.

 

01 Oct 2009 11:09:03,871 [http-127.0.0.1-9001-32] ERROR impl.QueryCache - Error loading block, ObjectType: 37, ObjectId: 1444
java.sql.SQLException: Incorrect syntax near ')'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:933)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:365)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)

 

Thanks in advance,

jb

Attachments:
karlcyr Jive Employee
karlcyr
9,093 posts since
Mar 12, 2008
Currently Being Moderated
Oct 1, 2009 4:55 PM in response to: jbradley
Re: ERROR impl.QueryCache - Error loading block

Hi Justin,

 

Do you have blogs disabled? I believe this is a known issue (CS-13991). It should not have any affect on your system except for spamming your logs.

 

Regards,
Karl

jgrahamthomas Novice
jgrahamthomas
22 posts since
Feb 15, 2007
Currently Being Moderated
Oct 2, 2009 1:27 PM in response to: Karl Cyr
Re: ERROR impl.QueryCache - Error loading block

Hey Karl - Blogs are enabled on our site.

karlcyr Jive Employee
karlcyr
9,093 posts since
Mar 12, 2008
Currently Being Moderated
Oct 5, 2009 8:45 AM in response to: Jeremy Thomas
Re: ERROR impl.QueryCache - Error loading block

Can you send me the entire log file with the error message? I'd like to see if I can pick up any additional context from reading the whole logs.

 

I took a closer look at the issue filed and I don't believe that having Blogs disabled is a necessary condition for reproducing the error, though it can cause the problem. Either way, I think the problem is with queries which return 0 results.

jbradley Novice
jbradley
60 posts since
Mar 24, 2009
Currently Being Moderated
Oct 5, 2009 4:42 PM in response to: Karl Cyr
Re: ERROR impl.QueryCache - Error loading block

Hi Karl,

 

Thanks for your help. The log file is attached.

 

jb

Attachments:
karlcyr Jive Employee
karlcyr
9,093 posts since
Mar 12, 2008
Currently Being Moderated
Oct 6, 2009 9:14 AM in response to: jbradley
Re: ERROR impl.QueryCache - Error loading block

Hi Justin,

 

Since this seems to come from the same location as I have logged this as a new bug: CS-16429. I do not believe this bug will cause any functional problems, but if you find otherwise please let me know.

 

Regards,

Karl

jbradley Novice
jbradley
60 posts since
Mar 24, 2009
Currently Being Moderated
Oct 14, 2009 10:06 AM in response to: Karl Cyr
Re: ERROR impl.QueryCache - Error loading block

Ok, thanks for reviewing the logs Karl. We'll keep an eye on the complaint.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Case Product Issues

Loading Jira issues

Loading related product issues for this case
To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.