Dataminer problem: Database connection switched to file offload.

Solved1.24K views
1
2 Comments

Good Morning,

Today we had this error on our DMA: Database connection switched to file offload, we review the dma and we see that the elements dont charge the trending, we restart the dma but always the dma get freeze on 99%, any idea or troubleshooting for this issue?

Regards

Javier Gordon Selected answer as best 7th July 2021
Carlos Trejo commented

Hi Javier,

I would suggest you go to the Local folder and verify the size of this folder. You can find this at C:/Skyline DataMiner/system cache/.

Right click on that folder and if it has thousands of files, rename it to something else (e.g Local_old) then restart your DMA, this should allow your agent to start.

Cheers!
Javier Gordon commented

Hi Carlos,

On saturday we don´t review the size of the folder, but on this moment the folder are empty.

Regards

2 Answers

2
9.19K 0 Comments

Hi Javier,

I'm not an expert, but it sounds like the DMA cannot reach the designated database, and hence it started putting its data into offload files, and hence you cannot charge trend data for elements.  That would be my first intuitive thinking.

Ben

Ben Vandenberghe [SLC] [DevOps Enabler] Answered question 3rd July 2021
You are viewing 1 out of 2 answers, click here to view all answers.