Start a conversation

Articles

  • Setting up a Separate Dedicated Database Server for Xinet versions

    Overview To improve the performance and expand the functionality of environments with a large number of assets, a separate dedicated database server should be set up to manage the Venture database, wh...

  • Restoring Database Backups

    Overview   There may be times where you will need to restore a database backup in your system, possibly due to database corruption or hardware issues. To restore database backups, you need to work fro...

  • Scheduling Database Backups

    Overview   The purpose of a backup is to create a copy of data that can be recovered in the event of a primary data failure. Primary data failures can be the result of hardware or software failure, da...

  • Error: "There was an error with the keyword data table" When Adding Data Fields

    Overview There might be cases where you are not able to add Data Fields on WebNative, and you will receive the error message There was an error with the keyword data table as shown below:   You will a...

  • Upgrading MySQL

    Overview This article provides information that can be useful in case you want to manually upgrade the MySQL to a higher version posted on MySQL portal.   Back to top   Information This action is not ...

  • Enabling Database Access from External DB Tools

    Overview You want to connect to your database to retrieve data directly using an external tool(such as HeidiSQL or DBeaver) to export or review the data directly for reporting. You have attempted to c...

  • Reviewing the Xinet Database Schema

    Overview You are attempting to identify the location of a particular field in the Xinet database. You need to review the links between certain tables in the database.   Prerequisites Enabled External ...

  • How to Purge Offline Files in the Database (Xinet)

    Overview On occasion, you might choose to go through some data clean-up. When you do, it's possible to come across a few entries in the database that are tagged as offline. When searching for those as...

  • External Reporting Tools Returning Inconsistent File Paths

    Overview While accessing data from the Xinet database from external reporting tools, you notice some older now non-existent file paths showing. These paths are resulting in duplicate entries within yo...

  • syncvoltodb is not being triggered automatically when files are not synced with the DB

    Overview You notice that syncvoltodb is not triggered automatically after some files have been marked as Online=0. The venture.log confirms that the files are resyncing. Information syncvoltodb is tri...