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>