EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB32537: How to interpret SMTP codes when troubleshooting MicroStrategy Narrowcast services that fail during the email delivery stage using the SMTP log.


Community Admin

• Strategy


When troubleshooting a MicroStrategy Narrowcast service that is failing to deliver an email to its destination, it is useful to understand the different Simple Mail Transfer Protocol (SMTP) codes logged by the SMTP log. This is the fastest approach towards identifying the underlying cause of a failed email delivery.

When troubleshooting a Strategy Narrowcast service that is failing to deliver an email to its destination, it is useful to understand the different Simple Mail Transfer Protocol (SMTP) codes logged by the SMTP log. This is the fastest approach towards identifying the underlying cause of a failed email delivery.
 
Two SMTP log entries are shown below:
 
Sample Code/Error
<<501 5.5.4 Invalid arguments??>>
 
Sample Code/Error
<<250 2.1.5 edante@microstrategy.com ??>>
  
The first number, highlighted in italics and underlined, refers to the SMTP reply code.
The second number, highlighted in bold and underlined, refers to the enhanced status code for SMTP.
 
SMTP Reply codes
 
The first three digit number shown in the examples above refers to the SMTP reply code as originally defined in RFC 821
 

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

select a11.Year_ID Year_ID,
    a11.Sales WJXBFS1,
    a11.Sales WJXBFS2
into #ZZTRE0015U2SP000
from Year_Sales_Fact a11

select a11.Year_ID Year_ID,
    a11.Item_Sold WJXBFS1
into #ZZTRE0015U2SP001
from Item_Sold_Fact a11

select coalesce(pa1.Year_ID, pa2.Year_ID) Year_ID,
    pa1.WJXBFS1 WJXBFS1,
    (pa1.WJXBFS2 / pa2.WJXBFS1) WJXBFS2
from #ZZTRE0015U2SP000 pa1 full outer join #ZZTRE0015U2SP001 pa2
on (pa1.Year_ID = pa2.Year_ID)
 211 System status, or system help reply 214 Help message 220 <domain> Service ready 221 <domain> Service closing transmission channel 250 Requested mail action okay, completed 251 User not local; will forward to <forward-path> 354 Start mail input; end with <CRLF>.<CRLF> 421 <domain> Service not available, closing transmission channel 450 Requested mail action not taken: mailbox unavailable 451 Requested action aborted: local error in processing 452 Requested action not taken: insufficient system storage 500 Syntax error, command unrecognized 501 Syntax error in parameters or arguments 502 Command not implemented 503 Bad sequence of commands 504 Command parameter not implemented 550 Requested action not taken: mailbox unavailable 551 User not local; please try <forward-path> 552 Requested mail action aborted: exceeded storage allocation 553 Requested action not taken: mailbox name not allowed (Incorrect mailbox syntax) 554 Transaction failed

 
For the example presented below, the following would be the correct interpretation of the log entry:
 
Sample Code/Error
<<501 5.5.4 Invalid arguments??>>
 
The 501 SMTP reply code is indicating there is a syntax error in the parameters or arguments. Since this particular log entry was logged when resolving the destination address, it can be determined that there are invalid arguments in the destination address provided.
 
Sample Code/Error
<<250 2.1.5 edante@microstrategy.com ??>> 
 
The 250 SMTP reply code indicates the requested action was completed successfully.
 
Enhanced SMTP Status Codes
In addition to the reply codes introduced in the original definition of the Simple Mail Transfer Protocol,  a set of extended status codes were later included (RFC 3463) to facilitate media and language independent rendering of message delivery status. These extended status codes can be seen in the SMTP log as shown in the examples above (the second three digit number), and are very useful in identifying the  underlying cause of failed deliveries.
 
All SMTP extended status codes consist of three digits.
 
The first digit determines a broad classification of the status of the SMTP request:
 
2.x.x Success
Success specifies a positive delivery action, the mail server has completed the task successfully without errors.
 
4.x.x Persistent Transient Failure
A persistent transient failure is one in which the message as sent is valid, but the mail server has encountered a temporary failure that prevents the successful sending of the message.  Sending in the future, without any change, may be successful.
 
5.x.x  Permanent Failure
A permanent failure means the mail server has encountered a fatal error which is not likely to be resolved by resending the message in the current form.  Some change to the message or the destination must be made for successful delivery.
 
When a permanent failure is encountered, it will be reflected in the Delivery Engine Log as shown below:
 
Sample Code/Error
Permanent error during message delivery
 
The second digit classifies the status. This value applies to each of the three classifications above.
 
X.1.X   Addressing Status
The address status reports on the originator or destination address.  It may include address syntax or validity.
 
X.2.X   Mailbox Status
Mailbox status indicates that something having to do with the mailbox has cause this code.
 
X.3.X Mail System Status
Mail system status indicates a system issue.
 
X.4.X Network and Routing Status
The networking or routing codes report status about the delivery system itself.
 
X.5.X   Mail Delivery Protocol Status
The mail delivery protocol status codes report failures involving the message delivery protocol. These failures include the full range of problems resulting from implementation errors or an unreliable connection.
 
X.6.X Message Content or Media Status
The message content or media status codes report failures involving the content of the message.
 
X.7.X Security or Policy Status
The security or policy status codes report failures involving policies such as per-recipient or per-host filtering and cryptographic operations.
 
The third digit defines and describes the detail value, which provides more information about the status and is defined relative to the subject of the status. A detailed list of all SMTP codes can be found in RFC 3463.
 
Going back to the sample SMTP entries presented above, we would interpret them as follows:
 
Sample Code/Error
<<501 5.5.4 Invalid arguments??>>
5.x.x = Permanent failure: Some change to the message or the destination must be made.
x.5.x = Mail Delivery Protocol status: Implementation error
x.5.4 = Invalid command arguments: Valid transaction with invalid arguments.
Since the error is thrown when validating the destination address, the conclusion would be that the destination address contains invalid arguments.
 
Sample Code/Error
<<250 2.1.5 edante@microstrategy.com ??>>
2.x.x = Success: successful delivery
x.1.x = Addressing status: This entry is logged by either the source or destination address.
x.1.5 = Destination address valid
The conclusion here is that the destination address, edante@microstrategy.com, is valid and the delivery was successful.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

March 30, 2017

Last Updated:

March 30, 2017