ADx 2.7.228 (31/08/2021) Patch Release Notes
This is a patch release to ADx 2.7. Here's a list of bug fixes (see bellow) and new features:
- AD-2635: For ADx 2.7 the following DB indexes needs to be added on the different schemas (ADx and Conversion). It is expected that from ADx 2.8+ this is done automatically by ADx.
ADx Oracle
CREATE INDEX fk_fkgu39yjngptwggk4dymohh6m5m ON cache_abstractdocument (acl);
CREATE INDEX fk_fkkri09kjy4c9qg8ldb9py9cmt0 ON cache_abstractdocument (securitypolicy);
CREATE INDEX fk_fkafpu40ahi0samvhanolommoy0 ON cache_abstractdocument (sourcerepresentation);
CREATE INDEX fk_fkq6e6m9nkxgulscrlygdnvhd61 ON cache_abstractdocumentattac (attachmentid);
CREATE INDEX fk_fk1xjshsxwomq3puqrhjbuba0uj ON cache_abstractdocumentattac (abstractdocumentid);
CREATE INDEX fk_fkkb1sgb26gx7jr1g14y372y89 ON cache_abstractoperation (description);
CREATE INDEX fk_fkrmxeet3svmt727tu8539335rn ON cache_abstractoperation (name_);
CREATE INDEX fk_fkg1mogb4rurs0xouyiq3afmk9r ON cache_abstractsecuritypolicy (operation_);
CREATE INDEX fk_fk4m7fbn0ncafesuucrud3ue1dr ON cache_abstractsecuritypolicy (selector);
CREATE INDEX fk_fkjobgcfkdb0d60qft4wrkvvbdq ON cache_aclaccessibility (aclid);
CREATE INDEX fk_fkflv2e45y3atj9g8ai1gxpv6s9 ON cache_aclentries (aclentryid);
CREATE INDEX fk_fkbo1r7qn4nmmmtveve6u491dnf ON cache_aclentries (aclid);
CREATE INDEX fk_fk6dgqxyj2gob77d63htt0f0yrt ON cache_adaptiveiconrepres (resourceid);
CREATE INDEX fk_fkkbh1xre8kyrduppsvdn66l6mw ON cache_adaptiveiconrepres (adaptiveiconid);
CREATE INDEX fk_fkma8dxfd3evfk1pcitmgq11y48 ON cache_adxprocesscontextstack (processcontextid);
CREATE INDEX fk_fkqmphoft5hhedb3q3l6a4ox93u ON cache_adxprocesscontextstack (adxprocessid);
CREATE INDEX fk_fk5vh3syuq7m4c446h96djafydo ON cache_ambgcntndemancontindeman (continuationdemandid);
CREATE INDEX fk_fkpc3bpcmevkenom2k84kvkjqw0 ON cache_ambgcntndemancontindeman (ambiguouscontinuationdemandid);
CREATE INDEX fk_fkfc5wemd752q7cuy2bdv6c8a8h ON cache_attachment (acl);
CREATE INDEX fk_fk4qavm5ktovmw5l31qtxvcwvna ON cache_attachment (securitypolicy);
CREATE INDEX fk_fkd6sjx85dl4l9ujlv359x7gd7 ON cache_attachment (commentthreadstatus);
CREATE INDEX fk_fk3orusqnqos56h68q6enft585o ON cache_attachment (assigneduser);
CREATE INDEX fk_fk4jgkjc4sl4mvyah8o265rwcpy ON cache_attachment (document);
CREATE INDEX fk_fk8dbiaec3r033ot2830tign3rx ON cache_attachment (page);
CREATE INDEX fk_fkbcwryo4td63bnc0cln2tbwsed ON cache_cntrepresjobresulcontids (contentrepresentationjobid);
CREATE INDEX fk_fkil9ly6ml57nddvta3uhm7jnux ON cache_commentthreadcomments (commentid);
CREATE INDEX fk_fkinqaodl33w38d6oi5kjo787hj ON cache_commentthreadcomments (commentthreadid);
CREATE INDEX fk_fk8b7mohghmogaglgf1pop4hqlo ON cache_commentthreadstatus (description);
CREATE INDEX fk_fkhw5oa05y15j9o51188p1l5uia ON cache_commentthreadstatus (name_);
CREATE INDEX fk_fk41hxwgly90bgdcoyt3jda7wob ON cache_compounddocumentdocum (abstractdocumentid);
CREATE INDEX fk_fkp5mww3bqtjexhtyvuyw4hie0c ON cache_compounddocumentdocum (compounddocumentid);
CREATE INDEX fk_fkgk7tgwony3a8kboe34ii0qvj1 ON cache_compoundoperationoper (abstractoperationid);
CREATE INDEX fk_fks84reet030wbcepuqvfu6nkwv ON cache_compoundoperationoper (compoundoperationid);
CREATE INDEX fk_fk21avl25h6edjxfn3dg9m6osjm ON cache_compsecurpolicsecurpolic (abstractsecuritypolicyid);
CREATE INDEX fk_fkm0htt1nc0qdn01fc3ac89f58k ON cache_compsecurpolicsecurpolic (compoundsecuritypolicyid);
CREATE INDEX fk_fkp2dcoey3awlx5yinrbg8xxawf ON cache_compstylhighlhighldimen (highlightingdimensionid);
CREATE INDEX fk_fkn7rqq8ho9skk39aqkhwnb45pg ON cache_compstylhighlhighldimen (compoundstyledhighlightingid);
CREATE INDEX fk_fkql0wbmfuwql8l2lfmcwh78a8d ON cache_contrepresjobcontentids (contentrepresentationjobid);
CREATE INDEX fk_fktkyqm3f63x53hq7iksetnucsy ON cache_contrepresjobinputfilen (contentrepresentationjobid);
CREATE INDEX fk_fkki4s4xr0fwvmwrfr2begyl06e ON cache_documcreatjobinputrefer (documentcreationjobid);
CREATE INDEX fk_fkklwf1a8f5555l6xd1ph0887gc ON cache_documcreatjobinputreso (resourceid);
CREATE INDEX fk_fk37n4w2m1u5yt6mu88u6h7hkrx ON cache_documcreatjobinputreso (documentcreationjobid);
CREATE INDEX fk_fkd03oj928lrdrscnx5vcx9c2y0 ON cache_documentcreationjob (document);
CREATE INDEX fk_fkjxvgoalq40d2vt8f1cbymqp1b ON cache_documentcreationjobtags (documentcreationjobid);
CREATE INDEX fk_fkguloixgjllw2ufjnh3ab6o343 ON cache_documentpages (pageid);
CREATE INDEX fk_fkdbd8er36nyfobva83qnn9kccr ON cache_documentpages (documentid);
CREATE INDEX fk_fkfiynt6nj0dhfn5kkyxqa982x ON cache_documentpageselection (document);
CREATE INDEX fk_fkpd4sbfceorttcug1jo6tjyymv ON cache_documentpageselection (user_);
CREATE INDEX fk_fk40bok6gt26u15npv7p4chxq5e ON cache_documentrepresentations (resourceid);
CREATE INDEX fk_fkqjjiey0w5836j5cw6v23l5qn6 ON cache_documentrepresentations (documentid);
CREATE INDEX fk_fk8jtau12wnwu2xkycrpymixymk ON cache_documpageselecselecpages (pageid);
CREATE INDEX fk_fkn1ok7tc317icrt45y2p041muj ON cache_documpageselecselecpages (documentpageselectionid);
CREATE INDEX fk_fkp7xl8hvk1hq6jgxl6wdpcstsj ON cache_emailcontextattachments (resourceid);
CREATE INDEX fk_fk808vl23276nwt1bra4kmq9v9f ON cache_emailcontextattachments (emailcontextid);
CREATE INDEX fk_fkobcrwetp0utuffefuxkvmg11j ON cache_emailcontextbcclist (emailcontextid);
CREATE INDEX fk_fka6w8xgo05btacxakh1gsb5teo ON cache_emailcontextcclist (emailcontextid);
CREATE INDEX fk_fkj9s4l4w4o5qiorvfs074td7xs ON cache_emailcontextinlineattac (resourceid);
CREATE INDEX fk_fknhpw1ju9s3t226qr2g89dqpf3 ON cache_emailcontextinlineattac (emailcontextid);
CREATE INDEX fk_fkgefv7d42khve16pqq4bmrhb9l ON cache_emailcontexttolist (emailcontextid);
CREATE INDEX fk_fkh1y6owj67rbnvfmjofq77ugvc ON cache_emailmetadatabcc (emailmetadataid);
CREATE INDEX fk_fk1p82c42ws69b0u88a6dx4rq08 ON cache_emailmetadatacc (emailmetadataid);
CREATE INDEX fk_fk70lgqyv2epjqusw7pj5dyrh49 ON cache_emailmetadatato (emailmetadataid);
CREATE INDEX fk_fkrm99yht5sq9edpfyni5jk1eal ON cache_group (description);
CREATE INDEX fk_fkd4f0dt5iy3gdx1e6tnjwpqymt ON cache_group (localizedname);
CREATE INDEX fk_fkikspecjj6khyo6cixmcky33ed ON cache_group (picture);
CREATE INDEX fk_fkj0cv2c1pv6wih8a3b6xqa3whg ON cache_grouproles (roleid);
CREATE INDEX fk_fknvv9oruwumqejsj3rhnolnijw ON cache_grouproles (groupid);
CREATE INDEX fk_fkhusos1gvg4febi4trcq3bujxd ON cache_groupusers (userid);
CREATE INDEX fk_fkfb1flvln6dlfcnmtk377bl4kc ON cache_groupusers (groupid);
CREATE INDEX fk_fkopycgaj9j9qupmdqiwxde9yxi ON cache_highlighting (attachment);
CREATE INDEX fk_fk7cs5p9mfbib3elw5j9ndjbyt1 ON cache_highlighting (securitypolicy);
CREATE INDEX fk_fk7qdocl0fghk4i7s8kxptfy8ig ON cache_highlighting (highlightingdimension);
CREATE INDEX fk_fkgr41uy4c0mcmyb0clig05nao6 ON cache_highlighting (highlightingcategory);
CREATE INDEX fk_fkqm9681nvxkd9g8kiiwl85ojgr ON cache_highlightingcategory (displayname);
CREATE INDEX fk_fk7v6guvy1lj9ret7qfbgikjtdp ON cache_highlightingcategory (style_);
CREATE INDEX fk_fkrwsn66sxtlqc0nx3n1uqkstbm ON cache_icon (image);
CREATE INDEX fk_fkct4fyt6usyu62h63ggxa8ofq4 ON cache_localstringlocalvalues (localizedstringid);
CREATE INDEX fk_fko2rouxrdoynspeutm8q42w5fy ON cache_ocrlinewords (ocrwordid);
CREATE INDEX fk_fk1c4mkhgfabkeoj2alt4yu03c2 ON cache_ocrlinewords (ocrlineid);
CREATE INDEX fk_fk2c4a4vprhhaujw5i2dqrbxod6 ON cache_ocrpagelines (ocrlineid);
CREATE INDEX fk_fkol4bwes9w1t7icevnjnh2n222 ON cache_ocrpagelines (ocrpageid);
CREATE INDEX fk_fk1bo8hodx5277e9l4lcaa0y5eb ON cache_ocrpageparagraphs (ocrparagraphid);
CREATE INDEX fk_fk7m990geghh45eweyjpf29jyfr ON cache_ocrpageparagraphs (ocrpageid);
CREATE INDEX fk_fk8mrfe3iga9hltrqkx6q8fu2cq ON cache_ocrpagewords (ocrwordid);
CREATE INDEX fk_fkrx5piuk79m3e7yhds9hickeyh ON cache_ocrpagewords (ocrpageid);
CREATE INDEX fk_fk15w1lpdjjies3g52kbw2nlhjx ON cache_ocrparagraphlines (ocrlineid);
CREATE INDEX fk_fk6raxj1mhqmptbefbd26gh9dni ON cache_ocrparagraphlines (ocrparagraphid);
CREATE INDEX fk_fkci1jxpu8nvf33yismcnuegk3d ON cache_ocrparagraphwords (ocrwordid);
CREATE INDEX fk_fk35sjdvnfoduy48mge2lx7r9w0 ON cache_ocrparagraphwords (ocrparagraphid);
CREATE INDEX fk_fkjf01rln3f6d56q4rbin0sdqji ON cache_page (securitypolicy);
CREATE INDEX fk_fk6rs5c3oartjyuhvp3jk92epcx ON cache_pagehighlightings (highlightingid);
CREATE INDEX fk_fkpg8pvi86begl5q023x5ey6db9 ON cache_pagehighlightings (pageid);
CREATE INDEX fk_fktpl8wjqbmla01blk9pmrnsceb ON cache_pagerepresentations (resourceid);
CREATE INDEX fk_fk44a7hpn52h4ndy6qos8j28rys ON cache_pagerepresentations (pageid);
CREATE INDEX fk_fkh5rre3x5n1pw7pbknwk7fnb8y ON cache_process (trace);
CREATE INDEX fk_fk9go80wthg0cmhf82oj9b5sx24 ON cache_processcontext (resource_);
CREATE INDEX fk_fkgq368cwldiqe1jknh01rhichh ON cache_processrestartcounters (restartcounterid);
CREATE INDEX fk_fkgcobhk7qn13vqy0twfcawumf ON cache_processrestartcounters (processid);
CREATE INDEX fk_fkiasjk0bytpo1uwiyol8et3g9m ON cache_processtrace (details);
CREATE INDEX fk_fkq63y1hcj527p089i8mvd6rfxw ON cache_processtrace (exceptiontrace);
CREATE INDEX fk_fk5a8ku83655mdi3bae8y6810pw ON cache_processtraces (processtraceid);
CREATE INDEX fk_fkcr6imsu6vglw9y6631uhhuef3 ON cache_processtraces (processid);
CREATE INDEX fk_fkq67nv75f88gmj929apgrmejvo ON cache_reposentryreferencesign (signatureid);
CREATE INDEX fk_fko2ro1id8yvp2eb9ru7roqe8n8 ON cache_reposentryreferencesign (repositoryentryreferenceid);
CREATE INDEX fk_fkt8oejxm1ua9mhtl3jpd1ico73 ON cache_reposentryreferencetags (repositoryentryreferenceid);
CREATE INDEX fk_fkkbcvrjg0x90ray7h2lp4ltg0k ON cache_repositoryentryreference (documentmetadataresource);
CREATE INDEX fk_fkcaanyyewyq1o377jdn9wiwhk7 ON cache_repositoryentryreference (metadataresource);
CREATE INDEX fk_fkb6br3rvbdfas69y5xbnt252di ON cache_resource (resourcesource);
CREATE INDEX fk_fk6gqk2embxc2n3166rqj8mahng ON cache_resource (securitypolicy);
CREATE INDEX fk_fkpx07p9smi3wea9m0uujigip6 ON cache_resource (specification);
CREATE INDEX fk_fki82sekqktaed0kwr4si5d66e9 ON cache_resourcesource (template_);
CREATE INDEX fk_fk1ty0ctcxjchtdyu2ftlnu1uqw ON cache_resourcetags (resourceid);
CREATE INDEX fk_fk5d1gm9gw5h9m4pkqq3owi5927 ON cache_role (description);
CREATE INDEX fk_fk111i6xts0nwku7i7b7istbygl ON cache_role (localizedname);
CREATE INDEX fk_fke31icrn3reggljmukod0qpg6h ON cache_servicerequestjobdummy (servicerequestjob);
CREATE INDEX fk_fksxjoe15ois60ivsufclo4tk9b ON cache_servrequestjobresultreso (resourceid);
CREATE INDEX fk_fko9h1dffpbv8bqrshnghk5mrkc ON cache_servrequestjobresultreso (servicerequestjobid);
CREATE INDEX fk_fk3571wxw5n56icx6nt5jatpwor ON cache_servrequjobrequestreso (resourceid);
CREATE INDEX fk_fkbmrfaax8lwaohsa74phueeygr ON cache_servrequjobrequestreso (servicerequestjobid);
CREATE INDEX fk_fk1wws053u2glss1n01pj83kmr1 ON cache_svghighlhighldimensions (highlightingdimensionid);
CREATE INDEX fk_fkhctbp842wnd4vp9s1shoi7bvs ON cache_svghighlhighldimensions (svghighlightingid);
CREATE INDEX fk_fkkepj8qg5j1fotfpnrnnmfocbt ON cache_user (description);
CREATE INDEX fk_fk2g1d99bf7nvnb3c5oa3337oeu ON cache_user (picture);
CREATE INDEX fk_fkovkdl9l3v4pwomfegn8t10luh ON cache_usergroups (groupid);
CREATE INDEX fk_fk56op8bsegsr3eluvus70ff14l ON cache_usergroups (userid);
CREATE INDEX fk_fkn8la71tra4tt7uuf8i4efvf6f ON cache_userroles (roleid);
CREATE INDEX fk_fkfvqvkxljy8p79edbl862iih4h ON cache_userroles (userid);
CREATE INDEX fk_fknh91puusgr09sfednoyivw1vs ON cache_videospecifattacstreams (attachmentstreamid);
CREATE INDEX fk_fk8tafaycilp47tiq6qvo1nd80f ON cache_videospecifattacstreams (videospecificationid);
CREATE INDEX fk_fkr8tovu4qqx7woq4y9k3inbcep ON cache_videospecifaudiostreams (audiostreamid);
CREATE INDEX fk_fkqio10gnsv4w7mgbqfx97804rt ON cache_videospecifaudiostreams (videospecificationid);
CREATE INDEX fk_fkpt9hj6130yslt7r7p14qv2pd4 ON cache_videospecifsubtstreams (subtitlestreamid);
CREATE INDEX fk_fki6bao8ykmifi54sfl0i8yf3q9 ON cache_videospecifsubtstreams (videospecificationid);
CREATE INDEX fk_fk8rbn1duvvg2fn776rnyjyisf ON cache_videospecifvideostreams (videostreamid);
CREATE INDEX fk_fk22ymd9tj9v98m61hjo3jk59ww ON cache_videospecifvideostreams (videospecificationid);
CREATE INDEX fk_fktlanrhbgsk7atj8wsjuufkb ON cache_wopisession (currentresource);
CREATE INDEX fk_fko1on4mff5c3721ttaubxduwk0 ON cache_wopisession (lock_);
CREATE INDEX fk_fkqa8bf78yusm0a8nhf8h0n5v1i ON cache_wopisessionaccesstokens (wopiaccesstokenid);
CREATE INDEX fk_fkoeh1t7johclb2wxynglq8wtiu ON cache_wopisessionaccesstokens (wopisessionid);
CREATE INDEX fk_fk14b9r7bbipys3ql0a65h3inl1 ON cache_wopisessionallowedroles (wopisessionid);
CREATE INDEX fk_fkaq919keyogp8ew450e7hu81g4 ON cache_wopisessionresoversions (resourceid);
CREATE INDEX fk_fk8lgu8vgi221q0in4hvqjumlm0 ON cache_wopisessionresoversions (wopisessionid);
CREATE INDEX fk_fkisltud3k0eoltc8j0vj5c5fns ON cache_wopisessiontags (wopisessionid);
CREATE INDEX fk_fk7sdjje37pb8ade2wu1ovnt88v ON cache_wopisesspostopenresovers (resourceid);
CREATE INDEX fk_fkfjqtrmnevpmxxbqsufpvnnr6h ON cache_wopisesspostopenresovers (wopisessionid);
ADx PostgreSQL
CREATE INDEX fk_fkgu39yjngptwggk4dymohh6m5m_idx ON cache_abstractdocument (acl);
CREATE INDEX fk_fkkri09kjy4c9qg8ldb9py9cmt0_idx ON cache_abstractdocument (securitypolicy);
CREATE INDEX fk_fkafpu40ahi0samvhanolommoy0_idx ON cache_abstractdocument (sourcerepresentation);
CREATE INDEX fk_fkq6e6m9nkxgulscrlygdnvhd61_idx ON cache_abstractdocumentattac (attachmentid);
CREATE INDEX fk_fk1xjshsxwomq3puqrhjbuba0uj_idx ON cache_abstractdocumentattac (abstractdocumentid);
CREATE INDEX fk_fkkb1sgb26gx7jr1g14y372y89_idx ON cache_abstractoperation (description);
CREATE INDEX fk_fkrmxeet3svmt727tu8539335rn_idx ON cache_abstractoperation (name_);
CREATE INDEX fk_fkg1mogb4rurs0xouyiq3afmk9r_idx ON cache_abstractsecuritypolicy (operation_);
CREATE INDEX fk_fk4m7fbn0ncafesuucrud3ue1dr_idx ON cache_abstractsecuritypolicy (selector);
CREATE INDEX fk_fkjobgcfkdb0d60qft4wrkvvbdq_idx ON cache_aclaccessibility (aclid);
CREATE INDEX fk_fkflv2e45y3atj9g8ai1gxpv6s9_idx ON cache_aclentries (aclentryid);
CREATE INDEX fk_fkbo1r7qn4nmmmtveve6u491dnf_idx ON cache_aclentries (aclid);
CREATE INDEX fk_fk6dgqxyj2gob77d63htt0f0yrt_idx ON cache_adaptiveiconrepres (resourceid);
CREATE INDEX fk_fkkbh1xre8kyrduppsvdn66l6mw_idx ON cache_adaptiveiconrepres (adaptiveiconid);
CREATE INDEX fk_fkma8dxfd3evfk1pcitmgq11y48_idx ON cache_adxprocesscontextstack (processcontextid);
CREATE INDEX fk_fkqmphoft5hhedb3q3l6a4ox93u_idx ON cache_adxprocesscontextstack (adxprocessid);
CREATE INDEX fk_fk5vh3syuq7m4c446h96djafydo_idx ON cache_ambgcntndemancontindeman (continuationdemandid);
CREATE INDEX fk_fkpc3bpcmevkenom2k84kvkjqw0_idx ON cache_ambgcntndemancontindeman (ambiguouscontinuationdemandid);
CREATE INDEX fk_fkfc5wemd752q7cuy2bdv6c8a8h_idx ON cache_attachment (acl);
CREATE INDEX fk_fk4qavm5ktovmw5l31qtxvcwvna_idx ON cache_attachment (securitypolicy);
CREATE INDEX fk_fkd6sjx85dl4l9ujlv359x7gd7_idx ON cache_attachment (commentthreadstatus);
CREATE INDEX fk_fk3orusqnqos56h68q6enft585o_idx ON cache_attachment (assigneduser);
CREATE INDEX fk_fk4jgkjc4sl4mvyah8o265rwcpy_idx ON cache_attachment (document);
CREATE INDEX fk_fk8dbiaec3r033ot2830tign3rx_idx ON cache_attachment (page);
CREATE INDEX fk_fkbcwryo4td63bnc0cln2tbwsed_idx ON cache_cntrepresjobresulcontids (contentrepresentationjobid);
CREATE INDEX fk_fkil9ly6ml57nddvta3uhm7jnux_idx ON cache_commentthreadcomments (commentid);
CREATE INDEX fk_fkinqaodl33w38d6oi5kjo787hj_idx ON cache_commentthreadcomments (commentthreadid);
CREATE INDEX fk_fk8b7mohghmogaglgf1pop4hqlo_idx ON cache_commentthreadstatus (description);
CREATE INDEX fk_fkhw5oa05y15j9o51188p1l5uia_idx ON cache_commentthreadstatus (name_);
CREATE INDEX fk_fk41hxwgly90bgdcoyt3jda7wob_idx ON cache_compounddocumentdocum (abstractdocumentid);
CREATE INDEX fk_fkp5mww3bqtjexhtyvuyw4hie0c_idx ON cache_compounddocumentdocum (compounddocumentid);
CREATE INDEX fk_fkgk7tgwony3a8kboe34ii0qvj1_idx ON cache_compoundoperationoper (abstractoperationid);
CREATE INDEX fk_fks84reet030wbcepuqvfu6nkwv_idx ON cache_compoundoperationoper (compoundoperationid);
CREATE INDEX fk_fk21avl25h6edjxfn3dg9m6osjm_idx ON cache_compsecurpolicsecurpolic (abstractsecuritypolicyid);
CREATE INDEX fk_fkm0htt1nc0qdn01fc3ac89f58k_idx ON cache_compsecurpolicsecurpolic (compoundsecuritypolicyid);
CREATE INDEX fk_fkp2dcoey3awlx5yinrbg8xxawf_idx ON cache_compstylhighlhighldimen (highlightingdimensionid);
CREATE INDEX fk_fkn7rqq8ho9skk39aqkhwnb45pg_idx ON cache_compstylhighlhighldimen (compoundstyledhighlightingid);
CREATE INDEX fk_fkql0wbmfuwql8l2lfmcwh78a8d_idx ON cache_contrepresjobcontentids (contentrepresentationjobid);
CREATE INDEX fk_fktkyqm3f63x53hq7iksetnucsy_idx ON cache_contrepresjobinputfilen (contentrepresentationjobid);
CREATE INDEX fk_fkki4s4xr0fwvmwrfr2begyl06e_idx ON cache_documcreatjobinputrefer (documentcreationjobid);
CREATE INDEX fk_fkklwf1a8f5555l6xd1ph0887gc_idx ON cache_documcreatjobinputreso (resourceid);
CREATE INDEX fk_fk37n4w2m1u5yt6mu88u6h7hkrx_idx ON cache_documcreatjobinputreso (documentcreationjobid);
CREATE INDEX fk_fkd03oj928lrdrscnx5vcx9c2y0_idx ON cache_documentcreationjob (document);
CREATE INDEX fk_fkjxvgoalq40d2vt8f1cbymqp1b_idx ON cache_documentcreationjobtags (documentcreationjobid);
CREATE INDEX fk_fkguloixgjllw2ufjnh3ab6o343_idx ON cache_documentpages (pageid);
CREATE INDEX fk_fkdbd8er36nyfobva83qnn9kccr_idx ON cache_documentpages (documentid);
CREATE INDEX fk_fkfiynt6nj0dhfn5kkyxqa982x_idx ON cache_documentpageselection (document);
CREATE INDEX fk_fkpd4sbfceorttcug1jo6tjyymv_idx ON cache_documentpageselection (user_);
CREATE INDEX fk_fk40bok6gt26u15npv7p4chxq5e_idx ON cache_documentrepresentations (resourceid);
CREATE INDEX fk_fkqjjiey0w5836j5cw6v23l5qn6_idx ON cache_documentrepresentations (documentid);
CREATE INDEX fk_fk8jtau12wnwu2xkycrpymixymk_idx ON cache_documpageselecselecpages (pageid);
CREATE INDEX fk_fkn1ok7tc317icrt45y2p041muj_idx ON cache_documpageselecselecpages (documentpageselectionid);
CREATE INDEX fk_fkp7xl8hvk1hq6jgxl6wdpcstsj_idx ON cache_emailcontextattachments (resourceid);
CREATE INDEX fk_fk808vl23276nwt1bra4kmq9v9f_idx ON cache_emailcontextattachments (emailcontextid);
CREATE INDEX fk_fkobcrwetp0utuffefuxkvmg11j_idx ON cache_emailcontextbcclist (emailcontextid);
CREATE INDEX fk_fka6w8xgo05btacxakh1gsb5teo_idx ON cache_emailcontextcclist (emailcontextid);
CREATE INDEX fk_fkj9s4l4w4o5qiorvfs074td7xs_idx ON cache_emailcontextinlineattac (resourceid);
CREATE INDEX fk_fknhpw1ju9s3t226qr2g89dqpf3_idx ON cache_emailcontextinlineattac (emailcontextid);
CREATE INDEX fk_fkgefv7d42khve16pqq4bmrhb9l_idx ON cache_emailcontexttolist (emailcontextid);
CREATE INDEX fk_fkh1y6owj67rbnvfmjofq77ugvc_idx ON cache_emailmetadatabcc (emailmetadataid);
CREATE INDEX fk_fk1p82c42ws69b0u88a6dx4rq08_idx ON cache_emailmetadatacc (emailmetadataid);
CREATE INDEX fk_fk70lgqyv2epjqusw7pj5dyrh49_idx ON cache_emailmetadatato (emailmetadataid);
CREATE INDEX fk_fkrm99yht5sq9edpfyni5jk1eal_idx ON cache_group (description);
CREATE INDEX fk_fkd4f0dt5iy3gdx1e6tnjwpqymt_idx ON cache_group (localizedname);
CREATE INDEX fk_fkikspecjj6khyo6cixmcky33ed_idx ON cache_group (picture);
CREATE INDEX fk_fkj0cv2c1pv6wih8a3b6xqa3whg_idx ON cache_grouproles (roleid);
CREATE INDEX fk_fknvv9oruwumqejsj3rhnolnijw_idx ON cache_grouproles (groupid);
CREATE INDEX fk_fkhusos1gvg4febi4trcq3bujxd_idx ON cache_groupusers (userid);
CREATE INDEX fk_fkfb1flvln6dlfcnmtk377bl4kc_idx ON cache_groupusers (groupid);
CREATE INDEX fk_fkopycgaj9j9qupmdqiwxde9yxi_idx ON cache_highlighting (attachment);
CREATE INDEX fk_fk7cs5p9mfbib3elw5j9ndjbyt1_idx ON cache_highlighting (securitypolicy);
CREATE INDEX fk_fk7qdocl0fghk4i7s8kxptfy8ig_idx ON cache_highlighting (highlightingdimension);
CREATE INDEX fk_fkgr41uy4c0mcmyb0clig05nao6_idx ON cache_highlighting (highlightingcategory);
CREATE INDEX fk_fkqm9681nvxkd9g8kiiwl85ojgr_idx ON cache_highlightingcategory (displayname);
CREATE INDEX fk_fk7v6guvy1lj9ret7qfbgikjtdp_idx ON cache_highlightingcategory (style_);
CREATE INDEX fk_fkrwsn66sxtlqc0nx3n1uqkstbm_idx ON cache_icon (image);
CREATE INDEX fk_fkct4fyt6usyu62h63ggxa8ofq4_idx ON cache_localstringlocalvalues (localizedstringid);
CREATE INDEX fk_fko2rouxrdoynspeutm8q42w5fy_idx ON cache_ocrlinewords (ocrwordid);
CREATE INDEX fk_fk1c4mkhgfabkeoj2alt4yu03c2_idx ON cache_ocrlinewords (ocrlineid);
CREATE INDEX fk_fk2c4a4vprhhaujw5i2dqrbxod6_idx ON cache_ocrpagelines (ocrlineid);
CREATE INDEX fk_fkol4bwes9w1t7icevnjnh2n222_idx ON cache_ocrpagelines (ocrpageid);
CREATE INDEX fk_fk1bo8hodx5277e9l4lcaa0y5eb_idx ON cache_ocrpageparagraphs (ocrparagraphid);
CREATE INDEX fk_fk7m990geghh45eweyjpf29jyfr_idx ON cache_ocrpageparagraphs (ocrpageid);
CREATE INDEX fk_fk8mrfe3iga9hltrqkx6q8fu2cq_idx ON cache_ocrpagewords (ocrwordid);
CREATE INDEX fk_fkrx5piuk79m3e7yhds9hickeyh_idx ON cache_ocrpagewords (ocrpageid);
CREATE INDEX fk_fk15w1lpdjjies3g52kbw2nlhjx_idx ON cache_ocrparagraphlines (ocrlineid);
CREATE INDEX fk_fk6raxj1mhqmptbefbd26gh9dni_idx ON cache_ocrparagraphlines (ocrparagraphid);
CREATE INDEX fk_fkci1jxpu8nvf33yismcnuegk3d_idx ON cache_ocrparagraphwords (ocrwordid);
CREATE INDEX fk_fk35sjdvnfoduy48mge2lx7r9w0_idx ON cache_ocrparagraphwords (ocrparagraphid);
CREATE INDEX fk_fkjf01rln3f6d56q4rbin0sdqji_idx ON cache_page (securitypolicy);
CREATE INDEX fk_fk6rs5c3oartjyuhvp3jk92epcx_idx ON cache_pagehighlightings (highlightingid);
CREATE INDEX fk_fkpg8pvi86begl5q023x5ey6db9_idx ON cache_pagehighlightings (pageid);
CREATE INDEX fk_fktpl8wjqbmla01blk9pmrnsceb_idx ON cache_pagerepresentations (resourceid);
CREATE INDEX fk_fk44a7hpn52h4ndy6qos8j28rys_idx ON cache_pagerepresentations (pageid);
CREATE INDEX fk_fkh5rre3x5n1pw7pbknwk7fnb8y_idx ON cache_process (trace);
CREATE INDEX fk_fk9go80wthg0cmhf82oj9b5sx24_idx ON cache_processcontext (resource_);
CREATE INDEX fk_fkgq368cwldiqe1jknh01rhichh_idx ON cache_processrestartcounters (restartcounterid);
CREATE INDEX fk_fkgcobhk7qn13vqy0twfcawumf_idx ON cache_processrestartcounters (processid);
CREATE INDEX fk_fkiasjk0bytpo1uwiyol8et3g9m_idx ON cache_processtrace (details);
CREATE INDEX fk_fkq63y1hcj527p089i8mvd6rfxw_idx ON cache_processtrace (exceptiontrace);
CREATE INDEX fk_fk5a8ku83655mdi3bae8y6810pw_idx ON cache_processtraces (processtraceid);
CREATE INDEX fk_fkcr6imsu6vglw9y6631uhhuef3_idx ON cache_processtraces (processid);
CREATE INDEX fk_fkq67nv75f88gmj929apgrmejvo_idx ON cache_reposentryreferencesign (signatureid);
CREATE INDEX fk_fko2ro1id8yvp2eb9ru7roqe8n8_idx ON cache_reposentryreferencesign (repositoryentryreferenceid);
CREATE INDEX fk_fkt8oejxm1ua9mhtl3jpd1ico73_idx ON cache_reposentryreferencetags (repositoryentryreferenceid);
CREATE INDEX fk_fkkbcvrjg0x90ray7h2lp4ltg0k_idx ON cache_repositoryentryreference (documentmetadataresource);
CREATE INDEX fk_fkcaanyyewyq1o377jdn9wiwhk7_idx ON cache_repositoryentryreference (metadataresource);
CREATE INDEX fk_fkb6br3rvbdfas69y5xbnt252di_idx ON cache_resource (resourcesource);
CREATE INDEX fk_fk6gqk2embxc2n3166rqj8mahng_idx ON cache_resource (securitypolicy);
CREATE INDEX fk_fkpx07p9smi3wea9m0uujigip6_idx ON cache_resource (specification);
CREATE INDEX fk_fki82sekqktaed0kwr4si5d66e9_idx ON cache_resourcesource (template_);
CREATE INDEX fk_fk1ty0ctcxjchtdyu2ftlnu1uqw_idx ON cache_resourcetags (resourceid);
CREATE INDEX fk_fk5d1gm9gw5h9m4pkqq3owi5927_idx ON cache_role (description);
CREATE INDEX fk_fk111i6xts0nwku7i7b7istbygl_idx ON cache_role (localizedname);
CREATE INDEX fk_fke31icrn3reggljmukod0qpg6h_idx ON cache_servicerequestjobdummy (servicerequestjob);
CREATE INDEX fk_fksxjoe15ois60ivsufclo4tk9b_idx ON cache_servrequestjobresultreso (resourceid);
CREATE INDEX fk_fko9h1dffpbv8bqrshnghk5mrkc_idx ON cache_servrequestjobresultreso (servicerequestjobid);
CREATE INDEX fk_fk3571wxw5n56icx6nt5jatpwor_idx ON cache_servrequjobrequestreso (resourceid);
CREATE INDEX fk_fkbmrfaax8lwaohsa74phueeygr_idx ON cache_servrequjobrequestreso (servicerequestjobid);
CREATE INDEX fk_fk1wws053u2glss1n01pj83kmr1_idx ON cache_svghighlhighldimensions (highlightingdimensionid);
CREATE INDEX fk_fkhctbp842wnd4vp9s1shoi7bvs_idx ON cache_svghighlhighldimensions (svghighlightingid);
CREATE INDEX fk_fkkepj8qg5j1fotfpnrnnmfocbt_idx ON cache_user (description);
CREATE INDEX fk_fk2g1d99bf7nvnb3c5oa3337oeu_idx ON cache_user (picture);
CREATE INDEX fk_fkovkdl9l3v4pwomfegn8t10luh_idx ON cache_usergroups (groupid);
CREATE INDEX fk_fk56op8bsegsr3eluvus70ff14l_idx ON cache_usergroups (userid);
CREATE INDEX fk_fkn8la71tra4tt7uuf8i4efvf6f_idx ON cache_userroles (roleid);
CREATE INDEX fk_fkfvqvkxljy8p79edbl862iih4h_idx ON cache_userroles (userid);
CREATE INDEX fk_fknh91puusgr09sfednoyivw1vs_idx ON cache_videospecifattacstreams (attachmentstreamid);
CREATE INDEX fk_fk8tafaycilp47tiq6qvo1nd80f_idx ON cache_videospecifattacstreams (videospecificationid);
CREATE INDEX fk_fkr8tovu4qqx7woq4y9k3inbcep_idx ON cache_videospecifaudiostreams (audiostreamid);
CREATE INDEX fk_fkqio10gnsv4w7mgbqfx97804rt_idx ON cache_videospecifaudiostreams (videospecificationid);
CREATE INDEX fk_fkpt9hj6130yslt7r7p14qv2pd4_idx ON cache_videospecifsubtstreams (subtitlestreamid);
CREATE INDEX fk_fki6bao8ykmifi54sfl0i8yf3q9_idx ON cache_videospecifsubtstreams (videospecificationid);
CREATE INDEX fk_fk8rbn1duvvg2fn776rnyjyisf_idx ON cache_videospecifvideostreams (videostreamid);
CREATE INDEX fk_fk22ymd9tj9v98m61hjo3jk59ww_idx ON cache_videospecifvideostreams (videospecificationid);
CREATE INDEX fk_fktlanrhbgsk7atj8wsjuufkb_idx ON cache_wopisession (currentresource);
CREATE INDEX fk_fko1on4mff5c3721ttaubxduwk0_idx ON cache_wopisession (lock_);
CREATE INDEX fk_fkqa8bf78yusm0a8nhf8h0n5v1i_idx ON cache_wopisessionaccesstokens (wopiaccesstokenid);
CREATE INDEX fk_fkoeh1t7johclb2wxynglq8wtiu_idx ON cache_wopisessionaccesstokens (wopisessionid);
CREATE INDEX fk_fk14b9r7bbipys3ql0a65h3inl1_idx ON cache_wopisessionallowedroles (wopisessionid);
CREATE INDEX fk_fkaq919keyogp8ew450e7hu81g4_idx ON cache_wopisessionresoversions (resourceid);
CREATE INDEX fk_fk8lgu8vgi221q0in4hvqjumlm0_idx ON cache_wopisessionresoversions (wopisessionid);
CREATE INDEX fk_fkisltud3k0eoltc8j0vj5c5fns_idx ON cache_wopisessiontags (wopisessionid);
CREATE INDEX fk_fk7sdjje37pb8ade2wu1ovnt88v_idx ON cache_wopisesspostopenresovers (resourceid);
CREATE INDEX fk_fkfjqtrmnevpmxxbqsufpvnnr6h_idx ON cache_wopisesspostopenresovers (wopisessionid);
Conversion Oracle
CREATE INDEX IDX_CONVJOB_TRIES on CONV_ConversionJob(tries);
CREATE INDEX IDX_CONVJOB_STATE on CONV_ConversionJob(state_);
CREATE INDEX IDX_CONVJOB_CONVJTYPE ON CONV_ConversionJob(conversionjobtype);
CREATE INDEX IDX_CONVJOB_WID_STATE ON CONV_ConversionJob(workerId, state_);
CREATE INDEX fk_fks2fx9d7erjx1toanlkcjl2ji ON conv_abstractdocument(acl);
CREATE INDEX fk_fk1tt5yhheuuidf6vpsrcrlbegr ON conv_abstractdocument(securitypolicy);
CREATE INDEX fk_fk8cc7fyjq0hl4wy9y2soqhe490 ON conv_abstractdocument(sourcerepresentation);
CREATE INDEX fk_fksxwjagekp66fxgi3u4cm7nyv3 ON conv_abstractdocumentattac(attachmentid);
CREATE INDEX fk_fk6n8cr2e7tvoitre0vdj8m580i ON conv_abstractdocumentattac(abstractdocumentid);
CREATE INDEX fk_fkh3963xdlnp49fyb7unccc8nx ON conv_abstractdocumentrepres(resourceid);
CREATE INDEX fk_fkeoc55vwh8neuccej2a8rrljua ON conv_abstractdocumentrepres(abstractdocumentid);
CREATE INDEX fk_fkguh95droxnlo6ptgcnmdhyq0j ON conv_abstractoperation(description);
CREATE INDEX fk_fkjoen4kgrplj4mqgigic56hqmc ON conv_abstractoperation(name_);
CREATE INDEX fk_fklg80m5gntqxpfayyvarn5q5qu ON conv_abstractsecuritypolicy(operation_);
CREATE INDEX fk_fkqk0o5k8c0njlwbwacqtyen6oi ON conv_abstractsecuritypolicy(selector);
CREATE INDEX fk_fkdfio6556s3p4rqgqt41rm6t9i ON conv_aclaccessibility(aclid);
CREATE INDEX fk_fk5dcxkd8fdkmhodhfh7km3sx89 ON conv_aclentries(aclentryid);
CREATE INDEX fk_fklmm9ryghrmoiyp7m8d3la7jwg ON conv_aclentries(aclid);
CREATE INDEX fk_fki8tyegvc0rqcor0mjiba5wjrc ON conv_adaptiveiconrepres(resourceid);
CREATE INDEX fk_fk20atdkmeehu6ll47th65shxtn ON conv_adaptiveiconrepres(adaptiveiconid);
CREATE INDEX fk_fkfh1tjs0p84cyxoyv692218emd ON conv_anythingtopdfjobjoblist(conversionjobid);
CREATE INDEX fk_fk2ifbjncxac1mk8jwwk0qrjx4x ON conv_anythingtopdfjobjoblist(anythingtopdfjobid);
CREATE INDEX fk_fk3yk56embk94m98ojs7vtbkdpn ON conv_attachment(acl);
CREATE INDEX fk_fkcwu97b0a2ocj82cvxsd55tkga ON conv_attachment(securitypolicy);
CREATE INDEX fk_fkqb0a6fmbeyhoybe5oly76qlkl ON conv_attachment(page);
CREATE INDEX fk_fkoa1nfb4pay4k1jes98jhv2v0h ON conv_attachment(document);
CREATE INDEX fk_fki74eakrxk33nlw985ukk9hib5 ON conv_attachment(commentthreadstatus);
CREATE INDEX fk_fksner82lfd2nwi446nxh19fcrt ON conv_attachment(assigneduser);
CREATE INDEX fk_fk6un7m8pbuwrwu34y9n7k90ag3 ON conv_combinedjobjoblist(conversionjobid);
CREATE INDEX fk_fkreq3q2wk9ekkgmjp6yn9ax4sw ON conv_combinedjobjoblist(combinedjobid);
CREATE INDEX fk_fknkkftv2vt2bqgxd7v9u50vrfc ON conv_commentthreadcomments(commentid);
CREATE INDEX fk_fk7p1fpvvhbkx4h7chvpxj734pd ON conv_commentthreadcomments(commentthreadid);
CREATE INDEX fk_fk7xyke3g8fftionkyoqda8mgg4 ON conv_commentthreadstatus(description);
CREATE INDEX fk_fk1siyem1vw5wq5mmdf9d7q2ig6 ON conv_commentthreadstatus(name_);
CREATE INDEX fk_fkt5t96x9oge4gjdtt5tfeuimns ON conv_compounddocumentdocuments(abstractdocumentid);
CREATE INDEX fk_fk5ni05rrh3l46568y98bwypr3v ON conv_compounddocumentdocuments(compounddocumentid);
CREATE INDEX fk_fk6kfj8ruenqhggyna1ve9hl96q ON conv_compoundoperationoper(abstractoperationid);
CREATE INDEX fk_fkoi0sear33a3xriywfrwwb3f2p ON conv_compoundoperationoper(compoundoperationid);
CREATE INDEX fk_fkcvbhcu714iv5v23w7nbdro2y2 ON conv_compsecurpolicysecurpolic(abstractsecuritypolicyid);
CREATE INDEX fk_fkb561oy4yjo61dqmt55y1me908 ON conv_compsecurpolicysecurpolic(compoundsecuritypolicyid);
CREATE INDEX fk_fkg0k82mr0si65i563oouopvn66 ON conv_compstyledhighlhighldimen(highlightingdimensionid);
CREATE INDEX fk_fksf6d8m8scm6p68oxb3dt4ixbc ON conv_compstyledhighlhighldimen(compoundstyledhighlightingid);
CREATE INDEX fk_fk3sytt3vsp1oluc11e4u5giipy ON conv_conversionjob(generaltemplatereplacements);
CREATE INDEX fk_fkslsqtu44y4snyk4y857df8y6y ON conv_conversionjobtags(conversionjobid);
CREATE INDEX fk_fksc0lljo8njht1i7lyqqwdfwnn ON conv_convjobinputreferences(conversionjobid);
CREATE INDEX fk_fkey370pih90edsn653k9wmt49v ON conv_convjobinputresources(resourceid);
CREATE INDEX fk_fklgvnildh0utypcrs205eebrkr ON conv_convjobinputresources(conversionjobid);
CREATE INDEX fk_fk6ts7u4ft53e2ca2ip9lj94whi ON conv_convjoboutputresources(resourceid);
CREATE INDEX fk_fka4me2ib0di0ikbu6ixqn2i6a7 ON conv_convjoboutputresources(conversionjobid);
CREATE INDEX fk_fkqidquwhpragybsjq675lsnvkh ON conv_createdocumentjobjoblist(conversionjobid);
CREATE INDEX fk_fkcdxqswxijudpuv5908chdn3ij ON conv_createdocumentjobjoblist(createdocumentjobid);
CREATE INDEX fk_fknibiiq15jk2b40j1vlvx481df ON conv_documentpages(pageid);
CREATE INDEX fk_fk76ujy6s9k42sc0fyd9xnnqddu ON conv_documentpages(documentid);
CREATE INDEX fk_fkm28oi5cdkxpxu4owulww1xbv2 ON conv_documentpageselection(document);
CREATE INDEX fk_fkpmg6j57bw9ritx9ciwco0sx88 ON conv_documentpageselection(user_);
CREATE INDEX fk_fkf512hr7kwr2d0ydg3jmq85d7r ON conv_documpageselecselecpages(pageid);
CREATE INDEX fk_fk5it9dgb55r8n560ike6h65kkv ON conv_documpageselecselecpages(documentpageselectionid);
CREATE INDEX fk_fknahwxw4ui5ye8kmit4q6kxg4v ON conv_emailmetadatabcc(emailmetadataid);
CREATE INDEX fk_fk9vx4va0m7tijnnvcaqkef2kbe ON conv_emailmetadatacc(emailmetadataid);
CREATE INDEX fk_fks3951l458rofgpis1xm8vrf0e ON conv_emailmetadatato(emailmetadataid);
CREATE INDEX fk_fkkfk9txm4iu17mfmwdj4b978r9 ON conv_emailtopdfjobjoblist(conversionjobid);
CREATE INDEX fk_fkijmdo2hporacovkuowlcs46ke ON conv_emailtopdfjobjoblist(emailtopdfjobid);
CREATE INDEX fk_fk7d8b2kx3gcr455d21aarqsoiq ON conv_extracttextjobjoblist(conversionjobid);
CREATE INDEX fk_fksw2o2edfxeeubc97ntt32sikr ON conv_extracttextjobjoblist(extracttextjobid);
CREATE INDEX fk_fk7844lhf3u47tdaylq3sntst9m ON conv_group(description);
CREATE INDEX fk_fk80bl6f5lvvra0fldqbjsfk5kl ON conv_group(localizedname);
CREATE INDEX fk_fkqxk11b19jr8mg0fug988r2ei ON conv_group(picture);
CREATE INDEX fk_fkl0dyye89cna799un1763vy0h6 ON conv_grouproles(roleid);
CREATE INDEX fk_fknxri93c5dxioc7fisf6wjs4gp ON conv_grouproles(groupid);
CREATE INDEX fk_fk3d2ora9kifcyejryeajh5035t ON conv_groupusers(userid);
CREATE INDEX fk_fkt6edlvdr0cxl9lxa8bvr6bfmn ON conv_groupusers(groupid);
CREATE INDEX fk_fkaso22rhwr961f7m57pbvn4rs9 ON conv_highlighting(attachment);
CREATE INDEX fk_fkbc0m4jr8puh4dvhcnc2dejyjx ON conv_highlighting(securitypolicy);
CREATE INDEX fk_fkphe6ar8hkmn3xmoao0n40ita3 ON conv_highlighting(highlightingdimension);
CREATE INDEX fk_fkcp6k40l5o4p6jtihycjdbvgd1 ON conv_highlighting(highlightingcategory);
CREATE INDEX fk_fkmh28609r9914b13w4lejud53 ON conv_highlightingcategory(displayname);
CREATE INDEX fk_fkmixbrugrjy0f7bc91ewtfg8is ON conv_highlightingcategory(style_);
CREATE INDEX fk_fk6bbm8npvdfaj4u2mr5vcx8p0k ON conv_icon(image);
CREATE INDEX fk_fkpr8moqtw0enl6urajy78hd1ut ON conv_localstringlocalvalues(localizedstringid);
CREATE INDEX fk_fk5jjhgmvug8t52og2cd3ythalq ON conv_ocrlinewords(ocrwordid);
CREATE INDEX fk_fk9mqjfwjivvp14btpy8bpq18o8 ON conv_ocrlinewords(ocrlineid);
CREATE INDEX fk_fkjieda6glrr8eyml43v0ocwln9 ON conv_ocrpagelines(ocrlineid);
CREATE INDEX fk_fktjrlhmv6wq7w7uvuoa2brlced ON conv_ocrpagelines(ocrpageid);
CREATE INDEX fk_fk62cskumlxub49quwf892b87u3 ON conv_ocrpageparagraphs(ocrparagraphid);
CREATE INDEX fk_fk5kyylrpsuqytcrkbn6y1xtl4a ON conv_ocrpageparagraphs(ocrpageid);
CREATE INDEX fk_fk2w5rdbt2x2mykkul7is9e2g9w ON conv_ocrpagewords(ocrwordid);
CREATE INDEX fk_fke6amlj8vdjm83d9eu24y2al7w ON conv_ocrpagewords(ocrpageid);
CREATE INDEX fk_fk9pborvcgy99j7l5okgjcgm4xs ON conv_ocrparagraphlines(ocrlineid);
CREATE INDEX fk_fkgrmm83mdekm3sik2qdnl1ewm7 ON conv_ocrparagraphlines(ocrparagraphid);
CREATE INDEX fk_fkpfch8l2r28tpliry3xx7tuaur ON conv_ocrparagraphwords(ocrwordid);
CREATE INDEX fk_fk7ywjqtcyt9kq9qonfleony0j5 ON conv_ocrparagraphwords(ocrparagraphid);
CREATE INDEX fk_fkijaq7y6y1f3m2d9nr7ksw0qgv ON conv_page(securitypolicy);
CREATE INDEX fk_fkg6qnrltikeaqw4vpecnoyu9kt ON conv_pagehighlightings(highlightingid);
CREATE INDEX fk_fk265nd8rktueukq18wdvr5poxx ON conv_pagehighlightings(pageid);
CREATE INDEX fk_fkeoortm5holbvdn3j6u2ih5dfq ON conv_pagerepresentations(resourceid);
CREATE INDEX fk_fkayqhehy48hhlslp3ilwuptwhh ON conv_pagerepresentations(pageid);
CREATE INDEX fk_fkx1k8yt7ciqlrrsfa1elr7xnk ON conv_resource(resourcesource);
CREATE INDEX fk_fk3y248omvbn1cmxp9vx8wjtj4j ON conv_resource(securitypolicy);
CREATE INDEX fk_fkso2uldbaie3j48yk1d8ly9w1j ON conv_resource(specification);
CREATE INDEX fk_fksun68jl110sd39sksbrboxame ON conv_resourcesource(template_);
CREATE INDEX fk_fk6ib2c390h8ekeaj3qfrsy8lls ON conv_resourcetags(resourceid);
CREATE INDEX fk_fkstlsw85457gq4qfnn2h7n5epn ON conv_role(description);
CREATE INDEX fk_fka323ja1j8it0k0xny3rm7717d ON conv_role(localizedname);
CREATE INDEX fk_fks2tudu054s46itlhyr8e2tlpm ON conv_servrequestjobrequestreso(resourceid);
CREATE INDEX fk_fkg3oc6491l95f7k2rsw6tsxt42 ON conv_servrequestjobrequestreso(servicerequestjobid);
CREATE INDEX fk_fkmu54i07vhkouubsxmcvin5fns ON conv_servrequestjobresultreso(resourceid);
CREATE INDEX fk_fkg37y7k0n7p8v3q1e4e27vau72 ON conv_servrequestjobresultreso(servicerequestjobid);
CREATE INDEX fk_fkpi8o714utcycpu2bbnqmivqtn ON conv_svghighlhighldimensions(highlightingdimensionid);
CREATE INDEX fk_fk56bafcpbxbfswoj2bx1c77g9r ON conv_svghighlhighldimensions(svghighlightingid);
CREATE INDEX fk_fk25hp7whkxymn915xcb9yec9ti ON conv_templatereplacfieldvalues(templatereplacementsid);
CREATE INDEX fk_fka0qvrpioevwdgx3uix2q9q21a ON conv_txttmplttxtjbtmplrplcprtg(templatereplacementsid);
CREATE INDEX fk_fk5ldqcnwoihexrfmsnhe5finc4 ON conv_txttmplttxtjbtmplrplcprtg(texttemplatetotextjobid);
CREATE INDEX fk_fkf4dli2l7n5t0sigx7buljc1w3 ON conv_user(description);
CREATE INDEX fk_fkh82bx5qc74jtm758k6p251isq ON conv_user(picture);
CREATE INDEX fk_fkbd8gvd94lev73w8hh67wpjbtc ON conv_usergroups(groupid);
CREATE INDEX fk_fkeoow8igh6ga6ic03aux5oeb6e ON conv_usergroups(userid);
CREATE INDEX fk_fkks4ciw5god79p5kl6kboe7q0t ON conv_userroles(roleid);
CREATE INDEX fk_fkn6ej9of8uddx00x8qvp2e86a2 ON conv_userroles(userid);
CREATE INDEX fk_fkrhikihhepnaaws6s88pk48dlv ON conv_videospecifattacstreams(attachmentstreamid);
CREATE INDEX fk_fkq77oqr46p4ejms1xk5jhcacku ON conv_videospecifattacstreams(videospecificationid);
CREATE INDEX fk_fkedqxc18jswvs90wlv9bqwab0j ON conv_videospecifaudiostreams(audiostreamid);
CREATE INDEX fk_fkhbjoifgfnwk2v6dj583p8lenv ON conv_videospecifaudiostreams(videospecificationid);
CREATE INDEX fk_fkroem7vaetruqavhhc02imsc19 ON conv_videospecifsubtstreams(subtitlestreamid);
CREATE INDEX fk_fksx7a9wju30s9kjb8oiq57cx8h ON conv_videospecifsubtstreams(videospecificationid);
CREATE INDEX fk_fkcyx7d3vh67cih6ylhtlff8ip9 ON conv_videospecifvideostreams(videostreamid);
CREATE INDEX fk_fkbbygd30fi9l2h64v9r9x887in ON conv_videospecifvideostreams(videospecificationid);
CREATE INDEX fk_fkpo12vkboy0rkf2njc6xdl3ife ON conv_videotoimagjobframemicros(videotoimagesjobid);
CREATE INDEX fk_fk9r9fbgobgmd5t9u0uw2h4qpcn ON conv_wrdtemplreplacregexreplac(wordtemplatereplacementsid);
CREATE INDEX fk_fksdg4w7il4hxxjyxmhrw0s6sjj ON conv_wrdtemplreplacstrinreplac(wordtemplatereplacementsid);
CREATE INDEX fk_fkg0cmvftud8h4g8ei4413k5fa1 ON conv_wrdtmpltwrdjbtmplrplcprtg(wordtemplatereplacementsid);
CREATE INDEX fk_fk6yhuw39vaagjp617twlqby2mx ON conv_wrdtmpltwrdjbtmplrplcprtg(wordtemplatetowordjobid);
Conversion PostgreSQL
CREATE INDEX IDX_CONVJOB_TRIES on CONV_ConversionJob(tries);
CREATE INDEX IDX_CONVJOB_STATE on CONV_ConversionJob(state_);
CREATE INDEX IDX_CONVJOB_CONVJTYPE ON CONV_ConversionJob(conversionjobtype);
CREATE INDEX IDX_CONVJOB_WID_STATE ON CONV_ConversionJob(workerId, state_);
CREATE INDEX IDX_ABSTDOC_SRCREP ON conv_abstractdocument(sourcerepresentation);
CREATE INDEX IDX_PAGEREPR_RESID ON conv_pagerepresentations(resourceid);
CREATE INDEX fk_fks2fx9d7erjx1toanlkcjl2ji_idx ON conv_abstractdocument(acl);
CREATE INDEX fk_fk1tt5yhheuuidf6vpsrcrlbegr_idx ON conv_abstractdocument(securitypolicy);
CREATE INDEX fk_fk8cc7fyjq0hl4wy9y2soqhe490_idx ON conv_abstractdocument(sourcerepresentation);
CREATE INDEX fk_fksxwjagekp66fxgi3u4cm7nyv3_idx ON conv_abstractdocumentattac(attachmentid);
CREATE INDEX fk_fk6n8cr2e7tvoitre0vdj8m580i_idx ON conv_abstractdocumentattac(abstractdocumentid);
CREATE INDEX fk_fkh3963xdlnp49fyb7unccc8nx_idx ON conv_abstractdocumentrepres(resourceid);
CREATE INDEX fk_fkeoc55vwh8neuccej2a8rrljua_idx ON conv_abstractdocumentrepres(abstractdocumentid);
CREATE INDEX fk_fkguh95droxnlo6ptgcnmdhyq0j_idx ON conv_abstractoperation(description);
CREATE INDEX fk_fkjoen4kgrplj4mqgigic56hqmc_idx ON conv_abstractoperation(name_);
CREATE INDEX fk_fklg80m5gntqxpfayyvarn5q5qu_idx ON conv_abstractsecuritypolicy(operation_);
CREATE INDEX fk_fkqk0o5k8c0njlwbwacqtyen6oi_idx ON conv_abstractsecuritypolicy(selector);
CREATE INDEX fk_fkdfio6556s3p4rqgqt41rm6t9i_idx ON conv_aclaccessibility(aclid);
CREATE INDEX fk_fk5dcxkd8fdkmhodhfh7km3sx89_idx ON conv_aclentries(aclentryid);
CREATE INDEX fk_fklmm9ryghrmoiyp7m8d3la7jwg_idx ON conv_aclentries(aclid);
CREATE INDEX fk_fki8tyegvc0rqcor0mjiba5wjrc_idx ON conv_adaptiveiconrepres(resourceid);
CREATE INDEX fk_fk20atdkmeehu6ll47th65shxtn_idx ON conv_adaptiveiconrepres(adaptiveiconid);
CREATE INDEX fk_fkfh1tjs0p84cyxoyv692218emd_idx ON conv_anythingtopdfjobjoblist(conversionjobid);
CREATE INDEX fk_fk2ifbjncxac1mk8jwwk0qrjx4x_idx ON conv_anythingtopdfjobjoblist(anythingtopdfjobid);
CREATE INDEX fk_fk3yk56embk94m98ojs7vtbkdpn_idx ON conv_attachment(acl);
CREATE INDEX fk_fkcwu97b0a2ocj82cvxsd55tkga_idx ON conv_attachment(securitypolicy);
CREATE INDEX fk_fkqb0a6fmbeyhoybe5oly76qlkl_idx ON conv_attachment(page);
CREATE INDEX fk_fkoa1nfb4pay4k1jes98jhv2v0h_idx ON conv_attachment(document);
CREATE INDEX fk_fki74eakrxk33nlw985ukk9hib5_idx ON conv_attachment(commentthreadstatus);
CREATE INDEX fk_fksner82lfd2nwi446nxh19fcrt_idx ON conv_attachment(assigneduser);
CREATE INDEX fk_fk6un7m8pbuwrwu34y9n7k90ag3_idx ON conv_combinedjobjoblist(conversionjobid);
CREATE INDEX fk_fkreq3q2wk9ekkgmjp6yn9ax4sw_idx ON conv_combinedjobjoblist(combinedjobid);
CREATE INDEX fk_fknkkftv2vt2bqgxd7v9u50vrfc_idx ON conv_commentthreadcomments(commentid);
CREATE INDEX fk_fk7p1fpvvhbkx4h7chvpxj734pd_idx ON conv_commentthreadcomments(commentthreadid);
CREATE INDEX fk_fk7xyke3g8fftionkyoqda8mgg4_idx ON conv_commentthreadstatus(description);
CREATE INDEX fk_fk1siyem1vw5wq5mmdf9d7q2ig6_idx ON conv_commentthreadstatus(name_);
CREATE INDEX fk_fkt5t96x9oge4gjdtt5tfeuimns_idx ON conv_compounddocumentdocuments(abstractdocumentid);
CREATE INDEX fk_fk5ni05rrh3l46568y98bwypr3v_idx ON conv_compounddocumentdocuments(compounddocumentid);
CREATE INDEX fk_fk6kfj8ruenqhggyna1ve9hl96q_idx ON conv_compoundoperationoper(abstractoperationid);
CREATE INDEX fk_fkoi0sear33a3xriywfrwwb3f2p_idx ON conv_compoundoperationoper(compoundoperationid);
CREATE INDEX fk_fkcvbhcu714iv5v23w7nbdro2y2_idx ON conv_compsecurpolicysecurpolic(abstractsecuritypolicyid);
CREATE INDEX fk_fkb561oy4yjo61dqmt55y1me908_idx ON conv_compsecurpolicysecurpolic(compoundsecuritypolicyid);
CREATE INDEX fk_fkg0k82mr0si65i563oouopvn66_idx ON conv_compstyledhighlhighldimen(highlightingdimensionid);
CREATE INDEX fk_fksf6d8m8scm6p68oxb3dt4ixbc_idx ON conv_compstyledhighlhighldimen(compoundstyledhighlightingid);
CREATE INDEX fk_fk3sytt3vsp1oluc11e4u5giipy_idx ON conv_conversionjob(generaltemplatereplacements);
CREATE INDEX fk_fkslsqtu44y4snyk4y857df8y6y_idx ON conv_conversionjobtags(conversionjobid);
CREATE INDEX fk_fksc0lljo8njht1i7lyqqwdfwnn_idx ON conv_convjobinputreferences(conversionjobid);
CREATE INDEX fk_fkey370pih90edsn653k9wmt49v_idx ON conv_convjobinputresources(resourceid);
CREATE INDEX fk_fklgvnildh0utypcrs205eebrkr_idx ON conv_convjobinputresources(conversionjobid);
CREATE INDEX fk_fk6ts7u4ft53e2ca2ip9lj94whi_idx ON conv_convjoboutputresources(resourceid);
CREATE INDEX fk_fka4me2ib0di0ikbu6ixqn2i6a7_idx ON conv_convjoboutputresources(conversionjobid);
CREATE INDEX fk_fkqidquwhpragybsjq675lsnvkh_idx ON conv_createdocumentjobjoblist(conversionjobid);
CREATE INDEX fk_fkcdxqswxijudpuv5908chdn3ij_idx ON conv_createdocumentjobjoblist(createdocumentjobid);
CREATE INDEX fk_fknibiiq15jk2b40j1vlvx481df_idx ON conv_documentpages(pageid);
CREATE INDEX fk_fk76ujy6s9k42sc0fyd9xnnqddu_idx ON conv_documentpages(documentid);
CREATE INDEX fk_fkm28oi5cdkxpxu4owulww1xbv2_idx ON conv_documentpageselection(document);
CREATE INDEX fk_fkpmg6j57bw9ritx9ciwco0sx88_idx ON conv_documentpageselection(user_);
CREATE INDEX fk_fkf512hr7kwr2d0ydg3jmq85d7r_idx ON conv_documpageselecselecpages(pageid);
CREATE INDEX fk_fk5it9dgb55r8n560ike6h65kkv_idx ON conv_documpageselecselecpages(documentpageselectionid);
CREATE INDEX fk_fknahwxw4ui5ye8kmit4q6kxg4v_idx ON conv_emailmetadatabcc(emailmetadataid);
CREATE INDEX fk_fk9vx4va0m7tijnnvcaqkef2kbe_idx ON conv_emailmetadatacc(emailmetadataid);
CREATE INDEX fk_fks3951l458rofgpis1xm8vrf0e_idx ON conv_emailmetadatato(emailmetadataid);
CREATE INDEX fk_fkkfk9txm4iu17mfmwdj4b978r9_idx ON conv_emailtopdfjobjoblist(conversionjobid);
CREATE INDEX fk_fkijmdo2hporacovkuowlcs46ke_idx ON conv_emailtopdfjobjoblist(emailtopdfjobid);
CREATE INDEX fk_fk7d8b2kx3gcr455d21aarqsoiq_idx ON conv_extracttextjobjoblist(conversionjobid);
CREATE INDEX fk_fksw2o2edfxeeubc97ntt32sikr_idx ON conv_extracttextjobjoblist(extracttextjobid);
CREATE INDEX fk_fk7844lhf3u47tdaylq3sntst9m_idx ON conv_group(description);
CREATE INDEX fk_fk80bl6f5lvvra0fldqbjsfk5kl_idx ON conv_group(localizedname);
CREATE INDEX fk_fkqxk11b19jr8mg0fug988r2ei_idx ON conv_group(picture);
CREATE INDEX fk_fkl0dyye89cna799un1763vy0h6_idx ON conv_grouproles(roleid);
CREATE INDEX fk_fknxri93c5dxioc7fisf6wjs4gp_idx ON conv_grouproles(groupid);
CREATE INDEX fk_fk3d2ora9kifcyejryeajh5035t_idx ON conv_groupusers(userid);
CREATE INDEX fk_fkt6edlvdr0cxl9lxa8bvr6bfmn_idx ON conv_groupusers(groupid);
CREATE INDEX fk_fkaso22rhwr961f7m57pbvn4rs9_idx ON conv_highlighting(attachment);
CREATE INDEX fk_fkbc0m4jr8puh4dvhcnc2dejyjx_idx ON conv_highlighting(securitypolicy);
CREATE INDEX fk_fkphe6ar8hkmn3xmoao0n40ita3_idx ON conv_highlighting(highlightingdimension);
CREATE INDEX fk_fkcp6k40l5o4p6jtihycjdbvgd1_idx ON conv_highlighting(highlightingcategory);
CREATE INDEX fk_fkmh28609r9914b13w4lejud53_idx ON conv_highlightingcategory(displayname);
CREATE INDEX fk_fkmixbrugrjy0f7bc91ewtfg8is_idx ON conv_highlightingcategory(style_);
CREATE INDEX fk_fk6bbm8npvdfaj4u2mr5vcx8p0k_idx ON conv_icon(image);
CREATE INDEX fk_fkpr8moqtw0enl6urajy78hd1ut_idx ON conv_localstringlocalvalues(localizedstringid);
CREATE INDEX fk_fk5jjhgmvug8t52og2cd3ythalq_idx ON conv_ocrlinewords(ocrwordid);
CREATE INDEX fk_fk9mqjfwjivvp14btpy8bpq18o8_idx ON conv_ocrlinewords(ocrlineid);
CREATE INDEX fk_fkjieda6glrr8eyml43v0ocwln9_idx ON conv_ocrpagelines(ocrlineid);
CREATE INDEX fk_fktjrlhmv6wq7w7uvuoa2brlced_idx ON conv_ocrpagelines(ocrpageid);
CREATE INDEX fk_fk62cskumlxub49quwf892b87u3_idx ON conv_ocrpageparagraphs(ocrparagraphid);
CREATE INDEX fk_fk5kyylrpsuqytcrkbn6y1xtl4a_idx ON conv_ocrpageparagraphs(ocrpageid);
CREATE INDEX fk_fk2w5rdbt2x2mykkul7is9e2g9w_idx ON conv_ocrpagewords(ocrwordid);
CREATE INDEX fk_fke6amlj8vdjm83d9eu24y2al7w_idx ON conv_ocrpagewords(ocrpageid);
CREATE INDEX fk_fk9pborvcgy99j7l5okgjcgm4xs_idx ON conv_ocrparagraphlines(ocrlineid);
CREATE INDEX fk_fkgrmm83mdekm3sik2qdnl1ewm7_idx ON conv_ocrparagraphlines(ocrparagraphid);
CREATE INDEX fk_fkpfch8l2r28tpliry3xx7tuaur_idx ON conv_ocrparagraphwords(ocrwordid);
CREATE INDEX fk_fk7ywjqtcyt9kq9qonfleony0j5_idx ON conv_ocrparagraphwords(ocrparagraphid);
CREATE INDEX fk_fkijaq7y6y1f3m2d9nr7ksw0qgv_idx ON conv_page(securitypolicy);
CREATE INDEX fk_fkg6qnrltikeaqw4vpecnoyu9kt_idx ON conv_pagehighlightings(highlightingid);
CREATE INDEX fk_fk265nd8rktueukq18wdvr5poxx_idx ON conv_pagehighlightings(pageid);
CREATE INDEX fk_fkeoortm5holbvdn3j6u2ih5dfq_idx ON conv_pagerepresentations(resourceid);
CREATE INDEX fk_fkayqhehy48hhlslp3ilwuptwhh_idx ON conv_pagerepresentations(pageid);
CREATE INDEX fk_fkx1k8yt7ciqlrrsfa1elr7xnk_idx ON conv_resource(resourcesource);
CREATE INDEX fk_fk3y248omvbn1cmxp9vx8wjtj4j_idx ON conv_resource(securitypolicy);
CREATE INDEX fk_fkso2uldbaie3j48yk1d8ly9w1j_idx ON conv_resource(specification);
CREATE INDEX fk_fksun68jl110sd39sksbrboxame_idx ON conv_resourcesource(template_);
CREATE INDEX fk_fk6ib2c390h8ekeaj3qfrsy8lls_idx ON conv_resourcetags(resourceid);
CREATE INDEX fk_fkstlsw85457gq4qfnn2h7n5epn_idx ON conv_role(description);
CREATE INDEX fk_fka323ja1j8it0k0xny3rm7717d_idx ON conv_role(localizedname);
CREATE INDEX fk_fks2tudu054s46itlhyr8e2tlpm_idx ON conv_servrequestjobrequestreso(resourceid);
CREATE INDEX fk_fkg3oc6491l95f7k2rsw6tsxt42_idx ON conv_servrequestjobrequestreso(servicerequestjobid);
CREATE INDEX fk_fkmu54i07vhkouubsxmcvin5fns_idx ON conv_servrequestjobresultreso(resourceid);
CREATE INDEX fk_fkg37y7k0n7p8v3q1e4e27vau72_idx ON conv_servrequestjobresultreso(servicerequestjobid);
CREATE INDEX fk_fkpi8o714utcycpu2bbnqmivqtn_idx ON conv_svghighlhighldimensions(highlightingdimensionid);
CREATE INDEX fk_fk56bafcpbxbfswoj2bx1c77g9r_idx ON conv_svghighlhighldimensions(svghighlightingid);
CREATE INDEX fk_fk25hp7whkxymn915xcb9yec9ti_idx ON conv_templatereplacfieldvalues(templatereplacementsid);
CREATE INDEX fk_fka0qvrpioevwdgx3uix2q9q21a_idx ON conv_txttmplttxtjbtmplrplcprtg(templatereplacementsid);
CREATE INDEX fk_fk5ldqcnwoihexrfmsnhe5finc4_idx ON conv_txttmplttxtjbtmplrplcprtg(texttemplatetotextjobid);
CREATE INDEX fk_fkf4dli2l7n5t0sigx7buljc1w3_idx ON conv_user(description);
CREATE INDEX fk_fkh82bx5qc74jtm758k6p251isq_idx ON conv_user(picture);
CREATE INDEX fk_fkbd8gvd94lev73w8hh67wpjbtc_idx ON conv_usergroups(groupid);
CREATE INDEX fk_fkeoow8igh6ga6ic03aux5oeb6e_idx ON conv_usergroups(userid);
CREATE INDEX fk_fkks4ciw5god79p5kl6kboe7q0t_idx ON conv_userroles(roleid);
CREATE INDEX fk_fkn6ej9of8uddx00x8qvp2e86a2_idx ON conv_userroles(userid);
CREATE INDEX fk_fkrhikihhepnaaws6s88pk48dlv_idx ON conv_videospecifattacstreams(attachmentstreamid);
CREATE INDEX fk_fkq77oqr46p4ejms1xk5jhcacku_idx ON conv_videospecifattacstreams(videospecificationid);
CREATE INDEX fk_fkedqxc18jswvs90wlv9bqwab0j_idx ON conv_videospecifaudiostreams(audiostreamid);
CREATE INDEX fk_fkhbjoifgfnwk2v6dj583p8lenv_idx ON conv_videospecifaudiostreams(videospecificationid);
CREATE INDEX fk_fkroem7vaetruqavhhc02imsc19_idx ON conv_videospecifsubtstreams(subtitlestreamid);
CREATE INDEX fk_fksx7a9wju30s9kjb8oiq57cx8h_idx ON conv_videospecifsubtstreams(videospecificationid);
CREATE INDEX fk_fkcyx7d3vh67cih6ylhtlff8ip9_idx ON conv_videospecifvideostreams(videostreamid);
CREATE INDEX fk_fkbbygd30fi9l2h64v9r9x887in_idx ON conv_videospecifvideostreams(videospecificationid);
CREATE INDEX fk_fkpo12vkboy0rkf2njc6xdl3ife_idx ON conv_videotoimagjobframemicros(videotoimagesjobid);
CREATE INDEX fk_fk9r9fbgobgmd5t9u0uw2h4qpcn_idx ON conv_wrdtemplreplacregexreplac(wordtemplatereplacementsid);
CREATE INDEX fk_fksdg4w7il4hxxjyxmhrw0s6sjj_idx ON conv_wrdtemplreplacstrinreplac(wordtemplatereplacementsid);
CREATE INDEX fk_fkg0cmvftud8h4g8ei4413k5fa1_idx ON conv_wrdtmpltwrdjbtmplrplcprtg(wordtemplatereplacementsid);
CREATE INDEX fk_fk6yhuw39vaagjp617twlqby2mx_idx ON conv_wrdtmpltwrdjbtmplrplcprtg(wordtemplatetowordjobid);
- AD-2592: in some circumstances (OS environment (Linux in some configurations)) one of the files reported might not be able to be displayed. There is a follow-up ticket for ADx 2.8 to investigate further to cover more situations.
Java Version
The on-prem installation packages for this release have been tested with JDK JDK 11.0.12 (package zulu11.50.19-ca-jdk11.0.12-linux_x64)
Changes in actual version
Nothing has been removed since previous release.
Changes in upcoming versions
Nothing is going to be removed in future release.
Runtime Properties and Configuration changes
No runtime properties have been added, changed or removed in this release.
List of New Features and Improvements
| Issue | Priority | Summary Description |
|---|---|---|
| AD-2637 | Major | Add DB index to "ACL Accessibility" |
| AD-2585 | Minor | Localization Object Upload |
| AD-2635 | Critical | Add DB index scripts to documentation |
Bug Fixes
| Issue | Priority | Summary Description |
|---|---|---|
| AD-2617 | Blocker | CMIS: Synchronize types and models is not working |
| AD-2556 | Critical | CMIS repository cannot connect to ADx due to certification error |
| AD-2592 | Critical | Cannot convert documents |
| AD-2629 | Critical | CMIS, DCTM: Merge document by id |
| AD-2619 | Critical | IS error occurs when some action is done on CMIS repository |
| AD-2601 | Critical | Connection check not working on configuration panel |
Updating Conversion and ADx
For information on how to update previously installed Conversion and ADx, see the following:
Known Issues
Below you can find a list of problems we're still working on.
Known Issues ADx
| Ticket | SEVERITY | Description |
|---|---|---|
| https://jira.braintribe.com/browse/AD-321 | CRITICAL | Add missing indices |
| https://jira.braintribe.com/browse/AD-348 | MAJOR | ADx Admin: Repository Modification-Status not updated on Update |
| https://jira.braintribe.com/browse/AD-1898 | MAJOR | Min and Max length metadata not respected on initial upload |
| https://jira.braintribe.com/browse/AD-342 | MINOR | Hibernate warnings in the log files |
| https://jira.braintribe.com/browse/AD-341 | MINOR | Java warnings during for Java 9 and later |
| https://jira.braintribe.com/browse/AD-311 | MINOR | Oracle - DbLockManager prints Oracle constraint message |
Reimporting an Existing Repository Requires UI Reload
In some cases, when reimporting an existing repository, repository properties are not rendered correctly. To make sure properties are rendered correctly, refresh your browser after each import.
Cannot migrate legacy contents simultaneously
Due to cache database being shared between repositories, it's not possible for now to run multiple migration jobs from a single legacy repository at the same time. You need to wait for the previous migration to finish before running a new one.
Min and Max length metadata not respected on initial upload
String length checks are only applied when values are updated but not on the initial upload.
Known Issues Conversion
| Ticket | SEVERITY | Description |
|---|---|---|
| https://jira.braintribe.com/browse/AD-338 | CRITICAL | Introduce roles for conversion |
| https://jira.braintribe.com/browse/AD-337 | MAJOR | Make TF Conversion workbench consistent to ADx |
| https://jira.braintribe.com/browse/EXTDOCS-71 | MINOR | Fix wrong encoding on opening resource in Browser |
Minor Warnings
StatusLogger Error
The following error currently appears in ADx console output. It doesn't affect ADx functionality or performance.
ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console.
Set system property 'org.apache.logging.log4j.simplelog.StatusLogger.level' to TRACE to show Log4j2 internal initialization logging.
Tomcat Shutdown Warning
The following warning is sometimes thrown by Tomcat when stopping the service:
./tribefire-console-stop.sh
...
Tomcat did not stop in time.
PID file was not removed.
To aid diagnostics a thread dump has been written to standard out.
Tribefire Host stopped.
This happens when shutdown takes longer than Tomcat expects. Shutdown may take several minutes, which will result in this message being printed out. This warning could appear on both Conversion and ADx.
Java Warnings
When using Java 9 or later, the following warning may appear in application logs and also during installation procedure:
WARNING: An illegal reflective access operation has occurred
WARNING : Illegal reflective access by com.braintribe.model.processing.itw.asm.AsmClassLoaderWrapper$1 (file:/path/to/instant-type-weaving-1.0.28.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int)
WARNING: Please consider reporting this to the maintainers of com.braintribe.model.processing.itw.asm.AsmClassLoaderWrapper$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Ticket: https://jira.braintribe.com/browse/AD-341
Hibernate Warnings
The log files may contain Hibernate-related warnings. They can be identified based on the fully qualified class which starts with org.hibernate, as in:
WARNING org.hibernate.tuple.entity.EntityMetamodel 'HHH000084: Entity [com.braintribe.model.user.User] is abstract-class/interface explicitly mapped as non-abstract; be sure to supply entity-names' [TribefireServices-2.0:tribefire-services#initialize,ApplicationLoader:/tribefire-services#initialize]
Ticket: https://jira.braintribe.com/browse/AD-342
These warnings do not affect the functionality of the application and can be ignored. We are working on a fix.