How to install DBLogger Add ons

[pedicar]

Dear Colleagues
I should install the DBLogger Add ons on WinccOA 3.13 but I have no clue how to proceed , can you please help me with the procedure?
Thank you very much.

Riccardo

[leoknipp]

Please have a look at the WinCC OA Documentation: Special functions --> DBLogger.
After starting the setup you can find the install option also at Special functions --> DB Logger.

Best Regards
Leopold Knipp
Senior Support Specialist

[pedicar]

Thank you very much Leopold!
So, I completed the procedure in a Linux environment and everything appeared to be fine: the DB Logger button appeared in the Database tab and seems to be enabled; however, when I click on it nothing happens: the configuration window doesn’t pop up and the following messages are dropped in the system log, each time I click

-----------------------------------------------------

WCCOAui (1), 2018.06.27 12:55:42.770, CTRL, WARNING, 54, Unexpected state,
Module: _SysMgm_
Panel: /opt/WinCC_OA/3.13/panels/vision/SystemMgm/sysMgm_TabList.pnl []
Object: 0 named: "icon" of type: PUSH_BUTTON
In reference: vision/SystemMgm/sysMgm_iconview_icon.pnl Group: 7 named: "344_9"
Script: Clicked
Library: /opt/WinCC_OA/3.13/scripts/libs/panel.ctl
Line: 1034, getPanelSize, Cannot open file
/opt/WinCC_OA/3.13/projects/DBloggertest/panels/vision/dbl/dbl_para.pnl
WCCOAui (1), 2018.06.27 12:55:42.770, CTRL, SEVERE, 176, Uncaught exception in thread started at main:
WCCOAui (1), 2018.06.27 12:55:42.770, CTRL, SEVERE, 79, Index out of range,
Module: _SysMgm_
Panel: /opt/WinCC_OA/3.13/panels/vision/SystemMgm/sysMgm_TabList.pnl []
Object: 0 named: "icon" of type: PUSH_BUTTON
In reference: vision/SystemMgm/sysMgm_iconview_icon.pnl Group: 7 named: "344_9"
Script: Clicked
Library: /opt/WinCC_OA/3.13/scripts/libs/panel.ctl
Line: 1035, diSize, 1
Stacktrace:
1: ModuleOnWithPanel(string ModuleName = "WinCC_OA(1)", unsigned x = -2, unsigned y = -2, unsigned w = 0, unsigned h = 0, unsigned iconbar = 1, unsigned menubar = 1, string ResizeMode = "None", string FileName = "vision/dbl ...", string PanelName = "", dyn_string Parameter = ({ 0 items })) at panel.ctl:1035
2: smOpenPanel(string sPanel = "vision/dbl ...", dyn_string dsDollar = ({ 0 items }), string sModule = "") at sysMgm.ctl:57
3: smStartAction(string ident = "344_9") at sysMgm.ctl:681
4: main() at [Module: _SysMgm_ Panel: vision/SystemMgm/sysMgm_TabList.pnl Object: icon Script: Clicked]:3

-----------------------------------

The panel dbl_para.pnl is correctly listed under DBLogger_3.13/Panels/Vision/dbl and it can also be run using a QuickTest Module!
What would you say can be possibly causing this?

Riccardo

[Gertjan van Schijndel]

Looks like a case-sensitive file system issue. In 3.13 the datapoint element '_SysMgm_DB.Items.Filenames' contains 'vision/dbl/dbl_para.pnl' instead of 'vision/dbl/DBL_Para.pnl'.

Perhaps the filenames are incorrect in more cases, so as a workaround you could use the DBLogger subproject from a case-insensitive file system (FAT, iso, cifs, etc).

[leoknipp]

I checked the ASCII files which are used for creating or updating a new database.
In version 3.15 the problem with the "wrong" file name is already solved. When creating a new project in 3.15 the file name will be vision/dbl/DBL_Para.pnl.

To correct it in version 3.13 you can modify the original value for the dp element _SysMgm_DB.Items.Filenames and define the correct (case sensitive) file name vision/dbl/DBL_Para.pnl.
Then you do not have to make any changes in the file system.

Best Regards
Leopold Knipp
Senior Support Specialist

[pedicar]

Thank you very much to both of you!
I implemented Leopold's advice an now I can open up the DB-Logger configuration panel.
However, when I try to carry out the settings for a connection to a MySQL server I get the following error as soon as i pick "MySQL" in the drop-down "type" menu

"This database type is not yet implemented!"



https://www.winccoa.com/fileadmin/image ... _47_29.jpg

Same thing happens if I pick "Oracle" (not that I have one of those) while according to the WebApp documentation for WinCC 3.13



The following database systems are supported under Windows by the DBLogger:

MySQL 5.6.20

MS SQL-Server 2014

Oracle Client 12.1.0.2

The following database systems are supported under Linux by the DBLogger:

MySQL 5.6.20

Oracle Client 12.1.0.2

Paradoxically, it let me pick "MS SQL-Server"!
Is there something else that has to be fixed? Thank you again in advance!