SQL Anywhere database - !!!Critical Stops the database services and drops all the connection !!!

Author

!!!Critical Stops the database services and drops all the connection !!!

Bhoj Rawal

2005-05-16, 8:23 pm

SQL Anywhere version 9.0.22551

When we try to run the stored procs it happend inside the stored procs.

INSERT INTO tmpS8FixupCheckAmoun
t
(tmpS8FixupCheckAmou
ntID, S8TmpCheckHeaderID, TMID, SumAmount)
SELECT null, Dtl.S8TmpCheckHeaderID, Dtl.TMID, SUM(Dtl.VchAmount) AS
SumAmount
FROM S8TmpCheckDetail AS Dtl
GROUP BY Dtl.TMID, Dtl.S8TmpCheckHeaderID
HAVING SUM(Dtl.VchAmount)<0

or
SELECT null, Dtl.S8TmpCheckHeaderID, Dtl.TMID, SUM(Dtl.VchAmount) AS
SumAmount into #t1
FROM S8TmpCheckDetail AS Dtl
GROUP BY Dtl.TMID, Dtl.S8TmpCheckHeaderID
HAVING SUM(Dtl.VchAmount)<0

Can you please look into above statement and see is anything I'm missing?

Thanks
Bhoj

Rob Waywell

2005-05-19, 7:23 am

If this is a reproducible issue then you should submit the case to Tech
Support so that we can diagnose and address the issue.

http://www.sybase.com/contactus/support

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Bhoj Rawal" <brawal@tenmast.com> wrote in message
news:42890af6@forums
-1-dub...
> SQL Anywhere version 9.0.22551
>
> When we try to run the stored procs it happend inside the stored procs.
>
>
> INSERT INTO tmpS8FixupCheckAmoun
t
> (tmpS8FixupCheckAmou
ntID, S8TmpCheckHeaderID, TMID, SumAmount)
> SELECT null, Dtl.S8TmpCheckHeaderID, Dtl.TMID, SUM(Dtl.VchAmount) AS
> SumAmount
> FROM S8TmpCheckDetail AS Dtl
> GROUP BY Dtl.TMID, Dtl.S8TmpCheckHeaderID
> HAVING SUM(Dtl.VchAmount)<0
>
> or
> SELECT null, Dtl.S8TmpCheckHeaderID, Dtl.TMID, SUM(Dtl.VchAmount) AS
> SumAmount into #t1
> FROM S8TmpCheckDetail AS Dtl
> GROUP BY Dtl.TMID, Dtl.S8TmpCheckHeaderID
> HAVING SUM(Dtl.VchAmount)<0
>
>
>
> Can you please look into above statement and see is anything I'm missing?
>
>
> Thanks
> Bhoj
>
>
>

Sponsored Links