Profile

Brent Alleweireldt

User info

First name Brent
Last name Alleweireldt
Description

Senior DevOps engineer @Skyline Communications

Achievements

Questions asked

Sorry! No question found.

Answers given

Hey Jamie, From the error posted from the SLAutomation log it seems that the system complains of insufficient permissions to send the mail. Could you check that the user you are running the script from...

View Question
10 Votes Selected

The info in the SLDataGateway dump should be enough to link the leak to a certain element or request that is being done. Occasionally it can be useful to look into the memory of the calling process. The...

View Question
9 Votes Selected

Hey Jeff, When an element is deleted, 3 items are added in the Recycle Bin <Date>_Delete_element_views.xml.zip <Date>ElementConnection before delete <element> ElementConnections.xml.zip...

View Question
8 Votes Selected

The refused state means that the dataminer is actively refusing incoming connections. It should clear automatically once the mentioned time has passed. This can happen when the agent is Has had too...

View Question
8 Votes Selected

Hi Jim, For a complete overview of this list you can consult the following article in the Dataminer Help. If the system uses a Central Database or a MySQL local database, then the same information can...

View Question
8 Votes Selected edited answer

To achieve this you have to use the range query (see: Kibana docs) As example: GET dms-info/_search { “query”: { “range”: { “TimeOfArrival” : { "gt":“2020-06-30T13:19:36Z” } } } }

View Question
8 Votes Selected

Hi Tiago, Cassandra generates hint files when it loses connection between agents in a cluster or a write requests times out, these hint files are then used to quickly bring the nodes back up to speed with...

View Question
7 Votes Selected edited answer

In general terms the error means that not enough nodes managed to respond to satisfy the threshold for a successful query. In this case only 1 node needed to respond but it did not. This can be due a number...

View Question
7 Votes Selected edited answer

Hey Javier, SL_LogCollector is a support tool only needed when you try and collect dumps or logging to debug an issue on the system. The only reason to run it in the background like that would be to capture...

View Question
6 Votes Selected

For real time trending it is indeed the case that when a value changes it gets written to the database. For average trending a point is written to the database when: During the window a value change happened...

View Question
6 Votes Selected edited answer

Hi Jamie, A similar case has been done before, utilizing the LoggerTable functionality and Elastic-database. The protocol would collect the data and push it straight to the Loggertable when available...

View Question
6 Votes Selected

Let's tackle each error separately: "Query replication_state failed:…”: is the result of failure on "SELECT id, grp, query FROM replication_state ORDER BY id ASC limit 100". This can be due to a timeout...

View Question
6 Votes Selected edited answer

Hey Joachim, TTL for loggertables in elastic does not operate on the SL_Internal_Timefield. Elastic does not have a way to define TTL on the record level. So to facilitate this we use the index. Notice...

View Question
5 Votes Selected

Hey Bruno, Requirements set by cassandra recommend to avoid shared storage such as SAN for performance reasons. It is better to give each server their own disks. https://cassandra.apache.org/doc/trunk/cassandra/operating/hardware.html#disks

View Question
5 Votes

Hey Jose, Providing a complete solution based on just this snippet of logging will be difficult. It seems that several processes have difficulty contacting the SLDataGateway service. There could be several...

View Question
5 Votes Selected

Hi João Smart baselines are calculated at specific times, for the "continuous degradation" a calculation will happen every 24h. For the "Daily pattern", we do the calculation every 15 minutes. Every...

View Question
5 Votes Selected

The data in the screenshot is calculated from information provided via a "DataMinerPerformanceInfoEventMessage". This event gets it data from various sources (SLWatchdog, SLDataminer,SLNet) depending on...

View Question
5 Votes Selected

Error 0x8004028A is an error defined by the DataMiner system itself, not by Microsoft (All errors between 0x80040200 and 0x8004FFFF are defined by DataMiner, an overview can be found Here). This particular...

View Question
5 Votes Selected edited answer

Is it possible? yes. Will it be more efficient? Probably not. Cassandra will still take all the resources it needs to process the SSTables for a certain table, for a smaller table it might be possible...

View Question
5 Votes Selected

Hey Ryan, This is a strange case. To provide some context, the inter-dma communication is done via the SLNet-service. This service runs under the SYSTEM user and thus does not use a windows user like...

View Question
4 Votes Selected

The Cassandra docs provide a pretty good answer to this. The replication factor does not need to be equal to the number of nodes. it just needs to guarantee availability. Replication factor of 3-5 per...

View Question
4 Votes Selected

Hey Paulo, The failedTokenRanges contains the ranges where there was an issue in migrating the alarms, effectively the alarms in those ranges have NOT been migrated. This could be due to a temporary loss...

View Question
4 Votes Selected

Hey Jeff, You can ignore these alarms. They state that part of your setup is licensed to do stuff for which the setup is not compatible at the moment. As long as you do not plan to use the mentioned functionality,...

View Question
4 Votes Selected

Hi Jeff, This option dictates whether the following objects are included or not UpgradeActions (Entire folder) DowngradeActions (Entire folder) VersionHistory.txt The VersionHistory is useful...

View Question
4 Votes Selected edited answer

Hi Flavio, This error gets thrown when SLXml failed to correctly load a particular XML file. The reason for this could be The file is encrypted and could not be decrypted There is an error in the...

View Question
4 Votes Selected

Hi Miguel, Both rep_pd_states and rep_pd_newalarms are tables primarily used by the SLASPConnection in DataMiner to generate reports. They serve a purpose similar to what the timetrace does in cassandra....

View Question
4 Votes Selected

Hi Jaime, It seems this is caused due an incorrect merge of [ID_29264] into the 9.6-branch To make a long story short, what is supposed to end up in SLErrors.txt is placed on the buffer for SLErrorsInProtocol.txt...

View Question
4 Votes Selected

It seems something is going wrong on type 148 (NT_REGISTER_SLA), which gets called when an SLA has changes to the alarms it listens to to calculate its SLA. The target of this call is SLDataMiner which...

View Question
4 Votes Selected

Hi Fernando, Dataminer will indeed internally update the time. So whilst the value stays the same the internal time will be updated. Other routines such as closing a trendwindow might also be triggered...

View Question
4 Votes Selected

Another issue with an AV was caused by a failover setup and a central McAfee-setup. This McAfee setup used a central management platform to monitor the health of the DMA-servers based on the ip. In a...

View Question
4 Votes

Hi Carlos, This is correct and intentional. A remnant from back in the days where systems were backed by a MySQL database the value of real time trend points were stored ad VARCHAR (as both discreet and...

View Question
3 Votes Selected

Hi Alberto, These kind of alarms get generated when the DataMiner system loses contact with the database. To prevent data loss we then go into a failsafe mode where data is stored on disk (C:\Skyline...

View Question
3 Votes Selected

Hey Bernard, The standalone Elastic tool basically calls the _snapshot API on all the indices that are relevant for DataMiner. Elastic will then proceed to gather the data for the desired indices from...

View Question
3 Votes Selected

Hi Jeff, I had a look at the code and it seems no changes where done between the versions mentioned. The query you posted should occur on both 9.6 and 10.1 so whilst not new it is definitely expected...

View Question
3 Votes Selected

Hey Ciprian, Rest assured, the SLReset tool does not change anything regarding the installed version, no downgrade, or upgradeactions are performed. SLReset only removes the VersionHistory.txt which...

View Question
3 Votes Selected

Hey Blake, Permission issues usually are indicated by the server throwing a DataMinerSecurityException during the call. When the script is run from an element. This exception should end up in the Element...

View Question
3 Votes Selected edited answer

Hey Ryan, The number represents the type of the call. So in this case the CM element is trying to do a NotifyDataMiner to with Type 10073. Now type 10073 internally becomes type 73 (NT_GET_PARAMETER)...

View Question
3 Votes Selected edited answer

Hi Geovanny, The exception means that visual studio fails to find the SLManagedScripting.dll-file or one of the dll that SLManagedScripting relies on. This can happen when the path used in the reference...

View Question
3 Votes

Hey Samuel, Losing connection with the database can indeed cause collectors to not start up properly as DataMiner will fail to read the necessary data from the database. Losing connection with the cassandra...

View Question
3 Votes Selected edited answer

Hey Wale, Part of the inter-process communication (IPC) in DataMiner ends up through pipes, basically 2 processes share some memory through which data can be exchanged. When there is an issue with these...

View Question
3 Votes Selected edited answer

Hey Paulo, Negative values are indeed not supported at this moment, to support this some changes would need to be made in the software. So if this is a requirement, you can request this feature to be...

View Question
3 Votes Selected edited answer

Hey Javier, From an architectural point of view there should be no issues when restarting the DMA whilst cassandra compaction is running. The cassandra is still able to serve queries and thus the DMA...

View Question
3 Votes Selected

Hey Jens, These kind of information events are thrown when an application tries to create an SLNet connection, but fails during the authentication step (checking the credentials). The event will say which...

View Question
3 Votes Selected

Hey Miguel, The "No cookie for ..." is an error thrown by SLAutomation when it fails to find the cookie for a certain procotol. The cookie in this case is an internal reference provided by SLXml to keep...

View Question
3 Votes Selected

Hey Jens, The interesting part of this notice is "the sequence contains no elements". During the HandleElementEventMessage_PreAddToCache we do certain checks only on one DMA, the one with the lowest dma...

View Question
3 Votes Selected

Error 0x80040221 is a DataMiner defined error and means SL_INVALID_DATA. This usually gets thrown when the data sent is either incorrect/incomplete or in an unexpected format. In this case I suspect the...

View Question
3 Votes Selected

Hey Ryan, Alarm_property table gets populated based on the amount of properties that are linked to an element (either directly on the element/service, on the alarm, or as part of the viewtree,...). For...

View Question
3 Votes Selected

The dot happens when a double-value happens to be a whole number (example, 8.00), somewhere down the line a string conversion causes these numbers to parsed to 8., omitting the zeros. Removing this should...

View Question
3 Votes Selected

Hi Carlos, The "unsuccessful connection ...." errors you see in the SLDataminer.txt are mostly irrelevant here, they are a consequence of trying to connect to the dataminer whilst it is starting up....

View Question
3 Votes Selected

Hi Miguel, From a quick test it seemed that this behaviour changed between 10.0.5.0 and 10.0.6.0, in 10.0.6.0 there is a default ApplicationSettings.xml included in the package which was not present before....

View Question
3 Votes Selected

Hi Laurens, Yes, the Temp folder is indeed used during the creation of the backup, temp folder is defined by the environment variables in the following order The TMP environment var The TEMP environment...

View Question
3 Votes Selected edited answer

Hi Terry, This functionality was added in DataMiner version 9.6.13/10.0.0. When adding/editing an element you can add a list of IP addressess under the "Accepted IP address" section. The element will...

View Question
3 Votes Selected

These fields are not stored in MySQL. They are retrieved at runtime from the information template when an alarm is generated or Requested. SLElement will do this when an alarm is created or an open alarm...

View Question
3 Votes Selected

Hi Ive, When a failover agent goes online, the only operation it does on the NIC level is adding the virtual IP, which is done using windows-level calls. Afterwards an ARP request is sent on the network...

View Question
3 Votes Selected edited answer

Stopping the windows SNMP service during an upgrade is an option. You can choose this before you launch the upgrade under the upgrade options. This is done to prevent the service from starting automatically...

View Question

Hey Ciprian, With "the machines are offline" I will assume that you mean that the entire dataminer including SLNet is stopped. First of all, SLReset is a factory reset tool, not a decommission tool....

View Question
2 Votes Selected

Hey Ciprian, The Dataminer Docs has the following to say on this topic. This relates both to syncing in a cluster and syncing to a failover partner.

View Question
2 Votes Selected

Hey Javier, The dropdown you mentioned relates to the type of trendpoint you want to offload. It has no relation or impact on the interval when the data will be actually offloaded. To set the interval...

View Question
2 Votes Selected edited answer

Hey Cirpian, The RefreshThread in SLDataGateway is responsible to keep the most recent datapoint for active trended parameters alive in the cassandra database. This is done so that stable parameters which...

View Question
2 Votes Selected

Hey Paulo, This is currently not possible yet. Currently a backup will restore everything that is contained in the package to the dma. Tinkering with the package and restoring a package on an agent that...

View Question
2 Votes Selected

This exception gets thrown when a query is launched, but the cassandra fails to resolve the permissions this users has. To do so, cassandra will ping the System_auth table and see what is stored in there....

View Question
2 Votes Selected edited answer

Hey Moazzam, Whilst not straightforward, it is possible to do this with Correlation rule on information events. First of all we need to filter out the correct events in our Correlation rule. This can...

View Question
2 Votes Selected

Hey Christhiam, A comprehensive list of the error message and their meaning can be found Here. Initializing the protocol for ELEMENT_NAME failed. General database failure. (hr = 0x80040226) is probably...

View Question
2 Votes Selected

Hey Arunkrishna, There should be an Upgrade folder present in the case of a full backup, in other cases there is no real way to know on which version the backup was taken I think. You can find this...

View Question
2 Votes

Hey Jack, Thank you for the questions, we will try to answer them to the best of our ability. Before we start with the questions, lets first review the types of documents. DataMiner supports 3 types...

View Question
2 Votes Selected

Hey Jeroen, By default Dataminer will use ConsistencyLevel ONE for both single-node and failover setup. This was chosen to ensure database availability in the event of a hardware failure. This can be...

View Question
2 Votes Selected edited answer

Hey Laurens, The thread that handles smart baseline calculations fires every 15 minutes, so for new smart baselines it can take up to 15 minutes before the initial calculation is done (regardless of their...

View Question
2 Votes Selected

Hi Bruno, All trending from an Aggregation rule will be saved under the elementName 'Skyline Generic Aggregator DMA<ID>'. So the easiest way to get this data would be to use the following filter...

View Question
2 Votes Selected changed status

Hi Jeff, It depends on the Database. For MySQL we will indeed periodically check the table and delete all records that are older than the specified time using a DELETE query. For cassandra we use the built...

View Question
2 Votes Selected edited answer

Hi Julian, That error gets thrown whenever a Dynamic Table filter can not be resolved to something sensible. In this case it seems that the filter is launched on table 2000 which only contains '(true)'....

View Question
2 Votes Selected

The ";" seperator is only partly responsible for identifying the different parts in the filter. Other parts such as the presence of a filterkeyword needs to be present as well. Otherwise it is considered...

View Question
2 Votes Selected edited answer

Hey Frederic, The Factory reset tool can be used for this. See https://docs.dataminer.services/user-guide/Reference/DataMiner_Tools/Factory_reset_tool.html for details

View Question
1 Vote Selected

Hi Robin, That action should not be tied to crossing a specific version, the change should happen from 10.3CU4 every time the DMA starts up. The DMA should log the attempt (and issues) in SLDBConnection.txt....

View Question
1 Vote Selected

Hey Filiep, The issue here is caused to to upgrading from a feature version before RN32944, to a main release version containing that RN. RN32944 added a few DLLs in the PreRequisite folder and some changes...

View Question
1 Vote Selected edited answer

Hey Jamie, There is little information to give a full answer, but we can give some information that might help investigation. This type of alarm gets thrown when by SLDataMiner when it has to handle...

View Question
1 Vote Selected

Hey Karel, It seems it DataMiner has issues connection to the NATS server. The impact of this is that various modules in dataminer relying on this will fail. Including the SPI-manager (responsible for...

View Question
1 Vote

Hey Luis, The main issue here is probably caused due to a difference in the MySQL settings between the source server and the destination server. Let us go over each question Why wasn’t the complete...

View Question
1 Vote Selected edited answer

Hey Ryan, These pop up boxes get thrown based on the DataMinerExtendedStateEvent sent by server to the client. These events contain the info on the state and the reason for the change. The disconnected...

View Question
1 Vote Selected

Hey Edson, Seems like something is keeping part of the upgrade package or SLUpgrade.dll in memory (SLNet logging might be more specific). The only workaround would be to figure out what is keeping the...

View Question
1 Vote Selected

Hey Jeroen, Unfortunately resolution at which RT points are offloaded into the Central DataBase is not possible. Neither from cube nor by tinkering with the files. The smallest supported resolution is...

View Question
1 Vote Selected

Hey Jeroen, Database per agent typically gets used in small setups (2 or so agents) where there is very little data and the data is only relevant to the agent it belongs to. Another reason to use database...

View Question
1 Vote Selected

Hey Edgar, That error gets thrown by MySQL (and logged by us) when the feature that allows inserting data from files is disabled on the MySQL server. DataMiner requires this feature to be enabled as it...

View Question
1 Vote Selected edited answer

Hi Alex, The Hosting agent is the ID of the dataminer agent that is currently hosting the element. This can be different than the DMAID of an element (which is the ID of the agent that originally created...

View Question
1 Vote Selected

Hey Luis, That table is used keep the link of an alarm that has had an impact on a service. It is used to populate the "Services" column in the alarm console and to allow filtering on  alarms based on...

View Question
1 Vote Selected

Hi Christhiam Aaron, This is a weird error to encounter. The error indicates there is an issue in the communication between the local SLNet and the Local SNMPAgent-process. From an initial glance it looks...

View Question
1 Vote Selected

Hey Jeroen, All the requirements can be found in this article. In the article you will also find a tool that takes care of the data migration for you, so this takes little effort A step by step guide...

View Question
1 Vote Selected edited answer

This error generally happens when an issue occurs when trying to crawl for all the related objects to this view (elements, childviews, services,....). Most of this happens in SLNet, so the SLNet.txt log...

View Question
1 Vote Selected

Data can take many forms and each have their own purpose. Some tables can contain configuration data which is send to the device. It makes sense to save these so they are persisted between restarts....

View Question
1 Vote

Hey João, The requests look correct and your setup should work from what I can tell. You could check the following SLScheduler.txt logfile Windows event viewer Errors might be reported in there...

View Question
1 Vote Selected

Hey Luís, The SLManagedScripting.txt file gets created as soon as it is needed. This happens when a QAction in a protocol needs to log something. This can happen by either by calling protocol.log() or...

View Question
1 Vote Selected

You can use the client test tool to attach to Cube (Follow->Follow...->Hook into active session->[select Cube in the drop-down]->click OK). When the visual overview is opened, client test tool...

View Question

According to the Amazon documentation, using the AWS Keyspace requires the usage of an SSL/TLS connection to the database. This is currently not possible to configure in Dataminer, not even using workarounds....

View Question
1 Vote Selected

Looks like a failure during the import is not correctly reported to the UI. On the destination DataMiner you can look into the SLDatabase[SLDataMiner].txt logfile for issues regarding the creation of the...

View Question
1 Vote Selected

The errors reported are correct. The definition check is executed by SLDatabase which does not rely on the 'C:\Skyline DataMiner\Tools\CentralTableDefSQLserver.sql' for the definitions. This mismatch can...

View Question
1 Vote Selected

Hey Tiago, This should be possible by using the following features. Use the SLOracle class in SLDatabase if you are connecting to an oracle database. Execute the query using the ScalarQuery() method...

View Question
0 Votes

Hey Rodrigo, It sounds like there is an issue with the .SQLite file used when the cassandra was not reachable. More specifically some lock in there got stuck. If the data is not critical, then I would...

View Question
0 Votes Selected edited answer

Everything seems to be configured correctly. So the only thing I can come up with is that the Visual Studio can find the Remote debugger, but the remote debugger somehow fails to authenticate the user....

View Question
0 Votes

Hi, In the trend data inspector we have 3 columns, the first one is for raw data from the database. The other 2 represent the data that is forwarded towards cube. Since we can access the database data,...

View Question
0 Votes

Hey Ive, Replacing a dead node is a 3-part process.Note that the following procedure is for the standard 2 node failover setup. Custom clusters might need a different process depending on their configuration....

View Question
0 Votes Selected edited answer

If the value does not need to be persisted between element restarts, then you should simply remove the save="true" from the element. This way the value will only be kept in memory but will not be saved...

View Question
-1 Votes