"Error executing query" after 4.32 upgrade

[Former Member]

Hello all!

This is my first thread, so I hope to give up some points!

Here is the deal. I've just crystal clean upgraded my SPP to version 4.32 and had no errors during the process.

Everything is working fine, but we keep on getting an "Error executing query" in one of our webpages.

The collabconsole.log reports something like this at the time of the webpage access:

[10/10/2011 16:21:10 (TP-Processor1_58)]: anonymous: http cmd: GetContainer, TP-Processor1, object=1.11.12217

[10/10/2011 16:21:16 (TP-Processor1_58)]: anonymous: http cmd: GetContainer, TP-Processor1, object=1.11.12216

[10/10/2011 16:21:16 (TP-Processor1_58)]: Redirect to:PerformSearch?query-object=1.47.201&format=EU_SmartSearchValidator.shtml&smartFolder=1.11.12216

[10/10/2011 16:21:16 (TP-Processor1_58)]: redirecting to PerformSearch?smartFolder=1.11.12216&format=EU_SmartSearchValidator.shtml&query-object=1.47.201

[10/10/2011 16:21:16 (TP-Processor1_58)]: anonymous: http cmd: PerformSearch, TP-Processor1, object=null

com.intraspect.exceptions.IntraspectException: Error executing query

[10/10/2011 16:21:16 (TP-Processor1_58)]: at com.intraspect.globalindexer.SearchServerImpl.search(SearchServerImpl.java:116)

[10/10/2011 16:21:16 (TP-Processor1_58)]: at com.intraspect.search.globalindexer.GlobalIndexerSearchEnumeration.doQuery(GlobalIndexerSearchEnumeration.java:597)

[10/10/2011 16:21:16 (TP-Processor1_58)]: at com.intraspect.search.globalindexer.GlobalIndexerSearchEnumeration.getResults(GlobalIndexerSearchEnumeration.java:309)

[10/10/2011 16:21:16 (TP-Processor1_58)]: at com.intraspect.search.globalindexer.GlobalIndexerSearchEnumeration.doMainWork(GlobalIndexerSearchEnumeration.java:206)

Has anyone gone through something like this?

Thanks in Advance!

[Former Member]

You just forgot to send the attachment, but the support has sent it as well.

Anyway you deserve the points!

Thanks a lot, man!

[Former Member]

Hi Aylton,

Welcome to the forum.

For Solr to work with uPerform there are two custom configuration files

that are required. These files are normally copied to the correct

location during the installation by specifying a Custom Configuration

Location containing the necessary files; however, in some cases the

files are not copied over automatically.

If the files are not copied over correctly during installation search

will not function until the necessary files are copied into the

Solr configuration directory.

In order to resolve the issue, the default Solr configuration files need

to be replaced with the modified files included with the uPerform

installer.

To replace the configuration files, perform the following steps:

1. Stop the Common Apache Solr-[Instance Name] service

2. Depending on your operating system version navigate to the temporary

installation location for Solr created during uPerform installation:

Note: In order to browse to the folder location you may have to enable

Show hidden files and folders under Windows Folder Options.

Windows 2003:

C:\Documents and Settings\[Install User]\Local

Settings\Temp\Solr_Install\config

C:\Documents and Settings\[Install User]\Local

Settings\Temp\1\Solr_Install\config

C:\Documents and Settings\[Install User]\Local

Settings\Temp\2\Solr_Install\config

Windows 2008 or Windows 2008 R2:

C:\Users\[Install User]\AppData\Local\Temp\Solr_Install\config

3. Backup the current schema.xml file and solrconfig.xml

4. Extract the 2 xml from the attached file into

[Drive]\OpenText\solr\solr\conf

1. Please find zip file uploaded to this support ticket.

5. Verify schema.xml is 40KB and solrconfig.xml is 48KB

6. Start the Common Apache Solr-[Instance Name] service

7. Login to the uPerform Websiteas an administrator.

8. Click on Administration -> Server Administration -> Global Settings.

9. Click Recreate Search Database

10. Try again.

Hope this helps,

Kind Regards,

Matthew