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

Is it possible to re-offload historical trend data from Cassandra to MySQL Snapshot Database?

Solved1.45K views18th May 2021Cassandra central database offload Snapshot
3
Martin Vrzba [DevOps Member]628 11th May 2021 0 Comments

Our DM system running separate Cassandra on every DMA is configured to offload trend data to Central database which is MySQL.

Recently our Central database suffered an outage of 27 hours and even though the data was cached locally on DMs and re-inserted into the Central DB, it got lost anyway due to other reasons.

As the issues were fixed, we’d like to re-import the data for specific elements/parameters in the specific time period from Cassandra to the Snapshot DB. The resolution is one point per 5 minutes, so about 324 data points per parameter (for 27 hours).

A way is to generate the .csv import file and store it in “c:\Skyline DataMiner\System Cache\Offload\Data\” that gets imported fine.

We are able to run a simple query in DevCenter per one parameter, export the data and manually produce the tab-delimited .csv with some data modification, which gets imported successfully. However, it is not feasible to do this for hundreds of elements with ~2-5 parameters per element.

Has anyone encountered similar request before?

Is there a way to automatically re-generate the .csv import files or even direct MySQL INSERT queries for specific Elements, Parameters for a specific Time Period to re-offload the historical trend data to Central MySQL Database?

Or any other ideas how to back-fill the Central DB with trend data?

Thanks for your help.

Martin Vrzba [DevOps Member] Selected answer as best 18th May 2021

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Jeroen Nietvelt [SLC] [DevOps Advocate]1.34K Posted 18th May 2021 0 Comments

Hi Martin,

Unfortunately regenerating these .csv offload files isn't currently part of the standard feature set of DataMiner software. As you pointed out we indeed generate offload files at runtime and will validate if these get inserted successfully into the central database.

In the event of a connection failure towards the central database, the DMA's will locally cache the offload files on the filesystem until the central database connection is restored. At that point the system will automatically resume offloading of the offload files.

In case these insert query itself would fail, we will move the offload files to a "failure" subfolder on the local filesystem of the DMA. This is done to prevent this file from blocking further processing of the offload files. If you as admin resolve the insert issue, you can proceed with moving those offload files from the failure folder back towards their original location where they will be automatically processed again by the offload sequence which runs every 5 minutes (by default)

If you would no longer have access to these offload files and you need to restore the missing dataset on the central database, you will need to create an application which can request the trend data locally from the DMS for the missing data period and have this application populating the necessary .csv offload files.
The easiest way forward would then likely be to create an application which can connect to our DataMiner v1 NBI (SOAP, JSON) and use the get trend data methods on this interface to manually compose the offload .csv files again.

This should allow you to recover the missing information from the DMS and insert it still into the central database.

Martin Vrzba [DevOps Member] Selected answer as best 18th May 2021
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

Multiple Set on Table parameters for DVE’s 0 Answers | 1 Vote
DOM Definition relations returned in Definition query 0 Answers | 1 Vote
Alarm Dashboard PDF/CSV Export 1 Answer | 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 (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) 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