Re: Emerald errors
Dale E. Reed Jr. ( (no email) )
Mon, 24 Aug 1998 13:05:21 -0700
Alan D. Criado wrote:
>
> Perhaps someone can help:
>
> I'm trying to run my cosolidation for billing purposes and it's erroring out.
>
> I click on SUMMARY and it seems to work (it creates two summaries), but
> when I click on CHARGES it looks like it's trying to work, but then fails
> witht he following error:
>
> "Error executing consolidation proceedure!"
>
> So I go into ISQL_W, select the Emerald database and run: CONSOLIDATION 1
>
> and I get the following results:
>
> "Msg 1205, Level 13, State 2
> Your server command (process id 15) was deadlocked with another process and
> has been chosen as deadlock victim. Re-run your command"
>
> Does anyone know what's going on and how to fix it?
If you re-run it and keep getting the same error, I'd check to see
what else is running that could be locking you out. You can use the
curent activity option in the Enterprise manager to see whos connected
and what they are doing.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com