Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
c3s_credit_card_issues [2019/01/30 09:22]
127.0.0.1 external edit
c3s_credit_card_issues [2019/02/06 10:52]
admin
Line 1: Line 1:
-====== ​ ====== +==== Description ​====
- +
- +
- +
-Description +
- +
- +
 ====== Unmask credit card number only shows first four digits ====== ====== Unmask credit card number only shows first four digits ======
  
Line 17: Line 10:
 **Solution** **Solution**
   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.
- 
  
  
Line 24: Line 16:
   - Run this query:   - Run this query:
  
-**UPDATE** StoreData.dbo.AccountContact +<code sql> 
- +UPDATE StoreData.dbo.AccountContact 
- +SET ModifiedDate = GETDATE() 
- +, ModifiedByUser = '​CyriousTech'​ 
-<​html><​div style="​margin-left:​ 20px;">​ **SET** ModifiedDate = **GETDATE**() </​div></​html>​ +, IsCCNumEncrypt = 1 
- +, DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber 
- +, CCCSCustomerGuid = NULL 
- +FROM [StoreData].dbo.AccountContact 
-<​html><​div style="​margin-left:​ 20px;"> ​, ModifiedByUser = '​CyriousTech' ​</​div></​html>​ +LEFT JOIN [43_StoreData].dbo.AccountContact OldAC ON OldAC.ID = AccountContact.ID 
- +WHERE CCCSCustomerGuid IS NOT NULL 
- +</code
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, IsCCNumEncrypt = 1 </​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, CCCSCustomerGuid = NULL </​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **FROM** [StoreData].dbo.AccountContact ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **LEFT JOIN** [43_StoreData].dbo.AccountContact OldAC **ON** OldAC.ID = AccountContact.ID ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **WHERE** CCCSCustomerGuid ​**IS NOT NULL** </​div>​</html>+
   - Restart the SSLIP.   - Restart the SSLIP.
   - Start Control. Control will again run through the process of updating existing credit card number to C3S.   - Start Control. Control will again run through the process of updating existing credit card number to C3S.
Line 62: Line 32:
  
  
-===== Elevon ​information fields not appearing in Account Setup\Unable to Process Credit cards =====+===== Elavon ​information fields not appearing in Account Setup\Unable to Process Credit cards =====
  
  
Line 83: Line 53:
  
  
-====***Always ensure that you are using the most current version of the C3S files***==== +==== *Always ensure that you are using the most current version of the C3S files* ====
  
 **Resolution #1: Modify the C3S Connection String** **Resolution #1: Modify the C3S Connection String**
-  - Open the SSLIP_Options.txt+ 
 +   - Open the SSLIP_Options.txt
   - Add this option to the file and save: UpdateC3SHostConfig=0. This will prevent the SSLIP from overriding the changes that will be made next in the C3S Host configuration file.   - Add this option to the file and save: UpdateC3SHostConfig=0. This will prevent the SSLIP from overriding the changes that will be made next in the C3S Host configuration file.
-  - Open the C3SHost.exe.config file located in ...\SSLIP\Utilities\C3S\.+  - Open the C3SHost.exe.config file located in \SSLIP\Utilities\C3S\.
   - Delete the "​Integrated Security=True"​ parameter from the connection string.   - Delete the "​Integrated Security=True"​ parameter from the connection string.
   - Type in User Id=USERNAME;​Password=PASSWORD*;​   - Type in User Id=USERNAME;​Password=PASSWORD*;​
Line 95: Line 66:
  
 **Resolution #2: Add User to SQL Server login** **Resolution #2: Add User to SQL Server login**
 +
   - Modify SQL Server to allow the user the SSLIP will run from as an accepted login user.   - Modify SQL Server to allow the user the SSLIP will run from as an accepted login user.
  
 **Resolution #3: Switch Users** **Resolution #3: Switch Users**
-  - Run the SSLIP as a user that has rights to the SQL Server database. 
  
 +  - Run the SSLIP as a user that has rights to the SQL Server database.