Messages

1

MP Server / CMOD and data mining

« on: July 17, 2020, 08:40:05 AM »

Hello,
It's been quite a while since I've been on here, lots of great information here. This is one of those things that I think I may already know the answer but with all the diverse knowledge here I figured it was worth a try. We are working through upgrading all our v9.5 server to v10 and it's proceeding fine. We also use the IBM recommended Datawatch / Monarch (now Altair?) Report Mining Server (RMS). My question is does anyone know if there are any other Windows based applications that do report mining that we could replace Datawatch RMS ? It would also have to be acceptable to IBM in that we wouldn't want to risk being on an unsupported platform. I know IBM's web site lists RMS as the solution they sell but are there any other options out there ? Thanks in advance.

2

OD/WEK & JAVA API / Re: issue with ODWEK, ICN and adding fix pack

« on: December 05, 2019, 08:52:14 AM »

Thanks and I agree. I think the middleware guys are going to have to start over again. Suppose it may have been a little easier if the ODWEK was a separate piece because I think that's all they really need. Either way It'll be up to them to fix and deliver.
Cheers

3

OD/WEK & JAVA API / issue with ODWEK, ICN and adding fix pack

« on: December 04, 2019, 02:53:32 PM »

Hi,
We were working on an upgrade of ICN in prep to get our v9.5 CMOD upgraded to v10. I downloaded the linux binaries ( new ICN instances are on RHL 5.5) for both CMOD 9.5 and then the FP to go to v9.5.0.4 which matches our CMOD app server. The base 9.5 install went fine but the fix pack kept failing. When it did it was coming back with the message that the base 9.5 could not be found. The middleware guys doing the install did check directories etc but can't seem to get past this error. One idea tossed around was what would be the impact of not installing the FP even though the app server is v9.5.0.4. Bearing in mind I know very little about ICN. They have opened a ticket with IBM's ICN team since they manage that environment but I thought the collective wisdom here might have some insights too.
Thanks !

4

MP Server / Re: Issue with CMOD admin client, application and pdf index

« on: November 07, 2019, 11:52:20 AM »

I had a PMR open with IBM and just got the same thing back from them. They say the issue is Adobe as well. Not surprised. Over the years we've had several Adobe products here and it's got a colourful history of issues. Thanks for the replies.
Cheers,
Bruce

5

MP Server / Re: Issue with CMOD admin client, application and pdf index

« on: November 07, 2019, 09:17:57 AM »

Just had a couple of my developers, and myself, give the 32 bit admin client a try and it does work. Seems silly since we have all 64 bit platforms we have to use 32 bit installs but since it works we'll go with it. Thanks for the reply  !

6

MP Server / Issue with CMOD admin client, application and pdf index

« on: November 05, 2019, 01:31:19 PM »

Hi,
It's been a while and since we are finally updating our v9.5 environment to v10.1 I'm sure I'll be back more. We successfully updated our Dev environment to v10.1 and in support of that installed the v10 desktop client and admin installs. I've gone through the process of copying the arspdf file off the server and copying it into my Acrobat plugins directory as per other posts and IBMs recommendation.
However we still have an issue where when you go to Applications, Update, Indexer Information and then change indexer from "ACIF" to "PDF" it greys out the "Modify with sample data". I do have Acrobat 15 and the arspdf.api is in plugins so I'm not sure what the issue is. I made another observation. When I did a registry check I see a bunch of entries of the arspdf.api under the v9.5 software but nothing under v10.1 so that seems a bit odd ? Any help is much appreciated .
Cheers,
Bruce

7

MP Server / CMOD 10 with remote SQL2016 - anyone seen a document for set up ?

« on: October 25, 2018, 08:36:59 AM »

Hi,
Due to a requirement here that all databases are on SQL dedicated servers our CMOD 10 upgrade needs to attach to an SQL 2016 database. I've seen one for setting up a remote SQL 2012 but not SQL 2016. I need an updated document too becasue on Microsoft's web page the downloads have all changed since SQL 2012. Anyone ?
Cheers,
Bruce

8

MP Server / Re: issues with upgrades CMOD 9.5 to 10.1.0.4

« on: October 25, 2018, 06:34:30 AM »

Hello,
Thanks for the reply. We did run through the list of commands as per IBM :
Stop the IBM Content Manager OnDemand server
        arssockd [-I <OD_INSTANCE>] -T
      Install the base IBM Content Manager OnDemand V10.1.0.0
        See the section on your specific platform
      Apply the current fix pack
        See the section on your specific platform
      For SQL Server: Drop the current indexes
            arsdb [-I <OD_INSTANCE>] -efv
      Update the database
            arsdb [-I <OD_INSTANCE>] -uv
      For SQL Server: Create the current indexes
            arsdb [-I <OD_INSTANCE>]-rfv
      Then perform database maintenance
            arsdb [-I <OD_INSTANCE>] -mv
         
      Start the IBM Content Manager OnDemand Server
        arssockd [-I <OD_INSTANCE>] -S
With my PMR and IBM's request we ran the "-uv" command a couple times but no change. I had trouble finding an install / config doc for setting up a remote SQL 2016 database. There's a 2012 one on IBM's site but SQL 2016 has changed and I can't find anything as a guide. I've asked IBM as well but so far no reply. We're using the v11 native ODBC connection and it tests ok. Our DBA says the database looks fine on the server but it's like there's something missing or wrong to make the connection between our app server and SQL server. Any ideas ?
Cheers

9

MP Server / issues with upgrades CMOD 9.5 to 10.1.0.4

« on: October 24, 2018, 08:05:51 AM »

Hi,
Wow where to start. Actually it started with a Java issue in Content Navigator and we moved up our planned 2019 upgrade into now. To set context due to Sun Life policy we have to use a remote database managed by the database team. What we did was :
- stopped LibLibSrvr service in windows
- ran the 10.1 install
- ran the 10.1.0.4 fix pack
- installed PDF indexer
While we were doing that the DBA copied the existing sql2012 database onto a new server and upgraded to SQL2016
- Uninstalled v9.5 which brought up the Configurator where we deleted the 9.5 instance / services
- Set up a new 64 bit ODBC Connection with new alias / server. Test connection worked.
- Ran new configurator and set up new instance
- Ran commands to drop and redo index's ( i.e. arsdb -I <instance> xxxxx)
- rebooted server because the developer wanted to, some other misc things
- Ran arsdate to see version and it came back with v10.1.0.4
- DBA confirmed the ID and password are good on the SQL server, ODBC connection tests ok on the Windows app server
- I perused the registry and it looks like the proper keys have updated to v10.1
- tried to restart the service in both the Configurator and LibSrvr in Windows Services and it won't start
Windows event log we get to consistent errors of event 13 and 151 :
- DB Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'keystore_type'. -- SQLSTATE=42S22, SQLCODE=207, File=arssys.c, Line=3895
- Unable to initialize server database system parameters.  Contact your system administrator.
Also if after running the index commands I try the arrsockd start command I get
- In StartServiceCtrDispatcher  Error number : 1063
We've opened a ticket with IBM but so far it's been more educational than successful.
BTW One thing I noticed it in our other environments as well as using the ODBC we have SQL server / feature pack installed (v2012). I can't find a doc for the requirements of setting up an SQL 2016 remote database and connection. I've asked IBM the same. And to think this all goes back to the Security team pushing a bloody Java update.
Cheers

10

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

« on: June 20, 2018, 11:38:53 AM »

One of the challenges we've had is the fact we use Java with our ICN for viewing reports. We skipped Edge and in the soon-to-be-started Win 10 migration we opted to use IE 11. We also have Chrome but without Java support we turned to IE 11. Now it sounds like that might not work either ? Really makes this a challenge ! I'll be curious to see what guys come up with. I'm trying to engage our browser SME as well.
Cheers

11

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

« on: June 19, 2018, 11:22:50 AM »

Hi,
Sorry I can't help but I'm interested in this too. Our java team is pushing an update that is causing an ICN issue that has me looking at migrating v9.5 up to 10.1.0.3. I also saw the HTML5 info. I've asked my developers to take a look at this along with our ICN support team. If I find anything I'll share and also keep an eye on your post. Good luck
Cheers

12

MP Server / authentication methods for remote SQL database

« on: October 23, 2017, 12:20:02 PM »

Hello,
Environment is CMOD aqpp server on Win2012 server talking to an SQL 2012 DB on another Win2012 server. CMOD v 9.5.0.4

We recently had an issue after the SQL team swapped out our old server onto a new one. We got that resolved but it brought something to light. Keeping in mind that our 3 yr old environment was designed and built by IBM we've made few changes other than versioning up. When the server was replaced I was going about updating the server name to create the updated connection. I noticed that we had matching local ID's on both servers with each one having both admin and RDP rights. That works but the thing that our DBA mentioned was unusual was that the local ID was using Windows authentication not SQL authentication. I basically understand how this works but I was wondering :
1) does anyone else have a remote database, a local ID and what authentication are you using ?
2) is this a CMOD driven configuration by design ? I'm left to think that if the IBM architect designed it that way there must have been a reason.
My chief concern is if our Corp Security guys do an audit they will want us to remove the ID because of the RDP rights.
Cheers,
Bruce

13

MP Server / Re: connecting to new remote SQL server

« on: October 17, 2017, 10:46:59 AM »

Hi Jsquizz,
Good call in that I was able to go in the registry and change the server name so thanks for that ! Still having connection issues but I've engaged the database team so hopefully we get it figured out. Thanks for the suggestion !
Cheers

14

MP Server / Re: connecting to new remote SQL server

« on: October 17, 2017, 09:42:59 AM »

Hey jsquizz it's worth a try. I think I'll back that up first before I go poking around. 

15

MP Server / connecting to new remote SQL server

« on: October 17, 2017, 09:15:51 AM »

Hi ,
A few weeks back I lost my developer to another team and she did all the SQL / database stuff so this is a challenge for me. (I'm not a developer, that's why I have/had one).The database team had to replace the existing dev server last night and also changed the name. When we built our environments we used a functional admin ID so no one would be using their personal one. I've RDP'd onto the server and have gone onto the OnDemand Configurator with the functional ID. I go to the CMOD instance->Properties-> Database-> Advanced Options and I see the name of the existing SQL server but it's greyed out. I can't see where I can update or change the name of the SQL server. I'm really hoping I don't have to delete and recreate the entire instance just to update the SQL server name ? btw We are on CMOD 9.5.0.4 and SQL 2012.  Any help is appreciated.
Cheers