[CRASH] Team Developer 6.3 / ASE Sybase

[wfournier]

Hey

Config:
Team developer 6.3
Sybase ASE 12.5.4

My apologies for my bad english.

I m working on project using Gupta team developer 6.3 and Sybase system 12.5.4. Compilation is fine , but while executing the app,when the control comes to the statement for executing the function SybExecuteProc (which can be used to execute stored procs in Sybase system 10 and 11) the execution is stopping abruptly, crash of TD6.3 and my app.

After some tests, i find out that one column in my SELECT crash SybExecuteProc. I tryed without this column and the app is running correctly.

I tried to figure why this column isn't working but i didn't find anything to help me debug this problem

The app :

I got a select like this :

Code: Select all

LOCAL VARIABLES : 
NUMBER: nCode
String strLibelle
String strAuto
String strExec
...
...
CONNEXION SERVER... ! Everything is working
...
...
SET strRequete = 'select distinct h.APPLI, app.LIB, "O", app.EXECUTABLE
   from HABI h, APPLICA app
   where h.APPLI  = app.APPLI'
IF SybExecuteProc(hSql,strRequete,':nCode,:strLibelle,:strAuto,:strExec) ! <- CRASH HERE ON the column strLibelle/app.LIB
---....
---....

My column app.LIB is composed with words and sentence :
...
hello
Hello\you
hey.working
hey working
...

I look in my log and i find this
ASSERTION FAILURE: file ..\..\sqlsyb32\c\SQSERR.CPP : line 310
[ERROR] 32031 Internal SQLRouter error [2031]

Got some ideas ?

Thanks!

W. Fournier.

[wfournier]

Yeah i find this post , but my sql.ini is already with enablemultipleconnections=off .

[wfournier]

I got this pop up :

Signature du problème :
Nom d’événement de problème: APPCRASH
Nom de l’application: cbi63.exe
Version de l’application: 6.3.1.46580
Horodatage de l’application: 5626d42b
Nom du module par défaut: MSVCR110.dll
Version du module par défaut: 11.0.51106.1
Horodateur du module par défaut: 5098858e
Code de l’exception: c0000005
Décalage de l’exception: 0000df22
Version du système: 6.1.7601.2.1.0.256.4
Identificateur de paramètres régionaux: 1033
Information supplémentaire n° 1: 0a9e
Information supplémentaire n° 2: 0a9e372d3b4ad19135b953a78882e789
Information supplémentaire n° 3: 0a9e
Information supplémentaire n° 4: 0a9e372d3b4ad19135b953a78882e789

[wfournier]

Code: Select all

hey ,

I got new informations : in my query :

Code: Select all

LOCAL VARIABLES : 
NUMBER: nCode
String strLibelle
String strAuto
String strExec
...
...
CONNEXION SERVER... ! Everything is working
...
...
SET strRequete = 'select distinct h.APPLI, app.LIB, "O", app.EXECUTABLE
   from HABI h, APPLICA app
   where h.APPLI  = app.APPLI'
IF SybExecuteProc(hSql,strRequete,':nCode,:strLibelle,:strAuto,:strExec) ! <- CRASH HERE ON the column strLibelle/app.LIB
---....
---....

I forced the conversion of app.LIB like :

Code: Select all

LOCAL VARIABLES : 
NUMBER: nCode
String strLibelle
String strAuto
String strExec
...
...
CONNEXION SERVER... ! Everything is working
...
...
SET strRequete = 'select distinct h.APPLI, convert(UNICHAR(60),app.LIB), "O", app.EXECUTABLE
   from HABI h, APPLICA app
   where h.APPLI  = app.APPLI'
IF SybExecuteProc(hSql,strRequete,':nCode,:strLibelle,:strAuto,:strExec) !
---....
---....

And it's working ! My app and gupte don't crash anymore.
i find in my log_file :

1/14/16 10:37:05 1> SERVERMSG: 2401:11 Character set conversion is not avai
1/14/16 10:37:05 1> lable between client character set 'utf8' and server ch
1/14/16 10:37:05 1> aracter set 'iso_1'.
1/14/16 10:37:05 1> SERVERMSG: 2411:10 No conversions will be done.
1/14/16 10:37:05 1> SERVERMSG: 2415:10 Due to previous errors, the language
1/14/16 10:37:05 1> for this session is being forced to 'us_english'.
1/14/16 10:37:05 1> SERVERMSG: 5704:10 Changed client character set setting
1/14/16 10:37:05 1> to '<NULL>'.

So i look at the collation information of my server with sp_helpsort:

'Character Set = 1, iso_1'
' ISO 8859-1 (Latin-1) - Western European 8-bit character set.'
'Sort Order = 50, bin_iso_1'
' Binary ordering, for the ISO 8859/1 or Latin-1 character set ('
' iso_1).'

but for client i got with @@client_csname --> NULL and @@client_csid --> -1 and the char convert is off ( @@char_convert --> 0 )

Any ideas to explain why i have to use convert(UNICHAR()) ?

[wfournier]

I got the same problem with an other column. And the same solution ( convert(UNICHAR()) works to correct the problem.

No idea to explain why i have to do this ?