forum

Global actions - On start (cyclical) - Error description ?

0 12

Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (SQL)". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the SQL query of the subworkflow action... So now I am facing the mystery where exactly this error occurs at all and what exactly is the cause. Does anyone know where I can find more information about t (...)

Connection to SharePoint

0 1

Hello everyone, I need your help with a task that should actually be relatively simple. I'm trying to establish a connection to my Site Collection in SharePoint and have entered the relevant data (Server and Site Collection, User, ...). When I click on "test", it loads for several seconds, and I get the error: Unable to connect to the remote server. Regarding my rights in SharePoint: I am the owner of the Site Collection. What could be the cause of this? Thanks in advance!

Connecting to on-premise Webcon from Power BI Service

0 0

I'm trying to connect to Webcon with Power Bi. Service I set up OData user and API key as described here https://community.webcon.com/posts/post/odata-format-in-webcon-bps/346. I do not have a problem to connect using Power Bi desktopapp but after uploading report to Power Bi service there is a problem with refreshing although I set up on-premise gateway on Webcon vm - invalid credentials. Has anyone tried to connect from Power Bi service to Webcon on premise server?

WEBCON 2023 and SQL 2022

0 1

Hello Does Webcon 2023 work with SQL 2022? Native or with compatibility db level 2019?

SOLVED -> Q: Is it possible to change the pencil color in "HANDWRITTEN SIGNATURE" FORM FIELD

0 2

Good morning everybody, did anyone of you managed to change the pencil color of the "HANDWRITTEN SIGNATURE" FORM FIELD ? Thanx and a nice, sunny weekend (not here ;-) ), Bjoern

RestAPI mode to admin

0 1

Changing the RestAPI mode to "admin" should allow you to update fields, including readonly. The documentation however mentions the requirement of "admin permissions" How to add requires admin permissions?. Below are excerpts from the RestAPI documentation mode -Enum: "standard" "ignoreReadonly" "admin" Optional mode parameter that specifies validation behavior. When empty or standard, all fields will be validated. When set ignoreReadonly, readonly fields won't be set but no error will be (...)

Dictionary unique items

0 1

Hello, Is there a way to ensure uniqueness of items in Webcon's dictionary when importing data from Excel, to avoid duplication? Thanks.

Report with previous user's tasks

0 2

I have request from business to create report that will be showing all instances , which current logged user had task to do in the past. Some user can have more than one task in workflow. Is it possible to prepare such report and in SQL filter make a join statement similiar to this: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY [WFD_ID] ORDER BY WFD_ID DESC) rn FROM [BPS_ConfigProd_Content].[dbo].[WFElements] LEFT JOIN WFElementTasks  ON WFElementTasks.WFT_WFDID=WFD_ID (...)

sending outgoing email configuration issue (Demo Version)

0 7

Hello, Can you assist me with the following? I'm attempting to test an outgoing/sending email but receiving an issue during the installation and setup of the webcon bps. I'm now working on WEBCON BPS 2023.1.1.89 demo version. Error image attached.

User privileges

0 2

Hello everyone, I have a question for you, maybe you can help me. I know you can set user privileges for each application or process separately, but I wonder if I can also restrict user visibility depending on some criteria.. For this scenario I've created: BPS user group: Software Engineer person X, person Y, person Z are part of software group Let's say there are also multiple projects and their details into a db: project 1, 2 and 3. process: Project update , each update process w (...)

Using dictionary process data in action “start a subworkflow (SQL)”

0 10

Hello community, I am building application with one Dictionary process, and one standard process with 2 workflows. I would like to start second workflow many times as subworkflow of fist workflow and assign it to the several users/users groups (one per subworkflow) selected from Dictionary process. I am trying to use action “start a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SE (...)

PowerShell - Connect-MsolService

0 0

Hi, Is anyone having trouble calling a PowerShell script that connects to MsolService? After updating WebCon to version 2023, the action calling the script ends with the error as below.

Sharepoint connection error

0 2

Hello, I am experiencing a problem with my SharePoint connection, which had been working properly until today. I've tried with multiple users and it is not working, same error. Webcon version 2022.1.4.174 If there is MFA enabled, is there a problem? Because it worked with MFA enabled. Any ideas?

Create Data Source from two different data connections

1 4

Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus

Not adding attachment - when using cyclical action create SQL subworkflow

0 4

Hi Guys I need your help. I start tasks based on a workflow but attachments do not transfer. If I do it manually as a action on path then the attachments move to subworkflow and its ok. But if I use a cyclical action to call the same action -> "create SQL subworkflow", tasks are created but without attachments :/ Example in the attachment, I trigger the same action: Uruchom zadanie TEST (en: Run the TEST task) I use version 2022.1.4.223

User > API authorization

0 7

Hi, I need to add an event to the AAD group calendar. Webcon uses/is synced with local AD. AD is synchronized with AAD. On the AAD side, an application with API permissions has been added Adding AAD groups and adding users to groups via graph API from webcon works fine. But, for example, if you want to add an event to the group's calendar POST method https://graph.microsoft.com/v1.0/groups/{group_id}/calendar/events The api needs to run in the context of the logged in user, not in th (...)

Different query execution contexts on environments

0 5

Hi, I have a problem with the execution of SQL queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that causes the execution of TEST SQL may be different than the rest of the environments? (...)

Dropdown choice attribute - language error

2

Hi, We have upgraded to ver. 2022.1.4.248 and I found the problem with language translations for the dropdown choice attribute. It seems like it does not translate just for dropdown - other types of choice attributes work just fine. Has anyone encountered a similar problem? 2022.1.4.248

Problem with upgrade.

0 2

Hi, I have a problem installing upgrad. I get a message : "User 'public' does not have permission to run DBCC CHECKIDENT for object 'ActiveTasks'. Anyone know what's going on and how to solve it?

Choice field limit to list

0 8

I have a choice field and it is populated from a data source with autocomplete activated. I want to limit the choice field to only the data from the data source. The user can't manually type any other text. How can I accomplish this?. Thanks