Cannot Start NAS because PRIMARY KEY does not exists

tomdebeer

Hi,

I am installing EP with NAV 4.0.3 on a front end machine meanwhile the SQL Server is behind firewall.
With the Navision Client I can connect to the database and work with it, so comunication is fine.

On the front I have : Navision Client, NAS and Employee portal front end parts. Sharepoint is working.

The problem : when I try to start NAS I got the following messages in the aplication LOG :

The first is saying that NAS could not be started and will try on 30 sec and the second is telling that the primary key does not exists.

Thus anyone knows how to solve this issue??

I did the instalation as in the manual, using the NEP_USER, NEP-1 as code. The Queues are created, but does not seem to work

DenSter

Please paste the whole message in here.

kine

You need to configure NEP in your DB, there must be entry in the setup table for NEP-1 backend server and the key-pair must be generated. Follow the NEP documentation.

tomdebeer

Hello Kine,

I've tried do create the entrey several times, but when I try to create the backend keys I' got in Navision the same message, ther apears a messagebox telling that the primary key "" does no exist.

Any idea what am I doing wrong ??

kine

And is there name of the table?

dpardom

I had the same problem,
make sure that in table 6800-"Employee portal setup" has "primary key" field = ""
I think that some configuration tables are not auto-filled when the database has been autoupdated by navision recent versions, this DB autoupdate also gave some problems with business notifications..

Maybe the best solution is to create the configuration on a cronus and then copy the record(s).

greets.

DenSter

the primary key "" does no exist.

This is not the whole message. There is also a table name in there. The message should say something like "Record <blabla> does not exist, primary key <blabla>". Please copy the entire message so we can tell you what to do.

You probably need to create a setup record with the correct values. All the steps to set up EP are in the installation manual, you should be able to figure out which setup to create.

tomdebeer

Hello,

Finaly we have solved the problem. Putting the values in table 6800 as in a Cronus database and it worked fine.

NOTE : When the mssbox with the error apears it does no give information about the table nº, we had to find it using the object designer.

Thanks for all the people who helped me.

Tom