Select ALL historical query fails via GUI

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
2 posts • Page 1 of 1
kyle.stotz.ext@siemens.com
Posts:1
Joined: Wed Aug 19, 2020 4:00 pm

Select ALL historical query fails via GUI

Post by kyle.stotz.ext@siemens.com »

I am having trouble using the system management SQL-Query tool to query for historical information.

I find the following in my logfile. How do I find and install the specified missing shared object (using WinCC OA 3.15 running on RedHat)?

WCCOAui (1), 2020.10.29 12:07:31.711, CTRL, INFO, 0, , Couldn't connect to data base xyz, libclntsh.so.12.1: cannot open shared object file: No such file or directory
DBMS API Library 'libclntsh.so.12.1' loading fails
This library is a part of DBMS client installation, not SQLAPI++
Make sure DBMS client is installed and
this required library is available for dynamic loading
Linux/Unix:
1) The directories in the user's LD_LIBRARY_PATH environment variable
2) The list of libraries cached in /etc/ld.so.cache
3) /usr/lib, followed by /lib

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: Select ALL historical query fails via GUI

Post by leoknipp »

Which type of database are you using to store historical data (RAIMA/HDB or RDB)?
The option "SELECT ALL" must not be used. If you want to historical events you have to use "SELECT" and for alerts "SELECT ALERT".

Best Regards
Leopold Knipp
Senior Support Specialist

2 posts • Page 1 of 1