You want to update the Experian password for certain Aurea's users as Experian shows the account locked and that is possibly why you are not getting the identity questions returned during a customer enrollment.
Solution
Please raise a support ticket with us specifying the Aurea username and new Experian password combination. We will update the password and inform you once done.
<supportagent>
Pre-requisite
- Access to BillingAdmin database
Stream uses Experian to pull information critical to its business. Experian uses authentication information that is managed by Stream but the changes in the credentials are communicated to Aurea and we need to store the updated information with us in the database.
Stream updates the authentication credentials and communicates the usernames and their passwords which have been updated. This information is then stored by us in the processconfigurationsource
table in the paes_Billingdmin
database. A sample set of records is as shown below
ProcessConfigurationID |
ProcessTypeID |
ParameterName |
ParameterValue |
83411 |
36 |
CreditCheck_UserID |
ista.creditcheck |
83412 |
36 |
CreditCheck_Password |
abcdef01234567 |
To locate the rows that need to be updated, execute,
select * from processconfigurationsource pcs
join processtype pt on pt.processtypeid = pcs.processtypeid
where clientid = 45 and
description like 'Experian%'
Note that clientid
45 is fetched from the Client
table in the paes_BillingAdmin
database, and this value corresponds to Stream Energy. Since this request will only originate from Stream, this value doesn't need revisiting.
Locate the relevant password rows to update, which would usually be followed by their username rows. A few frequently used usernames are albumen, albumen_nc, ista.northeast, ista.creditcheck.
Once the rows containing the password values are located, update the password with an UPDATE SQL statement.
update processconfigurationsource
set parametervalue = '<client provided password in clear text>'
where processconfigurationid = <ID as retrieved from the select query above, or the table above>