Nintex Automation K2

Hi Community,I am using K2 Dynamic Chart control and want to display the count of requests by status (e.g., Draft = 2, Submit = 1).Currently, my SmartObject  returns individual request rows with fields like RequestId and StatusText. Since the chart sums the RequestId, it shows incorrect values (e.g., Draft = 2, Submit = 3) instead of row counts.Challenge: I cannot modify the database (no SQL view or SP changes allowed). The SmartBox SmartObject does not support advanced grouping What I want:To show accurate grouped counts in my Dynamic Chart without modifying the database directly. in chart control there is any feature related to it.

User getting this pop-up box on a form but is unable to press the X on the top right to close, if they refresh the page, they will lose the data on the form.What to do? Also, where does the icon in the centre come from?   

Hi,On Nintex K2 5.8 I have workflows that are assigning some task to the users.On the task form a comment field is mandatory.When you use the worklist for this task (without opening the task form), you area able to do the requested action on the task without inserting the mandatory field. So the worklist action is bypassing the task form validation.This is possible from the user workspace, but also from the SharePoint (online) worklist.How can you solve such an issue?Thank you. 

Hi,I’ve create a rule “When a control is changed” on drop-down list and put advance condition for transfer data to another control Normally, the rule should run when I’ve select data on this drop-down But, when I open the view with parameter(execute read method) for put data to drop-down list and another column,  the rule "When a control is changed" is running. How can I set the rule for running only when drop-down list is select or change not when the view initialize with data. Thanks,Tim

I’m using Infopath forms on a Sharepoint forms library. Due to a migration to Subscription Server some date fields weren’t working properly anymore. I’ve updated these fields and uploaded the forms again in central admin, but some of the forms aren’t working.Here is the strange thing: when I add the form content type to another library it works like a charm, but the updated form on the same library doesn’t work.

Issue DescriptionWhen you install or run the Setup Manager on your computer with only Client Tools, the setup now requires a connection to the K2 Database., whereas it was previously not required.Error Message:The following error occurs: "The user 'SQLUser' is not a member of the 'dbcreator' and 'securityadmin' SQL server roles."ResolutionThe fix is available in:Nintex Automation K2 (5.8) Fix Pack 23.Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed. Download the latest Fix Pack using the links in the table above for the version you require. Install the Fix Pack to apply the fix. It is recommended to clear browser cache and refresh the page.

Using 5.6 at this time with a process having 200 boxes.Currently I have to manually search for the box.Would like to see a search feature that can point me to the box on the process.On the advanced side, show a list of nodes where a given text appears and allows me to go to them.

Based on log details provided by my DBA, I noticed the top queries executing in K2 DB belong to schema “Utility”, “Identity” and “Server”. Below are the K2 processes causing the huge transaction log:-Identity.AcquireLockForIdentity Server.kLogProcInsts Identity.ReleaseLockForIdentity Utility.EncryptionBeginMay I know is there a way that can minimize the transaction log size?

Hi,I am using K25.7, I recently encountered an issue with email events containing attachments in our workflow.The support team initially recommended applying Fix Pack 13, which resolved the attachment issue.However, we are now facing workflow failures where the activity recipients are null, specifically for reference items within a loop. This started after updating the SmartObject method, and although the data exists in the database, it is not being picked up.I am here attaching screen shot for your understanding.In Test1 Email, emails were received with correct values. In Update Status, updating only status field. in TestPostUpdate email , FQN is getting blank values but there are values in database table.If anyone has encountered a similar issue or has a recommended solution, please advise. Best Regards,Thriveni

Hello, can you help me please? Exception of type 'System.Web.HttpUnhandledException' was thrown.<br/>The AAD:xxxx@xxx.mx could not be found.  

Hellowe have observed very strange behavior with some users. When downloading a PDF document, the downloaded file is not shown in the downloads folder.Only PDFs aren't being downloaded; other file types work fine. The server response has status 200; I see the request in Chrome Developer Tools, which confirms that the server successfully responds to the request. However, the PDF file still doesn't appear in the downloads folder. Other file types, like Word documents, for example, work fine in Chrome. Downloads work for all file types in Edge. For some users, it is a temporary problem and resolves itself after some time, but may appear again, it comes and goes. Problem appears only on K2 Sites.We weren't able to find out what is causing this behavior we fix it by renaming the user profile, Backup Bookmarks (take note of plugins) Close Chrome Rename C:\Users\%username%\AppData\Local\Google\Chrome\User Data to C:\Users\%username%\AppData\Local\Google\Chrome\User Data - BackUp Restart Chrom

​@EttienneS Hi, your name came up n K2 for VS 2015 package.  😁If VS 2019 can load the K2 designer extension, the deployment functionality could work?VS 2015 / 2017 / 2019 are highly compatible for extensions. Seems it just needs to change a few references to point to VS 2019 path/registry.https://devblogs.microsoft.com/visualstudio/how-to-upgrade-extensions-to-support-visual-studio-2019/change K2 for Visual Studio 2015.xml:Reference 2019 name <AllowedDependency Type="Application" Name="Microsoft Visual Studio Professional 2019" MatchType="EqualTo" /> Path set to Microsoft Visual Studio 16.0SourceCode.VisualStudio(2015).reg:Reference 16.0 registry.SourceCode.Workflow.VisualStudio (2015).reg:Reference 16.0 registry.If anyone tried this and didn’t work, chime in.   Thanks.

Hi Community,I want to integrate Box.com with Nintex K2 (K2 Five) to allow file upload, download, and folder listing via SmartForms or workflows.I’m starting from zero and would really appreciate a step-by-step guide or best practices for: Setting up OAuth2 with Box Connecting Box API to K2 (via REST or other method) Creating SmartObjects to interact with Box files/folders If anyone has done this before, please share your approach or example.Thanks in advance!

I have a SQL instance with the collation Latin1_General_CI_AS_KS_WS for SharePoint Server SE. Is it possible to install K2 on the same instance by manually creating the K2 databases with the required collation (Latin1_General_CI_AS)? When I try this, I get the following warning message .And when I click 'Continue', I get another message: 'K2 is the wrong type of database'."

I want to change color based on status Like i want to add different color for purchase order and different for sale order

Hi, Can anyone advice how to implement a calendar based worklist in SmartForm?My product is K2 Five (5.4).

I want to ask if it is possible to integrate Nintex Automation K2 (aka K2 Five) with multiple tenants, with multiple SharePoint Online, and use user authentication against Entra ID?Thanks in advance for opinions, or links to clear documentation.

In smartobject is calling APIcurl -X 'GET' 'https://api.com/account?user_id=111'response is { "deactivation_candidates": [ { "user_id": "usr_abc123", "confidence_level": 0.95, "is_regulated_account": false }, { "user_id": "usr_def456", "confidence_level": 0.88, "is_regulated_account": true } ], "retention_candidates": [ { "user_id": "usr_ghi789", "confidence_level": 0.75, "is_regulated_account": false }, { "user_id": "usr_jkl012", "confidence_level": 0.99, "is_regulated_account": true } ], "analysis_summary": "Daily automated scan"}Now issue is we have user_id in request and response

Nintex automation on prem - How can you put trigger event on a message ?

Hi, For a SharePoint online list where the manual K2 workflows are visible on the dropdown to start manually  at the item level, it is some way to eliminate a workflow that doesn’t exist anymore on K2?Thank you!

Hi,I’m trying to deploy a K2 SmartForm that works on the development env. to the production with a package.It’s a SharePoint online form for New item in a SharePoint list.I have the bellow error. What could be the error for this?Fail    View    NewKKKK_sharepoint_com___sites___YYYY_Lists_ZZZZItemView    Error %d, Level %d, State %d, Procedure %s, Line %dCannot insert duplicate key row in object 'Form.EventInstance' with unique index 'UX_Form_EventInstance_ContextID_EventID_InstanceID_SubFormID_SubFormInstanceID_StateID'. The duplicate key value is (d732ab56-5d4d-4731-bdeb-615765b84ee0, c3e8535e-317e-45c7-9d10-bb1a132b08a4, <NULL>, <NULL>, <NULL>, 656963f9-e362-4eb8-b3fd-dc4ff7edccc0). Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. Warning: Null value is eliminated by an aggregate or other SET operation.    System.Data.SqlClient.SqlException (0x80131904): Error %d, Level %d, State %d

Hi All,Currently, I am working on a project to migrate Nintex Workflow 2016 on SharePoint 2016 to K2 Five. Some existing workflows use the “Query User Profile” action to retrieve user information from the SharePoint User Profile.Is there a feature in K2 Five that provides similar functionality to the “Query User Profile” action in Nintex Workflow? Thanks,Rizki

I have a SharePoint online list with K2 SmartForms (5.8 on prem).Using the out of the box generated SmartObject for this list in order to get the link to an item, I get a link like this one: https://[tenant].sharepoint.com/sites/[sitename]/Lists/[listname]/DispForm.aspx?ID=1 that normally works (making a redirect).But for a list the link is not functional, the iframe for the K2 Display Item SmartForms remains blank, without errors. Navigating the site, the link to the Display form is functional.Do you have an idea for what reason is happening? 

How to increase timeout for SmartObjects calling REST APIS