Showing results for 
Search instead for 
Did you mean: 

Password failing in advanced reporter

05 Base Camper

Password failing in advanced reporter

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.

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\" --dest-db "BigDataInsightUC" --sql-server "SPW099SQL05.compucom.local"  2>&1
Processing Descriptions...
Job 'PrognosisBDI_UC_Start_ETL' started successfully.
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

<< Command Completed >>
Thank you


05 Base Camper

Re: Password failing in advanced reporter



I get the username password error when trying to access the BigDataInsight databases even though they are running.


Thank you

Community Manager

Re: Password failing in advanced reporter

Hi ,


Have you tried updating the following two passwords on the Prognosis Advanced Reporting Node?




Below is an online help topic with steps on how to make the actual edits in either interface.


Hope this helps.


Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar