Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Which database tables are used when defining a logger table?

Solved918 views13th February 2023arrayoptions logger table SLProtocol
7
Brecht Deconinck [SLC] [DevOps Member]1.19K 3rd February 2023 0 Comments

When defining a logger table, according to the documentation, only a limited number of rows is loaded in the SLProtocol process.

https://docs.dataminer.services/develop/devguide/Connector/AdvancedLoggerTables.html

https://docs.dataminer.services/develop/schemadoc/Protocol/Protocol.Params.Param.ArrayOptions-options.html#database

Does this mean that only that limited amount of rows is also stored in the elementdata table?
Or is there never data stored in the elementdata table when using a logger table?
In case there's partial data stored in the elementdata table when using a logger table, should we combine this with the volatile option?

When using a logger table, in what database table can we find the table's data?

Brecht Deconinck [SLC] [DevOps Member] Selected answer as best 13th February 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Michiel Saelen [SLC] [DevOps Enabler]5.63K Posted 6th February 2023 0 Comments

Hi Brecht,

Logger tables are stored in a separate table in the DB created specifically for that element. So it should not be stored in the elementdata table in DB as it is already in a custom table in DB. When opening the element in Cube you will want to see the content of that table asap, this is why a part of the data is stored in the SLProtocol process, so that part can already be returned to the client while other parts can be loaded later through lazy loading if needed. So only a part to avoid blowing up memory in case of large logger tables. That part is in memory to still have reasonable responsiveness when retrieving the table through lazy loading.

The logger table can be stored in Cassandra and/or Elastic. Depending on your use case you might want to choose one over the other. I would recommend using Elastic if there might/can be many elements on a DMS using that logger table. As Cassandra can't cope well with many DB tables (>200).

Brecht Deconinck [SLC] [DevOps Member] Selected answer as best 13th February 2023
You are viewing 1 out of 1 answers, click here to view all answers.
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Alarm Dashboard PDF/CSV Export 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (108) Correlation (68) Cube (150) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (139) driver (65) DVE (55) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (151) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) services (51) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin