From: "Glen Harvy" <glen@aquarius.com.au> Subject: RE: [Emerald] Call online Date: Wed, 4 Feb 2004 14:20:52 +1100 Message-ID: <OGEKLMKDNIPKOKOIHJGBCEAFEAAA.glen@aquarius.com.au>
Hi,
I no expert on SQL but I use the following script via Enterprise Manager:
SELECT * INTO Calls2002FirstQuarter FROM Calls
WHERE Calldate BETWEEN '1/1/2002 00:00:00' AND '3/31/2002 23:59:59'
and it works well.
You can then do whatever you like with the table it creates (in the above
case Calls2002FirstQuarter).
If you still have the problem you describe then I suggest posting a message
at http://www.sswug.org/.
_____________________________________
Glen Harvy
Aquarius Communications
for all your Internet Needs.
Phone 9977 3788 Fax 9977 3844
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Vilmos Branyik
> Sent: Wednesday, 4 February 2004 10:25
> To: 'emerald@iea-software.com'
> Subject: RE: [Emerald] Call online
>
>
> Glen,
>
> Thanks for the link. I had already found that.
>
> I have been able to truncate my database and at least have some room. I'm
> trying to delete old call records and cannot do so. I've tried using the
> Emerald Maint function and running an SQL query. Neither works.
>
> I see this error in the logs:
> RA_AsyncReadioComplete: Operating system error 23 (Data error (cyclic
> redundancy check)) encountered
> RS_Service_IO [Bucket: 0][slot 5]; Process 5 generated access
> violation; SQL
> server is terminating this process
>
> Then I go right back to the bufwait timout errors
>
> I can find the locking SPID and kill the process but that doesn't seem to
> help.
>
> The only thing I found regarding this in a Google search was a link to a
> question in the Emerald mailing list that appears to be unanswered.
>
> Any suggestions on where to look?
>
> Matt
>
>
> > -----Original Message-----
> > From: Glen Harvy [mailto:glen@aquarius.com.au]
> > Sent: Monday, February 02, 2004 8:05 PM
> > To: emerald@iea-software.com
> > Subject: RE: [Emerald] Call online
> > Importance: High
> >
> >
> > Detailed help is at:-
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;165158
> > &Product=sql
> >
> > _____________________________________
> > Glen Harvy
> > Aquarius Communications
> > for all your Internet Needs.
> > Phone 9977 3788 Fax 9977 3844
> >
> > > -----Original Message-----
> > > From: emerald-request@iea-software.com
> > > [mailto:emerald-request@iea-software.com]On Behalf Of Vilmos Branyik
> > > Sent: Tuesday, 3 February 2004 12:35
> > > To: 'emerald@iea-software.com'
> > > Subject: [Emerald] Call online
> > >
> > >
> > > I'm running Emerald 2.5.342 with SQL 6.5.
> > >
> > > My database quit responding this afternoon and quit authenticating.
> > >
> > > It looks like it's because my error log is filling up. When
> > I look in the
> > > error logs they are filing up which is why I think the service died.
> > >
> > > I see a bunch of errors beginning with:
> > >
> > > bufwait timeout: BUF_IO
> > >
> > > Following that:
> > > Error: 17824
> > > Unable to write to ListenOn connection
> > "\\...\pipe\sql\guery, Loginname
> > > 'sa', hostname"
> > > OS Error: 232, the pipe is being closed
> > > Error: 1608, Severity 21, state 2
> > >
> > > I can't run database maint from the Emerald Administrator.
> > It asks me to
> > > truncate the log file then just freezes.
> > >
> > > I ran dbcc checkdb and it completes but doesn't help.
> > >
> > > I cannot trim my call online.
> > >
> > > The system is not updating the on-line users so even if
> > someone logs off
> > > they still show on and cannot log on again. Everyone else can still
> > > authenticate but do not show up on the on-line view when they do.
> > >
> > > I can't seem to find anything in the archives.
> > >
> > > Can someone point me in the right direction?
> > >
> > > Thanks,
> > >
> > > Matt Branyik
> > > www.piopc.net
> > >
> > >
> >
>
>