![\"\"](\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2012\/07\/AppDNA-logo2.jpg\" "\\"\\""){kind=logo}
<\/p>\n<\/p>\n
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:<\/p>\n
<\/p>\n 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.<\/em><\/p>\n <\/p>\n I was setting up a demo environment so I choose the \u2018with Quick DB Install\u2019 and installed the product on a secondary drive (the system drive wouldn\u2019t have enough free space. All SQL databases are stored on the E: drive.<\/p>\n <\/p>\n During the installation part where the Quick database is restored I got the error "\u201dRestoring the Quick database failed<\/strong><\/em>\u201d and then the installation stopped. <\/p>\n 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<\/a>). In the AppTitudeBusinessLogicVerboseLog.txt<\/strong> log file the following error was recorded:<\/p>\n <\/p>\n Apparently (after the AppDNA database is created) it tries to restore the content from the %InstallationFolder%\\Server\\Bin\\AppDNA.tmp <\/em><\/strong>to C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA<\/em><\/strong>. Since the database is stored in E:\\MSSQL\\DATA<\/em><\/strong>, this won\u2019t work.<\/p>\n <\/p>\n <\/p>\n![\"\"](\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2012\/07\/Citrix-AppDNA-Operating-systems.png\" "\\"\\"")
<\/a>The main difference between the two installers is that the \u2018with Quick DB install\u2019 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).<\/p>\nDatabase size<\/h2>\n
PoC<\/h2>\n
<\/a><\/a><\/p>\nAn error occurred<\/h2>\n
<\/a><\/p>\n11-7-2012 14:17:57: Restoring db: RESTORE DATABASE [AppDNA]\n FROM DISK = 'E:\\Program Files (x86)\\Citrix\\AppDNA\\Server\\Bin\\AppDNA.tmp'\n WITH REPLACE\n timeout: 6000\n11-7-2012 14:17:57: ExecuteScalarNoTran connection string: Data Source=SERVER01;Initial Catalog=master;Integrated Security=False;Persist Security Info=False;User ID=AppDNA;Enlist=False;Pooling=False;Connect Timeout=15;Application Name="AppDNA Configuration Wizard"\n11-7-2012 14:17:59: Directory lookup for the file "C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA.mdf" failed with the operating system error 3(The system cannot find the path specified.).\nFile 'AppDNA' cannot be restored to 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA.mdf'. Use WITH MOVE to identify a valid location for the file.\nDirectory lookup for the file "C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).\nFile 'AppDNA_log' cannot be restored to 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA_log.LDF'. Use WITH MOVE to identify a valid location for the file.\nProblems were identified while planning for the RESTORE statement. Previous messages provide details.\nRESTORE DATABASE is terminating abnormally.\n11-7-2012 14:17:59: AppDNA.ASM.Common.Exceptions.ASMException: Restoring the Quick database failed. ---> AppDNA.ASM.Common.Exceptions.ASMException: Restoring the Quick database failed. ---> System.Data.SqlClient.SqlException: Directory lookup for the file "C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA.mdf" failed with the operating system error 3(The system cannot find the path specified.).\nFile 'AppDNA' cannot be restored to 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA.mdf'. Use WITH MOVE to identify a valid location for the file.\nDirectory lookup for the file "C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).\nFile 'AppDNA_log' cannot be restored to 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\AppDNA_log.LDF'. Use WITH MOVE to identify a valid location for the file.\nProblems were identified while planning for the RESTORE statement. Previous messages provide details.\nRESTORE DATABASE is terminating abnormally.\n at AppDNA.ASM.SystemCheck.Database.ExecuteScalarNoTran(DatabaseConfig db, String aSQLStatement, Boolean throw_exceptions)\n at AppDNA.ASM.SystemCheck.Database.RestoreDatabaseFromStockBackup(DatabaseConfig db)\n --- End of inner exception stack trace ---\n at AppDNA.ASM.SystemCheck.Database.RestoreDatabaseFromStockBackup(DatabaseConfig db)\n at AppDNA.ASM.SystemCheck.Database.CreateQuickDb(DatabaseConfig db)\n at AppDNAConfigurationWizard.DataClasses.DatabaseDataDoer.Run()\n --- End of inner exception stack trace ---\n at AppDNAConfigurationWizard.DataClasses.DatabaseDataDoer.Run()\n at AppDNAConfigurationWizard.DataClasses.ConfigurationDataDoer.TaskWorker(AsyncOperation async, CancelInfo asyncContext, Boolean& cancelled)<\/pre>\n
<\/h2>\n
Helping the installer<\/h2>\n
<\/a>You can help the Citrix AppDNA installer by restoring the database manually (to the proper location). After you\u2019ve restored the database successfully the installation will detect the database and will upgrade the database.<\/p>\n