Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
c3s_credit_card_issues [2019/01/30 16:17] kcifreo [***Always ensure that you are using the most current version of the C3S files***] |
c3s_credit_card_issues [2019/02/06 10:52] (current) 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 = ' | |
- | < | + | , IsCCNumEncrypt = 1 |
- | + | , DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber | |
- | + | , CCCSCustomerGuid = NULL | |
- | + | FROM [StoreData].dbo.AccountContact | |
- | < | + | LEFT JOIN [43_StoreData].dbo.AccountContact OldAC ON OldAC.ID = AccountContact.ID |
- | + | WHERE CCCSCustomerGuid IS NOT NULL | |
- | + | </code> | |
- | + | ||
- | < | + | |
- | + | ||
- | + | ||
- | + | ||
- | < | + | |
- | + | ||
- | + | ||
- | + | ||
- | < | + | |
- | + | ||
- | + | ||
- | + | ||
- | < | + | |
- | + | ||
- | + | ||
- | + | ||
- | < | + | |
- | + | ||
- | + | ||
- | + | ||
- | < | + | |
- 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 | + | ===== Elavon |