ContributionsMost RecentMost LikesSolutionsHow do we get authentication token for snaplogic instance Hello Community, I want to access SnapLogic Assets such as pipelines, and projects on a SnapLogic instance within our organization. How do I authenticate the Public APIs from Postman? How do I get the access or authentication token? https://docs.snaplogic.com/public-apis/public-apis-about.html Thank You, Tharun Re: SQL server snap - Unexpected Re-throwing connection error Hello Community, As the issue is related to firewall, we raised a request the vendor(SQL server) to whitelist our IPs to resolve the persisting issue of re-throwing error. Thank you. Re: SQL server snap - Unexpected Re-throwing connection error Thanks Bowen, I really appreciate your effort to help me resolve the issue. I did raise a support ticket last week, and I’m following up with them. No breakthrough. I’ll post here the fix to be done and the root cause to this issue as soon as I get the solution. Best. Re: SQL server snap - Unexpected Re-throwing connection error mbowen: sslProtocol Hi Bowen, many thanks for your response. I have tried again with 4 different JDBC drivers, and also the default ones(by not specifying anything) and also by adding the URL properties as mentioned above, adding one at a time and both of the properties at a time, in my Dev and Test environments on 4 different groundplexes and yet the error remains the same. ‘Unexpected Rethrowing’ as the driver couldn’t establish a secure connection to SQL server. so, we are still at square one I suppose. Thanks. Re: SQL server snap - Unexpected Re-throwing connection error Hi @mbowen and @siwadon, The current issue I encounter is, I am able to connect the SQL server outside snaplogic but not with snaplogic. There were two errors, one while using groundplex(which is preferred) and an other using cloudplex. Also, there are other SQL servers accounts which I’ve created in the past and still working on with them. So, for this account alone I see ‘Unexpected rethrowing’ error. I really appreciate your responses. Thank you. Re: SQL server snap - Unexpected Re-throwing connection error Hello Community, Anyone faced similar issue as I before? Could you share what steps are to be followed to get this resolved this issue. Thank you. SQL server snap - Unexpected Re-throwing connection error Hi Community, I was trying to access SQL server via snaplogic but I wasn’t successful as I was facing an issue with the connection. Below are the two error messages when I tried with different plexes. Error while validating with groundplex Failed to validate account: Failed to retrieve a database connection. Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”. (Reason: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”.; Resolution: Address the reported issue.) Error while validating with cloudplex: Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host ***********************, port 1433 has failed. Error: “null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”. (Reason: The TCP/IP connection to the host ****************************, port 1433 has failed. Error: “null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.; Resolution: Address the reported issue.) JDBC drives that I used: mssql-jdbc-9.4.0.jre8 mssql-jdbc-7.4.1.jre8 mssql-jdbc-10.2.0.jre8.jar mssql-jdbc-7.4.1.jre11.jar* Details: I would really appreciate if anyone could help me on this. Thank you. Re: Migrate Pipelines Hi, The initial mapper takes the pipeline parameters and formulates the source and target asset paths. The concurrency is for, if I want to migrate only one pipeline, then I the pipeline read path will be taken, If I want to migrate set of pipelines it goes via pipeline list. So, there’s always only 1 active path. Re: Migrate Pipelines Hi Miller, Thanks for your response. Here’s my pipeline and depending on the key words that can migrate one or many - pipelines, accounts or tasks. Yes, I’ve taken inspiration from your Mirate Pipelines.slp and designed mine(still some work with migrating files). I could see the target path generated from mapper snap and it’s absolutely fine but still I end up with the above mentioned error. Pipeline Parameters Migrate Pipelines Hi Community, I’m trying to build a pipeline that migrate pipelines, accounts, tasks from one Org to another. I constantly receive an error message for the SnapLogic Create snap, while creating the pipeline in an folder. Could you please help me on this part. Error: Failure: Exception creating pipeline %s, Reason: Snapi request failed: {“response_map”: {“error_list”: [{“message”: “‘snap_map’”}]}, “http_status_code”: 500} $target_path: org/project_space/new_project/pipeline ; which will be given as input to the asset path from the above snap. Solved