Technovolve

Many ECM vendors have tried integrating their systems with Microsoft Office Applications, building custom plug-ins, and add-ons to have users work with content/meta-data from the office applications. This was the only feasible solution with pre-Office 2003 limitations to develop intelligent documents.

With Microsoft Office 2007 (MOSS), Microsoft offers a framework which is more usuable and in-line with the business needs. Intelligent documents can be developed in organizations using the following features:

• InfoPath 2007 extended capabilities
• Visual Studio support for Office Applications
• Document Information Panels
• Custom Task Pane (CTP)
• Custom Ribbons

Let us assume that an Apache Tomcat instance (Tomcat1) is currently installed as a windows service on an application server that uses port 80. There is a need to launch another Apache Tomcat instance (Tomcat2) as a windows service that uses port 7001.   

The following steps need to be performed:

1. Download the Tomcat deployment package and extract it onto the application server, say C:\jakarta-tomcat-5.0.28 (Tomcat2)
2. Modify the server.xml (Tomcat2) changing the port numbers making sure they do not colliode with the port numbers specified in server.xml (Tomcat1)
3. Create a environment variable CATALINA_HOME2=C:\jakarta-tomcat-5.0.28
4. Modify the Tomcat startup/shutdown scripts to change the CATALINA_HOME to CATALINA_HOME2
5. Install the windows service using the following command:
   

   Tomcat5.exe //IS//Tomcat51 –StartClass org.apache.catalina.startup.Bootstrap –StopClass org.apache.catalina.startup.Bootstrap –StartParams “-config;C:\jakarta-tomcat-5.0.28\conf\server.xml;start” –StopParams stop –StartMode jvm –StopMode jvm –Startup Manual –Description “Another Tomcat Instance” –DisplayName “Apache Tomcat51″ –JvmOptions “-Dcatalina.home=C:\jakarta-tomcat-5.0.28;-Djava.endorsed.dirs=C:\jakarta-tomcat-5.0.28\common\endorsed;-Djava.io.tmpdir=C:\jakarta-tomcat-5.0.28;-Djava.library.path=C:\Program Files\Documentum\shared” –LogPath “C:\jakarta-tomcat-5.0.28\logs” –LogPrefix “tomcat51_” –StdOutput “C:\jakarta-tomcat-5.0.28\logs\Tomcat51_out.log” –StdError “C:\jakarta-tomcat-5.0.28\logs\Tomcat51_err.log” –Jvm “C:\j2sdk1.4.2_05\jre\bin\server\jvm.dll” –JvmSs 256KB –JvmMx 128MB –JvmMs 256MB –JavaHome “C:\j2sdk1.4.2_05\jre” –Classpath “C:\jakarta-tomcat-5.0.28\bin\bootstrap.jar;C:\Documentum\config”

6. Install the WDK applications

1. Retrieve the workflow that needs to be uninstalled
   

   SELECT r_object_id, object_name, r_definition_state FROM dm_process WHERE object_name = ‘<Name of Workflow>‘

2. Change the definition of the workflow to DRAFT (0 = Draft)
   

   UPDATE dm_process OBJECT SET r_definition_state = 0 WHERE r_object_id = ‘<r_object_id retrieved in step 1>‘

3. Change the definition of the activities corresponding the above workflow to DRAFT (0 = Draft)
   

   UPDATE dm_activity OBJECT SET r_definition_state = 0 WHERE r_object_id IN (SELECT r_object_id FROM dm_activity WHERE r_object_id IN (SELECT r_act_def_id FROM dm_process WHERE r_object_id = ‘<r_object_id retrieved in step 1>‘))

4. Verify that all activities are in the DRAFT state
   

   SELECT object_name, r_definition_state FROM dm_activity WHERE r_object_id IN (SELECT r_act_def_id FROM dm_process WHERE r_object_id = ‘<r_object_id retieved in step 1>‘)

Finally got Documentum successfully installed on an Ubuntu platform.

• The Content Server software got installed with no issues.
• Keep in mind to run the dm_root_task before configuring any repositories

When configuring a new repository, the installation fails to execute the scripts after creating the database for the repository. Failure – Authentication failure for the repository owner with a blank password. Follow the following steps to turn off authentication, until the repository is successfully installed:

1. Change directory to the Documentum dba location ($DOCUMENTUM/dba in a default installation):
   

   cd $DOCUMENTUM/dba

2. Create a script that will be called by the server to validate passwords and always return success. Create a file named ‘dm_nocheck_password’ with the following lines:
   

   #!/bin/sh
   exit 0

3. Change permissions on this file so it is executable and read/write by the dmadmin account:
   

   chmod 4750 dm_nocheck_password

4. If the headstar.dql, formats.dql and wsconfig.api script have been executed (or a custom version of them) then skip to the next step. Otherwise, execute these scripts now. The script ‘dm_apply_headstart’ in DOCMENTUM/dba/config/ will execute all three. If you cannot connect to the docbase, log into the UNIX host machine directly as the docbase owner. You will then not have to supply a password for IDQL or IAPI since you already did logging into the server.
5. In IDQL execute the following DQL as the Docbase owner or dmadmin superuser:# Substitute in the full path for the file_system_path directory
   

   create dm_location object
   set object_name=’novalidate_user’,
   set path_type=’file’,
   set file_system_path=’<file_system_path>/dba/dm_nocheck_password’
   goupdate dm_server_config object
   set user_validation_location = ‘novalidate_user’
   goexec reinit
   go

6. This changes the user validation location in the server config object to point to a new location object which is the file we created in step 2.

To turn the password validation back on, do the following:

1. In IDQL execute the following DQL as the Docbase owner or dmadmin superuser:
   

   update dm_server_config object
   set user_validation_location = ‘validate_user’
   goexec reinit
   go

Note: Sometimes the validation does not work as expected! You will have to keep logging into the repository using IDQL or IAPI so you could keep a session active for the installer to use. Try re-executing the scripts until success.

Statement on Auditing Standards (SAS) No. 70, Service Organizations, is a widely recognized auditing standard developed by the American Institute of Certified Public Accountants (AICPA). Service organizations or service providers must demonstrate that they have adequate controls and safeguards when they host or process data belonging to their customers.

• The issuance of a service auditor’s report prepared in accordance with SAS No. 70 signifies that a service organization has had its control objectives and control activities examined by an independent accounting and auditing firm.
• SAS No. 70 provides guidance to enable an independent auditor (“service auditor”) to issue an opinion on a service organization’s description of controls through a Service Auditor’s Report.
• SAS No. 70 is generally applicable when an independent auditor (“user auditor”) is planning the financial statement audit of an entity (“user organization”) that obtains services from another organization (“service organization”).

In addition, the requirements of Section 404 of the Sarbanes-Oxley Act of 2002 make SAS 70 audit reports even more important to the process of reporting on the effectiveness of internal control over financial reporting.

Source: http://www.sas70.com