Hi all.

I've set up an orchestration and deployed it. It runs fine, but every time t
he 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_Fail
edTrackingData table for more details.  SQLServer: <Server>\BTS2004, Databas
e: 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 'BizT
alkDTADb', owner 'dbo'.

TDDS failed to execute event. Stored Procedure dtasp_MsgIn failed to run.EXE
CUTE permission denied on object 'dtasp_MsgIn', database 'BizTalkDTADb', own
er 'dbo'.

TDDS failed to execute event. Stored Procedure dtasp_MsgOut failed to run.EX
ECUTE permission denied on object 'dtasp_MsgOut', database 'BizTalkDTADb', o
wner 'dbo'.

TDDS failed to execute event. Stored Procedure dtasp_ServiceEnd failed to ru
n.EXECUTE permission denied on object 'dtasp_ServiceEnd', database 'BizTalkD
TADb', 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.EX
ECUTE permission denied on object 'dtasp_CtxEnd', database 'BizTalkDTADb', o
wner 'dbo'.

---------------------------------------------------

What does these stored procedures do? The process runs just fine despite the
se 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) ?

[ Post a follow-up to this message ]

Hej HÃ¥ken,

The stored procedures update the tracking information in the BizTalk trackin
g
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 me
ssages
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 worki
ng
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_Fa
iledTrackingData table for more details.  SQLServer: <Server>\BTS2004, Datab
ase: BizTalkDTADb.
>
> And here's the details from TDDS_FailedTrackingData:
>
> TDDS failed to execute event. Stored Procedure dtasp_ServiceBegin failed t
o run.EXECUTE permission denied on object 'dtasp_ServiceBegin', database 'Bi
zTalkDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_MsgIn failed to run.E
XECUTE permission denied on object 'dtasp_MsgIn', database 'BizTalkDTADb', o
wner '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 'BizTal
kDTADb', owner 'dbo'.
>
> TDDS failed to execute event. Stored Procedure dtasp_CtxBegin failed to ru
n.EXECUTE permission denied on object 'dtasp_CtxBegin', database 'BizTalkDTA
Db', 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 t
hese 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 th
e 'public' user, the errors don't occur.
>
> Is these sp's related in any way to BizTalk Message Queuing (MSMQT) ?

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]