Guru Of Geeks

Problem(Abstract) The following errors occur when the DataStage stored procedure stage contains columns of type NVarChar: Message: SP_SADRUPD,0: Error: Datatype not presently supported Message: SP_SADRUPD,0: Error occurred in call to ORPHCallActivePluginInitialize(). Resolving the problem When a DataStage Stored Procedure stage contains columns defined as data type NVarChar, the job fails with the following warning and error messages: Type: Warning Message Id: IIS-DSTAGE-STP-00082 Message: STP_stage,0: Error: Datatype not presently supported Type: Fatal Message Id: IIS-DSTAGE-TODC-00017 Message: STP_stage,0: Error occurred in call to ORPHCallActivePluginInitialize(). The NVarChar data type is not currently supported by the Stored Procedure stage. Change an NVarChar columns to type VarChar then save, compile, and re-run the job.

How to search for a pattern for all files under a given directory and its subdirectory. Examples with in COMMON_TOP we need to find all files that have the word ORACLE_SID in it find /appldev/apps/apps_st  -name "<ORACLE_SID>"

Find the Max file size: [applmgr@xxxxx out]$ ls -lSr -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  6 15:45 o5829172.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  6 15:04 o5829155.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 19:38 o5828959.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 19:38 o5828958.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 16:44 o5814026.out -rwxrwxrwx 1 applmgr oinstall    3704017 Jun  3 16:18 o5812462.out -rw-r--r--     1 applmgr oinstall    4203665 Jun 21 10:39 o5833173.out -rw-r--r--      1 applmgr oinstall   4212642 Jun 24 11:48 o5833667.out -rw-r--r--     1 applmgr oinstall    4790961 Jun 21 10:39 o5833174.out last 10 Users Connected in Putty [applmgr@xxxxxx out]$ last -10 applmgr    pts/3        192.168.1.135       Mon Jul  1 09:59   still logged in root          pts/4        192.168.1.139        Sat Jun 29 11:49 - 11:53  (00:04) root          pts/3        :1.0                         Sat Jun 29 11:45 - 11:53  (00:08) root   ...

Connect as system and run the following query. ​ ​​ ​​ alter database datafile 'C:\app\administrator\oradata\odi\USERS01.dbf' resize 1000m ;​

When attempting to open a job log in Director, user gets the following error message: Error selecting from log file RT_LOG### Error was: Unable to open DICT 'RT_LOG###'. This is because the D_RT_LOG file is missing from the projects directory. To solve this issue simply copy D_RT_LOG from another project to the project directory that is missing this file. That's it.

​ Unable to open jobs with error "Unable to open the Job Unable to load RID - c2e76d84.43058877.7e01af4f.cd92bbcd-2ebc-4cb3.833e.37a962373ef7" Also in SystemOut.log file, it has the following: [8/25/10 21:21:46:475 UTC] 000000b1 SystemOut O 2010-08-25 21:21:46,475 ERROR ojb.OjbPersistentEObjectPersistence - java.lang.OutOfMemoryError Solution : 1) Try to restart the DS Client and reopen the job 2) Increasing Java Virtual Machine (JVM) Heap will resolve this problem. Here are the steps to do this:     Log into the WebSphere Application Server administrative console.     Select Server > Application Servers and select the <ServerName>.     In the Configuration tab, navigate to Server Infrastructure > Java and Process Management > Process Definition > Additional Properties: Java Virtual Machine     Edit the field Maximum Heap Size. If the default is not specified then it assumes 256. Note: A value greater than 512 MB will improve the perfor...

#!/usr/bin/ksh # Declares a Korn shell ############################### # # ##!/usr/bin/sh # Declares a Bourne shell # ##!/usr/bin/bash # Declares a Bourne-Again shell # ##!/usr/bin/csh # Declares a C shell # ##!/usr/bin/tsh # Declares a T shell # # # # # # SCRIPT: DSgetJobLocks.sh # # DATE: Mar 04, 2014 # # # # # # PLATFORM: (AIX, HP-UX, Linux, Solaris & All Nix ) # # # # # # PURPOSE: This script optionally take arguement and provide the ites locked by # # the user, if no arguement is passed if will give the locked item list for all # # # # # # # Usage : # # ./DSgetJobLocks.sh # # ./DSgetJobLocks.sh atul vibha peter mahei ############################################################################     usr= " $* " user= ` echo " $usr " | sed ' s/ /|/g ' ` echo $user   DS_HOME= ` . /opt/IBM/InformationServer/Server/DSEngine/dsenv ` cd $DS_HOME   echo " " echo " INODE US...