We had to change our AD passwords and now we get the following error but we have no idea where to change the password that is failing.
Processing...
Job on line 27 of the rollup schedule table began at 2021-04-12 13:38:47
Status: Running
Running Command: BigDataInsight\UC\SSIS\cmdgwy.bat
Status: Command BigDataInsight\UC\SSIS\cmdgwy.bat, on line 27 completed with exit code 1
Status: Output for Command BigDataInsight\UC\SSIS\cmdgwy.bat, on line 27.
--------------------
E:\Prognosis\Server\Configuration>set /a result1=0
E:\Prognosis\Server\Configuration>set /a result2=0
E:\Prognosis\Server\Configuration>set /a result3=0
E:\Prognosis\Server\Configuration>REM Load lookup CSV files
E:\Prognosis\Server\Configuration>pushd E:\Prognosis\Server\Configuration\
E:\Prognosis\Server\Configuration>call irperl "E:\Prognosis\Server\Configuration\BigDataInsight\UC\SSIS\LoadCSVFiles.pl" --dest-db "BigDataInsightUC" --sql-server "SPW099SQL05.compucom.local" 2>&1
Processing Descriptions...
Done.
Job 'PrognosisBDI_UC_Start_ETL' started successfully.
message
Unable to start execution of step 1 (reason: Error authenticating proxy compucom\$progsqladmin, system error: Logon failure: unknown user name or bad password.). The step failed.
The job failed. The Job was invoked by User COMPUCOM\$progsqladmin. The last step to run was step 1 (PrognosisBDI_UC_Start_ETL_cmd).
(2 rows affected)
--------------------------------------------
Prognosis run ETL Failure ( Status : 0 )
--------------------
Job on line 31 of the rollup schedule table began at 2021-04-12 13:38:53
Source database: UCSC-Reports
Source node: \SPW099PGN14
Target summary template: file:IPTM\CUCS\UCSC-Reports 5 Minutes.txt
Target database:
Target node: Current Node
Status: Running for \SPW099PGN14 at 2021-04-12 13:38:53
Status: Complete - Successful
Job on line 31 of the rollup schedule table finished at 2021-04-12 13:39:01
...Complete
<< Command Completed >>
Thank you
