Mobile VO validated error troubleshooting

Mobile VO validated error troubleshooting




Make they are all a T or A (Tech or All)

Make sure they have a schedule under employee -- Tech/Employee module for days, time in and time out

This script may help you below :

 

 

select        

      --      7210 as [Subject],

          --  7210 as Username,       

            EMail = isnull(Email, '...'),          

            Fullname = [Name],

            [Admin] = cast(0 as bit),

            VirtualOperatorId,

            DealerId = DealerCode,

            EmployeeCode as DbId,

            Validated = convert(bit, 1)

        FROM

            dba.Employee

        WHERE

            employeetype in ('A', 'T')

            and (DateFired is null or DateFired > today())

            and VirtualOperatorID = 7210

            and VirtualOperatorPassword = 9545

            and AccountLocked = 'F'

            and (TechLoginDays) > 0

            and convert(time, now())  between TechLoginStart and TechLoginStop

        ORDER BY   

            employeeCode

 

This is an extra script below:

select Name,VirtualOperatorID,EmployeeType from DBA.Employee where VirtualOperatorID is Not NULL



    • Related Articles

    • Troubleshooting Error Messages

      Questions to ask when troubleshooting Error Messages If you receive an error message within your Micro Key software, here are questions to ask before reporting the issue: Is this a single incident? Can I force replicate it? If so, what are my steps? ...

    • Web Dealer - Updating subscriber central station record generates error stating "Error Updating Data"

      When logged into web dealer and you attempt to update the central station record. An error is generated stating  "Error Updating Data" Check to make sure that all the required fields like "Date on line" and "Town Code" have a value. In this case, the ...

    • Network performance view - simple tools

      Use TCPING to view how your network is performing TCPING is a unique tool that packs a lot of tools into a small application. It’s a console application that works like the built-in Windows ping, but it’s much more powerful and can provide you a lot ...

    • Micro Key Software Support Site / Emergency Daytime Support / Submit a Ticket

      Micro Key Solutions provides software support through our online support portal at https://support.microkey.com/. This site is available 24 hours a day and is used for NON Emergency support questions and answers. In order to utilize our support ...

    • Cluster Failover Procedure (MKSCluster.exe)

      Cluster Fail-over Procedure and Recovery When the system is operating normally the servers should be running the following applications. Primary Server (the server actively running the SQL Anywhere Server - database server engine), and Signal ...