[opencms-dev] Antwort: Re: Update OpenCMS to OpenCMSS 11.0.2: Error Editng existing Workplace Users
Michael Emmerich
m.emmerich at alkacon.com
Tue Sep 8 14:35:35 CEST 2020
Martin,
the start project of a user is stored in the User Additional Infos, the
key for it is
USERPREFERENCES_workplace-startupsettingsproject
The Project is stored with its name, not the ID.
The key was the same for the older versions of OpenCms, so updating
should not have an effect to it, as those values should kept as they
were. The only problem would be if the project itself does not exist
anymore.
Kind regards,
Michael
Am 08.09.20 um 14:12 schrieb martin.rosenthal at oerag.de:
> Hello Fabian,
>
> thank for your tip. That was the cause for the error.
> After added a project to the user, i can again make changes on the user
> data.
>
> But why is the user get the asignment to a project lost after OpenCms
> update? We have about 600 Users in our production OpenCms. It's arduous
> asigning the useres after update the project again. In which database table
> is stored the assignment of a project to an user?
>
> Regards,
> Martin
> _______________________________
> IT-Anwendungen
>
> Tel.: 0211 529 5775
> Fax: 0211 529 59775
> Email: Martin.Rosenthal at oerag.de
> Internet: www.oerag.de
>
> E-Mail-Newsletter "Rund um Rechtsschutz" – jetzt anmelden:
> www.oerag.de/newsletter
>
> ÖRAG Rechtsschutzversicherungs-AG
> Hansaallee 199, 40549 Düsseldorf
> Vorstand: Jörg Tomalak-Plönzke (Vorsitzender), Andreas Heinsen
> Aufsichtsratsvorsitzender: Dr. Walter Tesarczyk
> Sitz der Gesellschaft: Düsseldorf, Registergericht Düsseldorf HRB 12073
>
> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
>
>
>
> Von: <fhsubscriptions at componio.net>
> An: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> Datum: 08.09.2020 13:08
> Betreff: Re: [opencms-dev] Update OpenCMS to OpenCMSS 11.0.2: Error
> Editng existing Workplace Users
> Gesendet von: opencms-dev-bounces at opencms.org
>
>
>
> Looking at the code it seems that the start project for the old users seems
> to be NULL.
>
> \Fabian
>
>
> See also
> https://github.com/alkacon/opencms-core/blob/branch_11_0_x/src/org/opencms/db/CmsUserSettings.java
>
> ---
>
> // start project
> if (!getStartProject().equals(OpenCms.getWorkplaceManager
> ().getDefaultUserSettings().getStartProject())) {
> try {
> // be sure the project is valid
> if (cms != null) {
> cms.readProject(getStartProject());
> }
> m_user.setAdditionalInfo(
> PREFERENCES
> ...
>
> ---
>
> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-bounces at opencms.org <opencms-dev-bounces at opencms.org> Im
> Auftrag von martin.rosenthal at oerag.de
> Gesendet: Dienstag, 8. September 2020 12:50
> An: The OpenCms mailing list <opencms-dev at opencms.org>
> Betreff: [opencms-dev] Update OpenCMS to OpenCMSS 11.0.2: Error Editng
> existing Workplace Users
>
>
> Hello,
>
> after Updating to OpenCMS 11.0.2 i've got an problem with editing existing
> users. When i made changes at users in the admin workplace e.g. changing
> the default-website, on pushing the save-button i get the error.
>
> ------------------------------------------------------
> java.lang.NullPointerException: null
> at org.opencms.db.CmsUserSettings.save
> (CmsUserSettings.java:1391) ~ [opencms.jar:11.0.2]
> at org.opencms.ui.apps.user.CmsUserEditDialog.saveUserSettings
> (CmsUserEditDialog.java:1438) ~[opencms.jar:11.0.2]
> at org.opencms.ui.apps.user.CmsUserEditDialog.save
> (CmsUserEditDialog.java:799) ~[opencms.jar:11.0.2]
> at org.opencms.ui.apps.user.CmsUserEditDialog$3.buttonClick
> (CmsUserEditDialog.java:1312) ~[opencms.jar:11.0.2]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~ [?:1.8.0_211]
> at sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:62) ~[?:1.8.0_211]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_211]
> at java.lang.reflect.Method.invoke(Method.java:498) ~
> [?:1.8.0_211]
> at com.vaadin.event.ListenerMethod.receiveEvent
> (ListenerMethod.java:499) ~[vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.event.EventRouter.fireEvent
> (EventRouter.java:273) ~ [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.event.EventRouter.fireEvent
> (EventRouter.java:237) ~ [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.AbstractClientConnector.fireEvent
> (AbstractClientConnector.java:1014) ~[vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.ui.Button.fireClick(Button.java:384) ~
> [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.ui.Button$1.click(Button.java:57) ~
> [vaadin-server-8.7.1.jar:8.7.1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~ [?:1.8.0_211]
> at sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:62) ~[?:1.8.0_211]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_211]
> at java.lang.reflect.Method.invoke(Method.java:498) ~
> [?:1.8.0_211]
> at com.vaadin.server.ServerRpcManager.applyInvocation
> (ServerRpcManager.java:155) ~[vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.ServerRpcManager.applyInvocation
> (ServerRpcManager.java:116) ~[vaadin-server-8.7.1.jar:8.7.1]
> at
> com.vaadin.server.communication.ServerRpcHandler.handleInvocation
> (ServerRpcHandler.java:445) [vaadin-server-8.7.1.jar:8.7.1]
> at
> com.vaadin.server.communication.ServerRpcHandler.handleInvocations
> (ServerRpcHandler.java:410) [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.communication.ServerRpcHandler.handleRpc
> (ServerRpcHandler.java:274) [vaadin-server-8.7.1.jar:8.7.1]
> at
> com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest
>
> (UidlRequestHandler.java:90) [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.SynchronizedRequestHandler.handleRequest
> (SynchronizedRequestHandler.java:40) [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.VaadinService.handleRequest
> (VaadinService.java:1602) [vaadin-server-8.7.1.jar:8.7.1]
> at com.vaadin.server.VaadinServlet.service
> (VaadinServlet.java:445)
> [vaadin-server-8.7.1.jar:8.7.1]
> at org.opencms.main.CmsUIServlet.service
> (CmsUIServlet.java:340)
> [opencms.jar:11.0.2]
> at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:741)
> [servlet-api.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:231) [catalina.jar:9.0.30]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:166) [catalina.jar:9.0.30]
> at org.apache.tomcat.websocket.server.WsFilter.doFilter
> (WsFilter.java:53) [tomcat-websocket.jar:9.0.30]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:193) [catalina.jar:9.0.30]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:166) [catalina.jar:9.0.30]
> at org.opencms.main.OpenCmsUrlServletFilter.doFilter
> (OpenCmsUrlServletFilter.java:132) [opencms.jar:11.0.2]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:193) [catalina.jar:9.0.30]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:166) [catalina.jar:9.0.30]
> at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:202) [catalina.jar:9.0.30]
> at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:96) [catalina.jar:9.0.30]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke
> (AuthenticatorBase.java:541) [catalina.jar:9.0.30]
> at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:139) [catalina.jar:9.0.30]
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:92) [catalina.jar:9.0.30]
> at org.apache.catalina.valves.AbstractAccessLogValve.invoke
> (AbstractAccessLogValve.java:678) [catalina.jar:9.0.30]
> at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:74) [catalina.jar:9.0.30]
> at org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:343) [catalina.jar:9.0.30]
> at org.apache.coyote.http11.Http11Processor.service
> (Http11Processor.java:367) [tomcat-coyote.jar:9.0.30]
> at org.apache.coyote.AbstractProcessorLight.process
> (AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.30]
> at org.apache.coyote.AbstractProtocol
> $ConnectionHandler.process
> (AbstractProtocol.java:860) [tomcat-coyote.jar:9.0.30]
> at org.apache.tomcat.util.net.NioEndpoint
> $SocketProcessor.doRun
> (NioEndpoint.java:1598) [tomcat-coyote.jar:9.0.30]
> at org.apache.tomcat.util.net.SocketProcessorBase.run
> (SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.30]
> at java.util.concurrent.ThreadPoolExecutor.runWorker
> (ThreadPoolExecutor.java:1149) [?:1.8.0_211]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run
> (ThreadPoolExecutor.java:624) [?:1.8.0_211]
> at org.apache.tomcat.util.threads.TaskThread
> $WrappingRunnable.run
> (TaskThread.java:61) [tomcat-util.jar:9.0.30]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]
> -------------------------------------
>
> But this happens only with users that are existing before the update. At
> users which i'd created new after the update i can change everything
> without any error.
>
> Has someone the same problem?
>
> As datebase i'm using IBM DB2. As JPA library i'm using openjpa-2.4.0.jar
> which obviously was removed in OpenCMS 11.0.2 and which i've put again in
> the WEB-INF/lib directory of OpenCMS 11.0.2 Could this have any impacts?
>
> Thanks and regards,
> Martin
> _______________________________
> IT-Anwendungen
>
> Tel.: 0211 529 5775
> Fax: 0211 529 59775
> Email: Martin.Rosenthal at oerag.de
> Internet: www.oerag.de
>
> E-Mail-Newsletter "Rund um Rechtsschutz" – jetzt anmelden:
> www.oerag.de/newsletter
>
> ÖRAG Rechtsschutzversicherungs-AG
> Hansaallee 199, 40549 Düsseldorf
> Vorstand: Jörg Tomalak-Plönzke (Vorsitzender), Andreas Heinsen
> Aufsichtsratsvorsitzender: Dr. Walter Tesarczyk Sitz der Gesellschaft:
> Düsseldorf, Registergericht Düsseldorf HRB 12073
>
> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list To change your
> list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
-------------------
Michael Emmerich
Alkacon Software GmbH & Co. KG - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org
More information about the opencms-dev
mailing list