- Posts: 110
- Thank you received: 0
Apple Email Format Unrecognizable
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
9 years 10 months ago #8906
by brillsupport
Apple Email Format Unrecognizable was created by brillsupport
Hi,
There is an ETL process reading a POP3 email from an Apple Ipad format. The Apple email is not recognizable by the ETL tool and fails. If the email is manually forwarded to another email, the ETL process is successful at reading and processing the forwarded email.
Attached are 2 files with email details - one which fails (the Apple format) and the second which is successful (the forwarded email).
Please let me know if you need additional details.
Thank you!
BBS
There is an ETL process reading a POP3 email from an Apple Ipad format. The Apple email is not recognizable by the ETL tool and fails. If the email is manually forwarded to another email, the ETL process is successful at reading and processing the forwarded email.
Attached are 2 files with email details - one which fails (the Apple format) and the second which is successful (the forwarded email).
Please let me know if you need additional details.
Thank you!
BBS
Please Log in or Create an account to join the conversation.
9 years 10 months ago - 9 years 10 months ago #8907
by admin
Mike
ETL Architect
Replied by admin on topic Apple Email Format Unrecognizable
Please email us this email.
Mike
Mike
Mike
ETL Architect
Last edit: 9 years 10 months ago by admin.
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8928
by admin
Mike
ETL Architect
Replied by admin on topic Apple Email Format Unrecognizable
We are not able reproduce the problem
Email us some samples to test at etl-tools.com
Mike
Email us some samples to test at etl-tools.com
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8930
by admin
Mike
ETL Architect
Replied by admin on topic Apple Email Format Unrecognizable
It would really help if you publish execution logs and some screenshots.
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 110
- Thank you received: 0
9 years 10 months ago #8942
by brillsupport
Replied by brillsupport on topic Apple Email Format Unrecognizable
Running version 5.7.6.8
Main Workflow package consists of 4 packages: Write Success Record to Log (write a record to log indicating 'start of process', Email File Processing, Process DBase File, and Write Success Record to Log (write a record to log indicating 'end of process'). The email being received is coming from an Apple Ipad and is Apple formatted. The ETL process is unable to recognize the format and abends.
Here are 3 attachments with screenshots of the execution logs:
1) 11-18-2013 2-52-05 PM_PopEmailFail.jpg - execution log details of when package 'Email File Processing' is run (which is agent scheduled) to retrieve email and unzip attachments. Log shows failure on get of email.
2) 11-18-2013 2-54-00 PM_PopEmailSuccess1of2.jpg - since ETL process above failed, the Apple formatted email was forwarded to another email box via SmartMail. The 'Email File Processing' package was restarted reading off the second email box. Here is the first part of the execution log.
3) 11-18-2013 2-57-57 PM_PopEmailSuccess2of2.jpg - continued execution log from #2 above. This shows execution of the forwarded email was successful.
We are sending a copy of a file to you via email. Please let us know if you did not yet receive it. Let us know if you need additional information. Thank you!
BBS
Main Workflow package consists of 4 packages: Write Success Record to Log (write a record to log indicating 'start of process', Email File Processing, Process DBase File, and Write Success Record to Log (write a record to log indicating 'end of process'). The email being received is coming from an Apple Ipad and is Apple formatted. The ETL process is unable to recognize the format and abends.
Here are 3 attachments with screenshots of the execution logs:
1) 11-18-2013 2-52-05 PM_PopEmailFail.jpg - execution log details of when package 'Email File Processing' is run (which is agent scheduled) to retrieve email and unzip attachments. Log shows failure on get of email.
2) 11-18-2013 2-54-00 PM_PopEmailSuccess1of2.jpg - since ETL process above failed, the Apple formatted email was forwarded to another email box via SmartMail. The 'Email File Processing' package was restarted reading off the second email box. Here is the first part of the execution log.
3) 11-18-2013 2-57-57 PM_PopEmailSuccess2of2.jpg - continued execution log from #2 above. This shows execution of the forwarded email was successful.
We are sending a copy of a file to you via email. Please let us know if you did not yet receive it. Let us know if you need additional information. Thank you!
BBS
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8945
by admin
Mike
ETL Architect
Replied by admin on topic Apple Email Format Unrecognizable
We are sending a copy of a file to you via email. Please let us know if you did not yet receive it. Let us know if you need additional information. Thank you!
I have just checked test@etl-tools.com and there is nothing there from you.
Mike
I have just checked test@etl-tools.com and there is nothing there from you.
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.