Messages

181

Report Indexing / Re: Application group question

« on: May 17, 2021, 04:28:19 AM »

The identifier differentiates the Applications from each other in the Application Group definition.  It seems like you're using the field correctly, athough having an index for that field might not be really effective.

As for your date-related issues, I can think of a few ways to detect the issue (check the System Load App Group for disparities between the load date and the start/stop dates...) but the fix would be tricky unless you start digging around inside the database with SQL.  Even if you fixed the database values in the database, I'm not sure how it would affect the migration of data out of the cache and into secondary storage...  There's probably too many configuration variables for me to say for sure.

I have a morbid curiosity about how to fix this...    Please keep us posted on your progress!

-JD.

182

OD/WEK & JAVA API / Re: Use Arsadmin Hash for file validation

« on: May 05, 2021, 02:36:51 PM »

That only works if you already know the hash for the downloaded file.  You're probably better off using a built-in library to calculate the hash.

-JD.

183

General / Re: ARSSOCKD count climb & High CPU on AIX

« on: May 04, 2021, 12:53:54 PM »

For years now I have been experiencing occasional times on AIX where ARSSOCKD start climbing and won't come down along with high ARSSOCKD usage

What is it that's going up but not coming down?  Threads?  Processes?  CPU time?

Do you have any more diagnostic info you can share?

-JD.

184

General / Re: ARSSOCKD count climb & High CPU on AIX

« on: May 03, 2021, 10:24:06 AM »

AIX / CMOD / DB2 versions?

185

MP Server / Re: Unable to start CMOD V10.5 after upgrade from V9.5

« on: April 28, 2021, 10:30:24 AM »

Likely a bug in code that updates the ars* tables in v10.5.  It's happened before...  So it's good to report it so it gets fixed.

-JD.

186

MP Server / Re: Unable to start CMOD V10.5 after upgrade from V9.5

« on: April 27, 2021, 02:21:25 PM »

Yeah, it looks like there's some missing fields from your ARSSYS table - specifically ones related to data encryption.

Your commands will export, drop, create, and import the data for that table, so should help.

Please open a Service Request and report it as a bug.

-JD.

187

OD/WEK & JAVA API / Re: how to remove a single document added/loaded by ODWEK?

« on: April 21, 2021, 08:55:18 AM »

Because of the way CMOD 'packages' the documents that it stores, you would have to extract the load, modify the file to remove the unwanted documents, reload it, then remove the old load in order achieve what you want.

Alternately, you could use the Enhanced Retention Management module with implied holds, then remove the implied hold from the document you no longer wish to keep, and only the documents with holds would be kept at reclamation time, effectively achieving the document deletion.

Check with your information management team or legal department on how much effort & cost you should invest in this.

-JD.

188

MP Server / Re: ARSUSEC password requirements

« on: April 12, 2021, 06:43:03 AM »

You should probably consider switching to LDAP authentication, so that your enterprise password requirements can be enforced on CMOD with minimal effort.

-JD.

189

OD/WEK & JAVA API / Re: CMOD/ICN view Line Data report via HTML5 viewer

« on: March 30, 2021, 10:22:02 AM »

We're interested.  Please post more info on the process. 

190

MP Server / Re: Issue configuring new environment

« on: March 22, 2021, 08:17:22 AM »

You didn't mention the platform...

If it's AIX, Ed's on the right track - check to make sure you have the XLC libraries.  See here:  https://cmod.wiki/index.php?title=ARS4014E

If it's Linux, check to make sure you have the DB2 links created with db2ln.

-JD.

191

MP Server / Re: APPLICATION GROUP SETTINGS

« on: March 12, 2021, 09:56:16 PM »

Insight is valuable because it's rare. 

-JD.

192

MP Server / Re: APPLICATION GROUP SETTINGS

« on: March 12, 2021, 05:05:59 PM »

I still like to leave query logging enabled for audit, diagnostics, and performance tuning reasons. 

And the performance of the System Log was improved in v10.x - I believe it bundles writes now.

-JD.

193

Documentation / Re: Translating names and values for configuration objects with SQL Server

« on: March 09, 2021, 01:54:28 PM »

Wow...  This is way deep down in the weeds...  While I haven't worked with a CMOD + MSSQL server before, take this with a grain of salt...

The big-picture solution is to make the move to UTF-8.  It looks like you'll need to upgrade to begin resolving the issue.

The ARS_ORIGINAL_CODEPAGE parameter was introduced because historically, the database was built and configured to reflect the local language - so in Norway, your database would be created by default with a Norwegian codepage, and your data would be loaded with the Norwegian codepage, so everything worked...  Setting ARS_ORIGINAL_CODEPAGE to something other than zero allows some backwards compatibility for CMOD servers that were built before Unicode/UTF-* were a feature.

I've done database conversions before (Norwegian specifically!) and they were tricky and required a lot of testing / tweaking in order to work properly and find all of the edge cases -- my favourite edge case was a customer name fields that filled the entire field, and contained two double-byte characters, breaking one out of every several hundred loads, because the data wouldn't fit in the database field, even though it passed whatever testing arsload was doing. 

The best advice I have is to test your migration to UTF-8 throughly, and possibly consider doing a data migration to a whole new system if time and budgets permit.  You'll get the benefit of getting access to all the new features in CMOD v10.x as a bonus. 

194

Report Indexing / Re: Loading large CSV using Generic indexer

« on: March 06, 2021, 12:45:51 PM »

Yup, there's a limit in Excel:  2²⁰ rows:  https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3#ID0EBABAAA=Newer_versions

-JD.

195

Report Indexing / Re: Loading large CSV using Generic indexer

« on: March 05, 2021, 07:30:21 AM »

Hi.  Max rows is for the database table, not documents. 

I'd open a ticket with IBM to see which limitation you're running into -- I haven't seen this specific issue previously.

Is there any chance you could break up this CSV file somehow?  If it's truly archival (i.e., end users won't access it), you could pre-compress it with .zip or .gz, and store it as a binary.

-JD.