Workflows and Automation

Scenario: Upgrading K2 from 5.5 to 5.6 with Fix Pack 5 or later. Existing Oracle service instances fail to refresh, and SmartObjects encounter errors. Specific error message:  10702 An error occurred in the Oracle Service Instance.   System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. Cause: Incompatibility with Oracle 19c, now required for K2 5.6 Fix Pack 5 and beyond. Resolution: Install Oracle Data Access Components (ODAC) 19c: Download:  https://www.oracle.com/database/technologies/net-downloads.html# Extract the downloaded file. Open an elevated command prompt (Run as administrator). Navigate to the extracted directory. Run:  install.bat all c:\oracle myhome true true Install Microsoft Visual C++ 2010 Redistributable Package (both x86 and x64): Download:  https://www.microsoft.com/en-us/download/details.aspx?id=26999 Install both versions. Key Considerations: Cloud Environmen...

If you encounter the following error while adding or updating the K2 for SharePoint app, try these steps: Add the site to your local intranet or trusted zone: This might resolve the issue without further action. If step 1 doesn't work, set the AllowIframeAppAuthorizationPageDomains value using SharePoint PowerShell: Open SharePoint PowerShell. Execute these commands: PowerShell $f = Get-SPFarm $f .AddGenericAllowedListValue( "AllowIframeAppAuthorizePageDomains" , "*.k2test.net" ) $f .update() Once resolved, you should see: Key points: These steps offer alternative solutions before addressing the trust pop-up. The PowerShell commands modify SharePoint settings to potentially fix the error. Replace  *.k2test.net  with the actual domain if it differs.

When you archive reporting data using the stored procedure, you usually provide a start and end date range. This process archives workflow instances that meet these criteria: Workflow status: The instance must have a status of either "Completed" or "Deleted." Finish date: The instance's "FinishDate" must fall within the specified date range. Here's a breakdown of workflow statuses: StatusID 0: Error StatusID 1: Running StatusID 2: Active StatusID 3: Completed (eligible for archiving) StatusID 4: Stopped StatusID 5: Deleted (eligible for archiving) StatusID 6: Terminated Important note about "Deleted" status: If you delete a workflow instance without removing its reporting data, its status becomes "Deleted" and its "FinishDate" is set to the deletion date. This means "Deleted" instances are also eligible for archiving based on their "FinishDate." Archiving process: The archiving procedure moves eligi...

Key Point: Match SharePoint Structure Between Development and Production: To ensure seamless deployment of K2 solutions, maintain identical SharePoint site structures for lists used in the solution across both environments. Scenario: Production Structure: Root Site List A Subsite List B Development Structure (Incorrect): Root Site List A List B Subsite Deployment Issue: Attempting to deploy a package (.kspx) created in the incorrect Development structure to Production will fail to map List B correctly, as the package expects it under the root site, not in a subsite. Solutions: Preventive: Replicate the Production structure in Development precisely. Reactive: Recreate and Remap: Delete and recreate List B SmartObjects in Development to match the Production structure. Move List B in Production: Relocate List B's template and data in Production to align with the Development structure (less ideal due to potential data loss or disruption). Takeaway: Priorit...

 If you wish to register an Oracle service instance, you will need to install 64-bit Oracle Data Access Components (ODAC) 11.2 Release 6 (11.2.0.4.0) on the K2 server 1.  Download this ODAC file from: https://www.oracle.com/database/technologies/odac-downloads.html 2.  Extract 3. Run CMD as Administrator 4. cd to extracted folder 5. You can install all by "install.bat all       c:\oracle myhome" 6. Restart K2 service and retest If on 5.6 FP 5 or later, you may need to install 64-bit Oracle Data Access Components (ODAC) 19c from: https://www.oracle.com/database/technologies/net-downloads.html#