joel_bourgault
New Contributor III
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Jar file download failed : NOT FOUND
Thanks for the reply! I just received the same answer from SnapLogic support, and it works indeed: "use the absolute path", as shown in sldb file browser, and not the shortened, relative path. As this is an unexpected behavior, I suggested that 1) path entered in file selection is either absolute, or is resolved from Account location, not calling pipeline location, 2) an entry be added to the troubleshooting section. Hope at least one of these will be performed, preferably the first one 😁1.9KViews0likes0CommentsRe: Jar file download failed : NOT FOUND
Same issue here, with some interesting timeline: We want to connect to our MariaDB Maxscale database load balancer, using cyphered connection. This seems to require the Connector J, so we upload it, select it as JDBC JAR, provide the credentials, Validate the connection: all goes well. But then, pipeline fails, with following indication: "failure=Jar file download failed : NOT FOUND". Now, the weird part: Coming back to Account, I remove the custom JAR line; now *validation still works* (when it didn't previously without the custome JAR file.) And the pipeline do not fail anymore! I will open a support ticket on this; brianm do you experience the same behavior?4.8KViews0likes3CommentsRe: Keep data "through" snaps which don't provide original input under $original in their output
Hello, Very useful, thanks! An addition though: `original` is appended if both following conditions are met: "Reuse executions to process documents" is *not* checked "Batch size" is 1 However, this comes at the prize of a significantly slower execution. It’s still possible to set Pool Size though. Too bad there’s no "pass-through" option for Pipeline Execute snap.1.8KViews0likes0CommentsRe: Sharepoint Online OAuth account, error 500 when renewal since Oct. 30th
After a long search, the root cause is that, in Microsoft Entra ID, for SnapLogic registered application, the Client Secret has expired! The connections attempts are visible in the Entra ID logs. After secret renewal, the Authorize and Refresh work as expected. So: too bad that Microsoft feedback is not `401 Not Authorized`, that would have greatly helped. hope my post will help others in the same situation!2.9KViews0likes0CommentsSharepoint Online OAuth account, error 500 when renewal since Oct. 30th
Hi everyone, Since yesterday Oct. 30th, sometime between 9h and 12h UTC, OAuth connection to Microsoft Sharepoint ceased to work, with a error 500. I can reproduce this failure by opening the Sharepoint Online account, and clicking on Authorize (personal info replaced by placeholders): { "http_status_code": 500, "response_map": { "error_list": [ {"message": "Request to token endpoint https://login.microsoftonline.com/{tenant}.onmicrosoft.com/oauth2/v2.0/token failed for account \"/{org}/{workspace}/{project}/SharepointAccount\" of type \"SharePoint Online Account\""} ] } } I have two such Sharepoint Online accounts (one for dev, one for prod) and both fail to authorize and to refresh. So I am enclined to think that the issue is on Microsoft side, but I can find no trace of any change in the last days. Is anyone else facing the same issue? Thanks for the feedback; this is blocking most of my pipelines, as we extensively write files to Sharepoint folders.Solved2.9KViews0likes1CommentRe: Transactions with sqlserver
Hello, same question on my side, where multiple inserts occur within several MySQL snaps (so not the same server, but same need). But maybe it is sufficient to force “autocommit=False” in these MySQL snaps: if I understand correctly, the commit will be performed only when the pipeline completes, i.e. no commit happens if the pipeline fails. Is this understanding correct? Is this a correct way to handle this design?2.8KViews0likes0CommentsRe: Return the status of executed Pipelines for the specified time within the Org
Hi All, Just to share my experience: to retrieve runtime statuses, I use the following endpoint: https://elastic.snaplogic.com/api/1/rest/public/runtime/%1$s?last_hours=%2$s&limit=%3$s&offset=%4$s , that I call .sprintf() on it with following variables: %1$s is replaced by my Org %2$s is replaced by a number of hours from now in the past %3$s and %4$s are used by pagination This is associated with my personal account, stored as REST Basic Auth account. Hope this helps!3.7KViews0likes1Comment