About NicOla

NicOla · ‎Jun 24, 2020

Hi Jim, thanks for your time . We managed to fix the last issue with a reboot. Out App Portal is up and running. Our next step is to figure out the root cause. We can work with the support team on that one. Cheers, Nic

NicOla · ‎Jun 24, 2020

Our version is App Portal 2019 R1 (14.0.0.0). I replaced the exe earlier today and users could get into every tab and work in 'My Requests', 'Approve/Reject' . I did stop the ESDSErvice before i made the copy and start it up after. It was only after we re-enable our email that this issues appeared. Would you know if there a way to check if the version is incorrect and maybe get a new version of the exe?

NicOla · ‎Jun 24, 2020

Thanks Jim, We are having even stranger issues now... We removed the rows from [WD_MailQueue] as per Flexera Supports instructions... DELETE FROM [WD_MailQueue] WHERE ID > 226029 AND [StatusID] = 0 AND [subject] ='Appstore: Approval Reminder...' We had already copied the new ESDService.exe and we had stopped and started the ESDService wile we copied the new exe over. The had been working fine today (apart from us not having email enabled). We added the setting back to the SMTP Relay server to get email going again, then restarted the service again. Now when any one clicks on any of these tabs below: They get this error: Also - just to note - we had not made any recent change to any part of our App Portal. We enabled Flexible email approval over a month ago and that was working fine. Have you come across anything like that before? We do have a case open too and I uploaded out log files to that.

NicOla · ‎Jun 23, 2020

Thank you Jim. You said this issue has been seen before. I replaced the EDSService.exe but have not re-enabled outgoing emails yet. We are seeing something strange now. Old requests that were already approved are appearing and having comments added which say 'Auto-Approve'. I can see also there are emails queued to go out to requesters (as in the initial email a requester will receive when a users requests an application) but the requests are from 2019. Has that happened before in conjunction with this initial issue?

NicOla · ‎Jun 23, 2020

Thanks for that Jim, We have 30, 000+ items that are in a pending or sending status. We can delete them manually from the Site Management > Logs > Email Log however I think this will take hours. Is there a quicker (safe) way we can get rid of these too?

NicOla · ‎Jun 23, 2020

Hi Charles, I emailed support last night - but I think the support ticket still needs to be manually created. I just did that now and created case - 02155900. Is there any chance you could attach the fix the that please? Thanks again.

NicOla · ‎Jun 23, 2020

We are having an issue where our “Reminder to approve requests” emails are being sent out in bulk. In the last hour 3000+ emails have been sent out. It looks like they are only being sent out to approvers who have pending approval requests. Some approvers are getting 50 to 100 emails each. It appears that the “Reminder to approve requests” emails have not actually been sent since about August 2019 – we did not notice they were not being sent out – so maybe this is some kind of backlog catch-up? To stop this until we figure out how to fix the issue we removed the SMTP Relay Server setting in the Site Management – Settings – Email – Outgoing email tab To purge backed up emails we will go into Site Management > Logs > Email and select them and delete them. Is there a way to stop the ‘Reminder to approve requests’ emails? The ‘Send schedule reminder email’ option is unticked (under Site Management – Settings – Email – Outgoing email tab). Can anyone think of anything that could help us fix and do a root cause analysis on this?

NicOla · ‎Jun 17, 2020

Is it ok to install RSAT on my App Portal application server (Windows Server 2012 r2)? I want to use the AD Powershell module for some of my Catalog Item Script commands (they will be run from the server). Cheers.

NicOla · ‎Jun 13, 2020

Thanks Charles, I did need to use the 'delete from wd_nodesecurity'. I can now log in - when I go to Admin - Security I get an 'unexpected error'. I can see Catalog items under Catalog Management - which is what I'll need to see most right now as I intend to use our Dev App Portal environment to test the scripted adding of Catalog Items (with Alerts and Security Settings). I manually added in a General Catalog Item via Admin -> Catalog Management -> New Catalog Item Wizard. So I'm hoping I can run my testing here too. If there's an easy way/fix for the 'unexpected error' let me know. It is our DEV enironment - so errors in it are not a big deal. This is the error in the Website.log Unhandled Exception http://localhost/esd/admin/UserSecurity.aspx Current security context is not associated with an Active Directory domain or forest........ Cheers.

NicOla · ‎Jun 12, 2020

My App Portal dev environment is not looking too good (I have not been there for a while). When I launch App Portal it doesn’t log me in, I just see Approve/Reject and Proceeded Tab. I looked at the ActiveDirectory.log and there is an error --> Error reading GUID from user <username> error is The server is not operational. In Website.log the error is GetGUIDFromDN Method error for DN=CN=<FirstName Lastname (X-Account)>,OU=X Accounts,OU=Service & Data Management,DC=test,DC=internal,DC=macquarie,DC=comTargetDomain=TEST: The server is not operational. at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.RefreshCache() at System.DirectoryServices.DirectoryEntry.FillCache(String propertyName) at System.DirectoryServices.DirectoryEntry.get_NativeGuid() at SelfService.ActiveDirectoryAppCodeRepository.GetGUIDFromDN(String DN, String TargetDomain) If I can’t log in to my DEV Instance of App Portal … is there any other way I can fix/trouble shoot this issue? I have full access to the server but don’t have ant other account to log in with right now. Thanks

NicOla · ‎Jun 12, 2020

Thanks Charles, I'll try to add through a DB update. Thanks for confirming the tables.

NicOla · ‎Jun 11, 2020

Thanks for your reply. I feel submitting an enhancement might be a long process. We are have an application request self service option for our Developers where the packaging, SCCM Import and (most of the) Import to the App Portal is automated. The only parts missing is in the App Portal import (Adding an alert for catalog items and adding the security tab setting to add a user to an AD group). I was hoping the template would work as I already uses templates for copying settings in the Actions tab. Are there any APIs available I could use to achieve either of these requirements? If not, for the Alert – would we simple need to add to the WD_WebPackageAlert table and set the EnableAlert in the WD_WebPackages To 1? I’m not sure how to copy the Security tab settings – it would be the same AD group every time – it would have been handy to do this via a template. Maybe I can use an action instead. Please let me know if you have any ideas.

NicOla · ‎Jun 11, 2020

I’m looking for some guidance on using Catalog Item Templates. I use Catalog Item Templates to successfully copy Catalog Item settings from -- General -> Global tab (for example the ‘Request options’ get copied) -- Actions tab These work really well and save us a lot of time and manual effort. I now need to create a template to copy an Alert (General -> Alert tab) and also the security tab (to add user to AD group when the Catalog Item is requested) I have tried a number of time – but these settings never seem to be copied to the new Catalog Item. Setting from the General -> Global tab DO get copied so I know the template is being picked up (it’s also listed under Catalog Management – Administration – Catalog Templates) and the ‘is enabled’ is ticked under Global Options. Adding the Alert and setting up the security setting is not something we want to do manually every time we import new Catalog Items as we have the rest of the process fully automated (right through to setting up the application in SCCM to importing the Application into the App Portal). Am I doing something wrong or is there a limitation on what properties and setting can be copied using Catalog Item Templates ( I really hope there is not a limitation). Thanks in advance!

NicOla · ‎Jun 11, 2020

Thanks, this was something we were investigating. It's good to know it is possible. I think we might be able to create just one command and import it in the correct way and then use a template to assign it to future Catalog items. We can pass in different variables each time to the command ( ##MachineName## ##PackageID##) which should run the script to get the specific outcome we want for each catalog item.

NicOla · ‎Jun 09, 2020

Is it possible to Add a new command (PowerShell script) by copying it directly into …\Program Files (x86)\Flexera Software\App Portal\Web\Uploads\Commands without going through the Admin (Site Management – Commands & Actions – Script Commands : NewCommand) and then updated some table(s) – like WD_clientCommands? If not – is there any APIs to Add new command files? We would then have that command be related to a named Catalog Item (to be called when a user selected ‘Install Now’), we would like to do this using PowerShell also. We import all our new apps into App Portal using PowerShell, we also update all our existing catalog items using PowerShell, we are investigating adding commands to some of our Catalog Items – just wondering if this is feasible or if anyone has any experience doing this (or if this is a bizarre idea). Thanks

Online Status	Offline
Date Last Visited	‎Feb 07, 2023 10:33 AM

Re: Reminder to approve requests - being sent out every minute

Re: Reminder to approve requests - being sent out every minute

Re: Reminder to approve requests - being sent out every minute

Re: Reminder to approve requests - being sent out every minute

Re: Reminder to approve requests - being sent out every minute

Re: Reminder to approve requests - being sent out every minute

Reminder to approve requests - being sent out every minute

RSAT on my App Portal Server

Re: Can't log in to App Portal (DEV instance)

Can't log in to App Portal (DEV instance)

Re: Catalog Item Templates

Re: Catalog Item Templates

Catalog Item Templates

Re: Alternate way to add a command

Alternate way to add a command

Re: Multiple approval workflows on checkout

Re: Multiple approval workflows on checkout

Multiple approval workflows on checkout

Re: Query to get users groups within named Approval Groups

Re: Query to get users groups within named Approval Groups

Query to get users groups within named Approval Groups

Re: SetAlternateApproverAndOutOfOffice API

Re: SetAlternateApproverAndOutOfOffice API

SetAlternateApproverAndOutOfOffice API

Re: Order on Behalf of Limit