Daktronics

Content Studio: Error 'System.ServiceModel.FaultException: Data Access Error:' when trying to save a presentation

Topic

Receiving error 'System.ServiceModel.FaultException: Data Access Error:'Error:

System.ServiceModel.FaultException: Data Access Error: Violation of PRIMARY KE constraint 'DBO_Files_fileID_PK'. Cannot insert duplicate key in object 'dob.files'.

DD2403500_1.jpg

Environment

  • Product: 
  • Components: Content Studio
  • Control System: Venus 1500 Version 4, Display Studio

Steps

When trying to save the presentation, there is a duplication error happening within the database. 

Option 1: Copy each individual slide in the presentation and paste into new presentation.

  • As each slide is pasted into the new presentation attempt to save it to locate which slide is causing the issue.
  • Once a slide has been identified copy the content of the file and past it Microsoft word.
    • On the home tab click the button that looks like a backwards P with a line through it. This will show you all hidden characters.
  • Look for any extra returns paragraph markers that are between words or letters.
    • After removing all unnecessary hidden characters copy the text and paste it back into content studio making sure to attempt a save.

Option 2: Create a NEW database, attempt to reload existing database follow: How do I use the Nucleus Server Database utility to transfer or save a database?, DD1705994

  • Be sure to save a copy of the current Database, before proceeding with a New Database. There is a potential that the Database is corrupt and will not be functioning so creating a backup may not prove useful.
  • Attempt to reload the Database may resolve the issue. Follow the article above to save the existing and create the new Database.

KB ID: DD2403500

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.