Restructure of table giving The REquested object was not found. .\ccolumn

2

Using Local Advantage version 10.10.0.6 on XP writing in Delphi 2005.

I can restructure tables in terms of adding columns but having issue when trying to change the width of a column from 30 to 100 characters. The column is not indexed.

Code to restructure is Restructure('','','Description2,Description2,Char,100');

but getting message ...raised exception class EADSDatabaseError with message 'tblNomixM: Error 5041: The requested object was not found. .\ccolumn.cpp, 4995'. Process stopped. Used Step or Run to continue.

Have checked column name and it is as per the database.

Any suggestions welcomed.

asked 16 Jul '13, 06:25

B%20C's gravatar image

B C
46●5●5●8
accept rate: 0%

edited 26 Feb '15, 09:22

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff
1.3k●5●10●37
2 Answers:
oldestnewestmost voted
2

Some possible scenarios for this error:

  1. The index of the data dictionary file is corrupt or out of date. You can delete the .ai file and try again.
  2. The meta data of the table in the data dictionary does not match the actual table structure. This can be the case if using DBF table and the table is restructured while not connected to the database. You can use this SQL command in ARC to check the meta data in the data dictionary "SELECT * FROM system.columns WHERE Parent = 'MyTable'". If the meta data does not match the actual table structure, you can remove the table from the data dictionary and add it back to correct the problem.
link

answered 17 Jul '13, 08:49

Alex%20Wong's gravatar image

Alex Wong
5.3k●24●88
accept rate: 42%

edited 17 Jul '13, 08:51

0

That was the issue - thanks a lot. Table structure and meta data was out of sync.

Went through each table with the select statement and found offending table.

Exported to a New Table. Removed the old one. Added the new table into the dictionary and all is OK.

link

answered 18 Jul '13, 18:36

B%20C's gravatar image

B C
46●5●5●8
accept rate: 0%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Tags:

×271
×79
×4

Asked: 16 Jul '13, 06:25

Seen: 7,999 times

Last updated: 26 Feb '15, 09:22

Related questions

select SQL result wrong in ALS12, but the same App result ok with ALS11

TadsQuery with special character

DBF with utf-8

ADSCopyTable functionality

Installing ADS for different Delphi versions

Reindexation problem on Advantage Database local server?

error 5072 Advantage Local Db with v. 10.10.0.49/51 and not with v. 10.10.0.28

Is there a way to determine the number of active sessions on a dictionary

7041 Errors on AlsEvents and AlsEvents_Signals

Access violation on moving data into a table field

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.