The source session failed because you selected the Authority Check option when you generated the ABAP program for the mapping, but did not have the proper authorization.

If you enabled the Authority Check option when you generated the ABAP program, the SAP application server verifies that the user running the workflow has authorization to read the sources. SAP verifies the authorization before it reads the first source.

If the user in the SAP ECC application connection does not have read authorization on any one of the sources, the session fails with a NO AUTHORITY error.