Newsletter Studio licence issue

Questions
1

Hi,

Me again!!

I have a couple of questions:

  1. When I go to the administration section, I am seeing that the product is licenced, but the default workspace is showing ‘Trial’ as are any workspaces that I create.
  2. It’s showing who the product is licenced to. We purchased this on behalf of a client, where can I change this?

Thanks again

M

2

Hi @msladeapc

It may be better for you to contact Newsletter Studio re licence questions here:

I’ve tagged @markusjoha so he can see your question here.

Justin

3

Hi @msladeapc!

The overview in the administration section indicates that there is a license installed.

For the license to work for a given workspace both these needs to be true:

  • The workspace key must match the license. If you did a clean install in a new environment and have connected the license in e.g. a development environment - the workspace keys might be different. See our documentation about [workspaces]. If (Workspaces | Documentation | Newsletter Studio) to see how to find out the workspace key. If the keys differ, use the SQL-statement below to ensure that the workspace key matches the key in the license.
  • The hostname configured as Base URL must be found in the license.

// Markus

DECLARE @oldWorkspaceKey AS uniqueidentifier = '1df3ba0b-e17d-4d0f-9dc0-ba2fa03c2678'

DECLARE @newWorkspaceKey AS uniqueidentifier = 'c9865a30-bf93-494a-99f0-cca36d8eb7e1'

BEGIN TRAN

       ALTER TABLE [nsCampaignEmail] NOCHECK CONSTRAINT FK_nsCampaignEmail_nsWorkspace_uniqueKey
       ALTER TABLE [nsTransactionalEmail] NOCHECK CONSTRAINT FK_nsTransactionalEmail_nsWorkspace_uniqueKey
       ALTER TABLE [nsMailingList] NOCHECK CONSTRAINT FK_nsMailingList_nsWorkspace_uniqueKey
       ALTER TABLE [nsRecipient] NOCHECK CONSTRAINT FK_nsRecipient_nsWorkspace_uniqueKey
       ALTER TABLE [nsMailingList] NOCHECK CONSTRAINT FK_nsMailingList_nsWorkspace_uniqueKey

       UPDATE [nsWorkspace] SET [uniqueKey]=@newWorkspaceKey WHERE [uniqueKey] = @oldWorkspaceKey
       UPDATE [nsCampaignEmail] SET [workspaceKey]=@newWorkspaceKey WHERE [workspaceKey] = @oldWorkspaceKey
       UPDATE [nsTransactionalEmail] SET [workspaceKey]=@newWorkspaceKey WHERE [workspaceKey] = @oldWorkspaceKey
       UPDATE [nsRecipient] SET [workspaceKey]=@newWorkspaceKey WHERE [workspaceKey] = @oldWorkspaceKey
       UPDATE [nsMailingList] SET [workspaceKey]=@newWorkspaceKey WHERE [workspaceKey] = @oldWorkspaceKey

       ALTER TABLE [nsCampaignEmail] WITH CHECK CHECK CONSTRAINT FK_nsCampaignEmail_nsWorkspace_uniqueKey
       ALTER TABLE [nsTransactionalEmail] WITH CHECK CHECK CONSTRAINT FK_nsTransactionalEmail_nsWorkspace_uniqueKey
       ALTER TABLE [nsMailingList] WITH CHECK CHECK CONSTRAINT FK_nsMailingList_nsWorkspace_uniqueKey
       ALTER TABLE [nsRecipient] WITH CHECK CHECK CONSTRAINT FK_nsRecipient_nsWorkspace_uniqueKey
       ALTER TABLE [nsMailingList] WITH CHECK CHECK CONSTRAINT FK_nsMailingList_nsWorkspace_uniqueKey

COMMIT TRAN
4

Thanks Markus,

Couple of things:

  1. Where do I get the old Workspace key?
  2. Where do I get the new Workspace key? I see a couple of things in the .lic file:
    1. There are a couple of GUID’s: Data:Workspaces:Key & there’s also a key property in the root. The one in Data:Workspaces:Key is what is set in the production database.
5

Hi!

The workspace key gets automatically created on a fresh install, it will be assigned to the license the first time you download the license or connect it using the UI in the backoffice.

If the workspace key in your .lic file matches the workspace key in production, the problem is most likely hostnames. Are you sure that the “Base URL” configured on the workspace is included in the lic-file?

Hard to share details here i a public forum, but please reach out to me over e-mail I’d be happy to help you markus [at sign here] enkelmedia.se

// Markus