SearchService Error loading SingleSearchResponse.Results

I'm copying Francisco Gonzalezo's post from here:

https://knowledge.opentext.com/knowledge/llisapi.dll/open/16183975

I'm finding quite a similar problem when using a differente service: SearchService. After executing a call, similar to this:

SingleSearchRequest queries = new SingleSearchRequest();
//populate request
queries.setQueryLanguage("Livelink Search API V1");
queries.setDataCollectionSpec("\"LES S.I.P.\"");
queries.setFirstResultToRetrieve(1);
queries.setNumResultsToRetrieve(10);
queries.setResultSetSpec("where1=blabla");
//call
SingleSearchResponse response = searchService.search(queries, "");

I receive the following error code:

Exception in thread "main" javax.xml.ws.soap.SOAPFaultException: Error loading SingleSearchResponse.Results

Which seems pretty similar. Any idea about how to resolve it?

Find more posts tagged with

Comments

sgrasley

Can you provide the relevant messages from les-services.log and the LES thread logs?

Scott

modus_ponens

On les-services.log, the following lines are printed each time the service is called:

2009-04-20 13:44:09,234 ERROR [http-8080-Processor25] Error loading SNode.I
2009-04-20 13:44:09,328 ERROR [http-8080-Processor25] Error loading SGraph.N
2009-04-20 13:44:09,328 ERROR [http-8080-Processor25] Error loading SResultPage.Item
2009-04-20 13:44:09,328 ERROR [http-8080-Processor25] Error loading SingleSearchResponse.Results

sgrasley

Hi, Francisco.

Can you post information from the LES thread logs as well?

thanks,

Scott

sgrasley

Hi, Francisco.

Do you get any results if you execute the query in a browser?

?func=search&where1=blabla&slice=S.I.P.&outputformat=xml

Scott

modus_ponens

Hi Scott,

The URL returns a XML document with three results from the search (three <SearchResult> tags).

Where should I find the LES thread logs? I am working with a Tomcat server. Apart from les-services.log, observing Tomcat 'logs' folder, the only log files which are modified after calling the service are stdout_<date>.log, printing the aforementioned lines, and catalina_<date>.log, printing:

Apr 20, 2009 4:01:20 PM com.sun.xml.ws.server.sei.EndpointMethodHandler invoke
SEVERE: Error loading SingleSearchResponse.Results
javax.xml.ws.soap.SOAPFaultException: Error loading SingleSearchResponse.Results
    at com.opentext.livelink.service.core.ExceptionUtil.throwSOAPFaultException(ExceptionUtil.java:138)
    at com.opentext.livelink.service.searchservices.SearchService_JAXWS.search(SearchService_JAXWS.java:58)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246)
    at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
    at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
    at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
    at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:595)
    at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
    at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
    at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
    at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
    at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
    at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
    at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
    at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
    at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
    at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:75)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Unknown Source)

Thanks for your interest.

sgrasley

Hi, Francisco.

Could you post the XML file that is produced? I believe I'm looking at a related issue at the moment, and that file will help to determine if it is indeed related.

Also, do other queries work OK? (I probably should have asked that sooner. )

The LES thread logs are located in the 'logs' folder of the Livelink installation (e.g. C:\OPENTEXT\logs).

thanks,

Scott

modus_ponens

Hi Scott,

I have been monitoring OPENTEXT/logs folder, and it seems to me that traces of the web service call are printed in connect4.log. It is a great length of traces, but I cannot distinguish the important from the unimportant ones, sorry about that. I copy them at the end of this message.

Regarding the searches, I copy the generated XML at the end of this paragraph. Other queries (replacing 'blabla' with other strings) work always normally when executing them through URL, and return the 'Error loading ...' fault when they are executed through web service (excepting when the search does not return any result: then no exception is reported).

<?xml version="1.0" encoding="ISO-8859-1"?>
<Output>
<SearchResults>
<SearchResult>
<OTCreatedBy DisplayName="Creado por">
<![CDATA[1000]]>
</OTCreatedBy>
<OTLocation DisplayName="Ubicación" Protocol="http" ServerName="172.24.16.169" URL="/Livelink/livelink.exe?func=ll&objId=894194&objAction=browse">
2000 894194 897409
</OTLocation>
<OTMIMEType DisplayName="MIMEType" Protocol="http" ServerName="172.24.16.169" IconURL="/img/webdoc/apppdf.gif">
application/pdf
</OTMIMEType>
<OTName DisplayName="Nombre" Protocol="http" ServerName="172.24.16.169" ViewURL="/Livelink/livelink.exe?func=ll&objId=897409&objAction=Open&vernum=2&nexturl=%2FLivelink%2Flivelink%2Eexe%2Ffetch%2F2000%2Fpagina_inicial%2Ehtml%3Ffunc%3Dsearch%26where1%3Dblabla%26slice%3DS%2EI%2EP%2E%26outputformat%3Dxml" DownloadURL="/Livelink/livelink.exe?func=ll&objID=897409&objAction=download">
blabla
</OTName>
<OTObjectDate DisplayName="Fecha" Mask="YYYY-MM-DD">
2009-04-03
</OTObjectDate>
<OTObjectSize DisplayName="Tamaño" Suffix="KB">
161
</OTObjectSize>
<Functions Protocol="http" ServerName="172.24.16.169" ServerPort="80" URL="/Livelink/livelink.exe?func=SearchResultsFunctionMenu&hitID=1&searchCacheID=1868088687&version=2&dataID=897409&HH=false&subtype=264"/>
<FindSimilar Protocol="http" ServerName="172.24.16.169" ServerPort="80" URL="/Livelink/livelink.exe?func=OTCIndex.FindSimilarURL&DataID=897409&VolumeID=0&VersionNum=2&CacheID=1868088687&HitID=1" nextURL="/Livelink/livelink.exe?func=srch.SearchCache&cacheId=1868088687"/>
</SearchResult>
<SearchResult>
<OTCreatedBy DisplayName="Creado por">
<![CDATA[1000]]>
</OTCreatedBy>
<OTLocation DisplayName="Ubicación" Protocol="http" ServerName="172.24.16.169" URL="/Livelink/livelink.exe?func=ll&objId=894194&objAction=browse">
2000 894194 898890
</OTLocation>
<OTMIMEType DisplayName="MIMEType" Protocol="http" ServerName="172.24.16.169" IconURL="/img/webdoc/doc.gif">
application/pdf
</OTMIMEType>
<OTName DisplayName="Nombre" Protocol="http" ServerName="172.24.16.169" ViewURL="/Livelink/livelink.exe?func=ll&objid=898890&objaction=open&nexturl=%2FLivelink%2Flivelink%2Eexe%2Ffetch%2F2000%2Fpagina_inicial%2Ehtml%3Ffunc%3Dsearch%26where1%3Dblabla%26slice%3DS%2EI%2EP%2E%26outputformat%3Dxml" DownloadURL="/Livelink/livelink.exe?func=ll&objID=898890&objAction=download">
blabla Generación
</OTName>
<OTObjectDate DisplayName="Fecha" Mask="YYYY-MM-DD">
2009-04-03
</OTObjectDate>
<OTObjectSize DisplayName="Tamaño" Suffix="">

</OTObjectSize>
<Functions Protocol="http" ServerName="172.24.16.169" ServerPort="80" URL="/Livelink/livelink.exe?func=SearchResultsFunctionMenu&hitID=2&searchCacheID=1868088687&version=2&dataID=898890&HH=false&subtype=264"/>
<FindSimilar Protocol="http" ServerName="172.24.16.169" ServerPort="80" URL="/Livelink/livelink.exe?func=OTCIndex.FindSimilarURL&DataID=898890&VolumeID=0&VersionNum=2&CacheID=1868088687&HitID=2" nextURL="/Livelink/livelink.exe?func=srch.SearchCache&cacheId=1868088687"/>
</SearchResult>
<SearchResult>
<OTCreatedBy DisplayName="Creado por">
<![CDATA[1000]]>
</OTCreatedBy>
<OTLocation DisplayName="Ubicación" Protocol="http" ServerName="172.24.16.169" URL="/Livelink/livelink.exe?func=ll&objId=894194&objAction=browse">
2000 894194 898596
</OTLocation>
<OTMIMEType DisplayName="MIMEType" Protocol="http" ServerName="172.24.16.169" IconURL="/img/webdoc/doc.gif">

</OTMIMEType>
<OTName DisplayName="Nombre" Protocol="http" ServerName="172.24.16.169" ViewURL="/Livelink/livelink.exe?func=ll&objid=898596&objaction=open&nexturl=%2FLivelink%2Flivelink%2Eexe%2Ffetch%2F2000%2Fpagina_inicial%2Ehtml%3Ffunc%3Dsearch%26where1%3Dblabla%26slice%3DS%2EI%2EP%2E%26outputformat%3Dxml" DownloadURL="/Livelink/livelink.exe?func=ll&objID=898596&objAction=download">
blabla Método abreviado (shortcut)
</OTName>
<OTObjectDate DisplayName="Fecha" Mask="YYYY-MM-DD">
2009-04-03
</OTObjectDate>
<OTObjectSize DisplayName="Tamaño" Suffix="">

</OTObjectSize>
<Functions Protocol="http" ServerName="172.24.16.169" ServerPort="80" URL="/Livelink/livelink.exe?func=SearchResultsFunctionMenu&hitID=3&searchCacheID=1868088687&version=0&dataID=898596&HH=false&subtype=264"/>
</SearchResult>
</SearchResults>

<SearchResultsInformation>
<CurrentStartAt>0</CurrentStartAt>
<NumberResultsThisPage>3</NumberResultsThisPage>
<RawTotalResults>3</RawTotalResults>
<EstTotalResults>3</EstTotalResults>
<TotalResults>3</TotalResults>
<PreviousQuery>
<Parameter Name="where1"><![CDATA[blabla]]></Parameter>
<Parameter Name="slice"><![CDATA[S.I.P.]]></Parameter>
<Parameter Name="outputformat"><![CDATA[xml]]></Parameter>
</PreviousQuery>
</SearchResultsInformation>


<Themes>

<Theme ObjName="Authors" DisplayName="Autores comunes">
<Author>
<UserName DisplayName="Autor" Protocol="http" ServerName="172.24.16.169" URL="?func=user.userdialog&userID=1000"><![CDATA[Admin]]></UserName>
<Rating DisplayName="Valoración" Protocol="http" ServerName="172.24.16.169" IconURL="/img/themes/rating5.gif">5</Rating>
</Author>
</Theme>


<Theme ObjName="Dates" DisplayName="Fechas comunes">
<Date>
<DateRange DisplayName="Fecha"><![CDATA[Mes pasado]]></DateRange>
<Rating DisplayName="Valoración" Protocol="http" ServerName="172.24.16.169" IconURL="/img/themes/rating5.gif">5</Rating>
</Date>
</Theme>


<Theme ObjName="Location" DisplayName="Ubicaciones comunes">
<Location>
<LocationList DisplayName="Ubicación">
<LocationEntry DisplayName="Sistema de Información Patrimonial" Protocol="http" ServerName="172.24.16.169" URL="/Livelink/livelink.exe?func=ll&objId=2000&objAction=browse"/>
<LocationEntry DisplayName="Prueba Javier" Protocol="http" ServerName="172.24.16.169" URL="/Livelink/livelink.exe?func=ll&objId=894194&objAction=browse"/>
</LocationList>
<Rating DisplayName="Valoración" Protocol="http" ServerName="172.24.16.169" IconURL="/img/themes/rating5.gif">5</Rating>
</Location>
</Theme>


<Theme ObjName="ThemesComponent" DisplayName="Temas comunes">
<Topic DisplayName="Tema"><![CDATA[checkin event, checkinwithlifecycle...]]></Topic>
</Theme>

</Themes>

</Output>

------------------------------------------------

04/20/2009 17:04:00 [3618958577] 0003559280: CAPI.Log: Arguments = 'A<1,?,''partitionName''='''',''queries''=A<1,?,''DataCollectionSpec''=''"S.I.P."'',''FirstResultToRetrieve''=1,''NumResultsToRetrieve''=10,''QueryLanguage''=''Livelink Search API V1'',''ResultOrderSpec''=?,''ResultSetSpec''=''where1=blabla'',''_SDOName''=''SearchServices.SingleSearchRequest''>>'
04/20/2009 17:04:00 [3618958639] 0003559281: CAPI.Log: ServiceMethod = 'Search'
04/20/2009 17:04:00 [3618958711] 0003559282: CAPI.Log: ServiceName = 'SearchService'
04/20/2009 17:04:00 [3618958763] 0003559283: CAPI.Log: _ApiName = 'InvokeService'
04/20/2009 17:04:00 [3618958814] 0003559284: CAPI.Log: _ClientVersion = '9.7.1'
04/20/2009 17:04:00 [3618958869] 0003559285: CAPI.Log: _ConnectionName = ''
04/20/2009 17:04:00 [3618958924] 0003559286: CAPI.Log: _Cookie = 'd2LHVHCPx2%2BeYzBdJ4%2FP52oMjVhizkg1YddBJB%2F94GU%3D'
04/20/2009 17:04:00 [3618958974] 0003559287: CAPI.Log: _DomainName = ''
04/20/2009 17:04:00 [3618959024] 0003559288: CAPI.Log: _ImpersonateUserDomain = ''
04/20/2009 17:04:00 [3618959121] 0003559289: CAPI.Log: _LLENVIRON_ASSOC = 'A<1,?,''REMOTE_ADDR''=''172.24.22.223''>'
04/20/2009 17:04:00 [3618959173] 0003559290: CAPI.Log: _Request = 'llweb'
04/20/2009 17:04:00 [3618959223] 0003559291: CAPI.Log: _UserName = ''
04/20/2009 17:04:00 [3618959263] 0003559292: CAPI.Log: _UserPassword = 'XXXXXXXXXX'
04/20/2009 17:04:00 [3618970870] 0003559293: ****** CAPIAllocConnect called ...
04/20/2009 17:04:00 [3618970938] 0003559294: KConnect::AllocConnect() .. reusing existing connection.
04/20/2009 17:04:00 [3618971024] 0003559295: ****** CAPIExec called ...
04/20/2009 17:04:00 [3618971131] 0003559296: KSqlCursor::Open(201f,'select OwnerID, SpaceID, Name, UserPWD, PWDExpireDate, PWDExpireMode from KUAF where ID = :A1') -->'SUCCESS'
04/20/2009 17:04:00 [3618971157] 0003559297: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3618971176] 0003559298: KSqlCursor::Bind(1,{1000}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618972392] 0003559299: KSqlCursor::Execute({'OWNERID','SPACEID','NAME','USERPWD','PWDEXPIREDATE','PWDEXPIREMODE'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618972451] 0003559300: KSqlCursor::Fetch({1000,0,'Admin','xxxxxx',?,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618972495] 0003559301: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3618972523] 0003559302: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3618973285] 0003559303: ****** CAPIAllocConnect called ...
04/20/2009 17:04:00 [3618973301] 0003559304: KConnect::AllocConnect() .. reusing existing connection.
04/20/2009 17:04:00 [3618973391] 0003559305: ****** CAPIAllocLogin called ...
04/20/2009 17:04:00 [3618973617] 0003559306: KSqlCursor::Open(2000,'select a.*,b.OwnerID GroupOwnerID,b.Type GroupType,b.Name GroupName,b.UserData GroupUserData from KUAF a,KUAF b where a.Type=:A1 and a.SpaceID=:A2 and a.Name=:A3 and a.GroupID=b.ID') -->'SUCCESS'
04/20/2009 17:04:00 [3618973636] 0003559307: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3618973657] 0003559308: KSqlCursor::Bind(3,{0,0,'Admin'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618974273] 0003559309: KSqlCursor::Execute({'ID','OWNERID','TYPE','SPACEID','NAME','USERDATA','LEADERID','DELETED','USERPWD','GROUPID','USERPRIVILEGES','LASTNAME','MIDDLENAME','FIRSTNAME','MAILADDRESS','CONTACT','TITLE','PWDEXPIREDATE','PWDEXPIREMODE','SETTINGSNUM','FAX','OFFICELOCATION','TIMEZONE','PHOTOID','GENDER','BIRTHDAY','PERSONALEMAIL','HOMEADDRESS1','HOMEADDRESS2','HOMEPHONE','HOMEFAX','CELLULARPHONE','PAGER','HOMEPAGE','FAVORITES1','FAVORITES2','FAVORITES3','INTERESTS','GROUPOWNERID','GROUPTYPE','GROUPNAME','GROUPUSERDATA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618974443] 0003559310: KSqlCursor::Fetch({1000,1000,0,0,'Admin',?,?,0,'xxxxxx',1001,16777215,?,?,?,'sip@livelink.es',?,?,?,?,16,?,?,-1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,1000,1,'SIP-USUARIOS',?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618974537] 0003559311: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3618974578] 0003559312: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3618974607] 0003559313: KUAFUser::Get(Admin) --> 'SUCCESS'
04/20/2009 17:04:00 [3618974851] 0003559314: KSqlCursor::Open(2000,'select * from KState where StateID=:A1') -->'SUCCESS'
04/20/2009 17:04:00 [3618974870] 0003559315: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3618974884] 0003559316: KSqlCursor::Bind(1,{2}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975168] 0003559317: KSqlCursor::Execute({'STATEID','STATENUM','STATEUSERNUM'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975214] 0003559318: KSqlCursor::Fetch({2,46542,0}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975245] 0003559319: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3618975269] 0003559320: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:00 [3618975312] 0003559321: KSqlCursor::Open(2000,'select * from KState where StateID=:A1') -->'SUCCESS'
04/20/2009 17:04:00 [3618975329] 0003559322: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3618975347] 0003559323: KSqlCursor::Bind(1,{1}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975744] 0003559324: KSqlCursor::Execute({'STATEID','STATENUM','STATEUSERNUM'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975782] 0003559325: KSqlCursor::Fetch({1,17,0}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618975817] 0003559326: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3618975838] 0003559327: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:00 [3618975881] 0003559328: KSqlCursor::Open(2000,'select * from KState where StateID=:A1') -->'SUCCESS'
04/20/2009 17:04:00 [3618975898] 0003559329: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3618975912] 0003559330: KSqlCursor::Bind(1,{1000}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618976201] 0003559331: KSqlCursor::Execute({'STATEID','STATENUM','STATEUSERNUM'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618976236] 0003559332: KSqlCursor::Fetch({1000,17,59}) --> 'SUCCESS'
04/20/2009 17:04:00 [3618976267] 0003559333: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3618976287] 0003559334: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:00 [3618976317] 0003559335: KLogin::Login(Admin) --> 'SUCCESS'
04/20/2009 17:04:00 [3618976334] 0003559336: KLogin::AllocLogin() .. reusing existing login.
04/20/2009 17:04:00 [3618976505] 0003559337: ****** CAPIUserInfo called ...
04/20/2009 17:04:00 [3618976763] 0003559338: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3618976952] 0003559339: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3618977257] 0003559340: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3618977314] 0003559341: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3618977405] 0003559342: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3618977434] 0003559343: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619278456] 0003559344: ****** CAPIUserInfo called ...
04/20/2009 17:04:00 [3619278810] 0003559345: ****** UAPIGetUserByID called ...
04/20/2009 17:04:00 [3619281173] 0003559346: KSqlCursor::Open(2000,'select a.*,b.OwnerID GroupOwnerID,b.Type GroupType,b.Name GroupName,b.UserData GroupUserData from KUAF a,KUAF b where a.ID=:A1 and a.GroupID=b.ID') -->'SUCCESS'
04/20/2009 17:04:00 [3619281236] 0003559347: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619281256] 0003559348: KSqlCursor::Bind(1,{1000}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619282112] 0003559349: KSqlCursor::Execute({'ID','OWNERID','TYPE','SPACEID','NAME','USERDATA','LEADERID','DELETED','USERPWD','GROUPID','USERPRIVILEGES','LASTNAME','MIDDLENAME','FIRSTNAME','MAILADDRESS','CONTACT','TITLE','PWDEXPIREDATE','PWDEXPIREMODE','SETTINGSNUM','FAX','OFFICELOCATION','TIMEZONE','PHOTOID','GENDER','BIRTHDAY','PERSONALEMAIL','HOMEADDRESS1','HOMEADDRESS2','HOMEPHONE','HOMEFAX','CELLULARPHONE','PAGER','HOMEPAGE','FAVORITES1','FAVORITES2','FAVORITES3','INTERESTS','GROUPOWNERID','GROUPTYPE','GROUPNAME','GROUPUSERDATA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619282280] 0003559350: KSqlCursor::Fetch({1000,1000,0,0,'Admin',?,?,0,'xxxxxx',1001,16777215,?,?,?,'sip@livelink.es',?,?,?,?,16,?,?,-1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,1000,1,'SIP-USUARIOS',?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619282465] 0003559351: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619282513] 0003559352: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 3]
04/20/2009 17:04:00 [3619282574] 0003559353: KUAFUser::GetByID(1000) --> 'SUCCESS'
04/20/2009 17:04:00 [3619282929] 0003559354: ****** CAPIIniGet called ...
04/20/2009 17:04:00 [3619283262] 0003559355: ****** DAPIAllocNode called ...
04/20/2009 17:04:00 [3619283293] 0003559356: ****** DAPIGetNodeByID called ...
04/20/2009 17:04:00 [3619283535] 0003559357: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:00 [3619283555] 0003559358: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619283570] 0003559359: KSqlCursor::Bind(1,{2009}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619284116] 0003559360: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619284297] 0003559361: KSqlCursor::Fetch({-2001,2001,2009,'Plantillas de bsqueda personales',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,268,1000,D/2008/9/25:13:31:29,D/2008/12/23:23:38:22,-1,0,?,0,?,?,?,?,?,?,?,?,5,?,?,?,?,?,?,?,?,?,?,?,0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619284735] 0003559362: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619284794] 0003559363: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619284815] 0003559364: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,2001,2009,'Plantillas de bsqueda personales',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,268,1000,D/2008/9/25:13:31:29,D/2008/12/23:23:38:22,-1,0,?,0,?,?,?,?,?,?,?,?,5,?,?,?,?,?,?,?,?,?,?,?,0,0,?>}) before
04/20/2009 17:04:00 [3619285194] 0003559365: ****** CAPIIniGet called ...
04/20/2009 17:04:00 [3619285352] 0003559366: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:00 [3619285373] 0003559367: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:00 [3619285398] 0003559368: KSTree::GetByID(0,2009) --> 'SUCCESS',TRUE,TRUE
04/20/2009 17:04:00 [3619285473] 0003559369: ****** DAPIAllocNode called ...
04/20/2009 17:04:00 [3619285491] 0003559370: ****** DAPIGetNode called ...
04/20/2009 17:04:00 [3619285674] 0003559371: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:00 [3619285707] 0003559372: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619285722] 0003559373: KSqlCursor::Bind(1,{2009}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619286181] 0003559374: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619286360] 0003559375: KSqlCursor::Fetch({-2001,2001,2009,'Plantillas de bsqueda personales',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,268,1000,D/2008/9/25:13:31:29,D/2008/12/23:23:38:22,-1,0,?,0,?,?,?,?,?,?,?,?,5,?,?,?,?,?,?,?,?,?,?,?,0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619286745] 0003559376: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619286799] 0003559377: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619288045] 0003559378: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where ParentID=:A and Name=:B') -->'SUCCESS'
04/20/2009 17:04:00 [3619288069] 0003559379: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619288093] 0003559380: KSqlCursor::Bind(2,{2009,'Admin'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619288943] 0003559381: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619289125] 0003559382: KSqlCursor::Fetch({-2001,2009,4751,'Admin',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,268,1000,D/2008/9/25:13:53:15,D/2008/10/22:1:44:27,-1,0,?,0,'Carpeta de plantilla de bsqueda personal del usuario (Admin)',?,?,?,?,?,?,?,2,?,?,?,?,?,?,?,?,?,?,?,0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619289502] 0003559383: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619289567] 0003559384: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 2]
04/20/2009 17:04:00 [3619289589] 0003559385: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,2009,4751,'Admin',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,268,1000,D/2008/9/25:13:53:15,D/2008/10/22:1:44:27,-1,0,?,0,'Carpeta de plantilla de bsqueda personal del usuario (Admin)',?,?,?,?,?,?,?,2,?,?,?,?,?,?,?,?,?,?,?,0,0,?>}) before
04/20/2009 17:04:00 [3619289955] 0003559386: ****** CAPIIniGet called ...
04/20/2009 17:04:00 [3619290353] 0003559387: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:00 [3619290378] 0003559388: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:00 [3619290399] 0003559389: KSTree::Get(-2001,2009,Admin) --> 'SUCCESS',TRUE,TRUE
04/20/2009 17:04:00 [3619290610] 0003559390: ****** UAPIPrefsGet called ...
04/20/2009 17:04:00 [3619293239] 0003559391: KSqlCursor::Open(2000,'select PrefsValue from KUAFPrefs where PrefsID=:A1 and PrefsKeyword=:A2') -->'SUCCESS'
04/20/2009 17:04:00 [3619293266] 0003559392: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619293283] 0003559393: KSqlCursor::Bind(2,{1000,'DefaultTemplateID'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619293688] 0003559394: KSqlCursor::Execute({'PREFSVALUE'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619294142] 0003559395: KSqlCursor::Fetch({'A<1,?,\'nodeID\'=4752>'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619294401] 0003559396: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619294431] 0003559397: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619294654] 0003559398: ****** DAPIAllocNode called ...
04/20/2009 17:04:00 [3619294679] 0003559399: ****** DAPIGetNodeByID called ...
04/20/2009 17:04:00 [3619294987] 0003559400: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:00 [3619295010] 0003559401: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619295030] 0003559402: KSqlCursor::Bind(1,{4752}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619295459] 0003559403: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619296168] 0003559404: KSqlCursor::Fetch({-2001,4751,4752,'Admin - Por defecto',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,292,1000,D/2008/9/25:13:53:16,D/2008/12/11:18:0:43,-1,0,?,4,?,?,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'defaultTemplate\'=true,\'sequenceNum\'=4>',0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619296508] 0003559405: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619296572] 0003559406: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619296593] 0003559407: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,4751,4752,'Admin - Por defecto',0,0,1000,1001,16777215,128,36999,16777215,4,?,?,0,292,1000,D/2008/9/25:13:53:16,D/2008/12/11:18:0:43,-1,0,?,4,?,?,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'defaultTemplate\'=true,\'sequenceNum\'=4>',0,0,?>}) before
04/20/2009 17:04:00 [3619296964] 0003559408: ****** CAPIIniGet called ...
04/20/2009 17:04:00 [3619297106] 0003559409: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:00 [3619297126] 0003559410: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:00 [3619297145] 0003559411: KSTree::GetByID(0,4752) --> 'SUCCESS',TRUE,TRUE
04/20/2009 17:04:00 [3619329338] 0003559412: ****** DAPIAllocVersion called ...
04/20/2009 17:04:00 [3619329374] 0003559413: ****** DAPIGetVersion called ...
04/20/2009 17:04:00 [3619329584] 0003559414: KSqlCursor::Open(2000,'select VERSIONID,DOCID,VERSION,VERSIONNAME,OWNER,VERCDATE,VERMDATE,PLATFORM,FILENAME,DATASIZE,FILETYPE,FILECREATOR,FILECDATE,FILEMDATE,ICON,PROVIDERID,VERCOMMENT,LOCKED,LOCKEDBY,LOCKEDDATE,INDEXED,FINDERFLAGS,MIMETYPE,VERTYPE,VERMAJOR,VERMINOR,RESSIZE from DVersData where DocID=:AN and Version=:BN and VerType is NULL') -->'SUCCESS'
04/20/2009 17:04:00 [3619329604] 0003559415: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619329638] 0003559416: KSqlCursor::Bind(2,{4752,4}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619330268] 0003559417: KSqlCursor::Execute({'VERSIONID','DOCID','VERSION','VERSIONNAME','OWNER','VERCDATE','VERMDATE','PLATFORM','FILENAME','DATASIZE','FILETYPE','FILECREATOR','FILECDATE','FILEMDATE','ICON','PROVIDERID','VERCOMMENT','LOCKED','LOCKEDBY','LOCKEDDATE','INDEXED','FINDERFLAGS','MIMETYPE','VERTYPE','VERMAJOR','VERMINOR','RESSIZE'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619330387] 0003559418: KSqlCursor::Fetch({756807,4752,4,'4',1000,D/2008/12/11:18:0:42,D/2008/12/11:18:0:42,0,'Admin - Por defecto',L1495,?,?,?,?,?,756806,?,0,?,?,0,?,?,?,0,4,?}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619330483] 0003559419: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619330523] 0003559420: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619330571] 0003559421: ****** DAPIFetchVersionAsVal called ...
04/20/2009 17:04:00 [3619330592] 0003559422: KConnect::StartTransaction --> DiffLast[sec: 68 msec: 522]
04/20/2009 17:04:00 [3619330610] 0003559423: KSql::StartTransaction() --> 0,'SUCCESS'
04/20/2009 17:04:00 [3619330640] 0003559424: KSession::ExecuteCallback(0,3,1B7F8160,{'Admin - Por defecto','4','Admin - Por defecto',L1495,L1}) before
04/20/2009 17:04:00 [3619330750] 0003559425: KSession::ExecuteCallback(0,3,0) after
04/20/2009 17:04:00 [3619331529] 0003559426: KSqlCursor::Open(2000,'select * from ProviderData where providerID=:A1') -->'SUCCESS'
04/20/2009 17:04:00 [3619331550] 0003559427: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:00 [3619331566] 0003559428: KSqlCursor::Bind(1,{756806}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619331949] 0003559429: KSqlCursor::Execute({'PROVIDERID','REFCNT','PROVIDERTYPE','PROVIDERDATA'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619332339] 0003559430: KSqlCursor::Fetch({756806,1,'Default','A<1,?,\'providerInfo\'=\'0000\\\\756\\\\756806.dat\',\'storageProviderName\'=\'ExtShared\',\'subProviderName\'=\'Default\'>'}) --> 'SUCCESS'
04/20/2009 17:04:00 [3619332664] 0003559431: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:00 [3619332695] 0003559432: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:00 [3619332909] 0003559433: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:00 [3619333128] 0003559434: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619333307] 0003559435: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619333614] 0003559436: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619333652] 0003559437: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619333733] 0003559438: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619333762] 0003559439: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619357962] 0003559440: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:00 [3619358230] 0003559441: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619358426] 0003559442: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619358743] 0003559443: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619358791] 0003559444: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619358873] 0003559445: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619358902] 0003559446: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619365776] 0003559447: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:00 [3619365982] 0003559448: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619366142] 0003559449: ****** CAPIIniList called ...
04/20/2009 17:04:00 [3619366406] 0003559450: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619366442] 0003559451: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619366525] 0003559452: ****** DAPIAddProvider called ...
04/20/2009 17:04:00 [3619366554] 0003559453: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:00 [3619366821] 0003559454: KSession::ExecuteCallback(0,12,1B7F8160,0) before
04/20/2009 17:04:00 [3619366904] 0003559455: KSession::ExecuteCallback(0,12,0) after
04/20/2009 17:04:00 [3619367415] 0003559456: KSql::EndTransaction('SUCCESS',FALSE) --> 0
04/20/2009 17:04:00 [3619367449] 0003559457: KConnect::EndTransaction --> DiffStart[sec: 0 msec: 36], DiffLast[sec: 0 msec: 36]
04/20/2009 17:04:01 [3619380013] 0003559458: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619462131] 0003559459: ****** DAPIAllocNode called ...
04/20/2009 17:04:01 [3619462175] 0003559460: ****** DAPIGetNodeByID called ...
04/20/2009 17:04:01 [3619462495] 0003559461: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:01 [3619462517] 0003559462: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619462541] 0003559463: KSqlCursor::Bind(1,{2001}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619463479] 0003559464: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619463668] 0003559465: KSqlCursor::Fetch({-2001,-1,2001,'Sistema Livelink',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,148,1000,D/2008/9/25:13:31:28,D/2008/9/25:16:17:52,-1,0,?,0,?,?,?,?,?,?,?,?,5,?,?,?,?,?,?,?,?,?,?,?,0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619464038] 0003559466: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619464097] 0003559467: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:01 [3619464120] 0003559468: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,-1,2001,'Sistema Livelink',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,148,1000,D/2008/9/25:13:31:28,D/2008/9/25:16:17:52,-1,0,?,0,?,?,?,?,?,?,?,?,5,?,?,?,?,?,?,?,?,?,?,?,0,0,?>}) before
04/20/2009 17:04:01 [3619464503] 0003559469: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619464667] 0003559470: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:01 [3619464687] 0003559471: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:01 [3619464709] 0003559472: KSTree::GetByID(0,2001) --> 'SUCCESS',TRUE,TRUE
04/20/2009 17:04:01 [3619464775] 0003559473: ****** DAPIListSubNodes called ...
04/20/2009 17:04:01 [3619464877] 0003559474: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:01 [3619464896] 0003559475: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619464918] 0003559476: KSqlCursor::Bind(1,{2001}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619465269] 0003559477: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619465370] 0003559478: KSqlCursor::Fetch({-2001,-1,2001,'Sistema Livelink',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,148}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619465434] 0003559479: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619465461] 0003559480: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:01 [3619465485] 0003559481: KSTree::GetByID(-2001,2001) --> 'SUCCESS',TRUE,TRUE
04/20/2009 17:04:01 [3619465590] 0003559482: KSqlCursor::Open(4000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE from DTree where ParentID=:A AND SubType=275') -->'SUCCESS'
04/20/2009 17:04:01 [3619465610] 0003559483: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619465624] 0003559484: KSqlCursor::Bind(1,{2001}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619466002] 0003559485: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619466081] 0003559486: KSqlCursor::Fetch({-2001,2001,2662,'Carpeta de porciones',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,275}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619466143] 0003559487: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619466170] 0003559488: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:01 [3619466189] 0003559489: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE'><-2001,2001,2662,'Carpeta de porciones',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,275>}) before
04/20/2009 17:04:01 [3619466377] 0003559490: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619466507] 0003559491: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:01 [3619466530] 0003559492: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:01 [3619466545] 0003559493: KSTree::List(-2001,2001) --> 'SUCCESS',TRUE
04/20/2009 17:04:01 [3619466567] 0003559494: ****** DAPIAllocNode called ...
04/20/2009 17:04:01 [3619466653] 0003559495: ****** DAPIGetIndexedNode called ...
04/20/2009 17:04:01 [3619466772] 0003559496: ****** DAPIListContents called ...
04/20/2009 17:04:01 [3619467072] 0003559497: KSqlCursor::Open(201f,'select * from DTree where (OwnerID=:A1 and ParentID=:A2) and (SubType=258 and Catalog!=2) order by DataID') -->'SUCCESS'
04/20/2009 17:04:01 [3619467091] 0003559498: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619467106] 0003559499: KSqlCursor::Bind(2,{-2001,2662}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619467671] 0003559500: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVED','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','SUBTYPE','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEEXPIRATION','DATEDUE','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619468336] 0003559507: KSqlCursor::Fetch({-2001,2662,5856,'Ayuda de Admin',0,0,1000,1001,16777215,128,128,16777215,4,?,?,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:16:56,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda de Admin - 09/25/2008 02:13:37 P.M.\'>',0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619468744] 0003559508: KSqlOCI10Cursor: multi-fetched 3 rows
    ..
04/20/2009 17:04:01 [3619469140] 0003559510: KSqlCursor::Fetch({-2001,2662,5873,'Ayuda',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:17:52,D/2008/9/25:16:17:52,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda - 09/25/2008 02:14:33 P.M.\'>',0,0,?}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619469742] 0003559515: KSqlCursor::Fetch({-2001,2662,6076,'S.I.P.',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:13:19,D/2008/9/25:16:13:22,-1,0,0,?,2,'Porcin generada automticamente',?,258,'2',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=2,\'uniqueID\'=\'Empresa - 09/25/2008 02:10:05 P.M.\'>',0,0,?}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619470601] 0003559519: KSqlCursor::Fetch({-2001,2662,6078,'S.I.P. [todas las versiones]',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:13:19,D/2008/9/25:16:13:19,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Empresa [todas las versiones] - 09/25/2008 02:10:05 P.M.\'>',0,0,?}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619470795] 0003559522: KSqlCursor::Close() --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619470869] 0003559524: KSql::Execute(...) --> 'SUCCESS',4 records,[sec: 0 msec: 4]
    ..
04/20/2009 17:04:01 [3619470917] 0003559526: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVED','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','SUBTYPE','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEEXPIRATION','DATEDUE','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,2662,5856,'Ayuda de Admin',0,0,1000,1001,16777215,128,128,16777215,4,?,?,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:16:56,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda de Admin - 09/25/2008 02:13:37 P.M.\'>',0,0,?><-2001,2662,5873,'Ayuda',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:17:52,D/2008/9/25:16:17:52,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda - 09/25/2008 02:14:33 P.M.\'>',0,0,?><-2001,2662,6076,'S.I.P.',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:13:19,D/2008/9/25:16:13:22,-1,0,0,?,2,'Porcin generada automticamente',?,258,'2',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=2,\'uniqueID\'=\'Empresa - 09/25/2008 02:10:05 P.M.\'>',0,0,?><-2001,2662,6078,'S.I.P. [todas las versiones]',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,1000,D/2008/9/25:16:13:19,D/2008/9/25:16:13:19,-1,0,0,?,1,'Porcin generada automticamente',?,258,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Empresa [todas las versiones] - 09/25/2008 02:10:05 P.M.\'>',0,0,?>}) before
    ..
04/20/2009 17:04:01 [3619471864] 0003559537: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619472015] 0003559538: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:01 [3619472035] 0003559539: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:01 [3619472323] 0003559540: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619478439] 0003559541: ****** DAPIAllocNode called ...
04/20/2009 17:04:01 [3619478472] 0003559542: ****** DAPIGetNodeByID called ...
04/20/2009 17:04:01 [3619478715] 0003559543: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:01 [3619478736] 0003559544: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619478756] 0003559545: KSqlCursor::Bind(1,{5856}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619479380] 0003559551: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619480204] 0003559555: KSqlCursor::Fetch({-2001,2662,5856,'Ayuda de Admin',0,0,1000,1001,16777215,128,128,16777215,4,?,?,0,258,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:16:56,-1,0,?,1,'Porcin generada automticamente',?,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda de Admin - 09/25/2008 02:13:37 P.M.\'>',0,0,?}) --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619480666] 0003559557: KSqlCursor::Close() --> 'SUCCESS'
    ..
04/20/2009 17:04:01 [3619480724] 0003559559: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 2]
04/20/2009 17:04:01 [3619480747] 0003559560: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,2662,5856,'Ayuda de Admin',0,0,1000,1001,16777215,128,128,16777215,4,?,?,0,258,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:16:56,-1,0,?,1,'Porcin generada automticamente',?,'1',?,?,?,?,?,0,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'sequenceNum\'=1,\'uniqueID\'=\'Ayuda de Admin - 09/25/2008 02:13:37 P.M.\'>',0,0,?>}) before
    ..
04/20/2009 17:04:01 [3619481568] 0003559569: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619481719] 0003559570: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:01 [3619481740] 0003559571: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:01 [3619481931] 0003559572: KSTree::GetByID(0,5856) --> 'SUCCESS',TRUE,TRUE
    ..
04/20/2009 17:04:01 [3619483010] 0003559576: ****** DAPIAllocVersion called ...
04/20/2009 17:04:01 [3619483031] 0003559577: ****** DAPIGetVersion called ...
04/20/2009 17:04:01 [3619483187] 0003559578: KSqlCursor::Open(2000,'select VERSIONID,DOCID,VERSION,VERSIONNAME,OWNER,VERCDATE,VERMDATE,PLATFORM,FILENAME,DATASIZE,FILETYPE,FILECREATOR,FILECDATE,FILEMDATE,ICON,PROVIDERID,VERCOMMENT,LOCKED,LOCKEDBY,LOCKEDDATE,INDEXED,FINDERFLAGS,MIMETYPE,VERTYPE,VERMAJOR,VERMINOR,RESSIZE from DVersData where DocID=:AN and Version=:BN and VerType is NULL') -->'SUCCESS'
04/20/2009 17:04:01 [3619483207] 0003559579: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619483224] 0003559580: KSqlCursor::Bind(2,{5856,1}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619483703] 0003559581: KSqlCursor::Execute({'VERSIONID','DOCID','VERSION','VERSIONNAME','OWNER','VERCDATE','VERMDATE','PLATFORM','FILENAME','DATASIZE','FILETYPE','FILECREATOR','FILECDATE','FILEMDATE','ICON','PROVIDERID','VERCOMMENT','LOCKED','LOCKEDBY','LOCKEDDATE','INDEXED','FINDERFLAGS','MIMETYPE','VERTYPE','VERMAJOR','VERMINOR','RESSIZE'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619483818] 0003559582: KSqlCursor::Fetch({5856,5856,1,'1',1000,D/2008/9/25:16:16:56,D/2008/9/25:16:16:56,0,'Ayuda de Admin',L1351,?,?,?,?,?,5856,?,0,?,?,0,?,?,?,0,1,?}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619483909] 0003559583: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619483942] 0003559584: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 0]
04/20/2009 17:04:01 [3619483984] 0003559585: ****** DAPIFetchVersionAsVal called ...
04/20/2009 17:04:01 [3619484001] 0003559586: KConnect::StartTransaction --> DiffLast[sec: 0 msec: 117]
04/20/2009 17:04:01 [3619484017] 0003559587: KSql::StartTransaction() --> 0,'SUCCESS'
04/20/2009 17:04:01 [3619484043] 0003559588: KSession::ExecuteCallback(0,3,1B7F8160,{'Ayuda de Admin','1','Ayuda de Admin',L1351,L1}) before
04/20/2009 17:04:01 [3619484135] 0003559589: KSession::ExecuteCallback(0,3,0) after
04/20/2009 17:04:01 [3619484202] 0003559590: KSqlCursor::Open(2000,'select * from ProviderData where providerID=:A1') -->'SUCCESS'
04/20/2009 17:04:01 [3619484220] 0003559591: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619484234] 0003559592: KSqlCursor::Bind(1,{5856}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619484645] 0003559593: KSqlCursor::Execute({'PROVIDERID','REFCNT','PROVIDERTYPE','PROVIDERDATA'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619485260] 0003559594: KSqlCursor::Fetch({5856,1,'Default','A<1,?,\'providerInfo\'=\'0000\\\\005\\\\5856.dat\',\'storageProviderName\'=\'ExtShared\',\'subProviderName\'=\'Default\'>'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619485509] 0003559595: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619485543] 0003559596: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 1]
04/20/2009 17:04:01 [3619485596] 0003559597: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:01 [3619485791] 0003559598: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619485961] 0003559599: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619486301] 0003559600: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619486349] 0003559601: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619486433] 0003559602: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619486461] 0003559603: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619513964] 0003559604: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:01 [3619514257] 0003559605: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619514444] 0003559606: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619514860] 0003559607: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619514918] 0003559608: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619515018] 0003559609: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619515047] 0003559610: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619523777] 0003559611: ****** DAPIGetProviderScriptFeature called ...
04/20/2009 17:04:01 [3619524042] 0003559612: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619524402] 0003559613: ****** CAPIIniList called ...
04/20/2009 17:04:01 [3619524677] 0003559614: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619524714] 0003559615: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619524798] 0003559616: ****** DAPIAddProvider called ...
04/20/2009 17:04:01 [3619524826] 0003559617: KConnect::ErrLog --> [10408,2],'El proveedor ya existe en esta sesin.'
04/20/2009 17:04:01 [3619525293] 0003559618: KSession::ExecuteCallback(0,12,1B7F8160,0) before
04/20/2009 17:04:01 [3619525369] 0003559619: KSession::ExecuteCallback(0,12,0) after
04/20/2009 17:04:01 [3619526233] 0003559620: KSql::EndTransaction('SUCCESS',FALSE) --> 0
04/20/2009 17:04:01 [3619526258] 0003559621: KConnect::EndTransaction --> DiffStart[sec: 0 msec: 42], DiffLast[sec: 0 msec: 42]
04/20/2009 17:04:01 [3619527171] 0003559622: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619528099] 0003559623: ****** DAPIAllocNode called ...
04/20/2009 17:04:01 [3619528122] 0003559624: ****** DAPIGetNodeByID called ...
04/20/2009 17:04:01 [3619528413] 0003559625: KSqlCursor::Open(2000,'select OWNERID,PARENTID,DATAID,NAME,ORIGINOWNERID,ORIGINDATAID,USERID,GROUPID,UPERMISSIONS,GPERMISSIONS,WPERMISSIONS,SPERMISSIONS,ACLCOUNT,PERMID,DATATYPE,RESERVED,SUBTYPE,CREATEDBY,CREATEDATE,MODIFYDATE,MAXVERS,RESERVEDBY,RESERVEDDATE,VERSIONNUM,DCOMMENT,DCATEGORY,EXATT1,EXATT2,ORDERING,MAJOR,MINOR,RELEASEREF,CHILDCOUNT,ASSIGNEDTO,DATEASSIGNED,DATEEFFECTIVE,DATEDUE,DATEEXPIRATION,DATESTARTED,DATECOMPLETED,STATUS,PRIORITY,GIF,EXTENDEDDATA,CATALOG,CACHEEXPIRATION,PRUEBA from DTree where DataID=:A') -->'SUCCESS'
04/20/2009 17:04:01 [3619528434] 0003559626: KSqlCursor::Prepare() --> 'SUCCESS'
04/20/2009 17:04:01 [3619528452] 0003559627: KSqlCursor::Bind(1,{5855}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619529373] 0003559628: KSqlCursor::Execute({'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619530314] 0003559629: KSqlCursor::Fetch({-2001,5851,5855,'Gestor de bsqueda de Ayuda de Admin',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,269,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:17:0,-1,0,?,3,'Gestor de bsqueda generado automticamente',?,?,?,?,?,?,?,1,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'mappings\'={A<1,?,\'UrlFrom\'=\'C:/OPENTEXT/support/\',\'UrlTo\'=\'http://cnig/img/\'>},\'rankings\'=A<1,?,\'DateFieldRankers\'=\'"OTModifyDate",20,2\',\'ExpressionWeight\'=\'1\',\'ExtraWeightFieldRankers\'=\'"OTName",20;"OTHP",10;"OTSummary",10\',\'TypeFieldRankers\'=\'\'>,\'sequenceNum\'=3>',0,0,?}) --> 'SUCCESS'
04/20/2009 17:04:01 [3619530797] 0003559630: KSqlCursor::Close() --> 'SUCCESS'
04/20/2009 17:04:01 [3619530956] 0003559631: KSql::Execute(...) --> 'SUCCESS',1 record,[sec: 0 msec: 2]
04/20/2009 17:04:01 [3619530982] 0003559632: KSession::ExecuteCallback(0,16,1B7F8160,V{<'OWNERID','PARENTID','DATAID','NAME','ORIGINOWNERID','ORIGINDATAID','USERID','GROUPID','UPERMISSIONS','GPERMISSIONS','WPERMISSIONS','SPERMISSIONS','ACLCOUNT','PERMID','DATATYPE','RESERVED','SUBTYPE','CREATEDBY','CREATEDATE','MODIFYDATE','MAXVERS','RESERVEDBY','RESERVEDDATE','VERSIONNUM','DCOMMENT','DCATEGORY','EXATT1','EXATT2','ORDERING','MAJOR','MINOR','RELEASEREF','CHILDCOUNT','ASSIGNEDTO','DATEASSIGNED','DATEEFFECTIVE','DATEDUE','DATEEXPIRATION','DATESTARTED','DATECOMPLETED','STATUS','PRIORITY','GIF','EXTENDEDDATA','CATALOG','CACHEEXPIRATION','PRUEBA'><-2001,5851,5855,'Gestor de bsqueda de Ayuda de Admin',0,0,1000,1001,16777215,128,36995,16777215,4,?,?,0,269,1000,D/2008/9/25:16:16:56,D/2008/9/25:16:17:0,-1,0,?,3,'Gestor de bsqueda generado automticamente',?,?,?,?,?,?,?,1,?,?,?,?,?,?,?,?,?,?,'A<1,?,\'mappings\'={A<1,?,\'UrlFrom\'=\'C:/OPENTEXT/support/\',\'UrlTo\'=\'http://cnig/img/\'>},\'rankings\'=A<1,?,\'DateFieldRankers\'=\'"OTModifyDate",20,2\',\'ExpressionWeight\'=\'1\',\'ExtraWeightFieldRankers\'=\'"OTName",20;"OTHP",10;"OTSummary",10\',\'TypeFieldRankers\'=\'\'>,\'sequenceNum\'=3>',0,0,?>}) before
04/20/2009 17:04:01 [3619531474] 0003559633: ****** CAPIIniGet called ...
04/20/2009 17:04:01 [3619531653] 0003559634: KSession::ExecuteCallback(0,16,0) after
04/20/2009 17:04:01 [3619531673] 0003559635: KSTree::FilterNodesNotify() --> 'SUCCESS'
04/20/2009 17:04:01 [3619531697] 0003559636: KSTree::GetByID(0,5855) --> 'SUCCESS',TRU

modus_ponens

Hi,

I'm having this problem again. Soon after my last reply on this thread, this problem disappeared for us, because we changed our testing server to a different Livelink installation (same features: 9.7.1 UTF8 Spanish) and it started working properly. Now, we have to perform a search operation in a new Livelink installation (with the same features), and the error has appeared again.

Any idea to help us locate the problem? Thanks in advance.

sgrasley

Hi, Francisco.

I believe this is caused by the search results not having a value for one of the regions (e.g. OTObjectSize). Because there is no value, the service is throwing an exception when trying to populate the SNode SDO property (e.g. the I property) for the result.

The SNode SDO properties should likely be made nillable for a future release to avoid this problem.

Scott

modus_ponens

Hi Scott,

And could it be possible to reduce the number of regions returned on the search, to avoid such case? In our project we only need each ID of the results, and we can ignore the rest of the information. Can I configure search service results somehow ?

Thanks

sgrasley

Hi, Francisco.

You can use the ResultTransformationSpec property of SingleSearchRequest to specify the regions to return in the result. These regions need to be set as displayable in the region map of the Search Manager.

request.getResultTransformationSpec().add( "OTDataID" );

Thanks,

Scott