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 7.0 Upgrade Guide
Viewed 3190 times since Wed, Jan 4, 2017
Can I use SSL to protect my signage content?
Viewed 1695 times since Thu, Aug 20, 2015
Carousel software version release history
Viewed 1809 times since Tue, Jul 28, 2015
My Live Video Input bulletin is not working (AVermedia PCIe Card)
Viewed 2164 times since Tue, Nov 11, 2014
Where can I find the Carousel manual?
Viewed 2136 times since Mon, Sep 29, 2014
Carousel - Hardware Warranty Terms
Viewed 768 times since Mon, Feb 20, 2017
Can I have a separate SQL server for FrontDoor/Carousel?
Viewed 1801 times since Thu, Nov 13, 2014
Carousel Access Rights in 7.3: what you need to know
Viewed 145 times since Tue, May 1, 2018
Known Issues in Carousel 7.0.0
Viewed 969 times since Tue, Jan 17, 2017