wpenfold
Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Is there a way I can delete a folder and all files and subfolders from a windows server?
It's not snaplogic related files. This is part of an identity management system. When an employee leaves, all their personal files and folders need to be deleted off a windows server. This was done before with Powershell scripts, but now converting to Snaplogic pipelines.3.5KViews0likes0CommentsIs there a way I can delete a folder and all files and subfolders from a windows server?
When an employee leaves, their personal folder and any subfolders and files they have created needs to be deleted. I know I can delete an empty directory, but how can i find/delete all the files and subfolders they've created?Solved3.6KViews0likes5Comments$original.original.orginal.original.... How to avoid this?
I'm working on a long pipeline that calls a number of child pipelines and passes a lot of data. Is there some way that I can design the pipeline, so that my original documents values don't get buried in many layers of $original.original.original... It's a constant battle to find the data I started with, and every time I need to add a step, I have to also fix all the steps after. I use jsonPath($,"$..columnName") sometimes, but I there are many columns of data. Is there a better way?2KViews0likes1CommentActive Directory how to enable an account that is disabled?
I can use the Disable Entry snap and it successfully sets the Active Directory userAccountControl attribute to 514. But I can't figure out how to Enable an account that has been disabled. I've tried setting the userAccountControl attribute to 512, but it doesn't like the format of the attribute. I think maybe there is a sub-attribute that needs to be set...? Does anyone have any suggestions on what to try?1.1KViews0likes0CommentsCan I use Snaplogic to maintain our Source Control repository in SVN or GIT?
We currently have a PHP application which extracts changed source packages from our Oracle DB, and checks them into SVN nightly. Is there a way I could do the equivalent using Snaplogic? I can extract the changed source from Oracle using SQL. I would need to name the files and check them into SVN or GIT. Any suggestions, or anyone doing something similar?1.2KViews0likes0CommentsRe: DBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic
Thanks. I’ll submit a ticket about supporting DBMS_OUTPUT. As far as the GTT issue, we have over 100 pipelines running now, and many more to convert from our current scheduling software. I don’t think that creating and using a different account for each pipeline would be feasible. I don’t know if Snaplogic could handle db connections any differently…? We have multi-user PHP web applications using connection pooling that successfully call Pl/SQL packages using GTTs without collision, so it seems like it ought to be possible.3.4KViews0likes0CommentsRe: DBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic
Yes, it would be very helpful if the stored procedure snap could capture the DBMS_OUTPUT. In the meantime, I’ve written a procedure that writes to a file, that we can use to replace the DBMS_OUTPUT calls. But it does mean substantial changes to each oracle program we want to run from Snaplogic. Also, It would be helpful regarding the global temp table report issue, if Snaplogic didn’t run multiple pl/sql procedure calls concurrently within the same Oracle session. Right now, if program A and program B are run concurrently from 2 different pipelines, they both share the same Oracle session–therefore the same temporary table. Both write report data to the same instance of the temporary table. Whichever program ends first, produces a report containing mixed output from both A and B.3.4KViews0likes4CommentsDBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic
We are having issues with output when running our PL/SQL programs from Snaplogic. Many of our existing pl/sql packages use DBMS_OUTPUT to write some information about the execution of the job–like row counts, any warning messages etc. When run from within Oracle, the DBMS_OUTPUT buffer gets automatically written to a log file. When run from Snaplogic, no log file is written. PL/SQL programs that produce a more detailed report, use a Global Temporary Table, to build the report during processing, then write the data from the GTT to the report file at the end of the program. This doesn’t work in Snaplogic either, because instead of each job running in it’s own session, all of the oracle jobs that snaplogic runs use the same session–hence they share the same instance of the GTT. If multiple programs are running at the same time the reports become gobbledegook. The end result is, every legacy PL/SQL program that we want to run from Snaplogic has to be rewritten. Anyone else having this issue? What have you done about it?4.7KViews1like6Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
