SQL Server Agent – Report Failure but continue When intermediate step fails

I have a SQL Server Agent job that has three steps with the following control flow:

  • Step 1 – on success – Go to next Step. on fail – job fails
  • Step 2 – on success – Go to next Step. on fail – Go to next Step
  • Step 3 – on success – report success, on fail – report fail

However, What I want to happen is, if step 2 fails, run step 3 but report that the job has failed (regardless of whether step 3 is successful or not)

The only way I can think to do this is as per the screenshot below which duplicates the final step but the duplicate step reports failure if it succeeds

enter image description here

Is there a better way of doing this?

Custom endpoint failure after 2010 to 2016 migration

I’ve upgraded sharepoint 2010 app to 2016, it has 3 custom endpoints, and one of them is this one:

namespace AuthenticationWebService {     [BasicHttpBindingServiceMetadataExchangeEndpoint]     [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]     [ServiceContract]     public class AuthenticationService     {         [OperationContract]         [WebInvoke(Method = "POST",          BodyStyle = WebMessageBodyStyle.Wrapped,          ResponseFormat = WebMessageFormat.Json)]         public bool AuthenticateUser(string userName, string password)         {             return IsValidCredentials(userName, password);         }          internal static bool IsValidCredentials(string userName, string password)         {             bool isValid = false;              if (userName.IndexOf(@"\") > 0)             {                 userName = userName.Substring(userName.IndexOf(@"\") + 1);             }              string domain = SPContext.Current.Site.RootWeb.AllProperties["Authentication_Domain"].ToString();              using (PrincipalContext pc = new PrincipalContext(ContextType.Domain, domain))             {                 isValid = pc.ValidateCredentials(userName, password);             }              return isValid;         }     } } 

Simple really, just authenticates user in a few forms in order to confirm given action. This code was written for 2010 Sharepoint, and migrated to 2016 via visual studio upgrade.

Problem is, I can’t seem to properly call this endpoint in 2016, the same requests that work in 2010 gives me “400 bad request” in 2016. Any ideas?

WINE Install Repo PPA failure disco

I get this when trying to install WINE repo for my disco 19.04:

Err:12 http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu disco Release
404 Not Found [IP: 91.189.95.83 80]

E: The repository ‘http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu disco Release’ does not have a Release file. N: Updating from such a repository can’t be done securely, and is therefore disabled by default. N: See apt-secure(8) manpage for repository creation and user configuration details.

Wine still sort of installs but I have trouble understanding what this problem means for me. The goal is to install wine and play on linux so I can play all, or most, of my Steam games.

ACPI Error, two finger scrolling failure, on ThinkPad E480

A new Lenovo ThinkPad E480 laptop showed errors like PCI Bus error severity=Corrected among others. I searched for a solution and added the kernel boot parameter pci=nomsi permanently. The PCI error is solved, but there appears to be other errors as well:

[Do Okt 3 18:25:08 2019] Couldn’t get size: 0x800000000000000e

[Do Okt 3 18:25:09 2019] mmc0: Unknown controller version (3). You may experience problems.

[Do Okt 3 18:25:41 2019] iwlwifi 0000:05:00.0: pci_enable_msi failed – -22

[Do Okt 3 18:25:41 2019] ACPI Error: Field [TBF3] at bit offset/length 262144/32768 exceeds size of target Buffer (262144 bits) (20170831/dsopcode-235)

[Do Okt 3 18:25:41 2019] ACPI Error: Method parse/execution failed _SB.PCI0.GFX0.GETB, AE_AML_BUFFER_LIMIT (20170831/psparse-550)

[Do Okt 3 18:25:41 2019] ACPI Error: Method parse/execution failed _SB.PCI0.GFX0.ATRM, AE_AML_BUFFER_LIMIT (20170831/psparse-550)

[Do Okt 3 18:25:41 2019] [drm:dc_create [amdgpu]] ERROR DC: Number of connectors is zero!

[Do Okt 3 18:25:42 2019] Bluetooth: hci0: unexpected event for opcode 0xfc2f

that was shown to me after typing dmesg -T -l err in the terminal.

I also had issues with keys of my keyboard that wouldn’t react or get locked like the F1 to F12 and the Esc key. Today they functioned correctly but scrolling with two fingers didn’t function even though it was set in the settings.

How may I troubleshoot to resolve these issues?

Ubuntu Bionic Boot Failure googleapis

I recently updated my laptop that has Ubuntu installed on it to hopefully update it to 18.04 but upon boot I got stuck on something like, “Holding Gnome”, I forget what it was. But now I’m in the recovery mode root console and when I type

apt-get update 

I get

Err:1 https://storage.google.apis.com/bazel-apt stable InRelease    Could not resolve 'storage.google.apis.com' Reading package lists... Done W: Failed to fetch https://storage.googleapis.com/bazels-apt/dists/stable/InRelease Could not resolve 'storage.googleapis.com' W: Some index files failed to download. They have been ignored, or old ones used instead. 

I don’t know what to do from here. I was getting other linux-generic issues but I think I fixed those and now I’m stuck with this one. Any suggestions?

theHarvester: failure to import modules

I’m trying to install and run theHarvester. I’m running Ubuntu 16.04 LTS.

My default python3 is version 3.5.2. theHarvester requires Python3.6+, so I’ve installed Python3.6 and Python3.7 with sudo apt install python3.6 pthon3.7. My pip3 is version 8.1.1 (seems to be for python3.5).

I’ve run pip3 install -r requirements.txt to install the dependencies. When I do python3.6 theHarvester.py, I get the following errors:

Traceback (most recent call last):   File "theHarvester.py", line 10, in <module>     from theHarvester import __main__   File "/home/johnzhau/myTools/theHarvester/theHarvester/__init__.py", line 1, in <module>     from gevent import monkey as curious_george ModuleNotFoundError: No module named 'gevent' Error in sys.excepthook: Traceback (most recent call last):   File "/usr/lib/python3/dist-packages/apport_python_hook.py", line 63, in apport_excepthook     from apport.fileutils import likely_packaged, get_recent_crashes   File "/usr/lib/python3/dist-packages/apport/__init__.py", line 5, in <module>     from apport.report import Report   File "/usr/lib/python3/dist-packages/apport/report.py", line 30, in <module>     import apport.fileutils   File "/usr/lib/python3/dist-packages/apport/fileutils.py", line 23, in <module>     from apport.packaging_impl import impl as packaging   File "/usr/lib/python3/dist-packages/apport/packaging_impl.py", line 23, in <module>     import apt   File "/usr/lib/python3/dist-packages/apt/__init__.py", line 23, in <module>     import apt_pkg ModuleNotFoundError: No module named 'apt_pkg'  Original exception was: Traceback (most recent call last):   File "theHarvester.py", line 10, in <module>     from theHarvester import __main__   File "/home/johnzhau/myTools/theHarvester/theHarvester/__init__.py", line 1, in <module>     from gevent import monkey as curious_george ModuleNotFoundError: No module named 'gevent' 

Apparently, installing the dependencies with pip3 v8.1.1 doesn’t let python3.6 use the dependencies. How should I fix it so that either I can install dependencies for python 3.6+ or let python3.6 read pip3 v8.1.1 (python3.5)’s dependencies?

GParted failure

The system is Ubuntu 18.04. I’m trying to use GParted to repartition an unused disk to be like my system disk. While GParted is scanning the available disks i get this:

Assertion (metadata_length>0) at ../../libparted/labels/dos.c2313 in function add_logical_part_metadata() failed.

Any suggestions?

How do you calculate the chance of failure when copying spells in Adventurers League?

In a recent D&D 5e Adventurers League adventure, two of our characters attempted to copy spells from each-other’s spellbooks. The DM told us that each character would need to roll an Arcana check to determine success or failure in the copying of the spell.

Rules on copying spells can be found in the Player’s Handbook on page 114 as well as in the most recent Adventurer’s League Player’s Guide (Version 6.0, effective March 24, 2017) on page 5. Here is the link.

In the AL Guide, it stipulates (emphasis mine):

Downtime: Copying Spells

If you wish to copy spells into your spellbook, you must do so using this downtime activity—even if it occurs during an adventure.

For each downtime day spent copying spells, a character may spend eight hours copying spells into their spellbook. Two or more characters participating in the same adventure together at the same table that choose to perform this downtime activity may allow one another access to their spellbook; effectively “trading” spells between everyone involved to copy as normal. Both parties to the trade must perform this downtime activity to trade spells.

As there may sometimes be a chance of failure when copying spells, you must perform this downtime activity in the presence of the table’s DM.

Here are my questions:

  1. As the text says there “may sometimes be” a chance of failure, can the DM ultimately decide if a roll is required or not, or is there a written rule somewhere that requires it?

  2. Are there any written rules on how this chance of failure is to be calculated?