An error occured while performing the operation:

C

chiranjitbhadra

New Member
Hi,

I am using DB Visualizer 6.0.2 ver for Progress data base.

please help me when I am trying to open a particular file the error is coming like :
[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Lock table is full. (7870

Thanks
Chiranjit​
 
You must set the default isolation level of the odbc driver to:
READ UNCOMITTED
or you should increase your locktable (-L parameter of the database).
I'll opt for option 1.

Casper.
 
Casper said:
You must set the default isolation level of the odbc driver to:
READ UNCOMITTED
or you should increase your locktable (-L parameter of the database).
I'll opt for option 1.

Casper.
Click to expand...


I am getting the new error after doing as per your suggestion as follows :

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Array element value overflow. (12664)
 
I think that you are trying to reference an array field as a whole You should do that per array element:

e.g.
Code: 
select arrayfield[1] arrayfield[2] from pub.tablewitharrays

BTW did you ran dbtool on that database?

Regards,

casper.
 
Casper said:
I think that you are trying to reference an array field as a whole You should do that per array element:

e.g.
Code: 
select arrayfield[1] arrayfield[2] from pub.tablewitharrays

BTW did you ran dbtool on that database?

Regards,

casper.
Click to expand...


I could not find any array table whatever you mentioned also please let me know how to run dbtool

regards,
Chiranjit
 
You can run dbtool at the database server:
Code: 
dbtool [I]path-todatabase/databasename[/I]
Choose option 9: (export to file)
option 2: SQL width scan w/ fix option
then:
  • 1 (number of threads depending on # cpu )
  • Depending on version padding (I always choose 0 because I had some problems with value > 0 )
  • all (all tables)
  • all (all area's)
  • 3 (verbose logging level, depending on what you want to see in the output)
Dbtool is a tool which corrects _field._width field.
In Progress fields are of indefinite length, this causes problems with SQL92. In SQL92 fields are required to have fixed length. Normally Progress uses twice the display format as the value of _field._width this isn;t always sufficient. By running dbtool progress scnas the entire database for fields which exceed _field._width in length and adjusts _width accordingly.

You can also run it with option 1 then only the scan and no changes are made. If the table which gives the error is in the list then probably that is your problem.
On the other hand, verify as well that there are no extent fields in the table you are referencing. You can only reference array fields per field and not as a whole.

N.B.: If you use that particular database to create delta.df files then be aware that the delta.df shows more changes then you want after you ran dbtool :-).

HTH,

Casper
 
thx

I couldn’t understand some parts of this article, but I guess I just need to check some more resources regarding this, because it sounds interesting.
 
You must log in or register to reply here.
Back
Top