YOUR STORY PLAYS HERE
Home » Categories » Multiple Categories

FrontDoor fails to backup Carousel database

Applies to

  • Carousel 7.0.0 - 7.0.2

Symptoms

  • You receive an error stating "Could not back up database carousel50;multipleactiveresultsets=true. Incorrect syntax near 'multipleactiveresultsets'...."

Cause

This issue is caused by a software bug within the FrontDoor application.  The piece of code that detects the name of the Carousel database within SQL server is incorrectly interpreting the database name as "carousel50;multipleactiveresultsets=true" instead of "carousel50"

Workaround

  1. From the Windows desktop of your server navigate to C:\TRMS\Configuration\ 

    If you don't see a C:\TRMS\Configuration\ folder, check D:\TRMS\Configuration\

  2. Open connectionStrings.config in notepad.
  3. Update connectionString="data source=(local);Integrated Security=SSPI;initial catalog=Carousel50;MultipleActiveResultSets=true;"
    to read
    connectionString="data source=(local);Integrated Security=SSPI;MultipleActiveResultSets=true;initial catalog=Carousel50;"
  4. Save the file
  5. Restart IIS
  6. You should now be able to backup the database.

Additional Information

The TRMS engineering team plans to fix this issue for release in Carousel 7.0.3.  

Custom Fields
  • Bug Status: Pending
0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Carousel operating system compatibility
Viewed 2914 times since Tue, Nov 10, 2015
There is a Tightrope Media Systems bulletin I can’t turn off
Viewed 3706 times since Mon, Sep 22, 2014
RSS Feeds in a Crawl will not Validate with error, "The File Exists"
Viewed 266 times since Wed, Apr 4, 2018
Carousel Security Options
Viewed 254 times since Mon, Apr 16, 2018
Known Issues With Carousel 7 Installer
Viewed 873 times since Tue, Mar 7, 2017
Carousel Player On Windows Stops Cycling Through Bulletins
Viewed 241 times since Tue, Apr 3, 2018
Carousel 7.3.1 Released
Viewed 350 times since Tue, May 22, 2018
How do I update my Carousel software?
Viewed 2741 times since Mon, Sep 22, 2014