Dollar Universe for Beginners

Solved : S_DATRAIT is 000000

Mon, 09 Aug 2010 17:40:01 +0200

I would like to use the Processing Date (S_DATRAIT) in my Uproc but it is always returning 00000000. The Uproc Type is a CL_INT and is defined as:

CODE

echo S_DATRAIT: %S_DATRAIT%
echo S_DATRAIT_E: %S_DATRAIT_E%
echo S_DATRAIT_X: %S_DATRAIT_X%
echo S_DATRAIT_A: %S_DATRAIT_A%
echo S_ESPEXE: %S_ESPEXE%
echo S_NUMLANC: %S_NUMLANC%
echo S_CODSESS: %S_CODSESS%

::%UXEXE%\uxdat "yyyymmdd" %S_DATRAIT% "yyyymmdd" "-8d"

call %RBA_CMD_PATH%\du_StatusPurge.cmd %S_DATRAIT%

In the job log I see:

CODE

C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>REM 	3 - Launching the uproc script shell 
C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>set RESEXE=1 
C:\WINDOWS\system32>call   "D:\RBAI52\tmp\AA0000217.bat" 
C:\WINDOWS\system32>echo S_DATRAIT: 00000000 
S_DATRAIT: 00000000
C:\WINDOWS\system32>echo S_DATRAIT_E: 00000000 
S_DATRAIT_E: 00000000
C:\WINDOWS\system32>echo S_DATRAIT_X: 00/00/0000 
S_DATRAIT_X: 00/00/0000
C:\WINDOWS\system32>echo S_DATRAIT_A: 000000 
S_DATRAIT_A: 000000
C:\WINDOWS\system32>echo S_ESPEXE: A 
S_ESPEXE: A
C:\WINDOWS\system32>echo S_NUMLANC: 0000315 
S_NUMLANC: 0000315
C:\WINDOWS\system32>echo S_CODSESS: T_JOBPURGE 
S_CODSESS: T_JOBPURGE
C:\WINDOWS\system32>call D:\RBAI52\_rba\du_StatusPurge.cmd 00000000 

I see some of the variables being set properly - S_ESPEXE, S_NUMLANC, and S_CODSESS. Do I have to do anything to set this Processing date? I am running the task in the Application area using Windows and DU version 5.3.3

Thanks for any help you can provide.

-Bill

Regarding Mutliple Task.

Mon, 19 Apr 2010 14:56:41 +0200

Hello ,

I have created a TASK to run at 10:04, 12:04, 14:04, 16:04 i.e., Scheduled-Multiple during 16:50 (duration for which it can run) and have given it as "Serial Launch" initially which I later changed to "Parallel Launch" . During Serial launch , it ran once at 10:04 and didnt run again as desired .Even after I made it parallel , its not working fine .

Can any one please suggest me where it might have gone wrong. Attache is the snapshot of the TASK.

Solved : Processing date -1 in task

Mon, 28 Jun 2010 15:23:26 +0200

Hello ,

My requirement is as follows :-
Will have 3 Uprocs in a session XXXXX
XXXXstr -> initialization of variables (say VAR1 everytime initialized to system date until I manipulate)
XXXX010 -> call a job by passing variables (VAR1 to a job)
XXXXEND -> no role to play but for a structure.

Now my requirement is that I have to pass "System date -1" in VAR1 to the job.
I know that it can happen by manipulating var1 in XXXXXstr and there by passing it to Job in 010.

But please let me know if it also can happen in the following way :-
Will create a TASK with "Processing date - 1 offset" in the functional data
Will not touch VAr1 in XXXXstr (i.e., will be SYSTEM date as it got initialized)
in 010 will pass it to the job.

Will the task where the processing date is "offeset to - 1" take care ? If not what is the significance of that Processing date offset ?

Solved : Need to get day before the date given in Processing date "S_DATRAIT"

Mon, 28 Jun 2010 08:43:49 +0200

Hello ,

My requirement is as follows.
I have to create a TASK on a session XXXX whcih contains 3 Uprocs (XXXXSTR,XXXX010,XXXXEND).
Structure of session XXXX is as follows :-
XXXXstr->XXXX010->XXXXend.

While launching the session , the Processing date S_DATRAIT will be passed . Now I need to get the day before that processing date . My operating system is UNIX.

Ex:-
Processing date is "20091231" .
Now I shud get the vallue of "20080101" (processing date -1 ) in to a variable .
Is there any way how I can get it or if u have a Unix script please provide the same?

Solved : Unable to set RESEXE

Wed, 09 Jun 2010 17:47:23 +0200

Hello All,
I'm very new to $U, and even newer to this forum. I have a question that searching through the manuals and this forum is not being answered and I hope someone here can help.

I'm using an external script (Windows Command) that when completes normally, I am trying to set RESEXE to "0" so that the monitor will show a Completed status. No matter what I do, I get an Aborted status.

I am currently using: set RESEXE=%exitCode% (where I know %exitCode% is "0")

The last part of the log is:

CODE

D:\RBAI52\tmp>set exitCode=0 
D:\RBAI52\tmp>goto End 
D:\RBAI52\tmp>set RESEXE=0 
C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>REM 	4 - Run, if exists, customized Post Uproc routine 
C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>if EXIST D:\RBAI52\mgr\U_POST_UPROC.bat call  D:\RBAI52\mgr\U_POST_UPROC   
C:\WINDOWS\system32>REM  ====================== 
C:\WINDOWS\system32>REM  ====================== 
C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>REM 	5 - UNIVERSE technical job ending 
C:\WINDOWS\system32>REM	----------------------------------------------------------------------------------------------- 
C:\WINDOWS\system32>REM
C:\WINDOWS\system32>if NOT EXIST D:\RBAI52\exec\uxjobstatus.exe goto U_BATCH_TERM_UXJOBEND 
C:\WINDOWS\system32>D:\RBAI52\exec\uxjobstatus 1 
C:\WINDOWS\system32>if NOT (2) == (2) set RESEXE=2 
C:\WINDOWS\system32>erase    "D:\RBAI52\tmp\X0000265.bat" 
C:\WINDOWS\system32>erase    "D:\RBAI52\tmp\XX0000265.bat" 
C:\WINDOWS\system32>D:\RBAI52\exec\uxjobend 1 
C:\WINDOWS\system32>exit

I've also attempted to include a U_POST_PROC.bat - which when using echo to display %RESEXE% shows the value at "1", and also using a
uxset var RESEXE=%exitCode% in the external script, but that returns UXSET UxCmd_LoadUniverse Failed.

Any help you can provide would be very much appreciated.
Thanks,
-Bill

Solved : .def File

Thu, 17 Jun 2010 19:59:44 +0200

Could anyone tell me if and how the custom environment file ".def" is loaded. I have added a value and cannot access this new variable in my U_ANTE_UPROC.bat file.

The batch file uxsetenv.bat looks very similar to the file UNIVERSE.def and it contains a reference to the batch file %UXMGR%\uxsetenv_.bat. I do not have a batch file uxsetenv_.bat. Are these environment setting batch files created on installation using the .def files and therefore something went wrong since I do not have a uxsetenv_.bat.

Should I just create a uxsetenv_.bat file and add the new environment variables that I need, or should I use the U_ANTE_UPROC.bat to set the environment variables.

Thanks,
-Bill

Solved : retrieving session name ?

Thu, 17 Jun 2010 12:59:24 +0200

hi

is there a variable that contains the name of the current session ?

i didn't find it in the manuals ...

for example, i know that $S_ESPEXE displays the space where the uproc is currently executed.

sylvain

Solved : How to use "uxMIN_RUN_TIME"

Sun, 06 Jun 2010 08:39:11 +0200

Hi All,

I have 1 uproc which uses variable "uxMAX_RUN_TIME". Value given for this variable is 45. so whenever this uproc runs for more than 45 minutes it will send alert to (mobile or pager) respective application team. i have attached a file to represent this.

Now i want to know about the variable "uxMIN_RUN_TIME". i have some questions for this varibale.

How this variable (uxMIN_RUN_TIME) works or what is the functionality of this variable?
How can we use this variable?
Where we have to set the alert mechanism for this variable to throw alert to respective team?

Also if someone can attach the screenshot, it will be helpfull. Thanks in advance.

Thanks.

Solved : Disabling UPROC in a Session

Tue, 08 Jun 2010 16:43:11 +0200

Hi,

There is a requirement in our project to disable certain UPROCs of a particular session.

Is there any best practice method of acheiving this ? It would be desirable not to remove the UPROC from session level or to edit the CL_INT code.

Please help.

Regards,

Solved : How can we delete monitoring configuration

Tue, 01 Jun 2010 11:01:04 +0200

Hi,
I have created one monitor and added some 10 nodes in that for testing of uprocs (either they are running or aborting).
Now when i am finished with my testing i want to delete that monitor but not able to do so.
when i right click and select delete, it gives me below error.

""Delete Monitoring Configuration in error.
Reason: Deletion impossible : rule unknown""

can any one help me to delete them.

Thanks,
Gaurav

Solved : Problem while passing variables

Thu, 08 Apr 2010 15:55:33 +0200

Hello ,

I will have to pass few variables from Dollar-Universe to a job which is being called in my UPROC.
My requirement for the variables is like this .
Variable 1) G_GVA_MIN_DT of type date and the default value shoud be NULL. How to achieve passing NULL in $U as everytime it will prompt me to select date. Is there any way how can I do it ?
else I will have to declare the variable G_GVA_MIN_DT as text and convert it to DATE using TO_DATE function. Again when I define it as character , do I need to leave it as it is or should I initialize to '' for it to pass NULL after conversion to date.
Variable 2) G_LOAD_MODE��which should be defaulted to 'Delta Load' and my script is reading only till 'Delta as there is a space there.Please let me know how to deal with it.

Please help me in this.

Solved : Several tasks with the same uproc ?

Wed, 28 Apr 2010 15:00:49 +0200

hi

I've created a uproc with 2 variables (VAR1 and VAR2) and I'd like to launch it at 8:00 with VAR1=A and VAR2=B, and at 13:00 with VAR1=C and VAR2=D.

I thought that I just have to create 2 tasks but while i am saving the second task, i have an error message saying that the task already exists.

what did I wrong ?
is there another way to do that ?
using session maybe ?

thanks for your help,

sylvain

Solved : Problem with exporting an object

Tue, 13 Oct 2009 14:28:22 +0200

Hello ,

I encountered the following error while exporting an UPROC.

C:\Universe\CDBTST\exec>uxext UPR=B01 MU=T02_MU1 NODE=dwhdev
The Subject (UPR=B01) is not enabled with this Verb

Again I want to know the result of this command "uxext" like, will it export a file (to some specific path) which can again be imported in to $U ?

Thanks in advance

Solved : Processing date in dependancies.

Thu, 22 Apr 2010 16:51:20 +0200

Hello ,

I have a Session which contains some 10 Uprocs..
like U1 , U2 , U3 , U4, U5 ..UEnd.

The UEnd shud run only if 7 of the 9 other Uprocs run . Dependancies are created accordingly in the UEnd. When the task (the task Processing date is Offset-2) imposed on that session gets launched everything runs fine other than the UEND and its processing date is shown as 00/00/0000 and it depends on U1 for the sysdate i.e., getting in to Event-wait status.
Even when I individually launch that Uproc , same is the case.

can u pls let me know what can be checked.

Solved : Though my script runs fine, my UPROC fails

Tue, 20 Apr 2010 17:25:24 +0200

Hello ,

I have a UPROC which runs one more script and the status of the UPROc depends on the execution of the script. So if the job runs succesfully , my UPROC should be with COMPLETED status else with ABORTED status.

But in this case my UPROC is getting aborted though my Script is executed succesfully. Below is the content of the script of the UPROC for your reference.

#!/bin/ksh
###=============================================================================
#@(#) OBJECT: BODI XI Trigger
#@(#)
#@(#) VERSION: 0.0.2
#@(#)
#@(#) AUTHOR: Sanjeev
#@(#)
#@(#) CREATION DATE: 2010/03/31
#@(#)
###=============================================================================
return_code=1

### Variable U_SET_DATE is set in U_ANTE_UPROC
### Variable ENVIRONNEMENT is set in U_ANTE_UPROC depending on company & space
### Variable LOG_DIRECTORY is set in U_ANTE_UPROC depending on company & space
### Variable BO_JOB is set in UPROC with the name of the job to be executed

###======================
### Start the job in BODI (parameters can be removed and added as required)
###======================
/bo/bodi/scripts/launchJobDefault_${ENVIRONNEMENT}.sh ${BO_JOB}
"G_RECOVERY_FLAG='$G_RECOVERY_FLAG';G_GVA_MAX_DT=to_date('${G_GVA_MAX_DT}','YYYY.MM.DD');G_GVA_MIN_DT=to_date('${G_GVA_MIN_DT}','YYYY.MM.DD');"
return_code=$?

echo "/bo/bodi/scripts/launchJobDefault_${ENVIRONNEMENT}.sh ${BO_JOB}
G_RECOVERY_FLAG='$G_RECOVERY_FLAG';G_GVA_MAX_DT=to_date('${G_GVA_MAX_DT}','YYYY.MM.DD');G_GVA_MIN_DT=to_date('${G_GVA_MIN_DT}','YYYY.MM.DD');"

###====================
### Display logs
###====================
TRACELOG=`find $LOG_DIRECTORY -name "$BO_JOB*trace.txt" | tail -1`
ERRORLOG=`find $LOG_DIRECTORY -name "$BO_JOB*error.txt" | tail -1`
echo "============================================================== TRACE LOG======================================================="
head -2000 $TRACELOG
echo "===========================================================END OF TRACE LOG==================================================="
echo "============================================================== ERROR LOG ======================================================"
if [$ERRORLOG = ""]
then echo "No Error File"
else head -1000 $ERRORLOG
fi
echo "===========================================================END OF ERRORLOG==================================================="

###====================
## End
###====================
echo "Exit Code : $return_code"
exit $return_code

The job log is attached for your reference.

The Job on my server has got executed succesfully i.e., the below piece of code resulted 0 where as the UPROC got aborted.
/bo/bodi/scripts/launchJobDefault_${ENVIRONNEMENT}.sh ${BO_JOB}
"G_RECOVERY_FLAG='$G_RECOVERY_FLAG';G_GVA_MAX_DT=to_date('${G_GVA_MAX_DT}','YYYY.MM.DD');G_GVA_MIN_DT=to_date('${G_GVA_MIN_DT}','YYYY.MM.DD');"

Solved : Problem Listing ALL Future Launches

Tue, 13 Apr 2010 17:18:33 +0200

Hello,

for an automatically process to add exclusion windows for our system maintenance I'm trying to
create a small script like this. The script should read alle launches which will start in the given
timeframe.

CODE

$UXEXE/uxlst FLA FULL STATUS=L MU=MU1 EXP since=13/04/2010,1600 before=13/04/2010,2000 | tail +5 > /tmp/output.tmp

while read LINE
do
    #extract all the info you need
    _ses=`echo "$LINE" | awk '{ print $1 }'`
    _upr=`echo "$LINE" | awk '{ print $2 }'`
    _mu=`echo "$LINE" | awk '{ print $3 }'`
    #_datestart=`echo "$LINE" | awk '{ print $6 }'`
    #_timestart=`echo "$LINE" | awk '{ print $7 }'`
    #_dateend=`echo "$LINE" | awk '{ print $8 }'`
    #_timeend=`echo "$LINE" | awk '{ print $9 }'`
    
    _timenow=`$UXEXE/uxtim NOW "dd/mm/yyyy,hhMM"`
	_timeend=`$UXEXE/uxtim NOW "dd/mm/yyyy,hhMM" "+4h"`
    
	echo $_mu $_ses $_upr $_timeend    
	
	$UXEXE/uxupd TSK EXP SES=$_ses UPR=$_upr MU=$_mu INTERVAL add EXCLUSION="($_timenow,$_timeend)"
    
done < /tmp/output.tmp

The code is running without any errors, but we still have a problem.
Not all launches in the timeframe will be shown by the uxlst command.
When a launch is planned with an short intervall of execution, the launch
will be in Launch wait state only a few minutes before, so in the moment we execute the uxlst command
this "high intervall" launches often aren't listed.

Ist there any solution for this problem?

Regards,
Simon

Solved : Variable name containing "FLAG" is not allowed

Wed, 07 Apr 2010 11:54:32 +0200

Hello ,

Please note that I am encountering an error "Invalid Variable Name" when I try to create a variable with name "G_RECOVERY_FLAG" may be because of the fact that the variable name contains "FLAG" in it ,because I am able to create something like "G_RECOVERY_ZZFLAGZZ" i.e., prefixing & postfixing the FLAG keyword by ZZ.

Actually I will have to use the same variable ""G_RECOVERY_FLAG" as that is defined in my job which is very difficult to get changed. Please suggest me how to surmount this probem.

Thanks in advance.

Regards,
Sanjeev G.

Solved : Processing date != scheduled date

Thu, 18 Feb 2010 15:05:50 +0100

can anyone shed any light on this problem?

Unix, $U 5.1
Create a Rule for the 1st Sunday each month:
Period: 1 month
Position: 1 from beginning
Offset: next
Days of week: Sunday only
(no days or months tab on this version)

Create a task using this rule, no offset for the processing date.
Simulate this task.
Results show:
the Start date to be the 1st Sunday, i.e. 03/01/10, 07/02/10 (correct)
the Processing date is the 1st of the month, i.e. 01/01/10, 01/02/10.

This seems to me to be wrong. Events from this task are logged using the processing date, but Uproc dependencies are looking for events with the scheduled date, so the job never completes.

Repeating this exercise on our windows server, running $U 5.3 shows the simulated processing date matches the scheduled date, as I would expect.

Can anyone explain the difference, and tell me how to get the dates to match on v5.1?

The 5.1 version is the latest we can manage on our old version of unix, so no, we can't upgrade.

thanks

Solved : How to track the mofications made to Objects like UPROC

Fri, 05 Mar 2010 10:18:05 +0100

Hello ,

Please let me know if there is any way to track the changes/modifications made to Dollar-Universe objects like UPROC , Session.

For example , if I have created a Session , some one else has modified it , now how to make out who had modified it.

Solved : Problem with versioning while deleting a UPROC

Tue, 16 Feb 2010 07:54:44 +0100

Hello ,

I am facing a problem with a UPROC "OBIP06STR" . Actaully I am not able to create the same UPROC "OBIP06STR" Version "002" as the I am encountering the error "Uproc already exists" but there is no such UPROC for version 002 where as it exists for version "001" . Now when I embed the UPROC "OBIP06STR" "001" in a session , I am not able to open the same as I encounter an error "Couldnot read this UPROC . Reason : UPROC unknown". I am not even able to create a task for this session as encounterign some error about "OBIP06STR" "002" .

I doubt the "OBIP06STR" "002" version debris exists somewhere which cant be seen . Could you please let me know what can be the next course of action .

Below are the details for your reference

C:\Universe\CDBTST\exec>UXSHW UPR NODE=dwhdev APP UPR=OBIP06STR VUPR=002
Command : uxshw upr node=dwhdev app upr=OBIP06STR vupr=002 partage

No articles were extracted
command in error!!

Command : uxshw upr node=dwhdev app upr=OBIP06STR vupr=001 partage

TYPE | upr

ITEMS | upr : OBIP06STR
| vupr : 001
| class :
| clfil :
| label : Start the Session & Start of the Uproc (OBCP01STR)
| dom : D
| appl : U_
| upt : CL_INT
| definfo :
| defsev :
| fperiod : d
| memo : o
| nbper : 0
| command :
| execdir :
| incclass : ( )
| launchvar : (
[
varname : in_file_location
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : in_file_name
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : new_file_location
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : new_file_name
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : channel_id
vvalue : OFL
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : config_id
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : slot_end_date
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : period
vvalue :
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : dir_working
vvalue : /bo/bodi/inputfiles/Billing/working
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : dir_error
vvalue : /bo/bodi/inputfiles/Billing/error
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : dir_done
vvalue : /bo/bodi/inputfiles/Billing/done
vtype : T
vformat : 255
valmin :
valmax :
]

[
varname : compress
vvalue : N
vtype : T
vformat : 1
valmin :
valmax :
]

)
| depcon : (
condno : 01
dep : OBCP01STR
dtype : a
pdate : ( , , )
mu : same
sess : any
user : any
status : absent
all
expected
nofatal
)
| inccon : ( )
| rescon : ( )
| termins : ( )
| formula : ( =C01 )
| sap_xbp2 : ( )
| sap_xbp2_step : ( )
| sap_xbp2_step_pr : ( )
| sap_xbp2_step_ar : ( )
| sap_pchain : ( )
| sap_ipack : ( )
| ftp_get : ( )
| ftp_put : ( )
| ejb : ( )
| ejb_param : ( )
| create_param : ( )
| notify : ( )
| upr_status : ( )
| script :

==================================================
echo "START THE PARENT UPROC"
$UXEXE/uxset var level ALL

new_file_location=$dir_working
$UXEXE/uxset var new_file_location=$dir_working

logfile=`echo $in_file_name | cut -c 1-8`
new_file_name=$logfile'_'${channel_id}'_'`date +%Y%m%d%H%M%S`'.txt'
$UXEXE/uxset var new_file_name=$new_file_name

slot_end_date=`date +%Y%m%d%H%M%S`
$UXEXE/uxset var slot_end_date=$slot_end_date

period=`echo $in_file_name | cut -c 9-12`
$UXEXE/uxset var period=$period

echo "******************************"
echo "new_file_location ==> $new_file_location"
echo "new file name ==> $new_file_name"
echo "slot_end_date ==> $slot_end_date"
echo "period ==> $period"
echo "******************************"

return_code=$?
echo "return_code :$return_code"

echo "END OF PARENT UPROC"

==================================================

Tutorial : How to sequence Sessions

Mon, 15 Feb 2010 18:26:49 +0100

Hello,

This tutorial explains how you can sequence Sessions.

Michel

Solved : Issue with "MUltiple Launches"

Wed, 10 Feb 2010 11:25:38 +0100

Hello ,

I have imposed a task on a session in the followsing manner:-

Launch From: 00:02 during 000 h 50 min
Until : 23:59 every 60 min.

and I had clicked "Insert multiple windows" to get the below list.
00.02
01.02
02.02
03.02
04.02
05.02
06.02
07.02
08.02
09.02
10.02
11.02
12.02
13.02
14.02
15.02
16.02
17.02
18.02
19.02
20.02
21.02
22.02
23.02

I saved & closed the task.

The issue comes here when I reopen the task . The columns will be shown as below :
Launch from: 15:48 (current time in my local system though $Universe is located on server whose time is different) during: 00h 50 m
Until : 15.48 every 000 min

Can you please let me know where it could have gone wrong.

Solved : Processing date needs to be set before launching the Session

Thu, 04 Feb 2010 16:38:31 +0100

Hello ,

I have a requirement where my Uproc U1 whose processing date should be 1st of previous month
EX: If I am launching that Uproc today , the Processing date of that UPROC should be 1st January 2010.
Again the UPROC U1 depends on two other UPROCS U2 (Processing date -1)& U3 (same Processing date ).
So as per our example , the U1 running for Processing date 01/01/2010 should depend on U2 for 12/31/2009 & U3 for 01/01/2010.

I thoguht of incorporating the logic for changing the processing date in the internal script of U1 , but the problem is that the U1 is depending on the U2 (for current date -1 i.e., 02/03/2010) and U1 (for the current date 02/04/2010) which is not as per my requirement.

Is there any way how I can incorporate this logic in U_ANTE_UPROC only for this specific Uproc , i.e., in case of only this Uproc , the above logic for processing date should happen , else no.
Please suggest me if there is any other solution .

Solved : Dependant UPROC not getting launched

Mon, 01 Feb 2010 09:42:13 +0100

Hello ,

An UPROC DGBM01STR (runs on 1st of every month) which is set to be dependant on DGBJ01END for any( any year & any month ) of the last day of the previous month is not getting launched even after a job-event is created for DGBJ01END with processing date as 31/01/2010 & 31/12/2009 and is still in event-wait status.

Below is the message in History-trace.

02/01/2010 03:00:00 Start Condition Check
Processing Date 02/01/2010

Dependency Cond. 01 Prop. 01 :
Depe. : - DGBJ01END - DWHDEV 00000031 Missing
*** Task launch refused ***
Please let me know where it might have gone wrong.

Solved : Aborting a Session

Wed, 27 Jan 2010 10:25:07 +0100

If I have a Session containing 10 Uprocs running in series - one after the other, and [for example] number 2 aborts, and I wish to abort the rest of the Session - that is, prevent Uprocs 3 to 7 from running, what is the best procedure?

I have been purging the aborted Uproc execution. However what SEEMS to be happening is that next time the Session is run, when it gets to Uproc number 3, it launches the Uproc twice. It seems to 'remember' that it had a launch pending for that Uproc from the aborted Session. But this ehaviour seems to be intermittent. That is, I am unable to reliably reproduce it....

Solved :NO RUNBOOKS DEFINED

Tue, 26 Jan 2010 19:13:23 +0100

Hello....

We occasionally encountered issues with job aborted due to message below....

Has anyone encountered this issue? Thanks.....

01/26/2010 12:04:31 Start Condition Check
The rerun was requested by operator : ????????????????????
Processing Date 01/26/2010
01/26/2010 12:04:31 Submitted in BATCH Q: SYS_BATCH
under ENTRY N� : 0913

BATCH starting
++++++++++++++++++++++++++++++++++
CURRENT ENVIRONMENT: PRODUCTION
++++++++++++++++++++++++++++++++++

==== Operations Runbook ====

WARNING: NO RUNBOOK DEFINED FOR JOB CNXXXXXX on node CNXXNN

=============================
Job aborted or killed during execution

01/26/2010 12:04:37 *** TASK ENDED ABNORMALLY ***
*** TOTAL *** - Duration : 00.00:00:06.00 - CPU : 00.00:00:00.00
- PGF : ???? - DIO : ???? - BIO : ????

*** Abnormal execution of Uproc ***

Solved : $Universe installation footprint

Wed, 20 Jan 2010 16:01:02 +0100

Good Morning,

We encountered disk space issue in the server where $Universe was installed. In investigating, it was discovered that $Universe has a 6 GB footprint. When the files and folders were checked, it totaled only about 600mb. Not sure if anybody encountered the same issue and what caused this. Also, what possible solution can resolve this issue. Thanks for your help.

Solved : Processing date in dependancies.

Tue, 19 Jan 2010 14:56:46 +0100

Hello ,

Could you please let me know the concept behind the processing date in the dependancy condition.
In the below case :-
DAY: specific value 1 day
MONTH: Offset - 1
YEAR: Offset - 1 .
then it is getting as 12/01/2008 (i.e., 2 years behind the current date) .

Is it that it calculates one-by-one firstly month i.e., Dec 2009 and then goes to the previous year (2008) .
(or)
where as I expected it to be Month(currnet date) -1 and (year)-1 i..e, 2009 dec.

Thanks in advance.

Solved : Modular Development - Another 'newbie' question.

Tue, 17 Nov 2009 11:04:48 +0100

What support does $U have for developing modular schedules?

Let me explain my requirement: I have a batch of jobs that will run overnight to populate a Data Warehouse and some Data Marts. (The tool in use is DataStage, called via a standard shell script, but from a $Universe perspective we just have a bunch of 'jobs' to run in a particular order with some parameters)

Now these jobs can be divided into modules:

1. Initialisation
2. Data Warehouse Load [Country Specific]
3. Data Mart Load.

Module 2 consists of the same group of jobs, run several times with a variable specifying the country. See my separate thread on Session Variables.

Now I could obviously build a big Session to run all the modules in order, however a key requirement is that it should be possible to run (or re-run) each 'module' on its own 'on demand' as well as in the standard schedule, so I would like to break the batch into modules. Ideally I would like to have 'nested' Sessions, that is Sessions that call Sessions but it may be that I have misunderstood the $U architecture, as this seems not to be supported.

I raised this requirement on the training course, and the proposed solution was to create a Session for each module with a Header and Trailer UProc and then a Master Session to call each module in turn.

For each child module/Session the 'Master' session has

A Uproc that calls the 'Child' Session and its Header Uproc via a provoked Task
A second Uproc, child of the first, that is conditioned on the Trailer UProc of the called Session.

I hope that's clear. Any comments on this approach? Is this what other people are doing? Is there a more elegant solution?

Specific question - Suppose the child Session had run already that day? Would this successful 'memorised' run of the Trailer Uproc not cause my Conditioned Uproc to execute immediately? How to prevent this?

thanks,

Phil Clarke.
Three Telecoms.

Feedback from a new user

Tue, 22 Dec 2009 13:22:28 +0100

We have been using the tool for a few months now and while I am impressed by its sophisticated scheduling abilities, I have encountered a couple areas where functionality that one would expect to find in such a tool is weak or missing. I've posted on these before but thought it would be useful to have them in a single place. We have developed workarounds and here I describe the weaknesses and what we have done to work around them. I would welcome feedback from more experienced people. Is there a better way of achieving the same result? Are my facts correct? Am I missing something?

1. �Global� variables.

It is not possible to define variables with a scope of 'Session'. All variables are defined at Uproc level and must be passed from Uproc to Uproc. This can only be done by writing code. Thus, to make a variable available across a session, it must be declared in all Uprocs, whether or not it is used.

Background: We have a batch of ETL jobs that must be run several times for different countries. The jobs are identical but accept a country code as a parameter. Thus we run the same set of Uprocs with the country code as a variable. It is not possible to set this variable once at session level and have each Uproc inherit it automatically.

Workaround. We have one session per country, these are identical apart from a header Uproc that sets the country code. We have added code to the U_POST_UPROC script to test if this variable exists and if so call uxset to pass it to the next Uproc in the flow.

2. �Nested� Sessions

Our overnight batch consists of several modules, run in a particular order. It is sometimes necessary to run or re-run a module on its own. Thus we have one Session for each module. Ideally we would like to have a master or controller session that calls the sessions in the correct order. It is not possible to call a Session from a Session without writing code. Ideally we would want several layers of �nesting�.

Workaround: We have developed the following functionality

- The �child sessions each have a Header and Trailer Uproc. These are just placeholders that do an �exit 0� and have no other functionality.

-There is a controller session with these characteristics �.

A Header Uproc that removes event records for the trailer Uprocs of the �child� sessions.

One Uproc per Session. This runs a provoked task to run the child Session. The next Uproc in the master session is conditioned on successful completion of the trailer Uproc of the called session.

So the first functional Uproc calls the first Session, the second Uproc goes into �Event Wait� until the first child session completes � as indicated by the completion of the trailer Uproc, and so on. This seems to me a little clumsy, but I cannot see a more elegant way of achieving this.

Solved : Provoked tasks can't be manually launched ?

Wed, 09 Dec 2009 14:29:54 +0100

Hello,

Could you please let me know if a Provoked task can be launched manually form Launch option.
When I tried launching a Uproc from Launch option its getting in to Launch wait status where as I can launch the same session (whcih I gave in the task) without task.

Attached are the screenshots for your reference.

Thanks a lot in advance.

Solved : Job events

Thu, 03 Dec 2009 10:12:50 +0100

Hello ,

Please let me know how the concept of Job-Event works.
For ex , I have a an Uproc U1 which is dependant on U2 .

Case1) Is there any constraint like the Uproc should have run on the same processing date as that of U1 , only then U1 runs ....
(or )
Case2) If a job event exisits for the Uproc U2 for any processing date (Prior/post the processing date of that of U1) , will U1 run

If Case 1 is true and if U1 & U2 are in a session and the session runs multiple time a day, then there is a chance that U1 runs everytime in that day if U2 has run succesfully atleast once in a day irrespective of the fact that the U2 in the same run has failed. So to evade that case , may be job event of U2 should be deleted at the end of the session every time. Is there any other way how we can achieve this like time stamp restricted to each run or so ?

Thanks in advance

uxset : No record corresponds to those criteria

Mon, 07 Dec 2009 16:11:10 +0100

Hi All,

When using the command

$UXEXE/uxset parm "MyValue"

I get the following error:

uxset : No record corresponds to those criteria

Do you know where I can find some information about this error ?

Thanks
Alex

Solved : Info on the product architecture

Mon, 30 Nov 2009 20:43:14 +0100

Hello friends,

i am new to this product , in our organization we are using Orsyp Doller Universe for scheduling the jobs, the $U client is running on AIX and Solaris, in case of any job failure i am not able to understand the architecture of this to troubleshoot , it would be great of you all , if you can help with the basic understanding of this product.

i am looking for :

1.$U architecture.
2.How to troubleshoot the job failures from unix point of view.

please help me with the documentation.

Thank you.
Gangadhar.G

Solved : Automated Script

Fri, 27 Nov 2009 12:54:39 +0100

Hi All,

I am absolutely new to unix and DU. I have a task to automate all the Time overruns ie; if a job goes to time over run the script should automatically increase the time. I have downloaded the ppt which shows all the variables for the universe, but i don't know how to use them. Eg
$UXEXE/uxlst ctl upr=SRS* since=10/27/2009,0000 status=O full

I use this script to get all the Time overruns but don't know how to use S_NUMLANC in it to get the launch number for the jobs.
I hope i am making myself clear to all.

I am planning to pull all the unique ids( time over run) and put them into the script to increase the time

Do let me know how to use it and make the automation job easier.

Thank in advance.
- Newbee

Solved : Get the UProc Name in SH Script

Fri, 20 Nov 2009 15:52:51 +0100

Hi,

I am trying to get the UProc Name in my called script ?
I already know it's possible to get the Uproc n� thru $S_NUMPROC, but how to get the name of the Uproc ?

Thanks
Alex

Solved : Variable common in a session

Thu, 12 Nov 2009 14:31:02 +0100

Hello ,

My curernt requirement is something similar to that of last one. I have 3 Uprocs(say U1 , U2 , U3) in a session with few variables declared in the U1. Inside the U1 I Will have to manipulate few of the defined variables and then pass all the variables down the session.
I have used "$UXEXE/uxset var level ALL" in U1 and tried displaying them in U2 (which is a duplication of U1 with some modifications and so all the variables defined in U1 got replicated here) but in vain as nothing is getting displayed

Please let me know how to handle this scenario preferably a way where I need not repeat the declaration of variable in every UPROC.

Thanks in advance

Solved : Session Variables

Wed, 11 Nov 2009 18:49:26 +0100

Hello,

I am developing a Session that will run a batch of data loads. The session will run for a particular country and for a particular Unique Batch Id.What I would like to do is set the value of the Country and the Batch Id as variables at the start of the Session and have each of the Uprocs (about 20 in total) access these 'global' variables. I thought this was possible using the uxset var command, but it does not seem to be working. Here is what I have tried ...

My Country is in a variable named INVOCATION, the batch id is in DELTA_ID. I created these variables in a header UPROC, assigned them values and added this command to the CL :

${UXEXE}/uxset var INVOCATION DELTA_ID

But this aborts the UProc (Return Code 1 from uxset).

So I tried

${UXEXE}/uxset var level INTER

and in a child UPROC created an identical variable INVOCATION, this ran OK but the value for INVOCATION set in the header is not being passed to the child ...Is it possible to do what I am attempting - I would expect that this is a common requirement - ? And if so, what am I doing wrong?

If I use uxset var, does this make the variable available to ALL the UProcs in a session, or just the immediate children of the UProc where it is issued? The manual is not clear (at least en anglais!).

thanks

Phil Clarke
Three Telecoms.

Solved : Commands like "Uxlst " are not yielding

Thu, 22 Oct 2009 11:28:56 +0200

Hello ,

Commands like Uxlst are not yielding the desired result and are throwing some errors as shown below:-

1) C:\Universe\CDBTST\exec>uxlst upr APP
Command : uxlst upr app vupr=* full

api_cmd_SetEnv Initialization error
Server process not found
command in error!!

2) C:\Universe\CDBTST\exec>uxlst SOC
Command : uxlst soc full

UxCmd_LoadUniverse Initialization error
Mandatory data
command in error!!

The content of the "Uxsetenv" located in "mgr" is given below.

ECHO OFF
REM ==========================================================================
REM ORSYP.Sa
REM ------------------------------------------------------
REM Procedure for declaring a Dollar Universe Global Control environment
REM Defining variables
REM Defining REM aliases
REM
REM
REM The following declarations are part of the common login
REM UNIVERSE for the company TESTET
REM (file created at installation)
REM ==========================================================================
REM
REM if (-e \etc\UNIVERSE_DQM_CDBTST ) then
REM set UXDQM \etc\UNIVERSE_DQM_CDBTST
REM REM alias uxdqm "cd $UXDQM;set prompt='$UXDQMREM '"
REM endif
REM
set U_MASK_UPR="u=rwx,g=rw,o=x"
set UXDIR_ROOT=C:\Universe\CDBTST
REM
set UXEXE=C:\Universe\CDBTST\exec
set UXMGR=C:\Universe\CDBTST\mgr
set UXDAP=C:\Universe\CDBTST\app\data
set UXDIN=C:\Universe\CDBTST\int\data
set UXDSI=C:\Universe\CDBTST\sim\data
set UXDEX=C:\Universe\CDBTST\exp\data
set UXPAP=C:\Universe\CDBTST\app\upr
set UXPIN=C:\Universe\CDBTST\int\upr
set UXPSI=C:\Universe\CDBTST\sim\upr
set UXPEX=C:\Universe\CDBTST\exp\upr
set UXLAP=C:\Universe\CDBTST\app\log
set UXLIN=C:\Universe\CDBTST\int\log
set UXLSI=C:\Universe\CDBTST\sim\log
set UXLEX=C:\Universe\CDBTST\exp\log
set UXLOG=C:\Universe\CDBTST\exp\log
REM
set U_LOG_FILE=C:\Universe\CDBTST\exp\log\universe.log
set U_MSG_FILE=C:\Universe\CDBTST\exec\uni_msg.txt
set U_LIC_FILE=\\Cursa\div\IT\PRO\BASC\Universe\$U_test\u_fali01.txt
REM
REM set U_EDITEUR_R "vi -R "
REM set U_EDITEUR_W "vi "
REM
set SRVNET_DIR=C:\Universe\CDBTST\mgr
set S_CODPROF=PROFADM
set S_SOCIETE=CDBTST
set S_U_LANGUE=EN
set S_TIMEOUT=60
set S_ESPEXE=X
set S_UNIVERS=E
set S_APPLI=U_
REM
set U_FMT_DATE=MM/DD/YYYY
REM
set U_TMP_PATH=C:\Universe\CDBTST\tmp
set S_NOEUD=dev4801
set S_CODCENTRAL=N
set S_PLAGEHORAIRE="0:0/23:59"
set UNIVERSE_DQM_CDBTST=YES
set UNIVERSE_USERALIAS_CDBTST=\\Cursa\div\IT\PRO\BASC\Universe\$U_test\useralias.txt
set UNIVERSE_SECURITY_CDBTST=\\Cursa\div\IT\PRO\BASC\Universe\$U_test\security.txt
set U_CDJ_DISABLE=no
if NOT "%UNIVERSE_DQM_CDBTST%"=="no" set START_DQM=Y
REM
set UXRES=C:\Universe\CDBTST\res
REM
set UXMGR4JAVA_HOSTS_FILE=%SRVNET_DIR%\uxmgr4java.host
set UX_IO_VAR_OS=W32

if exist %UXMGR%\uxsetenv_CDBTST.bat CALL %UXMGR%\uxsetenv_CDBTST.bat

Please let me know where the issue lies .

Solved : crystal reports

Wed, 04 Nov 2009 21:55:58 +0100

Can we run crystal reports by scheduling in Dollar Universe?

Call batch files

Wed, 04 Feb 2009 15:54:20 +0100

I' am trying to run an batch file, which resides on a different server, but it just won't run. Does anyone know what the syntax is fo calling batchfiles in DU?

I've tried to use the "Call" command but this doesn't work either.

Can anybody help me?

Solved : Issue with "Step"

Thu, 15 Oct 2009 10:14:31 +0200

Hello ,

I am trying to execute the example given in $Universe command manual and the content of the script is as follows:

#! /bin/ksh

STEP0 ()

# Variable S_NUMJALON =0 at normal start of uproc

{

$UXEXE/uxset msg " *** Passage STEP 0 *** "

}

STEP1 ()

{

$UXEXE/uxset step "1"

$UXEXE/uxset msg " *** Passage STEP 1 *** "

# Use uxset msg to display normal

# comments and instructions in History Trace.

}

STEP2 ()

{

$UXEXE/uxset step "2"

$UXEXE/uxset msg " *** Passage STEP 2 *** "

}

STEP3 ()

{

$UXEXE/uxset step "3"

$UXEXE/uxset msg " *** Passage STEP 3 *** "

}

STEP4 ()

{

$UXEXE/uxset step "4"

$UXEXE/uxset msg " *** Passage STEP 4 *** "

}

STEP5 ()

{

$UXEXE/uxset step "5"

$UXEXE/uxset msg " *** Passage STEP 5 *** "

}

# During recovery the S_NUMJALON variable is loaded manually from the Job Monitor screen, else =0

#

Iscn=$S_NUMJALON

let Iscn=Iscn

echo "Iscn =$Iscn"

while [ $Iscn -le 5 ]

do

echo "Iscn =$Iscn"

Fnct=STEP$Iscn

echo "Fnct =$Fnct"

e $Fnct

let Iscn=Iscn+1

done

exit 0

The resulted job log is as follows.

_!================================================
_!**
$!** PROCEDURE .. : T13_SCRCH2
$!** VERSION .....: 001
$!** EXECUTION .. : 0032739
_!**
_!** PROCESS DATE : 10/15/2009
_!**
_!------------------------------------------------
$!** PARAMETERS. : None
_!------------------------------------------------
_!** VARIABLES
_!================================================
'2009.10.14'
ENVIRONNEMENT = DEV
Repertoire des logs = log_directory_a_definir
the value at the starting S_NUMJALON is 00
/opt/universe/CDBTST/app/upr/T13_SCRCH2.001[2]: Recovery: not found
Iscn =0
Iscn =0
Fnct =STEP0

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP0" [New file]
Iscn =1
Fnct =STEP1

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP1" [New file]
Iscn =2
Fnct =STEP2

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP2" [New file]
Iscn =3
Fnct =STEP3

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP3" [New file]
Iscn =4
Fnct =STEP4

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP4" [New file]
Iscn =5
Fnct =STEP5

[3g[24;9HH[24;17HH[24;25HH[24;33HH[24;41HH[24;49HH[24;57HH[24;65
HH[24;73HH
[24;1H"STEP5" [New file]

The history log didnt contain any desired messages like " *** Passage STEP 4 *** " .
I want to know the significance of "e $Fnct" . Is "e" there to execute ??

Thanks in advance.

Solved : Uproc of type CL_EXT is not locating file

Thu, 08 Oct 2009 16:11:51 +0200

Hello all ,

My Uproc of type CL_EXT is not able to locate file . I have defined an uproc of type CL_EXT and have given the file name & path in the CL: When I click the EDIT button it is able to open the correct file but when I launch the job , it is throwing an error "CL non executable by this user or not found " though the file is located in the specified directory.
Attached is the file with detailed snapshots for your reference. Could you please let me know where the problem is located.

Please find the attached file with detailed snapshots.

Solved : Update sessions with command to synchronize sessions

Mon, 05 Oct 2009 10:42:54 +0200

Hello $U-specialists

I have to update ALL sessions at the end by one uproc.
Now we have about 2000 sessions to change.
Is it possible (and how ) to manage this at the command line?

Thank you
lmotu

Solved : No motif/picture/image when starting $U

Fri, 31 Jul 2009 23:50:21 +0200

Hi all,

Can you please tell me why after starting $U.
I only have text and no picture in the GUI ?

Thanks.

Solved : $U file monitoring

Mon, 29 Jun 2009 16:26:05 +0200

Hello,

this thread was initially posted by Horace:

Hello,

I am very new to Dollar Universe. I need to implement an application that does the following.

On a frequent periodic basis, perhaps every minute or so, my application must check a file system directory for the arrival of a file. Depending on the file name, the application will

a) immediately invoke a web service, passing a reference to the file that has just arrived OR
B\) postpone processing of the file to a later date - another job will be scheduled to process the file at the later date

Is it possible to implement the above using $U? I''m particularly interested in any file monitoring/file name matching capabilities that $U provides, if any. I''m also interested in the integration that $U provides with web services.

Thanks in advance for any help.

Regards,
John.

Solved : $U from Java

Thu, 25 Jun 2009 18:02:50 +0200

Hi,

This is a fairly broad question. What I would like to do is to trigger a uproc from a Java application. My current solution is to call the uxordre command from my Java app which works. What I'm wondering is if there is a more Java centric approach? Does $U offer any kind of Java API that I can call to do the same. For my $U version/patches see below. Thanks in advance for any help which would be greatly appreciated as always.

Horace.

echo "Start of installation of a Dollar Universe Application Server 5.3 (install
ation kit 533 2008/10/16 14:48)"
echo "End of installation of a Dollar Universe Application Server 5.3 (installat
ion kit 533 2008/10/16 14:48)"
echo "Start of update 24493 installation (20081017184322)"
echo "Start of update 24567 installation (20081022160023)"
echo "End of update 24567 installation (20081022160023)"

Solved : Access uproc variables from uproc/ksh script

Wed, 10 Jun 2009 19:18:26 +0200

Hi,

I have a uproc that calls a ksh script. I would like to access the values of uproc variables in the script. Is it possible to do this? I've had a good look through the documentation and can't seem to find a solution. If this is possible, I would like to know how. Thanks in advance!

John.

Solved : uxordre prints () and exits with status=1

Thu, 18 Jun 2009 19:12:53 +0200

Hi,

I have written a script (see below) to call uxordre. This script executes fine when I run it locally on the $U server. However, when I run the script using remote ssh uxordre prints '()' to the console and exits with a status of 1. Does anybody know what this means? My script is below. I don't understand why there is a difference between local and remote execution. Any help would be greatly appreciated. This is a tough one!

Cheers,
Horace.

#!/bin/ksh

if [ $# -ne 2 ] ; then
echo "Invalid number of arguments"
exit 1
fi

#first of all setup the $U environment

. /data/UNIVERSE/HRDV01/mgr/uxsetenv_ksh

UPROC_TO_PROVOKE=$1
FILE_TO_PROCESS=$2

/data/UNIVERSE/HRDV01/exec/uxordre MU=IFDEV UPR=$UPROC_TO_PROVOKE PARAM=$FILE_TO_PROCESS

echo $?

Solved : $U On multi hosts

Wed, 10 Jun 2009 12:12:19 +0200

I would like to run three jobs on three host differents using each a different user, ex:

user1 on host1 running script1
user2 on host2 running script2
user3 on host3 running script3

of course in the same company and if possible in the same session.

What is the best strategy to implement this scheduling?

Solved : Deferring processing

Thu, 21 May 2009 12:55:26 +0200

Hi,

I am developing a system to satisfy the following requirements. A cyclic task will run frequently - perhaps as often as every minute. A unix shell script associated with the task/uproc will check a directory for file arrivals. If a file has arrived with a certain extension processing of that file must be deferred for 3 days for example. The shell script will need to ensure that another uproc runs in 3 days time to process the file. Does anybody know how I can do this in $U? Can I use the uxordre command here? Thanks in advance for any help with this.

John.

Solved : What/where is U_FMT_DATE?

Thu, 21 May 2009 16:58:06 +0200

Hi,

I see a lot of references to U_FMT_DATE in the $U help files. This is an environment variable apparently. How and where is this environment variable set? It is not set in my own Linux environment. Do I need to run a $U script to initialise my environment variables perhaps? Any assistance is greatly appreciated.

John.

Tutorial : Environment variables in Dollar Universe jobs

Mon, 30 Mar 2009 13:11:55 +0200

Hi,

this lists and explains the different environment variables a job can handle.

Michel

Tutorial : Dollar Universe in a network configuration

Mon, 06 Apr 2009 17:42:25 +0200

Hello,

this document explains how to use Dollar Universe in a network configuration: Objectives, implementation steps, how to check...

Michel

Sending a mail through the GUI.

Tue, 03 Feb 2009 12:29:25 +0100

Hi all

I am getting mail from the Dollar U Gui for the conditions I have set.
But i get a very specific subject, I wanted to know if the subject of the mail can be modified as per requirements.

Being more specific i want to append more information to the current mail subject.

Thanks
sam

Solved : Message "L'horaire n'est pas valide!" when trying to create a cyclical Task in command mode

Mon, 25 May 2009 17:41:15 +0200

Hi,

I am trying to add a task using the uxadd command as follows -

$uxadd TSK UPR=TEST3_JS MU=DUBLIN TECHINF TYPE=C USER=hr01b

Uxadd responds with

Commande : uxadd tsk upr=TEST3_JS mu=DUBLIN ses=" " vupr=000 nomodel nopartage techinf type=C user=hr01b pdate=(0,0,c) prty=100 queue=SYS_BATCH nohold nomult noforce nocentral norestart serial

L'horaire n'est pas valide
commande en erreur!!

This would appear to mean that the schedule is not valid. Does anyone know what schedule this refers to? Thanks in advance for any assistance.

Cheers,
John.

Solved : U_POST_UPROC & environment variables

Tue, 19 May 2009 22:09:19 +0200

Hi , I am beginner to $universe,

I make test with the post execution U_POST_UPROC

I get the correct variables in the initial uproc RESEXE, S_CODEXE and S_CODUG but for S_APPLI I do not recover anything.

Am I obligated to load the variable from the uproc in a temp file to be "read" by u_post_uproc?

Solved : uxordre - help!

Thu, 21 May 2009 17:55:21 +0200

Hi,

I am trying to defer the processing of a uproc with the uxordre command as follows.

/data/UNIVERSE/HRDV01/exec/uxordre UPR=TEST2_JS MU=DUBLIN NODE=HRABS-LI50 AFTER=21/05/2009-1645

When I run the command it responds with the following and my uproc doesn't run at the appointed time.

U_LOG_FILE: Success

Can someone please tell me what this means? According to the documentation The command displays the launch number in the standard output. but this is clearly not happening. What am I doing wrong? Any help greatly appreciated!

John.

Solved : How to know the version of $U?

Wed, 20 May 2009 16:35:19 +0200

Hi,

How can I find out what version of $U is installed on a particular node? The host operating system is Linux.

Thanks in advance,
John.

Solved : Starting Dollar Universe automatically on Windows

Tue, 21 Apr 2009 15:40:34 +0200

Hello Everybody,

The best way to get Dollar Universe running automatically when you startup your server is to put the uxstartup.bat in the group strategies :

0 - log as admin on the server
1 - Start Menu
2 - execute then gpedit.msc
3 - Local computer strategies / windows parameters / scripts / startup
4 - add uxstartup script

One more thing : it would be good to edit the uxstartup and remove or reduce the uxsleep.

Rgds,
FLS

Solved : Transfer variables with FTP Uproc in between

Mon, 20 Apr 2009 14:20:36 +0200

Hello,

this is a translation from another intersting post from the french section:

The need is to transmit variables from UPROC1 to UPROC2 but there is a FTP_PUT type UPROC in between.

The variables are defined in the 3 Uprocs and the script of UPROC1 includes command "uxset var level ALL". UPROC2 retrieves empty variables.

To answer this need, the best solution is to:

Modify the Session and built it like:

CODE

Header
    `-UPROC1
           `-UPROCFTP
           `-UPROC2

and to create a dependency condition on UPROCFTP Completed in UPROC2, with "same session same execution"

Some may use the post & ante uproc files, but this requires some scripting.

Michel

Solved : Setting a Remote Resource

Wed, 18 Feb 2009 18:24:33 +0100

Hello to All,

I am trying to set a resource on a server that has $U installed, the uproc is to wait until a file becomes available on a remote server that does not have $U installed on it. Is this possable?

Thanks in advance for your help.

L&I

Print to PDF with win2pdf

Mon, 22 Sep 2008 14:54:58 +0200

Hello,
In our companty we use Win2PDF te create PDF documents. In our Navision-environment we have developed functionality to automate the process of printing of something to Win2PDF and then attach it to an email. This can now be done by clicking a button once.
We would like to do a similar thing with a report that Dollar Universe generates every week. It is now being printed on paper on the systemprinter (networkprinter). I am quite new to Dollar Universe, so I hope anyone can give me some help with this problem. I am not even quit sure where to start.
Thanks in advance.

Solved : Error handling in the Uprocs

Wed, 28 Jan 2009 12:41:53 +0100

Hi all,

I m running a Uproc which call the DB end in the following manner.
Now in case the DB is down the connection is not available and the status comes as ABORTED.

sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<var var1 VARCHAR2(200);
exec ODAS_BATCH_JOBS_RETRIEVE.retrieve_company_info(:var1);
eof

I wanted to do a similar thing in case an exception is raised in ODAS_BATCH_JOBS_RETRIEVE.retrieve_company_info procedure.

I want to make the job as aborted which will fire a mail.

Any clues of how this can be done will be very helpful....

Thanks
Sam

Solved : Application Area of $U

Tue, 20 Jan 2009 09:17:18 +0100

Do the $U scripts of the Uprocs get executed when run from the application area ?

Solved : Scheduling Sessions in different time zones

Mon, 19 Jan 2009 09:41:50 +0100

Hi all,

I wanted to schedule two sessions which run on different nodes and different MU's. Now the two nodes are on different time zones.

Il explain the same in detail.

Node 1 :- Wonder -> Session :- ODS_135_B -> Jobs :- ODS_135_H and ODS_135__T ; MU :- ODS_ECP

Node 2 :- Stilt -> Session :- ODAS_3S -> Jobs :- ODAS_3HD , ODAS_3, ODAS_3T ; MU :- ODAS_SCH

ODAS_3HD is dependent on ODS_135__T. So ODAS_3HD waits for the ODS_135__T to release the dependency.

Now the wonder node is 8hrs behind the stilt node because of the different time zones.

I wanted to know how long does ODAS_3HD wait for ODS_135__T ?

Does it check the time or does it check the date first, because if it checks the date then at many instances the day will be one day behind.

Thanks
Ramit.

Solved : Session with jobs running under various users

Wed, 07 Jan 2009 13:22:47 +0100

Hi everyone,

is it possible to schedule a Session with its jobs running under various users?

Thanx!

What is your IT Operations size for Dollar Universe?

Tue, 06 Jan 2009 15:46:27 +0100

Hi Guy's

Just looking for some information if any of you would care to share .

How many processes do you have definded at your sites ?

And how many servers do you run your jobs across ?

Thanks in advance !

Solved : Dollar Universe Model

Wed, 31 Dec 2008 07:19:30 +0100

Hi,

I would like to make sure the setup of my Dollar Universe is as model, can someone help me in defining the most important point to achieve it.

Mohammed

Tutorial: Job status and cycle life

Tue, 30 Dec 2008 18:55:07 +0100

Hi,

this lists and explains the different statuses a job can get through.

Michel

Solved : Triggering Uprocs across company

Mon, 22 Dec 2008 12:08:04 +0100

Hi,

Im new to the world of $U. I wanted to know if its possible to do the following.

There is 2 Uprocs namely

Uproc MU
GES_180__T GES_KS1
GES_181_T GES_KS2

Now once both the Uprocs have executed successfully they should execute a session namely ODAS_1S which further contains 4 Uprocs.

OR another way if it is possible could be.

The Session is scheduled and this will actually trigger the uporcs GES_180__T and GES_181_T.

Please give me some idea or pointers to solve this problem.

Thanks.

Solved : What is a Management Unit (MU)?

Thu, 10 Apr 2008 16:37:58 +0200

Hi all,
Can somebody explain MU concept and its use to me?
I am new to Dollar Universe and I heard that with MU you can do a lot of things regarding scheduling.
Please help!
Thanks!
Mulder

Solved : Implementing Maintenance Jobs

Fri, 08 Aug 2008 10:11:09 +0200

Hi

Can someone help to explain how the maintenance jobs needs to be implemented for a clean installation. For the sake of everybody it would be best to explain what is required, how it works and how it is implemented so that anybody can use this forum to implement their housekeeping on Dollar Universe. I could not find a complete a-z document on this anywhere. I want to implement on Windows and DU5.23.

Solved : DU Admin duty

Wed, 03 Dec 2008 16:34:44 +0100

Hi All,

I need to know what are the Dollar Universe administrator tasks, what is his responsibility?

Mohammed

Tutorial : Scheduling & Sequencing

Thu, 20 Nov 2008 20:57:45 +0100

Hi,

this is to explain how to condition a job (to sequence it) and how to schedule it.

Michel

Solved : which document should I read to implement DU on Windows 2003

Tue, 18 Nov 2008 19:54:27 +0100

Hello DU Guru's,

I am a new user for DU and I wanted to Implement Job Scheduler on Windows 2003 server for Scheduling Tasks.

Can anybody tell me which document should I read to implement DU on Windows 2003 server.

Thanks in Advance

Regards,
rankam77

Solved : UPROC is not running at all ?

Fri, 22 Aug 2008 14:18:21 +0200

Hi all ,

Is there any service / process need to be started to make sure that a scheduled UPROC will run on time.

As i have an issue that whenever i submit a uproc or session it never run .

How could i know that every thing is fine.

Note that All engines are up & running & no error displayed in universe.log

Any idea , please .

Solved : Extract/Import Calendar Template

Mon, 03 Nov 2008 22:21:14 +0100

Hi. I am new to Dollar Universe and new to this forum. I hope I am posting this question in the right place.

I am trying to import a calendar template from a node in one company to the corresponding node in another company.

When I originally set up the TEMPLATE, I gave it a meaningful name, then it created the calendar "specific" on the node. It created the calendar with the node name (different from the template name).

Whenever I run the extract/insert commands via command line, the only thing that gets exported is the calendar that the template created.

Does anyone know how to export the actual template?

Solved : How to call an U_PROC from another U_PROC

Tue, 28 Oct 2008 10:47:58 +0100

Hi all
I'm running DU 5.1.3 on linux/AIX.
I would like to call an U_PROC from another U_PROC (CL_INT) with then same environment (UG, etc), just like running a "sub-script". And how to get the exit code of the called U_PROD?
Thanks for help.

Solved : Possibility to choose the editor for the Uproc script

Mon, 22 Sep 2008 13:35:53 +0200

Hello,

some of our $U developpers would like to use editors different from notepad on Windows and vi on Unix. Is there a way to do it?

Solved : Help on using insert Child Error - depending on file size

Fri, 12 Sep 2008 22:59:27 +0200

Hi,

I'm new to using Dollar universe and i have a simple logic that I need to improve.
One of my uprocs checks a file and depending on the size of that file, the uproc would return success or abort.

Is there any other way to do this without the uproc returning status of aborted? because dollar universe logs a ticket stating that the process has aborted even if it is part of normal processing.

see session screenshot below:

thanks

All UPROCs are aborted

Mon, 25 Aug 2008 16:10:06 +0200

Hi All,

All UPROCs are aborted , see the error in universe.log

/uxord /UXOS_CrtlJobBatch /000000000 - Terminaison : JobId (13) , Statut : _Uproc <2304> _Val <9>_Exit <9> _Signal <0>

Any idea .

Solved : uxord as root How to?

Tue, 26 Aug 2008 15:28:16 +0200

Hi All,

I would like to know how to enable uxord " The luncher to run as root "

Thank you

Solved : Retrieve basic info for specific job status

Fri, 08 Aug 2008 18:09:44 +0200

Hi,

I'd like to improve the reporting of my $U production.

I heard of Dollar Universe Reporter and will have a meeting with Orsyp to evaluate this product.

In the meantime, I'd like to know what can be done with $U. I'm interested in information about aboted jobs, as well as times in time overrun.

Homer

Solved : Identifying a relaunched job from a "normal" one

Fri, 08 Aug 2008 19:13:31 +0200

Hello all,

is there a way of identifying a relaunched job from a "normal" one in the job itself?

Homer

Solved : No Dollar Universe User Defined

Thu, 31 Jul 2008 15:07:01 +0200

I'm failing to run Dollar Universe Control Desktop from my local account. When I log on to the server hosting Dollar Universe and click on the Control Desktop or the Job Monitor I get the error:

No Dollar Universe User defined for xxxxxx in Domain yyyyyy.

When I log on using an administrator account, I can go in to the Control Desktop and under the Admin Node check to see that my user exists.

Are there other places I need to add my user to, do I need to reset some process to start my user? There are plenty of other local accounts defined in the user node.

Solved : Find the version of Dollar Universe on Windows

Wed, 30 Jul 2008 17:11:11 +0200

How can you tell what version you have on a windows node?

Solved : several uxord processes

Tue, 01 Jul 2008 13:58:29 +0200

Hello,

I seems to me that there should be only 1 uxord process on a universe AS?
Can somebody confirm this ?

Solved : problem of creating a new rule help

Wed, 25 Jun 2008 12:01:49 +0200

Unless I am presenting is a user Dollar Universe society lottomatica (Italy).
I need to schedule a uproc first Wednesday of every month.
you know how I can create the rule?
Thank you very much

Tutorial: Avoid confusion between Functional Period and Scheduling Rule

Tue, 03 Jun 2008 11:06:48 +0200

Hello,

I piggyback on another thread to set this reminder on Functional Period and Scheduling Rule.

Functional Period and Scheduling Rule are two different things and have different goals:

When the job is set to run: This is set via the Scheduling Rules of the Task.

What data is handled by the job: This is set via the Functional Period of the Uproc.

The Functional Period has a direct link with the Processing date of the job.

Be aware that there are no link whatsoever between Functional Period of the Uproc and Scheduling Rules of the related Task.

Here is an exemple:

You want to automate the job that calculates the pay of employees in your company.

If employees are paid for the work they have done during a week and are paid at the end of the week or at the beginning of the following week, the Functional Period of the job will be "Week" and the Scheduling Rule "1st working day of the week" or "Last working day of the week" for example.

If employees are paid for the work they have done during a month and are paid at the end of the month, the Functional Period of the job will be "Month" and the Scheduling Rule will be monthly based.

In this first example, it happens that Functional Period and Scheduling Rule are based on similar periods.

BUT :

You want to automate the job that sends a report of the stock flow for the current month in your company factories.

As you want to process the data for the current month, the Functional Period of the Uproc will be month.

But you may want to get the information daily, or at the beginning of the week, or on demand. So the scheduling Rule could be "Working days", or "1st Workday of the week" or the Task may simply not include a Scheduling Rule but be triggered by the uxordre command.

In this second example, you clearly understand that Functional Period and Scheduling Rule have no link whatsoever.

Michel

Solved : How do you use $U steps?

Mon, 26 May 2008 14:23:47 +0200

Hello,

I have heard of steps in $U. How exactly do they work?

Any examples of scripts (ksh and 'dos') using them are welcome.

Cheers,

Gary

Solved : Scheduling rule and functional period for a job running on week-ends

Tue, 27 May 2008 17:08:57 +0200

Hi,

a job must run once a week during the week-end, on saturday. I don't know what functional period I should set in the uproc .

The job is part of a session which runs daily.

Help!!!

Solved : Understanding $U MODEL and distributing a job

Fri, 02 May 2008 11:50:29 +0200

Dear all,

I am trying to understand the concept of creating a UPROC or SESSION as a "Model".

I was told that it is required to create the job as a model to enable "distribution" it between two environments.

A brief description of the setup is given below:

Node A (Environment : E01, Production)

Node B (Environment : E02, Development)

$U : V4.3

OS: OpenVMS

What I understood is that, there are few uprocs and session created as "Model" and they distribute it from E02 to E01. This is followed for any new job related to application.

Please help me in understanding the concept behind "distributing a job" among environments.

Can this happen between two different nodes running with $U?

What are the conditions that needs to be met for distributing a job.

Cheers
Venkata

Solved : $U Configuring command mode on VMS

Fri, 25 Apr 2008 12:30:48 +0200

Hi Forum members,

I have a server running with $Universe V4.3 on it. ( OS : OpenVMS V6.2)

All management activities are done using the Character interface menu by logging in as user XXXX_ADM.

If I try to use dollar universe commands ( uxlst, uxshw etc. ) at the command prompt, getting error that it is an invalid command:

%DCL-W-IVVERB, unrecognized command verb - check validity and spelling
\UXSHW\

Is it sufficent to run the CRE_ALIAS.COM procedure in my LOGIN.COM so that I can use all the commands?

What are the steps to be followed for configuring the Command mode in $U on OpenVMS

Please suggest.

Cheers
Venkata

Dollar Universe vocabulary

Fri, 11 Apr 2008 11:12:21 +0200

Hi all ,
Although I have sufficient (basic) knowledge of Dollar Universe vocabulary but as I am new I want someone to give list of commonly used terms in Dollar Universe context.
Everyone is wellcome to add new definitions and explainations about terms specific to Dollar Universe.
Thanks!

Solved : Scheduling question...

Fri, 21 Mar 2008 15:32:35 +0100

I'm trying to set a task which will run according to successful finish of 2 other uprocs(TASKS) in every day expect Monday and Saturday . On Monday and Saturday it supposes to run only after first uproc successful finish. I created a new MU with a calendar that supports execution on everyday except Monday and Saturday, but I still can't configure the same resource condition to use for all this condition.

Could anyone help me?
Thanks!
Sam