Install Citrix APPDNA with QuickDB on a non-system drive

Written by Ingmar Verheij on July 12th, 2012. Posted in AppDNA

There are two installers available for Citrix AppDNA (former App-DNA Apptitude). Depending on how big of a download you want to obtain and distribute internally, you can choose any of those two. Both installers will result in the same product:

  • AppDNA Enterprise Edition [288MB]
  • AppDNA Enterprise Edition with Quick DB Install [659MB]

The main difference between the two installers is that the ‘with Quick DB install’ includes a database dump of OS images, where you otherwise would have to download and import the OS images manually (which will take around 2 hours).

Database size

Citrix estimates that a base database (with no applications) requires around 3GB of disk space, adding the applications will cause the database to increase. 10GB is reasonable but needs to be considered.Microsoft SQL Server Express (limited to 10GB databases) can be used in a PoC environment.  Source: Citrix AppDNA 6.1 presentation.

 

PoC

I was setting up a demo environment so I choose the ‘with Quick DB Install’ and installed the product on a secondary drive (the system drive wouldn’t have enough free space. All SQL databases are stored on the E: drive.

 

An error occurred

During the installation part where the Quick database is restored I got the error "”Restoring the Quick database failed” and then the installation stopped.

Citrix AppDNA environment - An error occurred

This error message isn’t very informative (but does give a hint) so I figured out how to enable verbose logging of the installation proces (Howto: Citrix AppDNA installation logfiles). In the AppTitudeBusinessLogicVerboseLog.txt  log file the following error was recorded:

 

Apparently (after the AppDNA database is created) it tries to restore the content from the %InstallationFolder%\Server\Bin\AppDNA.tmp to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA. Since the database is stored in E:\MSSQL\DATA, this won’t work.

 

Helping the installer

You can help the Citrix AppDNA installer by restoring the database manually (to the proper location). After you’ve restored the database successfully the installation will detect the database and will upgrade the database.

 

 

You can restore the database via Transact-SQL using the RESTORE command with MOVE and REPLACE option:

If you’re using the Microsoft SQL Server Management Studio don’t forget to select a different database then the AppDNA database (default is master), otherwise the database would be in use. The restore will (probably) be completed within a minute.

Ingmar Verheij

At the time Ingmar wrote this article he worked for PepperByte as a Senior Consultant (up to May 2014). His work consisted of designing, migrating and troubleshooting Microsoft and Citrix infrastructures. He was working with technologies like Microsoft RDS, user environment management and (performance) monitoring. Ingmar is User Group leader of the Dutch Citrix User Group (DuCUG). RES Software named Ingmar RES Software Valued Professional in 2014.

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Tags: , , ,

Comments (1)

  • Sheldon Lachambre
    13 July 2012 at 17:11 |

    Hi Ingmar

    Thank you for the great feedback, I will make sure we address this and improve it in a future release.

    -Sheldon

Leave a comment

*

Donate

%d bloggers like this: