Hi Ed, I mean, I have more than 2K AGs , so I was thinking to do arsxml update.
Your recommendation would be to do it from Admin client ?

Thanks!

Hi - Our documents are stored in ICOS with different retentions ranging from 1 year to 99 years and we even have some AGs for which we have applied hold using ERM.
I need to update the retention of all the AGs to 7 years and then purge anything that is older than 7 years.
I am planning to do a direct DB update to change the retention to 7 for all the AGs.
Will this approach apply the 7 year retention to the historical load too? And when I run arsmaint for purging, will historical data older than 7 year also be deleted ? 

I spot checked some of the AGs that are missing from the list, they are actually empty. Yeah, seems like we have few 100 empty AGs.

Thanks for the help!!

Hi Justin,

Thanks for sharing useful tips here.

I am trying to get count of all the documents that we have in our CMOD today, I tried below command but the AG count doesn't match with what I have in CMOD (the count comes to be less than what I have in CMOD).

db2 "select arsag.name,sum(arsseg.ins_rows-arsseg.del_rows) as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid group by arsag.name"

I get 1137 record(s) selected vs I have 1461 AGs in CMOD.

Would you know why there is the difference in the record count?

Thanks Ahead !!

Hi All - I need help with System Log data query.
I am trying to pull data from System Log table where an ADMIN user has made a user update (user admin task). When I query, it gives me two entries, one with View option "T" and other with View Option "N". I only want to see one entry in my log that I have pulled. Preferably View="T".
The filed in SystemLog table is ANNOT. 

I tried below query but it doesn't give me back any result.

arsdoc query -h <hostname> -u <user>-f "System Log" -i "where userid='$line' and msg_num in (34,35,36) and annot='YES' and ODDAT_time_stamp_dt > '$endDate'".

this query gives me empty result and if I remove annot='YES', then I get two line back as a result in my log file.

Time Stamp,Userid,Severity,Msg Num,Message,View,Log ID
11/16/2021 14:12:42,<Admin_userid>,4,36,User Update: Userid(<userid1>) Id(3),T,1369837038,
11/16/2021 14:12:37,<Admin_userid>,4,36,User Update: Userid(<userid1>) Id(3),N,1698537038,

Hi - We recently migrated from CMOD 9.5 to 10.1 and some of our loads are failing complaining about less index fields than expected.
We have few index fields in "Load Information" tab in an application which are set to default in 9.5 but it appears that 10.1 doesn't like that and complains about the missing indexes.
Does anyone know if this is something different/new in 10.1 than 9.5?

Hi All,  Is there a way to write the indexes on a separate file (like a text file) as we load the document to OnDemand, its a PDF doc with embedded index values.

Hi Justin,
Assigning Application Group / Folder administration authority to my user id did the trick. :) Thanks !!

Hi Ed,
This is a useful link, thanks for sharing. Thank you!!

Thanks,
Shivani

Hi Ed,
I tried using task="update", in this case, it didn't help, I am still getting the same error.

Hi Justin,
I tried by removing folder update with below xml, I am now trying to just add AG to a user, I still get the same error:-

Updated XML file
<?xml version="1.0" encoding="UTF-8"?>
<onDemand xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                xsi:noNamespaceSchemaLocation="/opt/IBM/ondemand/V9.5/xml/ondemand.xsd">
<user
             name="mmtest"
         />
<applicationGroup name="TESTAG">

       <permission task="update" user="mmtest" authority="Access" docViewPerm="Yes" docPrintPerm="Yes" docCopyPerm="Yes" annotViewPerm="Yes" annotAddPerm="Yes"/>

       </applicationGroup>
</onDemand>


$ arsxml update -h hostname -u user -p password -i add32.xml
ARS6822I Attempting login for userid 'user' on server 'host' ...
ARS7744E A applicationGroup object named 'TESTAG' does not exist.

Hi, I am trying to update permission for a user id (trying to add AG and folder) by using ARSXML udpate command. My ID is defined as User Admin in OnDemand and when I use my id to run an ARSXML update, I get an error that AG doesn't exist but when I run the it as System Admin it updates the permission for that user.

below is my input XML

<?xml version="1.0" encoding="UTF-8"?>
<onDemand xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                xsi:noNamespaceSchemaLocation="/opt/IBM/ondemand/V9.5/xml/ondemand.xsd">
<user
             name="mmtest"
         />
<applicationGroup name="TESTAG">

       <permission user="mmtest" authority="Access" docViewPerm="Yes" docPrintPerm="Yes" docCopyPerm="Yes" annotViewPerm="Yes" annotAddPerm="Yes"/>

       </applicationGroup>
<folder name="TESTFOLDER">

  <permission user="mmtest" accessAuthority="Yes" maxHits="No Limit" />

  </folder>
</onDemand>

Am I missing any settings when I am setup myself as User ADMIN ?

Thanks !!

Hi All,
Does this transform works only for downloads or for viewer too?
I already have some customized code to convert the linedata to PDF when download or send it as email. I am looking for a solution which will do the conversion for viewer also.

Thanks ahead!

Hi Srinivas,
I have a similar issue, I have a .txt file that I am trying to load. There are multiple customer record in that text file which I need to split per customer and load.
I have created an application with ACIF indexer and below index information (took few from your index information).

CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
MCF2REF=CPCS
TRC=NO
FORMFEED=YES
FILEFORMAT=STREAM,(NEWLINE=X'0A')
GROUPMAXPAGES=9999
TRIGGER1=*,1,X'F1',(TYPE=GROUP)                            /* '1' */
FIELD1=2,91,8,(TRIGGER=1,BASE=TRIGGER)
FIELD2=23,51,8,(TRIGGER=1,BASE=TRIGGER)
INDEX1=X'506F73746C6E675F44617465',FIELD1,(TYPE=GROUP,BREAK=YES)  /* Posting_Date */
INDEX2=X'47726F75705F6F',FIELD2,(TYPE=GROUP,BREAK=NO)         /* Group_No */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=ALL
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE
INPEXIT=/opt/IBM/ondemand/V9.5/exits/acif/asciinp

and I use below command on my server to load the file
/opt/IBM/ondemand/V9.5/bin/arsload -fv -u <username>-p <password> -c /arstmp -h <hostname> -g <AG_name> -a <app> /file_path/file.txt

I get below error
2019-08-02 16:27:40.682942: ARS4302I Indexing started, 13245 bytes to process
                          : APK415I CC=YES
                          : APK415I CCTYPE=A
                          : APK415I CONVERT=NO
                          : APK415I CPGID=500
                          : APK415I MCF2REF=CPCS
                          : APK415I TRC=NO
                          : APK415I FORMFEED=YES
                          : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                          : APK415I GROUPMAXPAGES=9999
                          : APK415I TRIGGER1=*,1,X'F1',(TYPE=GROUP)
                          : APK415I FIELD1=2,91,8,(TRIGGER=1,BASE=TRIGGER)
                          : APK415I FIELD2=23,51,8,(TRIGGER=1,BASE=TRIGGER)
                          : APK415I INDEX1=X'506F73746C6E675F44617465',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'47726F75705F6F',FIELD2,(TYPE=GROUP,BREAK=NO)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=ALL
                          : APK415I INDEXSTARTBY=1
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=NONE
                          : APK415I INPEXIT=/opt/IBM/ondemand/V9.5/exits/acif/asciinp
                          : APK415I INPUTDD=/file_path/file.text
                          : APK415I OUTPUTDD=/arstmp/file.txt.out
                          : APK415I INDEXDD=/arstmp/file.txt.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK493S A VALUE OF YES FOR THE FORMFEED PARAMETER IS NOT ALLOWED WITH THE CONVERT=YES, CC=YES, OR TRC=YES PARAMETERS.
                          : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2019-08-02 16:27:40.707222: ARS4309E Indexing failed
2019-08-02 16:27:40.707350: ARS4318E Processing failed for file >/file_path/file.txt<
2019-08-02 16:27:40.726587: ARS4327E Processing has stopped.  The remaining files will NOT be processed.


Please suggest if I am doing something incorrect or missing something.

Thanks ahead!! 

Hi Justin,

I guess the problem here is that not all the documents of a load is corrupted, there are few in a load that are good and there are multiple such semi corrupted load.

Regards,
Shivani

Hi Joe,
Can that be done in Bulk? I mean can we modify the index value of all the impacted documents at one time?

Thanks,
ODSA

Hi All,
I am on OnDemand Content Management version 9.0.0.3, I have a requirement to add Note/Annotation to ~800 documents that were loaded as part of one incorrect load. Is it possible to add notes for all 800 document in bulk instead of adding the notes manually one at a time which will be a time consuming process?.  Please advise.

Thanks,
ODSA