[TD 5.1 SP6] ORA-24324 after fetch a lot of columns

General discussion forum about all databases other than SqlBase.
ILYA

[TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by ILYA » 30 Mar 2010, 14:20

Hi!

I have a table with many columns (more then 30). I populate it with SalTblPopulate. Data loads normally. Then I wait couple of minutes and populate again - everything is correct again. I wait again, and populating I've got "ORA-24324 - service handle not initialized", and then "ORA-24323 - value not allowed". I tried to use less then 30 columns and with 28 column I don't see ORA-24324 error. What can it be?

Jeff Luther

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by Jeff Luther » 31 Mar 2010, 01:41

Try adding a COMMIT after the populate is done. Be sure the table window's cache is Discardable=No and Max Rows = 128000 or something large.

ILYA

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by ILYA » 31 Mar 2010, 07:59

Doesn't work, Jeff. I added COMMIT and Discardable=No and Max Rows = 128000 - no effect. But I can't understand why should I have to use COMMIT after the populate.

Jeff Luther

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by Jeff Luther » 31 Mar 2010, 19:50

why should I have to use COMMIT after the populate
On the off-chance that there were any locks left on the DB after the populate was done. And if so, that might account for the server error next time you tried to populate.

User avatar
Charlie
Canada
Posts: 649
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by Charlie » 01 Apr 2010, 11:59

Hello,

Just for the heck of it, have you tried calling SalTblReset( hWndTbl ) before each SalTblPopulate( ... ) call ?

ILYA

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by ILYA » 01 Apr 2010, 12:09

Yes, SalTblReset is calling before SalTblPopulate

User avatar
Charlie
Canada
Posts: 649
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by Charlie » 06 Apr 2010, 14:25

A few questions:
  • What version of Oracle (database and client) are you using?
  • Native connection or OleDB ?
  • Is it the exact same query for each SalTblPopulate?
  • Are your table window columns static or dynamically created?
  • Between calls to SalTblPopulate and during SalTblPopulate processing (i.e. SAM_Fetch* message processing), do you perform any other database activity?

ILYA

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by ILYA » 07 Apr 2010, 06:37

  • Oracle Dtabase 10g EE 10.2.0.1.0 / Oracle client 10.2.0.1.0
  • Native connection (sqlora32.dll 5.1.6.8873)
  • I do different queries for SalTblPopulate, but have a bug for just one
  • Columns are dynamically created
  • No database activity between SalTblPopulate and during SalTblPopulate processing

User avatar
Charlie
Canada
Posts: 649
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

Re: [TD 5.1 SP6] ORA-24324 after fetch a lot of columns

Post by Charlie » 08 Apr 2010, 11:48

G'day,

I'm thinking that you're getting a misleading error (i.e. ORA-24324 has nothing to do with your problem.)

Being a betting man, I'm guessing that the problem has to do with one specific column that works sometimes and doesn't work in one or more other cases because of some db column value.

By trial and error, can you isolate the problem to one or more specific columns? (i.e. by commenting and uncommenting different batches of columns.)

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests