Executed as user: domain\user. Warning: cannot write a log to table. The step failed.

microsoft.public.sqlserver.tools

12 Jan 2006 6:03 PM

Phil Nicholas

Trying to processing a dimension via the agent in 2005 & I get this error
(seems to be possible as a AS command)?? Can't find any reference to it on
the web (beginning to remember why I tend to leave new stuff for a couple of
years).

Executed as user: FSSOLUTIONS\Phillip.Nicholas. Warning: cannot write a log
to table. The step failed.

13 Jan 2006 9:23 AM

Michael Cheng [MSFT]

Hi Phil,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you encounter the error message

Executed as user: FSSOLUTIONS\Phillip.Nicholas. Warning: cannot write a log
to table. The step failed.

when processing a dimension. If I have misunderstood your concern, please
feel free to point it out.

1. Whether the processing of each dimension will lead to this error message?
2. Is it possible for you to reproduce this with Foodmart?
3. What's the privilege user FSSOLUTIONS|Phillip.Nicholas has?
4. Any other error message you could find in Event Log or anywhere else?

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.