Messages

61

OD/WEK & JAVA API / Re: ODWek REST - Search with SQL - Segment start and stop date

« on: March 09, 2023, 11:49:10 AM »

I'd like to request robust SQL support with access to all fields in the table, for those of us who do "interesting" things. 

-JD.

62

OD/WEK & JAVA API / Re: Can we adjust the ODWek REST max hits

« on: March 02, 2023, 08:55:16 AM »

Moved to the ODWEK/Java API Board.

63

Report Indexing / Re: Character removal question

« on: February 23, 2023, 07:43:43 AM »

Hrm.  Interesting question.

It depends on how you want to 'normalize' the document metadata, so that you can ensure the maximum level of success in FINDING a document you're searching for. 

In the vanilla thick client & ICN, since there's not a lot of options for modifying queries entered by end users to match specific formats (like a US Social Security Number or phone number) it's probably best to just store them as a series of digits in a string.  It doesn't make sense to treat them as numbers -- because you won't be doing comparisons like greater-than or less-than.

If you ensure that SSNs are loaded with spaces, dashes, or dots removed, then ensure that spaces, dashes, or dots are removed at query time, you're dramatically increasing the chance that someone can find what they're looking for.

Hope that helps.

-JD.

64

Report Indexing / Re: Character removal question

« on: February 22, 2023, 10:19:20 AM »

You may also find this interesting if you're loading CMOD Generic Index files, and doing character removal at load time to normalize data:  https://cmod.wiki/index.php?title=Default_Values_and_the_Generic_Indexer

-JD.

65

Content Navigator / Are you interested in CMOD + ICN + Datawatch RMS?

« on: February 15, 2023, 03:30:40 PM »

I've got a customer who is upgrading their entire ECM portfolio, and wants to see ICN v3 + Datawatch RMS support.

I'm wondering who else is in the same boat.

If you don't want to post publicly, just send me a DM, eMail, or give me a call.

-JD.

66

MP Server / Re: New Date Format CMOD 10.5

« on: January 19, 2023, 02:51:55 PM »

Hi Dani.

Querying mixed date formats isn't going to be easy - it's best left to CMOD by using the arsdoc query command.

If you're going to insist on running the queries in SQL, check out the wiki article on date formats:
  https://cmod.wiki/index.php?title=Date_and_Time_formats_in_Content_Manager_OnDemand

You're going to need to determine which tables have old-style date formats and new-style date formats, then convert as appropriate.  There appears to be a built-in function in CMOD called ODDAT that handles the special cases around the different date formats, but I'm not sure that's available to you in DB2.

Let us know how it goes!

-JD.

67

MP Server / Re: Sample Post Processor - Email when a file loads

« on: January 10, 2023, 08:05:15 AM »

Two options that I can see...

A wrapper around arsload that checks the output for successful load message numbers, or arslog. 

-JD.

68

MP Server / Re: does IBM CMOD 10.5 support OCI as its archive storage solution

« on: January 06, 2023, 11:50:50 AM »

If it's not listed, it's not supported.  You can enter it as an enhancement request here on the forums, or talk to your IBM Rep to request it through the official channels.

However, 'unsupported' doesn't mean 'won't work'.  If the APIs are identical to AWS S3 APIs, then CMOD should be able to store and retrieve data from it.  More advanced functions (WORM, etc.) may not be compatible.

If you do go down this path, you'll need to test it extensively.

-JD.

69

MP Server / Re: Oracle Update V17 to V19

« on: December 17, 2022, 03:32:52 PM »

That's only for CMOD version upgrades.

-JD.

70

MP Server / Re: Filtering out/handing file failures

« on: December 14, 2022, 06:39:32 AM »

Consider using arslog to write load failures to a specific directory, and process them hourly/daily?

-JD.

71

Other / Re: CD-ROM installations and missing file

« on: November 24, 2022, 09:34:48 AM »

Probably better off to download an old version of the client and try to use that to access the CD ROM as a server.

Clients prior to v8.5 can be found here:

ftp://ftp.software.ibm.com/software/ondemand/fixes/v841/

-JD.

72

MP Server / Re: TSM Error:ANS1035S (RC406) Options file '*' could not be found...CMOD Down

« on: November 23, 2022, 08:32:00 AM »

Wow.  That's second only to a customer's system administrator *uninstalling* the TSM Client from the server without telling anyone...  Ouch.

I'm happy to hear you're back online!

-JD.

73

MP Server / Re: TSM Error:ANS1035S (RC406) Options file '*' could not be found...CMOD Down

« on: November 22, 2022, 11:08:10 AM »

It's hard to tell, but I'd start with checking the TSM config file directory to see if there have been any changes you didn't know about:

Code: [Select]

# List the directory in reverse chronological order:
ls -ltr /usr/tivoli/tsm/client/api/bin64/
# See the contents of the TSM Options and System file:
cat /usr/tivoli/tsm/client/api/bin64/dsm.opt
cat /usr/tivoli/tsm/client/api/bin64/dsm.sys

-JD.

74

Other / Re: SSL/TLS between CMODi and CMODz

« on: November 22, 2022, 08:33:47 AM »

Hi Greg.

That link was a placeholder for a draft article that I haven't finished yet.

What's the question?

-JD.

EDIT:  I've cleaned up the draft and posted an initial edit.  I'll try to expand it over the next few weeks.

Here's the direct link: https://cmod.wiki/index.php?title=Loading_into_a_remote_CMOD_server_with_SSL_enabled

75

MP Server / Re: TSM Error:ANS1035S (RC406) Options file '*' could not be found...CMOD Down

« on: November 22, 2022, 08:30:44 AM »

There's a problem with your TSM Config files.  Check for recent changes, and refer to your backups to pull earlier versions.

-JD.