Hello
My application is running on one of my client on Client-Server mode.
The app is installed on main computer with the edbsrvr running and there is a shortcut
of the main programs on the connected computer. Every user has a username and password.

The program is running ok from all places beside one. On this one the program is running but on
the edbsrvr  manager I don't see any session. Some parts of the programs are running ok on this
computer and some  raise the "Error #100 There is an error in the metadata for the table tableName
(The internal structure does not match the structure in the catalog)

On the others computers it doesn't happened
Any suggestions what to check?
Thanks Sorin

Sorin

First thing is to check that the session is set to stRemote and is pointing to the right place. If you're using multiple sessions check them all, including ones in threads. The only way I can see the sort of error you're getting is down to pointing at the wrong data.



Roy Lambert

Roy Lambert wrote:

Sorin

First thing is to check that the session is set to stRemote and is pointing to the right place. If you're using multiple sessions check them all, including ones in threads. The only way I can see the sort of error you're getting is down to pointing at the wrong data.



Roy Lambert
Thanks Roy

This session is set to stRemote and point to the right place otherwise the program would have raise an error when started.
The program have only one session.
The error raise only on one computer
Thanks Sorin

Sorin

>This session is set to stRemote and point to the right place otherwise the program would have raise an error when started.
>The program have only one session.
>The error raise only on one computer

The last point says that the error is on that computer. Is it running a different copy of the exe? How many database instances are there?

Roy Lambert

The last point says that the error is on that computer. Is it running a different copy of the exe? How many database instances are there?

Thanks again
There is one .exe on the main computer. All the computers have a shortcut to that exe.
The program have one database instance
Thanks Sorin

Sorin


Unless I'm misinterpreting something what you're saying is that everything is the same across several PCs but one of them for no reason gives a different result to the others.

Going back to the manual

EDB_ERROR_VALIDATE (100)
There is an error in the metadata for the <ObjectType>
<ObjectName> (<ErrorMessage>)This error is raised
whenever an attempt is made to create a new catalog
or configuration object, and there is an error in the
specification of the object. The specific error message is
indicated within the parentheses.


What it is effectively saying is that the tables files and the catalog file are not compatible. Columns may have been added or deleted, constraints may have been changed etc. The only way I can see that happening on one PC out of a group is if that PC isn't pointing to the same data as the other PCs.

Roy Lambert

Unless I'm misinterpreting something what you're saying is that everything is the same across several PCs but one of them for no reason gives a different result to the others.

Yes Roy that is the problem.
And it has exactly the same shortcut, and it's point exactly to the same directory.
We also check the permissions and they looks the same on all computers
I agree it's very strange
Sorin

On 12/7/2016 11:58 AM, Hershcu Sorin wrote:
> And it has exactly the same shortcut, and it's point exactly to the same directory.
> We also check the permissions and they looks the same on all computers
> I agree it's very strange

Sorin,

What do you mean it points to the same directory ?

You mentioned you are running Client-Server and remote sessions so what
is this directory for ?

Are you just sharing the EXE or doing something else.


You did not mention if database in ANSI or unicode ?


if it's just 1 PC then i would check things like regional settings and
language settings and such on that PC - are they any different than others.

Raul

What do you mean it points to the same directory ?

You mentioned you are running Client-Server and remote sessions so what
is this directory for ?

The path to the directory with the exe file. It's the same on all computer and defined on edbsrvr


Are you just sharing the EXE or doing something else.
Yes just sharing


You did not mention if database in ANSI or unicode ?
ANSI

if it's just 1 PC then i would check things like regional settings and
language settings and such on that PC - are they any different than others.
Ok I'll do it tomorow

Hershcu,

<< The program is running ok from all places beside one. On this one the program is running but on the edbsrvr  manager I don't see any session. Some parts of the programs are running ok on this computer and some  raise the "Error #100 There is an error in the metadata for the table tableName (The internal structure does not match the structure in the catalog) >>

I agree with Roy here - something *must* be different, otherwise you wouldn't be getting a different result.

A very helpful utility here is the Process Monitor from SysInternals (Microsoft):

https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx

I would run it on a "working" machine, save the logged activity, and then run it on the "non-working" machine and save its logged activity.  Then, visually compare the two to see if any file/directory I/O is odd or different with the "non-working" machine.  That should pinpoint where the issue is.

Tim Young
Elevate Software
www.elevatesoft.com