Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Windows Azure Database ILS Setup

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support
View previous topic :: View next topic  
Author Message
sfinch



Joined: 23 Jul 2013
Posts: 2
Location: United Kingdom

PostPosted: Tue Jul 23, 2013 9:50 pm    Post subject: Windows Azure Database ILS Setup Reply with quote

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
View user's profile Send private message Visit poster's website
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Wed Jul 24, 2013 2:13 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Aug 19, 2013 1:44 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group