IT Pro is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission. Learn more

Scots election review critical of e-counting IT

Electoral Commission finds political considerations had negative influence on e-counting trials and policy framework is under-developed.

The Electoral Commission has published a damning report on the breakdown of procedures that led to chaos during the Scottish local and parliamentary election counts earlier this year.

Widespread reports of 'technical glitches' with a computerised vote counting system used live for the first time during the May elections led to delayed results in at least nine constituencies, while some 150,000 votes were excluded.

The subsequent independent external Commission review, led by elections expert Ron Gould CM, broadly found that political considerations hampered the effectiveness of technology preparation for electronic counting procedures.

The e-counting system, supplied by automated data capture specialist DRS, was bought by the Scottish Parliament last year and went through what was then thought of as a successful testing period before the elections. It also followed the successful use of similar systems in 2001 when the capital's voters went to the polls for the London Assembly.

However, the review found the technical problems on the night had arisen because the database had not updated its internal statistical information on the night.

"Modern databases such as the SQL Server make use of 'intelligent' rules to determine how best to undertake complex processing," said the report. "But because the database had incorrect information about the sizes of various data tables, it had chosen to process the count information in a particularly inefficient manner."

This database glitch meant that the queries that determined whether all ballot papers had been correctly processed could not complete. It also meant that in some cases, the system could not provide progress information within the allotted ten minute slot and therefore the system displayed 'zero' figures.

The review was highly critical of the fact that "this technical problem had not occurred during the testing activities undertaken by DRS or by the Project Board".

It found there were a number of small differences in the configuration of the system for the test and for the actual count that were significant to its operational ability to scale.

For example, the most significant of these differences was that the test configuration only had information relating to the set-up at a single count centre, with 50 entries in the 'contest' table, which related to the total number of wards and constituencies to be counted each centre. But the final configuration used at each count centre contained information relating to all count centres for resilience purposes, which resulted in about 550 entries in the 'contest' table.

The Commission also said the 32 Returning Officers individually responsible for election administration in their constituencies found themselves "swimming upstream" against the introduction of the new technology.

And it said the appointment of one contractor to provide the electronic counting system, using the same technology, equipment and software across the whole of Scotland made it difficult for regionally dispersed Returning Officers to take effective remedial action when problems occurred.


It has subsequently extended its software to include new automated features, like updating of statistics prior to the start of each count; the rebuild of indexes prior to each count starting; and the recompiling of stored procedures prior to each count starting. User level monitoring and early warning of database performance issues arising during the count, with user level capability for corrective actions, have also been added.

The report also called for legislative and policy frameworks that guide electronic counting and better, as well as more comprehensive pilot phases and user acceptance testing.

Featured Resources

Accelerating AI modernisation with data infrastructure

Generate business value from your AI initiatives

Free Download

Recommendations for managing AI risks

Integrate your external AI tool findings into your broader security programs

Free Download

Modernise your legacy databases in the cloud

An introduction to cloud databases

Free Download

Powering through to innovation

IT agility drive digital transformation

Free Download

Most Popular

How to boot Windows 11 in Safe Mode
Microsoft Windows

How to boot Windows 11 in Safe Mode

7 Jun 2022
Attracting and retaining talent through training

Attracting and retaining talent through training

13 Jun 2022
The top programming languages you need to learn for 2022
Careers & training

The top programming languages you need to learn for 2022

23 Jun 2022