{"id":41215,"date":"2025-10-25T09:11:23","date_gmt":"2025-10-25T07:11:23","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=41215"},"modified":"2025-10-25T09:15:02","modified_gmt":"2025-10-25T07:15:02","slug":"dctm-d2-dar-installation-fails-because-of-workflow-trackers","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/","title":{"rendered":"Dctm – D2-DAR installation fails because of workflow trackers"},"content":{"rendered":"\n

In a Documentum upgrade project from 20.x to 23.4 earlier this year, I faced an issue which prevented the installation\/upgrade of D2. The problem was located inside the D2-DAR while it was trying to update the workflow trackers, which failed because of an ORA-01427<\/em><\/strong> error. The exact error displayed was this one:<\/p>\n\n\n

\n[emc.installer] dmbasic output : [DM_SERVER_E_EXEC_SQL]error:  "The execsql method failed due to a database error: ORA-01427: single-row subquery returns more than one row"\n<\/pre><\/div>\n\n\n
Before that happened, I successfully upgraded 7 or 8 environments from 20.x to 23.4, for that customer, and after that, I did around 20 more. However, this issue only happened once, so not sure what exactly was wrong, and the Application\/Business Teams couldn’t find what really caused the initial issue (inside the DB) either\u2026 In any cases, to start my investigation, I tried to quickly compare the generated logs for the D2-DAR installation on a working vs non-working Repository.<\/p>\n\n\n\n
Working Repository logs:<\/p>\n\n\n
\n###\n## Working repo:\n###\n[dmadmin@cs-0 DARsInternal]$ cat dar-deploy-D2-DAR.dar-REPO1-20250703-133024.log\n[INFO]  ******************************************************\n[INFO]  * Headless Composer\n[INFO]  * Version:        23.4.0000.0120\n[INFO]  * Java version:   17.0.13 (64bit)\n[INFO]  * Java home:      $JAVA_HOME\n[INFO]  * Set storage type: false\n[INFO]  *\n[INFO]  * DAR file:       $DM_HOME\/install\/DARsInternal\/D2-DAR.dar\n[INFO]  * Project name:   D2-DAR\n[INFO]  * Built by Composer: 23.4.0000.0027\n[INFO]  *\n...\n[INFO]  dmbasic output : Finished creating required indexes on D2 types.\n[INFO]  dmbasic output : Copied workflow_id in to d2c_workflow_tracker object\n[INFO]  dmbasic output : Copied process_id in to d2c_workflow_tracker object\n[INFO]  dmbasic output : Copied supervisor_name in to d2c_workflow_tracker object\n[INFO]  dmbasic output : Adding d2_digital_sign_tracker_user user to the group d2_digital_signature_tracker\n[INFO]  dmbasic output : Fetched the group d2_digital_signature_tracker\n[INFO]  dmbasic output : Check for 'Public searches' folder to migrate.\n[INFO]  dmbasic output : Folder '\/Resources\/D2\/[MIGRATE] Public searches' not found. Do not migrate.\n[INFO]  dmbasic output : Disconnected from the server.\n[INFO]  Finished executing post-install script Thu Jul 03 13:32:13 UTC 2025\n[INFO]  Project 'D2-DAR' was successfully installed.\n[dmadmin@cs-0 DARsInternal]$\n<\/pre><\/div>\n\n\n
Non-working Repository logs:<\/p>\n\n\n
\n###\n## Non working repo:\n###\n[dmadmin@cs-0 DARsInternal]$ cat dar-deploy-D2-DAR.dar-REPO2-20250704-144219.log\n[INFO]  ******************************************************\n[INFO]  * Headless Composer\n[INFO]  * Version:        23.4.0000.0120\n[INFO]  * Java version:   17.0.13 (64bit)\n[INFO]  * Java home:      $JAVA_HOME\n[INFO]  * Set storage type: false\n[INFO]  *\n[INFO]  * DAR file:       $DM_HOME\/install\/DARsInternal\/D2-DAR.dar\n[INFO]  * Project name:   D2-DAR\n[INFO]  * Built by Composer: 23.4.0000.0027\n[INFO]  *\n...\n[INFO]  dmbasic output : Finished creating required indexes on D2 types.\n[INFO]  dmbasic output : Copied workflow_id in to d2c_workflow_tracker object\n[INFO]  dmbasic output : [DM_SERVER_E_EXEC_SQL]error:  "The execsql method failed due to a database error: ORA-01427: single-row subquery returns more than one row"\n[INFO]  dmbasic output :\n[INFO]  dmbasic output : [DM_TYPE_MGR_E_INDEX_ALREADY_EXISTS]error:  "The index being created on type d2_recently_used_profile already exists. The existing index is represented by dmi_index object with id 1f012345800005a0."\n[INFO]  dmbasic output :\n[INFO]  dmbasic output : [DM_TYPE_MGR_E_INDEX_ALREADY_EXISTS]error:  "The index being created on type d2_recently_used_profile already exists. The existing index is represented by dmi_index object with id 1f0123458000059f."\n[INFO]  dmbasic output :\n[INFO]  dmbasic output :\n[INFO]  dmbasic output : Exiting with dmExit(-1)\n[ERROR]  Procedure execution failed with dmbasic exit value : 255\n[INFO]  D2-DAR install failed.\n[ERROR]  Unable to install dar file $DM_HOME\/install\/DARsInternal\/D2-DAR.dar\ncom.emc.ide.installer.PostInstallException: Error running post-install procedure "PostInstall". Please contact the procedure owner to verify if it is functioning properly.\n        at internal.com.emc.ide.installer.DarInstaller.postInstall(DarInstaller.java:1574)\n        at internal.com.emc.ide.installer.DarInstaller.doInstall(DarInstaller.java:669)\n        ...\nCaused by: com.emc.ide.external.dfc.procedurerunner.ProcedureRunnerException: Procedure execution failed with dmbasic exit value : 255\n        at com.emc.ide.external.dfc.procedurerunner.ProcedureRunnerUtils.executeDmBasic(ProcedureRunnerUtils.java:285)\n        at com.emc.ide.external.dfc.procedurerunner.ProcedureRunner.execute(ProcedureRunner.java:55)\n        ...\n[ERROR]  Failed to install DAR\nUnable to install dar file $DM_HOME\/install\/DARsInternal\/D2-DAR.dar\n        at com.emc.ant.installer.api.InstallerAntTask.installDar(InstallerAntTask.java:273)\n        at com.emc.ant.installer.api.InstallerAntTask.execute(InstallerAntTask.java:135)\n        ...\nCaused by: com.emc.ide.installer.PostInstallException: Error running post-install procedure "PostInstall". Please contact the procedure owner to verify if it is functioning properly.\n        at internal.com.emc.ide.installer.DarInstaller.postInstall(DarInstaller.java:1574)\n        at internal.com.emc.ide.installer.DarInstaller.doInstall(DarInstaller.java:669)\n        ...\nCaused by: com.emc.ide.external.dfc.procedurerunner.ProcedureRunnerException: Procedure execution failed with dmbasic exit value : 255\n        at com.emc.ide.external.dfc.procedurerunner.ProcedureRunnerUtils.executeDmBasic(ProcedureRunnerUtils.java:285)\n        at com.emc.ide.external.dfc.procedurerunner.ProcedureRunner.execute(ProcedureRunner.java:55)\n        at internal.com.emc.ide.installer.DarInstaller.postInstall(DarInstaller.java:1570)\n        ... 42 more\n<\/pre><\/div>\n\n\n
As often with DAR installation failures, there aren’t a lot of information. It’s clear that the installation failed because there is apparently some wrong data inside the DB (a query that should return only 1 row is giving more results), but there isn’t much more details expect that. By comparing the 2 different logs, you can understand that the issue is located between these 2 lines:<\/p>\n\n\n
\n[INFO]  dmbasic output : Copied workflow_id in to d2c_workflow_tracker object\n[INFO]  dmbasic output : Copied process_id in to d2c_workflow_tracker object\n<\/pre><\/div>\n\n\n
Therefore, finding the root cause is essentially finding what is being done between these 2 lines. A DAR is essentially a zip (Documentum Archive), so you can just extract it and look at its content to see what is being done. In this case (D2 23.4), I could find the necessary source code inside the file named “D2-DAR\/bin\/content\/55\/-1569930955\/runnableContent.crtext<\/em><\/strong>“. Here is an extract of that file:<\/p>\n\n\n
\n    Print "Copied workflow_id in to d2c_workflow_tracker object"\n\n    sQuery = "update d2c_workflow_tracker_s set process_id = " & _\n             "(select child_id from dm_relation_s where dm_relation_s.parent_id = " & _\n             "d2c_workflow_tracker_s.r_object_id and dm_relation_s.relation_name = " & _\n             "'D2_WF_TRACKER_TEMPLATE') where (process_id IS NULL or process_id = '0000000000000000') " & _\n             " and exists (select child_id from dm_relation_s where dm_relation_s.parent_id = " & _\n             "d2c_workflow_tracker_s.r_object_id  and dm_relation_s.relation_name = 'D2_WF_TRACKER_TEMPLATE')"\n\n    bRet = dmAPIExec("execsql," & sess & "," & sQuery)\n\n    if (not bRet) then\n      Call Err_Handle(sess, "0")\n      Print "Exiting with dmExit(-1)"\n      dmExit(-1)\n    end if\n\n    Print "Copied process_id in to d2c_workflow_tracker object"\n<\/pre><\/div>\n\n\n
Therefore, the query that is causing the issue is the one referenced above as “sQuery”, i.e. this one, transformed into plain SQL:<\/p>\n\n\n
\nupdate d2c_workflow_tracker_s \n  set process_id=(select child_id from dm_relation_s \n    where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n      and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE') \n  where (process_id IS NULL or process_id='0000000000000000') \n    and exists (select child_id from dm_relation_s \n      where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n        and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE');\n<\/pre><\/div>\n\n\n
And indeed, executing this query produces the same result:<\/p>\n\n\n
\nSQL> update d2c_workflow_tracker_s \n       set process_id=(select child_id from dm_relation_s \n         where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n           and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE') \n       where (process_id IS NULL or process_id='0000000000000000') \n         and exists (select child_id from dm_relation_s \n           where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n             and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE');\nupdate d2c_workflow_tracker_s set process_id=(select child_id from dm_relation_s where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE') where (process_id IS NULL or process_id='0000000000000000') and exists (select child_id from dm_relation_s where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE')\n                                                *\nERROR at line 1:\nORA-01427: single-row subquery returns more than one row\n<\/pre><\/div>\n\n\n
Unfortunately, because of the way the query is formed (mapping all d2c_workflow_tracker_s.process_id<\/em><\/strong> 1-by-1 from the dm_relation_s.child_id<\/em><\/strong>), you cannot just execute the sub-query (whatever is present between the parenthesis):<\/p>\n\n\n
\nSQL> select child_id from dm_relation_s \n       where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n         and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE';\nselect child_id from dm_relation_s where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE'\n                                                                   *\nERROR at line 1:\nORA-00904: "D2C_WORKFLOW_TRACKER_S"."R_OBJECT_ID": invalid identifier\n<\/pre><\/div>\n\n\n
Even if you “correct” it (by adding the 2nd table name in the “from”), then it will just display something that isn’t directly usable:<\/p>\n\n\n
\nSQL> select child_id from dm_relation_s, d2c_workflow_tracker_s \n       where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n         and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE';\n\nCHILD_ID\n----------------\n4b01234580044d0f\n4b01234580057910\n4b01234580002572\n...\n4b01234580057910\n4b01234580057910\n4b01234580311d91\n\n1406 rows selected.\n<\/pre><\/div>\n\n\n
What to do then? Well, you need to go further. There are 1406<\/strong> rows from the above query (number of dm_process<\/em><\/strong> being tracked or to be more accurate, the number of relations between a Workflow Tracker (parent_id<\/em><\/strong>) and its dm_process<\/em><\/strong> (child_id<\/em><\/strong>)). Assuming that the error is legit, then that would probably mean that there could be less Workflow Trackers than that number. Therefore, after a bit of reflection, I executed the following query to try to find all Workflow Trackers and the count of relations that each and every one of them has. Under normal conditions, each Workflow Tracker should have a single relation (meaning a single dm_process<\/em><\/strong> (1-by-1 mapping)) but that wasn’t the case:<\/p>\n\n\n
\nSQL> select d2c_workflow_tracker_s.r_object_id, count(dm_relation_s.parent_id) \n       from d2c_workflow_tracker_s, dm_relation_s \n       where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n         and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE' \n       group by d2c_workflow_tracker_s.r_object_id \n       order by 2;\n\nR_OBJECT_ID      COUNT(DM_RELATION_S.PARENT_ID)\n---------------- ------------------------------\n09012345800df7eb                              1\n09012345800df7ed                              1\n...\n0901234580313e31                              1\n090123458004fdde                              2\n090123458005cdf5                              2\n090123458005fb44                              2\n\n1403 rows selected.\n<\/pre><\/div>\n\n\n
There are only 1403<\/strong> Workflow Trackers, which means that there are 3 “additional” relations (or 3 dm_process<\/em><\/strong> which are assigned to an already-used Workflow Tracker). To get more details on the Workflow and their Workflow Trackers, these kinds of queries can be executed:<\/p>\n\n\n
\nSQL> select parent_id, child_id from dm_relation_s \n       where parent_id IN ('090123458004fdde','090123458005cdf5','090123458005fb44') \n         and relation_name='D2_WF_TRACKER_TEMPLATE' \n       order by 1, 2;\n\nPARENT_ID        CHILD_ID\n---------------- ----------------\n090123458004fdde 4b01234580002575\n090123458004fdde 4b01234580057910\n090123458005cdf5 4b01234580057910\n090123458005cdf5 4b01234580057910\n090123458005fb44 4b01234580057910\n090123458005fb44 4b01234580057910\n\n\n\nSQL> select r_object_id, object_name, r_creator_name from dm_sysobject_sp \n       where r_object_id IN ('090123458004fdde','090123458005cdf5','090123458005fb44');\n\nR_OBJECT_ID      OBJECT_NAME                                                            R_CREATOR_NAME\n---------------- ---------------------------------------------------------------------- -----------------\n090123458004fdde Start Import Approval October 29, 2021 at 10:34:45 AM UTC              OQSOP01\n090123458005cdf5 Start Ready For Approval November 11, 2021 at 3:55:04 PM UTC           OQAuthor01\n090123458005fb44 Start In Review November 16, 2021 at 12:01:32 PM UTC                   OQSOP01\n\n\n\nSQL> select r_object_id, object_name from dm_sysobject_sp \n       where r_object_id IN ('4b01234580002575','4b01234580057910');\n\nR_OBJECT_ID      OBJECT_NAME\n---------------- ----------------------\n4b01234580002575 WF_Import\n4b01234580057910 WF_Review_Approve\n\n\n\nSQL> select * from dm_relation_sp \n       where parent_id='090123458005cdf5' \n         and relation_name='D2_WF_TRACKER_TEMPLATE';\n\nR_OBJECT_ID      RELATION_NAME                    PARENT_ID        CHILD_ID         CHILD_LABEL                      PERMANENT_LINK   ORDER_NO EFFECTIVE EXPIRATIO DESCRIPTION                 I_PARTITION I_IS_REPLICA   I_VSTAMP\n---------------- -------------------------------- ---------------- ---------------- -------------------------------- -------------- ---------- --------- --------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------ ----------\n370123458000d92a D2_WF_TRACKER_TEMPLATE           090123458005cdf5 4b01234580057910                                               0          0 01-JAN-01 01-JAN-01                               0             0          0\n370123458000cd4f D2_WF_TRACKER_TEMPLATE           090123458005cdf5 4b01234580057910                                               0          0 01-JAN-01 01-JAN-01                               0             0          0\n<\/pre><\/div>\n\n\n
Clearly, there is a Data\/Business problem. Two of the three Workflow Trackers have an exact duplicate relation for the same dm_process<\/em><\/strong> while the third one tracks two different dm_process<\/em><\/strong>, which is even more surprising.<\/p>\n\n\n\n
To be able to proceed, I noted all the IDs and informed the Application\/Business teams and then I did what the SQL command from the D2-DAR was supposed to do. Therefore, I took one of the 2 values and assigned it to the process_id<\/em><\/strong> of the Workflow Tracker:<\/p>\n\n\n
\nSQL> update d2c_workflow_tracker_s \n       set process_id='4b01234580002575' \n       where (process_id IS NULL or process_id='0000000000000000') \n         and r_object_id='090123458004fdde';\n\n1 row updated.\n\n\n\nSQL> update d2c_workflow_tracker_s \n       set process_id='4b01234580057910' \n       where (process_id IS NULL or process_id='0000000000000000') \n         and r_object_id='090123458005fb44';\n\n1 row updated.\n\n\n\nSQL> update d2c_workflow_tracker_s \n       set process_id='4b01234580057910' \n       where (process_id IS NULL or process_id='0000000000000000') \n         and r_object_id='090123458005cdf5';\n\n1 row updated.\n<\/pre><\/div>\n\n\n
After that, I re-triggered the query which was previously failing and this time it worked properly for all the remaining Workflow Trackers:<\/p>\n\n\n
\nSQL> update d2c_workflow_tracker_s \n       set process_id=(select child_id from dm_relation_s \n         where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n           and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE') \n       where (process_id IS NULL or process_id='0000000000000000') \n         and exists (select child_id from dm_relation_s \n           where dm_relation_s.parent_id=d2c_workflow_tracker_s.r_object_id \n             and dm_relation_s.relation_name='D2_WF_TRACKER_TEMPLATE');\n\n1400 rows updated.\n<\/pre><\/div>\n\n\n
I was then able to start the upgrade pipeline from scratch again, and it was able to complete properly. As previously stated, the Application\/Business teams still didn’t find what caused these 3 rows, but it’s only a DEV, so I can only assume that it was some human errors at some points, like a wrong DQL being executed that duplicated some values or something similar. In any cases, what is interesting for this blog is the investigation process and the way to get to the bottom of things by searching inside the D2 DAR and analyzing the DB content.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
In a Documentum upgrade project from 20.x to 23.4 earlier this year, I faced an issue which prevented the installation\/upgrade of D2. The problem was located inside the D2-DAR while it was trying to update the workflow trackers, which failed because of an ORA-01427 error. The exact error displayed was this one: Before that happened, […]<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,525],"tags":[443,907,2609,96,98,3714],"type_dbi":[],"class_list":["post-41215","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-enterprise-content-management","tag-d2","tag-dar","tag-documentum-2","tag-oracle","tag-sql","tag-workflow"],"acf":[],"yoast_head":"\nDctm - D2-DAR installation fails because of workflow trackers - dbi Blog<\/title>\n<meta name=\"description\" content=\"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dctm - D2-DAR installation fails because of workflow trackers\" \/>\n<meta property=\"og:description\" content=\"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-25T07:11:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-25T07:15:02+00:00\" \/>\n<meta name=\"author\" content=\"Morgan Patou\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MorganPatou\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Morgan Patou\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/\"},\"author\":{\"name\":\"Morgan Patou\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4d05b25843a9bc2ab20415dae6bd2d8\"},\"headline\":\"Dctm – D2-DAR installation fails because of workflow trackers\",\"datePublished\":\"2025-10-25T07:11:23+00:00\",\"dateModified\":\"2025-10-25T07:15:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/\"},\"wordCount\":748,\"commentCount\":0,\"keywords\":[\"D2\",\"DAR\",\"Documentum\",\"Oracle\",\"SQL\",\"Workflow\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Enterprise content management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/\",\"name\":\"Dctm - D2-DAR installation fails because of workflow trackers - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2025-10-25T07:11:23+00:00\",\"dateModified\":\"2025-10-25T07:15:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4d05b25843a9bc2ab20415dae6bd2d8\"},\"description\":\"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dctm – D2-DAR installation fails because of workflow trackers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/c4d05b25843a9bc2ab20415dae6bd2d8\",\"name\":\"Morgan Patou\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"caption\":\"Morgan Patou\"},\"description\":\"Morgan Patou has over 12 years of experience in Enterprise Content Management (ECM) systems, with a strong focus in recent years on platforms such as Alfresco, Documentum, and M-Files. He specializes in the architecture, setup, customization, and maintenance of ECM infrastructures in complex & critical environments. Morgan is well-versed in both engineering and operations aspects, including high availability design, system integration, and lifecycle management. He also has a solid foundation in open-source and proprietary technologies - ranging from Apache, OpenLDAP or Kerberos to enterprise-grade systems like WebLogic. Morgan Patou holds an Engineering Degree in Computer Science from ENSISA (\u00c9cole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse, France. He is Alfresco Content Services Certified Administrator (ACSCA), Alfresco Content Services Certified Engineer (ACSCE) as well as OpenText Documentum Certified Administrator. His industry experience spans the Public Sector, IT Services, Financial Services\\\/Banking, and the Pharmaceutical industry.\",\"sameAs\":[\"https:\\\/\\\/blog.dbi-services.com\\\/author\\\/morgan-patou\\\/\",\"https:\\\/\\\/x.com\\\/MorganPatou\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/morgan-patou\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dctm - D2-DAR installation fails because of workflow trackers - dbi Blog","description":"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/","og_locale":"en_US","og_type":"article","og_title":"Dctm - D2-DAR installation fails because of workflow trackers","og_description":"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!","og_url":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/","og_site_name":"dbi Blog","article_published_time":"2025-10-25T07:11:23+00:00","article_modified_time":"2025-10-25T07:15:02+00:00","author":"Morgan Patou","twitter_card":"summary_large_image","twitter_creator":"@MorganPatou","twitter_misc":{"Written by":"Morgan Patou","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/"},"author":{"name":"Morgan Patou","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8"},"headline":"Dctm – D2-DAR installation fails because of workflow trackers","datePublished":"2025-10-25T07:11:23+00:00","dateModified":"2025-10-25T07:15:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/"},"wordCount":748,"commentCount":0,"keywords":["D2","DAR","Documentum","Oracle","SQL","Workflow"],"articleSection":["Database Administration & Monitoring","Enterprise content management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/","url":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/","name":"Dctm - D2-DAR installation fails because of workflow trackers - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-10-25T07:11:23+00:00","dateModified":"2025-10-25T07:15:02+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8"},"description":"Ever faced an issue on D2-DAR workflow trackers or any other updates done by D2 during install? Let's go through the investigation process!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dctm-d2-dar-installation-fails-because-of-workflow-trackers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dctm – D2-DAR installation fails because of workflow trackers"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8","name":"Morgan Patou","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","caption":"Morgan Patou"},"description":"Morgan Patou has over 12 years of experience in Enterprise Content Management (ECM) systems, with a strong focus in recent years on platforms such as Alfresco, Documentum, and M-Files. He specializes in the architecture, setup, customization, and maintenance of ECM infrastructures in complex & critical environments. Morgan is well-versed in both engineering and operations aspects, including high availability design, system integration, and lifecycle management. He also has a solid foundation in open-source and proprietary technologies - ranging from Apache, OpenLDAP or Kerberos to enterprise-grade systems like WebLogic. Morgan Patou holds an Engineering Degree in Computer Science from ENSISA (\u00c9cole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse, France. He is Alfresco Content Services Certified Administrator (ACSCA), Alfresco Content Services Certified Engineer (ACSCE) as well as OpenText Documentum Certified Administrator. His industry experience spans the Public Sector, IT Services, Financial Services\/Banking, and the Pharmaceutical industry.","sameAs":["https:\/\/blog.dbi-services.com\/author\/morgan-patou\/","https:\/\/x.com\/MorganPatou"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/morgan-patou\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=41215"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41215\/revisions"}],"predecessor-version":[{"id":41222,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41215\/revisions\/41222"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=41215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=41215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=41215"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=41215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}