NAS cannot find the db "You have not selected a database"

vandang

Hi all,

I have installed a NAS on the Administrator window login, it can start NAS successfully. The issue happen when I create a new Window login and try to start that NAS after open NAV client with native database. then I got the message "You have not selected a database". I checked the on the "log on" tab of NAVMY and it set the the account for NAVMY already. Could you give me any advices, thanks!

ta5

Hi
Classic-DB or SQL?
Did you check the NAS configuration in the mmc snap in?
Regards
Thomas

vandang

Hi ta5,

Thanks you for reply, it's using Native database I checked NAS setup with

Database Server Name = localhost
Database = <blank>
Company Name = <company name in database>
Start-up parameter = jobqueue
Net Type = TCP/IP
Object Cached Size = 32000
Service Status = Started

And when I start the service, Event viewer said that:

The Application Server for Microsoft Dynamics NAV USER-PC-ClASSIC started with the following configuration:

Database Server Name = localhost
Database = <blank>
Company Name = <company name in database>
Start-up parameter = jobqueue

In Job Queue Processes form, there is one line With Proccess is running = true, but the Object Type Running and Object ID Running is empty. My question now is why NAV cannot the the information regarding to those fields?

DenSter

Did you actually set up jobs to run in the Job Queue?

vandang

Hi DenSter,

I set "log on" on NAS services for window login server.

Regarding to Job Queue setup, I created 2 Recurrence Job Queue Entry Card one for Scheduled Tasks and one for SMS Send. Then Active Job Queue with NAS started

DenSter

I think your problem is with your Job Queue setup, not NAS. That message says it started with the right parameters, so NAS is running. Then your Job Queue itself is started, so there must be a problem with how your jobs are set up.

Check the status of the Job Queue Entries, make sure that the start time is correct. I would probably enter a bogus job that's not recurring just to see if it executes.

vandang

Thanks DenSter for quick reply,


The status for Job Queue setup is "Ready". Just put the recently time to "Earliest Start Time" for not Recurring Job. But it's still not working

DenSter

You need to go through your setup again and doublecheck everything, and troubleshoot the issue from there. Check the event log for errors from NAV. Use the debugger to see if it finds the job. Look at the field values there, figure out where it looks for certain values and step through the code to verify that it runs and why it is not doing what you expect.

You should probably get your NAV partner involved at this point, and if you work for the NAV partner get someone more senior involved. Someone needs to troubleshoot this with you if you are stuck.

vandang

Dear DenSter,

Please tell where can I start debug through it because when I click "Job Queue > Reset Status" it's not call to any codeunit or table.

Actually I cannot connect to partner, and the senior is always busy so I just have only way is raise this issue here...