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

    • 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 ...
    • How to setup ODBC Driver/Connection 64 bit

      How to setup your ODBC? Search your Start Menu in Windows for ODBC Select Add Select SQL Anywhere 17 (If not listed please select the next SQL Anywhere available) Select ODBC Tab: Data Source Name: Your Database Name (MKMSDEFAULT) Check Microsoft ...
    • 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 ...
    • 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  ...