Mixing
Azure web app function not triggering through crontab
I want to implement timer based trigger based on the below article.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/manage-compute-with-azure-functions
I followed and completed each and every step. As i selected "India standard time" in template deployment, i gave the cron schedule as per Indian time. However, the scale up function did not trigger as per the scheduled time.
Can we see if any error has occurred. What could be the reason..Please reply..Let me know if any inputs are required
Edit
It gave me the error
The client 'client id' with object id 'object id' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/subscriptionid/resourceGroups/rgname/providers/Microsoft.Sql/servers/dwhserver/databases/DWH_Name
Please suggest way forward
Thanks in advance
azure azure-active-directory edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
add a comment |
I want to implement timer based trigger based on the below article.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/manage-compute-with-azure-functions
I followed and completed each and every step. As i selected "India standard time" in template deployment, i gave the cron schedule as per Indian time. However, the scale up function did not trigger as per the scheduled time.
Can we see if any error has occurred. What could be the reason..Please reply..Let me know if any inputs are required
Edit
It gave me the error
The client 'client id' with object id 'object id' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/subscriptionid/resourceGroups/rgname/providers/Microsoft.Sql/servers/dwhserver/databases/DWH_Name
Please suggest way forward
Thanks in advance
azure azure-active-directory edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
Go to kuduhttps://<functionappname>.scm.azurewebsites.net/DebugConsoleand navigate toD:homeLogFilesApplicationFunctionsHostfor detailed logs.
– Jerry Liu
Nov 20 '18 at 7:35
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56
add a comment |
I want to implement timer based trigger based on the below article.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/manage-compute-with-azure-functions
I followed and completed each and every step. As i selected "India standard time" in template deployment, i gave the cron schedule as per Indian time. However, the scale up function did not trigger as per the scheduled time.
Can we see if any error has occurred. What could be the reason..Please reply..Let me know if any inputs are required
Edit
It gave me the error
The client 'client id' with object id 'object id' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/subscriptionid/resourceGroups/rgname/providers/Microsoft.Sql/servers/dwhserver/databases/DWH_Name
Please suggest way forward
Thanks in advance
azure azure-active-directory edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
I want to implement timer based trigger based on the below article.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/manage-compute-with-azure-functions
I followed and completed each and every step. As i selected "India standard time" in template deployment, i gave the cron schedule as per Indian time. However, the scale up function did not trigger as per the scheduled time.
Can we see if any error has occurred. What could be the reason..Please reply..Let me know if any inputs are required
Edit
It gave me the error
The client 'client id' with object id 'object id' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/subscriptionid/resourceGroups/rgname/providers/Microsoft.Sql/servers/dwhserver/databases/DWH_Name
Please suggest way forward
Thanks in advance
azure azure-active-directory azure azure-active-directory edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
edited Nov 20 '18 at 10:25
Jerry Liu
10k1728
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
asked Nov 20 '18 at 7:16
SuryaSurya
114
asked Nov 20 '18 at 7:16
SuryaSurya
114
114
Go to kuduhttps://<functionappname>.scm.azurewebsites.net/DebugConsoleand navigate toD:homeLogFilesApplicationFunctionsHostfor detailed logs.
– Jerry Liu
Nov 20 '18 at 7:35
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56
add a comment |
Go to kuduhttps://<functionappname>.scm.azurewebsites.net/DebugConsoleand navigate toD:homeLogFilesApplicationFunctionsHostfor detailed logs.
– Jerry Liu
Nov 20 '18 at 7:35
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56
Go to kudu
https://<functionappname>.scm.azurewebsites.net/DebugConsole and navigate to D:homeLogFilesApplicationFunctionsHost for detailed logs.– Jerry Liu
Nov 20 '18 at 7:35
Go to kudu
https://<functionappname>.scm.azurewebsites.net/DebugConsole and navigate to D:homeLogFilesApplicationFunctionsHost for detailed logs.– Jerry Liu
Nov 20 '18 at 7:35
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53388000%2fazure-web-app-function-not-triggering-through-crontab%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53388000%2fazure-web-app-function-not-triggering-through-crontab%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
Go to kudu
https://<functionappname>.scm.azurewebsites.net/DebugConsoleand navigate toD:homeLogFilesApplicationFunctionsHostfor detailed logs.– Jerry Liu
Nov 20 '18 at 7:35
It gave me the error "The client '<<client id>>' with object id '<<object id>>' does not have authorization to perform action 'Microsoft.Sql/servers/databases/write' over scope '/subscriptions/<<subscriptionid>>/resourceGroups/<<rgname>>/providers/Microsoft.Sql/servers/<<dwhserver>>/databases/<<DWH_Name>>" Please suggest way forward
– Surya
Nov 20 '18 at 9:04
Have you Provisioned an Azure Active Directory administrator for data warehouse?
– Jerry Liu
Nov 20 '18 at 9:35
No.can you just tell what is it for..Is it necessary
– Surya
Nov 20 '18 at 9:41
Should be necessary since the tutorial uses AAD authentication with Sql.
– Jerry Liu
Nov 20 '18 at 9:56