K2 blackpearl

Hi, We have a client which has put the K2 on a Database with Always on high availibilty groups across 2 servers using active passive infrastructure.For the sake of simplicity, lets call these SQL1 and SQL2.Our primary node is always SQL1. This acts as the “Live replica” and all read-write operations are done on it. SQL2 is just on standby and replicating with SQL1 in real-time. In case something happens to SQL1, a failover is automatically triggered and SQL2 now becomes the primary replica. Once the issue with SQL1 is fixed, we usually fail over manually back to SQL1, bringing SQL2 back as a secondary replica. Is this recommended by K2? Will this cause any issues?  

Got a few text boxes and text areas on a List View and have added Watermarks to all boxes and set the text to Arial 12 -> The Text Boxes show the watermark in Arial 12 -> The Text Areas show the watermark in tiny Arial 8 (i.e. much smaller) Why is this and how do i get the Text Area Watermark to be Arial 12? If i type in the Text Area, the font is indeed Arial 12, so the problem is the Watermark font size... Bug????

Hi K2 Community, Is there any product feature that enables migrate users with all permissions and worklist items related to them (e.g., migrate user A to user B without losing user A's tasks and work items)? I've tried to search information about this topic in the forum, but I only found threads related to user migration between AD domains: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Migrate-AD-users-to-different-AD/m-p/85952?advanced=false&collapse_discussion=true&q=user%20migration&search_type=thread https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Migration-script-for-moving-user-to-new-domain/m-p/85821?collapse_discussion=true&page=2&q=user%20migration&search_type=thread And both were answered redirecting them to a Microsoft's guide site. Has been any update since 2016 (the date from the threads I mentioned before) about this topic? Thank you for your help in advance. 

Hi, Is it possible to have a seperate AD Service for Nested AD Groups? I have an AD Group which i use for most forms, however i also have a Nested AD group within there which i want to use for a specific form only Is it possible to create a seperate AD Service instance and then click the NestGroups flag to true, and then use that Smartobject within this new form to use for when i need to specifically use nested groups? Thanks P.S. Even when testing on the current AD User Service and setting ResolveNestedGroups to True, the tester tool only brings back the AD Groups direct users, not the nested group.... Why?

I'm trying to use the contents of a multivalue field in an email, however when sent as plain text the values appear inside XML tags e.g: <collection><object><fields><field><value>MyVar</value></field></fields></object></collection> If I try to send the email as HTML, it doesn't even display in Outlook, no doubt due to these tags. How can I just get the values and strip all the tags?

K2 4.7 Studio workflow error when trying to browse smart objects through the context browser or through explorer.Error :System.NullReferenceException: Object reference not set to an instance of an object.at SourceCode.Workflow.Common.HostedServers.SmartObjects.GetSmartObjectGuidCollectionForCategory(Int32 categoryId)at SourceCode.Plugins.SmartObjectBrowser.Framework.ServerItem.OnLoadItems()

Hi, How dow we implement the single sign on(SSO) with SAML way of authentication against the Azure Active Directory services (AAD). As per the documentation below, K2 supports SAML authentication for SSO. Documentation has the list of steps to achieve the OAuth way of SSO with AAD, but has no steps detailed to achieve the same for SAML way doing with Azure Active Directory. Does anyone have got the documentation or detailed steps to achieve the SAML way of Single Sign On with Azure Activie Directory.  Documentation : https://community.k2.com/pfxaw45692/attachments/pfxaw45692/K2_blackpearl/20825/1/K2_Authentication.pdf ThanksPrasant

I have a workflow and one of the steps in the worflow is the creation of a PDF from an item view. The workflow works fine the only issue is that the PDF is squeezing the item view into the middle of the page. See the screen shot attached Could any body advise how I get the pdf to use the full page Regards Andrew

Hi ALL, Currently have an issue around starting a workflow from a form. Each time I try to trigger the "Start a Workflow" Event, i keep getting the error below; " Value was either too large or too small for an Int32 " I have checked the values that I am passing into the workflow datafield, and ensured that the datatype is same. Still have the same issue. Not quite about what the issue may be. Will really appreciate an answer Pronto. Thanks all...

HI in K2 designer I would like to refresh a view list based on a value from a different view that is in the form.my example when man days = 5 then show approver x in the views approvers list. if man days <= 4 then show all. What I need is a change event but am seeing it in designer, is this possible? this is a sharepoint list btw

How do I get a workflow ID?

Dear K2, Does SharePoint Content service broker Impersonation work on SharePoint 2013 sites? FYI, SharePoint Service V2 service broker impersonation works on SharePoint 2010 sites in our environment. Thanks.

I've got a form that captures images and stores them in a nvarchar(max) column in SQL.  For some reason I'm spacing on how to display this image on an SSRS report.  I know I've seen this done before, but can't figure out what I'm missing. The image is being stored in SQL  in the following format - <image><name>Imagename.jpeg</name><content>imagecontentgoeshere</content></image>.  I can pull that field into SSRS, and use this field to populate the value behind an image control.  On the image control, I'm setting the source to database.  I've tried all sorts of file types/mime types, but can't seem to get anything but a red 'x' to show up. Any hints would be great.  Thanks.

In K2 Studio, how can I specify multiple SP groups to remove permissions? K2 studio allows me to pick only one SP group at a time.. does it mean, if I have five groups to remove, I will have to create five events?  What I am doing wrong? Can someone please try? If you can select multiple grops? We are on version 4.7Thanks,

Hi, I want to remove the duplicate and disabled users from License management.Due to these additional users my license user count is exceeding the limit.kindly suggest me any solution. Thanks in Advance. Regards,Hemant

Hi all, So i've got a list where the user selects a row (the row has 5 fields) I want to then transfer all of those 5 fields into another List, but put all 5 fields in one column and a new line for each of the 5 fields.End result would be all 5 fields in 1 field on the other list. I am using the transfer data rule, and can put the 5 fields into one column, but it's all next to each other. My question is, how do i get each field onto a new line???I tried <br> between the fields and, neither of which work. Basically here is how i want it to look: PICKER LIST - Row 1 (field1, field2, field3, field4, field5 Add New RowTransfer data to this New Row NEW LIST - Row 1 (field1)field1 should look like this Field1Field2Field3Field4Field5 Come on K2ers, whats the magic character for the new line between items so that i can chuck everyone into one Column? Thanks 

I have to implement a logic to check if a document exists in a document library using a key field. If document exists, update a custom meta data column. But when document doesn't exist, workflow throws error. How to bypass this error if document doesn't exist?Thanks!

Hi, Is there any technique on a List view to mark items as done? For example, i have a Summary List View, when user double-clicks a record (row), it opens a form in a seperate window and they do whats needed in that form and close it. Then they go back to the Summary List View and do the same with the next. Is there a way of highlighting/change colour of completed rows in the Summary List View or put a Check box next to each record so the User knows which ones have been actioned? The List is Not editable, just used to double-click to open a record and mark as done. Thanks

Anybody knows how can i obtain the product K2 Designer for Visio because i want import Visio diagrams to K2 Studio.Than you

We have a Smartbox drop down list which is populated from a table query.  The list contains a group of students for a class. We have set up an editable list where a person can select each individual student to take an exam. Can we add a control to 'Select All' the students and add them to the test form? I am looking into using the for/next logic, but not sure how to use this, and I can't find a clear example; at least for me. If I were programming this I would save all members in the table collection to an array, then parse through them one at a time to add them to my new list.   After they would all be added, there is another form button to write them out with the form. I would need some screen shots of rules, or routines (an example); if I were to get this to work. Thanks!  Any help is appreciated; it will save some time for entering information.

I've been at this a while now, I'm reading a boolean colulmn from a list of records. With that, not all the records have a value, thus some contain "NULL" during a looping process. Items without a value are to be orphaned and pushed back into the prior task to again be addressed. Within the Split Rule I've attempted the following: IF (Bool != scnull (Plain text)) THEN...----IF (ToString(Bool) = Empty String (text) THEN...----IF (Bool = True (True/False) OR Bool = False (True/False))THEN IF (Bool = True(True/False)) THEN Approve (Path) ELSE Deny (Path)  ELSE Orphan (Path) ----IF (Length(ToString(Bool)) >= 0)THEN IF (Bool = True(True/False)) THEN Approve (Path) ELSE Deny (Path)  ELSE Orphan (Path)  A Few others, but in the end whenever I compare my Boolean against a "NULL" I get either: String was not recognized as a valid BooleanOR Unable to compare values that are not of the same type  Any suggestions? I also though of creating a reference before hand and filtering out thos items in

I am trying to use the 'SharePoint Groups' SO as per this article (https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Binding-the-users-from-a-sharepoint-group-to-a-drop-down-in-K2/td-p/84402) This isn't sholwing in the catorgy structure when selecting a smart object as a data source on a dropdown control I have created on a K2 smartform. However, when looking at the structure via the SO Tester client, there is a section at the bottom called 'All Smartobjects' and when expanding this we can see the SharePoint Groups SO... but it doesn't say which category it is in?  We have been through every category manually and it just isn't there for us to select? Sould we see the 'all items' category via designer?  Or is this a helpdesk fault request? Thanks, Julie

Hey everyone, I got an issue when i want to choose list to update list item in K2 Studio.I have a workflow built in 2010 blackpearl, moved into 2016 blackpearl environment and i cannot connect to my SP2016 list. Searching around found that "Sharepoint Item Url" is applicable to 2007/2010 versions. Moving on i would like to pick "Update List" from Sharepoint 2013 - List Events in order to update a field in my sp list. When SmartWizard pops up , i choose use list and the dropdown is empty. Anyone faced it before? Any suggestions? I am pretty new to Sharepoint 2016 Blackpearl.

We just upgraded our dev environment to 4.7.   In a workflow, I have an escalation set by reading an SQL DateTime field via a Smart Object.   The escalation is set for 1 hour later than the value in the field.  For example, the value in the field was 4/28/2017 and 13:44:11, but the escalation was set for 4/28/2017 and 14:44:11 (per confirming the Server.ASync table).   Why is the To DateTime function adding an hour? EDIT:  I had to write the time above in a non-datetime format.  K2 community's site redacted sections of it. 

Is there no way to use validation around a rule completely? In the below ruleset I would like to check validation first then complete every step thereafter. I can't seem to add the validation step around all of the listed rules unless I add multiple validation steps. I figured I could just run one validation up top to check before running then user "Stop rule execution", but there is also no option for "If the Form fails validation".  Is there anything that can be done other then adding in multiple validation steps? Thanks,