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

Post found 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: 6
Joined: 22 May 2018, 08:59
Location: Braunichswalde

Re: 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: 472
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: 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: 6
Joined: 22 May 2018, 08:59
Location: Braunichswalde

Re: 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: 6
Joined: 22 May 2018, 08:59
Location: Braunichswalde

Re: 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: 4
Joined: 06 Mar 2017, 07:33
Location: Dortmund / Germany

Re: 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 ather but important things worse :cry:
Wladislaw Wasilewitsch
---------------------------------------------------
Software Developer
Materna TMT GmbH

Return to “Bug Reports”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests