By default the maximum number of errors in a mapping is 50..... Here is a script to change it to 0:
############################################################
# #
# Change Maximum Number Of Errors #
# #
# (C) Ciber Nederland John Minkjan #
# http:\\OMB101.blogspot.com #
# V001 Init Version #
# V002 Validated against OWB11gR2 #
# orignal idea: Borkur Steingrimsson #
# #
############################################################
#Disconnect if connected
catch {
OMBDISCONNECT;
};
OMBCONNECT OWB_OWN/******@***********:1521:DWH_A2
set OMBPROMPT ON
set projectList [OMBLIST PROJECTS]
foreach projectName $projectList {
OMBCC '$projectName'
puts "Project: $projectName"
set moduleList [OMBLIST ORACLE_MODULES]
foreach moduleName $moduleList {
puts "Process: $moduleName"
OMBCC '$moduleName'
set mappingList [OMBLIST MAPPINGS]
foreach mappingName $mappingList {
puts "Altering: $moduleName/$mappingName"
OMBALTER MAPPING '$mappingName' SET PROPERTIES (MAXIMUM_NUMBER_OF_ERRORS) VALUES ('0')
};
OMBCC '..'
};
OMBCC '..'
};
(Kudos to Borkur: http://www.rittmanmead.com/2007/07/a-little-bit-of-omb-goes-a-long-way/)
Till Next Time
A Collection of all my OMB+ / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff
Showing posts with label GET PROPERTIES. Show all posts
Showing posts with label GET PROPERTIES. Show all posts
Thursday, March 1, 2012
Friday, November 11, 2011
OMB Get Repository Documentation
#########################################################################################################
# #
# COMPILE OWB Repository #
# #
# Get the Repository documentation #
# Output is written to file in RootDir #
# #
# (C) Ciber Nederland John Minkjan OMB101.blogspot.com #
# V001 Init Version #
# V002 Validated against OWB11gR2 #
# #
#########################################################################################################
#OMBCONNECT rep_owner/rep_owner@localhost:1521:orcl USE WORKSPACE 'My_Workspace'
#set OMBPROMPT ON
# RootDir
set RootDir "C:\\temp\\"
set ProjectList [OMBLIST PROJECTS];
foreach ProjectName $ProjectList {
if {$ProjectName != "PUBLIC_PROJECT"} {
set chan [open [string map {\\ /} "$RootDir\\ProjectSummery_$ProjectName.txt"] w];
set timestamp [clock format [clock seconds]];
puts $chan "Project Summery: $ProjectName Run: $timestamp";
puts $chan "";
set ProjectDescription [OMBRETRIEVE PROJECT '$ProjectName' GET PROPERTIES (DESCRIPTION)];
puts $chan "Project Description: $ProjectDescription";
OMBCC '$ProjectName';
puts $chan "";
puts $chan "$ProjectName: ORACLE_MODULES";
puts $chan "";
set ModuleList [OMBLIST ORACLE_MODULES];
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list MAPPING DATA_AUDITOR DIMENSION CUBE TABLE EXTERNAL_TABLE VIEW MATERIALIZED_VIEW SEQUENCE FUNCTION PROCEDURE TABLE_FUNCTION PACKAGE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
}
;
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: FLAT_FILE_MODULES";
puts $chan "";
set ModuleList [OMBLIST FLAT_FILE_MODULES];
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list FLAT_FILE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: PROCESS_FLOW_MODULES";
puts $chan "";
set ModuleList [OMBLIST PROCESS_FLOW_MODULES]
puts $ModuleList
foreach ModuleName $ModuleList {
puts $ModuleName
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list PROCESS_FLOW_PACKAGE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: CALENDAR_MODULES";
puts $chan "";
set ModuleList [OMBLIST CALENDAR_MODULES]
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list CALENDAR]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: CONFIGURATIONS";
puts $chan "";
set ModuleList [OMBLIST CONFIGURATIONS];
foreach ModuleName $ModuleList {
set ProjectDescription [OMBRETRIEVE CONFIGURATION '$ModuleName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ProjectDescription"
};
OMBCC '..';
close $chan;
}
}
# #
# COMPILE OWB Repository #
# #
# Get the Repository documentation #
# Output is written to file in RootDir #
# #
# (C) Ciber Nederland John Minkjan OMB101.blogspot.com #
# V001 Init Version #
# V002 Validated against OWB11gR2 #
# #
#########################################################################################################
#OMBCONNECT rep_owner/rep_owner@localhost:1521:orcl USE WORKSPACE 'My_Workspace'
#set OMBPROMPT ON
# RootDir
set RootDir "C:\\temp\\"
set ProjectList [OMBLIST PROJECTS];
foreach ProjectName $ProjectList {
if {$ProjectName != "PUBLIC_PROJECT"} {
set chan [open [string map {\\ /} "$RootDir\\ProjectSummery_$ProjectName.txt"] w];
set timestamp [clock format [clock seconds]];
puts $chan "Project Summery: $ProjectName Run: $timestamp";
puts $chan "";
set ProjectDescription [OMBRETRIEVE PROJECT '$ProjectName' GET PROPERTIES (DESCRIPTION)];
puts $chan "Project Description: $ProjectDescription";
OMBCC '$ProjectName';
puts $chan "";
puts $chan "$ProjectName: ORACLE_MODULES";
puts $chan "";
set ModuleList [OMBLIST ORACLE_MODULES];
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list MAPPING DATA_AUDITOR DIMENSION CUBE TABLE EXTERNAL_TABLE VIEW MATERIALIZED_VIEW SEQUENCE FUNCTION PROCEDURE TABLE_FUNCTION PACKAGE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
}
;
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: FLAT_FILE_MODULES";
puts $chan "";
set ModuleList [OMBLIST FLAT_FILE_MODULES];
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list FLAT_FILE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: PROCESS_FLOW_MODULES";
puts $chan "";
set ModuleList [OMBLIST PROCESS_FLOW_MODULES]
puts $ModuleList
foreach ModuleName $ModuleList {
puts $ModuleName
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list PROCESS_FLOW_PACKAGE]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: CALENDAR_MODULES";
puts $chan "";
set ModuleList [OMBLIST CALENDAR_MODULES]
foreach ModuleName $ModuleList {
OMBCC '$ModuleName';
set plural "S"
set ObjectList [list CALENDAR]
foreach ObjectName $ObjectList {
set workListName [concat $ObjectName$plural];
set workList [OMBLIST $workListName];
foreach workName $workList {
set ProjectDescription [OMBRETRIEVE $ObjectName '$workName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ObjectName - '$workName' - $ProjectDescription"
};
};
OMBCC '..';
};
puts $chan "";
puts $chan "$ProjectName: CONFIGURATIONS";
puts $chan "";
set ModuleList [OMBLIST CONFIGURATIONS];
foreach ModuleName $ModuleList {
set ProjectDescription [OMBRETRIEVE CONFIGURATION '$ModuleName' GET PROPERTIES (DESCRIPTION)]
puts "$ProjectName - $ModuleName - $ProjectDescription"
puts $chan "$ProjectName - $ModuleName - $ProjectDescription"
};
OMBCC '..';
close $chan;
}
}
Subscribe to:
Posts (Atom)