I'm trying to setup uMarketingSuite using an Azure SQL database and ran into an issue when I tried to setup my database.
It looks like there are a few COLUMNSTORE indexes that are part of some of the analytics tables, however the version of SQL server doesn't appear to support that feature. That feature is only supported in Azure SQL Database Premium tiers, Standard tiers - S3 and above, and all vCore tiers
Does this mean I need to use this level of database to use uMarketingSuite, or will it still work without this SQL feature?
Also it looks like the columnstores are in the the Analytics tables, if I just wanted to use the personalization and not care about the analytics, could I use a lower tier database?
I read a little bit more about what this would be doing and it looks like the database should still "work" with out the columnstore indexes, it just may be slow and is more likely to timeout.
Since I'm using this just to demo things right now and so will have very little data, I think it should be fine. But for a production site, I'll be sure to use a more powerful DB to make sure this feature is available.
thanks for your question and we weren't aware that there was a difference between the Azure SQL Databases.
We already created a fallback in our migration for SQL Server 2016 and earlier, so I guess it's should be an easy job to do that for some specific Azure SQL versions as well. And as you posted in your second comment; it's indeed "just" a performance optimization that can also be done by regular indexes (but their a bit slower).
Maybe you can help me out with two things:
Did your installation complete, or did it fail? Hope that it completed and you can use the uMarketingSuite for demo purposes... If not, let me know and I will see how we can create a workaround to get the uMarketingSuite up and running for you
Which version of Azure SQL Database did you try to use?
I have a setup that sounds very similar to this one I didn't notice any problems with the install process but running locally on a dev licence I do not get any analytics results coming through
1) Which version of the uMarketingSuite are you using?
2) To debug the Analytics tracking you can best take a look at the table "uMarketingSuiteAnalyticsRawPageview". Each pageview should be stored in this table.
If no row are stored in that table:
Check you license. Does this include the domain that you are now working on?
Check whether your IP address is not filtered (see the tab "IP Filters)
If rows are stored for each pageview:
Check the columns processingStarted, processingFinished, processingMachine, processingFailed and exception. Are these filled?
I can see that there is no data in the Raw pageview table
In terms of the license I have this site running locally on the domain "da.localhost" and am using the dev license which just has the single 'localhost' domain configured.
Aaah, then that is exactly the problem. If the domain 'localhost' is only configured for localhost, it will only track that domain. No subdomains or anything else.
I've added da.localhost to your dev license as well. If you restart the website it will normally download the new license and then this should work. If not; please redownload the license from your uMarketingSuite profile.
I see Analytic data in uMarketingSuiteAnalyticsRawPageview and the processing columns are filled in.
So far I haven't come across any issues or errors and it appear that everything is working as expected, but I mainly only tested the personalization part.
in the last columns of this table (processingstarted & processingfinished) you see that the processing has been finished.
Debugging step 2 is to look at the processed tables and see if there's any info in there. You could take a look at uMarketingSuiteAnalyticsPageview, uMarketingSuiteAnalyticsPage and uMarketingSuiteAnalyticsSession. If there's no information there we need to find out why these are empty.
If there is information in these tables then you should look at the date range settings of your Analytics reporting. By default "Today" is not shown so that could be why you're not seeing the data:
uMarketingSuite using Azure SQL
I'm trying to setup uMarketingSuite using an Azure SQL database and ran into an issue when I tried to setup my database.
It looks like there are a few COLUMNSTORE indexes that are part of some of the analytics tables, however the version of SQL server doesn't appear to support that feature. That feature is only supported in Azure SQL Database Premium tiers, Standard tiers - S3 and above, and all vCore tiers
Does this mean I need to use this level of database to use uMarketingSuite, or will it still work without this SQL feature?
Also it looks like the columnstores are in the the Analytics tables, if I just wanted to use the personalization and not care about the analytics, could I use a lower tier database?
I read a little bit more about what this would be doing and it looks like the database should still "work" with out the columnstore indexes, it just may be slow and is more likely to timeout.
Since I'm using this just to demo things right now and so will have very little data, I think it should be fine. But for a production site, I'll be sure to use a more powerful DB to make sure this feature is available.
Hi Kevin,
thanks for your question and we weren't aware that there was a difference between the Azure SQL Databases.
We already created a fallback in our migration for SQL Server 2016 and earlier, so I guess it's should be an easy job to do that for some specific Azure SQL versions as well. And as you posted in your second comment; it's indeed "just" a performance optimization that can also be done by regular indexes (but their a bit slower).
Maybe you can help me out with two things:
Thanks for the answers,
kindest regards and a wonderful weekend,
Jeffrey
Hey guys
I have a setup that sounds very similar to this one I didn't notice any problems with the install process but running locally on a dev licence I do not get any analytics results coming through
Okay I think this might be related to our CSP setup.
It looks like uMarketingSuite outputs some JS at the foot of the page:
<script>typeof uMarketingSuite!=="undefined"&&uMarketingSuite.analytics&&uMarketingSuite.analytics.init("60f0cb6d-b848-4d1e-8ab5-11ae038bcb40")</script>but the GUID in the init statement chnages on page load meaning that I cannot whitelist a hash for the script.
Any ideas? L
Hi Kevin & Lachlann,
first question is
1) Which version of the uMarketingSuite are you using?
2) To debug the Analytics tracking you can best take a look at the table "uMarketingSuiteAnalyticsRawPageview". Each pageview should be stored in this table.
If no row are stored in that table:
Check you license. Does this include the domain that you are now working on?
Check whether your IP address is not filtered (see the tab "IP Filters)
If rows are stored for each pageview:
Can you let me know what you find out :)
3) The javascript that is outputted on the page is only to make sure that clientside events can be linked to the correct pageview. These clientside event can be tracked automatically. See https://documentation.umarketingsuite.com/analytics/clientside-events-and-additional-javascript-files/additional-measurements-with-our-ums-analytics-scripts/.
The default tracking should work even if this script is not run / rendered.
Let's debug this together :),
Jeffrey
Hey Jeffrrey
Thanks for your response.
I am on version 1.6.0 at the moment.
I can see that there is no data in the Raw pageview table
In terms of the license I have this site running locally on the domain "da.localhost" and am using the dev license which just has the single 'localhost' domain configured.
I can confirm there are no IP filters setup.
I hope this helps
Cheers L
Aaah, then that is exactly the problem. If the domain 'localhost' is only configured for localhost, it will only track that domain. No subdomains or anything else.
I've added da.localhost to your dev license as well. If you restart the website it will normally download the new license and then this should work. If not; please redownload the license from your uMarketingSuite profile.
Let me know if that works!
Kind regards, Jeffrey
Oh amazing i will give this a go and let you know how it goes.
Thanks Jeffrey!
So far I haven't come across any issues or errors and it appear that everything is working as expected, but I mainly only tested the personalization part.
Aaah, that sounds perfect... I think it also works; maybe a bit slower overtime, but we can fix that at that moment.
Thanks for the feedback!
Hi I know this is an older query but couldn't see any newer and wanted it 'in one spot'.
I am running on localhost, and analytics shows no pageviews either total or on the node itself.
Rawpageviews has data, all fields you mentioned above have data in them here's an example line:
Hi Damien,
in the last columns of this table (processingstarted & processingfinished) you see that the processing has been finished.
Debugging step 2 is to look at the processed tables and see if there's any info in there. You could take a look at uMarketingSuiteAnalyticsPageview, uMarketingSuiteAnalyticsPage and uMarketingSuiteAnalyticsSession. If there's no information there we need to find out why these are empty.
If there is information in these tables then you should look at the date range settings of your Analytics reporting. By default "Today" is not shown so that could be why you're not seeing the data:
Let me know whether this helps!
Jeffrey Schoemaker
Yup, thanks Jeffry. I took a look and the pageviews from yesterday are now showing, I didn't notice that today wasn't being shown.
For future troubleshooting I've written some documentation about Troubleshooting your Analytics-setup: https://documentation.umarketingsuite.com/analytics/troubleshooting-analytics/
If you have any thoughts, or parts that I'm missing, please let me know!
Kind regards,
Jeffrey
is working on a reply...