Re: [Emerald] Emerald UpdateCalls Accounts Failure

Dale E. Reed Jr. ( (no email) )
Tue, 25 May 1999 14:17:03 -0700

PowerNet wrote:
> I am getting failures in the SQL task history for the Emerald UpdateCalls Accounts task tries to run.
> There are 2 alternating failure messages.
> They are:
> 1 Internal error -- Unable to open table at query execution time. (Message 202)
> 2 Cursorfetch: Maximum length of '@username' is incompatible with that of selected column in the cursor
> (Message 16923)
> Can anyone tell me how to fix this problem.

In Enterprise manager, Drill down to Emerald, Objects, Stored
and find the UpdateCalls_AccountID stored proc, and select edit. At the
top of the stored proc, change the @username len to 32 and click save.
Some of the newer DBs have a 32 character username in the calls table
to handle roaming entries. The line should be:

DECLARE @username varchar(32), @acctid int


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.