Error " The Field X on the service Invoice Header does not exist in the SQL Server table or view"

Business Central/NAV User Forum
1

I have a particular user that has one error message in a lot of navision sessions. This, only happens in his PC. If he connect on another PC with the same DB user, the error does not exist. Any user that connet to the same PC have the error message too.

I renamed the zup file

I have already uninstall Client Nav 5.00SP1 and installed again.

I remove all evenViewers logs

But I still have the error message :

" The Field X on the service Invoice Header does not exist in the SQL Server table or view"

2

Hy

Any idear about this ?

I think this error is only related to PC, but I don’t know where is the problem.

Thanks

3

The Code Unit where this error occur is in CU5972.

Any idear???

4

You may try some of or all the steps mentioned below.

But before doing anything, create a backup! Be sure that you are able to restore the backup if nessesary!! The best backup is NAV’s own: Tools → Backup.

1: Are you sure that you have renamed the correct ZUP-file? Rename again, enter NAV and exit - is the [new] ZUP-file’s timestamp your current time?
2: Just to eliminate errors - try to re-compile that codeunit (Object Designer, Codeunit 5972, F11)
3: Try to re-compile table 5992 (Service Invoice Header)
4: Export table 5992 in FOB-format and import it again with option Replace.
…

5

Make sure you rename the correct ZUP from the correct location. Some servers, like i have just sorted one right now, have the zup file on a different location than the original location.

If you still have probs, i guess you should format the PC since this might be related to some bug on your OS. I suggest you may have a VM installed on your system and load Win XP and NAV on that, and then see if you still have the same prob. this will help in identifying the issue.

Cheers

6

I can’t re-compile that codeunit (Object Designer, Codeunit 5972, F11) and table 5992 (Service Invoice Header) because I get the same error message.

As this error only happens in this PC, I think it is not a good idear Export table 5992 in FOB-format and import it again with option Replace.

Every ones works ok, except this user on his PC.

I don’t have any idear about where it is the information in systema that is causing this error.

7

Perhaps a stupid quetsion, but are you quite sure that you connect to the same database?

8

no question is stupid. sometimes a clarification can lead you right to the place you need to be. PS, I and probably a few other were thinking the same thing.

9

Yes I am sure I am connecting to the same database.

If I compile those objects in my PC no problem. In the other PC I have the problem. This only happens in one pc

10

I even connect on the same pc to another data base, a database test and I get the same error

11

I formated the PC, and even after that I get the same error message.

After this, I can only think that the problem must be in SQL DB server.

May me some table with a relation User/PC has some old inconsistent record???

What is your opinion

12

Unless you have some strange modification [can’t think of anyone] in your NAV, there is no connection at all between you SQL-database and the PC. Other than the ZUP-file and the client-program, if located locally.

Who logged on that PC - you or the other person? Do you connect to NAV with WIN- or DB-authentication? Have you synchronized NAV-users with SQL? Did the other person try to log on another PC, using his own ID and run NAV from there? Have you checked the person’s permissions in SQL? (if quesions asked are “recurrent” - sorry).

13

Did you check if there are any fields in the table that have been disabled?