lg-it Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue

From: "Jeffrey Boehme" <dmarc-noreply@xxxxxxxxxxxxx> ("Jeffrey.Boehme")
To: "lg-it@xxxxxxxxxxxxx" <lg-it@xxxxxxxxxxxxx>
Date: Thu, 1 Jun 2023 04:25:56 +0000

Hi Team,

Just wondering if anyone has come across and hopefully resolved an issue with
upgrading to Content Manager 10 in which creating documents from templates
using Authority and the Word Macro document generator creates a new container
each time you generate a new document if a defaultcontainer is not defined as a
specific container in External Document Parameters.

Any ideas?
Thanks
Jeff

Technical details

Current behaviour in CM9.4
Generate document, If there is a container with the same unid and file type it
puts it in there
Complete document upload the AuthTrimTrace shows;
31/05/2023 10:27:26 AM [Information] :    Create record type: Authority Document
31/05/2023 10:27:26 AM [Information] :    Check if container already exists in
Trim
31/05/2023 10:27:26 AM [Information] :       Entering findContainer
31/05/2023 10:27:26 AM [Information] :          Check if Authority has a TRIM
Record Number available and search for match
31/05/2023 10:27:26 AM [Information] :                Container not found
31/05/2023 10:27:26 AM [Information] :                Check if TRIM has a
container linked to the Authority Module + Account:
DD008.2023.00000803.001Authority File
31/05/2023 10:27:26 AM [Information] :                Container found
31/05/2023 10:27:26 AM [Information] :       Exiting findContainer

Cm9.4 shows
SELECT uri FROM TSRECORD  WITH (NOLOCK)  WHERE ( uri IN ( SELECT A0.rwRecordUri
FROM  TSRECWORD A0 WITH (NOLOCK) WHERE ( A0.rwIndexWordUri IN ( SELECT uri FROM
TSINDEXWOR WITH (NOLOCK) WHERE ( ixWordName LIKE '%DD008.2023.00000803.001%'
AND ixwType = 2506 ) ) ) ) AND rcRecTypeUri = 6 AND rcDateRecycled IS NULL AND
uri > 0 ) AND EXISTS ( SELECT 1 FROM TSRECORD  SECFLTR  WITH (NOLOCK)  WHERE
SECFLTR.uri = TSRECORD.uri AND SECFLTR.rcSecLevel <= 10 AND ( SECFLTR.rc1Caveat
& ~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc2Caveat & ~CAST( 0  as bigint)) = 0
AND ( SECFLTR.rc3Caveat & ~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc4Caveat &
~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc5Caveat & ~CAST( 0  as bigint)) = 0
AND ( SECFLTR.rc6Caveat & ~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc7Caveat &
~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc8Caveat & ~CAST( 0  as bigint)) = 0
AND ( SECFLTR.rcAccessLoc = 0 OR EXISTS ( SELECT 1 FROM TSaccessCo  WITH
(NOLOCK)  WHERE axObjectUri = SECFLTR.uri AND axObject = 6 AND axType = 2 AND
axLocUri IN (56163,0,785,881,16403,20589,49864,106953) )) AND (
SECFLTR.rcAccessLoc > 0 OR SECFLTR.rcAccessIsCont = 'F' OR
SECFLTR.rcContainerUri = 0 OR EXISTS ( SELECT 1 FROM TSRECORD CONTTEST  WITH
(NOLOCK)  WHERE CONTTEST.uri = SECFLTR.rcContainerUri  AND  CONTTEST.rcSecLevel
<= 10 AND ( CONTTEST.rc1Caveat & ~CAST( 0  as bigint)) = 0 AND (
CONTTEST.rc2Caveat & ~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc3Caveat &
~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc4Caveat & ~CAST( 0  as bigint)) = 0
AND ( CONTTEST.rc5Caveat & ~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc6Caveat &
~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc7Caveat & ~CAST( 0  as bigint)) = 0
AND ( CONTTEST.rc8Caveat & ~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rcAccessLoc
= 0 OR EXISTS ( SELECT 1 FROM TSaccessCo  WITH (NOLOCK)  WHERE axObjectUri =
CONTTEST.uri AND axObject = 6 AND axType = 2 AND axLocUri IN
(56163,0,785,881,16403,20589,49864,106953) )) )) )

In Cm10
Generate document, If there is a container with the same unid and file type it
creates a new container with the same unid and puts the document in there.

Complete document upload the AuthTrimTrace shows;
31/05/2023 10:24:32 AM [Information] :    Create record type: Authority Document
31/05/2023 10:24:32 AM [Information] :    Check if container already exists in
Trim
31/05/2023 10:24:32 AM [Information] :       Entering findContainer
31/05/2023 10:24:32 AM [Information] :          Check if Authority has a TRIM
Record Number available and search for match
31/05/2023 10:24:32 AM [Information] :                Container not found
31/05/2023 10:24:32 AM [Information] :                Check if TRIM has a
container linked to the Authority Module + Account:
DD010.2023.00000174.001Authority File
31/05/2023 10:24:35 AM [Information] :                Container not found
31/05/2023 10:24:35 AM [Information] :       Exiting findContainer
31/05/2023 10:24:35 AM [Information] :       Create new container

CM 10 Logs
SELECT uri,recordId FROM TSRECORD  WITH (NOLOCK)  WHERE ( uri IN ( SELECT uri
FROM TSTXTIDXRT WHERE CONTAINS ( text ,
'NEAR(("DD","010","2023","00000174","001","DEVELOPMENT","APPLICATION","APPROVAL","NO","CLASSIFICATION"),0,TRUE)'
, LANGUAGE 1033 ) ) AND title = 'DD - 010.2023.00000174.001 - Development
Application Approval - No Classification' AND rcStructuredTitle = '' ) AND
EXISTS ( SELECT 1 FROM TSRECORD  SECFLTR  WITH (NOLOCK)  WHERE SECFLTR.uri =
TSRECORD.uri AND SECFLTR.rcSecLevel <= 10 AND ( SECFLTR.rc1Caveat & ~CAST( 0
as bigint)) = 0 AND ( SECFLTR.rc2Caveat & ~CAST( 0  as bigint)) = 0 AND (
SECFLTR.rc3Caveat & ~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc4Caveat & ~CAST(
0  as bigint)) = 0 AND ( SECFLTR.rc5Caveat & ~CAST( 0  as bigint)) = 0 AND (
SECFLTR.rc6Caveat & ~CAST( 0  as bigint)) = 0 AND ( SECFLTR.rc7Caveat & ~CAST(
0  as bigint)) = 0 AND ( SECFLTR.rc8Caveat & ~CAST( 0  as bigint)) = 0 AND (
SECFLTR.rcAccessLoc > 0 OR SECFLTR.rcAccessIsCont = 'F' OR
SECFLTR.rcContainerUri = 0 OR EXISTS ( SELECT 1 FROM TSRECORD CONTTEST  WITH
(NOLOCK)  WHERE CONTTEST.uri = SECFLTR.rcContainerUri  AND  CONTTEST.rcSecLevel
<= 10 AND ( CONTTEST.rc1Caveat & ~CAST( 0  as bigint)) = 0 AND (
CONTTEST.rc2Caveat & ~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc3Caveat &
~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc4Caveat & ~CAST( 0  as bigint)) = 0
AND ( CONTTEST.rc5Caveat & ~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc6Caveat &
~CAST( 0  as bigint)) = 0 AND ( CONTTEST.rc7Caveat & ~CAST( 0  as bigint)) = 0
AND ( CONTTEST.rc8Caveat & ~CAST( 0  as bigint)) = 0 )) ) ORDER BY recordId ASC
OFFSET 0 ROWS FETCH NEXT 6 ROWS ONLY

Jeffrey Boehme
Business Systems Partner
Information Services | Dubbo Regional Council
P 02 6801 4323 | M 0436 640 439
Jeffrey.Boehme@xxxxxxxxxxxxxxxx
http://dubbo.nsw.gov.au

We acknowledge the Wiradjuri people, the traditional custodians of the land. We
pay respects to Elders past, present and emerging of the Wiradjuri
Nation.Please consider the environment before printing this email.
This e-mail, together with any attachments, is for the exclusive and
confidential use of the addressee(s). Any other distribution, use of, or
reproduction without prior written consent is strictly prohibited. Views
expressed in this e-mail are those of the individual, except where specifically
stated otherwise. Dubbo Regional Council does not warrant or guarantee this
message to be free of errors, interference or viruses.

Follow-Ups:
- lg-it Re: Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue
  - From: Emmaleah Cumming
- lg-it Re: Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue
  - From: Kate Barrington

lg-it Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue

Other related posts: