Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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:
Thanks for the answers,
kindest regards and a wonderful weekend,
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:
but the GUID in the init statement chnages on page load meaning that I cannot whitelist a hash for the script.
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 :)
The default tracking should work even if this script is not run / rendered.
Let's debug this together :),
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
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.
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:
url ipAddress userAgent statusCode referrer tampered headers processingStarted processingFinished processingMachine
https://localhost:44366/blog/my-blog-post/ :: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36 200 https://localhost:44366/blog/ 0 Connection=close&Accept=text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9&Accept-Encoding=gzip%2c+deflate%2c+br&Accept-Language=en-GB%2cen-US%3bq%3d0.9%2cen%3bq%3d0.8&Cookie=uMarketingSuiteAnalyticsVisitorId%3dEFbQYNyAtG%2fw%2bkgJV4GT95WF%2fepOtyWUbpw6xhevzWNM%2bvEzT9KCD8vlcjz2YTERjX14UfOjVsWBtAt75s3vFEzGXQ6QWcs033k0vrkxrnecJZlsIIXrJYaSCna%2fw2nG&Host=localhost%3a44366&Referer=https%3a%2f%2flocalhost%3a44366%2fblog%2f&User-Agent=Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f88.0.4324.96+Safari%2f537.36&sec-ch-ua=%22Chromium%22%3bv%3d%2288%22%2c+%22Google+Chrome%22%3bv%3d%2288%22%2c+%22%3bNot+A+Brand%22%3bv%3d%2299%22&sec-ch-ua-mobile=%3f0&upgrade-insecure-requests=1&sec-fetch-site=same-origin&sec-fetch-mode=navigate&sec-fetch-user=%3f1&sec-fetch-dest=document 2021-01-19 22:45:27.920 2021-01-19 22:45:27.933 DESKTOP-65A7075
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!
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!
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted