Topic
2 replies Latest Post - ‏2009-12-17T17:15:56Z by SystemAdmin
SystemAdmin
SystemAdmin
254 Posts
ACCEPTED ANSWER

Pinned topic Problems query item in content

‏2009-12-17T15:30:18Z |
Hi we are doing a query to a List in Content Manager 8.3 using the following code.

public Collection findListValuesCollection(DKDatastoreICM dataStoreCM, String nombre) throws Exception {
DKDDO ddo = null;
String query = "/" + nombre;
String value = null;
Collection coleccion = new ArrayList();
ListsValues valores = null;
try {
DKNVPair options[] = new DKNVPair[3];
// Sin Máximo número de resultados
options[0] = new DKNVPair(DKConstant.DK_CM_PARM_MAX_RESULTS, "0");
// Solo los Atributos
options[1] = new DKNVPair(DKConstant.DK_CM_PARM_RETRIEVE, new Integer(DKConstant.DK_CM_CONTENT_ATTRONLY));
// Fin de KNVPair
options[2] = new DKNVPair(DKConstant.DK_CM_PARM_END, null);
dkResultSetCursor cursor = dataStoreCM.execute(query, DKConstantICM.DK_CM_XQPE_QL_TYPE, options);
while ((ddo = cursor.fetchNext()) != null) {
value = ddo.getData((short)1).toString();
valores = new ListsValues();
valores.setClave(value);
valores.setValor(value);
coleccion.add(valores);
}
return coleccion;
} catch (Exception e) {
System.err.print("Inicia Error");
e.printStackTrace();
System.err.print("Finaliza Error");
request.setAttribute("mensajeError", "ERROR: " + e.getMessage());
throw new Exception("Error al consultar la Lista de Selección " + nombre, e);
}
}
But im getting the following error

com.ibm.mm.sdk.common.DKQueryException: DGL7087A: Nombre de vista de tipo de componente VA305080F08L007 desconocido.
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.PQExceptionHelperICM.<init>(PQExceptionHelperICM.java:130)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.getCompIdByName(PQueryEngineICM.java:931)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.getComponentID(PQueryEngineICM.java:991)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.CUP$XqpeParser$actions.CUP$XqpeParser$do_action(XqpeParser.java:1357)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.XqpeParser.do_action(XqpeParser.java:686)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at java_cup.runtime.lr_parser.parse(lr_parser.java:569)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.sqlString(PQueryEngineICM.java:712)
12/17/09 10:05:34:684 COT 0000003c SystemErr R at com.ibm.mm.sdk.internal.ql.PQueryEngineICM.process(PQueryEngineICM.java:641)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.mm.sdk.server.DKResultSetCursorICM.processQuery(DKResultSetCursorICM.java:281)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.mm.sdk.server.DKResultSetCursorICM.Init(DKResultSetCursorICM.java:223)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.mm.sdk.server.DKResultSetCursorICM.<init>(DKResultSetCursorICM.java:133)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:3749)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:3619)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at co.com.argos.pcc17.cm.helper.ContentManagerBaseHelper.findListValuesCollection(ContentManagerBaseHelper.java:198)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at co.com.argos.pcc17.cm.helper.ContentManagerBaseHelper.consultarLSIN(ContentManagerBaseHelper.java:2216)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at co.com.argos.pcc17.pl.ConsultarListasSeleccionIN.doPost(ConsultarListasSeleccionIN.java:89)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1583)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1523)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
12/17/09 10:05:34:685 COT 0000003c SystemErr R at co.com.daga.util.filter.SessionFilter.doFilter(SessionFilter.java:49)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:184)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:885)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:865)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3799)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:930)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:182)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
12/17/09 10:05:34:686 COT 0000003c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
12/17/09 10:05:34:687 COT 0000003c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)

Can anyone tell me what can be wrong.

Thanks for the help

Best Regards

Carlos Andres Jaramillo Abad
Updated on 2009-12-17T17:15:56Z at 2009-12-17T17:15:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    254 Posts
    ACCEPTED ANSWER

    Re: Problems query item in content

    ‏2009-12-17T16:58:39Z  in response to SystemAdmin
    Carlos,

    You have posted to the wrong forum - try the IBM Filet Content Manager forum here:

    http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1165
  • SystemAdmin
    SystemAdmin
    254 Posts
    ACCEPTED ANSWER

    Re: Problems query item in content

    ‏2009-12-17T17:15:56Z  in response to SystemAdmin
    THe post was redirected to the Filenet content forum