uipath / community.activities Goto Github PK
View Code? Open in Web Editor NEWRepository of Windows Workflow Foundation Activities for UiPath Community
Home Page: https://www.uipath.com/community
Repository of Windows Workflow Foundation Activities for UiPath Community
Home Page: https://www.uipath.com/community
Hi,
In the contribution guide you posted:
NuSpec file should have the approximately same structure as the others
I've searched the whole repo and couldn't find anything.
Do you mean that a "standard" nuspec should be included or is it an omission?
Clarification would help.
Cheers,
Andrzej
Is your feature request related to a problem? Please describe.
This is not a problem but a feature request for Database Activities.
Describe the solution you'd like
At the moment we are able to execute SQL against Access DB, but unable to directly call a set of Access queries. Writing very long SQL in Execute Query activity can cause some operational mistakes whenever DB schema change happens in Access side.
Describe alternatives you've considered
N/A
Additional context
N/A
Detail
I executed the demo from UiPath Studio Docs and it works fine.
Then, i create my own sequence like this:
UiPath.Java.Activities.JavaScope input properties are using default value.
Using UiPath.Java.Activities version 1.3.1.
Then, it gets me error like this:
Java Scope: Error intializing Java : System.NullReferenceException: Java initialization timeout expired.
at UiPath.Java.Service.JavaService.<StartServiceAsync>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.JavaInvoker.<StartJavaService>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Activities.JavaScope.<ExecuteAsync>d__16.MoveNext()
So, i set Init timeout
to 30000ms and still get the same error. I try another timeout limit and it errors too.
Then, i copy the Java Scope
activity from UiPath Docs example, and i get the same error too.
I try to downgrade UiPath.Java.Activities to 1.0.6863.33114 (it is same like the example from UiPath Docs), and i got this message:
21.4.4+Branch.master.Sha.a8b5101efe02651274064093e9c7410fedff7696
Source: Java Scope
Message: Error intializing Java : System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Java.Service.JavaService.<StartServiceAsync>b__7_2(IAsyncResult ar)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Service.JavaService.<StartServiceAsync>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.JavaInvoker.<StartJavaService>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Activities.JavaScope.<ExecuteAsync>d__12.MoveNext()
Exception Type: System.InvalidOperationException
RemoteException wrapping System.InvalidOperationException: Error intializing Java : System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Java.Service.JavaService.<StartServiceAsync>b__7_2(IAsyncResult ar)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Service.JavaService.<StartServiceAsync>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.JavaInvoker.<StartJavaService>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Activities.JavaScope.<ExecuteAsync>d__12.MoveNext()
at UiPath.Shared.Activities.AsyncTaskNativeImplementation.BookmarkResumptionCallback(NativeActivityContext context, Object value)
at UiPath.Shared.Activities.AsyncTaskNativeActivity.BookmarkResumptionCallback(NativeActivityContext context, Bookmark bookmark, Object value)
at System.Activities.Runtime.BookmarkCallbackWrapper.Invoke(NativeActivityContext context, Bookmark bookmark, Object value)
at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
I've set my path environment to C:\Program Files\Java\jdk-11.0.12\bin
Could anybody help me?
The weird part is i always success to run the example robot from UiPath docs.
Any solution could help. Thanks!
How to record page scrolling in UiPath?
Hi, Iwas using this Activity perfectly but when Uipath updated to last version, the automation I built stopped working.
The package version I'm using is 1.0.2.1 and the error is the copied below. Can you help me with this please?
Thanks!
Gabriel
"C:\Users\Bot PC\AppData\Local\UiPath\app-18.2.2\UiRobot
.exe" /file:"C:\Robot 1 - V1\Robot 1.xaml"
Robot 1 System.Xaml.XamlObjectWriterException: Cannot create unknown type '{clr-
namespace:GoogleSpreadsheet.Activities;assembly=GoogleSpreadsheet.Activities}Goo
gleSheetApplicationScope'.
at System.Xaml.XamlObjectWriter.WriteStartObject(XamlType xamlType)
at System.Xaml.XamlWriter.WriteNode(XamlReader reader)
at System.Xaml.XamlServices.Transform(XamlReader xamlReader, XamlWriter xamlW
riter, Boolean closeWriter)
at System.Activities.XamlIntegration.FuncFactory1.Evaluate() at System.Activities.DynamicActivity.OnInternalCacheMetadata(Boolean createEm ptyBindings) at System.Activities.Activity.InternalCacheMetadata(Boolean createEmptyBindin gs, IList
1& validationErrors)
at System.Activities.ActivityUtilities.ProcessActivity(ChildActivity childAct
ivity, ChildActivity& nextActivity, Stack1& activitiesRemaining, ActivityCallSt ack parentChain, IList
1& validationErrors, ProcessActivityTreeOptions options,
ProcessActivityCallback callback)
at System.Activities.ActivityUtilities.ProcessActivityTreeCore(ChildActivity
currentActivity, ActivityCallStack parentChain, ProcessActivityTreeOptions optio
ns, ProcessActivityCallback callback, IList1& validationErrors) at System.Activities.ActivityUtilities.CacheRootMetadata(Activity activity, L ocationReferenceEnvironment hostEnvironment, ProcessActivityTreeOptions options, ProcessActivityCallback callback, IList
1& validationErrors)
at System.Activities.Hosting.WorkflowInstance.ValidateWorkflow(WorkflowInstan
ceExtensionManager extensionManager)
at System.Activities.Hosting.WorkflowInstance.RegisterExtensionManager(Workfl
owInstanceExtensionManager extensionManager)
at System.Activities.WorkflowApplication.EnsureInitialized()
at System.Activities.WorkflowApplication.Enqueue(InstanceOperation operation,
Boolean push)
at System.Activities.WorkflowApplication.SimpleOperationAsyncResult.Run(TimeS
pan timeout)
at System.Activities.WorkflowApplication.BeginRun(AsyncCallback callback, Obj
ect state)
Describe the bug
When Python Scope is used inside a process with targetFramework Windows, the process gets stuck at Python Scope. There is no error logged in UiPath Studio. It just freezes for an unlimited period of time.
If the same logic is run in a process with targgetFramework Legacy-Windows, it works.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
I would expect to have the activity failing after a specific amount of time and have an exception thrown that gives some information about what is wrong.
The cause of this issue is that โ.NET 5.0 Desktop Runtime (v5.0.17)โ was not installed. This cause was discovered in Event Viewer.
Discovered in UiPath.Python.Activities v1.6.0
Describe the bug
Input arguments in properties window.There is no arguments in flowchart.
Screenshots
There is no 'Dict' argument.
Desktop (please complete the following information):
OS: Microsoft Windows 10 Enterprise 64-bit .NET Framework Version 4.7.1
Edition: Studio 2018.4.5 - 03/27/2019 Community Edition Windows Installer
Describe the bug
In version 1.0.7053.27728 the 'WorkingFolder' property was added to the PythonScope activity. Now when updating the package to 1.1.6863.33404, the 'WorkingFolder' property is gone.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
WorkingFolder property should be there.
Using UiPath.Database.Activities 1.5.0 "Start Transaction" activity does not execute wrapped Do sequence, skipping all its activities and not throwing any error. Downgrading to 1.4.0 solves the issue.
The implementation of the Download method of the IFtpSession interface for the standard FtpSession class will not work consistently, because of the misuse of an async call. See the below link, but put simply, the wrapped FTP client has two methods, one synchronous, which is used correctly in the case that the Download method is processing a folder, but in the case of files, the wrapped FTP client's asynchronous method is used, which returns and then does nothing with a Task. This renders this function useless if called on anything other than a directory.
Changing the call on line 443 of FtpSession.cs from:
_ftpClient.DownloadFileAsync(localPath, remotePath, overwrite ? FtpLocalExists.Overwrite : FtpLocalExists.Skip);
to _ftpClient.DownloadFile(localPath, remotePath, overwrite ? FtpLocalExists.Overwrite : FtpLocalExists.Skip);
should resolve the issue.
Describe the bug
File Exist Activity doesn't return true if file exist in folder (Using FullPath)
To Reproduce
Steps to reproduce the behavior:
Expected behavior
return True if file exist, false if not
Desktop (please complete the following information):
Additional context
Possibly issues on FluentFTP Depencendy Library
Environment
UiPath.Java.Activities 0.1.6774.30067-alpha
UiPath Studio 18.3.0-alpha.933
Preconditions
Steps to reproduce
Expected results
Actual results
Please see attachments for more details.
Description
Setting the Path field to point to the install folder of Python 36, and the Version field to show Python_27, will throw an ambiguous exception:
Main has thrown an exception
Message: Job python stopped due to unexpected process termination!
Exception Type: Exception
System.Exception: Job python stopped due to unexpected process termination!
If setting the Version to another Version, (but not the path`s version 3.6) something like 3.4, will throw a normal error message. Something like:
Error initializing python engine. Unable to load DLL 'python33'.
Perhaps we can use this same error message for python_27
Parameters that have value null in C# must be sent as DbNull.Value
to DB.
Python Scope activity requires Retired .NET Desktop Runtime Version
We are using enterprise licensed UiPath studio and looks like python scope activity is using .NET Desktop Runtime 5.0.17 version which is already retired. This is causing security concern and vulnerability issue for us. Can someone look in to this?
I have contacted one UiPath Staff and he mentioned he will pass this to the correct person ๐
Here is the link
https://dotnet.microsoft.com/en-us/download/dotnet/5.0.
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context
Add any other context about the problem here.
Environment
Python 1.2.6880.18459-alpha
Description
The new WorkingFolder property of Python Scope has this tooltip: "Used to specify the working folder of the scripts executing under the current scope."
Since the addition of this property, it would be useful to adapt the "File" property tooltip in "Load Python Script" to something like "Full path to python script file.".
This is because some people might mistakenly believe that since a WorkingFolder value was set in the Python Scope, they do not need to set the full path to the script file in the "Load Python Script" activity (which is wrong; the activity works the same, and it needs the full path to the file, just like before).
Describe the bug
The SFTP requires new security practices:
โข Host key algorithms: rsa-sha2-256, rsa-sha2-512, and/or ssh-ed25519
โข Key Exchange (KEX) algorithms: curve25519-sha256, [email protected], diffie-hellman-group16-sha512, diffie-hellman-group18-sha512
When connecting to this SFTP, we got an error.
Error: An established connection was aborted by the server.
To Reproduce
Steps to reproduce the behavior:
SFTP:https://dataexchange.televox.com/
Port:22
Additional context
Current Uipath.FTP.Activities use SSH.Net 2020. It needs to be upgraded to 2024.
Description
User encountered an error while trying to execute a query, see this topic for more context:
https://forum.uipath.com/t/getting-stored-procedure-output-error-value-is-too-large-to-bind/71881/
When running UiPath python activities with 64 bit python interpreter there is an issue while the same works fine with 32 bit python interpreter.
Problem lies when we are dealing with advanced ml packages which work only with 64 bit version
Environment
UiPath.Java.Activities - 1.0.6787.19104-beta
Description
The Invoke Java Method does cannot call Generic methods
Please see attached log for more details.
Please note that if this is a limitation (due to the fact that in Java the type info in generics is lost after compilation), we should make sure to document it for customers.
Repro steps
Expected results:
Actual results:
Describe the bug
If you import a function from another Python file and use the Load Script activity, UiPath throws this exception: "ModuleNotFoundError : No module named 'to_import'"
To Reproduce
Steps to reproduce the behavior:
Expected behavior
It should import the function and run it without any problem, just like from the command line.
Additional context
Example workflow here: https://drive.google.com/open?id=110ZaUyYRcYuUv5y6pvP0SKO8OcLgo2bw
Describe the bug
Java Scope: Error intializing Java : System.NullReferenceException: Object reference not set to an instance of an object.
To Reproduce
Steps to reproduce the behavior:
Source: Java Scope
Message: Error intializing Java : System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Java.Service.JavaService.b__7_2(IAsyncResult ar)
at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func
2 endFunction, Action1 endAction, Task
1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Service.JavaService.d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.JavaInvoker.d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Java.Activities.JavaScope.d__12.MoveNext()
Exception Type: System.InvalidOperationException
1.FromAsyncCoreLogic(IAsyncResult iar, Func
2 endFunction, Action1 endAction, Task
1 promise, Boolean requiresSynchronization)Expected behavior
Could popup the messagebox as the expectation.
Desktop (please complete the following information):
Additional context
Download the example from below:
https://activities.uipath.com/docs/running-static-and-object-methods
So im new to this repo and while reading the README I come to this that this link - http://schemas.company.com/workflow/activities
is broken.
Description
there is version 3.7 of python available, and our python activities can`t use it
should we add support for it also?
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context
Add any other context about the problem here.
Description
It should be possible to retrieve different outputs out of ExecuteQuery activity.
A ResultType (default DataTable) should be set... based on this the output of the ExecuteQuery will be only of of a certain type:
Another option will be to get the output and based on the type to convert it automatically to one of the three types above without setting a datatype.
Environment
UiPath Studio Version - 2018.2.3
Oracle Database - 11g Enterprise Edition
Operating System - Windows 10 Pro
Database Activity Pack Version - 1.1.6660.26865
Steps to reproduce
Describe the bug
Trying to set the Python path to a virtual environment results in an exception when using the Load Script activity: "There was no endpoint listening at net.pipe://localhost/UiPath.Service/Host_IPythonService_13976 that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ----> System.IO.PipeException: The pipe endpoint 'net.pipe://localhost/UiPath.Service/Host_IPythonService_13976' could not be found on your local machine."
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Should work just like when providing the system Python path
Screenshots
http://prntscr.com/ma29e6
Additional context
Example workflow to reproduce: https://drive.google.com/open?id=1S-RYuGmxN6vWDlWANnVEJcSzF7oaclI_
Describe the bug
I installed a new version uipath, when init a project from empty flow, it always give failure message failed to download package **
, which make me crazy.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context
NO.
Is your feature request related to a problem? Please describe.
It would be great if the logs from Python (like from a print() function) would be transposed inside of UiPath output. Currently, even if a script fails in Python, running it using the Run Python Script activity gives no output in UiPath.
Describe the solution you'd like
Using both the Invoke Python Method and Run Python Script activities, the logs generated by the Python scripts should appear in the output panel inside UiPath Studio.
List returnded by "Enumerate Objects" activity contains FtpObjectInfo elements with Property "Name" looks like "REMOTE_PATH/FILE.EXT" and "FullName" like "REMOTE_PATH/REMOTE_PATH/FILE.EXT". Can someone please confirm if is this a issue?
Thanks
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.