Mixing
Rest API for Azure SSAS cube refreshment
0
I'm currently trying to create a Rest API to refresh a SSAS cube in Azure. I followed all the steps from this link. Then I'm using that code to refresh the Cube1 :
#r "Microsoft.AnalysisServices.Tabular.DLL"
#r "Microsoft.AnalysisServices.Core.DLL"
#r "System.Configuration"
using System;
using System.Security;
using System.Security.Principal;
using System.Configuration;
using Microsoft.AnalysisServices.Tabular;
public static void Run(TimerInfo myTimer, TraceWriter log)
{
log.Info($"C# Timer trigger function started at: DateTime.Now}");
// try
// {
Microsoft.AnalysisServices.Tabular.Server asSrv = new Microsoft.AnalysisServices.Tabular.Server();
log.Info("Log1");
var connStr = "Provider=MSOLAP;Data Source=asazure://serveraddress; Initial Catalog=Cube1;User ID=*****;Password=*****";
log.Info("Log2");
asSrv.Connect(connStr);
log.Info("Log3");
Database db = asSrv.Databases["Cube1"];
log.Info("Log4");
Model m = db.Model;
m.RequestRefresh(RefreshType.Full); // Mark the model for refresh
db.Model.SaveChanges(); //commit which will execute the refresh
asSrv.Disconnect();
// }
// catch (Exception e)
// {
// log.Info($"C# Timer trigger function exception: {e.ToString()}");
// }
log.Info($"C# Timer trigger function finished at: {DateTime.Now}");
}
Normally everything should be ok but here is my error message :
Could not load type
'System.Security.Principal.WindowsImpersonationContext' from assembly
'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=*****
Any idea to solve this ?
Thanks a lot.
c# rest
azure ssas azure-analysis-services edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
add a comment |
0
I'm currently trying to create a Rest API to refresh a SSAS cube in Azure. I followed all the steps from this link. Then I'm using that code to refresh the Cube1 :
#r "Microsoft.AnalysisServices.Tabular.DLL"
#r "Microsoft.AnalysisServices.Core.DLL"
#r "System.Configuration"
using System;
using System.Security;
using System.Security.Principal;
using System.Configuration;
using Microsoft.AnalysisServices.Tabular;
public static void Run(TimerInfo myTimer, TraceWriter log)
{
log.Info($"C# Timer trigger function started at: DateTime.Now}");
// try
// {
Microsoft.AnalysisServices.Tabular.Server asSrv = new Microsoft.AnalysisServices.Tabular.Server();
log.Info("Log1");
var connStr = "Provider=MSOLAP;Data Source=asazure://serveraddress; Initial Catalog=Cube1;User ID=*****;Password=*****";
log.Info("Log2");
asSrv.Connect(connStr);
log.Info("Log3");
Database db = asSrv.Databases["Cube1"];
log.Info("Log4");
Model m = db.Model;
m.RequestRefresh(RefreshType.Full); // Mark the model for refresh
db.Model.SaveChanges(); //commit which will execute the refresh
asSrv.Disconnect();
// }
// catch (Exception e)
// {
// log.Info($"C# Timer trigger function exception: {e.ToString()}");
// }
log.Info($"C# Timer trigger function finished at: {DateTime.Now}");
}
Normally everything should be ok but here is my error message :
Could not load type
'System.Security.Principal.WindowsImpersonationContext' from assembly
'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=*****
Any idea to solve this ?
Thanks a lot.
c# rest
azure ssas azure-analysis-services edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26
add a comment |
0
0
0
I'm currently trying to create a Rest API to refresh a SSAS cube in Azure. I followed all the steps from this link. Then I'm using that code to refresh the Cube1 :
#r "Microsoft.AnalysisServices.Tabular.DLL"
#r "Microsoft.AnalysisServices.Core.DLL"
#r "System.Configuration"
using System;
using System.Security;
using System.Security.Principal;
using System.Configuration;
using Microsoft.AnalysisServices.Tabular;
public static void Run(TimerInfo myTimer, TraceWriter log)
{
log.Info($"C# Timer trigger function started at: DateTime.Now}");
// try
// {
Microsoft.AnalysisServices.Tabular.Server asSrv = new Microsoft.AnalysisServices.Tabular.Server();
log.Info("Log1");
var connStr = "Provider=MSOLAP;Data Source=asazure://serveraddress; Initial Catalog=Cube1;User ID=*****;Password=*****";
log.Info("Log2");
asSrv.Connect(connStr);
log.Info("Log3");
Database db = asSrv.Databases["Cube1"];
log.Info("Log4");
Model m = db.Model;
m.RequestRefresh(RefreshType.Full); // Mark the model for refresh
db.Model.SaveChanges(); //commit which will execute the refresh
asSrv.Disconnect();
// }
// catch (Exception e)
// {
// log.Info($"C# Timer trigger function exception: {e.ToString()}");
// }
log.Info($"C# Timer trigger function finished at: {DateTime.Now}");
}
Normally everything should be ok but here is my error message :
Could not load type
'System.Security.Principal.WindowsImpersonationContext' from assembly
'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=*****
Any idea to solve this ?
Thanks a lot.
c# rest
azure ssas azure-analysis-services edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
I'm currently trying to create a Rest API to refresh a SSAS cube in Azure. I followed all the steps from this link. Then I'm using that code to refresh the Cube1 :
#r "Microsoft.AnalysisServices.Tabular.DLL"
#r "Microsoft.AnalysisServices.Core.DLL"
#r "System.Configuration"
using System;
using System.Security;
using System.Security.Principal;
using System.Configuration;
using Microsoft.AnalysisServices.Tabular;
public static void Run(TimerInfo myTimer, TraceWriter log)
{
log.Info($"C# Timer trigger function started at: DateTime.Now}");
// try
// {
Microsoft.AnalysisServices.Tabular.Server asSrv = new Microsoft.AnalysisServices.Tabular.Server();
log.Info("Log1");
var connStr = "Provider=MSOLAP;Data Source=asazure://serveraddress; Initial Catalog=Cube1;User ID=*****;Password=*****";
log.Info("Log2");
asSrv.Connect(connStr);
log.Info("Log3");
Database db = asSrv.Databases["Cube1"];
log.Info("Log4");
Model m = db.Model;
m.RequestRefresh(RefreshType.Full); // Mark the model for refresh
db.Model.SaveChanges(); //commit which will execute the refresh
asSrv.Disconnect();
// }
// catch (Exception e)
// {
// log.Info($"C# Timer trigger function exception: {e.ToString()}");
// }
log.Info($"C# Timer trigger function finished at: {DateTime.Now}");
}
Normally everything should be ok but here is my error message :
Could not load type
'System.Security.Principal.WindowsImpersonationContext' from assembly
'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=*****
Any idea to solve this ?
Thanks a lot.
c# rest
azure ssas azure-analysis-services c# rest
azure ssas azure-analysis-services edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
edited Nov 22 '18 at 12:43
Murray Foxcroft
6,25713754
6,25713754
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
asked Nov 22 '18 at 8:53
Mathieu RicourMathieu Ricour
203215
203215
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26
add a comment |
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26
add a comment |
1 Answer
1
active
oldest
votes
0
That looks like you are missing a reference to the nuget package System.Security.Principal
#r "System.Security.Principal"
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427054%2frest-api-for-azure-ssas-cube-refreshment%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
That looks like you are missing a reference to the nuget package System.Security.Principal
#r "System.Security.Principal"
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
add a comment |
0
That looks like you are missing a reference to the nuget package System.Security.Principal
#r "System.Security.Principal"
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
add a comment |
0
0
0
That looks like you are missing a reference to the nuget package System.Security.Principal
#r "System.Security.Principal"
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
That looks like you are missing a reference to the nuget package System.Security.Principal
#r "System.Security.Principal"
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
answered Nov 22 '18 at 9:52
Murray FoxcroftMurray Foxcroft
6,25713754
6,25713754
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
add a comment |
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
It's still the same error. Actually the error occurs after the log2
– Mathieu Ricour
Nov 22 '18 at 12:23
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
Are you deploying all the dependencies? docs.microsoft.com/en-us/bi-reference/tom/…
– Murray Foxcroft
Nov 22 '18 at 12:49
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427054%2frest-api-for-azure-ssas-cube-refreshment%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which row throws the error?
– Itay Podhajcer
Nov 22 '18 at 9:35
asSrv.Connect(connStr); I guess because the run machine displays the "log 2" and then an error
– Mathieu Ricour
Nov 26 '18 at 8:26