Hello,

I am hoping someone can help me. I recently moved all my tasks from a Windows XP machine to a Windows 7 machine (installed 7.1.3). The transition was mostly painless, with the only exception being that my tasks will not run properly when the PC is locked. It runs but it seems that the send keystrokes function does not work in Windows 7 (I am trying to activate an accelerator [i.e. Alt-p] within an Excel file that was opened using the run command).

Other details...

* I have checked Enable software SAS (Vista & Windows 2008) to true
* I have enabled Secure Attention Sequence within the Local Group Policy Editor
* I have enabled UAC settings

Logon is set to:
When workstation is logged on: Logged on user
When workstation is logged off: Logon specified user
When workstation is locked: Unlock using specified user

Run with highest privileges is set to true.

Thanks in advance for any help!

Category Survey

Hi Ivan,

Are you able to watch the logon process outside of Remote Desktop?

If you are able to watch the logon sequence can you please confirm if Control+Alt+Delete is being sent successfully?

Category Survey

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700

Hi Ricardo,

Originally, I did not see a logon process but as of this morning, I finally see it occurring (AMLogin.aml runs).

The keystroke problem seems to have disappeared.

The problem now is that my script cannot detect a folder on the server even though it exists. I am using the UNC pathname (there are no spaces within the path). Even though the folder does exist, my script attempts to create a folder on the network.

Originally I have assigned the path to a variable but even when I hard code the path within the script, it still fails to recognize the folder.

It almost seems like Automate does not have the credentials to the server (the server is on a different domain). Yet when I try to connect to the path using the run command, no issues.

Any clues? Thanks for your response.

Category Survey

Edited: 01/16/2013 at 06:54 AM by IvanCurkovic

Hi Ivan,

Please post the contents of your task using the Attach Code button in your next reply. We need to review the contents in order to better troubleshoot the issue.


Leonard

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Here you go. Thank you.

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<!-- <AMPAUSE ACTION="waitfor" SCALAR="20" /> --> <!-- <AMSTARTTIMER /> --> <AMSTARTTASK MANAGEDTASK="Reports\Shutdown Excel" TASKID="{94DB40BE-9281-4F62-883F-E0508B555FAF}" /> <!-- <AMRUN FILE="C:\Windows\System32\ambpa32.exe" /> --> <!-- <AMSENDKEY>sodexo</AMSENDKEY> --> <AMVARIABLE NAME="Username"></AMVARIABLE> <AMVARIABLE NAME="Password"></AMVARIABLE> <AMVARIABLE NAME="Period"></AMVARIABLE> <AMVARIABLE NAME="CurrentYear"></AMVARIABLE> <AMVARIABLE NAME="ServerName"></AMVARIABLE> <AMFILEREAD FILE="C:\Automator\Reports\Essbase.txt" RESULTVARIABLE="Password" /> <AMFILEREAD FILE="C:\Automator\Reports\Period.txt" RESULTVARIABLE="CurrentYear" /> <AMFILEREAD FILE="C:\Automator\Reports\Server.txt" RESULTVARIABLE="ServerName" /> <AMTEXTREMOVE ACTION="remove_end" TEXT="%Left(Password, 9)%" RESULTVARIABLE="Username" /> <AMTEXTREMOVE ACTION="remove_end" TEXT="%Right(Password, 8)%" RESULTVARIABLE="Password" /> <AMTEXTREMOVE ACTION="remove_end" TEXT="%Left(CurrentYear, 2)%" RESULTVARIABLE="Period" /> <AMTEXTREMOVE ACTION="remove_end" TEXT="%Right(CurrentYear, 4)%" RESULTVARIABLE="CurrentYear" /> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // COPY FILES TO AUTOMATOR COMPUTER. --> <AMSQLOPENCONNECTION SESSION="cnAccess" CONNECTIONSTRING="AM19y9I4LjuL6XmCLAvRM48OiQXzPcJt2zNDf6g2L8y8OlibGYYt4mg6tR1rffSUmIbevDVwyYVuA+hQC62G7p+ev00RhJoxLfQ7Uge1C4fkPZ+WZyizErSd23BEtvjqmLuxCqU83UCLtaZ4e1dzGw6aQ==aME" /> <AMSQLQUERY SESSION="cnAccess" RESULTDATASET="dsBrandFiles">SELECT * FROM tblBrands WHERE Active = 1</AMSQLQUERY> <!-- // CREATE FY AND PERIOD FOLDERS --> <AMVARIABLE NAME="FileLocation">%dsBrandFiles.BrandPeriodNew%FY_%CurrentYear%\</AMVARIABLE> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // Create FY Folder --> <AMIF ACTION="not_exist" FOLDER="%FileLocation%"> <AMMESSAGEBOX>%FileLocation%</AMMESSAGEBOX> <AMCREATEFOLDER FOLDER="%FileLocation%" /> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // Create Period Folder --> <AMSET VARIABLENAME="FileLocation">%FileLocation%Period_%Period%\</AMSET> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMIF ACTION="not_exist" FOLDER="%FileLocation%"> <AMCREATEFOLDER FOLDER="%FileLocation%" AM_RETRY="3" /> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMLOOP TYPE="DATASET" DATASET="dsBrandFiles"> <!-- // RUN PERIOD REPORT. --> <AMRUN FILE="C:\Program Files\Microsoft Office\Office14\Excel.exe &quot;%dsBrandFiles.BrandPeriod%&quot;" /> <!-- // ENTER CREDENTIALS --> <!-- <AMWINDOWFOCUS WINDOWTITLE="Microsoft Excel - Brands Report_PER.xls [Compatibility Mode]" /> --> <!-- <AMWAITFORWINDOW WINDOWTITLE="Microsoft Excel - Brands Report_PER.xls [Compatibility Mode]" /> --> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMSENDKEY>{ALT}p</AMSENDKEY> <AMWAITFORWINDOW WINDOWTITLE="User Information" /> <AMIF EXPRESSION="%Val(Period)% = 1"> <AMSENDKEY>%Username%{TAB}%Password%{TAB}%Period%{TAB}%CurrentYear%{TAB}{SPACE}{TAB}{SPACE}</AMSENDKEY> <AMELSE /> <AMSENDKEY>%Username%{TAB}%Password%{TAB}%Period%{TAB}%CurrentYear%{TAB}{TAB}{SPACE} </AMSENDKEY> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="15" /> <AMSENDKEY>{ENTER}</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="5" /> <!-- // SAVE AS... --> <AMSENDKEY>{ALT}fa</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMSENDKEY>%FileLocation%PER_%Period%_%dsBrandFiles.Brand%.xls{ENTER}</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // IF FILE EXISTS, OVERWRITE --> <AMIF WINDOWTITLE="Confirm Save As"> <AMSENDKEY>{LEFT}{ENTER}</AMSENDKEY> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // CLOSE WORKBOOK --> <AMSENDKEY>{ALT}fx</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="10" /> <!-- // RUN YTD REPORT. --> <AMRUN FILE="C:\Program Files\Microsoft Office\Office14\Excel.exe &quot;%dsBrandFiles.BrandYTD%&quot;" /> <!-- // ENTER CREDENTIALS --> <!-- <AMWINDOWFOCUS WINDOWTITLE="Microsoft Excel - Brands Report_YTD.xls [Compatibility Mode]" /> --> <!-- <AMWAITFORWINDOW WINDOWTITLE="Microsoft Excel - Brands Report_YTD.xls [Compatibility Mode]" /> --> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMSENDKEY>{ALT}p</AMSENDKEY> <AMWAITFORWINDOW WINDOWTITLE="User Information" /> <!-- <AMPAUSE ACTION="waitfor" SCALAR="5" /> --> <AMIF EXPRESSION="%Val(Period)% = 1"> <AMSENDKEY>%Username%{TAB}%Password%{TAB}%Period%{TAB}%CurrentYear%{TAB}{SPACE}{TAB}{SPACE}</AMSENDKEY> <AMELSE /> <AMSENDKEY>%Username%{TAB}%Password%{TAB}%Period%{TAB}%CurrentYear%{TAB}{TAB}{SPACE} </AMSENDKEY> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="15" /> <AMSENDKEY>{ENTER}</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="5" /> <!-- // SAVE AS... --> <AMSENDKEY>{ALT}fa</AMSENDKEY> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <AMSENDKEY>%FileLocation%YTD_%Period%_%dsBrandFiles.Brand%.xls{ENTER}</AMSENDKEY> <!-- <AMSENDKEY>%dsBrandFiles.BrandYTDNew%{ENTER}</AMSENDKEY> --> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // IF FILE EXISTS, OVERWRITE --> <AMIF WINDOWTITLE="Confirm Save As"> <AMSENDKEY>{LEFT}{ENTER}</AMSENDKEY> </AMIF> <AMPAUSE ACTION="waitfor" SCALAR="2" /> <!-- // CLOSE WORKBOOK --> <AMSENDKEY>{ALT}fx</AMSENDKEY> </AMLOOP> <AMSQLCLOSECONNECTION SESSION="cnAccess" /> <!-- <AMREADTIMER RESULTVARIABLE="Username" SCALE="Minutes" /> --> <!-- <AMSTOPTIMER RESULTVARIABLE="Username" SCALE="Minutes" /> --> <!-- <AMMESSAGEBOX>%Username%</AMMESSAGEBOX> -->

Hi Ivan,

What is the exact error message that you are receiving and on which step?

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

I get a problem at line 28. Could not create folder path (Code 27214). It is supposed evaluate line 26 (to see if FileLocation exists). It does exist but the script does not seem to think so. It attempts to create the folder and that is where it ends.

Category Survey

Just an FYI...I just upgraded to Version 9.0.3.4 and I get the same problem. The error occurs at line 28 again but this time I get a new message: File System failed (Error : Logon failure: unknown user name or bad password.

I have logged on to the particular domain using a different username and password from the one I use to login to the Automate computer. Therefore the Automate machine already has access to the drive it needs. It just seems that this is not enough for Automate. Is there a place I should be storing this other username/password?

Thanks!

Category Survey

Edited: 01/17/2013 at 05:40 AM by IvanCurkovic

I think I solved the problem. I simply put the credentials for the other domain in the Service User section and it worked!

Just hate the fact that I will have to update the password every 45 days or so.

Category Survey

I think I spoke too soon. I am still having issues connecting to directories on a different domain.

Category Survey

Hi Ivan,

Does the user the task itself is running as (from the Logon Properties) have access to these network locations? Please provide as much information as possible so that we can better assist you

Category Survey

-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4