Re: [xwiki-users] DB List Query Problems

2010-10-21 Thread Marius Dumitru Florea
Hi Martin,

On 10/20/2010 09:10 PM, mbryant wrote:
>
> So using HQL in velocity helps a little, I have been able to get results, and
> for that I thank you.  I did run into an unexpected issues that you might be
> able to help with.  Below is the query that was used
>
> {{velocity}}
>
>
> #set($hql = "select obj.name, prop.value from BaseObject obj, StringProperty
> prop where obj.className='CustClasses.ToolClass' and prop.id.id=obj.id and
> prop.name='ProductName'")
>
> #set($results = $xwiki.search($hql, 1000, 0))
> #foreach ($item in $results)
>   * $item
> #end
> {{/velocity}}
>
>
> While I get a result it is an unexpected value, it appears to have returned
> the object ID see below:
>

> * [Ljava.lang.Object;@af0baa

That's normal because $item is an array of Java objects (xobject name 
and property value) and by simply printing $item you are in fact calling 
its toString() method which returns the string you see.

>
> It should be noted when I just try to get the obj.name without the property
> value it works fine.

That's normal too, because in this case $item is not an array of Java 
objects but a string (xobject name).

You can use this code to display the results:

|=Object Name|=Property Value
#foreach ($item in $results)
|$item.get(0)|$item.get(1)
#end

Hope this helps,
Marius

>
> Now that I know the Query generally works in Velocity, It should be the same
> thing to just cut and paste the Query into the DB List attribute of an
> object.
>
> Thanks for your continued help and timely response.
>
> On a side note, I would like to be able to create links on results (when
> used inside of a velocity script on a page), is there an easy way to do that
> as well?
>
> Martin
> Modus Operandi
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] I'll be in The Hague on November 1st

2010-10-21 Thread Guillaume Lerouge
Hi XWiki users,

I'll be in The Hague on November 1st to give a XWiki workshop. For those of
you who'd like to attend (and who speak Dutch), all the details are on:
https://noiv.nl/actueel/nieuws/2010/10/18/workshop-over-de-waarde-van-open-source-xwiki-voor-organisaties/

Looking forward meeting some of you guys there,

Guillaume
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] DB List Query Problems

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.


Marius Dumitru Florea wrote:
> Hi Martin,
>
> On 10/20/2010 09:10 PM, mbryant wrote:
>   
>> So using HQL in velocity helps a little, I have been able to get results, and
>> for that I thank you.  I did run into an unexpected issues that you might be
>> able to help with.  Below is the query that was used
>>
>> {{velocity}}
>>
>>
>> #set($hql = "select obj.name, prop.value from BaseObject obj, StringProperty
>> prop where obj.className='CustClasses.ToolClass' and prop.id.id=obj.id and
>> prop.name='ProductName'")
>>
>> #set($results = $xwiki.search($hql, 1000, 0))
>> #foreach ($item in $results)
>>   * $item
>> #end
>> {{/velocity}}
>>
>>
>> While I get a result it is an unexpected value, it appears to have returned
>> the object ID see below:
>>
>> 
>
>   
>> * [Ljava.lang.Object;@af0baa
>> 
>
> That's normal because $item is an array of Java objects (xobject name 
> and property value) and by simply printing $item you are in fact calling 
> its toString() method which returns the string you see.
>
>   
>> It should be noted when I just try to get the obj.name without the property
>> value it works fine.
>> 
>
> That's normal too, because in this case $item is not an array of Java 
> objects but a string (xobject name).
>
> You can use this code to display the results:
>
> |=Object Name|=Property Value
> #foreach ($item in $results)
> |$item.get(0)|$item.get(1)
> #end
>
> Hope this helps,
> Marius
>
>   
>> Now that I know the Query generally works in Velocity, It should be the same
>> thing to just cut and paste the Query into the DB List attribute of an
>> object.
>>
>> Thanks for your continued help and timely response.
>>
>> On a side note, I would like to be able to create links on results (when
>> used inside of a velocity script on a page), is there an easy way to do that
>> as well?
>>
>> Martin
>> Modus Operandi
>> 
You can use the public API method $searchDocuments this way...

{{velocity}}
#set($query = ", BaseObject as obj, StringProperty as productName where 
doc.fullName = obj.name and obj.className='CustClasses.ToolClass' order 
by doc.fullName asc")

#set($results=$xwiki.searchDocuments($query))
#foreach($item in $results)
#set($itemdoc = $xwiki.getDocument($item))
[[$itemdoc.display('Name')>>$item]]
#end
{{/velocity}}

Look for $searchDocuments in the API JavaDoc to better understantd what 
you are doing...

http://platform.xwiki.org/xwiki/bin/view/DevGuide/API

I, like you, I'm still trying to understand the whole stuff and to be 
able to do things as "easy" as developers do! :-)

Greetings,

Ricardo

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] Java using 100%

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.
Hi!

In a 2.4.1 XE/XEM installation with contents recently migrated from a XE 
1.3.8295 I'm seeing this:

top - 12:15:06 up 16 days,  8:38,  3 users,  load average: 1.36, 1.39, 1.32
Tasks: 1062 total,   1 running, 1061 sleeping,   0 stopped,   0 zombie
Cpu(s):  7.8%us,  0.2%sy,  0.0%ni, 92.0%id,  0.0%wa,  0.0%hi,  0.0%si,  
0.0%st
Mem:   6216784k total,  5992440k used,   224344k free,95312k buffers
Swap:  2104472k total,  152k used,  2104320k free,  3222044k cached

  PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  
COMMAND  
17689 root  22   0  668m 550m 2852 S  100  9.1 216:28.00 
java  

Java goes back to "normal" if I shut down the Tomcat instance on which 
XWiki is running. Catalina.out is plenty of errors and warnings and I 
really don't know which of them, if any, could be responsible of this 
situation.

Lucene is not working neither.

I'm linking a catalina.out file truncated by yesterday at 22:19 after a 
Tomcat shutdown. Please, could you help me to work out this errors and 
warnings?

http://ftp.ebiotic.net/fromPeat/catalina.out.201010211227.txt

Thanks for your help!

Ricardo
 

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Open Office import plugin is not working in XEM 2.4.3

2010-10-21 Thread AngeloG


AngeloG wrote:
> 
> Hi everybody,
> 
> I have XEM 2.3 working in a test environment with OpenSuse 11.3, Mysql
> 5.1, OpenOffice 3.2.1, and Jetty, as per defualt war distributed, and
> everything is working fine.
> I made the upgrade to XEM 2.4.3 version, importing new xar, also. I made
> modifications to the relevant  
> xwiki.properties file to make the Office importer section identical to the
> previous 2.3 version, (see below) but the office server does not start and
> import is not working in 2.4.3!
> --
> xwiki.log file: (XEM 2.4.3)
> 
> 2010-10-18 11:23:05,125 [main] ERROR rnal.DefaultObservationManager  -
> Fail to send event
> [org.xwiki.observation.event.applicationstartedev...@1d592a] to listener
> [org.xwiki.officeimporter.internal.openoffice.openofficemanagerlifecycleliste...@c8e4de]
> java.lang.IllegalStateException: invalid templateProfileDir:
> /home/smg/.ooo3/user
> at
> org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.buildOfficeManager(DefaultOfficeManagerConfiguration.java:122)
> at
> org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.initialize(DefaultOpenOfficeManager.java:102)
> at
> org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.start(DefaultOpenOfficeManager.java:135)
> at
> org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.startOpenOffice(OpenOfficeManagerLifecycleListener.java:96)
> at
> org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.onEvent(OpenOfficeManagerLifecycleListener.java:83)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:269)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:243)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:290)
> at
> org.xwiki.container.servlet.XWikiServletContextListener.contextInitialized(XWikiServletContextListener.java:76)
> at
> org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
> at
> org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
> at
> org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)
> at
> org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
> at
> org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:467)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
> at org.mortbay.jetty.Server.doStart(Server.java:224)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:985)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.mortbay.start.Main.invokeMain(Main.java:194)
> at org.mortbay.start.Main.start(Main.java:534)
> at org.mortbay.start.Main.start(Main.java:441)
> at org.mortbay.start.Main.main(Main.java:119)
> 
> 
> Since it is a test environment, I can easily start/stop Jetty container
> and choose to use 2.3 or 2.4.3 versions, which are in different dirs but
> they use the same database. Since the values of the parameters in the
> Office import section of the xwiki.properties are exactly the same and if
> I use 2.3 version Office server starts and import works fine, I wonder if
> this is a bug of version 2.4.3 or what can be my mistake in configuration.
> ---
> xwiki.properties file: (good for 2.3 , bad for 2.4.3)
> 
> # Settings for the OpenOffice server instance consumed by the
> OfficeImporter plugin
> #--
>  
> #-# [Since 1.9M2]
> #-# Type of the openoffice server instance used by officeimporter plugin.
> #-# 0 - Internally managed server instance. (Default)
> #-# 1 - Externally managed (local) server instance.
> # openoffice.serverType=0
> 
> #-# [Since 1.9M2]
> #-# Port number used for connecting to the openoffice server 

Re: [xwiki-users] Open Office import plugin is not working in XEM 2.4.3

2010-10-21 Thread AngeloG


AngeloG wrote:
> 
> Hi everybody,
> 
> I have XEM 2.3 working in a test environment with OpenSuse 11.3, Mysql
> 5.1, OpenOffice 3.2.1, and Jetty, as per defualt war distributed, and
> everything is working fine.
> I made the upgrade to XEM 2.4.3 version, importing new xar, also. I made
> modifications to the relevant  
> xwiki.properties file to make the Office importer section identical to the
> previous 2.3 version, (see below) but the office server does not start and
> import is not working in 2.4.3!
> --
> xwiki.log file: (XEM 2.4.3)
> 
> 2010-10-18 11:23:05,125 [main] ERROR rnal.DefaultObservationManager  -
> Fail to send event
> [org.xwiki.observation.event.applicationstartedev...@1d592a] to listener
> [org.xwiki.officeimporter.internal.openoffice.openofficemanagerlifecycleliste...@c8e4de]
> java.lang.IllegalStateException: invalid templateProfileDir:
> /home/smg/.ooo3/user
> at
> org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.buildOfficeManager(DefaultOfficeManagerConfiguration.java:122)
> at
> org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.initialize(DefaultOpenOfficeManager.java:102)
> at
> org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.start(DefaultOpenOfficeManager.java:135)
> at
> org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.startOpenOffice(OpenOfficeManagerLifecycleListener.java:96)
> at
> org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.onEvent(OpenOfficeManagerLifecycleListener.java:83)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:269)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:243)
> at
> org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:290)
> at
> org.xwiki.container.servlet.XWikiServletContextListener.contextInitialized(XWikiServletContextListener.java:76)
> at
> org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
> at
> org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
> at
> org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)
> at
> org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
> at
> org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:467)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
> at org.mortbay.jetty.Server.doStart(Server.java:224)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
> at
> org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:985)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.mortbay.start.Main.invokeMain(Main.java:194)
> at org.mortbay.start.Main.start(Main.java:534)
> at org.mortbay.start.Main.start(Main.java:441)
> at org.mortbay.start.Main.main(Main.java:119)
> 
> 
> Since it is a test environment, I can easily start/stop Jetty container
> and choose to use 2.3 or 2.4.3 versions, which are in different dirs but
> they use the same database. Since the values of the parameters in the
> Office import section of the xwiki.properties are exactly the same and if
> I use 2.3 version Office server starts and import works fine, I wonder if
> this is a bug of version 2.4.3 or what can be my mistake in configuration.
> ---
> xwiki.properties file: (good for 2.3 , bad for 2.4.3)
> 
> # Settings for the OpenOffice server instance consumed by the
> OfficeImporter plugin
> #--
>  
> #-# [Since 1.9M2]
> #-# Type of the openoffice server instance used by officeimporter plugin.
> #-# 0 - Internally managed server instance. (Default)
> #-# 1 - Externally managed (local) server instance.
> # openoffice.serverType=0
> 
> #-# [Since 1.9M2]
> #-# Port number used for connecting to the openoffice server 

Re: [xwiki-users] Livetable does not show results

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.
Hi!

Gerritjan Koekkoek wrote:
> Hi
>
> I only have 2.5, deinstalled the old version
> In my situation It looks like it is only working on classes where the classes 
> sit in the XWiki space and the documents holding the objects are in the same 
> space?
> So it works with users, but not with panels.panelclass (or my own custom 
> developed class). It does work brilliantly with tag-class Even get unexected 
> goodies
>   

It also works here with custom developed classes. See this, I've created 
it trying to find an answer to another message sent to the list...

http://ebiotic.net/bin/ICT/LiveTableModusOperandi
> I do not think it's the generator script, but something with livetable?
>
> Gerritjan
>
> Op 20 okt 2010, om 01:05 heeft [Ricardo Rodriguez] eBioTIC. het volgende 
> geschreven:
>
> Hi,
>
> Thibaut Camberlin wrote:
>   
>> Hi Gerritjan,
>>
>> Ludovic did that script not me I have to say!
>>
>> Did you test the same code on another version of XWiki ? If so what is the
>> behaviour and the version ?
>> Can you generate the livetable based on another class, say XWiki.XWikiUsers,
>> what is the result ?
>>
>>
>> 
>
> It is working fine in a XE/XEM 2.4.1 system. Thibaut, you can check it 
> here...
>
> http://ebiotic.net/bin/ICT/LiveTableUsers
>
>   
>> On Tue, Oct 19, 2010 at 7:48 PM, Gerritjan Koekkoek <
>> gerritjankoekk...@gmail.com> wrote:
>>
>>
>> 
>>> Hi Thibaut,
>>> The script works like magic, very nice.
>>> Copy and Paste from the link created some formatting challenges, but after
>>> fixing the script generated actually created a live table;
>>> BUT...
>>> Still there are no records displayed? Like with the script I put in this
>>> question.
>>> The pages where the objects are stored are in a space that has access
>>> forbidden for unregistered users?
>>> Off course I run the generated script as a registered user (actually as a
>>> admin user
>>> I'm running this on xwiki 2.5
>>>
>>> Gerritjan
>>>
>>> Op 18 okt 2010, om 23:11 heeft Thibaut Camberlin het volgende geschreven:
>>>
>>> Hi Gerritjan,
>>>
>>> You can use the livetable generator code snippet
>>> http://code.xwiki.org/xwiki/bin/view/Snippets/LivetableGeneratorSnippet
>>>
>>> Hope this helps,
>>> --
>>> Thibaut
>>>
>>>
>>> On Sun, Oct 17, 2010 at 2:23 PM, Gerritjan Koekkoek <
>>> gerritjankoekk...@gmail.com> wrote:
>>>
>>>
>>>   
 Hi,

 i'm trying to use LiveTable to improve our user experience.
 This is my code:

 #set($collist = ["name", "email" , "subject", "status", "question",
 "answer", "generalize"])

 #set($colprops = {
 "name" : { "type" : "text", "size" : 20, " link" : "view"},
 "email" :{ "type" : "text", "size" : 20, " link" : "view"},
 "subject" :{ "type" : "text", "size" : 20, "link" : "none"},
 "status" :{ "type" : "text", "size" : 20, "link" : "none"},
 "question" :{ "type" : "text", "size" : 20, "link" : "none", "html" :
 "true", "sortable":false },
 "answer" :{ "type" : "text", "size" : 20, "link" : "none", "html" :
 "true", "sortable":false },
 "generalize" : { "type" : "list", "class":
 "CdlsatdCode.CdLS_ATD_UserQuestionsClass"}
   })

 #set($options = {
 "className":"CdlsatdCode.CdLS_ATD_UserQuestionsClass",
 "rowCount": 15 })
 
 #livetable("myLTQuestions" $collist $colprops $options)

 It does show the table, but without any rows!
 The last column does recognize the List box as defined in the Class,
 because when I click it it shows the list of values defined in the class

 If I use a jsonQuery as in the example below, I get two records as

 
>>> defined
>>>
>>>   
 in the filter.
 I tried to replace the above options value className with resultPage
 pointing to page containing the jsonQuery below... but with the same

 
>>> result,
>>>
>>>   
 no rows returned

 ===
 {{include document="XWiki.LiveTableResultsMacros" /}}
 {{velocity}}
 #gridresultwithfilter("CdlsatdCode.CdLS_ATD_UserQuestionsClass"
 $request.collist.split(",") "" " and doc.creator='$context.user'")
 {{/velocity}}

 the page I get shows me:
 {
 "totalrows": 2,
 "matchingtags": {
 },
 "tags" : [
 ],
 "returnedrows":  0 ,
 "offset": 1,
 "reqNo": $request.reqNo,
 "rows": [
 {
 "doc_viewable" : true,
 "doc_name" : "GerritjanKoekkoek_doc261",
 "doc_fullname" : "xwiki:CdlsatdPrivate.GerritjanKoekkoek_doc261",
 "doc_space" : "CdlsatdPrivate",
 "doc_url" :


 
>>> "\/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/CdlsatdPrivate\/GerritjanKoekkoek_doc261",
>>>
>>>   
 "doc_space_url" :
 "\/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/CdlsatdPrivate\/",
 "doc_hasadmin"  : true,
 "doc_edit_url" :


 
>>> "\/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/inline\/CdlsatdPrivate\/GerritjanKoekkoek_doc261",
>>>
>>> 

Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne
On Wed, Oct 20, 2010 at 11:46, [Ricardo Rodriguez] eBioTIC.
 wrote:
>
>
> Thomas Mortagne wrote:
>> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>>  wrote:
>>
>>> Hi!
>>>
>>> In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...
>>>
>>> *Lucene is currently building its index, 41 documents in queue.
>>>
>>> *And we can't access Search in XWiki Preferences of any of the subwikis
>>> or even the controller.*
>>> *
>>> I see this in xwiki.log:
>>>
>>> com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
>>> switching to database redpatrimonio
>>>
>>
>> The only way to have this error I know is to have a
>> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
>> no corresponding database.
>>
>>
>>> Wrapped Exception: Unknown database 'redpatrimonio'
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
>>>    at
>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
>>>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
>>>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
>>>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
>>>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
>>>    at com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
>>>    at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
>>>    at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22
>>>
>>>
>>> In fact, that database is called redepatrimonio, not redpatrimonio.
>>>
>>> The wiki descriptor page name in the main wiki is
>>> XWiki.XWikiServerRedepatrimonio.
>>>
>>
>> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>>
>
> I think I haven't it. Please, see...

I think you used to have it and it has been removed but lucene plugin
did not see that and now you have document in lucene index that don't
exists. Try to recreate the lucene index.

>
> http://ebiotic.net/bin/ICT/Subwikis
>>
>>> Please, where the name of the database as listed in the exception is
>>> stored? How could I correct it?
>>>
>>> I don't know how I've messed things and if this error is related with
>>> problem, but it seems that need to be corrected before trying anything else!
>>>
>>
>> In any case, it's also a Lucene plugin bug since a ghost wiki should
>> not break it, would be nice if you could report it on
>> http://jira.xwiki.org.
>
> I'm doing some more research. I'll create a JIRA issue with the results.
>
> Thanks!
>
> Ricardo
>
> --
> Ricardo Rodríguez
> CTO
> eBioTIC.
> Life Sciences, Data Modeling and Information Management Systems
>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne
On Thu, Oct 21, 2010 at 16:50, Thomas Mortagne
 wrote:
> On Wed, Oct 20, 2010 at 11:46, [Ricardo Rodriguez] eBioTIC.
>  wrote:
>>
>>
>> Thomas Mortagne wrote:
>>> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>>>  wrote:
>>>
 Hi!

 In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...

 *Lucene is currently building its index, 41 documents in queue.

 *And we can't access Search in XWiki Preferences of any of the subwikis
 or even the controller.*
 *
 I see this in xwiki.log:

 com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
 switching to database redpatrimonio

>>>
>>> The only way to have this error I know is to have a
>>> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
>>> no corresponding database.
>>>
>>>
 Wrapped Exception: Unknown database 'redpatrimonio'
    at
 com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
    at
 com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
    at
 com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
    at
 com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
    at com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
    at
 com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
    at
 com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22


 In fact, that database is called redepatrimonio, not redpatrimonio.

 The wiki descriptor page name in the main wiki is
 XWiki.XWikiServerRedepatrimonio.

>>>
>>> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>>>
>>
>> I think I haven't it. Please, see...
>
> I think you used to have it and it has been removed but lucene plugin
> did not see that and now you have document in lucene index that don't
> exists. Try to recreate the lucene index.

Note that this is "because of" http://jira.xwiki.org/jira/browse/XWIKI-3966

>
>>
>> http://ebiotic.net/bin/ICT/Subwikis
>>>
 Please, where the name of the database as listed in the exception is
 stored? How could I correct it?

 I don't know how I've messed things and if this error is related with
 problem, but it seems that need to be corrected before trying anything 
 else!

>>>
>>> In any case, it's also a Lucene plugin bug since a ghost wiki should
>>> not break it, would be nice if you could report it on
>>> http://jira.xwiki.org.
>>
>> I'm doing some more research. I'll create a JIRA issue with the results.
>>
>> Thanks!
>>
>> Ricardo
>>
>> --
>> Ricardo Rodríguez
>> CTO
>> eBioTIC.
>> Life Sciences, Data Modeling and Information Management Systems
>>
>> ___
>> users mailing list
>> users@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
>>
>
>
>
> --
> Thomas Mortagne
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne
On Wed, Oct 20, 2010 at 15:10, [Ricardo Rodriguez] eBioTIC.
 wrote:
> An update, please, see below...
>
> [Ricardo Rodriguez] eBioTIC. wrote:
>> Thomas Mortagne wrote:
>>
>>> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>>>  wrote:
>>>
>>>
 Hi!

 In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...

 *Lucene is currently building its index, 41 documents in queue.

 *And we can't access Search in XWiki Preferences of any of the subwikis
 or even the controller.*
 *
 I see this in xwiki.log:

 com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
 switching to database redpatrimonio


>>> The only way to have this error I know is to have a
>>> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
>>> no corresponding database.
>>>
>>>
>>>
 Wrapped Exception: Unknown database 'redpatrimonio'
    at
 com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
    at
 com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
    at
 com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
    at
 com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
    at com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
    at
 com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
    at
 com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22


 In fact, that database is called redepatrimonio, not redpatrimonio.

 The wiki descriptor page name in the main wiki is
 XWiki.XWikiServerRedepatrimonio.


>>> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>>>
>>>
>>
>> I think I haven't it. Please, see...
>>
>> http://ebiotic.net/bin/ICT/Subwikis
>>
>>>
>>>
 Please, where the name of the database as listed in the exception is
 stored? How could I correct it?

 I don't know how I've messed things and if this error is related with
 problem, but it seems that need to be corrected before trying anything 
 else!


>>> In any case, it's also a Lucene plugin bug since a ghost wiki should
>>> not break it, would be nice if you could report it on
>>> http://jira.xwiki.org.
>>>
>>
>> I'm doing some more research. I'll create a JIRA issue with the results.
>>
>> Thanks!
>>
>> Ricardo
>>
>>
> There were some corrupted attachments here that were throwing
> exceptions. I guess this has nothing to do with Lucene stopping

Yes corrupted attachments can't break Lucene indexing AFAIK.

> indexing, but I'm trying to "clean up" catalina.out to find the reason
> why Lucene is failing.
>
> Only one attachment not identified as "broken attachment" by Raluca's
> script
> (http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments), in
> fact, it downloads without a glitch, keeps throwing an exception while
> indexing:
>
> ricardorodrig...@peat:/var/log/tomcat5/base> cat catalina.out |grep
> 'IML.Acreditacion'
> 2010-10-20 13:15:22,501 [Lucene Index Updater] WARN
> lucene.AttachmentData           - error getting content of attachment
> [IsoIec17025-1999IRam301-00NormaArgentina.pdf] for document
> [gmx:IML.Acreditacion]
> ricardorodrig...@peat:/var/log/tomcat5/base>
>

That weird because this error is because storage returned an error to
Lucene plugin.

> I'll delete it, change its name and try again.
>
> I'll keep cleaning errors and keep this thread posted.
>
> BTW: I've not seen the error related with the Redpatrimonio ghost
> subwiki any more... :-(
>
> Any idea will be welcome! Thanks!
>
> Ricardo
>
> --
> Ricardo Rodríguez
> CTO
> eBioTIC.
> Life Sciences, Data Modeling and Information Management Systems
>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne
On Thu, Oct 21, 2010 at 16:56, Thomas Mortagne
 wrote:
> On Wed, Oct 20, 2010 at 15:10, [Ricardo Rodriguez] eBioTIC.
>  wrote:
>> An update, please, see below...
>>
>> [Ricardo Rodriguez] eBioTIC. wrote:
>>> Thomas Mortagne wrote:
>>>
 On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
  wrote:


> Hi!
>
> In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...
>
> *Lucene is currently building its index, 41 documents in queue.
>
> *And we can't access Search in XWiki Preferences of any of the subwikis
> or even the controller.*
> *
> I see this in xwiki.log:
>
> com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
> switching to database redpatrimonio
>
>
 The only way to have this error I know is to have a
 XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
 no corresponding database.



> Wrapped Exception: Unknown database 'redpatrimonio'
>    at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
>    at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
>    at
> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
>    at
> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
>    at 
> com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
>    at
> com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
>    at
> com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22
>
>
> In fact, that database is called redepatrimonio, not redpatrimonio.
>
> The wiki descriptor page name in the main wiki is
> XWiki.XWikiServerRedepatrimonio.
>
>
 Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.


>>>
>>> I think I haven't it. Please, see...
>>>
>>> http://ebiotic.net/bin/ICT/Subwikis
>>>


> Please, where the name of the database as listed in the exception is
> stored? How could I correct it?
>
> I don't know how I've messed things and if this error is related with
> problem, but it seems that need to be corrected before trying anything 
> else!
>
>
 In any case, it's also a Lucene plugin bug since a ghost wiki should
 not break it, would be nice if you could report it on
 http://jira.xwiki.org.

>>>
>>> I'm doing some more research. I'll create a JIRA issue with the results.
>>>
>>> Thanks!
>>>
>>> Ricardo
>>>
>>>
>> There were some corrupted attachments here that were throwing
>> exceptions. I guess this has nothing to do with Lucene stopping
>
> Yes corrupted attachments can't break Lucene indexing AFAIK.
>
>> indexing, but I'm trying to "clean up" catalina.out to find the reason
>> why Lucene is failing.
>>
>> Only one attachment not identified as "broken attachment" by Raluca's
>> script
>> (http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments), in
>> fact, it downloads without a glitch, keeps throwing an exception while
>> indexing:
>>
>> ricardorodrig...@peat:/var/log/tomcat5/base> cat catalina.out |grep
>> 'IML.Acreditacion'
>> 2010-10-20 13:15:22,501 [Lucene Index Updater] WARN
>> lucene.AttachmentData           - error getting content of attachment
>> [IsoIec17025-1999IRam301-00NormaArgentina.pdf] for document
>> [gmx:IML.Acreditacion]
>> ricardorodrig...@peat:/var/log/tomcat5/base>
>>
>
> That weird because this error is because storage returned an error to
> Lucene plugin.
>
>> I'll delete it, change its name and try again.
>>
>> I'll keep cleaning errors and keep this thread posted.
>>
>> BTW: I've not seen the error related with the Redpatrimonio ghost
>> subwiki any more... :-(

Maybe you recreated the Lucene index as i suggested in another before
seeing this one.

>>
>> Any idea will be welcome! Thanks!
>>
>> Ricardo
>>
>> --
>> Ricardo Rodríguez
>> CTO
>> eBioTIC.
>> Life Sciences, Data Modeling and Information Management Systems
>>
>> ___
>> users mailing list
>> users@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
>>
>
>
>
> --
> Thomas Mortagne
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.


Thomas Mortagne wrote:
> On Thu, Oct 21, 2010 at 16:56, Thomas Mortagne
>  wrote:
>   
>> On Wed, Oct 20, 2010 at 15:10, [Ricardo Rodriguez] eBioTIC.
>>  wrote:
>> 
>>> An update, please, see below...
>>>
>>> [Ricardo Rodriguez] eBioTIC. wrote:
>>>   
 Thomas Mortagne wrote:

 
> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>  wrote:
>
>
>   
>> Hi!
>>
>> In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...
>>
>> *Lucene is currently building its index, 41 documents in queue.
>>
>> *And we can't access Search in XWiki Preferences of any of the subwikis
>> or even the controller.*
>> *
>> I see this in xwiki.log:
>>
>> com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
>> switching to database redpatrimonio
>>
>>
>> 
> The only way to have this error I know is to have a
> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
> no corresponding database.
>
>
>
>   
>> Wrapped Exception: Unknown database 'redpatrimonio'
>>at
>> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
>>at
>> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
>>at
>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
>>at
>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
>>at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
>>at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
>>at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
>>at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
>>at 
>> com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
>>at
>> com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
>>at
>> com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22
>>
>>
>> In fact, that database is called redepatrimonio, not redpatrimonio.
>>
>> The wiki descriptor page name in the main wiki is
>> XWiki.XWikiServerRedepatrimonio.
>>
>>
>> 
> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>
>
>   
 I think I haven't it. Please, see...

 http://ebiotic.net/bin/ICT/Subwikis

 
>   
>> Please, where the name of the database as listed in the exception is
>> stored? How could I correct it?
>>
>> I don't know how I've messed things and if this error is related with
>> problem, but it seems that need to be corrected before trying anything 
>> else!
>>
>>
>> 
> In any case, it's also a Lucene plugin bug since a ghost wiki should
> not break it, would be nice if you could report it on
> http://jira.xwiki.org.
>
>   
 I'm doing some more research. I'll create a JIRA issue with the results.

 Thanks!

 Ricardo


 
>>> There were some corrupted attachments here that were throwing
>>> exceptions. I guess this has nothing to do with Lucene stopping
>>>   
>> Yes corrupted attachments can't break Lucene indexing AFAIK.
>>
>> 
>>> indexing, but I'm trying to "clean up" catalina.out to find the reason
>>> why Lucene is failing.
>>>
>>> Only one attachment not identified as "broken attachment" by Raluca's
>>> script
>>> (http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments), in
>>> fact, it downloads without a glitch, keeps throwing an exception while
>>> indexing:
>>>
>>> ricardorodrig...@peat:/var/log/tomcat5/base> cat catalina.out |grep
>>> 'IML.Acreditacion'
>>> 2010-10-20 13:15:22,501 [Lucene Index Updater] WARN
>>> lucene.AttachmentData   - error getting content of attachment
>>> [IsoIec17025-1999IRam301-00NormaArgentina.pdf] for document
>>> [gmx:IML.Acreditacion]
>>> ricardorodrig...@peat:/var/log/tomcat5/base>
>>>
>>>   
>> That weird because this error is because storage returned an error to
>> Lucene plugin.
>>
>> 
>>> I'll delete it, change its name and try again.
>>>
>>> I'll keep cleaning errors and keep this thread posted.
>>>
>>> BTW: I've not seen the error related with the Redpatrimonio ghost
>>> subwiki any more... :-(
>>>   
>
> Maybe you recreated the Lucene index as i suggested in another before
> seeing this one.
>
>   

I've recreated the index several times (completely removed 
/tmp/xwiki/lucene folder and restarted the servlet container) before and 
after deleting broken attachments. I've also removed those documents 
reported by Lucene as having problems with them. Three PDF files and 
three Excel xlsb files. I can download them from the wiki and open them 
without problems. Now, n

Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.


[Ricardo Rodriguez] eBioTIC. wrote:
> Thomas Mortagne wrote:
>   
>> On Thu, Oct 21, 2010 at 16:56, Thomas Mortagne
>>  wrote:
>>   
>> 
>>> On Wed, Oct 20, 2010 at 15:10, [Ricardo Rodriguez] eBioTIC.
>>>  wrote:
>>> 
>>>   
 An update, please, see below...

 [Ricardo Rodriguez] eBioTIC. wrote:
   
 
> Thomas Mortagne wrote:
>
> 
>   
>> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>>  wrote:
>>
>>
>>   
>> 
>>> Hi!
>>>
>>> In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...
>>>
>>> *Lucene is currently building its index, 41 documents in queue.
>>>
>>> *And we can't access Search in XWiki Preferences of any of the subwikis
>>> or even the controller.*
>>> *
>>> I see this in xwiki.log:
>>>
>>> com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
>>> switching to database redpatrimonio
>>>
>>>
>>> 
>>>   
>> The only way to have this error I know is to have a
>> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
>> no corresponding database.
>>
>>
>>
>>   
>> 
>>> Wrapped Exception: Unknown database 'redpatrimonio'
>>>at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
>>>at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
>>>at
>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
>>>at
>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
>>>at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
>>>at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
>>>at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
>>>at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
>>>at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
>>>at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22
>>>
>>>
>>> In fact, that database is called redepatrimonio, not redpatrimonio.
>>>
>>> The wiki descriptor page name in the main wiki is
>>> XWiki.XWikiServerRedepatrimonio.
>>>
>>>
>>> 
>>>   
>> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>>
>>
>>   
>> 
> I think I haven't it. Please, see...
>
> http://ebiotic.net/bin/ICT/Subwikis
>
> 
>   
>>   
>> 
>>> Please, where the name of the database as listed in the exception is
>>> stored? How could I correct it?
>>>
>>> I don't know how I've messed things and if this error is related with
>>> problem, but it seems that need to be corrected before trying anything 
>>> else!
>>>
>>>
>>> 
>>>   
>> In any case, it's also a Lucene plugin bug since a ghost wiki should
>> not break it, would be nice if you could report it on
>> http://jira.xwiki.org.
>>
>>   
>> 
> I'm doing some more research. I'll create a JIRA issue with the results.
>
> Thanks!
>
> Ricardo
>
>
> 
>   
 There were some corrupted attachments here that were throwing
 exceptions. I guess this has nothing to do with Lucene stopping
   
 
>>> Yes corrupted attachments can't break Lucene indexing AFAIK.
>>>
>>> 
>>>   
 indexing, but I'm trying to "clean up" catalina.out to find the reason
 why Lucene is failing.

 Only one attachment not identified as "broken attachment" by Raluca's
 script
 (http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments), in
 fact, it downloads without a glitch, keeps throwing an exception while
 indexing:

 ricardorodrig...@peat:/var/log/tomcat5/base> cat catalina.out |grep
 'IML.Acreditacion'
 2010-10-20 13:15:22,501 [Lucene Index Updater] WARN
 lucene.AttachmentData   - error getting content of attachment
 [IsoIec17025-1999IRam301-00NormaArgentina.pdf] for document
 [gmx:IML.Acreditacion]
 ricardorodrig...@peat:/var/log/tomcat5/base>

   
 
>>> That weird because this error is because storage returned an error to
>>> Lucene plugin.
>>>
>>> 
>>>   
 I'll delete it, change its name and try again.

 I'll keep cleaning errors and keep this thread posted.

 BTW: I've not seen the error related with the Redpatrimonio ghost
 subwiki any more... :-(
>>

Re: [xwiki-users] some problem with Lucene -> Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne
On Thu, Oct 21, 2010 at 18:15, [Ricardo Rodriguez] eBioTIC.
 wrote:
>
>
> Thomas Mortagne wrote:
>> On Thu, Oct 21, 2010 at 16:56, Thomas Mortagne
>>  wrote:
>>
>>> On Wed, Oct 20, 2010 at 15:10, [Ricardo Rodriguez] eBioTIC.
>>>  wrote:
>>>
 An update, please, see below...

 [Ricardo Rodriguez] eBioTIC. wrote:

> Thomas Mortagne wrote:
>
>
>> On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
>>  wrote:
>>
>>
>>
>>> Hi!
>>>
>>> In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...
>>>
>>> *Lucene is currently building its index, 41 documents in queue.
>>>
>>> *And we can't access Search in XWiki Preferences of any of the subwikis
>>> or even the controller.*
>>> *
>>> I see this in xwiki.log:
>>>
>>> com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
>>> switching to database redpatrimonio
>>>
>>>
>>>
>> The only way to have this error I know is to have a
>> XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
>> no corresponding database.
>>
>>
>>
>>
>>> Wrapped Exception: Unknown database 'redpatrimonio'
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
>>>    at
>>> com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
>>>    at
>>> com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
>>>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
>>>    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
>>>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
>>>    at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
>>>    at 
>>> com.xpn.xwiki.plugin.lucene.SearchResult.(SearchResult.java:98)
>>>    at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
>>>    at
>>> com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22
>>>
>>>
>>> In fact, that database is called redepatrimonio, not redpatrimonio.
>>>
>>> The wiki descriptor page name in the main wiki is
>>> XWiki.XWikiServerRedepatrimonio.
>>>
>>>
>>>
>> Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.
>>
>>
>>
> I think I haven't it. Please, see...
>
> http://ebiotic.net/bin/ICT/Subwikis
>
>
>>
>>> Please, where the name of the database as listed in the exception is
>>> stored? How could I correct it?
>>>
>>> I don't know how I've messed things and if this error is related with
>>> problem, but it seems that need to be corrected before trying anything 
>>> else!
>>>
>>>
>>>
>> In any case, it's also a Lucene plugin bug since a ghost wiki should
>> not break it, would be nice if you could report it on
>> http://jira.xwiki.org.
>>
>>
> I'm doing some more research. I'll create a JIRA issue with the results.
>
> Thanks!
>
> Ricardo
>
>
>
 There were some corrupted attachments here that were throwing
 exceptions. I guess this has nothing to do with Lucene stopping

>>> Yes corrupted attachments can't break Lucene indexing AFAIK.
>>>
>>>
 indexing, but I'm trying to "clean up" catalina.out to find the reason
 why Lucene is failing.

 Only one attachment not identified as "broken attachment" by Raluca's
 script
 (http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments), in
 fact, it downloads without a glitch, keeps throwing an exception while
 indexing:

 ricardorodrig...@peat:/var/log/tomcat5/base> cat catalina.out |grep
 'IML.Acreditacion'
 2010-10-20 13:15:22,501 [Lucene Index Updater] WARN
 lucene.AttachmentData           - error getting content of attachment
 [IsoIec17025-1999IRam301-00NormaArgentina.pdf] for document
 [gmx:IML.Acreditacion]
 ricardorodrig...@peat:/var/log/tomcat5/base>


>>> That weird because this error is because storage returned an error to
>>> Lucene plugin.
>>>
>>>
 I'll delete it, change its name and try again.

 I'll keep cleaning errors and keep this thread posted.

 BTW: I've not seen the error related with the Redpatrimonio ghost
 subwiki any more... :-(

>>
>> Maybe you recreated the Lucene index as i suggested in another before
>> seeing this one.
>>
>>
>
> I've recreated the index several times (completely removed
> /tmp/xwiki/lucene folder and restarted the servlet container) before and
> after deleting broken attachments. I've also removed those documents
> reported by Lucene as having problems with them. Three PDF files and
> three Excel xlsb files. I can download them fro

Re: [xwiki-users] Farm upgrade

2010-10-21 Thread Thomas Mortagne
On Wed, Oct 20, 2010 at 17:39, Maxime Mathieu
 wrote:
> Hi,
>
> I'm trying to upgrade my farm from 2.3.2 to 2.4.3.
> If I follow the upgrade guide
> http://manager.xwiki.org/xwiki/bin/view/AdminGuide/Migration , the 2 steps
> are :
> 1/ upgrade the main wiki (XEM war and XEM xar)
> 2/ upgrade each sub-wikis
>
> My question is about this last third step.
> To do the upgrade, I have downloaded the standard XE xar
> (xwiki-enterprise-wiki-2.4.3.xar). But there is also a xar attached in the
> XemManager.install page (template-xe.xar). These 2 xar are the same. I hope
> you confirm this.
> When I import this XAR in a sub-wiki, the author of the upgraded pages is
> XWiki.Admin (the local admin of the sub-wiki). But this local Admin doesn't
> have programming rights. It so happens that a lot of pages (AllDocs,
> DeletedDocuments, ...) can't execute. The workaround is to save these pages
> as xwiki:XWiki.Admin but it's boring.
>
> Is there something that I've missed ?
> Why the template-xe.xar does not have xwiki:XWiki.Admin as author of the
> pages ?

You are not supposed to use template-xe.xar file which is a copy of
the XE xar and used only to create an examplate template wiki in XEM
install page the first time you install XEM. When you do an upgrade,
use the proper XE xar to upgrade each wiki which need to be upgraded
including the template wiki if you created it (or you delete the
template wiki and recreate it by going to XEM install page after
having upgraded XEM main wiki).

>
> Best regards,
> Maxime Mathieu
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] java.io.NotSerializableException

2010-10-21 Thread Thomas Mortagne
On Thu, Oct 21, 2010 at 00:05, [Ricardo Rodriguez] eBioTIC.
 wrote:
> Hi,
>
> Our XE/XEM 2.4.1 farm runs in a Tomcat servlet server. Lucene is
> currently not working. I'm trying to understand what messages logged in
> catalina.out could relate to this problem. We get this
> java.io.NotSerializableException during the start up process. See this...
>
> http://ftp.ebiotic.net/fromPeat/catalina.out.201010202219.txt
>
> Could it affect Lucene? Thanks!

I already seen this error but only when running tomcat in Eclipse and
each time it go away when i restart and I have absolutely no idea what
could be the cause. BTW in my case when i get that there is a lot more
that Lucene which does not work.

>
> Ricardo
>
> --
> Ricardo Rodríguez
> CTO
> eBioTIC.
> Life Sciences, Data Modeling and Information Management Systems
>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] java.io.NotSerializableException

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.
Hi!

Thomas Mortagne wrote:
> On Thu, Oct 21, 2010 at 00:05, [Ricardo Rodriguez] eBioTIC.
>  wrote:
>   
>> Hi,
>>
>> Our XE/XEM 2.4.1 farm runs in a Tomcat servlet server. Lucene is
>> currently not working. I'm trying to understand what messages logged in
>> catalina.out could relate to this problem. We get this
>> java.io.NotSerializableException during the start up process. See this...
>>
>> http://ftp.ebiotic.net/fromPeat/catalina.out.201010202219.txt
>>
>> Could it affect Lucene? Thanks!
>> 
>
> I already seen this error but only when running tomcat in Eclipse and
> each time it go away when i restart and I have absolutely no idea what
> could be the cause. BTW in my case when i get that there is a lot more
> that Lucene which does not work.
>   

I'm afraid the we are in trouble here... :-( So, as several issues seems 
to be related here, I think we have to establish some kind of "strategy" 
to identify the problems. I'm not a maven, so what I can do are only 
simple things.

So, as it seems Lucene is, for one or other reason crowding 
catalina.out, I'll remove Lucene Plugin from xwiki.cfg, start a new 
catalina.out, restart the servlet container and see what messages we do 
obtain.

Please, any other idea? Thanks!

Cheers,

Ricardo

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] java.io.NotSerializableException

2010-10-21 Thread Thomas Mortagne
On Thu, Oct 21, 2010 at 19:32, [Ricardo Rodriguez] eBioTIC.
 wrote:
> Hi!
>
> Thomas Mortagne wrote:
>> On Thu, Oct 21, 2010 at 00:05, [Ricardo Rodriguez] eBioTIC.
>>  wrote:
>>
>>> Hi,
>>>
>>> Our XE/XEM 2.4.1 farm runs in a Tomcat servlet server. Lucene is
>>> currently not working. I'm trying to understand what messages logged in
>>> catalina.out could relate to this problem. We get this
>>> java.io.NotSerializableException during the start up process. See this...
>>>
>>> http://ftp.ebiotic.net/fromPeat/catalina.out.201010202219.txt
>>>
>>> Could it affect Lucene? Thanks!
>>>
>>
>> I already seen this error but only when running tomcat in Eclipse and
>> each time it go away when i restart and I have absolutely no idea what
>> could be the cause. BTW in my case when i get that there is a lot more
>> that Lucene which does not work.
>>
>
> I'm afraid the we are in trouble here... :-( So, as several issues seems
> to be related here, I think we have to establish some kind of "strategy"
> to identify the problems. I'm not a maven, so what I can do are only
> simple things.
>
> So, as it seems Lucene is, for one or other reason crowding
> catalina.out, I'll remove Lucene Plugin from xwiki.cfg, start a new
> catalina.out, restart the servlet container and see what messages we do
> obtain.
>
> Please, any other idea? Thanks!

As i said this error has absolutely nothing to do with Lucene plugin
and if you have it you have a serious issue.

>
> Cheers,
>
> Ricardo
>
> --
> Ricardo Rodríguez
> CTO
> eBioTIC.
> Life Sciences, Data Modeling and Information Management Systems
>
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] java.io.NotSerializableException

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.
Hi!

Thomas Mortagne wrote:
> On Thu, Oct 21, 2010 at 19:32, [Ricardo Rodriguez] eBioTIC.
>  wrote:
>   
>> Hi!
>>
>> Thomas Mortagne wrote:
>> 
>>> On Thu, Oct 21, 2010 at 00:05, [Ricardo Rodriguez] eBioTIC.
>>>  wrote:
>>>
>>>   
 Hi,

 Our XE/XEM 2.4.1 farm runs in a Tomcat servlet server. Lucene is
 currently not working. I'm trying to understand what messages logged in
 catalina.out could relate to this problem. We get this
 java.io.NotSerializableException during the start up process. See this...

 http://ftp.ebiotic.net/fromPeat/catalina.out.201010202219.txt

 Could it affect Lucene? Thanks!

 
>>> I already seen this error but only when running tomcat in Eclipse and
>>> each time it go away when i restart and I have absolutely no idea what
>>> could be the cause. BTW in my case when i get that there is a lot more
>>> that Lucene which does not work.
>>>
>>>   
>> I'm afraid the we are in trouble here... :-( So, as several issues seems
>> to be related here, I think we have to establish some kind of "strategy"
>> to identify the problems. I'm not a maven, so what I can do are only
>> simple things.
>>
>> So, as it seems Lucene is, for one or other reason crowding
>> catalina.out, I'll remove Lucene Plugin from xwiki.cfg, start a new
>> catalina.out, restart the servlet container and see what messages we do
>> obtain.
>>
>> Please, any other idea? Thanks!
>> 
>
> As i said this error has absolutely nothing to do with Lucene plugin
> and if you have it you have a serious issue.
>   

Those are not good news. The idea of removing Lucene is to clean up a 
bit catalina.out. Now, without Lucene plugin, Java is back to normal, 
XWiki/XWikiPreferences?editor=globaladmin§ion=Search is accessible 
again (even almost useless :-), and we have only a bunch of errors.

Here the whole catalina.out some 20 minutes after the start-up and with 
"normal" use (three, four users browsing some wikis)...

http://ftp.ebiotic.net/fromPeat/catalina.out.201010212026.txt

Well, now, I have no idea about what to do next. Here the situation:

1. We have a recently migrated farms that is working quite nicely 
without Lucene.
2. We have the record of an error on Tomcat start-up process that points 
to a serious issue. I  have no idea about what does this mean at this 
moment.
3. We have some more errors, most of them saying 
'com.xpn.xwiki.XWikiException: Error number 11015 in 11: Exception while 
exporting'.  I  guess those errors are related with some robot wanting 
to export pages available for guest in PDF format. I don't know if this 
error is important or no. I'll report it on Jira.

I think that before going back to Lucene, we must to work-out these 
other exceptions. And perhaps wait until 2.5 is released and try with it.

What I don't know is what else could I do to find the root of the "big" 
error:

2010-10-21 19:57:56,199 [main] ERROR session.ManagerBase - 
IOException while loading persisted sessions: 
java.io.WriteAbortedException: writing aborted; 
java.io.NotSerializableException: 
com.xpn.xwiki.internal.model.reference.CompactWikiStringEntityReferenceSerializer
 

java.io.WriteAbortedException: writing aborted; 
java.io.NotSerializableException: 
com.xpn.xwiki.internal.model.reference.CompactWikiStringEntityReferenceSerializer
...
Caused by: java.io.NotSerializableException: 
com.xpn.xwiki.internal.model.reference.CompactWikiStringEntityReferenceSerializer
...

Any idea? Thanks!

Ricardo

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] using XWQL with additional search criterias by dates

2010-10-21 Thread Eugen Colesnicov

Hi! Maybe somebody can help me.

I need to select some docs with own class. Together I need 3 filters:
1) by class: only "myclass"
2) by property value: where "myproperty" = "myvalue"
3) by date: where doc date = current date - 5 days
I created xwql script with 2 creterias and it's working well:

select obj.name from Document doc, doc.object(mySpace.myClass) as obj where
obj.myProperty like 'myValue' order by obj.name

How need to add one more criteria by date?

Thanks beforehand!
Eugen Colesnicov
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/using-XWQL-with-additional-search-criterias-by-dates-tp5660503p5660503.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] What template does control contentmenu ID items?

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.
Hi!

I would like to modify the appearance of this area entries for guests 
(Export, More Actions and Annotations) allowing these options only for 
registered users. Thus, I would like this area to be empty for guests.

I've been playing with *menuview.vm* both in /templates and 
/skins/colibri to no avail.

Please, what template is controlling this appearance?

Thanks!

Ricardo

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] show/hide attachments, comments, information and history

2010-10-21 Thread Lockie

You probably already know this so I don't know if it helps, but putting

#xwikidata {
display: none;
}

in an attached stylesheet is a way of hiding that stuff, or you could just
put it into colibri.css directly. I guess on a per page basis though that
might be annoying to manage. I hide it on my Main page that way.
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/show-hide-attachments-comments-information-and-history-tp5651431p5660833.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users