SAP Knowledge Base Article - Preview

1664971 - Title Search in infoview returns no results or timesout


After migrating large repository to XI3.1, the Title search in Infoview does not return any results and CMS trace logs show the query timeout.

2011/12/06 16:49:24.454| | | 1848|5892|CInfoStoreSubsystem::Query:[UID=32233446;USID=32235100] SELECT TOP 30 EVERY 15 SI_KIND,SI_NAME,SI_ID FROM CI_INFOOBJECTS WHERE ((CHILDREN("SI_NAME='Category-Document'","SI_ID=23 OR SI_ANCESTOR=23") OR SI_ANCESTOR=23) AND ((SI_KIND IN ('Pdf','Agnostic','CrystalReport','FullClient','FullClientAddin','FullClientTemplate','Flash','Folder','Hyperlink','Excel','Powerpoint','Word','MyInfoView','ObjectPackage','Program','Publication','Rtf','Shortcut','Txt','MDAnalysis','Webi','Xcelsius') AND SI_INSTANCE=0) OR (SI_KIND IN ('ObjectPackage','FavoritesFolder','PersonalCategory','Inbox','Category','Folder') AND SI_INSTANCE=0)) AND (SI_NAME LIKE '%countryselection%')) ORDER BY SI_KIND CUSTOM('Folder', 'FavoritesFolder', 'Category', 'PersonalCategory', 'Inbox', 'ObjectPackage'),SI_NAME ASC,SI_ID ASC : (proc=false,chk=true,srv=false)
9 minutes later :

2011/12/06 16:58:24.441| | | 1848|5892|DBQueue::Read
2011/12/06 16:58:24.457| | | 1848|5892|ThrowOnThreadTimeout currTime: 11/12/06 11:58:24.457   expireTimeout: 540000
2011/12/06 16:58:24.457| | | 1848|5892|THREAD TIMEOUT! throwing exception now
2011/12/06 16:58:24.473|E|X| 1848|5892|DBQueue::Read: 0.032



  • Xi3.1 any version
  • Oracle CMS DB
  • Windows


SAP BusinessObjects Enterprise XI 3.1


title; search; infoview; results; no; timeout; category; folder , KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.