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

From: Kate Barrington <kbarrington@xxxxxxxxxxxxxxxx>
To: "'lg-it@xxxxxxxxxxxxx'" <lg-it@xxxxxxxxxxxxx>
Date: Mon, 12 Jun 2023 21:32:26 +0000

Hi Jeffrey,

The integration in CM10 works the same.

The examples you have below are slightly different. In the CM9 example, a
container was found.

Hope that's helpful.

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

Whereas in the CM10 example, a container was not found in the search and hence
it created one.

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

Kate Barrington
Contractor

[cid:image001.jpg@01D99DC9.302D6910]

         Reception: 03 5871 9222
         Email: kbarrington@xxxxxxxxxxxxxxxx | moira.vic.gov.au
         Post: PO Box 578, Cobram, Vic 3643
       [cid:image002.png@01D99DC9.302D6910]
<http://facebook.com/moirashirecouncil> [cid:image003.png@01D99DC9.302D6910]
<http://instagram.com/moirashirecouncil> [cid:image004.png@01D99DC9.302D6910]
<http://au.linkedin.com/company/moira-shire-council>
      [cid:image005.jpg@01D99DC9.302D6910]

From: lg-it-bounce@xxxxxxxxxxxxx <lg-it-bounce@xxxxxxxxxxxxx> On Behalf Of
Jeffrey Boehme
Sent: Thursday, 1 June 2023 2:26 PM
To: lg-it@xxxxxxxxxxxxx
Subject: lg-it Content manager 9 -> 10 upgrade with Authority 7.33.2
integration issue

CAUTION:This message is from an external sender. Please be cautious when
clicking on links or opening attachments.

________________________________
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

[cid:image006.png@01D99DC9.302D6910]<https://www.dubbo.nsw.gov.au/>[cid:image007.png@01D99DC9.302D6910]<https://www.facebook.com/DubboRegionalCouncil/>
   [cid:image008.png@01D99DC9.302D6910] <https://twitter.com/DubboCouncil>
[cid:image009.png@01D99DC9.302D6910]
<https://www.instagram.com/dubboregionalcouncil/>

Jeffrey Boehme
Business Systems Partner
Information Services | Dubbo Regional Council
P 02 6801 4323 <tel://02%206801%204323> | M 0436 640 439<tel://0436%20640%20439>
Jeffrey.Boehme@xxxxxxxxxxxxxxxx<mailto:Jeffrey.Boehme@xxxxxxxxxxxxxxxx>
http://dubbo.nsw.gov.au

How was your experience today?
Click on one of the icons below to let us know!
[cid:image010.png@01D99DC9.302D6910]<https://app.smartsheet.com/b/form/99bade8442224f879ab069dffdb0934a?Email=Jeffrey.Boehme@xxxxxxxxxxxxxxxx&Dept=Information%20Services&Level=3>
[cid:image011.png@01D99DC9.302D6910]<https://app.smartsheet.com/b/form/e716d0458a6244a29072ad4404aaec57?Email=Jeffrey.Boehme@xxxxxxxxxxxxxxxx&Dept=Information%20Services&Level=2>
[cid:image012.png@01D99DC9.302D6910]<https://app.smartsheet.com/b/form/c69da494fb8541e28b6a2482161b3281?Email=Jeffrey.Boehme@xxxxxxxxxxxxxxxx&Dept=Information%20Services&Level=1>

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.

Disclaimer

The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby notified
that any disclosure, copying, distribution or taking action in relation of the
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast, a leader in email security and cyber
resilience. Mimecast integrates email defenses with brand protection, security
awareness training, web security, compliance and other essential capabilities.
Mimecast helps protect large and small organizations from malicious activity,
human error and technology failure; and to lead the movement toward building a
more resilient world. To find out more, visit our website.

Follow-Ups:
- lg-it Re: Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue
  - From: Jeffrey Boehme

References:
- lg-it Content manager 9 -> 10 upgrade with Authority 7.33.2 integration issue
  - From: Jeffrey Boehme

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

Other related posts: