FullTextSearch giving an exception com.bea.content.RepositoryException:

657795

Hi all,
I'm trying to search a repository with libraries enabled using Full text search.
the code is

queryExpression= this.mQuery.buildContains(IMetadataQuery.SystemProperty.cm_objectClass,new String[]{"Article"});
IFullTextSearch expression = FullTextSearchFactory.buildFullTextSearch(queryExpression, null, true);
Search search = new Search(path, 10000, sort, expression,true);
ISortableFilterablePagedList<Node> results = searchManager.search(context, search);

and when the search is perfomed with searchManager.search it throws me the following Exception:

com.bea.content.RepositoryException: The Type is not specified in the query, so sorting on user-defined properties cannot be performed.
at com.bea.content.repo.internal.server.logic.search.AutonomyExpression.setSortParameters(AutonomyExpression.java:451)
at com.bea.content.repo.internal.server.logic.search.AutonomyClient46.executeQuery(AutonomyClient46.java:88)
at com.bea.content.repo.internal.server.logic.SearchOpsLogic.fullTextSearch(SearchOpsLogic.java:195)
at com.bea.content.repo.internal.server.logic.SearchOpsLogic.search(SearchOpsLogic.java:146)
at com.bea.content.repo.internal.server.bean.SearchOpsBean.search(SearchOpsBean.java:76)
at com.bea.content.repo.internal.server.bean.RepoSearchOps_xxpfs2_ELOImpl.search(RepoSearchOps_xxpfs2_ELOImpl.java:220)
at com.bea.content.spi.internal.SearchOpsImpl.search(SearchOpsImpl.java:89)
at sun.reflect.GeneratedMethodAccessor677.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.bea.content.manager.internal.delegate.LatestInterfaceVersionWrapper.invoke(LatestInterfaceVersionWrapper.java:57)
at $Proxy64.search(Unknown Source)
at com.bea.content.manager.internal.delegate.LatestSearchOpsDelegate.search(LatestSearchOpsDelegate.java:47)
at com.bea.content.manager.internal.SearchOpsImpl.searchRepository(SearchOpsImpl.java:231)
at com.bea.content.manager.internal.SearchOpsImpl.search(SearchOpsImpl.java:167)
at com.bea.content.federated.internal.itemloader.NodeSearchItemLoader.fetchItemIdentifiers(NodeSearchItemLoader.java:74)
at com.bea.content.paging.internal.OnDemandQueryProcessorImpl.initializeItemIdsIfNeeded(OnDemandQueryProcessorImpl.java:90)
at com.bea.content.paging.internal.OnDemandQueryProcessorImpl.fetchItems(OnDemandQueryProcessorImpl.java:330)
at com.bea.content.paging.internal.DirectAccessQueryProcessor.fetchItems(DirectAccessQueryProcessor.java:111)
at com.bea.content.paging.internal.ItemLoadingAdapter.fetchItemsImpl(ItemLoadingAdapter.java:237)
at com.bea.content.paging.internal.ItemLoadingAdapter.fetchItems(ItemLoadingAdapter.java:126)
at com.bea.content.paging.internal.ItemLoadingAdapter.initialize(ItemLoadingAdapter.java:97)
at com.bea.content.paging.internal.PagedListImpl.<init>(PagedListImpl.java:100)
at com.bea.content.federated.internal.SearchManagerImpl.search(SearchManagerImpl.java:60)


Any ideas????

Any help is very appreciated.

Regards, Armando

648793

Search search = new Search(path, 10000, sort, expression,true);

What is sort in this? this could either be string or SortCriteria object, or null. I think your query is failing here.

Hope it helps

657795

The sort parameter is a SortCriteria object that is:
SortCriteria NODE_NAME_ASC = new SortCriteria("name",true);

any clues?

648793

Did you define the name property as an explicit property? It should also be mapped to cm_node table in the database. Did you do that? Try running the same query in the jsp with cm:search tag.