Back

Topic

[KB1236]Not possible to archive in SQL database

Tags: Database, HDS, SQL Server

2 months ago
By LM
Options
Print
Applies to:
PcVue 8.10 to 16
Summary:
This article gives some possible reasons for an archiving problem in a SQL Server database with HDS
Details:

If the traces are activated you could have this kind of error:

CSchTable::AbleToWrite on ‘TRENDTABLE1′ is FALSE ID=’2’

Here’s what we recommend you check in this case:

Is the database created?
By default, the .mdf and .ldf files are located in PcVue’s Databases directory. If you can’t find the files here, check with Microsoft SQL Server Management Studio (SSMS) and the connection string to see if the database exists and where the files are. For example :

image
mage

Is the database full?
The variable SYSTEM.HDS.<DatabaseName>.SpaceUsed is set to 100
The variable SYSTEM.HDS.<DatabaseName>.Paused is set to 1
It exists, but has reached its maximum size. You need to increase its size or purge the oldest records to make room.
It exists, but it has reached a size that exceeds the capabilities of the Express version of SQL Server. SQL Server Express, the free edition of SQL Server, is limited to 4GB per database for versions prior to 2008 R2, and 10GB per database for more recent versions.

Is the hard disk full?
SYSTEM.HDS.<DatabaseName>.DiskFull is set to 1

Is the database connected?
SYSTEM.HDS.<DatabaseName>.Disconn is set to 1

Is the database invalid?
Can SSMS connect to the database and read table records?

Is the table structure correct?
One way to check is to start the project on another workstation and create a new database.

Created on: 23 Jan 2025