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 for Apple TV Media Constraints
Viewed 1096 times since Thu, Jun 22, 2017
How to Factory Restore a Carousel 260
Viewed 1130 times since Thu, May 4, 2017
Unable to locate Stored Procedures
Viewed 167 times since Tue, Sep 13, 2016
Dynamic Instagram via third-party API Intergration
Viewed 1243 times since Thu, Apr 20, 2017
Videos are not playing
Viewed 2415 times since Mon, Sep 22, 2014
Internet Explorer cannot crop a web picture block.
Viewed 1439 times since Mon, Oct 20, 2014
Can I use SSL to protect my signage content?
Viewed 2380 times since Thu, Aug 20, 2015
How do I change the order in which my bulletins play
Viewed 2350 times since Tue, Nov 4, 2014
Carousel Player For Apple TV
Viewed 2892 times since Fri, Jun 23, 2017
How do I use custom icons for my weather bulletin?
Viewed 1183 times since Fri, May 1, 2015