An error occured while performing the operation:

[chiranjitbhadra]

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​

 

[Casper]

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.

 

[chiranjitbhadra]

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.

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

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Array element value overflow. (12664)

 

[Casper]

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

e.g.

select arrayfield[1] arrayfield[2] from pub.tablewitharrays

BTW did you ran dbtool on that database?

Regards,

casper.

 

[chiranjitbhadra]

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

e.g.

select arrayfield[1] arrayfield[2] from pub.tablewitharrays

BTW did you ran dbtool on that database?

Regards,

casper.

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

regards,
Chiranjit

 

[Casper]

You can run dbtool at the database server:

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

 

[loadmilmnaw]

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.