|
Home > Archive > IQ Server > March 2005 > IQ Server Stops when an Update/Delete statement is issued
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
IQ Server Stops when an Update/Delete statement is issued
|
|
| Anand Vijai 2005-03-30, 7:08 pm |
| HI all,
I have a table on which if i issue an UPdate/Delete
statement with a condition, the interactive SQL says that
"connection is already closed"
The IQ server stops as well..There is no error message in
the server log...there is a stack trace
** IQconnectID: 9999
** Adaptive Server IQ/12.5.0/030305/P/GA
** 2005-03-03 11:57:01
IQ built on: MS/Windows NT 4.0, Executed on:
Windows/CMITSIP08/WinNT/5.0/Build 2195/Service Pack 4/x86
Family/level 15/Model 2/Stepping 5/4 CPU(s)
** while executing this command from user: NO NAME
COMMAND: NO COMMAND or NO CURSOR
***************** This is the STACKTRACE ***************
===== Thread Number 3804 =====
pc: 0x11dc ()
pc: 0x656bcf96 void near vpe_HostVar::Constru
ctKey()
+0x513bbcd6()
pc: 0x6556d750 void near vpe_HostVar::Constru
ctKey()
+0x5126c490(0x808dc3
c0, 0x0, 0xb7b5be8, 0x5168a300,
0xc031657b)
I did a sp_iqcheckdb verify on that table..but there was no
problem reported..
Any pointers or suggestions would be welcome
Table: 6 columns,1 primary key
No of records: 48
| |
| denzilsyb 2005-03-30, 7:08 pm |
| Hallo
Can you post the table create statement and the update/delete statement.
Also - are you using the latest EBF for 12.5?
Denzil
<Anand Vijai> wrote in message news:4227015b.68b5.1681692777@sybase.com...
> HI all,
> I have a table on which if i issue an UPdate/Delete
> statement with a condition, the interactive SQL says that
> "connection is already closed"
> The IQ server stops as well..There is no error message in
> the server log...there is a stack trace
>
> ** IQconnectID: 9999
> ** Adaptive Server IQ/12.5.0/030305/P/GA
>
> ** 2005-03-03 11:57:01
> IQ built on: MS/Windows NT 4.0, Executed on:
> Windows/CMITSIP08/WinNT/5.0/Build 2195/Service Pack 4/x86
> Family/level 15/Model 2/Stepping 5/4 CPU(s)
> ** while executing this command from user: NO NAME
> COMMAND: NO COMMAND or NO CURSOR
> ***************** This is the STACKTRACE ***************
>
> ===== Thread Number 3804 =====
> pc: 0x11dc ()
>
> pc: 0x656bcf96 void near vpe_HostVar::Constru
ctKey()
> +0x513bbcd6()
>
> pc: 0x6556d750 void near vpe_HostVar::Constru
ctKey()
> +0x5126c490(0x808dc3
c0, 0x0, 0xb7b5be8, 0x5168a300,
> 0xc031657b)
>
>
> I did a sp_iqcheckdb verify on that table..but there was no
> problem reported..
> Any pointers or suggestions would be welcome
>
> Table: 6 columns,1 primary key
> No of records: 48
| |
| Anand Vijai 2005-03-30, 7:08 pm |
| The Table DDL is as follows:
--------------------------------
create table dbo.MC_Form(
SurveyID_FK int,
FormID_PK int primary key,
FormTypeText varchar(40),
UpdateUser varchar(20),
UpdateDate datetime,
FormDocDirDesc varchar(255))
Delete/Update Stmts:
------------------------
delete from MC_Form where FormID_PK = 6743 and SurveyID_FK =
89
update MC_Form set FormID_PK = 6749 where SurveyID_PK = null
The EBF used is ESD9....
I guess the latest EBF available is ESD12...
Thks
Anand Vijai
> Hallo
>
> Can you post the table create statement and the
> update/delete statement. Also - are you using the latest
> EBF for 12.5?
>
> Denzil
>
> <Anand Vijai> wrote in message
> *************** >
>
>
|
|
|
|
|