DB permission errors

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
6 posts • Page 1 of 1
winthrop.polk
Posts:15
Joined: Thu May 06, 2021 1:34 pm

DB permission errors

Post by winthrop.polk »

Hello,

I am getting the below errors fairly randomly. my just is just to install the software in production, it was developed remotely. It has not been going well at all. Does anyone have any clues?

[EDIT] It's so bizarre... I install this application and project files the same way over and over again, sometimes I end up with this error and sometimes I do not; sometimes the project will not start, sometimes it will, sometimes it will only start at the CLI, sometimes it will only start at the GUI. At the moment, when I run through the install process everything is fine... on the last iteration I tried to delete everything I could think of, I even removed /opt/WinCC_OA, so I am guessing what is happening is that things are getting corrupted for various reasons (likely depending who starts it and how and if it already happens to be running) and leftover artifacts after I do a rollback are keeping it messed up.

Are there any better formal docs such as: Installation procedure, rollback procedure, troubleshooting, deployment testing, etc for WinCC OA, general projects and/or demo projects? i.e. a way to check that everything is working as the Vendor intended before we start imparting our unique project or ways of doing things on the systems we are trying to deploy?

Code: Select all

WCCOAtoolLogViewer1:ATTENTION: default value of option vblank_mode overridden by environment.
WCCILpmon    (1), 2021.08.17 08:59:28.464, SYS,  INFO,       20/pmon, Got START_ALL command from ::1, starting the project
WCCILpmon    (1), 2021.08.17 08:59:28.464, SYS,  INFO,        1, Manager Start, /opt/WinCC_OA/3.16/bin/WCCILdata -PROJ SSEN_HV -pmonIndex 1 
WCCILdata    (0), 2021.08.17 08:59:28.575, SYS,  INFO,        1, Manager Start, PROJ, SSEN_HV, V 3.16 - 3.16   platform Linux x86_64 linked at Jun 21 2018 16:07:45 (c2ee5ad24d7)
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  INFO,        0, , (Re)Opening databases in single user mode without transaction logging.
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.576, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:28.577, IMPL, SEVERE,     54, Unexpected state, DataManDpIntern, init, Datenbank konnte nicht geoeffnet werden!
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  INFO,        0, , Loading DpIdentification
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-1 (PROGRAMMER/USER error: -1
database not opened
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-27 (PROGRAMMER/USER error: -27
transaction not active
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:28.577, SYS,  SEVERE,     66, Error when connecting, DataManager, initialize
WCCILdata    (0), 2021.08.17 08:59:30.579, SYS,  INFO,        2, Manager Stop
WCCILpmon    (1), 2021.08.17 08:59:30.581, SYS,  INFO,       11/pmon, Detected stopped manager WCCILdata(0) - restarting it #1
WCCILpmon    (1), 2021.08.17 08:59:30.581, SYS,  INFO,        1, Manager Start, /opt/WinCC_OA/3.16/bin/WCCILdata -PROJ SSEN_HV -pmonIndex 1 
WCCILdata    (0), 2021.08.17 08:59:30.590, SYS,  INFO,        1, Manager Start, PROJ, SSEN_HV, V 3.16 - 3.16   platform Linux x86_64 linked at Jun 21 2018 16:07:45 (c2ee5ad24d7)
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  INFO,        0, , (Re)Opening databases in single user mode without transaction logging.
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.591, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:30.592, IMPL, SEVERE,     54, Unexpected state, DataManDpIntern, init, Datenbank konnte nicht geoeffnet werden!
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  INFO,        0, , Loading DpIdentification
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-1 (PROGRAMMER/USER error: -1
database not opened
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-27 (PROGRAMMER/USER error: -27
transaction not active
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:30.592, SYS,  SEVERE,     66, Error when connecting, DataManager, initialize
WCCILdata    (0), 2021.08.17 08:59:32.594, SYS,  INFO,        2, Manager Stop
WCCILpmon    (1), 2021.08.17 08:59:32.596, SYS,  INFO,       11/pmon, Detected stopped manager WCCILdata(0) - restarting it #2
WCCILpmon    (1), 2021.08.17 08:59:32.596, SYS,  INFO,        1, Manager Start, /opt/WinCC_OA/3.16/bin/WCCILdata -PROJ SSEN_HV -pmonIndex 1 
WCCILdata    (0), 2021.08.17 08:59:32.607, SYS,  INFO,        1, Manager Start, PROJ, SSEN_HV, V 3.16 - 3.16   platform Linux x86_64 linked at Jun 21 2018 16:07:45 (c2ee5ad24d7)
WCCILdata    (0), 2021.08.17 08:59:32.607, SYS,  INFO,        0, , (Re)Opening databases in single user mode without transaction logging.
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:32.608, IMPL, SEVERE,     54, Unexpected state, DataManDpIntern, init, Datenbank konnte nicht geoeffnet werden!
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  INFO,        0, , Loading DpIdentification
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-1 (PROGRAMMER/USER error: -1
database not opened
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-27 (PROGRAMMER/USER error: -27
transaction not active
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:32.608, SYS,  SEVERE,     66, Error when connecting, DataManager, initialize
WCCILdata    (0), 2021.08.17 08:59:34.611, SYS,  INFO,        2, Manager Stop
WCCILpmon    (1), 2021.08.17 08:59:34.612, SYS,  INFO,       11/pmon, Detected stopped manager WCCILdata(0) - restarting it #3
WCCILpmon    (1), 2021.08.17 08:59:34.612, SYS,  INFO,        1, Manager Start, /opt/WinCC_OA/3.16/bin/WCCILdata -PROJ SSEN_HV -pmonIndex 1 
WCCILdata    (0), 2021.08.17 08:59:34.622, SYS,  INFO,        1, Manager Start, PROJ, SSEN_HV, V 3.16 - 3.16   platform Linux x86_64 linked at Jun 21 2018 16:07:45 (c2ee5ad24d7)
WCCILdata    (0), 2021.08.17 08:59:34.622, SYS,  INFO,        0, , (Re)Opening databases in single user mode without transaction logging.
WCCILdata    (0), 2021.08.17 08:59:34.622, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-905 (SYSTEM/OS error: -905
error opening data or key file
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCILdata    (0), 2021.08.17 08:59:34.623, IMPL, SEVERE,     54, Unexpected state, DataManDpIntern, init, Datenbank konnte nicht geoeffnet werden!
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  INFO,        0, , Loading DpIdentification
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-1 (PROGRAMMER/USER error: -1
database not opened
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-27 (PROGRAMMER/USER error: -27
transaction not active
C errno = 13: Permission denied), errno:13 (Permission denied)
WCCILdata    (0), 2021.08.17 08:59:34.623, SYS,  SEVERE,     66, Error when connecting, DataManager, initialize
WCCILdata    (0), 2021.08.17 08:59:36.625, SYS,  INFO,        2, Manager Stop
WCCILpmon    (1), 2021.08.17 08:59:36.627, SYS,  SEVERE,      7/pmon, The manager WCCILdata(0) did not start correctly! Stopping the startup sequence and waiting for commands
Top
kilianvp
Posts:443
Joined: Fri Jan 16, 2015 10:29 am

Re: DB permission errors

Post by kilianvp »

Does the used user have read/write permissions for the db folder?
Top
winthrop.polk
Posts:15
Joined: Thu May 06, 2021 1:34 pm

Re: DB permission errors

Post by winthrop.polk »

yes. I even did a "chmod 777 -R /opt/WinCC_OA/" and confirmed just to be certain of this.

Ultimately, I am starting to get a better idea of the issues I am facing. I am really just the Deployment and Test Engineer on this stuff, I haven't dug into these project files... so I am continuously uninstalling and reinstalling it in an effort to get a repeatable process. When uninstalling, the /opt/WinCC_OA as well as the file /etc/opt/pvss/pvssInst.conf are left behind by the WinCC OA uninstallers, also the uninstallers DO NOT appear to first shutdown their relevant running processes and X11 windows before uninstalling happens... so I think leftover files were causing some kind of corruption issue. When I deleted the app folder & pvssInst.conf, these DB errors I can no longer reproduce (which is nice).

Worth noting that pvssInst was definitely causing a minor issue "Missing or erroneous progs- or config file" since in once case I installed with the demo projects, started WinCC OA (which filled this file), uninstalled (with the file left behind) and then reinstalled this time without demo projects.

I think I got past this... if it happens again, I think this rollback operation will succeed and I can avoid it during install.
Top
kilianvp
Posts:443
Joined: Fri Jan 16, 2015 10:29 am

Re: DB permission errors

Post by kilianvp »

There are always leftovers that remain. Not every user wants his files to be deleted. Doing chmod & chown after install is always a good idea.

The installer does not check if projects are running. To finish the project cleanly, the installer would have to run with the same user that starts the installer. This is all too complicated. Therefore, the user must stop the project.
Top
winthrop.polk
Posts:15
Joined: Thu May 06, 2021 1:34 pm

Re: DB permission errors

Post by winthrop.polk »

Well, these are standard issues with common solutions I do believe... generally when I uninstall skype, NTP or any other package it handles the checks to ensure windows are closed, processes are stopped, services are removed and registries are corrected... Otherwise the user is left in an unpredictable state, which is dangerous for this application I would think.

Thus, I would at least note the artifacts that remain in the docs and explain how they may affect a future re-install action (I haven't found/read the uninstall section yet but will look soon) and I would at least prompt the user "uninstaller cannot run because you have WinCC OA processes running and or windows open, please blah blah and try again".
Top
leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: DB permission errors

Post by leoknipp »

Normally WinCC OA is only installed once and there is no need to uninstall/install it several times.
Only when applying a patch an additional installation is done.
It is the standard use case that all WinCC OA processes are stopped properly before applying changes to the WinCC OA installation.

There is no need to do a chmod/chown for the files of a project or the WinCC OA installation.
You only have to ensure that the user which is used to start the WinCC OA processes has sufficient permissions for the project directory and the log directory of the WinCC OA installation.

For detailed information please check the WinCC OA Documentation.

Best Regards
Leopold Knipp
Senior Support Specialist
Top
6 posts • Page 1 of 1

Return to “Bugs / Problems”