Micros NetVuPoint 1

[yelman]

Hi Guys,

I just installed the 9700 system and netvuponit,but i cannot access the netvupoint system i get the username or password is incorrect please advise.

 

[hosehead78]

Ok, I have a fix for you. There are some manual steps for editing files and such, along with needing access to the DB to create a new user. I will post the files and info shortly for you.

 

[hosehead78]

Here yo go.

https://app.box.com/s/qb372v0twknasl5qht0aguog2vvbmzt9

I've tested this on my Micros 9700 v3.6 Lab. This will fix the issue with the "Login failed for user 'sa'" error. Stsart on page 4 of the doc within the zipped file. If you do not have the files the doc talk about, then extract the NameChangeNVP.exe file to the '<Micros Drive>:\MICROS\LES\POS\9700\bin' folder and continue with the instructions. Let me know if you have any issues.

 

[yelman]

Hi Hosehead78,
First of all thank you so much.

i have done all steps but im always getting the same error:

please find attatched the wrapper.log file.

 

[hosehead78]

Are you still getting the same error in the log file?

Can you log into EMC and create a new account, instead of using the micros one?

 

[yelman]

no there is no more invalid login errors in logs also i tried with another user account that i have created into EMC but always the same problem.

 

[hosehead78]

Once you create an Account, sign out of EMC and sign in to EMC with that new account. It should ask that you change the password. Once you have done this restart the NetVu Point services and try again.

 

[yelman]

Always the same problem

 

[yelman]

Always the same problem

 

[hosehead78]

Run the following Query in MS SQL Studio Management. See if the user you are trying to access is actually in the DB for NetVu point.

--################################################################################
-- Author: Chad Freiling
-- 
-- Usage: 
--	Run script in SQL Query window when connected to MICROS 9700 Database
--	Query Returns all Active Employees
--	If an Employee is set to Position 86 - Terminated, they will not show up.
--	There is a filter on the LastName, as these are not actual micros accounts, 
--	they are more so headers or system accounts.
--################################################################################

select 
	a.posref as #		-- Micros Account Number
	,a.LastName as LastName
	,a.FirstName as FirstName
	,a.userName
	,SUBSTRING(REPLACE(a.posPwd,'0',''),1,10) as CardNum
	,CAST(b.employeeclassPOSRef AS nvarchar(20))+'-'+ b.name as EmployeeClass
	,emp.RevCtrID

from LOCATION_ACTIVITY_DB.dbo.employee a

Join LOCATION_ACTIVITY_DB.dbo.employee_class b on a.employeeclassid = b.employeeclassid
Join MCRSPOS.microsdb.EMPLOYEE emp on a.posref = emp.ObjectNumber

where a.employeeclassid = b.employeeclassid
And a.userName <> ''		-- Removes all blank entries
And b.name Not In ('Terminated', 'Micros')
And Not a.posPwd = '00000000-1'		-- Removes -1 entries, Generally Deleted/Term'd Employees

order by a.posref, a.lastname

 

[yelman]

Hi hosehead78 ,

i got one row as result:

??? what does mean,how can i resolve this issue.

 

[hosehead78]

Remove or Comment out the And b.name Not In ('Terminated', 'Micros').
Comment out by adding -- in the beginning of the line.
example:
--And b.name Not In ('Terminated', 'Micros'). See if any others come up.

Also, in EMC Configurator, go to Employees > Maintenance and locate that Employee. Is the username the same as you see there? If so, reset the password for that user. Then close EMC and log back in to EMC using that username and new password. Once you sign in you will be prompted to change the password. Change it and then log out. Then on the server restart the NetVu Point services. Once you have restarted the services, try the account again in NetVu point.

 

[yelman]

im getting the same result even after that i comment the And b.name Not In ('Terminated', 'Micros'),and for the username it's not the same as in EMC ??

 

[hosehead78]

Is the micros account number (#) the same?

 

[hosehead78]

Run just this. It will pull all Accounts, with and without usernames. Do you see any in there?

select *
from LOCATION_ACTIVITY_DB.dbo.employee

 

[yelman]

yeah im getting a lot of users??

 

[hosehead78]

Clean it up a little and make it easier to read. The query below will show any users with valid names and passwords. Is the account you have been using listed?

select 
   posRef,
   lastname,
   firstname,
   username,
   password
from LOCATION_ACTIVITY_DB.dbo.employee

Where username <> '
and password <> '
order by posRef, lastname ASC

Can you login to this url: http://[YOURSERVERNAME]:8080/vupoint/Login.aspx using the account that gets you into EMC?
Where [YOURSERVERNAME] is, is the name of your server.

 

[yelman]

the account that im using to access in EMC is not listed and i tried to logged in with a listed account but always the same problem i think that EMC is not linked with nvp

 

[hosehead78]

That might be the case.

Run these queries. When are the last run times for each of them?

Select *
From MCRSPOS.microsdb.netvupoint_nightly_jobs

Select *
From MCRSPOS.microsdb.netvupoint_polling_schedules

Also, go into EMC > Configurator > System Parameters.
Go to the NetVu Point Settings. it should have default setting.
Dataviewer: http:\\[yourservername]:8080/vupoint
NetVu Point: http:\\[yourservername]

 

[hosehead78]

Ok, I think have a fix for you. I am trying it on my Lab server first before I pass it on.
I think the issue is the "link" between the EMC profile and the NVP profile. Being this might be the case for others, I am going to write a how to for it and share it. I will post back later today.

::UPDATE::
I will have the doc ready tomorrow.

 

[hosehead78]

Here you go.

https://app.box.com/s/icng6cxilvlkrtgo2fbp49lorx3hkenx

You've already done the first part, so move on the the 2nd option, which starts on page 10.