Trigger on License information

Trigger on License information

------------------This article is for only internal use ------------------------

Product version:          

iVend 6.6 With SAPB1 10

Problem statement:

User got the license expiry message however licenses were valid with their date.

Symptoms:

There are many different users who access iVend HO MC from different machines & their machine regional settings are different.

Proposed Solution/Workaround:


There are many different users who access iVend HO MC from different machines & their machine regional settings are different but it is difficult to identify which machines are casusing or generating incorrect licenses information 
There is below SQL Trigger which can be used to find the same
1.CREATE TABLE [dbo].[Custom_Customer_tblTriggerAuditRecord]([HostName] [varchar](100) NULL,
    [UpdatedDate] [datetime] NULL,[UpdatedBy] [varchar](100) NULL) ON [PRIMARY]
2.ALTER TABLE [dbo].[Custom_Customer_tblTriggerAuditRecord] ADD  DEFAULT (getdate()) FOR [UpdatedDate]
3.create trigger Custom_Customer_trgTriggerAuditRecord on SysSystemInformation after update, insert as
begin
insert into Custom_Customer_tblTriggerAuditRecord (HostName, UpdatedBy) Select Host_Name(), SUSER_SNAME()
end

It should be deployed after discussing with L3 team


    • Related Articles

    • License Expired, please contact vendor

      Problem Statement: Getting an error "License Expired, please contact vendor.". However, you are using a valid license. Solution: - Please follow below steps: - Please check the regional setting of the machine and make sure short date should be in ...

    • Check Support Contract Days

      How to Check the Number of Days for the iVend Maintenance and Support Contract All customers that are using iVend Perpetual Licensing, can check their time for renewal of their AMC (Annual Maintenance Contract) proactively and then start the renewal ...

    • How can we check the active license Information and its status.

      Query: - How can we check the License details and license's status. Answer: - Please follow below steps to check license status. --> Open "CXS license Administration Tool" --> Choose "Return a License " on Introduction Page --> Click next --> "The ...

    • License Issue : Getting Error license is expired

      Version : iVend 6.6 with SAPB1 Problem Statement: - iVend License was activated with valid to 31 Dec 2050 but while opening iVend MC/POS , it displays the error message “license is expired , please contact vendor “ iVend MC log file displays the ...

    • License File not found

      Problem Statement:- License File not found. Problem Description:- An issue comes to a specific user while using the Item matrix on the terminal server. Troubleshooting attempts : -- Gave user full permission to the item matrix folder on the SQL ...