Export of user data problem

Openfire Openfire Support
1

My OS is W2K Pro and Jive Messenger version is 2.1.5, the Import & Export plugin version is 1.0.

After installed that plugin, when Exporting data, got following exception:

javax.servlet.ServletException: org/jivesoftware/util/XMLWriter

at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl .java:825)

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.j ava:758)

at org.jivesoftware.messenger.plugin.userImportExport.export_002duser_002ddata_jsp ._jspService(export_002duser_002ddata_jsp.java:140)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :215)

at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:7 7)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:78)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:78)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2

Hi rosenjiang,

I apologize for the troubles you’'re having with the plugin. Did you by chance see url=http://www.jivesoftware.org/forums/thread.jspa?threadID=14837this thread[/url] about the troubles another user is having with the plugin? What is interesting, is that he is having problems with the plugin and Linux but it works fine for him on Windows. Since you are posting from China I am guessing you probably have some non-English characters in your user data and it looks like the plugin does not handle them properly. Unfortunately, I have not been able to recreate the problem so figuring out a solution has been difficult. If you would like to private message me your email address I can send you a beta copy of the plugin that gives you the option to output the user data directly to the screen.

Thanks,

Ryan

3

Hi Ryan,

Thanks for your attention, you are very kindly :).

I have read that thread before post this topic. Yes, am form China, my OS character set is GBK, but the user data is English characters :).

Please mailto:rosener_722@hotmail.com or allike@163.com

Best Regards!

-Rosen

4

Hi Rosen,

Thanks for your attention, you are very kindly

.

I am happy to help.

I have read that thread before post this topic.

Yes, am form China, my OS character set is GBK, but

the user data is English characters :).

Interesting. The latest thought is that there is some incompatibility with Messenger 2.1.5 and the plugin, which would explain why you’‘re having troubles with the plugin even though you’'re using Windows.

I have sent you the 1.0.1 beta 4 version of plugin, try it out and let me know how it goes.

Thanks,

Ryan

5

Hi Ryan,

I have received that plugin.

Then update it like this: Server --> Server Manager --> Plugins --> delete 1.0 version first, stop jive messager server, delete userimportexport directory from “C:\Program Files\Jive Messenger\plugins”. start jive messager server again, copy the new “userImportExport.jar” file into “C:\Program Files\Jive Messenger\plugins”. But in Admin Console, the plugin version is “1.0.1 - Beta 3”(sent me a old version? ).

Finally, Export User Data to To Screen, i got the same error form Log Viewer.

2005.06.24 10:02:40 [org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java: 96)

]

javax.servlet.ServletException: org/jivesoftware/util/XMLWriter

at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl .java:825)

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.j ava:758)

at org.jivesoftware.messenger.plugin.userImportExport.export_002duser_002ddata_jsp ._jspService(export_002duser_002ddata_jsp.java:150)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :215)

at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:7 7)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

…

…

Thanks,

-Rosen

6

Hi Rosen,

But in Admin Console, the plugin version is "1.0.1 -

Beta 3"(sent me a old version? ).

Oops, if it has the export to screen option you have the beta 4 version, I must have mislabeled.

Finally, Export User Data to To Screen, i got the

same error form Log Viewer.

2005.06.24 10:02:40

org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:96 )

javax.servlet.ServletException:

org/jivesoftware/util/XMLWriter

at org.apache.jasper.runtime.PageContextImpl.doHandlePage

Exception(PageContextImpl.java:825)

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.j ava:758)

at org.jivesoftware.messenger.plugin.userImportExport.export_002duser_002ddata_jsp ._jspService(export_002duser_002ddata_jsp.java:150)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :215)

at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:7 7)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

This is a new twist. I would really like to look a data that is causing this problem, what database are you using?

Thanks,

Ryan

7

Hi Ryan,

I’‘m very sorry to tell you that, today is Friday, and next day is Saturday. I don’'t work at the weekend.

So the detailed database info i would show you must be next week . I used Oracle 9.0.2 database, and in “jiveuser” table have three pieces record, all of that using English but Chinese.

Sorry for my poor english :).

Best regards!

-Rosen

8

if you have an opportunity (if this is only test server) to upgrade to latest nigthly build of Jive Messenger, you may confirm that there i some incompatibility problem with 2.1.5 and this plugin. Maybe…

9

Hi Rosen/Wroot,

I was finally able to reproduce the error so I’‘ve figured out a fix that will make the plugin work with Messenger 2.1.4 and above. I’'ve sent you both copies (version 1.0.1 beta 5) let me know how it goes.

Thanks,

Ryan

10

Hi Ryan,

Thanks for your contribution !

Export User Data to To Screen successful

Best wishes!

Rosen

11

Hi Rosen

I am happy to hear that the export is working for you. Did you by chance try the export to file option?

If Wroot is also able to get the plugin to work I’'ll have the 1.0.1 version offically posted to the plugins download site.

Thanks,

Ryan

12

i’‘ve got beta 5 version, but i’'ll be able to test it only after two weeks. So you can wait or you can upload it now:)

13

Two weeks???

I probably won’‘t wait that long. I’‘ll do a bit more testing and if I don’‘t run into any more problems I’'ll go ahead and release it.

Thanks,

Ryan

14

Hi Ryan

Export to file successfully. And import to database successfully too !

Thanks,

-Rosen

15

Hi Ryan

I have a big problem, could you help me ?

http://www.jivesoftware.org/forums/thread.jspa?threadID=13920&tstart=0

Thanks,

Rosen

16

this is probably my English, but i said it twice in my thread. I’‘m on vacation, holiday, leave etc. And our server is internal, and i dont want to go back to work just to do testing (and they will make me to do something else, you know them, co-workers). And i’'m little sick now, so i dont want to go anythere. At home i have 2.2 build on win2000. I can try to degrade it to 2.1.5 to test beta 5, but Rosen have already confirmed it working, so… Be patient Two weeks is not so long counting overall Jive Messenger progress time frame

P.S. yes, you should release 1.0.1 without waiting for me

17

Hi Rosen,

Export to file successfully. And import to database

successfully too !

A complete round-trip! Yeah! Thanks so much for your assistance and patience.

~Ryan

18

this is probably my English, but i said it twice in

my thread. I’'m on vacation, holiday, leave etc.

It’'s not your Enlgish, I was just giving you a hard time.

19

Can someone send me a copy of the updated (version beta-5 ) plugin too? I have a need of this plugin currently and unfortunately mgmt wants this piece working. I have read through the threads and I do receive the same errors and sadly none of the suggestions have helped in resolving the issue so I’'m down to updating the plugin. Thanks.

20

Hi wlovins,

The final version of the plugin should hopefully be posted in the next couple of days, but in the interim I’'ve sent you a copy.

Thanks,

Ryan