|
Home > Archive > BizTalk Server > July 2004 > Execute batch error. (Stored Procedures, BTS 2004)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Execute batch error. (Stored Procedures, BTS 2004)
|
|
| Håkan Thornqvist 2004-07-14, 2:46 am |
| Hi all.
I've set up an orchestration and deployed it. It runs fine, but every time the process runs I get an error in the event log.
Source: BAM EventBus Service
Execute event error. Error(s) occurred while executing events, see TDDS_FailedTrackingData table for more details. SQLServer: <Server>\BTS2004, Database: BizTalkDTADb.
And here's the details from TDDS_FailedTrackingData:
TDDS failed to execute event. Stored Procedure dtasp_ServiceBegin failed to run.EXECUTE permission denied on object 'dtasp_ServiceBegin', database 'BizTalkDTADb', owner 'dbo'.
TDDS failed to execute event. Stored Procedure dtasp_MsgIn failed to run.EXECUTE permission denied on object 'dtasp_MsgIn', database 'BizTalkDTADb', owner 'dbo'.
TDDS failed to execute event. Stored Procedure dtasp_MsgOut failed to run.EXECUTE permission denied on object 'dtasp_MsgOut', database 'BizTalkDTADb', owner 'dbo'.
TDDS failed to execute event. Stored Procedure dtasp_ServiceEnd failed to run.EXECUTE permission denied on object 'dtasp_ServiceEnd', database 'BizTalkDTADb', owner 'dbo'.
TDDS failed to execute event. Stored Procedure dtasp_CtxBegin failed to run.EXECUTE permission denied on object 'dtasp_CtxBegin', database 'BizTalkDTADb', owner 'dbo'.
TDDS failed to execute event. Stored Procedure dtasp_CtxEnd failed to run.EXECUTE permission denied on object 'dtasp_CtxEnd', database 'BizTalkDTADb', owner 'dbo'.
---------------------------------------------------
What does these stored procedures do? The process runs just fine despite these errors, but ofcourse I'm not confortable with alot of errors in my log.
It seems to be some kind of problem with the permissions on these sp's.
BizTalk Host Users is set to permit on Execute. If I permit Execute for the 'public' user, the errors don't occur.
Is these sp's related in any way to BizTalk Message Queuing (MSMQT) ?
| |
| Alan Smith 2004-07-14, 7:47 am |
| Hej Håken,
The stored procedures update the tracking information in the BizTalk tracking
database. I don't think it's critical to the operation of the orchestrations, but I
think it is used by Health and Activity tracking (HAT) for monitoring the messages
processed by the server. You should make sure HAT is working properly as it's
used a lot for checking and debugging messages in orchestrations.
Maybe some of the info was incorrect during the config stage of installation that
caused this. You could either use the "public" oprion, or check with a working
BizTalk installation for the correct settings.
Regards,
Alan
--
BizTalk & .net
Consulting Training Mentoring
Stockholm London Europe
See aboutme for contact info
"Håkan Thornqvist" wrote:
> Hi all.
>
> I've set up an orchestration and deployed it. It runs fine, but every time the process runs I get an error in the event log.
>
> Source: BAM EventBus Service
> Execute event error. Error(s) occurred while executing events, see TDDS_FailedTrackingData table for more details. SQLServer: <Server>\BTS2004, Database: BizTalkDTADb.
>
> And here's the details from TDDS_FailedTrackingData:
>
> TDDS failed to execute event. Stored Procedure dtasp_ServiceBegin failed to run.EXECUTE permission denied on object 'dtasp_ServiceBegin', database 'BizTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_MsgIn failed to run.EXECUTE permission denied on object 'dtasp_MsgIn', database 'BizTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_MsgOut failed to run.EXECUTE permission denied on object 'dtasp_MsgOut', database 'BizTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_ServiceEnd failed to run.EXECUTE permission denied on object 'dtasp_ServiceEnd', database 'BizTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_CtxBegin failed to run.EXECUTE permission denied on object 'dtasp_CtxBegin', database 'BizTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_CtxEnd failed to run.EXECUTE permission denied on object 'dtasp_CtxEnd', database 'BizTalkDTADb', owner 'dbo'.
>
> ---------------------------------------------------
>
> What does these stored procedures do? The process runs just fine despite these errors, but ofcourse I'm not confortable with alot of errors in my log.
>
> It seems to be some kind of problem with the permissions on these sp's.
> BizTalk Host Users is set to permit on Execute. If I permit Execute for the 'public' user, the errors don't occur.
>
> Is these sp's related in any way to BizTalk Message Queuing (MSMQT) ?
| |
| Eldar Musayev 2004-07-14, 5:50 pm |
| It's used by tracking, these particular ones primarily for BAM - Business
Activity Monitoring. So neither runtime, not even HAT should be affected,
but if you want to use BAM for analysis - the data for it may be incomplete.
Out of top of the head - did you configured BAM at all? You may
accidentally have some shapes marked as reported to BAM (that's not the
same as HAT), then if BAM is not configured, you may get something like
this. For reference, most of the shapes has this field "Report to
Ananlysis", which is by default True.
Regards,
Eldar
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
--------------------[vbcol=seagreen]
<AlanSmith@discussions.microsoft.com>[vbcol=seagreen]
tracking[vbcol=seagreen]
orchestrations, but I[vbcol=seagreen]
the messages[vbcol=seagreen]
it's[vbcol=seagreen]
installation that[vbcol=seagreen]
working[vbcol=seagreen]
time the process runs I get an error in the event log.[vbcol=seagreen]
TDDS_FailedTrackingData table for more details. SQLServer:
<Server>\BTS2004, Database: BizTalkDTADb.[vbcol=seagreen]
failed to run.EXECUTE permission denied on object 'dtasp_ServiceBegin',
database 'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
run.EXECUTE permission denied on object 'dtasp_MsgIn', database
'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
run.EXECUTE permission denied on object 'dtasp_MsgOut', database
'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
to run.EXECUTE permission denied on object 'dtasp_ServiceEnd', database
'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
to run.EXECUTE permission denied on object 'dtasp_CtxBegin', database
'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
run.EXECUTE permission denied on object 'dtasp_CtxEnd', database
'BizTalkDTADb', owner 'dbo'.[vbcol=seagreen]
despite these errors, but ofcourse I'm not confortable with alot of errors
in my log.[vbcol=seagreen]
sp's.[vbcol=seagreen]
for the 'public' user, the errors don't occur.[vbcol=seagreen]
|
|
|
|
|