Company: Link Technologies
Case No: L07296. Project: 07.50: LinkSOFT Version 7.5
Logged By: Alvis (Link Technologies) on 07 Dec 2015 08:49AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 5.50 (Weight: 5.50)
Version: 07.500.0904
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Sanjeet, Vineet
Resolve By: Monday, 07 December 2015 12:00 AM [3064 days since logged date]
Status: Closed
Subject: When importing licence from BO, the licence name does not get updated in sy_module causing POS and reporter to fail
Summary:    When importing licence from BO, the licence name does not get updated in sy_module causing POS and reporter to fail
Audit Notes:
07 Dec 201511:01AM Comment 1 by Sanjeet (Link Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 07-12-2015 11:01 AM Time Taken: 1.00

Hi Vineet,


Development completed. Please add this call to UAT sheet. Will be availabe for QA in this evening's patch.


Regards

Sanjeer


08 Dec 201509:24AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjeet (Link Business Solutions) Followup Date: 08-12-2015 09:24 AM Time Taken: 1.00
Hi Sanjeet, there is still a problem with license update script. The max_users in module table is not updated to 1000. 

See profiler:

UPDATE sy_control SET licensee = 'Link Technologies', expiry_date = {ts '2999-12-31 00:00:00.000'}, max_user = 1000, max_emp = 1000 WHERE system_license = 'SY233616' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'DE1346962072743', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'DEB' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'EX7464774221532', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'EXT' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'HR1229085225296', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'HRM' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'IN1444632874494', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'INV' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'LT1481392680778', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'LTT' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'PA2531220543966', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'PAY' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'PO1999390071057', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'POS' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'PU1783013669812', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'PUR' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'RE2528533137693', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'REP' 
go
UPDATE sy_module SET LICENSE_NAME = 'Link Technologies', LICENSE_ID = 'SA2756454306611', MAX_USERS = 1, EXPIRY_DATE = {ts '2999-12-31 00:00:00.000'} WHERE MODULE_ID = 'SAA'


08 Dec 201502:49PM Comment 3 by Sanjeet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 08-12-2015 02:49 PM Time Taken: 1.00
Added max user to update statements

09 Dec 201511:15AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjeet (Link Business Solutions) Followup Date: 09-12-2015 11:15 AM Time Taken: 1.00
Hi Sanjeet, icense update is still not updating max users.

I think its using the max_users value that is currently saved in the table SY_CONTROL. its not picking the new values from the license file.

See profiler results below:



09 Dec 201503:48PM Comment 5 by Sanjeet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 09-12-2015 03:48 PM Time Taken: 0.50
Resolved issue.

09 Dec 201504:43PM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 09-12-2015 04:43 PM Time Taken: 1.00
Tested, working fine. closing case.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L07296 in the subject line of all emails regarding this issue.

Document size: 6.3 KB
For call complaints, please contact the Managing Director of the company using this form.