AWS – Email – “Error Sending Mail – Message Reject : Email address is not verified. The following identities failed the check in region”

Background

Trying to send out an email email over an SMTP Server residing in AWS.

Error

Image

emailAddressInNotVerified.20190107.0253PM.PNG

Textual

An error occurred while sending mail.
The mail server responded : Message rejected: Email address is not verified.
The following identities failed the check in region 

Remediation

Outline

  1. Launch web browser
  2. Enter Region Specific URL
  3. SES
    • Domain Identities
      • Listing
        • All Domain Identities are listed
      • Add Domain
        • If your domain is not listed, please prepare to register it by clicking on the “Verify A New Domain” button
    • Email Addresses
      • Listing
        • All Email Addresses are listed
      • Verify a new email address
        • If your email address is not listed, please prepare to register it by clicking on the “Verify A New Email Address” button
      • Registration
        • In the “Verify New Email Address” window
          • Enter the Email Address
          • Click the “Verify this Email Address” button
      • Validation Email
        • Wait for the validation email
        • Read, Review, and Click in registration link

Steps

SES Home Page

Enter URL to the SES Home Page.

The generic URL to the SES Home Page is https://console.aws.amazon.com/ses/home.

For us, we are in US-WEST-2, and we can connect to the region specific URL by going here ( https://console.aws.amazon.com/ses/home ( https://us-west-2.console.aws.amazon.com/ses/home?region=us-west-2 ).

Domain Identities

From the left frame, please click the “Domains” link.

Please review the registered Domain Identities.

If your Domain is not listed, please click the “Verify a New Domain” button.

Listing

domainidentities.20190109.0102pm

Verify New Domain Identity

AmazonSimpleEmailService.verifyANewDomain.20190109.0106PM.PNG

Email Address Identities

From the left frame, please click the “Email Addresses” link.

Please review the registered “Email Addresses Identities“.

If the “Email Addresses Identifiers” is not listed, please click the “Verify a New Email Address” button.

Listing

Registered “Email Address Identifiers” are listed.

emailAddressIdentities.listing.20190109.0115PM.PNG

Verify New Email Address

In the “Verify a New Email Address” window, please enter the email Address that you will be using as the “Sending Address”.

Click the “Verify this Email Address” to confirm.

verifyanewemailaddress.20190109.0118pm

Validation Email

You will receive an email in email address you entered earlier.

Within 24 hours, please review the email and click on the Link.

Samples

Here are sample emails :-

Image

validation.email.20190109.0148PM.PNG

Textual

Dear Amazon Web Services Customer,

We have received a request to authorize this email address for use with Amazon SES and Amazon Pinpoint in region US West (Oregon). If you requested this verification, please go to the following URL to confirm that you are authorized to use this email address:

https://email-verification.us-west-2.amazonaws.com/?Context=458828384081&X-Amz-Date=20180913T234020Z&Identity.IdentityName=daniel.adeniji%40edriving.com&X-Amz-Algorithm=AWS4-HMAC-SHA256&Identity.IdentityType=EmailAddress&X-Amz-SignedHeaders=host&X-Amz-Credential=AKIAJJHD5MBOFZDF5APA%2F20180913%2Fus-west-2%2Fses%2Faws4_request&Operation=ConfirmVerification&Namespace=Bacon&X-Amz-Signature=7cccbc70dddc08dc9d93c91cb1febb2a6792ce4f86083d26d3fa1668b2155063

Your request will not be processed unless you confirm the address using this URL. This link expires 24 hours after your original verification request.

If you did NOT request to verify this email address, do not click on the link. Please note that many times, the situation isn't a phishing attempt, but either a misunderstanding of how to use our service, or someone setting up email-sending capabilities on your behalf as part of a legitimate service, but without having fully communicated the procedure first. If you are still concerned, please forward this notification to aws-email-domain-verification@amazon.com and let us know in the forward that you did not request the verification.

To learn more about sending email from Amazon Web Services, please refer to the Amazon SES Developer Guide at http://docs.aws.amazon.com/ses/latest/DeveloperGuide/Welcome.html and Amazon Pinpoint Developer Guide at http://docs.aws.amazon.com/pinpoint/latest/userguide/welcome.html.

Sincerely, 

References

  1. Amazon
    • Amazon Simple Email Service
      • AWS Documentation » Amazon SES Documentation » Developer Guide » Sending Email with Amazon SES » Setting up Email with Amazon SES » Verifying Identities in Amazon SES » Verifying Email Addresses in Amazon SES
        Link
      • AWS Documentation » Amazon SES Documentation » Developer Guide » Sending Email with Amazon SES » Setting up Email with Amazon SES » Verifying Identities in Amazon SES » Verifying Email Addresses in Amazon SES » Verifying an Email Address
        Link

 

SQL Server – BCP Error – “String Truncation”

Background

Trying to Bulk copy data but running into error.

Error

Error Image

stringdatarighttruncation.20190108.0552pm

Error Text


SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]String data, right truncation
1000 rows sent to SQL Server. Total sent: 1591000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]String data, right truncation

1591585 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total     : 347468 Average : (4580.52 rows per sec.)

Troubleshooting

We copied the data over using character mode and it is possible carriage return our default line terminator is naturally occurring.

Remediation

Change from character mode (-c) to native mode ( -n)

Next Error

Image

unexpectedEOFEncounteredInBCPDatafile.20190108.0604PM.PNG

Textual


1000 rows sent to SQL Server. Total sent: 3198000
1000 rows sent to SQL Server. Total sent: 3199000
1000 rows sent to SQL Server. Total sent: 3200000
1000 rows sent to SQL Server. Total sent: 3201000
1000 rows sent to SQL Server. Total sent: 3202000
1000 rows sent to SQL Server. Total sent: 3203000
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]
Unexpected EOF encountered in BCP data-file

 

References

  1. Github
    • Microsoft
      • msphpsql
        • PDOException: String data, right truncation when insert a long string #169
          Link

DOS batch file – Counting Lines

Background

Needing to count lines in a file.

Script

DOS / Command Line

Find Command

syntax

find /v /c "" [filename]

sample

find /v /c "" modules.txt

findstr

findstr – type / findstr/find

syntax
findstr /R "." [filename] | find /c /v ""
sample
findstr /R "." products.txt | find /c /v ""

findstr – type / findstr/find

syntax
type [filename] | findstr /r /n "^"| find /c ":"
sample
type products.txt | findstr /r /n "^"| find /c ":"

Transact SQL – Scaler Functions – Schema Bound

Background

Want to have a quick talk about Scaler Functions; specifically Schema Bound.

Transact SQL

DDL

Outline

We are going to create two functions, dbo.left10.No and dbo.left10.Yes.

dbo.left.No will be non-schema bound and dbo.left10.Yes will be schema bound.

Function

Function – [dbo].[left10.No]

Code
use [tempdb]
go

if object_id('[dbo].[left10.No]') is null
begin

    exec('create function [dbo].[left10.No]
            (
                @input varchar(100)
            )
            returns varchar(10)
            as
            begin

                return reverse
                (
                    left(@input, 10)
                )

            end
        ')

end
go

ALTER FUNCTION [dbo].[left10.No]
(
    @input varchar(100)
)
returns varchar(30)
as
begin

    return reverse
            (
                left(@input, 10)
            )

end
go

Function – [dbo].[left10.Yes]

Code
use [tempdb]
go

if object_id('[dbo].[left10.Yes]') is null
begin

    exec('create function [dbo].[left10.Yes]
            (
                @input varchar(100)
            )
            returns varchar(10)
            as
            begin

                return reverse
                (
                    left(@input, 10)
                )

            end
        ')

end
go

ALTER FUNCTION [dbo].[left10.Yes]
(
    @input varchar(100)
)
returns varchar(10)
with schemabinding
as
begin

    return reverse
            (
                left(@input, 10)
            )

end
go

DML

Outline

In our sample exercise we compare the effect of updating a table with a non-schema bound Scaler function against updating a similar table with a schema bound Scaler function.

Steps

  1. Non-Schema Bound Function
    • Create Table 1
    • Add data
    • Update data with non-schema bound function
  2. Schema Bound Function
    • Create Table 2
    • Add data
    • Update data with schema bound function

Code


use [tempdb]
go

set nocount on
go

set statistics io on
go

set XACT_ABORT on
go

if object_id('[dbo].tbl1') is not null
begin

    drop table [dbo].tbl1

end
go

if object_id('[dbo].[tbl2]') is not null
begin

    drop table [dbo].[tbl2]

end
go

create table [dbo].[tbl1]
(
      [id] int not null identity(1,1)
    , [data] varchar(60) not null
    , [dataProcessed] varchar(100) null
)

create table [dbo].[tbl2]
(
      [id] int not null identity(1,1)
    , [data] varchar(60) not null
    , [dataProcessed] varchar(100) null
)

declare @lMaxNumberofRecords int

set @lMaxNumberofRecords = 100000

;with
   L0 as (select 1 as C union all select 1)       --2 rows
  ,L1 as (select 1 as C from L0 as A, L0 as B)    --4 rows
  ,L2 as (select 1 as C from L1 as A, L1 as B)    --16 rows
  ,L3 as (select 1 as C from L2 as A, L2 as B)    --256 rows
  ,L4 as (select 1 as C from L3 as A, L3 as B)    --65536 rows
  ,L5 as (select 1 as C from L4 as A, L4 as B)    --4,294,967,296 rows
  ,Nums as
  	(
		select 

			row_number() 

			over
			(

				order by
					(
						select 0
					)
			) as N 

		from L5
	)

insert into tbl1
(
      [data]
)
select
          CAST (newid() as varchar(36))
from Nums
where N<=@lMaxNumberofRecords

;with
   L0 as (select 1 as C union all select 1)       --2 rows
  ,L1 as (select 1 as C from L0 as A, L0 as B)    --4 rows
  ,L2 as (select 1 as C from L1 as A, L1 as B)    --16 rows
  ,L3 as (select 1 as C from L2 as A, L2 as B)    --256 rows
  ,L4 as (select 1 as C from L3 as A, L3 as B)    --65536 rows
  ,L5 as (select 1 as C from L4 as A, L4 as B)    --4,294,967,296 rows
  ,Nums as
	(
		select 

			row_number() 

			over
			(

				order by
					(
						select 0
					)
			) as N 

		from L5
	)

insert into tbl2
(
      [data]
)
select
        CAST (newid() as varchar(36))
from Nums
where N<=@lMaxNumberofRecords

go

print replicate('=', 160)
go

update statistics [dbo].[tbl1] with fullscan
go

update statistics [dbo].[tbl2] with fullscan
go

update tbl
set    dataProcessed = [dbo].[left10.No](tbl.[data])
from   tbl1 tbl
go

print replicate('=', 160)
go

update tbl
set    dataProcessed = [dbo].[left10.Yes](tbl.[data])
from   tbl2 tbl
go

print replicate('=', 160)
go

drop table [dbo].[tbl1]
go

drop table [dbo].[tbl2]
go

Query Plan

Image

queryplan.20190107.0820am

Explanation
  1. We can see that the Non-Schema bound function has a Table Spool

Statistics

Statistics I/O
Statistics I/O – Image

statistics.io.20190107.0818am

Statistics I/O – Textual
================================================================================
Update table 1 ...
================================================================================================================================================================
Table 'tbl1'. Scan count 1, logical reads 145382, physical reads 125, read-ahead reads 654, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 1, logical reads 202750, physical reads 2, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Updated table 1
================================================================================================================================================================
Update table 2 ...
================================================================================================================================================================
Table 'tbl2'. Scan count 1, logical reads 45522, physical reads 0, read-ahead reads 658, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
================================================================================================================================================================
Updated table 2
================================================================================================================================================================

Statistics I/O – Explanation
  1. We can see that the Non-Schema bound function
    • References a Worktable
    • And, has more IO against the targeted table

MS Office – Access/Excel – “Missing Excel 16.0 Object Library”

Background

Our users started having problems using a homegrown Microsoft Access Application.

Error

Error Image

microsoftexcel16objectlibraryismissing.20190104.0107pm

 

Error Text

MISSING : Microsoft Excel 16.0 Object Library

 

Trouble Shooting

We have Microsoft Office 2010 installed.

Being sought for “Microsoft Excel 16.0 Object Library“….

BTW, Excel 16.0, is Office 2016.

Remediation

Install Microsoft Office Interop Component.

Microsoft Office Interop Component

Version

Office 2010

For Microsoft Office 2010, the Interop product is available here :-

Microsoft Office 2010: Primary Interop Assemblies Redistributable
Link

Office 2016

The Interop Component not available as a standalone product.  One needs the entire Office suite.

Microsoft Office Suite

Install

As I tried installing Microsoft Office 2016 ran into a blocking issue :-

Image

wecantinstallthe32bitversionofoffice

Text

We can’t install the 32-bit version of Office because we found the following 64-bit programs on your PC :

Microsoft Office Access Runtime 2010
Microsoft Office Office 32-bit Components 2010

Uninstall

Uninstall – “Microsoft Office Office 32-bit Components 2010”

Help
  1. Microsoft Office Office 32-bit Components 2010
    Link
Command

MsiExec.exe /X{90140000-0043-0000-1000-0000000FF1CE}

Confirmation

microsoftofficeoffice32bitcomponents2010.20190104.0137pm

 

Uninstall – “Microsoft Office Access Runtime 2010”

Help
  1. A guide to uninstall Microsoft Office Access Runtime 2010 from your system
    Link
Command

MsiExec.exe /X {90140000-001C-0000-0000-0000000FF1CE}

Confirmation

microsoftofficeoffice32bitcomponents2010.20190104.0137pm

 

Dr. Thomas Oden, A theologian who made made no new contribution to theology

Who is Thomas Clark Oden?

Wikipedia
Link

Thomas Clark Oden was an American United Methodist theologian and religious author. He is often regarded as the father of the paleo-orthodox theological movement and is considered to be one of the most influential theologians of the 20th century and the beginning of the 21st century.

Quotes & Works

  1. “The heart of my story is that the first part of 40 years of my life, I was way, way out there on a path that I had to go on in order to come back like the prodigal son to the father,” Oden told Al Mohler, president of Southern Baptist Theological Seminary, in a 2015 interview. “But eventually I did and by my 40th year, I became deeply invested in listening carefully to the classical Christian consensus … of the ancient Christian writers and their interpretation of Scripture.”
  2. On Passing
    • Mark Tooley, Institute on Religion & Democracy president
      • “Tom is now with the early saints whose lives and teachings he studied so closely,” said Institute on Religion & Democracy president Mark Tooley, who called him “a dear friend and counselor, a brilliant and cheerful warrior for good causes, irreplaceable.
    • Russell Moore, president of the Ethics and Religious Liberty Commission
      • “What a loss to us all is the death of [Oden]. He is a hero of orthodox conviction,” tweeted Russell Moore, president of the Ethics and Religious Liberty Commission.
  3. Paleo-orthodox
    • Fred Sanders
      • Fred Sanders, theology professor at Biola University, remembered Oden as a “paleo-orthodox champion of the classic, consensual Christian tradition.”
    • Michael Patton, Credo House

      • Oden coined the term paleo-orthodox, explained here ,  here by Credo House’s C. Michael Patton as:

        • This is the belief that the Christian faith can be found in the consensual beliefs of the church. This is a form of “consensual orthodoxy” (consensus fidelium). This search for consensus follows the dictum of Saint Vincent of L’rins: quod ubique, quod semper, quod ab omnibus, “that which was believed everywhere, always.” Normally, according to Thomas Oden, who coined the term “paleo-orthodoxy,” this consensual faith can be found in the first five centuries of the Christian church (Oden, Requiem: A Lament in Three Movements), before the “speculative scholasticism” of western Catholicism. The idea of theological progression is normally thought by strict adherents of Paleo-Orthodoxy as a post-enlightenment influenced methodology that should not be followed.

  4. Prolific
    • Oden wrote and edited hundreds of books, articles, and essays and gave speeches on such topics as church and the world, church controversies, evangelicalism, Kierkegaard, the Methodist church, church discipline, John Wesley, postmodernism, and others. His first volume with InterVarsity Press was Two Worlds (1992), which discussed the dichotomy of perishing modernity and emerging post modernity, and their impact on Christianity. He quickly followed this with the launch of the [ACCS] in 1998, forever changing the face of IVP’s publishing program.
  5. Association of Classical and Christian Schools

    • J. I. Packer

      • The ACCS’s patristics exposition was praised by Packer as “badly needed for several centuries, and the whole Christian world should unite to thank those who are undertaking to fill the gap.”
    • Joel Scandrett, director of the Robert E. Webber Center at the Trinity School for Ministry

      • One of Oden’s many former students, Joel Scandrett, director of the Robert E. Webber Center at the Trinity School for Ministry, said the theologian “passed on to me and generations of students his great love of the Triune God and the ancient legacy of patristic exegetical and trinitarian theology.

      • “His lifetime of work,” said Scandrett, “reveals that Christians need to rely upon the wisdom of the historical church, particularly the early church, rather than exclusively on modern scholarship and theology.”

  6. He made no new contribution to theology
    • Oden told CT in 1990 that he dreamed his epitaph would read: He made no new contribution to theology. He said:
      • In my dream I was extremely pleased, for I realized I was learning what Irenaeus meant when he warned us not to invent new doctrine. This was a great discovery for me. All my education up to this point had taught me that I must be compulsively creative. If I was to be a good theologian I had to go out and do something nobody else ever had done. The dream somehow said to me that this is not my responsibility, that my calling as a theologian could be fulfilled through obedience to apostolic tradition.

Videos

  1. Dr. Thomas Oden, author of How Africa Shaped the Christian Mind
    • Profile
      • Dr. Tom Oden, author of How Africa Shaped the Christian Mind, speaks with Dr. Jerry Pattengale of The Green Scholars Initiative about the role of Africa in the early Church
    • Videos
      • Video #1
        Channel :- InterVarsity Press
        Published On :- 2014-Jan-6th
        Link
  2. Libyan Christianity 1: A Libyan History Awaiting Discovery – Thomas C. Oden
    • Profile
      • Thomas Oden, professor of Theology Emeritus, Drew University; General Editor, Ancient Christian Commentary on Scripture, explores historical Christianity by means of understanding the ancient culture and historical underpinnings of the people of Libya.
    • Videos
      • Video #1
        Channel :- Dallas Theological Seminary
        Published On :- 2012-July-27th
        Link

In depth

Dr. Thomas Oden, author of How Africa Shaped the Christian Mind

  1. 215 to 230 AD
  2. Christians in Palestine
  3. Intellectual Energy from South to North

Libyan Christianity 1: A Libyan History Awaiting Discovery – Thomas C. Oden

  1. Struggle of Rural Christianity
    • Conflict
      • North South Conflict
      • East west conflict
      • Christian/Islam Conflict
    • Undercurrent
      • Visa
      • Lockerbie
  2. Archbishop
  3. Socialism

References

  1. Wikipedia
    • Thomas C. Oden
      Link