View previous topic :: View next topic |
Author |
Message |
sfinch
Joined: 23 Jul 2013 Posts: 2 Location: United Kingdom
|
Posted: Tue Jul 23, 2013 9:50 pm Post subject: Windows Azure Database ILS Setup |
|
|
I have now moved over to the cloud and am using Micosoft's Azure Platform as a Service.
When running the ILS Setup on the Virtual Server and setting the Database connection details I get the following error:
---------------------------
Unhandled Exception
---------------------------
An unhandled exception occurred in LicenseTracker.Installer. Please contact Infralution and provide the information given below:
Exception Type: COMException
Message: Invalid object name 'sysconstraints'.
Stack Trace:
at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)
at Infralution.LicenseTracker.Installer.SqlDatabase.DeleteDefaultConstraint(String table, String column)
at Infralution.LicenseTracker.Installer.SqlDatabase.UpgradeSchema(String schema)
at Infralution.LicenseTracker.Installer.Database.UpgradeSchemaIfRequired()
at Infralution.LicenseTracker.Installer.Database.Install(Database copyFromDatabase, ProgressHandler progressHandler)
at Infralution.LicenseTracker.Installer.MainForm.DoInstall()
at Infralution.LicenseTracker.Installer.MainForm._progressPage_ShowFromNext(Object sender, EventArgs e)
at Infralution.Controls.Wizard.WizardPage.OnShowFromNext(Wizard wiz)
at Infralution.Controls.Wizard.Wizard.Next()
at Infralution.LicenseTracker.Installer.MainForm._upgradePage_ShowFromNext(Object sender, EventArgs e)
at Infralution.Controls.Wizard.WizardPage.OnShowFromNext(Wizard wiz)
at Infralution.Controls.Wizard....
Click OK to exit the application.
I believe that it is to do with Azure not exposing the system objects or having clustered indexing that would normally be available within the standard SQL Server versions.
Could you advise on how I can get ILS to work with the Azure Database.
Thanking you in advance
Simon |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Wed Jul 24, 2013 2:13 am Post subject: |
|
|
Yes the documentation for Azure seems to indicate that it doesn't support all of the system tables of standard SQL Server. I think that this is probably only an issue for the installation script. In this case it is attempting to remove a default constraint that was present in earlier versions of the database schema. I think that we could probably get this working with some minor code changes to the installer. If you are willing to provide us with the connection details for your Azure database then we would be happy to do the work required to get it working. You can email us at support@infralution.com to organise this. _________________ Infralution Support |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Mon Aug 19, 2013 1:44 am Post subject: |
|
|
Thanks for your assistance on sorting out this issue. Version 5.10.0 of ILS has now been released and includes the fixes required to get ILS installed on Azure SQL Server. _________________ Infralution Support |
|
Back to top |
|
|
|