RAIMA problem, can't Login

[jonred]

Hello,

A client call us today telling that they could't open the excel report.
The excel just got frozen, and reviewing the log i saw this type of messages:

PVSS00ComMan (0), 2020.02.25 10:43:40.121, SYS, INFO, 1, Manager Start, PROJ, RedundanteServer_MLO, V 3.10 - 3.10 SP1 linked at Oct 20 2011 22:58:46
PVSS00ComMan (0), 2020.02.25 10:43:40.126, SYS, INFO, 3, Trying to connect to, (SYS: 0 Data -num 0 CONN: 1) @ TLM-MLO1:4897$TLM-MLO2:4897
PVSS00ComMan (0), 2020.02.25 10:43:40.136, SYS, INFO, 4, Connected to, (SYS: 0 Data -num 0 CONN: 1) @ TLM-MLO1 (127.0.0.1)
PVSS00ComMan (0), 2020.02.25 10:43:40.141, SYS, INFO, 4, Connected to, (SYS: 0 Data -num 0 CONN: 2) @ TLM-MLO2 (12.192.73.12)
PVSS00ComMan (1), 2020.02.25 10:43:40.147, REDU, INFO, 0, , Closing connection to redundant data during initialization, (SYS: 1 Data -num 0 CONN: 1)
PVSS00ComMan (1), 2020.02.25 10:43:40.150, SYS, INFO, 181, Closing connection to (SYS: 0 Data -num 0 CONN: 1)
PVSS00ComMan (1), 2020.02.25 10:43:40.561, SYS, INFO, 6, Initialization by Data Manager finished
PVSS00ComMan (1), 2020.02.25 10:43:40.565, SYS, INFO, 3, Trying to connect to, (SYS: 1 Event -num 0 CONN: 2) @ TLM-MLO2:4998
PVSS00data (0), 2020.02.25 10:43:39.714, SYS, SEVERE, 69, Database error, StVLastVariableUtils, storeVariable, Db : lastval\ValHist -1- Addr : 0 Code : -901
DYNTEXT_VAR 1179648 524288 0
PVSS00data (0), 2020.02.25 10:43:41.145, SYS, INFO, 119, Last error repeated 220 times.
PVSS00data (0), 2020.02.25 10:43:40.141, SYS, INFO, 4, Connected to, (SYS: 1 Ascii -num 1 CONN: 1(R)) @ TLM-MLO1 (::ffff:127.0.0.1)
PVSS00data (0), 2020.02.25 10:43:41.152, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.155, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.158, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.160, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.162, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.164, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.165, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)
PVSS00data (0), 2020.02.25 10:43:41.168, SYS, INFO, 39, Connection lost, MAN: (SYS: 1 Ascii -num 1 CONN: 1(R)), Connection closed
PVSS00ComMan (1), 2020.02.25 10:43:41.169, SYS, WARNING, 39, Connection lost, MAN: (SYS: 0 Data -num 0 CONN: 1), Connection reset by peer (10054)
PVSS00ComMan (1), 2020.02.25 10:43:41.578, SYS, INFO, 101, Connection failed, new attempt in, 20 sec
PVSS00data (0), 2020.02.25 10:43:41.171, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-901 (INTERNAL error: -901
bad dchain
C errno = 0: No error
FILE: dio.c(2270))
PVSS00data (0), 2020.02.25 10:43:42.174, SYS, SEVERE, 69, Database error, StVLastVariableUtils, storeVariable, Db : lastval\ValHist -1- Addr : 0 Code : -901

and this type:

PVSS00data (0), 2020.02.25 10:43:42.179, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-901 (INTERNAL error: -901
bad dchain
C errno = 13: Permission denied
FILE: dio.c(2270)), errno:13 (Permission denied)
PVSS00data (0), 20

20.02.25 10:43:42.183, SYS, SEVERE, 69, Database error, StVLastVariableUtils, storeVariable, Db : lastval\ValHist -1- Addr : 0 Code : -901[/quote]

I have attached the log.

Then, i noticed that the secondary server (is a redudant system) was down, and in the primary server the Data manager state was 3 (Violet).

I decided to reboot the servers, but that kind of messages continued in the initialization, like this one:

"PVSS00data (0), 2020.02.25 12:40:47.540, SYS, SEVERE, 69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-29 (bad ROM error code), errno:13 (Permission denied)"

After the init, all looked like normal, but when triying to initiate the UI, no user is recognized, i always get the "wrong user or password".

I tried the method described here: https://www.winccoa.com/knowledge-base/ ... store.html, but no result.

How can i oslve this problem? and what was the cause?

Thank you very much

Best regards

[leoknipp]

The Knowledge base article refers to a different problem. The log messages in the article are not the same as in your project. When you get RAIMA errors you have to read several log entries to get the full information.

In the project it looks like the database part for the original values /(lastval directory) is corrupted. As the usernames and passwords are stored as original values you probably get the information that the username and password is wrong.
If there is a chance to fix the problem we cannot see only by reading the log messages.

Best Regards
Leopold Knipp
Senior Support Specialist

[jonred]

Hello,

Finally, i just recovered the last backup of the database and all went OK.

I don't know why could the DB got corrupted. My only clue is that, apparently, there was a power cut off thar affected the secondary server. This cicrcunstance could lead to the DB corruptio?

Thank you.

[leoknipp]

A power cut of the machine where WinCC OA is running can lead to a corrupted database.
Also parts of the operating system or other files which are in access when the power is cut can be affected leading to other problems with the machine.
Therefore it is recommended to install a UPS on a plant system.

Best Regards
Leopold Knipp
Senior Support Specialist

[jonred]

Thank you Leopold