Timeline for Query issue - Automation failed due to system error
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 17, 2018 at 13:56 | comment | added | Johannes Schapdick | Domain has to be filled because its a group by of a different dataextension => Therefore it cannot be the Primary Key Violation and not the nullable reason. Inserting value to long: i restricted the only value which could have been to long by left 128. Query to Long failure after 1second seems very very odd. | |
| Jul 17, 2018 at 13:50 | history | edited | Johannes Schapdick | CC BY-SA 4.0 |
added 122 characters in body
|
| Jul 17, 2018 at 13:47 | comment | added | Johannes Schapdick | Checking it out and implementing some left function to Domain, thats the only field which can be over 128 (doubting it though). | |
| Jul 17, 2018 at 13:47 | history | edited | Adam Spriggs | CC BY-SA 4.0 |
update title, add automation tag
|
| Jul 17, 2018 at 13:41 | comment | added | Adam Spriggs | It's likely a truncation or datatype mismatch. Query errors can only be one of four things. | |
| Jul 17, 2018 at 13:37 | comment | added | Johannes Schapdick | Yeah you are right it should be decimal but i believe Decimal(5,2) just did text because of the documentation post. | |
| Jul 17, 2018 at 13:33 | history | edited | Johannes Schapdick | CC BY-SA 4.0 |
added 266 characters in body
|
| Jul 17, 2018 at 13:30 | answer | added | Adam Spriggs | timeline score: 2 | |
| Jul 17, 2018 at 13:28 | comment | added | Adam Spriggs | Should be Decimal (18,2), IMO. | |
| Jul 17, 2018 at 13:25 | comment | added | Johannes Schapdick | Because of this post help.salesforce.com/… my BouncePercent is text. | |
| Jul 17, 2018 at 13:19 | comment | added | Adam Spriggs |
Why is BouncePercent a string in your target DE?
|
|
| Jul 17, 2018 at 13:18 | comment | added | Adam Spriggs |
When you say it's crashing, what exactly do you mean? The syntax is valid -- even with the BouncePercent column included.
|
|
| Jul 17, 2018 at 13:13 | comment | added | Adam Spriggs | You can see some errors if you run your Query Activity in an Automation. | |
| Jul 17, 2018 at 7:08 | history | asked | Johannes Schapdick | CC BY-SA 4.0 |