TD51 SP2 Unable To Fetch Data From Oracle Table

General discussion forum about all databases other than SqlBase.
Sunil

TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Sunil » 08 May 2008, 09:05

I am running TD51 deployments inhouse and find most of Time TD unable to fetch data from Oracle Table. I am not able to figure out exact problem but certainly this problem is there. Please take seriously issue. Sometimes TD failed to write data in Oracle Table column .


Sunil
Last edited by Sunil on 08 May 2008, 18:07, edited 1 time in total.

caa

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by caa » 08 May 2008, 16:33

We have no problems fetching data. Can you provide a repro case so that we can debug this problem?

Sunil

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Sunil » 08 May 2008, 16:58

I am trying to repro this case but i am not able to do so but certainly major problem. My client has lost data from various tables. I can give one clue , problem may ibe n while data capture or update in long string datatype.

Please take this issue very very seriously .

Sunil

caa

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by caa » 08 May 2008, 17:26

I would certainly like to see a repro case so that we can fix it.

Our QA tests fetch and store data to long strings -- those tests pass. So clearly we're not doing what you're doing.

Sunil

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Sunil » 08 May 2008, 18:07

These are following clues where i would like to have your attention.
1. Extract data from Oracle long string datatype to Table windows, sometime dropped.
2. On SAM_ANyEdit sometime works fine and sometime failed.
3. SqlExists failed.
4. upper or lower function failing sometimes.
( in that case you have to come out from your application or restart your PC. Mostly when you are trying to logged in application using normal User Login / User Password. )

( I am working with 10g Server and 9i clients ) .

Sunil

caa

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by caa » 08 May 2008, 22:11

Are you using a 9.2 client or better?

Sunil

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Sunil » 09 May 2008, 02:15

I am using 9.2.0.1.0 as client and Server is 10.2.0.1.0 . Please let me know if anything more required.

Sunil

caa

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by caa » 09 May 2008, 14:02

A repro case, please! :-)

Sunil

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Sunil » 10 May 2008, 04:49

here I have got clue and i wil send you repro for the same, meanwhile if you would like see at your end then this is clue.

Fetch using SqlImmediate from Oracle Table having long string data type into Multiline Text. This fetch fails sometimes not always. I am working at my end and let you know exact repro.

Sunil

Jean-Marc Gemperle

Re: TD51 SP2 Unable To Fetch Data From Oracle Table

Post by Jean-Marc Gemperle » 12 May 2008, 11:54

Hi,

I have seen that issue with Sunil directly. The issue is related to a query using SqlImmediate() with an into clause of an ORACLE LONG column (TEXT) that do not return a values ( other columns are fine) in a random fashion. It does not seems to be related to data ( but must be in a way ) and using SqlPrepareAndExecute() did not help, as well as attempting to use SqlSetLongBindDataType() to force the long to be seen as TEXT (it is anyway per default) or SqlSetInmessage() as a shot in the dark did not help. Also using a variable as opposed to a multi line edit field did not help.

So currently figuring out how to reproduce that issue. I belive ORACLE LONG DATA TYPE are deprecated and CLOB should be used instead...now don't know if that would help and it should be ok with LONG anyway. Client is 9.02 against 10g

JM

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest