Hi Olivier,
Thanks for uploading this utility, it is very helpful :)
However, sometimes we need to connect to K2 using AAD credentials. Is there some way you can add "Security Label Name" to the Connection String properties in the .config file? So we can connect using different Security Labels?
And would this also affect how we connect to the SQL server? Can we connect to the SQL server through the K2 server for example, so we don't need to run this utility as the K2 Service Account?
Thanks and kind regards,
ChrisW
Hi Olivier, another request, can you please include logging into your utility? A customer recently ran into an issue where the only error message was "Object reference not set to an instance of an object" which is very vague, and some detailed / verbose logging would be helpful in this case. Thanks!
Has anyone tried if this will work with K2Five?
Thanks for taking over this utility, Olivier. Does this now work better with K2 4.7? Has it been tested with K2 Five?
Steve_H, Knudsend
Warning: when I use Process Version Migration on a K2 Five (5.1 FP13), I saw two issues:
- The more important/blocking one: When you add new Task on the workflow, if you try to migrate, the process instance will be stopped you will have error "Error while migrating to new version:Object reference not set to an instance of an object.".
At this state, it's not possible to do the migration to the previous version and we can't remove this instance (same error message): Very dangerous.
The only case where the migration work is when there are no Client event with an action done.
More details:
Issue with K2 Five new workflow designer (FP20 at least).
If we deploy twice the workflow: version 3 and 4 are exactly the same.
Start 2 instances with version 3.
Approve the first instance only to go to Task 2. The second instance is still in first step.
Do the migration of the instances from 3 to 4: only no issue with the second instance (in first step : CODE is always "Task").
Other issue found:
Start 1 instance with version 3.
Approve the first task only to go to Task 2.
Do GoToActivity of the first instance (Version is 3 and current task "First task")
Do the migration of the instances from 3 to 4: Issue: seems to be linked to the first action done.
Test with First task as Timer and SmartObject: no issue. First issue is when we perform a client event (Certainly linked to table aServerLog].LActInstSlot])
No issue with K2 Studio and K2 Five
I opened a ticket with this title "Migration of instance generate a blocking state with "Object reference not set to an instance of an object.". Please contact support team.
- No very important and not blocking: The Datafields seems to be duplicated after each migration of workflow instance in the reports Process Overview/Process instance Detail/Data Audit. In the K2 database the information is not realy duplicated: it's only one data in table iServerLog].rProcInstData] .
I opened ticket with this title: "Migration of K2 workflow generate duplicated datafield in the process overview". Please contact support team.
Best regards,
Olivier
Where is the download link for this version?
Randall,
As it explained in this url:
http://community.k2.com/t5/General-K2-Utilities/K2-Process-Error-Notification-Service-Version-3-K2-PENS/ba-p/65970
The Market Solution files are temporarily unavailable from the Community, while we transition to the new format.
As per this post to the Community News board, you should email one of the Community Administrators, and specify which project you are looking for.
The new Market is under development, and coming soon.
We apologize for the inconvenience.
Thanks, and regards,
Gail
K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
Mahjooob,
Currently the K2 Five issue raised in ticket 152011 is not fixed.
But you can vote to the following idea:
https://ideas.k2.com/ideas/APIT-I-88
Best regards,
Olivier
I believe the object reference error when using process migration if a client event was completed is resolved in FP27:
http://help.k2.com/kb003056
The tool's filtering isn't working for activity and version. e.g. I selected to filter on v11 but v12 shows up. With FP27 I migrated a few dozen then encountered 1 item with this error. A database error occurred : Object reference not set to an instance of an object. Compared ProcId and ExecutingProcID and they were the same. Just needed to Restarted the work item from a stopped state.
Olivier, Is this tool meant for installations with 4.7 to K2 Five so it uses SourceCode.Workflow.Management API's SetProcessInstanceVersion(procInstId, NewVersionNumber) ? Does it work also with fresh K2 Five install? If we wanted to migrate a specific procinstId we can just use the API? It seems K2 did not update SetProcessInstanceVersion API to work properly in: 4.7 processes running in K2 Five? K2 Five processes running in K2 Five? (based on the issues/conditions stated in CheckIfK2fiveVersionIsCompatible())
https://help.k2.com/onlinehelp/k2blackpearl/devref/4.7/default.htm#Live_Instance_Management.html%3FTocPath%3DRuntime%2520APIs%2520and%2520Services%7CWorkflow%7CWorkflow%2520Management%2520API%7CLive%2520Instance%2520Management%2520(LIM)%7C_____0 Anyone tried it on K2 Five 5.3?
Hi Pyao,
I didn't work on this tools since K2 five 5.0. But I can say that this tool (not originally created by me) use the
SetProcessInstanceVersion(procInstId, NewVersionNumber)
Today, according ticket 152011 https://portal.k2.com/support/report/snapshotnew?id=152011 the corresponding TFS is not officialy fixed.
If you want to use this tool, I advise to do a backup of database before because, if the bug is still here, your process instances will be definitively broked.
Best regards,
Olivier
Hi Pyao,
I generated the version 3.0.6: After some tests, the issue of "Object reference not set to an instance of an object." has been fixed with 5.2 FP27 (Reproduced with FP26). We don't have the issue too with 5.3 (No FP).
Thanks to Celine for the test!
Remember: In all cases, this tool is not supported by K2 Support. If you want to use it, we strongly advise to do test on other environment before migration on production.
See details of version 3.0.6 in the main comment in the top of this page.
Best regards,
Olivier
Oliver, on FP27 using 3.0.6, why are some items in the same process getting 24129 A database error occurred : Object reference not set to an instance of an object. Is there more detail to the error?
Hi Olivier,
first of all: thank you for the good work, the tool looks very useful and the new features are a great improvement on the original version.
However, it does not work for us. We get a couple of errors ("Could not retrieve process set ID for selected process", "Error during retrieve of instance: the input string was not in the correct format"). So I was wondering if the source code is available somewhere (as it was for the previous version) so we can debug these errors?
kind regards,
Michael
I thought I saw source code to this tool at one point. I couldn't edit my last comment, but I am still encountering this bug where the instance becomes Stopped. On 5.2 FP27 using 3.0.6, some items in the same process gets 24129 A database error occurred : Object reference not set to an instance of an object. So this tool does not other database updates other than calling the SetProcessInstanceVersion(procInstId, NewVersionNumber) API which in turn calls a K2 stored proc in the database, and it's this K2 stored proc that's buggy?
Michael,
I put the source code attached. Generally the issue "Could not retrieve process set ID for selected process" could appears if the database not correspond to the K2 server (Dev/Production).
Pyao,
What is the context of the error? If you are able to reproduce, I think that the best thing is to open a support ticket base on the use of SetProcessInstanceVersion(procInstId, NewVersionNumber) API. In the Source of this tool, you have a very simple tool "SimpleUseOfSetProcessInstanceVersion" that you can provide as test for labs.
Best regards,
Olivier
Oliver, it failed on SetProcessInstanceVersion. Tried StopProcessInstance first also. I removed the SourceCode DLL (seems for 4.x) that came with the zip and just let it use the one installed by K2 on test server. Exception thrown: 'ClientException' in SourceCode.HostClientAPI.dll Additional information: 24129 A database error occurred : Object reference not set to an instance of an object. Thanks for the source upload, can clean up the files in in and obj folders and delete SourceCode*.dll.
Pyao,
I known that when we try to use the tool on an instance already badly migrated (because migrated before 5.2 FP27) the issue will still here even if you upgrade to 5.2 FP27. Are you in this configuration? Do you reproduce the issue on the new instance (Old version) of the workflow?
If yes, in the Source of this tool, you have a very simple tool "SimpleUseOfSetProcessInstanceVersion" that you can provide as test for labs. Please reproduce the issue on this tool and open a Support Ticket that will be acceptable by labs.
Best regards,
Olivier
Hi Guys,
Has anyone been able to use this on a K2 CLOUD environment?
If so, what did you modify to make it work?
TIA
BradleyFes,
This tools is currently note available for cloud as it need a direct access to the K2 server and a SQL access to the corresponding database.
If it's only the solution that you needed, maybe open a ticket support asking to use this tool to do the migration, but I'm not sure that it will be accepted as support.
You can vote to the following idea:
https://ideas.k2.com/ideas/APIT-I-88
Best regards,
Olivier
3.0.6 has an issue with checking for compatibility if your 5.2 has updated to use the CU. You'll get this error: "Known issue with K2 Five version: Impossible to migrate without error." Current code checks for version.IndexOf("fp"); (version.StartsWith("k2 five (5.2") && fpNb<27) _IsK2FiveVersionWithIssue = true; K2 Five (5.2) May 2019 CU Fixpack 04 K2 Five (5.2) May 2019 Cumulative Update K2 Five (5.2) FP27
Pyao,
I fixed this issue with version 3.0.6.1.
Best regards,
Olivier
Fantastic tool. I am bewildered that I am the first to give it kudos.
Thank you!