Messages

1

MP Server / Re: Wintel : Moving Data - OnPrem SAN > AWS

« on: January 02, 2024, 06:34:21 AM »

Sure, here are a few things to check:

1. Did you verify that this particular file was included in your 10 GB file copy?
2. And its linked target? (Probably something like "f:\arscache1\<somenumber>\CBA\DOC\2FAAI")
3. Did you use the proper flags in robocopy so that the link file (I assume) was indeed copied as a link? Robocopy default is to copy the link TARGET instead of the actual link.
4. Also, even if it is a link, the link may be "dead". You can check this by right-clicking on the link file and check if it has a target file path or not (compare with the same file on your windows 2012 server)
EDIT:
5. Of course, also check the access settings for your OD user account against this folder structure. It is a beach  in Windows, not like in the Unixes where you can just run "chmod sumthng" a couple o'times and it's done.

Hope this helps!

2

OD/WEK & JAVA API / Stable permanent DocId links

« on: December 22, 2023, 07:04:26 AM »

So, I have read existing threads here that touch upon the usage of the CMOD Unique DocID feature .

• Topic 1
• Topic 2
• Topic 3

I'd like to catch up with the community here as what can be done to create permanent document links. As far as I understand, even if we activate unique docids in CMOD, we are still required to use odfolder.recreateHit in combination with either getOpenDocid or getDocid - which IBM warns produces non-persistent links (in case of reloads etc).

IBM also states (in the same ODApi docs):

The docid format is subject to change. If your application requires a unique document identifier to persist, consider using the Application Group field option "Unique ID".

What for, mate? How would that help? I can find no retrieve doc function that exclusively uses the unique docid (and perhaps a folder name or its Application Group or AGID) to retrieve a document.

So what's the use then, if we cannot create persistent doc links? (like the ones they have in that not-as-nice system "FileNet". This is a big commercial issue as the lack of links will entice companies into using or migrating to that system, instead of CMOD.)

Here is my current idea on how unique docids might be used to create persistent/permanent links.

1. Make sure the field you use for the Unique DocId has the same name in all Application Groups.
2. Search using a combination of folder name, application group name and the unique docid. For example:
URL Link = ODServer/search/folder_name/agcode+unique_docid
(such as www.mycomp.com/ODWEKServer/search/generalfolder/B6EA49-2ff02876-ffa5-4564-b0fb-966361dcf4f0 where "B6EA49" is an encoded Application Group Name and the rest is the actual, CMOD-generated Unique ID)

Code: [Select]

appgrpname = decodeAGname(agcode); // decodes "B6EA49" from the URL into some existing Application Group name
ODFolder odf = ods.openFolder(foldername); // "generalfolder" from the URL
odf.setApplGroupForSearchWithSQL(appgrpname);
ODHit uniqueHit = odf.search("WHERE $uniqidfieldname = $unique_docid); // get the unique hit
uniqueHit.retrieve('',C:\Temp\uniquefile);  // retrieve the unique file
//...Do something with the file...
(Note: this is untested code with the syntax of no real programming language - it is merely an idea)

Depending on how the rest of the web app is built, the user with the link will somehow need to be authenticated and have authorization to view the file.

Do you have any better ideas? Please share!
Or insights from IBM workshops etc? Sorry if I am currently not up to date.
Or improvements or helpful thoughts on the matter.

3

MP Server / Re: arsdoc query is failing with SQL0420N Invalid character found in a character st

« on: June 26, 2023, 10:51:13 AM »

Thanks Lars,

Actually the problem was with the date format we figured it out and it resolved the problem

Glad to hear that you solved it - thanks for sharing the solution here!

4

MP Server / Re: Object level migration

« on: June 25, 2023, 07:53:30 AM »

Hey there,
How much data are we talking about - no of TBs and the number of documents? A rough estimate would be good enough.
If you plan to stay on the same platform (or close), an extract + ingest procedure may not be required.
Please provide some more details.

(PS: Send me a PM if you would like practical help for this project - advisory only or hands-on.)

5

OD/WEK & JAVA API / Re: How install odwek v10.x only to linux?

« on: April 05, 2023, 02:53:00 AM »

There is one implication with installing all of CMOD when all you want is ODWEK, and that is when the yearly license audit takes place.
The automated tools will report CMOD as being installed on all of your ODWEK servers.
So far, a good explanation at a meeting has sufficed to convince the auditors that this is not a breach of licensing.
But it is the same type of meeting every year... 🙄😏

6

MP Server / Re: arsdoc query is failing with SQL0420N Invalid character found in a character st

« on: April 03, 2023, 08:23:06 AM »

Hi Mayank,

Did you by any chance alter the data type of any of the fields in Production to DecFloat (or any other numerical data type)?
Since concat takes two strings and puts them together, I assume that tstcrt_number, cast_number and BS_CSI_No are all strings.
Another thing to check here, if for example BS_CSI_No is a numeric value, then your SQL should not have 'quotes' around its value.

7

Other / Re: The famous but illusive 33 petabyte system

« on: November 04, 2022, 08:16:41 AM »

The largest one I'm aware of is/was in the low-single-digit petabyte range.  I would suspect that the number might have been 3.3 Petabytes...  33 sounds unfathomably large, even for CMOD.

-JD.

True, but still, IBM likes to brag tell about it - here's a quote by Brian Phelps, available online:

IBM has thousands of archive and retrieval customers using CM OnDemand (CMOD), the largest of which has over 33 petabytes under management, with many others in the same size range.

Perhaps I misrecall slightly - 33 Petabytes is the max size one vendor's Storage repository can handle, and maybe it was 33 Billion documents in one system? Or Trillion Anyways it was a huge number, that's for sure.

8

Other / The famous but illusive 33 petabyte system

« on: November 03, 2022, 02:43:50 AM »

Hi all,

I believe I once saw a technical description of the famous OnDemand system, which allegedly holds 33 petabyte of document data on a standalone server.
But I cannot find it anymore. Does anyone have a link to where I can find detailed info on the setup of that system?

9

MP Server / MASK field in ARSSEG - bit meaning

« on: October 13, 2021, 07:17:55 AM »

Does anyone have a list (full or partial) of the what the different bits in the MASK field of ARSSEG are for?
A guy asked us, the theory is that one or more of the bits determine which date style is used in the Segment date field of the table?

10

Windows Client / Re: Data update validation

« on: September 13, 2021, 01:35:04 AM »

Yeah, I figured. But sometimes some of you wizards out there have something up your sleeve that I haven't thought of yet, so I thought "well, no harm in asking".
Thanks JD!

11

MP Server / Re: Errors encountered during migration from CMOD 8.5.0.6

« on: August 31, 2021, 08:57:24 AM »

Another possibility, which I until just recently I thought only existed in Windows-based CMOD systems, but it does in Linux and probably in other Unix versions as well... is that your loads happen so fast that the Operating System runs out of ports. It actually uses one port per group/document in your input files (sic(k)!).

There are some simple commands to raise the number of ports available to arsload though. Unsure what they are in AIX, but you can Google that. If you run into a roadblock, get back to me and I'll dig out the solution from our archives.

12

MP Server / Re: ARSLOAD issues with Running as a Windows Service on new OnDemand v.10.5 Server

« on: August 31, 2021, 08:43:12 AM »

I have noticed in Windows installations that the parser looking for the 4th filename part starts counting FROM THE END of the filenames.
So if the filenames don't have 8 parts (X.Y.Application.ApplicationGroup.Z.W.ARD.ind for example), it fails to pinpoint the correct file name part.

Try lengthening your file name from TEST1.0.INVOICE.INVOICE to TEST1.0.INVOICE.INVOICE.0.0.0.0 or TEST1.0.INVOICE.INVOICE.0.0.0.ARD and see if it makes any difference.

13

Windows Client / Data update validation

« on: August 31, 2021, 07:39:58 AM »

NOTE TO ALL READERS: This article is NOT orthodox usage of OnDemand. Be warned.

Hey, we have an unfortunate situation where some documents residing in CMOD needs to have their metadata corrected. This is done (by a few privileged users) using the built-in "Update Fields..." functionality in the OnDemand Client.

This of course has multiple impact, one being the discrepancy incurred between CMOD-stored metadata and DB-stored metadata.
The one I wish to ask about however is the risk of PEBKAC ("Problem Exists Between Keyboard And Chair" ) i.e. "human error" during data entry.

Has anyone implemented a well-functioning solution to validate the new data entered by these individuals? Like with a simple data mask, length check etc.

We currently do not have IBM Content Navigator in place, and I am reluctant to suggest a web service using the ODWEK Java API for handling this instead, due to that the size of such a project might be tough to squeeze in before the end of this year.
All suggestions welcome!

PS: Oh, by the way, we are NOT looking for a DDE/OLE solution.

14

MP Server / Re: Issue Starting Load Data Service for first time - Windows Server

« on: August 09, 2021, 05:57:45 AM »

Happy to help! 

15

MP Server / Re: Issue Starting Load Data Service for first time - Windows Server

« on: August 06, 2021, 02:42:31 AM »

This does not quite sound like it, but the most common mistake during new installs is to not run arsstash and create a user + password for the Load Service to use, and/or not to point to the default ars.stash file in ars.cfg/Registry.