not authorized for operation : insufficient access rights for database (Error -44)

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • not authorized for operation : insufficient access rights for database (Error -44)

    Hello,



    a user (rather the only user with write permissions except the admin) has changed his password.

    After that he changed the password in excel via the modeller and also checked "remember password".



    Since that, the database on the server is not connected, when he starts excel.

    E.g. he opens a document with data which is on the server and in the cells just stands "N/V" ("N/A" would be in english)

    Then wants to add a view an gets the error: not authorized for operation : insufficient access rights for database (Error -44)

    Then he opened the modeller and there he saw, that the database is not loaded. So he wanted to load it and got the same error.

    When he edit the server-connection and types his password again and
    saves it, the database will be connected and everything is working.

    But he has to do this steps everytime he uses a different document.



    I also restarted the server, but it has no effect.

    Extracts of logfiles:

    olap_server.log:

    Source Code

    1. 2012-07-04 13:43:55 INFO: Service started succesfully.
    2. 2012-07-04 13:44:10 INFO: user '_internal_suite' logged in
    3. 2012-07-04 13:44:11 INFO: user '_internal_suite' logged in
    4. 2012-07-04 13:44:40 WARNING: error code: 1009 description: not authorized for operation message: login error
    5. 2012-07-04 13:47:12 INFO: user 'xxx' logged in



    tomcat.log:

    Source Code

    1. 012-07-04 13:43:58,437 [Thread-1] INFO org.apache.catalina.loader.WebappClassLoader - validateJarFile(C:\Programme\Jedox\Palo Suite\tomcat\webapps\etlserver\WEB-INF\lib\servlet-api-2.3.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
    2. 2012-07-04 13:44:47,312 [Thread-1] INFO org.apache.catalina.core.StandardContext - Suspicious url pattern: "*.nocache.*" in context [/web-etl] - see section SRV.11.2 of the Servlet specification
    3. 2012-07-04 13:44:48,359 [Thread-1] INFO org.apache.coyote.http11.Http11Protocol - Starting Coyote HTTP/1.1 on http-0.0.0.0-7775
    4. 2012-07-04 13:44:48,500 [Thread-1] INFO org.apache.jk.common.ChannelSocket - JK: ajp13 listening on /127.0.0.1:8010
    5. 2012-07-04 13:44:48,500 [Thread-1] INFO org.apache.jk.server.JkMain - Jk running ID=0 time=0/32 config=null
    6. 2012-07-04 13:44:48,515 [Thread-1] INFO org.apache.catalina.startup.Catalina - Server startup in 76077 ms


    core.log:

    Source Code

    1. [2012/07/04 13:44:03] INFO [core] palo web core server version 3.2.0.4166
    2. [2012/07/04 13:44:04] INFO [ui_backend] handler dispatcher instantiated.
    3. [2012/07/04 13:44:04] INFO [ui_backend] parsing configuration file 'ui_backend_config.xml' ... Ok.
    4. [2012/07/04 13:44:07] INFO [persistence] parsing configuration file 'persistence_settings.xml' ... Ok.
    5. [2012/07/04 13:44:11] INFO [palo] parsing configuration file 'palo_config.xml' ... Ok.
    6. [2012/07/04 13:44:11] INFO [palo] connected to palo master server at ip address '127.0.0.1', port '7921'
    7. [2012/07/04 13:44:20] INFO [php_macro_engine] parsing configuration file 'macro_engine_config.xml' ... Ok.
    8. [2012/07/04 13:44:20] INFO [php_macro_engine] configured 5 php extensions
    9. [2012/07/04 13:44:25] INFO [php_macro_engine] initialized the PHP module and extension(s) with loglevel 'error'
    10. [2012/07/04 13:44:27] INFO [php_macro_engine] registered 98 spreadsheet functions, using '../httpd/app' as the base directory
    11. [2012/07/04 13:44:27] INFO [text metrics] parsing configuration file 'font_config.xml' ... Ok.
    12. [2012/07/04 13:44:30] INFO [core] starting up server.
    13. [2012/07/04 13:44:30] INFO [core] session handler starting up!
    14. [2012/07/04 13:44:30] INFO [core] memory garbage collector starting up!
    15. [2012/07/04 13:44:30] INFO [ui_backend] starting up!
    16. [2012/07/04 13:44:30] INFO [core] ready.
    17. [2012/07/04 13:44:30] INFO [core] Service started succesfully.
    18. [2012/07/04 13:47:12] INFO [ui_backend:ccmd] cmd_login logged in with username xxx
    Display All


    stdout.log attached

    Can you help me, please?

    Best regards,
    Jens
    Files