Your acquisition seems to be completely out of control. The database threads are struggling to put the data into the database fast enough.
The beginning of that is that your acquisition threads were set to 200, and your database output threads were set to 4.
Better to set the acquisition threads to 80 and the database output threads to 20.
I think it is important to switch off Events for all the meters until we have stabilized
because on the ACE6000 and SL7000, the only way to read the event log is to read the entire event log
so I'd say, on those meters, maybe we should read the events once a week?
there are more than 10k ACE6000s....
ok, so for now, I'm just going to switch off events on all the meters
>We should read profiles, totals and billing registers for all meters
even events and possibly billing registers, maybe even totals. I think we should focus on profile only for now
because maxdate is profile
so if we want to get the number of meters read to be more quicker, we can do profile only. That is the most important.
of course, without totals, the readings would be wrong, so that is also important.
>Ok
and then once we have profile and totals working, we switch on billing registers
> Ok so profiles and totals for now
well, if we have like, the week end, I'd say, lets focus on only profile. To get back in control.
then later today or early 2moro, we switch on totals
then once totals look good, we switch on billing registers also
ok, bulk edit is going through...
the amount of concurrent queries are a lot more now than yesterday. All the Output threads are busy.
do we have to have the TOU registers in the recon report?
wouldn't it be better to first reconcile the energy totals, before we start getting into the TOU registers?
because the TOU registers are non-standard, meaning there could be config errors or differences on meters. But the default energy registers and global kVA are stock standard, and more of a hard limit te measure the accuracy of the system.
> I needed it in a comprehensive report in order to submit both TOU and NOU meters in that report
all I am saying, is that if you want to prove data integrity, you start from the foundation up, and
you don't build the walls before you lay the foundationthere is a progression to this
> ok, I hear you
you just basically throw it with the kitchen sink and expect everything to work. I have a problem with the basic methodology. For instance, the multiplier that was configured on all the ACE6000 meters by default.
No. You start with a multiplier of 1, make sure you can read everything, and then change it from there as needed.
Also the TOU Calendar that was configured on all the meters by default, even including the Meter Register descriptor, messing up even the Totals as a result. I mean, you even left out the TOUID.
No. You start the meters with NO Calendar configured, and get the basic totals and profile right first, before even configuring a Calendar on the meters, and then you configure it WITHOUT a Meter Register descriptor, and use that report I wrote before to try to reconcile the registers in the meter with the registers in the Calendar.
Also, you even started all the meters with all the sets checked in the Advanced Meter Settings.
No. You start with profile, and work your way up once that reads in fine. You even checked Instrumentation Profile and Billing Registers, when you didn't even know if the meters were programmed for it.
I realize there is value in throwing it with the kitchen sink and then fixing it afterwards.
However, I am a developer, and I don't want my baby to have trauma. Also, since the customer is looking at us, we have a limited tolerance for failure
we are trying to prove data integrity
Also, if we start with a system that is not working, it is difficult to know what is wrong. It is easier to start with a simpler setup, that works, and as we incrementally add things, if it doesn't work or performs badly, we know where to concentrate. It is difficult to troubleshoot a large setup that is not working.
If you want to have a faster rollout, your method does have merit: it is like SpaceX blowing up Starships and learning faster. So we could also explain it to the customer in these terms. Since they wanted to go live quick
ok, I've run the profile only setting for the meters
we're on list sz:6627(6627);csd sz:0;outpbsz:1345)
that means, 6000+ meters still to call in, and 1345 meters in the output buffer
Let me restart the server, and then we see the performance...