Exception in reading/writing data to DataSight database

Exception in reading/writing data to DataSight database

Reported: July 26, 2017

Version(s) affected: DataSight 3.0 and above

Issue: Users encounter 'db_owner' permission error intermittently when reading and writing data to a database, especially when a user is trying to add/delete a gauging or level.

Workaround: All DataSight users require read and write permissions to a database. The presented issue is most likely the result of 'db_owner' role not being assigned to the user. A DataSight Administrator user with administrative privileges on the Microsoft SQL Server can grant 'db_owner' permission to a user to prevent this issue. Select the user from Security > Logins and assign a 'db_owner' privilege. Please note that this is different from Database > Security > login.

Resolution: Same as workaround suggested above

Last Updated: July 26, 2017

    • Related Articles

    • Create a DataSight Database

      Click New Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel. Enter Database Database names can be alphanumeric and include spaces and underscore characters. Assign the ...

    • DataSight Database Management

      Manage your Databases Click Database Management in the DataSight Database group of the DataSight Administrator Ribbon. The View & Delete Database window appears in the Main panel. View a Database Select a database from the list of DataSight ...

    • Restore DataSight database

      Thursday, 15 June 2017 Backing up a database and storing it at a secure location is excellent practice for preventing data loss. This is implemented by data houses on a regular basis. DataSight databases can be backed up and restored on the SQL ...

    • DataSight Components

      The following DataSight components are available as a turn key solution with all on-premise DataSight installations. Usage of these components depends upon a user's role and the design of the DataSight system. User who will enter, edit, QA/C and ...

    • DataSight Database Upgrade

      DataSight is continually improving its database functions to deliver optimal solutions to users. For this reason, DataSight Administrator is provided with options to easily carry out the process of upgrading DataSight databases to the latest release. ...