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
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
Go to kuduhttps://<functionappname>.scm.azurewebsites.net/DebugConsole
and navigate toD: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
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
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
10k1728
asked Nov 20 '18 at 7:16
SuryaSurya
114
114
Go to kuduhttps://<functionappname>.scm.azurewebsites.net/DebugConsole
and navigate toD: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
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/DebugConsole
and navigate toD: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
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/DebugConsole
and navigate toD: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
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