Inconsistent 09024 Error SQLBase 12.0

Discussion forum about all things SqlBase.
akshey.dixit
Australia
Posts: 3
Joined: 16 Mar 2020, 02:46
Location: Sydney

Inconsistent 09024 Error SQLBase 12.0

Post by akshey.dixit » 26 Aug 2020, 02:32

I am using SQLTalk for Windows 12.0.0.10579. This is connecting to the local SQLBase server, both are installed on a Windows 10 Enterprise machine.

Running a simple select query as below would start giving me errors, however it only happens every so often.

Code: Select all

select * from product;
The first time it will give me an 09024 error
select * from product
^
Error: 09024 GCI SEA Session ended abnormally
Any subsequent runs will give me a 03806 error
select * from product
^
Error: 03806 RSO SCT Session closed/terminated
What could be the cause of the session terminating and not being able to reconnect even if I disconnect/reconnect via SQLTalk ?

SQLBase Process activity only indicates that the session keeps getting terminated immediately.

Code: Select all

3> Database process created
3> Stack Usage For Database Process 3: Total 11000 Used 1000 Free 10000
3> Database Process terminated
3> Database process created
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
5> Database process created
5> Stack Usage For Database Process 5: Total 11000 Used 1000 Free 10000
5> Database Process terminated
3> Stack Usage For Database Process 3: Total 11000 Used 1000 Free 10000
3> Database Process terminated

SQL.ini is as below.

Code: Select all

[dbntsrv]
dbname=XXXXX
ANSIJoinSyntax=1
centurydefaultmode=1
cache=64000
NamedPipes=LocalOnly
tempdir=F:\data\
dbdir=F:\data\
ipv4listenaddress=127.0.0.1:2155
servername=SERVER1


AUDIT=GLOBAL,SBCCGLBL,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,1,1,,1,4,5,6,7,8,9,10
AUDIT=PERFM,SBCCPRFM,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,2,1,,1,2,3
[dbntsrv.gui]

[dbntsrv.dll]
comdll=sqlws32
;comdll=sqlapipe

[dbntsrv.apipe]

[dbntsrv.ws32]
ListenPort=2155


[win32client]
clientname=Win32User
transports=npipe,tcp,apipe
clientruntimedir=C:\Program Files (x86)\Gupta\SQLBase 12.0


[win32client.dll]
;comdll=sqlws32
comdll=sqlapipe

[win32client.npipe]
serverpath=SERVER1,127.0.0.1

[win32client.apipe]

[win32client.ws32]
serverpath=SERVER1,127.0.0.1:2155/XXXXX

[win32client.tcp]
serverpath=SERVER1,127.0.0.1:2155/XXXXX

FRBhote
India
Posts: 2172
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Inconsistent 09024 Error SQLBase 12.0

Post by FRBhote » 26 Aug 2020, 05:09

Any fail.sql created?

What are the last few lines in the audit files?

akshey.dixit
Australia
Posts: 3
Joined: 16 Mar 2020, 02:46
Location: Sydney

Re: Inconsistent 09024 Error SQLBase 12.0

Post by akshey.dixit » 26 Aug 2020, 05:57

Thanks for responding!

No fail.sql created. Not sure which audit files you are referring to but here are the last few lines from the SBCCPRFM.1. log file

Code: Select all

001,26-AUG-20 15:49:01.16,CONNECT,dbname,SYSADM,SBCCNTR-workstation-name,0.00
002,26-AUG-20 15:49:01.27,EXECUTE,dbname,SYSADM,SBCCNTR-workstation-name,0.00,
select
*
from SYSADM.PRODUCT
003,26-AUG-20 15:49:01.36,ROLLBACK,dbname,SYSADM,,56.35
003,26-AUG-20 15:49:01.36,ROLLBACK,dbname,SYSADM,,0.00
003,26-AUG-20 15:49:01.36,COMMIT,dbname,SYSADM,,0.00
I have also ran a

Code: Select all

check database
and

Code: Select all

Update Statistics on Database
I am gettting a feeling that the database is corrupted as I ran an unload on the problematic table and it unloaded unsuccessfully.

FRBhote
India
Posts: 2172
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Inconsistent 09024 Error SQLBase 12.0

Post by FRBhote » 27 Aug 2020, 05:18

The audit file are:

AUDIT=GLOBAL,SBCCGLBL,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,1,1,,1,4,5,6,7,8,9,10
AUDIT=PERFM,SBCCPRFM,C:\Program Files (x86)\Gupta\SQLBase 12.0\,1000,2,1,,1,2,3

Perhaps having the same parameter repeated causes a problem?

Come to think of it - do you really require all of them?

Igor Ivanovic
Site Admin
Site Admin
Croatia
Posts: 1365
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: Inconsistent 09024 Error SQLBase 12.0

Post by Igor Ivanovic » 27 Aug 2020, 08:15

Run this:

Code: Select all

unload database nul log <your log location>;
This will touch every corner of your database and if there is a corruption you will know where.
Igor Ivanovic
Image

tom_bond
Germany
Posts: 107
Joined: 09 Mar 2017, 09:20
Location: Germany

Re: Inconsistent 09024 Error SQLBase 12.0

Post by tom_bond » 27 Aug 2020, 13:48

Same here.
The database is ok. Error 9024 with SQLTalk. Startet with SQLTalk Plus there is more info like this:

select * from hkinf;

An error has occurred, please report the following message to OpenText:
Methode nicht gefunden: "Void Gupta.SQLBase.Data.SQLBaseException..ctor(Gupta.SQLBase.Data.SQLBaseError, Int32, System.Exception, System.Collections.Generic.List`1<System.String>, System.Object)".
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatement>d__51.MoveNext()
bei System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.ExecuteStatement(Object obj)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatementEvent>d__50.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
bei Gupta.SQLBase.SQLTalkPlus.ViewModel.SQLTalkEngineViewModel.<ExecuteStatementAtPosition>d__54.MoveNext()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
bei System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
bei System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
Thomas Janocha
FORMAT Software GmbH

SQLBase 9.0.1, 11.6, 11.7.4, 12.0.2, TeamDeveloper 6.1, 7.0.3, 7.2.0, TD Mobile 2.3

akshey.dixit
Australia
Posts: 3
Joined: 16 Mar 2020, 02:46
Location: Sydney

Re: Inconsistent 09024 Error SQLBase 12.0

Post by akshey.dixit » 28 Aug 2020, 00:08

Igor Ivanovic wrote:
27 Aug 2020, 08:15
Run this:

Code: Select all

unload database nul log <your log location>;
This will touch every corner of your database and if there is a corruption you will know where.
Hi Igor, thanks for the information.

I have run the unload twice now on different days and time and both have completed successfully. I couldn't find any mention of any corrupted indexes or tables and manully checked the log entries with the problematic tables for any other errors.

Would you have any ideas on any other checks or auditing that can be done to see why the SQLTalk would crash?

Thanks,

Akshey

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests