pvsharish9
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
How to create a report on Tasks Invoked by Specific User in SnapLogic?
Hi Everyone, I created a user with administrator privileges to invoke pipelines in a project using a username and password. However, I now want to reduce the user's role to a lower level. Before making this change, I want to ensure it won't disrupt any existing workflows. To do this, I'd like to generate a report that lists all the tasks invoked using this administrator account. I've checked the activity log and tried using the SnapLogic metadata snap to generate the report, but neither method has shown any records of user API authentication history. Example- User@abc.com is having admin role and allowed to trigger Pipeline 1,Pipeline,pipeline3 with authentication(user@abc.com and password) But user@abc.com can trigger pipeline 4,5,6 with authentication(user@abc.com and password). I am looking for report that list user@abc.com invoked pipeline 1,2,3,4,5,6 with authentication (User@abc.com) Can anyone advise on how I can create a report listing all the tasks invoked by this particular user? Thanks, Harish985Views0likes0CommentsUnable to get all records from mysql database in Generic JDBC execute or Select snap
Hello, I am seeing a different behavior in Generic JDBC execute or Select snap when it has upstream and downstream. I have a table with 10000 records and the query used in both snaps is "select * from . where pipl id =‘1’ " and this query is giving same count in mysql and when the snap(execute,select) is not having any input/output connected but if there is a input/output, i am not getting same count in output and the record count is not consistent. Sometimes i get 10,20 … but not 10000. Tried all troubleshooting steps like clearing cache, re deploying snap, restarting snap plex… but no luck. Snap version - com-snaplogic-snaps-jdbc-execute-1-main19844 Did anyone face this issue? Appreciate any solution here. Thank you in advance. HarishHow to automatically disable and enable Ultra task through api's
Hello, We have a requirement to automatically recycle ultra task threads on every day at a certain time. Are there any api’s to disable and enable ultra task ? or any alternative to recycle threads when ultra task is hung. Thank you in advance. Harish3.3KViews0likes3CommentsSQL Server account connection setup failing with multiple error
Hello Community, We are trying to setup SQL server account in Snaplogic, however, getting below error Invalid username password- Able to login with windows authentication in microsoft sql management studio Failed to validate account: Failed to retrieve a database connection. Cause: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198 (Reason: Login failed for user ‘\empid’. ClientConnectionId:27dc1f0c-b783-4327-8d10-c77c82f6c198; Resolution: Ensure credentials are valid, multiple attempts with invalid credentials may result into account getting locked) If we use domainname/instancename in HOSTNAME, getting below error Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host /, port 1433 has failed. Error: “/. 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: “/. 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.) version - 13.0.5 Here are our account settings - Hostname: abc.bot.com/mydatabase port:1433 DBname:emp_name username: abc\123 password:<> Also, Please share sample account settings for our reference. Thank you in advance.