TD-24106: [TD 71, 705] Big problem on sql error

Report bugs and possible workarounds.
coolatsa
France
Posts: 1
Joined: 23 Mar 2017, 17:04
Location: Paris, France

TD-24106: [TD 71, 705] Big problem on sql error

Post by coolatsa » 28 Jun 2018, 11:55

Hi,

we use dynamic sql in our application. Sometime users could write an error in a sql.

Before TD 6.2 and 6.3 a simple sql error displays the error box and we can continue with the application or the IDE.

With TD 7.1 any execution of an sql statement, after the sql error, generate an error -21213.

A simple testcase :

create a app with a form and in the form have those lines : 

!!CB!! 173
On SAM_Create
    Set SqlUser = 'SYSTEM'
    Set SqlPassword = 'SYSPWD'
    Set SqlDatabase = 'P1'
    Call SqlConnect( hSql1 )
    Call SqlPrepareAndExecute( hSql1, 'SELECT 1 FROM DUAL')
    Call SqlPrepareAndExecute( hSql1, 'SELECT 1 FROM ERROR')
    Call SqlPrepareAndExecute( hSql1, 'SELECT 1 FROM DUAL')


First sql statement : no problem

Second sql statement : error ORA-00942: table or view does not exist. For the test the table ERROR does not exist.

Third sql statement : error SQL Error 21213, not found in ERROR.SQL file.

From this point any sql statement give the same error even the sql statement without error (first or third statement ).

With the IDE we have to close the TD application and launch a new one TD (cbi71.exe) to avoid the same error.

Best regards

Coolatsa

bheilscher
Germany
Posts: 23
Joined: 22 May 2018, 08:59
Location: Braunichswalde

TD 7.1 : big problem on sql error

Post by bheilscher » 06 Jul 2018, 15:05

Hi,

It is reproducible in a 32 bit and 64 bit environment, occurs only against ORACLE (with native router). Also with SQLTALK.
Seems to be a bug in sqlora32.dll.

IMHO, without patch, TD7.1 against ORACLE is not usable.

Best regards

Bernd

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 691
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

TD 7.1 : big problem on sql error

Post by Dave Rabelink » 09 Jul 2018, 05:15

Is this issue already been reported to OpenText Gupta?
If so, please post the ticket and defect # here so we can refer to it.

Here the issue is reproducible and indeed blocking.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

bheilscher
Germany
Posts: 23
Joined: 22 May 2018, 08:59
Location: Braunichswalde

TD 7.1 : big problem on sql error

Post by bheilscher » 10 Jul 2018, 05:41

This issue is registered as ticket 3802033.

Regards

Bernd

bheilscher
Germany
Posts: 23
Joined: 22 May 2018, 08:59
Location: Braunichswalde

TD 7.1 : big problem on sql error

Post by bheilscher » 11 Jul 2018, 05:42

The bug number is TD-24106.

wwasilew
Germany
Posts: 5
Joined: 06 Mar 2017, 07:33
Location: Dortmund / Germany

TD 7.1 : big problem on sql error

Post by wwasilew » 12 Jul 2018, 07:43

Hello,

same problem exists yet also in the 7.0.5. Also think twice before installing of this...
I think the reason for this can be founded in the list of fixed issues:

TD-23687
Oracle native router error "ORA-04043: object XXX does not exist" when executing a package via SYNONYM using SqlPLSQLCommand() or SqlOraXXX() functions

now that situation:
they have fixed one rare error and make other but important things worse :cry:
Last edited by wwasilew on 03 Aug 2018, 07:12, edited 1 time in total.
Wladislaw Wasilewitsch
---------------------------------------------------
Software Developer
Materna TMT GmbH

kclench
United States of America
Posts: 8
Joined: 26 Jun 2017, 23:22
Location: Ventura, CA, USA

TD-24106: [TD 71, 705] Big problem on sql error RESOLVED

Post by kclench » 02 Aug 2018, 19:00

The SQL 24106 error issue in TD7.1 is fixed by Open Text. I had opened a support ticket asking about a fix and Mike Vandine gave me a link.
"This defect has been fixed and a ONEOFF created. You may download now the ONEOFF710.3 and please read the text file containing the steps on your will update your TD7.1.0." the file is: ONEOFF710.3.zip

Karen

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests