latest posts

HI,

I think you forgot to install ASP.NET Core 5.0 Runtime (v5.0.17) - Windows Hosting Bundle Installer (https://dotnet.microsoft.com/en-us/download/dotnet/thank-you/runtime-aspnetcore-5.0.17-windows-hosting-bundle-installer).

Hi Christian,

you could check out this post

https://daniels-notes.de/posts/2023/updating-to-bps-2023

Alternatively you could also look at:
https://community.webcon.com/forum/thread/3063
https://community.webcon.com/forum/thread/3065
;)

Off topic
Maybe you can upvote this user voice
https://community.webcon.com/forum/thread/5519/15

I still hope that it may get implemented. :)



Best regards,
Daniel

Hi guys,

Did anyone of you ever encounter the HTTP 500.19 - Internal Server Error like the one in the print screen immediately after a fresh installation? Any ideas what could be wrong?

Thanks,
Martin

Hi all,

first of all: this is not supposed to be a moaning complaint, just a heads up so other people dont fall for the issue that hit us today.

I wanted to share some info regarding the update from 2022 to 2023, as we ran into some very unsatisfying issues with SQL COMMAND business rules that are querying field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some pain right now.

If you still have to update to 2023 make sure you test every SQL COMMAND based rule (and datasource) that is using the Field-ID object, the behaviour of the result of clearwfelemID has changed in 2023.

In 2022 result of the DB function clearwfelemID (and also the Field-ID-Object in designer) was returning an empty string for fields having no value, so when evaluating a result from a query using this, and the function gave back an empty string in 2022 the behaviour changed to giving back NULL value in 2023. At least that is my impression.
This might be connected to the seperate ID columns and a change in the underlying DB function. I think that it even behaves differently when trying to get ID from wfelementdetails and wfelements tables. (specific ID field in wfelements, no specific ID field in wfelementdetails - you can see calculated columns in table wfelements, none in wfelementdetails, because there are no specific colums for choose fields in item lists).

Example:

I am using the following statement to find out if a check in our invoice approvals is necessary, depending on a template workflow that defines the running order, using an item list to define parameters to jump into steps or not.

Query is:
if exists (select 1 from wfelements WF_E , wfelementdetails WF_D where WF_E.WFD_ID = WF_D.DET_WFDID and DET_WFCONID = {WFCON:1614} and {DCNCOL_ID:121} = {ST:153} and WF_E.WFD_COMID = {COM_ID} and ({WFCONCOL_ID:1559} = '{I:1559}' or {WFCONCOL_ID:1559} = '') and '{I:68}' = {SYSCOL:WFD_ID}) select 1 else select 0

This part: "or {WFCONCOL_ID:1559} = ''" being the problem, as cases in which {WFCONCOL_ID:1559} would gave back an empty string in 2022, now, in 2023 give back NULL, excluding the cases that I was aiming for with that ["or {WFCONCOL_ID:1559} = ''"] part of the whereclause.

So whereever you have such scenario you need to change {WFCONCOL_ID:1559} = ''" to "{WFCONCOL_ID:1559} is null" to get proper results. I am not sure if this just didn't occur to me when I was reading the changelogs, but of course I fell for it in several occurences in the system. We went through all data sources when testing, fixed issues that were there, and failed to check the rules.

If anyone has questions and concerns, or didn't understand the issue from my textchaos: i will try to explain with examples and screenshots :)


Cheers, Chris

Hi Joanna,

if you already have an HTML field, you could add a script tag and execute InvokeMenuAction function
https://docs.webcon.com/docs/2025R1/Studio/UxRules_General/JavaScriptEditor/#invoke-menu-action

This will automatically execute the button whenever the HTML field is rendered.

I hope you are not creating and endless loop as only a few actions in the menu button don't trigger saving and reloading the form.

Best regards,
Daniel

Hello,

I'm wondering if it's possible to trigger the automation of a menu button every time the user opens a specific page. There is already a HTML field (button behavior) in my form that will do exactly the automation I need, but will be more helpful if this happens automatically instead of waiting for a click from an user.

Thank you very much!

Hi Andreia,

I'm using the action I linked above:

https://docs.webcon.com/docs/2025R1/Studio/Action/Form/Action_UpdateItemListValues


Best regards,
Daniel

The Webcon Version 2019.1.4.45

I need to change License Server from one Node to a other Node every Time i become a error Message.
I have configured in the Firewall the Port TCP 8002

The previous server was running on the 2012 R2 operating system and is now running on a Server 2019 operating system.

On the previous server, the licence server can be activated and deactivated without any problems. The listener is active and can also be displayed.

Reserved URL : http://+:8002/LicenceService/
User: XXXXX\sharepoint-spp-xxxxxxxx
Listen: Yes
Delegate: No
SDDL: D:(A;;GX;;;)


System.ServiceModel.ServerTooBusyException: The HTTP service located at http://Serverxyc:8002/LicenceService is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable.
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at WebCon.WorkFlow.Common.WFLicenceService.IWorkFlowLicenceService.Ping()
at WebCon.WorkFlow.Common.Licencing.LicenceClientManager.<>c.<CheckIfServiceIsWorking>b__17_0(WorkFlowLicenceServiceClient client)
at WebCon.WorkFlow.Common.Licencing.LicenceClientManager.ServiceAgent.Execute[TResult](Func`2 executionMethod)
at WebCon.WorkFlow.Common.Licencing.LicenceClientManager.CheckIfServiceIsWorking()
at WebCon.WorkFlow.Studio.Forms.MainFormControls.FormLicence.CheckLicenceServiceExists(DoWorkEventArgs e)


The strange thing about this error is that when I transfer the service back to the original server. The WCF service works without any problems. The URL can be accessed without problems and I get the info text from Windows Communication Foundation Service.

Hi Daniel,

You're doing this sql on what type of action?

My goal is basically to either hide or remove the rows that will have one column set to zero or empty.
This item list is a cargo list, it's initialized with data from the database, the user will only define the column with the quantity desired.
Because a lot of lines might be empty or zero, I want to remove them for better visualization.

I think I can use a selection attribute to search in the API data source, but is there a way to grab only the values that were selected in this attribute and save all records returned from the data source that meet the search keywords into an item list? The data source will surely return more than one column, and I think there might also be more than one row.