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

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

JensH

Trainee

Posts: 2

Date of registration: Jul 4th 2012

Wednesday, July 4th 2012, 2:59pm

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

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

tomcat.log:

Source code

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
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
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
2012-07-04 13:44:48,500 [Thread-1] INFO  org.apache.jk.common.ChannelSocket  - JK: ajp13 listening on /127.0.0.1:8010
2012-07-04 13:44:48,500 [Thread-1] INFO  org.apache.jk.server.JkMain  - Jk running ID=0 time=0/32  config=null
2012-07-04 13:44:48,515 [Thread-1] INFO  org.apache.catalina.startup.Catalina  - Server startup in 76077 ms

core.log:

Source code

[2012/07/04 13:44:03] INFO [core] palo web core server version 3.2.0.4166
[2012/07/04 13:44:04] INFO [ui_backend] handler dispatcher instantiated.
[2012/07/04 13:44:04] INFO [ui_backend] parsing configuration file 'ui_backend_config.xml' ... Ok.
[2012/07/04 13:44:07] INFO [persistence] parsing configuration file 'persistence_settings.xml' ... Ok.
[2012/07/04 13:44:11] INFO [palo] parsing configuration file 'palo_config.xml' ... Ok.
[2012/07/04 13:44:11] INFO [palo] connected to palo master server at ip address '127.0.0.1', port '7921'
[2012/07/04 13:44:20] INFO [php_macro_engine] parsing configuration file 'macro_engine_config.xml' ... Ok.
[2012/07/04 13:44:20] INFO [php_macro_engine] configured 5 php extensions
[2012/07/04 13:44:25] INFO [php_macro_engine] initialized the PHP module and extension(s) with loglevel 'error'
[2012/07/04 13:44:27] INFO [php_macro_engine] registered 98 spreadsheet functions, using '../httpd/app' as the base directory
[2012/07/04 13:44:27] INFO [text metrics] parsing configuration file 'font_config.xml' ... Ok.
[2012/07/04 13:44:30] INFO [core] starting up server.
[2012/07/04 13:44:30] INFO [core] session handler starting up!
[2012/07/04 13:44:30] INFO [core] memory garbage collector starting up!
[2012/07/04 13:44:30] INFO [ui_backend] starting up!
[2012/07/04 13:44:30] INFO [core] ready.
[2012/07/04 13:44:30] INFO [core] Service started succesfully.

[2012/07/04 13:47:12] INFO [ui_backend:ccmd] cmd_login logged in with username xxx

stdout.log attached

Can you help me, please?

Best regards,
Jens

JensH has attached the following file: