Archive

 Symptoms Unable to install February 2017 Cumulative Update Diagnoses It was discovered that the below component where not installed- Microsoft SQL Server System CLR Types- Microsoft SQL Server 2008 R2 Management Objects Resolution After installing the below componentsThe location where it can be found is in C:Program Files (x86)K2 blackpearlSetupRedist- SharedManagementObjects_x86.msi- SQLSysClrTypes_x86.msiAfter restarting the Feb CU it installed as expected  

Hi All, I am working on  producing a daily Turn-around time/ Task response -mail summary report. I understand that the OOTB reporting feature of Approver Performance Statics Reports contains a summery but what I need is a monthly rolling report for a specific task type that can be sent and e-mailed daily. I have the html table format and the beginning steps,query the list, get the date difference (assigned date - end date), round them off but I cannot for the life of me figure out how to add all of those tasks up and get an average. I tried the collection operation Add and the run-time function of average but they don't seem work. Is what I'm trying to do possible, if so can someone help me understand what I'm missing?Thanks in advance!

Within a query list I assign a URL path from a list item to a text variable.  At the end of the SITE workflow I send an email that includes the variable.  However, it never includes .aspx at the end of the URL and in addition it appears to add zeros to the Item Id within the URL string.I even tried Absolute URL, but same behavior no .aspx at the end of the URL...suggestions..thx

Let say I develop a workflow for a given custom list and I template that custom list--no really funny custom fields (Standard SharePoint Columns).Will the exported version of that workflow run on a different installation?  Let's say not even the same company environment.Or are there some things that are installation or license specific. I do realize if you use features from a more advanced version, they will not work.  Just for the sake of argument, let's say the versions are close and no advanced features are used.Would the workflow be expected to work?  This is just for my knowledge of portability.

Hi everyone,I have de custom Nintex Forms en a French Site collection hosted on a US SharePoint Server (itself on US Windows Server)This forms has a Date Time Field. Most of time, the date formatting applied is in french (dd/MM/YYY) wich is great.But Sometimes, the date formattin is in US. I could'nt determine why this users are mis-formatted (No correlation about the Device).Is this a known issue? What are the best practices about this local settings for a Nintex Forms?I'v alreday check the local setting on the site collection and the Web Application : they are all set in French.

We have a training site that periodically needs to be refreshed from a backup. We backup the Nintex and Content databases and restore as needed. We upgraded to a new version of Nintex and restored the older version to the farm which made the Nintex DB show up in the CheckDatabaseVersion output. Is there a way to run UpgradeDatabases on a single Nintex DB or is there a different way to upgrade a single Nintex DB ot the latest version?Thanks

I seem to be having difficulty searching for text in multiline text box in a workflow. I am manually populating a column based on items from another child list.  I decided to write "NO DATA" into the Status Field, also multiline, when no transactions were present in the detail list. I'd like to be able to query that textbox for the existence of "NO DATA" but my queries don't seem to identify any of the lines.I've tried a couple of things in the selection such as "equal to" and "NO DATA" also "begins with" since it's the only thing in the text box.

When the snippet is released onto the drop zone, nothing happen and my action set will not appear.

Hi All,I have done several WF's with word conversation, but this time I need to use check boxes as well.The problem is that the check boxes are converted as "True" or "False" in the word output and not as real check boxes.  I used the check box control in the word developer tool tab and in SharePoint its also a check box field. Any idea what adjustment needs to be done? ThanksRobert

I created a Nintex Form within a Nintext Workflow under option Workflow Settings > Edit Start Form > Edit with Nintex Forms.Now, I would like to create a button or link on the home page to launch the workflow.  I do not want to attach the form to the List, because I do not want the form to launch without the workflow.  Does this make sense?Is it possible to launch the workflow from a link or button on the Home page?  If so, how would I do it? Thank you.

Hi nintex gurus!I have a user that needs the following functionality in a workflow:- the forms have to be editable even after the information is submitted (i.e. I have to use "Save" instead of "Save and submit")- The information entered in the form should show up in sharepoint whenever the form is updatedI have a workflow with several forms in it, but the problem is that the information entered in the forms gets saved to the "workflow tasks" list, instead of the original list. So I'm setting up a second workflow in the "Workflow tasks" list, but I'm unsure which columns to use in order to link back to the original list.Do you know which fields/IDs nintex uses in order to link items between these 2 lists? Which actions and queries would you guys use? All brainstorming welcome

 Symptoms Dear,If I run the following query:SELECT * FROM [HostServer].[SecurityCredentialCache]I get around 500 recordsbut in black pearl it shows 302 so how come? how can I get the correct list of users?Regards, Diagnoses we had a copy of the .[SecurityCredentialCache] tablein the workspace the licensed users are the users who have cached passwords and have a value saved in the Password field.When we eliminated the rows where the password field is blank and also eliminate the rows where PasswordCached is equal to 0 we will get the 302 rows. Resolution Customer ordered closure of this ticket after the following reply"in the workspace the licensed users are the users who have cached passwords and have a value saved in the Password field.When you eliminate the rows where the password field is blank and also eliminate the rows where PasswordCached is equal to 0 you will get the 302 rows." 

I have been using UpdateListItems adding entries to a list that resided in another SharePoint site using a Call Web Service.  So far it works for everything except dates.  I finally got a solution for it to pass over "People" from list to list, but can't figure out transferring a date field.  When I use the example below it does not create a new item (passing information from one date field to another on the new list).  If I remove the line for the "Example date" it works no problem and creates the new list item.  Any ideas how to format dates?<Batch OnError="Continue" ListVersion="1" > <Method ID="1" Cmd="New"> <Field Name="ID">{ItemProperty:ID}</Field> <Field Name="Title">{ItemProperty:Title}</Field><Field Name="PMO_x0020_Primary">-1;#{ItemProperty:PMAssigned}</Field><Field Name="ExampleDate">{ItemProperty:ExampleDate}</Field> </Method></Batch>

Hello!I have a diary system where the user enters a due date.The workflow then pauses until that date and sends an email. After that reminders are sent every day based on a days interval setting. IE it'll pause again for 7 days and send again until not in progress.I would like that reminder email to go out at 9am. Any suggestions?Tony.

 Symptoms Error on all forms linked to a SharePoint Online objects:The remote server returned an error: (403) Forbidden.? Type:System.Net.WebException? Source:SourceCode.HostServerLib? Stack Trace:at SourceCode.Hosting.Client.BaseAPI.BaseAPIConnection.RemoteCall(String TypeName, String MethodName, Object[] Parameters, Boolean[] NullList, MarshalMessageType CallType)at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteCall(String TypeName, String MethodName, Object[] Parameters, Boolean[] NullList, MarshalMessageType CallType)at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteList(ArchiveX ax, ExecuteListReaderOptions options)at SourceCode.SmartObjects.Client.SmartObjectClientServer.GetSmartObjectReader(SmartObject smartObject, ExecuteListReaderOptions options, Dictionary`2and propertyReference)at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteListReader(SmartObject smartObject, ExecuteListReaderOptions options)at SourceCode.Forms.AppFramework.FormsApiToXml.To

 Symptoms Users seem to be getting the following message occasionally whilst using SmartForms: ?The remote server returned an error (401) unauthorized? If you click "OK" and refresh the page the error goes away. Diagnoses From the SharePoint ULS log the following errors were noticed:"Unexpected error occurred in method 'GetObject', usage 'Distributed Logon Token Cache'" followed by "The request timed out."From researching this error, the following Blog posts were found:https://newsignature.com/articles/distributed-cache-errors-in-sharepoint-2013/https://blogs.msdn.microsoft.com/sambetts/2014/05/28/troubleshooting-appfabric-timeouts-on-sharepoint/ Resolution Client was advised to review the articles to see if this could be the cause of the issue. Client responded that they fixed the errors in the Distributed Cache by applying latest AppFabric updates and that this resolved the issue. 

Hello,Having lots of problems rendering forms with Show/Hide rules.I have three basic fields - one Single Line textbox for Name, and two date fields for Start and End date.The fields are hidden to start with, and when you select a checkbox, it shows the fields.  However they jump all over the form.  I've checked that the Rules are in the same order as the fields on the form, with no luck.  I've tried putting them in panels with no luck.(Design screen)(No checkboxes selected, fields hidden)(Checkbox selected - fields not rendering correctly)Hope someone knows how to fix this.Regards,Peter

Hi Team,If i run below commands without -site parameter it goes through the entire farm:.NWAdmin.exe -o PurgeWorkflowData -deletedLists -silent.NWAdmin.exe -o PurgeWorkflowData -lastActivityBeforeLocal $SixMonthOld -state "Running" -silentThere are some site collections being locked in our farm. So can you please confirm what will happen if it runs through the locked site collection?Regards,Simran Sachdeva

I have a library workflow running where I have used the 'Pause for' box, it pauses the workflow for 24hrs to allow time for approval etc and works fine.Question is:Will the 'pause' be re-started / cancelled / stop and re-started at the point that it stopped? - or will the whole workflow get cancelled?Thanks in advance for answers.RegardsJohn

Hello All!We had some interesting behavior with one of our workflows regarding holidays.  Our business case is that users are to have 10 business days to complete a task, else the task is terminated.  We had holidays assigned to 12/25, 12/26 and 1/1.  One of our workflows was kicked off such that the 'due date' should have calculated to 1/5 and instead it calculated to 1/2.  I am wondering if having two holidays in a row caused an issue?Thanks,Erin

I need create workflow to export automatic  documents from SharePoint library whe there are create or altering for share folders on server local.

As subject, can i use it? if can, i must to create my database in SmartBox, right? Could you please to explain me how to do? Thanks,Jack

I am trying to use Query Excel Services in a workflow to import an Excel spreadsheet.    If I specify the whole range I need to import, it seems to work great.   But there are problems with this:1.  All cells are imported into one huge collection.  I would need how to figure out how to parse the collection into rows (items).   Not difficult but cumbersome.2.  I don't know how many rows will be in the sheet.  I don't want to have to ask the user for the number of rows.   I want them to simply drop the file into a folder then a scheduled workflow will do the import.What I did was to create a workflow that imports one row at  a time.   I read until I hit a blank row.   A good idea as it solves both issues above. But the problem is the workflow just errors out.   It reads and processes the first row just fine.When it goes to query the next row in excel, I get the error:Error querying Excel Services. We're sorry. We ran into a problem completing your request.Is there a better way to do this

Hello Everyone,we  create  a summary email, it's working fine. when ever we add a group in  "Assignto" column, workflow is not working for assignto column. group  contains users, group members didn't get any emails.  Any one give me the solutions and tips.Thanks,Santhosh,

Hello,Would you please help me to call external web service which provides multiple records?I need to consume web service (Not SharePoint; it's external e.g. http://*******/*******_POC/GetDatafromExternalPOC.asmx) and display the records on Nintex form in table format. Is there any specific setting that has to be done while consuming external web service? Scenario: Need to create Site workflow >> On initiation form records from web service should be displayed (on form load)>> those records will be stored to list (on submit) >> approval process has to be initiated. Thank you in advance. Regards,Santosh