topic Re: SAS AML Jobs Failing to Run: fcf_aml_segmentation and fcf_aml_prep_vi_daily in Fraud, AML and Security Intelligence

SAS AML Jobs Failing to Run: fcf_aml_segmentation and fcf_aml_prep_vi_daily

Eric_01 — Wed, 02 Apr 2025 20:56:43 GMT

Hello Community,

I'm trying to generate management reports using SAS Job Execution, where a job is executed to enrich reports in Visual Analytics (VA).

However, I'm facing an issue where none of the jobs are running successfully in SAS Job Execution. I'm unsure if I'm doing something wrong or if I missed a necessary step.

I've attached the logs from the failed jobs in this post, hoping someone can help me troubleshoot and resolve this issue.

PS: I've already generated alerts.

These are the jobs👇

Thank you in advance!

Re: SAS AML Jobs Failing to Run: fcf_aml_segmentation and fcf_aml_prep_vi_daily

manishiiita — Thu, 10 Apr 2025 12:10:50 GMT

From your logs, the errors are related to libname statements. Please check. Probably, the user doesn't have employee access or db related access.

normal: FCF_EMPLOYEE_ACCESS=0
note: NOTE:  Credential obtained from Viya credentials service.
error: ERROR: CLI error trying to establish connection: connection to server at "SOCDEV" (10.1.2.45), port 5432 failed: FATAL:  
error:        password authentication failed for user "csbatchtenant1"

error: ERROR: Error in the LIBNAME statement.
note: NOTE:  Credential obtained from Viya credentials service.
error: ERROR: CLI error trying to establish connection: connection to server at "SOCDEV" (10.1.2.45), port 5432 failed: FATAL:  
error:        password authentication failed for user "csbatchtenant1"

error: ERROR: Error in the LIBNAME statement.
note: NOTE:  Credential obtained from Viya credentials service.
error: ERROR: CLI error trying to establish connection: connection to server at "SOCDEV" (10.1.2.45), port 5432 failed: FATAL:  
error:        password authentication failed for user "csbatchtenant1"

error: ERROR: Error in the LIBNAME statement.
normal: The definitions in the ENUSA locale are as follows:

Re: SAS AML Jobs Failing to Run: fcf_aml_segmentation and fcf_aml_prep_vi_daily

Eric_01 — Fri, 11 Apr 2025 15:06:50 GMT

Hello @manishiiita,

The main issue is that all users use the same password, and I’ve been able to log in successfully to PGAdmin with the same credentials. So I’m not sure why it’s failing during job execution.

Do you happen to know where the script or code for the fcl_aml_prep_daily job is located?

I’m specifically looking for the part of the code that establishes the connection — I believe there’s a line in there responsible for it.

PS: I’m not referring to the job execution wrapper with macros, but the actual base script with the DATA step and logic that runs the job.

Thanks in advance!