Analysis Models - Data Load Run Error

Hi @himasha.abeywickrama,

We extract data from IFS Cloud Oracle database and load into SQL server database using “IFSINFO” user account.

It seems like you are using wrong credentials for the IFSINFO username and password secrets.

There should be another error message “invalid username/password” in the SSIS error log for some other data source.

During the data load when multiple requests are made with wrong credentials eventually the account gets locked and we get this error message.

unlock the user account (https://www.oracletutorial.com/oracle-administration/how-to-unlock-a-user-in-oracle/) and then check the secrets for IFSINFO username and password in the ifscloud-values.yaml file.

1. ifscore.passwords.ifsamIfsinfoPassword
2. ifscore.secrets.ifsamIfsinfoUsername

I assumed this is a remote installation. If this is a IFS managed cloud issue might have to check the secrets in the key vault and see if they are working. 

Make sure that you can connect to the oracle database using IFSINFO user  using the credentials set in yaml file through SQLplus or something just to make sure and then run the “Environment setup assistant” again.

https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/060_chk_env_params/

https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/070_run_env_setup/