Archive

 Symptoms I created a SQL table, all is fine when I execute Read, Update, Create, Delete methods, but when trying to execute List method, I am getting access error.What permissions in SQL does a user need to be able to call List method in a smart object? Diagnoses Provided the link below to see if the client was using linked servers:Please see the below link for more information:https://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.6/webframe.html#sic02.html- The client also mentioned they are not using any linked servers.if the previous link does not work then one other thing that we need to do is:- grant the K2 Service account 'dbo.owner' permissions on this database- use the "ServiceAccount" Authentication ModeAdditional information:http://community.k2.com/t5/K2-blackpearl/Service-instance-Throwing-Error-on-SmartObject/ta-p/77865If both settings: On Different SQL Server" = true and "Use Native SQL Execution" = true then K2 calls the stored procedure sp_addlinkedserver anyway. Re

 Symptoms Lithium theme does not have the total number of pages available in a listview , even if we set SmartObject.RuntimeListViewRowCount to true.Any workaround? Diagnoses customer resolved the issue on his own.His last response was:"We found a soultion for this bug,you can find below the CSS (for LTR and RTL directions) to overcome this issue:.grid-paging-control {width:120px !important}.toolbar-button.paging-right {margin-left:80px !important}.toolbar-button.paging-last {margin-left:80px !important}.grid-paging-control-text{display:inline-block !important}.grid-paging-control-text.current{float:left !important}.grid-paging-control-text.total{float:none !important}html[dir=rtl] .grid-paging-control {width:120px !important}html[dir=rtl] .toolbar-button.paging-left {margin-left:80px !important}html[dir=rtl] .toolbar-button.paging-first {margin-left:80px !important}html[dir=rtl] .grid-paging-control-text{display:inline-block !important}html[dir=rtl] .grid-paging-control-text.current{f

I use a workflow to create some HTML that I store in a field on my list item. I can do all kinds of stuff - for example create a table. Then when the list item is viewed, the nice table is shown in a field.However - there is one thing that is somehow left out: I want my HTML to refer to a stylesheet, so the styling of the table can be dynamically changed later without having to re-run the workflow on all the list items. But my "<LINK REL ...." stuff seems to be ignored.An example:I have a list with a multiline textfield called "SomeHTML" and this workflow:Running the workflow on a list item results in this way - I can see the result of the two heading tags and they appear in the DOM viewer, but the "<LINK Rel..." has magically disappeared.How should I go about making a reference to a stylesheet in the workflow generated HTML?RegardsLeif

A Site Workflow which is scheduled every day at 5 a.m. (GMT) does not start on some days, on others it does. I don't know why.Is this a known bug?What I already did was cleaning the Workflow History for this Workflow and assign a new dedicated "Workflow Task List" to this Site Workflow. But the issue continues.Has anybody experienced a similar problem yet, or has a solution for this? Thanks in advance.Dom.

Hi everyone, I'm new to Nintex and have a seemingly simple problem but just don't know why it happened.Here's the scenario. I'm wanting to test Reminder alerts if an item is not approved/rejected one (1) Day after item creation and every hour thereafter if still not worked on.I've created a Workflow Variable called "My Due Date Variable".Added a Calculate Date action. Entered "1" in the Days field. Also ticked 'Use date when action is executed' option. Stored the date in My Due Date Variable.Added Flexi Task action. Set Due Date field to My Due Date Variable. Under Reminder tab, I added "20" for Number of reminders field. Also added "1" for Hours field. Problem: I received the email alert 1 hour after item creation (and subsequent hours). It acts as though the Due Date field did not matter and Reminder alerts were not dependent upon Due Date Variable. Shouldn't the Reminder alerts trigger after Due Date has passed? Appreciate if anyone can shed some light. Using WF 2013 v3.1.6.0. Thank

I am using the Workflow Report viewer webpart  for one of my sites and it is set to report on errored workflow (all sites). The default columns that appear after configuration are workflow name, initiator, start time and last action. These columns are useful however does anyone know if there is a way to add additional columns in the webpart or a webpart that provides me with the ability on reporting on other columns? Thank you!! Rency

 Symptoms After editing the following section of K2HostServer.exe.config:URLhttp://K2Server.domain.com:82/SmartObjectServices/endpoints/endpoints.xmlreturns:HTTP Error 401.2 - UnauthorizedYou are not authorized to view this page due to invalid authentication headersHow to configure SmartObjectServices Endpoints? Diagnoses First of all based on the configuration listed above correct URL supposed to be:http://K2Server.domain.com:8888/SmartObjectServices/endpoints/endpoints.xmlAs we have parameter port="8888" specified there. Next it is also necessary to configure bindingConfiguration sections for wsHttpBinding+Windows and webHttpBinding+Windows and specifiy security mode as "None":It is also necessary to make sure that URL reservation for http://K2server.domain.com:8888 is exist and if not create it:Issue this command to check if URL reservation already exist:netsh http show urlacl url=http://K2server.domain.com:8888/If this command returns no results, create URL reservation by issuing t

I want to send workflow task and notifications to users in SharePoint Group. I am able to add that group in the "User Task" action but email only goes to single user and not all the users within the SharePoint group. I don't want the review to be dependent upon the people picker values within the form. I would like the K2 appit workflow to reference SharePoint groups Is there anyways to accomplish this? 

 Symptoms  During "heavy load" periods most of the running processes fail with following error:   "Exception has been thrown by the target of an invocation. Insufficient winsock resources available to complete socket connection initiation. An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full".  Diagnoses  Most likely these symptoms indicate that custom code (e.g. custom service broker) used in environment does not close opened connections properly causing errors mentioned above. In addition to this you may want to review the following Microsoft KB: "Kernel sockets leak on a multiprocessor computer that is running Windows Server 2008 R2 or Windows 7"    In some scenarios it may be necessary to adjust values in the following registry settings:   KEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesTcpipParametersMaxUserPort = 60000 HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesTcpipParametersTcpTimedWaitDelay = 30   S

 Symptoms  Receiving the following error message while starting Blackpearl Setup Manager:   "Unsupported license entered for Windows 7, a developer license is required for K2 Server installs"  Diagnoses  This error is being thrown when you are trying to install all components (both server and client) on a Windows 7 client machine. Though such configuration is not supported as clearly indicated in K2 blackpearl compatibility matrix you may still proceed with installation in such scenario (only for development or testing purposes and accepting the risks of running unsupported configuration). In order to bypass this error message disable the "checkwindows7" property in the product.config file. The product.config file can be found in "C:Program Files (x86)K2 blackpearlSetup" and the setting should look like this:  <setting key="checkwindows7" value="false" />   Resolution You should understand that installation of K2 server components on desktop OS is supported only for developer lic

Hello,in my form I am saving employee name + applicable period + applicable year + type of action as the title via a calculated column. if any of the information is changed, it would create a new item instead of updating the current one. I know InfoPath does this, any idea how to do this with Nintex forms? I've set the list to set title for unique values but that does not help.Please advise.

Hi again. In a list view on a form, I don't want the "Save" button to be enabled until a user selects a list item.  That way, he/she can't save unless something is selected to write the data using the create/update method. Defaulting the save button to disabled and adding a rule to enable when a list item is clicked works great...but unfortunately, if the user clicks the little green arrows pointing at each other right above the list view (Apply quick search) it will refresh the view and unselect the selected item, but the "Save" button remains enabled. So, I'm looking for one of two things:  #1 - Is it possible to write an action against the condition the Apply quick search button is clicked?#2 - Is it possible to have some kind of conditino that says "When nothing on view is selected" Or, I'm open to other suggestions. Rob 

 Symptoms Error when creating new application. I have a new application to create. The list is done but I'm getting an error on application creation. It's attached below. I suspect it may have to do with using too many Choice columns in the list--there are a total of 58. Error message below. Can you confirm that there's a limit on the number of choice columns (these generate SmartObjects in the list) and if so remind me of the limit? I can design around the limitation, but want to confirm this is the problem. Thanks.String or binary data would be truncated. The data for table-valued parameter "@Control" doesn't conform to the table type of the parameter. SQL Server error is: 8152, state: 10 The statement has been terminated.HelpLink.ProdName : Microsoft SQL Server HelpLink.ProdVer : 12.00.0015 HelpLink.EvtSrc : MSSQLServer HelpLink.EvtID : 8152 HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink HelpLink.LinkId : 20476 OriginalClientConnectionId : 81646051-4f9c-44c8-803c-a3365ad90226

 Symptoms Workflow step for user SmartForm action not sending email. I have a multi-step workflow with several SmartForm user tasks and the last one in the workflow is not sending the email but I can see that step as "Active" in the K2 Worklist. I tried inserting a new step just before it and setting it up just like the one that isn't sending the emails, then removed the other task and the new one is exhibiting the same behavior. Diagnoses This was an issue when using the CC field for the email property of the people picker control. Which passes and ID value. Resolution Resolution:Using the SharePoint Email inline function and selecting the people picker node property, resolved the issue.  

 Symptoms Forms do not load within K2Mobile app. For acceptance only, the forms do not load when I try to access them via the K2Mobile app. Tasks are still being pulled in from the server, and I have walked through (and gotten successes) on everything in the K2 Mobile troubleshooting page (http://help.k2.com/kb001641)When I open any of the forms (via the forms section, or by clicking the form button on a given task) I get a 401 error. I can access all of these forms successfully from my desktop, and have accessed them from mobile in the past.This seems to have started after the iOS 10.1 upgrade the iPad received this morning. Diagnoses Cache credentials usually saves the token to the Phones store which can't be recycled by resetting the phone. Only by reinstalling the app. Resolution Reinstalling the K2 mobile app the issue went away and the forms loaded correctly.  

 Symptoms Date with year prior to 1773 do not return in List Method. We have a MSSQL table column with a datetime2(7) datatype. When we call the list method , the date column returns data for dates after 1773. But no dates are returned prior to 1773. Diagnoses This has been identified as a Bug. Resolution A coldfix was provided which resolved the issue.  

 Symptoms List View won't sort on Expression columns. I have a List View that is connected to a SmartObject. Some of the columns are Expressions of the other columns. This is done for display or calculation reasons. I didn't want to put all that logic in the Sql Server Stored Procedure, if possible.I can not click on the Expression columns and re-sort those columns. The other property SmartObjects columns can be clicked on and sorted. Kind of deal breaker for the Business. Can you confirm this limitation? Any thing I can do differently in the View? Or do I need to move all that logic to the Stored Procedure (not ideal). Diagnoses This is by design. The expression values are not available to the SmartObject layer, and thus no sorting can be done on them. Resolution Creating a Storeprocedure so all the calculations take place there and create the SmartObject and view from resolves the issue.  

 Symptoms Form's level rules associated to view's rules disappear after updating child views rules.We have a common view (QuestionInstanceMultiControlList) associated to all our forms, this view is the backbone of the forms, we are trying to add new features to this common form, but for some reason Form's rules not associated to the new features are being removed and sometimes the rules order is changed in the form level. Diagnoses Rules often get misplaced during the deployment or creation of them. In some cases they disappear form the destination server. That was not the case and the error wasn't reproducible. Resolution Recreating the rules and redeploying them resolved the issue. 

 Symptoms CRM Broker Connection issue Post 4.7 Upgrade. Strike is using the out of box CRM broker to connect to CRM. We are using a Static user for authentication and is configured as below.This works fine for a while. However after the system is idle for a period of time we start receiving errors "An unsecured or incorrectly secured fault was received from the other party". This happens in the smart object tester and on the forms.To troubleshoot we have done the following.1. Refresh the service instance. This fixes the problem temporarily but it will recur when the system is idle.2. Point to a different instance of CRM. This instance is current and known to be working with K2 4.6.9. The same error occurred.3. Reset IIS on the K2 server. No change.4. Review the logs in K2, CRM, and AD. K2 log shows the same error. CRM and AD logs show no anomalies.5. Review the Event log on the K2 server. Nothing that points to the cause of the problem. Diagnoses This is a known behavior. Resolution A

 Symptoms Post-Deployment: Unable to register dependencies for SmartObject. While I did deployment, I got the error as attached snapshot: Post-Deployment: Unable to register dependencies for SmartObject. I don't really understand what the error is. Could you please help me how I could fix it. Diagnoses SmartObjects are based in Service Instances. If a service instance is out of sync from the source environment the SmartObjects will not deploy Resolution Restoring the database whish is used to create the smartobject from the source to the destination resolved the issue. 

Is there any way to attach two work flows to a single form? One work flow to be triggered by one event and the other by different event. This is needed as different triggers require different kinds of review and approval. Then each work flow is responsible for send out the appropriate email pertaining to that action. Any help would be appreciated.Thank you EDIT: If there isn't a way to have two workflows on a single form. If one single work flow with 4 outcomes needs to be created, is there a way to note in the email that notifies the approver which action was perfomed so they they can choose the correct path.

I've got a status page on my forms and I need to display who has the task open vs. who ( when assigned to multiple users - single slot) the task is assigned to. The problem is i can't find this info in the database.  What does the Workspace>Management> environment> workflow server> worklists section use to display this info?     Currently I am referencing the Workflow Report > Workflow General > etc.  SmartObjects to display the status info and I can get it show who actions the task but there is a need to identify who currently has the task open.    

How do i query a list with all files that has not been modified today using a site workflow.

Hi i need to hide controls based on group members which was created in sharepoint 2013. (I'm using SharePoint with K2 Designer) Thanks in Advance... :)

 Symptoms Control Type 'GUID' Not Found Diagnoses Issue:Control Type 'GUID' Not FoundA user on the PROD environment ran into the error 'Control Type GUID Not Found'. Other users did not get the same error, we were also not able to replicate the error. The user accessed the site again a few hours later with no errors showing. Resolution Resolution:Following on from the initial investigation, it was established that this is a know issue and there is an existing codefix.Codefix was sent and customer chose to close the ticket.