AWS region selection help URL

Hi,

I found one URL which is very helpful choosing the region while creating any new service. If you are not sure try it -

Navigate to the below link
https://www.cloudping.info/

Click on HTTP Ping

You should see the latency details and based on that you can choose the region -

Issue 01- No valid crumb was included in the request while configuring git with Jenkins

Hi,

Received Error -
No valid crumb was included in the request while setting git url from github in Jenkins Job configuration


Solution -

Enable the below checkbox and the error will be gone.

Angular getting started - part 1

Angular Getting Started

                                                                   

Prerequisites – Knowledge of Typescript, Basic HTML and CSS

Installation in windows

  Prerequisites:  Node.js and NPM

Make sure you have node and npm installed. Below commands should return response

·         node -v

·         npm -v

Command to install angular

                npm install -g @angular/cli

Note: if you under corporate proxy you might have to configure proxy to npm work properly

Verify successful installation and check version

                ng –version

To create project

                ng new <project_name>

                example: ng create my-first-angular-project       

               

To launch Angular application

ng serve

                To launch to different port than default

                ng serve –port 8080

Note: First time ng serve gave me error like ' The serve command requires to be run in an Angular project, but a project definition could not be found'

Solution: I was not inside the project folder so move inside the project folder and run the command again and It works. (Funny 😊).

Webpack –

                                Angular uses webpack build automation tool. The technique is also known as - HMR - HOT Module replacement / Hot module reloading. It means you do not need to restart the application for any changes in the component.

Create a component using angular cli

ng g c <componentName>

ng g c courses

To Create component inside of another component

ng g c Courses/course-details --skipTests

Note- skipTests can be used if you don’t want to generate test file for the component

Create a service using angular cli

ng g s [serviceName]

continued….

GIT Command reference

Below is list of git commands for quick reference

Initialize git with new Folder

git init [ProjectFolder] 

example - git init sample-git-demo

Initialize git with existing Folder

Navigate to existing folder and execute git init

Display modified files in the working directory vs Git's staging area.

git status

Add new or newly modified filename to Git's staging area

git add [filename]

To add recursively all new and newly modified files.

git add .

Commits all files in Git's staging area

git commit -m "First Commit to git"

Below command to directly commit newly modified already committed files

git commit -am "Second Commit to git"

Reset File from Git's staging area

git reset HEAD [filename]

Checkout last committed version from Git

git checkout -- [filename]

Display Git log history

git log

Creating a remote repository reference

git remote add origin [full URL for the remote repository]

List Git's Remote repos

git remote -v

Send Changes to Remote - The -u parameter is needed the first time

git push -u [RemoteName] [BranchName]
git push [RemoteName] [BranchName]

Receive Changes from Remote

git push [RemoteName] [BranchName]

About WebRTC

I was/am highly impressed by WebRTC so started exploring different things related to it.

To start with the basic definition of WebRTC -

WebRTC (Real Time Communication) is a free, open project that provides browsers and mobile applications with Real-Time Communications (RTC) capabilities via simple APIs. It has inbuilt security and encryption functionality which is making it more valuable.

Use cases are -

• Video Chat
• Screen Sharing
• File Sharing

Emerging Use Cases are

• IOT
• Healthcare
• Real time Team Collaboration

There are some brilliant sites available, describing the capabilities and usage of WebRTC and for understanding the basic -

https://webrtc.org/

https://blog.sessionstack.com/how-javascript-works-webrtc-and-the-mechanics-of-peer-to-peer-connectivity-87cc56c1d0ab

One stunning demonstration is in the link below. Open it in Chrome.

https://webrtc.github.io/samples/src/content/capture/video-pc/

Some live saving facts about day to day activity in documentum environment

Below are some facts which I personally think very useful. Hope you guys finds the same.

Fact -1 

You want to change the content of a document to test something very quickly. Many times for some unknown reason UCF error is one of the hurdle in your way, so in such scenario using below API you can do it very easily-


retrieve,c,dm_sysobject where object_name='test.xml'
checkout,c,l
setfile,c,l,'[TempLocation]\test.xml',xml
set,c,l,log_entry
Testing the xml content
checkin,c,l

Fact - 2

Quick way of Cleaning up dmi_queue_item table - garbage entries of full text users.

dmi_queue_item is one of the table which is responsible for performance of your system functionalities like workflows.
Many time, I noticed we have entries of full text index users which does not make sense, may be because of upgrade or failed index requests or removal of index agents.

To clean up, you can follow the below steps -
1. Shutdown your repository services.2. take back up of the table by using below command -

exp USERID=<schema_user>@<schema_name> FILE=<schema_user>_dmi_queue_item_s.DMP LOG=<schema_user>_dmi_queue_item_s.LOG full=n TABLES=dmi_queue_item_s consistent=y compress=y statistics=none BUFFER=2000000 RECORDLENGTH=64000

3. Execute below queries

SQL:

CREATE TABLE dmi_queue_item_s_backup AS (SELECT * FROM dmi_queue_item_s where name !='dm_fulltext_index_user');

truncate TABLE dmi_queue_item_s;

insert into dmi_queue_item_s select * from dmi_queue_item_s_bkp;

drop table dmi_queue_item_s_backup;

PURGE recyclebin;

You can manage user events according to your need.

4. Restart your repository services.

FACT - 3

For version mismatch error during workflow activities -
I found setting up below parameters resolved most of the issues

retrieve,c,dm_docbase_config 

dump,c,l

append,c,l,r_module_name

WF_SKIP_PARALLEL_TASK_EXECUTION

append,c,l,r_module_mode

1

save,c,l

retrieve,c,dm_docbase_config 

dump,c,l

To be continued ...

Quick start for npm under proxy [POC/Learning purpose only]

NPM (Node Package Manager) is the default package manager for Node.js. Setting up NPM for downloading packages, one common issue is working behind the corporate proxy. 

Below is a workable solution - 

Fire up your command line and type in the following:

npm config set proxy http://<proxy_user_id>:<password>@<proxy_url>:<proxy_port>

npm config set https-proxy https://<proxy_user_id>:<password>@<proxy_url>:<proxy_port>



Note: For https_proxy url starts with https.



If you get error like "SSL routines:ssl3_get_record:wrong version number" then you have problem with the entry you made above for https_proxy.

• If SSl not configured properly then try not to use https_proxy command above.

There is one file which maintains all entries related to npm - C:\Users\<account_id>\.npmrc See if you have proper entries inside of that. You can make the changes there as well.

Performance degradation after upgrading Oracle database from 11g to 12c for documentum applications

I faced major performance issues when I upgrade database environment for one of the system from 11g to12c (12.1.0.2.0). Front end application is Document D2.

Here is my analysis -

In Oracle 12.1 the adaptive optimizer features are controlled by the OPTIMIZER_ADAPTIVE_FEATURES parameter, which was set to TRUE by default.

This is introduced to better estimate statistics and optimize plans. In some system,  this lead to the performance issues.


SOLUTION -

I found the below tuning works for my environment

Use the following system setting to disable Adaptive Query Optimization:

ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES = FALSE SCOPE=BOTH; 

Also there are some tables which still contains statistics, so have to flush them out as well to get the better result. Contact your DBA team with these details.

IMP-00010: not a valid export file, header failed verification - ERROR during oracle database schema import

Hi Everyone,

This is one of the error which I received while trying to import database dump exported from another oracle database version as part of migration activities. It took me some time to work out the things -

Error Received during import of schema: 

                          IMP-00010: not a valid export file, header failed verification

Schema dump exported from oracle version:

                          V12.01.00

Schema dump imported into oracle version:

                           V11.02.00

 From oracle note available in web:

                           If you are running Oracle Database 12c Release 1 (12.1.0.2) and specify VERSION=11.2 on an export, then the dump file set that is created can be imported into an Oracle 11.2 database.

It means I must redo the export again which I cannot afford due to some time constraints.

Quick and dirty resolution I work out which works:

 1. First I checked the content of the DMP file with the help of some commands, then I noticed there is one line with the version number inside of DMP file. If you can execute Unix commands, then try 

                       head -5 {dump_file_name}.DMP

Result shows like below -

                       gEXPORT:V12.01.00 

 2. I replaced the line with version of the target oracle instance by below command-

                       sed 's/gEXPORT:V12.01.00/gEXPORT:V11.02.00/' {dump_file_name}.DMP > {dump_file_name}_new.DMP

3. Then try to import the new DMP file i.e. {dump_file_name}_new.DMP and guess what?

It successfully imported into new schema. Do let me know if it helps you. 😊