Патчи

Список патчей для Oracle Data Integrator
версии 11g с перечнями исправлений.

Патчи для версии 11.1.1.6

Начиная с версии ODI 11.1.1.6. Oracle выпускает сборки патчей (bundled patches) для исправления ошибок.
Рекомендуется всегда устанавливать последнюю сборку.

Одноразовые исправления и наборы нескольких патчей должны инсталлироваться только если для исправления специфических ошибок.


Patch 16886924: Oracle Data Integrator 11g (11.1.1.6.5), Дата: 2013-07-16 Сборка.
17003927 - JNP FAILURE WHEN PERSIST INTERFACE CREATED VIA HELPER 11G SDKS
14606515 - READPERMISSIONTOBECHEHTTPCKEDLIST CAUSED UN-EXPECTED BEHAVIOR FOR NON-SUPERVISOR
14336455 - VERY BAD PERFORMANCE OF SMART IMPORT/EXPORT ON REMOTE REPOSITORY
12784671 - ODI 11.1.1.5 INVOKEWEBSERVICE GENERATES WRONG PAYLOAD FILE
13996344 - EXECUTING A SCENARIO REQUIRES OPEN PRIVILEGE
14027293 - ODIWAITFORDATA REQUIRES EDIT SNP_PSCHEMA PRIVILEGE
14069742 - INCONSISTENT ODI11G ODIWAITFORCHILDSESSION PROCESSING
14244043 - NUMBERS IN COPYBOOK WITH KEYWORD USAGE REVERSE ENGINEERED AS ZONED DECIMAL
14279014 - ODI SQL COMMANDS USE LITERAL SQL, LEADING TO HIGH SGA SHARED POOL USAGE
14461691 - SHOW/HIDE VARIABLE VALUES - INCORRECT VALUES FOR VARIABLES USED WITH PREFIX
14467336 - CHECK EXPRESSION IN THE DBMS - UNOPTIMISTIC SQL COMMAND RUN AGAINST THE DBMS
14487844 - CAN NOT CREATE NEW LOAD PLAN WITH COMMENT
14550964 - LOAD WHEN USING THE ODI LOAD PLAN, THE LOADING STOPS WHEN THERE IS A WARNING
14616050 - CHANGE SOURCE ALIASNAME ON INTERFACE TWICE IT HAS NO IMPACT OF INACTIVE MAPPINGS
14738253 - NON GENERIC PRIVILEGE DOESN'T WORK FOR CONTEXT WITH SELECTED REPOSITORIES OPTION
14786348 - ODI-10153 READ PERMISSION REQUESTED ON GLOBAL VARIABLES
15838512 - INTERFACE EXECUTION FAILS ONLY FOR NON-ENGLISH LANGUAGES AFTER 10G UPGRADE
16054371 - ORA-00972 IDENTIFIER IS TOO LONG ERROR WHEN STARTING A JOURNAL
16176733 - PARTIAL FIX FOR BUG 14738253
14267368 - ODI-26156 WHEN DELETING SCENARIO ON EXECUTION REPOSITORY
12732226 - ERROR ON IMPORTING LOAD PLANS ON EXECUTION REPOSITORY
14480033 - ODISTARTLOADPLAN TOOL WON'T SAVE THE LOAD PLAN NAME
14507023 - CAN'T CONNECT REPOSITORY AFTER WE CHANGE PASSWORD.PASSWORD VALID DAYS OVER 25
16290682 - ODI CAN'T OPEN LOAD PLAN STEPS TAB, IF USER DOES NOT HAVE PERMISSIONS TO ALL CO
14087811 - UNABLE TO ADD NEW LOOKUP OBJECTS IN INTERFACES
11930440 - SOURCE TABLE ALIAS IS CASE SENSITIVE IN ODI 11G
14490806 - JAVA.UTIL.CONCURRENTMODIFICATIONEXCEPTION WHEN EXECUTING INTERFACE DIRECTLY
14509410 - SOURCE COLUMN NOT HIGHLIGHTED DUE TO CASE SENSITIVITY
14558329 - INCIDENT_ERROR, NPE FOUND WHEN SELECT JOURNALIZED DATA ONLY IN INTERFACE EDITOR
16297861 - SMART IMPORT - IMPORT CONTEXT AND LOGICAL SCHEMA ONLY IF USER HAS PRIVILEGES
13092238 - UNABLE TO CALL CRM ON DEMAND WEB SERVICE USING ODIINVOKEWEBSERVICE
14370086 - USERS REQUIRE ACCESS TO ALL GLOBAL IKM'S, ELSE GLOBAL KM'S ARE NOT ACCESSIBLE
15929964 - ODIINVOKEWEBSERVICE COM.SUNOPSIS.WSINVOCATION.SNPSWSINVOCATIONEXCEPTION JAVA.LA
15998826 - SPORADIC SUNOPSIS MEMORY ENGINE ISSUES
16195607 - EBCIDIC ENCODING PROBLEM IN ODI 11.1.1.6
16317739 - UPGRADE TO ODI11G OF AN EXECUTION REPOSITORY RESULTS NO VALUE VARIABLE
14528186 - ODISTARTSCEN EXECUTED FROM A PACKAGE STEP REPORTS INCORRECT RESULT
14031906 - ORACLE.ODI.RUNTIME.AGENT.ODIINVOKEWEBSERVICETESTCASE FAILS
13649240 - ODI CONSOLE ORGANIZATION OF LOAD PLANS AND SCENARIOS IN FOLDERS IS ABSENT
16691650 - ODI CONSOLE DOES NOT RESPECT GRANTED PRIVILEGES ON SCENARIOS
14604120 - DECIMAL VALUES ARE GETTING ROUNDED OFF IN THE TARGET XML FILE
14409563 - REMOTE REPOS - THE INTERFACE DESIGN OPERATIONS ARE LONGER IN ODI 11G THAN IN 10G
14471932 - ODI-26042 WHEN VIEWING A PROCEDURE STEP WITH SCHEMA SET ON COMMAND ON SOURCE TAB
14725049 - THE MAPPINGS VIEW IS NOT RESIZED TO MATCH THE SIZE OF INTERFACE QUICK-EDIT TAB
13644431 - OPERATOR ALL SCHEDULES TAB ALL SCENARIOS ARE LISTED EVEN NON AUTHORIZED ONES
16300260 - ODI SDK CRASHES IF NUMBER OF USERS GREATER THAN OID ORCLSIZELIMIT
16438829 - NON-SUPERVISOR USER CANNOT EXECUTE SCENARIOS IF NOT GRANTED WITH EDIT ON SESSION
13338450 - EXCEPTION WHEN OPEN IMPORT REPORT DLG AFTER IMPORT MASTER REPO
14586488 - ODI STORES DB USER CREDENTIALS IN A XML FILE LOCAL WITH EASY ENCRYPTION METHOD.
16514223 - ERROR CONSOLIDATING REFRESHING METADATA IN ODI-OBI DATA LINEAGE. ODI-50043
14271570 - JAVA BEAN SHELL TASKS EXECUTED AT ALL
11833620 - CERT POSTGRESQL UPPER CASED COLUMNS ARE NOT QUOTED
14744472 - SMART EXPORT - THE TOPOLOGY OBJECTS ARE EXPORTED REGARDLESS TO THE USER PROFILES
14732277 - REMOTE REPOS - THE OPENING OF "EXPRESSION EDITOR" WINDOW IS EXTREMELY SLOW
14704408 - UNABLE TO USE SUNOPSIS MEMORY ENGINE IN INTERFACE
14538962 - UNABLE TO DELETE A TEMP INTERFACE FROM A MAIN INTERFACE
14365485 - ISSUE IN ORACLE TO JMS QUEUE XML TRANSFORMATION.
14299121 - ODI SHOWS DATASET LIST WITH WRONG ORDER IN PDF FILE
14275652 - ODIIMPORTOBJECT FAILING TO IMPORT LOAD PLANS
14215052 - NPE WHEN EXPORTING OBIEE WEBCATALOG METADATA, AND LANGUAGE IS SET TO SPANISH
14209408 - GETTING TO MAPPING TAB IS MUCH LONGER IN 11G THAN IN 10G
14204248 - ODI- UNNECESSARY CONTEXT PASSWORD QUESTION WHILE EXECUTING A SCENARIO
14191659 - MAPPING WITH LOWER CASE ALIAS IS BROKEN
14160282 - ODI-50066: THE GIVEN RPD FILE IS INVALID WITH ODI DATA LINEAGE 11.1.1.6.2
14090493 - STUDIO IS VERY SLOW , SQLTRACE SHOWS REPEATED EXECUTION OF QUERIES
14002695 - NEED TO INCLUDE FILE JPS-CONFIG.XML_TEMPLATE TO THE PATCH
13947503 - ODISFTPPUT/ODISFTPGET TOOLS DO NOT TRANSFER FILES AFTER UPGRADE TO VFS V2
13877712 - ODIOUTFILE SHOULD NOT REQUIRED -TEXT PARAMETER
13869161 - UNABLE TO SAVE COLUMN_NAME(ODI-17591):"COLUMN NAME" IS ALREADY USED
13831392 - ODI-1232: PROCEDURE TEST PROC_VALIDATE_LABOR WLS EXECUTION FAILS. WEBLOGIC.XML.C
13788407 - HFM MEMBER LISTS DO NOT CORRECTLY RESTRICT MEMBERS IN HFM LKM MEMBERS TO SQL
13717297 - LOGGING INTO ODI STUDIO TOO SLOW FOR NON SUPERVISOR USERS ON LARGE REPOSITORY
13716991 - ODIWAITFORDATA GIVES ERROR IF THE TABLENAME CONTAINS UNDERSCORE OR PERCENT CHAR
13693252 - CORE - AS IN ODI 10G, ALLOW IMPORT-REPLACE MODE FOR PROCEDURES
13592619 - JAVA.UTIL.CONCURRENTMODIFICATIONEXCEPTION WHEN GENERATING SCENARIO OF INTERFACE
13573115 - BIAPPS: VARIABLES ARE REPLACED WITH RANDOM NUMBERS.
13445866 - REPOSITORY PERFORMANCE AWFUL FOR LARGE INTERFACES
13341997 - BIAPPS: QUICK-EDIT. DELETES INCORRECT JOINS WHEN SORTED.
13117372 - AS IN ODI 10G, ALLOW IMPORT-REPLACE MODE FOR PROCEDURES
8631771 - WORKREP RENUMBERING ALWAYS DETECTS NEW ID AS ALREADY USE
13651700 - ESSBASE IKM ERROR WITH SCENARIOS IMPORTED FROM ODI10 AND EXECUTED IN ODI11.1.1.5
10386668 - SHORT SCHEDULE REPETITIONS ARE DELAYED
12317781 - PROCESS (INDEX= , UID=, PID=) TIME OUT WHILE WAITING FOR A MANAGED PROCESS TO ST
8761717 - XML VALIDATION AT SYNTACTIC LEVEL FOR DTDS AND XSDS
13115564 - (NLS) PRINT ?INTERFACE? MAKE WRONG DEFINITION(BLANK) AT MAPPING INFORMATION.
13251720 - REVERSE COBOL COPYBOOK MAKE WRONG DEFINE IN MODEL
13112998 - AFTER UPGRADE INTO ODI 11.1.1.5 SCENARIO REPORTS 'ORA-00936: MISSING EXPRESSION'
13009103 - ODI STANDALONE AGENT HTTPS SUPPORT
12971227 - BIND VARIABLES ARE NOT SUBSTITUTED WHEN THEY ARE IN LOWERCASE
13146193 - IMPORT SCENARIO INTO NEW MASTER + EXE WORK REPO - THE VERSIONS ARE NOT IMPORTED
12944162 - THE ODI 11.1.1.5.0 TAKES 30 OR MORE SECONDS TO SWITCH TABS IN DESIGNER
13480235 - STARTSCENREMOTE.SH ONLY FIRST VARIABLE RECOGNISED IN WEBSERVICE
13538870 - HIERARCHICAL SESSIONS VIEW TODAY DOES NOT DISPLAY SESSIONS IN HIERARCHICAL ORDER
13465079 - INTEGRATION INTERFACES ARE NO LONGER ACCESSIBLES WITH NG PRIVILEGE ON PROJECTS
13491598 - STARTCMD ALWAYS RETURNS 0, DESPITE THE SESSION FAILURE IN ODI OPERATOR
13645147 - ERROR ENCOUNTERED WHEN A DATASTORE IS DRAGGED ON TO AN INTERFACE.
13688012 - ODIEXPORTOBJECT API HAS CHANGED BEHAVIOR FROM ODI 10G TO ODI 11G
13439276 - UPGRADE FAILS 'ORA-00001: UNIQUE CONSTRAINT (ODI_WORK_REP_10G.PK_TXT_HEADER)'
12560820 - LKM SQL TO ORACLE INVOLVING BLOB COLUMN FAILES WITH ORA-942
13834653 - RUP2_ST5: ODI - UNABLE TO CREATE DATA SERVER
13604288 - PROCEDURE OPTION VALUE OF NULL CORRUPTED DURING UPGRADE FROM 10G
12370811 - RANDOM CORRUPTION OF INTERFACES
12779124 - LOADING XML ON ODI 11G SI SLOWER THAN ON ODI 10
13472954 - 0 BYTE PDF FILE WAS GENERATED WHEN WE SELECT PRINT INTERFACE AT A CERTAIN FOLDER
13465079 - INTEGRATION INTERFACES ARE NO LONGER ACCESSIBLES WITH NG PRIVILEGE ON PROJECTS
11655078 - ODI CONSOLE CANNOT VIEW A SCENARIO DETAIL ON RUNTIME WORK REPOSITORY
9819026 - DELIM.FILE WITH TEXT DELIMETER - DATA VIEWER - NO DATA WHEN NUMERIC DATATYPE
11682398 - PACKED DECIMAL DATATYPE IS NOT PADDING LEADING ZEROS WHILE TRANSFORMING
11075760 - ERROR JAVA.LANG.NOSUCHMETHODEXCEPTION WHEN RESTORING FOLDER VERSION
13630149 - 0 BYTE PDF FILE WAS GENERATED WHEN WE SELECT PRINT FOLDER
13442395 - UA FAILS ON SQL SERVER REPOSITORY UPGRADING FROM 10G TO 11G
13632193 - AGENT ARRAYINDEXOUTOFBOUNDSEXCEPTION ON SCENARIO WITH ONCONNECT/ONDISCONNECT CMD
12705973 - B18: ERP: UNABLE TO LOGIN TO ODI CONSOLE
13539743 - UNABLE TO EDIT PHYSICAL SCHEMA SCHEMA/WORK SCHEMA NAME FIELD
13511368 - UNABLE TO EDIT DATASERVER INSTANCE/DBLINK FIELD
13578092 - ODI TO SUPPORT APPEND MODE DURING IMPORT

Bundled patch 14037855, Дата: 2013-02-07 Сборка.
14744472 - Smart export - the topology objects are exported regardless to the user profiles
14732277 - Remote repos - the opening of "expression editor" window is extremely slow
14704408 - Unable to use sunopsis memory engine in interface
14538962 - Unable to delete a temp interface from a main interface
14365485 - Issue in Oracle to JMS queue XML transformation.
14299121 - ODI shows dataset list with wrong order in PDF file
14275652 - Odiimportobject failing to import load plans
14215052 - NPE when exporting OBIEE webcatalog metadata, and language is set to Spanish
14209408 - Getting to mapping tab is much longer in 11G than in 10G
14204248 - ODI - unnecessary context password question while executing a scenario
14191659 - Mapping with lower case alias is broken
14160282 - ODI-50066: the given rpd file is invalid with ODI data lineage 11.1.1.6.2
14090493 - Studio is very slow , sqltrace shows repeated execution of queries
14002695 - Need to include file jps-config.xml_template to the patch
13947503 - Odisftpput/odisftpget tools do not transfer files after upgrade to vfs v2
13877712 - Odioutfile should not required -text parameter
13869161 - Unable to save column_name(odi-17591):"column name" is already used
13831392 - ODI-1232: procedure test proc_validate_labor WLS execution fails. weblogic.xml.c
13788407 - HFM member lists do not correctly restrict members in HFM LKM members to SQL
13717297 - Logging into ODI Studio too slow for non supervisor users on large repository
13716991 - Odiwaitfordata gives error if the tablename contains underscore or percent char
13693252 - Core - as in ODI 10G, allow import-replace mode for procedures
13592619 - Java.util.concurrentmodificationexception when generating scenario of interface
13573115 - BIAPPS: variables are replaced with random numbers.
13445866 - Repository performance awful for large interfaces
13341997 - BIAPPS: quick-edit. deletes incorrect joins when sorted.
13117372 - As in ODI 10G, allow import-replace mode for procedures
8631771 - Workrep renumbering always detects new id as already use
13651700 - Essbase ikm error with scenarios imported from ODI10 and executed in ODI11.1.1.5
10386668 - Short schedule repetitions are delayed
12317781 - Process (index= , uid=, pid=) time out while waiting for a managed process to st
8761717 - XML validation at syntactic level for DTDS and XSDS
13115564 - (NLS) Print ?interface? make wrong definition(blank) at mapping information.
13251720 - Reverse cobol copybook make wrong define in model
13112998 - After upgrade into ODI 11.1.1.5 scenario reports 'ora-00936: missing expression'
13009103 - ODI standalone agent https support
12971227 - Bind variables are not substituted when they are in lowercase
13146193 - Import scenario into new master + exe work repo - the versions are not imported
12944162 - The ODI 11.1.1.5.0 takes 30 or more seconds to switch tabs in designer
13480235 - Startscenremote.sh only first variable recognised in webservice
13538870 - Hierarchical sessions view today does not display sessions in hierarchical order
13465079 - Integration interfaces are no longer accessible with ng privilege on projects
13491598 - Startcmd always returns 0, despite the session failure in odi operator
13645147 - Error encountered when a datastore is dragged on to an interface.
13688012 - Odiexportobject api has changed behavior from ODI 10G to ODI 11G
13439276 - Upgrade fails 'ora-00001: unique constraint (odi_work_rep_10g.pk_txt_header)'
12560820 - LKM SQL TO ORACLE involving blob column failes with ora-942
13834653 - RUP2_ST5: ODI - unable to create data server
13604288 - Procedure option value of null corrupted during upgrade from 10G
12370811 - Random corruption of interfaces
12779124 - Loading xml on ODI 11G is slower than on ODI 10
13472954 - 0 byte pdf file was generated when we select print interface at a certain folder
13465079 - Integration interfaces are no longer accessibles with ng privilege on projects
11655078 - ODI console cannot view a scenario detail on runtime work repository
9819026 - Delim.file with text delimeter - data viewer - no data when numeric datatype
11682398 - Packed decimal datatype is not padding leading zeros while transforming
11075760 - Error java.lang.nosuchmethodexception when restoring folder version
13630149 - 0 byte PDF file was generated when we select print folder
13442395 - Ua fails on SQL server repository upgrading from 10G to 11G
13632193 - Agent arrayindexoutofboundsexception on scenario with onconnect/ondisconnect cmd
12705973 - B18: ERP: unable to login to ODI console
13539743 - Unable to edit physical schema schema/work schema name field
13511368 - Unable to edit dataserver instance/dblink field
13578092 - ODI to support append mode during import

Patch 16096942, Дата: 2013-01-11
11930440 Source table alias is case sensitive in ODI 11G
13117372 As in ODI 10G, allow import-replace mode for procedures
13644431 Operator/all schedules tab : all scenarios are listed even non authorized ones
13693252 Core - as in ODI 10G, allow import-replace mode for procedures
13717297 Logging into ODI Studio too slow for non supervisor users on large repository
13877712 Odioutfile should not required -text parameter
14191659 Mapping with lower case alias is broken
14271570 Java bean shell tasks seem to ignore any exceptions
14487844 New load plan with comment creation is failing with ODI-10135 error
14509410 Source column not highlighted due to case sensitivity

Patch 14279014, Дата: 2012-09-27
14279014 ODI sql commands use literal sql, leading to high SGA shared pool usage

Patch 14611933, Дата: 2012-09-27
13445866 Repository performance awful for large interfaces
14090493 Studio is very slow , sqltrace shows repeated execution of queries
14209408 Getting to mapping tab is much longer in 11G than in 10G
14409563 Remote repos - the interface design operations are longer in ODI 11G than in 10G

Patch 14588283, Дата: 2012-09-25
13445866 Repository performance awful for large interfaces
14090493 Studio is very slow , sqltrace shows repeated execution of queries
14209408 Getting to mapping tab is much longer in 11G than in 10G

Patch 14660486, Дата: 2012-09-24
11930440 Source table alias is case sensitive in ODI 11G
13002540 Requests from oim to grc are being invoked synchronously and this is taking too
13445866 Repository performance awful for large interfaces
13483792 OIM 11.1.1.5 compatbility with OAACG 8.6.3
13573115 BIAPPS: variables are replaced with random numbers.
13888489 Errors when parsing some utf-8 characters for multiple responsibilities request
14090493 Studio is very slow , sqltrace shows repeated execution of queries
14209408 Getting to mapping tab is much longer in 11G than in 10G
14409563 Remote repos - the interface design operations are longer in ODI 11G than in 10G
14509410 Source column not highlighted due to case sensitivity

Patch 14493022, Дата: 2012-09-17
14160282 ODI-50066: the given rpd file is invalid with ODI data lineage 11.1.1.6.2
14215052 Npe when exporting OBIEE webcatalog metadata, and language is set to Spanish

Patch 14209408, Дата: 2012-09-12
14209408 Getting to mapping tab is much longer in 11G than in 10G

Patch 14610140, Дата: 2012-09-12
13716991 Odiwaitfordata gives error if the tablename contains underscore or percent char
14271570 Java bean shell tasks seem to ignore any exceptions

Patch 14588286, Дата: 2012-09-10
14090493 Studio is very slow , sqltrace shows repeated execution of queries
14209408 Getting to mapping tab is much longer in 11G than in 10G

Patch 14578483, Дата: 2012-09-10
13573115 BIAPPS: variables are replaced with random numbers.
13592619 Java.util.concurrentmodificationexception when generating scenario of interface

Patch 13716991, Дата: 2012-09-08
13716991 Odiwaitfordata gives error if the table name contains underscore or percent char

Patch 14087811, Дата: 2012-08-15
14087811 ODI-26066 error message during creation of a new lookup object in interface

Patch 14271570, Дата: 2012-08-13
14271570 Java bean shell tasks seem to ignore any exceptions

Patch 13592619, Дата: 2012-08-13
13592619 Java.util.concurrentmodificationexception when generating scenario of interface

Patch 14364138, Дата: 2012-08-03
11930440 Source table alias is case sensitive in ODI 11G
13573115 BIAPPS: variables are replaced with random numbers.
14209408 Getting to mapping tab is much longer in 11G than in 10G

Patch 14322362, Дата: 2012-07-13
11930440 Source table alias is case sensitive in ODI 11G
14209408 Getting to mapping tab is much longer in 11G than in 10G

Patch 11930440, Дата: 2012-07-12
11930440 Source table alias is case sensitive in ODI 11G

Patch 12784671, Дата: 2012-07-12
12784671 Odiinvokewebservice incorrectly prefixes namespace,generates wrong payload file

Patch 13573115, Дата: 2012-06-21
13573115 BIAPPS: variables are replaced with random numbers.

Patch 13877712, Дата: 2012-06-13
13877712 Odioutfile should not required -text parameter

Bundled patch 14037855, Дата: 2012-05-24 Сборка.
10386668 Short schedule repetitions are delayed
11075760 Error java.lang.nosuchmethodexception when restoring folder version
11655078 ODI console cannot view a scenario detail on runtime work repository
11682398 Packed decimal datatype is not padding leading zeros while transforming
12317781 Process (index= , uid=, pid=) time out while waiting for a managed process to st
12370811 Random corruption of interfaces
12560820 LKM Sql to oracle involving blob column failes with ora-942
12705973 b18: erp: unable to login to ODI console
12779124 Loading XML on ODI 11G is slower than on ODI 10
12944162 The ODI 11.1.1.5.0 takes 30 or more seconds to switch tabs in designer


Патчи для версии 11.1.1.5

Patch 10288265 - патч для инсталляции других патчей. ОБЯЗАТЕЛЕН перед применением других патчей для 11.1.1.5.0 версии.
Patch 12415764 - крайне рекомендован для инсталляции, в противном случае вы не сможете видеть ошибки через приложение Оператор.


Patch 13919058, Дата: 2012-04-05
Merge request on top of 11.1.1.5.0 for bugs 11689756 12370811 13472954 13630149

Patch 13845109, Дата: 2012-03-26
Merge request on top of 11.1.1.5.0 for bugs 12370811 13472954 13630149 13797390

Patch 13783987, Дата: 2012-03-23
Merge request on top of 11.1.1.5.0 for bugs 12702144 13491598

Patch 13705147, Дата: 2012-03-13
Oracle Data Integrator 11.1.1.5.0 Patch Release Update 1 (One Off Patch 2) for Fusion Applications

Patch 13736256, Дата: 2012-03-05
Merge request on top of 11.1.1.5.0 for bugs 13633324 13633732

Patch 13696391, Дата: 2012-03-01
Merge request on top of 11.1.1.5.0 for bugs 12709543 12730462 12971227

Patch 12722119, Дата: 2012-02-23
Odiwaitforlogdata generates error on execution only environment

Patch 13688641, Дата: 2012-02-16
Merge request on top of 11.1.1.5.0 for bugs 13597857 13112998 13465079

Patch 13651700, Дата: 2012-02-08
ESSBASE IKM error with scenarios imported from ODI10 and executed in ODI11.1.1.5

Patch 13620940, Дата: 2012-02-07
Oracle Data Integrator 11.1.1.5.0 Patch Release Update 1 (One Off Patch 1) for Fusion Applications

Patch 11655078, Дата: 2012-02-07
ODI Console Cannot View A Scenario Detail On Runtime Work Repository

Patch 13146193, Дата: 2012-01-05
Import Scenario Into New Master + Exe Work Repo - The Versions Are Not Imported

Patch 12971227, Дата: 2012-01-05
Upgrade Assistant Does Not Handle Change In Case Sensitivity In ODI 11.1.1.5

Patch 12722119, Дата: 2011-12-23
OdiWaitForLogData Generates Error On Execution Only Environment

Patch 13009103, Дата: 2011-12-21
ODI Standalone Agent Https Support

Patch 12636186, Дата: 2011-12-20
Deleting Dataset Corrupts Interface

Patch 13043782, Дата: 2011-12-08
Add Flexfield "Sap_Allow_Abap_Execute" To Sap Abap Technology

Patch 8826035, Дата: 2011-12-08
Extract Member's Descriptions When We Have More Than One Alias Table In Hyperion

Patch 12317781, Дата: 2011-12-02
Process (Index= , Uid=, Pid=) Time Out While Waiting For A Managed Process To St

Patch 12700647, Дата: 2011-11-29
Variable Description Field In Not Displayed On Execution Screen In ODI Console

Patch 12905298, Дата: 2011-11-14
Interface Fails To Integrate On Step "Load Data Into Planning"

Patch 13093442, Дата: 2011-11-04
Essbase Lkm Attribute Extract Issues

Patch 12700750, Дата: 2011-10-14
All Startup Parameters Displayed While Executing Scenario By ODI Console

Patch 11731148, Дата: 2011-10-13
Jnp When Open Editor For Imported Scenario

Patch 12957474, Дата: 2011-10-12
Incorrect Values Propagated To Scenario On First Call From ODI Console

Patch 12798243, Дата: 2011-10-08
Fail To Reverse Using Rkm File (From Excel)

Patch 12730462, Дата: 2011-09-19
ODI Variable Refresh Fails If Self Referencing Variable Is Used

Patch 12657089, Дата: 2011-09-12
Package Execution Fails When One Of Its Steps Has The Log_Level 0

Patch 12415764, Дата: 2011-09-02
Sql Exception Not Thrown When Processing Batch Rows Remainder

Patch 11779704, Дата: 2011-07-29
Very Bad Performances When User With Ng Privileges Opens The Operator Module

Patch 12702144, Дата: 2011-07-29
ODI-20161: Standard Revers-Engineering Failed In ODI 11.1.1.5

Patch 10288265, Дата: 2011-07-15
Oracle Data Integrator 11g (11.1.1.5.1) Installer Patch

Patch 12564476, Дата: 2011-07-04
ODIInvokeWebService Prompts User Authentication Even -Http_User/Password Are Set

Patch 12317373, Дата: 2011-06-21
Incorrect ODIRef.GetJoin(I) Generated When Using Multi Data Sets And Lookups



Патчи для версии 11.1.1.3.0

Patch 13650357, Дата: 2012-02-27
Merge request on top of 11.1.1.3.0 for bugs 10349700 12700750

Patch 9531021, Дата: 2012-02-16
KM: cannot open error log file on metadata load into ESSBASE ASO app

Patch 13593973, Дата: 2012-02-14
If logical column more than 250 characters, ODI create incorrect a control file

Patch 12722119, Дата: 2012-02-06
Odiwaitforlogdata generates error on execution only environment

Patch 12558086, Дата: 2012-02-02
ODI release image does not include all HFM dll files

Patch 8761717, Дата: 2012-01-27
XML validation at syntactic level for DTDS and XSDS

Patch 13480235, Дата: 2012-01-27
Startscenremote.sh only first variable recognized in webservice

Patch 12652687, Дата: 2011-12-08
Import_Schedule Parameter Missing In ODI 11g

Patch 8761717, Дата: 2011-12-08
Xml Validation At Syntactic Level For Dtds And Xsds

Patch 12722119, Дата: 2011-11-30
OdiWaitForLogData Generates Error On Execution Only Environment

Patch 12573586, Дата: 2011-10-14
Ikm Sql To Hfm: Log File Is Created But Nothing Inside

Patch 11779704, Дата: 2011-09-23
Very Bad Performances When User With Ng Privileges Opens The Operator Module

Patch 12397991, Дата: 2011-09-16
Utf8 Japanese Characters Are Garbled On Column Setup Wizard

Patch 12722119, Дата: 2011-08-29
OdiWaitForLogData  Generates Error On Execution Only Environment

Patch 10041898, Дата: 2011-07-29
GetTable Doesn't Really Work In Jkm

Patch 12317373, Дата: 2011-05-13
Incorrect OdiRef.getJoin(I) Generated When Using Multi Data Sets And Lookups

Patch 11924462, Дата: 2011-04-25
LKM Bw Does Not Handle More Than 68 Columns (At Least For Dso,Ohd)

Patch 9503712, Дата: 2011-04-11
In ODI 11.1.1,  Xml Drive Has "Column" As Reserved Word

Patch 9853540, Дата: 2011-04-11
Journal Data : Ora-942 When Using Separate Work Schema

Patch 11883963, Дата: 2011-04-04
New Knowledge Modules For Soa Cross Referencing

Patch 10302682, Дата: 2011-03-28
IKM Sql To Planning: Log File Is Created But Nothing Inside.

Patch 11871678, Дата: 2011-03-25
Unable To Invoke Webservice From Large Wsdls Using OdiInvokeWebService

Patch 11737156, Дата: 2011-03-16
Source Xml: Are Not Able To Import Defintion File (.Xsd) Into ODI

Patch 9814235, Дата: 2011-02-21
Nosuchmethoderror During ODI_Server1 Startup

Patch 10349700, Дата: 2011-02-04
Startup Parameters Not Coming While Executing Scenario By ODI Console

Patch 10255390, Дата: 2011-01-12
ODI 11.1.1.3 Studio Usability Fixes (Multiple Bugs Fixed)

Patch 10172307, Дата: 2011-01-12
OdiInvokeWebService Unable To Invoke Webservices With User Authentication

Patch 10367427, Дата: 2011-01-12
Goldengate Jkms For Sybase Source Platforms

Patch 10083345, Дата: 2010-10-13
Goldengate Jkms For Ms Sql Server And Ibm Db2 Udb Source Platforms

Patch 10083293, Дата: 2010-10-13
A Set Of New And Modified Kms To Support Etl Style Interfaces


Список патчей для Oracle Data Integrator
10 версии с перечнями исправлений.

Version 10.1.3.6.10_01
Bugs Fixed
14186475 – Cursors are not closed white updating col/table description

Version 10.1.3.6.10
Bugs Fixed
13495698 - LKM SQL TO ORACLE involving BLOB column failes with ORA-942
13465079 - Integration interfaces are no longer accessibles with ng privilege on projects
12954272 - Trying to configure ODIXMLCONCAT hangs studio

Version 10.1.3.6.9_01
Bugs Fixed
13495698 - LKM SQL TO ORACLE involving blob column failes with ORA-942

Version 10.1.3.6.9
Bugs Fixed
12807021 - odi agent crashes when executing a data load to classic hfm
12635843 - odisqlunload command delete comment rows at the sql statement section
12635569 - odisqlunload command can't contain comment rows over 8 rows
12620573 - startcmd.sh got error but the session finished successfully on operator
12402779 - odistartscen fails to start child session, and "no suitable driver" is thrown
12324358 - xmlsplit does not create expected target files
11779704 - very bad performances when user with ng privileges opens the operator module
9844424 - odixmlsplit tool creates empty target files
9780900 - jms queue rollback incorrectly implemented on package termination
9692148 - use appropriate method for statements (executeupdate vs. Execute)
9046176 - wrong export order of members using lkm hyperion essbase metadata
8979305 - snp_orig_txt records incorrect i_var_value column for snp_step table
7165848 - unable to use 'external database' feature with mssqlserver and xml driver
6952828 - interface looses km option settings when restoring km version
6857509 - steps in operator are deleted automatically after re-generate a scenario

Version 10.1.3.6.8_08
Bugs Fixed
9692148 - Use appropriate method for statements (executeupdate vs. execute)

Version 10.1.3.6.8_07
Bugs Fixed
Bug 9780900 - jms queue rollback incorrectly implemented on package termination

Version 10.1.3.6.8_06
Bugs Fixed
12635843 - ODISQLUNLOAD command delete comment rows at the sql statement section
12635569 - ODISQLUNLOAD command can't contain comment rows over 8 rows

Version 10.1.3.6.8_05
Bugs Fixed
12412327 - Code generation increases disproportionately when many sessions are started on the agent.

Version 10.1.3.6.8_04
Bugs Fixed
9046176 - Wrong export order of members using LKM Hyperion Essbase Metadata

Version 10.1.3.6.8_03
Bugs Fixed
7165848 - Unable to use the 'external database' XML Driver feature with Microsoft SQL Server

Version 10.1.3.6.8_02
Bugs Fixed
6952828 - Interfaces loose their KM options settings when restoring a KM version.
9844424 - OdiXMLSplit tool creates empty target files.

Version 10.1.3.6.8_01
Bugs Fixed
12412327 - Code generation increases disproportionately when many sessions are started on the agent.

Version 10.1.3.6.8
Bugs Fixed
8826035 - Extract member's descriptions when we have more than one alias table in Hyperion
9878033 - Error 0x8000ffff "catastrophic error" during metadata loading via ODI
10021593 - Filtering on hierarchy version is not supported
10041898 - odiRef.getTable does not work correctly in JKMs
10331801 - Metadata Navigator launches 2 parallel sessions on a double click.
10354784 - filter on operator does not show running sessions
11075760 - Java.lang.nosuchmethodexception error appears when restoring folder version
11770013 - It is not possible to load data into bytea PostrgreSQL field using standard KMs
11803693 - Unicode support incorrectly implemented in the JMS XML topic technology
11808834 - Java process is killed while trying to connect to HFM 9.3.1.0
11877799 - Unable to log into ODI metadata navigator after having restarted the database

Version 10.1.3.6.7_01
Bugs Fixed
9046176 - Wrong export order of members when using LKM Hyperion Essbase Metadata to SQL.A new column called sortid is added to the all the dimensions to order the records. This column is automatically populated using a counter.

Version 10.1.3.6.7
Bugs Fixed
11804233 - Odihapp_essbase.jar and odihapp_common.jar have been recompiled with a JVM 1.4.2
10636218 - SAP OpenTool does not report back execution failures like a hash code mismatch
10632463 - Debug mode now traces connection and driver details to facilitate "no suitable driver" troubleshooting
10403202 - Unable to extract data from HFM using the multiperiod options
10380133 - The version shown in the log file of the Hyperion Planning and HFM adapters is hard-coded
10373089 - OdiFileMove fails to rename file when invoked in a package step or IKM task in certain scenarios
10359304 - Error while loading data using the Essbase adapter due to conversion issues
10302682 - IKM SQL to Planning: log file is created with no content
10298093 - The msvcr100.dll file is added for the 64-bit HFM Driver
10276429 - HFM data load does not complete in windows 2008 64-bit
10236232 - Hyperion Planning reverse engineer fails with error "com.hyperion.odi.common.ODIHAppException: Failed to import the models into ODI repository".
10166126 - Running Pre Load Maxl Scripts with IKM SQL to Hyperion Essbase Data fail with error "Error occured while executing maxl script. Error Message is: essmsh error: Could not open file for reading"
10126922 - LKM Hyperion Financial Management Data to SQL now support 64 Bit account hierarchy filter support for HFM 11.1.1.2. Accounts specified with ".*" are expanded automatically.
10124336 - LKM Hyperion Financial Management Data to SQL now support 64 Bit account hierarchy filter support for HFM. Accounts specified with ".*" are expanded automatically.
10124027 - ODI User Interface crashes when trying to load data to HFM using LKM SQL to Hyperion Financial Management Data
9549965 - Issue when creating a global marker group using a user with the NG Designer Profile
8664736 - OdiFileWait removes file when -ACTION is set to COPY, and -DIR and -TODIR are set to the same value.
8358993 - HFM member lists do not correctly restrict members in LKM Hyperion Financial Management Members To SQL
8241133 - OdiSqlUnload tool generates incorrect CLOB data in the text file for delimited and xml files.

Version 10.1.3.6.6_02
Bugs Fixed
10373089 - OdiFileMove fails to rename file when invoked in a package or IKM step
10359304 - Error while loading data into essbase using odi and essbase adapter

Version 10.1.3.6.6
Bugs Fixed
10164163 - Variable in URL of JMS XML queue techno incorrectly evaluated
7704715 - Importing a work in insert-update raises a nullpointerexception
8559892 - propagating the version change last date causes db deadlocks in multi usersusage
9859883 - Cannot insert technology to physical architecture in topology manager

Version 10.1.3.6.5_01
Bugs Fixed
10166126 - Running MAXL scripts with ODI 10.1.3.6 on Linux does not work.

Version 10.1.3.6.5
Bugs Fixed
10141600 - Generate All Scenarios do not allow variable selection for a package in a subfolder.
5994581 - LKM JMS XML to SQL "Truncate XML schema" task does not work.
9364998 - Master repository import fails with "integrity constraint (ODIPSR.FK_PROF_METH2) violated" error.
9964738 - "invalid object, it has been updated by another user" error when importing a project.
10025936 - Reverse-engineering EssBase 11.1.1.3 fails with error: com.hyperion.odi.essbase.ODIEssbaseConnection.getTables(Unknown Source)

Version 10.1.3.6.4
Bugs Fixed
9847668 - When a model is synchronized from a source repository to a target repository using import-export, the import in Synonym Insert-Update mode may fail due to cross references to interfaces not being correctly removed by the import process. The following error appears: "XML Import Error com.sunopsis.dwg.d: ObjectColumn : <column_name> is referenced by: Txt CrossRef : <id>, Txt CrossRef : <id> Cannot remove".
9723044 - While importing in Synonym Insert-Update mode a model containing a reference that was modified to use different columns, the following error appears: "<column_name> is referenced by: Reference / Column : Version 10.1.3.6.3
Bugs Fixed
8446089 - Master Repository upgrade resets the data servers' URLs.
9249230 - On Windows 2008 and Windows 7, OdiOSCommand execution fails with "java.io.IOException: Cannot run program "sh": CreateProcess error=2, The system cannot find the file specified".
9614140 - A user defined with a value in the Notes field (in the User Editor in Security Manager) is unable to login to any graphical module.
9661558 - Interface execution fails with "SnpsInexistantObjectException" when there is no connection between the context of source and the logical schema of the staging area.
9708500 - Master repository database connections remain in inactive state when scenarios are executed using a scheduler agent.
9723044 - Updated foreign keys cause "com.sunopsis.dwg.SnpsIsReferencedException: ObjectColumn : <column name> is referenced by: Reference / Column" errors during import.
9734323 - Restarting failed scenarios is not working in Operator.
9467619 - IKM Oracle Incremental Update's "Analyze Target" step doesn't differentiate whether Work schema or Data schema was selected for temporary target.
9329286 - Unable to perform a reverse-engineering using RKM Hyperion Financial Management from a 64-bit HFM 11.1.1.2 environment. This problem does not occur with HFM 11.1.1.3.
9201073 - Unable to load metadata that includes shared members into HFM 11.1.1.3.

Version 10.1.3.6.2
Bugs Fixed
7291916 - Unable to load data from file to target table if the data in the file is of type date.
7708885 - Import of folders with chained interfaces (temporary interfaces used in other interfaces) fails in INSERT_UPDATE mode
9134792 - On Linux, JMS XML Driver fails to connect with "javax.jms.JMSException: Cannot find the Connection Factory " error if the JNDI URL contains a subdirectory (for example, for a JNDI file provider)
9135700 - Parallel execution of SqlUnload tool fails with errors.
9308874 - Expanding the "Poplulated By" and "Used To Populate" at Datastore level for a temporary interface results in "edu.emory.mathcs.backport.java.util.concurrent.ExecutionException" error
9450149 - A webservice that doesn't requires any parameter fails with "com.sunopsis.sql.SnpsMissingParametersException" error when invoked from OdiInvokeWebService
9504001 - OdiWaitForLogData tool performance optimization on database connections and SQL commands.
6142001 - OdiPingAgent tool fails with a "java.lang.Exception: Invalid parameter" error when started using the startcmd command line script.

Version 10.1.3.6.1
Bugs Fixed
8494060 - Loading of scenario properties is very slow for non supervisor users.
8562992 - "java.lang.ClassNotFoundException" error appears when executing OdiInvokeWebService on AIX platform.
9032150 - Session startup performance optimization. Non-optimal SQL queries affected performance after migrating from Sunopsis.
9393932 - Unable to move procedure steps in duplicated procedures.
9450870, 9336082 - RKM Teradata: Foreign Keys are not correctly reverse-engineered.



Version 10.1.3.6.0

Bugs Fixed
• 8855049 - Random "java.sql.SQLException: Closed Connection" error appears when running scenarios, while updating a session task. Connection to the repository is lost and session stops.
• 7696856 - Users not having "view/edit data" privileges are able to see table data through interface diagrams.
• 8993849 - Some session task logs are grayed out for a user with limited privileges in operator.
• 9309858 - IKM SQL To Hyperion Planning: ERROR_LOG_FILENAME overwrites and does not append log content.
• 9056142,9188539 - Repository Structure Fix. This patch set includes a fix to the repository structure. Running an upgrade of the Master and work repositories after this patch fix invalid the repository structures. See Repository Structure Fix for more information.

Version 10.1.3.5.6
Bugs Fixed
• 6870772 - Unable to reverse engineer a Datastore or to insert/update a Datastore containing a LOB family type object.
• 6667705 - Version restore operation causes a deadlock and prevents simultaneous users from updating other repository objects.
• 8855049 - While updating a session task, repository connections are closed abruptly there by causing "closed connection" exception .
• 8967643 - "java.lang.NumberFormatException:" when attempting to connect to a set of XSD files.
• 9103310 - With no overwrite on change configured, IKM Oracle Slowly Changing Dimension fails at step 272 "Updating Existing Row".
• 9235923 - Missing KMS in the impexp folder, LKM DB2 400 Journal to SQL and JKM DB2 400 Simple (Journal).
• 9094083 - LKM SAP ERP to Oracle (SQLLDR) : File separator changed to \n for UNIX systems.
• 9170437 - RKM SAP ERP: Retrieve list of SAP modules dynamically.
• 9094083 - LKM SAP BW to Oracle (SQLLDR) : File separator changed to \n for UNIX systems.
• 9249552 - SAP BW RKM : Obsolete step "INSTALL RFC FUNCTIONS" removed from KM.
• 8848077 - OdiSAPAleServer and OdiSAPAleClient cannot connect to recent sap Netweaver systems. This is due to an incompatibility of these tools with JCO 3. To use a compatible version of the tools. Alter the SAPALE tools calls to use with OdiSAPAleServer3 and OdiSAPAleClient3 instead.
• 9201073 - Cannot load metadata that includes shared members into HFM 11.1.1.3

Version 10.1.3.5.5
Bugs Fixed
• 7274910 - Killing a Session generates the following error on DB2 UDB repositories: "DB2 SQL error: SQLCODE: -408, SQLSTATE: 42821, SQLERRMC: I_TXT_STEP_MESS".
• 8446089 - Master Repository upgrade resets the data servers' URLs.
• 8529169 - "Class not registered" error while loading metadata into Hyperion Financial Management classic application using an 64-Bit HFM Client. 
A new 64-bit driver (HFMDriver64.dll) has been added to the /oracledi/drivers directory. To use this driver on a 64-Bit platform with a 64-Bit HFM Client installed, rename HFMDriver.dll as HFMDriver32.dll and rename HFMDriver64.dll as HFMDriver.dll.
• 8636504 - Customized reverse-engineering using RKM Salesforce.com fails with the error "UNKNOWN_EXCEPTION: Destination URL not reset. The URL returned from login must be set in the SforceService" .
• 8640312 - SNP_EXP_TXT still contains records for session variables after a log purge.
• 8713986 - Consolidation attribute "^" (Never Consolidate - Added in Essbase 9.3.1) is not handled in the Essbase KM. The Extract Metadata step fails with error "No_matching_Enum_found".
• 8844655 - Metadata Navigator Data Lineage feature fails to work in headless mode.
• 8912703 - When an Essbase member is rejected due to error "3303: Member not found in database" the log does not indicate which member caused the record to be rejected.
• 8988790 - ODI internal IDs reset to 0 once its limit is reached causing repository corruption. In this version internal IDs are no longer automatically reset to zero.
• 8989114 - Users having only View privilege cannot see procedure and KM lines and receive the error: "You are not authorized to Edit the Object"
• 9076431 - Historized variables do not return the latest variable value if an internal ID (SNP_VAR_DATA.I_VAL) reset was performed for variable values (bug 8988790). This version solves this problem by taking the latest value based on value creation date and not the internal ID.
• 9080483 - Essbase Interface fails with "ImportError: No module named hyperion" on the "Prepare for loading step" when loading ASO/BSO data into Essbase.
• 9126706 - Metadata Navigator does not start after deploying the oracledimn.war from the ODI patch 10.1.3.5.3

Version 10.1.3.5.4
Bugs Fixed
• 6447278 - RKM Oracle doesn't import the check constraints of tables.
• 8550987 - LKM File to Oracle (SQLLDR) fails with error: "Field in data file exceeds maximum length" when loading a file that contains a string longer than 255 characters.
• 8605840 - Model or Model folder creation fails with java.lang.stackoverflowerror if the user is not a supervisor user having metadata admin profile.
• 8854189 - ODI Master Repository import incorrectly deletes existing data server connections if the insert_update mode is selected.
• 8871204 - Master Repository import aborts when user expands a node in Topology Manager.
• 8899683 - JKM DB2 400 Simple (Journal) does not handle uncommitted transaction with CDCRTVJRN.
• 8904234 - Sessions continue to execute even if the Master Repository connection is terminated.
• 8917148 - Timestamp datatypes loose time precision after the millisecond when data is loaded via the agent.

Version 10.1.3.5.3
Bugs Fixed
• 5995469 - Empty numeric fields in delimited files are treated as a '0' (zeros) instead of null values.
• 7343670 - Long SQL statements in logs are truncated by Import/Export.
• 7489803 - XML JDBC driver is unable to handle XSD having xsd:restriction in ComplexType.
• 8373852 - Unique constraint violation error occurs on "Reverse - Get FK" step when using RKM E-Business Suite.
• 8571901 - Loading data to XML fails when "Commit 1000 Rows" option is used in the LKM.
• 8624002 - Inconsistency in datastore definition after deleting a column from the Model tree.
• 8668465 - XML driver fails if DB schema is set in db_props file.
• 8676282 - OdiImportObject does not use the workrep parameter from the odiparams file.
• 8709634 - RKM Teradata does not handle correctly timestamp(0) datatypes.
• 8713484 - OdiReadMail tool is not taking into account the platform encoding during attachment download.
• 8721876 - ' "' characters in attribute values are removed when using external storage for the XML driver.

Version 10.1.3.5.2
Bugs Fixed
• 8320399 - OdiExportAllScen execution fails if source Project parameter is empty
• 8614797 - Project documentation (Print to PDF) shows KM commands in a wrong order.
• 8333319 - WSDL containing Complex content with Extension/Restriction causes a "Part Does not Exist" error in OdiInvokeWebService.
• 8417826 - Scheduler agent does not close the master repository connections when failing to connect the work repository.
• 8529951 - Unique constraint (PK_EXP_TXT) violation error appears when starting a scenario.
• 8527219 - Sub-Model objects are not exported when using OdiExportObject tool. The following error appears: "Unable to find the object with type SnpSubModel and identifier ..."
• 8474594 - XML 'boolean' values ('1' or '0') are always read as '0' by the XML driver.
• 7393196 - Scenario started with a log level smaller than 5 are not purged correctly, causing the SNP_EXP_TXT work repository table to grows indefinitely.
• 8657545 - OdiSqlUnload tool adds extra spaces when unloading columns of type CHAR.
• 8559586 - Public Web Service returns a response with an empty session ID when starting sessions on a load balancing parent agent and when this agent is exclusively set up to do load balancing.
• 8471871 - Scenarios are not displayed in Metadata Navigator under scenario folders when connected to an execution work repository

Version 10.1.3.5.1
Bug Fixed
• 8214243 : Upgrade to 10.1.3.5 fails with 'table already exists' error
• 7655965 : Agent window stays open even in case of a repository connection problem
• 6777963 : Unable to execute scenario by a user having generic privileges on contexts.
• 6394344 : ODI not reading more than one JMS XML messages even after setting MessageMaxNumber=2
• 5995743 : Work repository import fails with integrity constraint violation
• 6622519 : OdiReverseSetMetadata does not retrieve all the datastores during reverse
• 6711431: Testing connection with an agent to IBM MQ throws "JAVA.LANG.EXCEPTION:"
• 7191727: RKM Oracle now uses ALL_OBJECTS instead of SYS.DBA_OBJECTS.
• 7365439: RKM Oracle now handles correctly of precision of oracle TIMESTAMP columns
• 8312924: IKM Oracle Slowly Changing Dimension does not sets to 0 the field indicated as Current Record Flag.
• 6885530 RKM Oracle OLAP (Jython) throws a "No End Separator for the following text" error

Version 10.1.3.5.0_02
Bug Fixed
• 7650278: Hyperion Financial Management 9.3.0.3 wasn't correctly supported by the Hyperion Financial Management Adapter.
• 8213454: Agent schedules are replaced even if the 'import schedules' option is not switched on.
• 8222432: OdiInvokeWebService command/tool is incorrectly parsing WSDL having XML base elements like long, string etc in Complex Type element.
• 8247319: OdiXMLConcat is creating XML target file with incorrect data.
• 8267556: Importing in Operator in duplication mode creates "copy of ".
• 8312924: IKM Oracle Slowly Changing Dimension uses MINUS instead of 'Not Exists' operator.
• 8334678: Session steps minutes and seconds not shown fully in operator right pane.
• 8214474: PostgreSQL standard BIGINT datatype is not defined in ODI Topology.

Version 10.1.3.5.0_01
Bug Fixed
• 7420284: Adding to a solution a project using a model stored in a model folder displays now the model folder and not only the model in the required elements.
• 7538565: The getInfo substitution method is now able to return the value of JDBC Properties called "password".
• 7551228: A variable password can be defined by specifying a "password" property with an ODI variable as the value in the "JDBC Properties" tab.
• 7709128: The import of a Master Repository in synonymy INSERT_UPDATE mode fails with no message when a data server with the same already exists in the target repository.
• 7717515: Upgrade of Sunopsis V4.1 to Oracle Data Integrator 10.1.3.5.0 removes the URLs for data servers and work repositories.

Источник: замечательный блог http://john-goodwin.blogspot.com/, перевести заметки из которого все не доходят руки, а там есть настоящие бриллианты по методам подстановки и многому другому.

Обновление с 10.1.3.2 до 10.1.3.3

Список пофиксеных багов

# 5994142 : OdiOSCommand throws an error when executed on Windows Vista.
# 5994306 : Repcreate.sh fails to display any technologies in the panel when running on SuSE Linux.
# 5994366 : Changes in the work repository are only visible in Flow Map after relogin to Metadata Navigator.
# 5994368 : It is impossible for a user with generic privileges on versions to visualize the “Versions checkbox” on the Version tab.
# 5994386 : Not indicating the fields “sequence name” and “position” of the package created with the API OdiReinitializeSeq displays the wrong error message.
# 5994814 : Incorrect scenario text after import in synonym update mode.
# 5994914 : A popup window informs you that the connection to the physical agent failed when you try to view the schedule information and the physical agent is not launched.
# 5995019 : Regeneration of a scenario deletes the execution reports.
# 5995103 : Wrong Icon for references after refreshing the treeview.
# 5995147 : Wrong date/time information in the “Scheduling information” dialog for the execution of a scenario.
# 5995116 : SnpsReadMail does not create the folders as specified by the -FOLDERS_OPT prameter
# 5995240 : When performing a search the session steps are not displayed under the sessions in the treeview of Operator.
# 5995286 : Possibility to set the SUPERVISOR’s password when creating a master repository.
# 5995297 : Sunopsis GUI does not start if any additional file has been detected in the /lib/skins folder.
# 5995302 : The option “Except these days of the month” is automatically checked when an “Active for the period” schedule is created in the Scheduler.
# 5995316 : Exporting technical environment on a case-sensitive SQL server repository fails with error : “Invalid Column name ‘Rep_Name’”.
# 5995317 : Importing user functions in SYNONYM_INSERT_UPDATE mode loses the reference to the technologies to which the implementations are linked to.
# 5995321 : When importing a KM in SYNONYM_INSERT_UPDATE mode, the lines options are lost.
# 5995324 : It is possible to create multiple primary keys on datastores.
# 5995336 : Reversing a file raises the error “File not found” if the resource name is a global variable.
# 5995434 : Incorrect behavior of the parameters SOURCE_*_DT and DEST_*_DT in the getFKColList method. When using the snpRef.getFKColList(), the parameters SOURCE_DT, SOURCE_CRE_DT, SOURCE_WRI_DT, DEST_DT, DEST_CRE_DT, and DEST_WRI_DT do not return any information.
# 5995531 : It is impossible to update the data of a Microsoft SQL Server table with the Data Editor.
# 5995504 : Incorrect management of parameters -GRPMARKER et -MARKER for odiGenerateAllScen.
# 5995547 : When selecting a RKM for a model all RKMs are displayed in the combo box regardless of the source technology set for the KM.
# 5995551 : Impossible to delete in a package a variable from the Additional Variables tab of the scenario’s properties.
# 5995553 : The API getFrom() generates undesired supplementary C$ table references.
# 5995556 : The API getFilter() generates a wrong syntax for the filters on Sybase.
# 5995566 : The display of the resource name in the model tree view should be optional for a better clarity.
# 5995572 : The icon marker indicating the journalizing status of datastores in models does not refresh automatically when a datastore has been added to CDC or has been removed from CDC.
# 5995577 : Editing datatype definitions in topology is very slow with a remote database.
# 5995600 : Viewing data of delimited flat files containing NULL values for date fields generates a NullPointerException.
# 5995602 : The Zoom functions for viewing the scheduling information of the agent in a diagram do not work correctly.
# 5995608 : Viewing a Session with a Session Number greater than 2150764 generates a java.lang.NumberFormatException.
# 5995612 : Scheduler keeps on executing a session even if it has been stopped.
# 5995623 : After refreshing the tree view in Getting Started, check constraints are displayed as a copy of already existing PK and generate an java.lang.reflect.InvocationTargetException.
# 5995631 : The value of a text variable is not always returned when a session is executed.
# 5995633 : When clicking Apply after reverse-engineering a COBOL Copybook, the reversed columns disappear.
# 5995634 : LightWeight Designer does not check if it connects to the appropriate work repository.
# 5995674 : Duplicating a command line in a KM does not duplicate the corresponding setting options.
# 5995675 : Swapping two command lines in a KM disarrays the options settings.
# 5995678 : Using the command of the API ODIOutFile truncates the default value of a text variable when the variable contains more than 250 caracters.
# 5995683 : When updating the scheduled period to display in Operator, the “update finished” message raises before the action is done.
# 5995697 : Upgrading with the mupgrade tool from a 4.1.01.06 to a 10.1.3.2.0 may lead to “SnpMtxt does not exist” error message.
# 5995702 : Generating a PDF report of a diagram raises a NullPointerException error message.
# 5995703 : Printing a knowledge module from a project raises a NullPointerException error message when SKMs have been imported into the project.
# 5995741 : An incorrect error message is displayed with OdiFileWait when the -PATTERN parameter is missing.
# 5995755 : Saving a package after deletion of a startscen additional var, raises an “ArrayIndexOutOfBoundsException”.
# 5995759 : Creating a reference raises the error message “The field Table is mandatory” if the selected parent table has a name containing more than 50 characters.
# 5995760 : On DB2400 the Alias field of a datastore is empty after reverse-engineering for datastores with names containing more than 35 characters.
# 5995762 : Viewing the steps of execution in the Hierarchical View of the Operator after the executioon of two procedures raises the error message “Ambiguous column name ‘NB_RUN”.
# 5995764 : The “Closed Connection” error is raised when the same scenario is launched several times with a schedule.
# 5995774 : When the property panel of an OdiInvokeWebServices tool step is undocked, clicking the “Advanced” button raises a “java.lang.ClassCastException”.
# 5995795 : Error message is displayed twice when trying to edit a locked datastore’s reference.

Источник: уже упоминавшийся мною блог http://dwhbi.com/


Список патчей для модулей знаний.

Version 10.1.3.6.8
Bugs Fixed
9799842 - LKM ERP: long SAP column names can lead to ABAP syntax errors
10094400 - LKM ERP: ftp_transfer_method=none mode does not work
10285683 - LKM SAP BW: line breaks in data may cause data loading issues
10426660 - LKM ERP: filter with two variables does not work
10634167 - LKM SAP BW: drop work table must always be executed
11660553 - LKM SAP BW: process chain completion status not handled
11683146 - LKM SAP ERP/BW: no new transport request created
11688643 - LKM SAP ERP does not report failure when opening output file
11727728 - LKM SAP ERP: field names too long
11802623 - SAP open tool does not upload on Unicode system
11892290 - LKM SAP BW: transfer option none causes wrong FTP path
11924462 - LKM SAP BW does not handle more than 68 columns (at least for dso, ohd)
11733199 - RKM SAP ERP should reverse views

Version 10.1.3.6.7
Bugs Fixed

10636218 - SAP OpenTool does not report back execution failures like a hash code mismatch

Version 10.1.3.6.6
Bugs Fixed
10126210 - RKM SAP ERP fails, if zreturn data type is already defined
10126214- RKM SAP BW fails, if zreturn data type is already defined
10161344 - LKM SAP BW to Oracle (SQLLDR): interfaces are not added to transport request
10184100 - LKM SAP BW to Oracle (SQLLDR): upload/execution failure due to lack of synchronization
10243524 - LKM SAP BW to Oracle (SQLLDR): long SAP column names can lead to ABAP syntax errors
10285447 - LKM SAP BW to Oracle (SQLLDR): extraction from infocube only supports single filter
10285620 - LKM SAP ERP to Oracle (SQLLDR): scenario fails in production as it does not match abap code
10300495 - RKM SAP BW: NullPointerException when reversing infoobject with text but no master data table
9054865 - LKM SAP ERP to Oracle (SQLLDR): data records are cut off at position 500
9178774 - Reduce parameters in opentool calls
9298970 - LKM SAP BW to Oracle (SQLLDR): column separator not implemented
9400457 - RKM SAP BW: NullPointerException when using /wo installed RFCs
9463503 - RKM SAP BW SAP installation fails due to invalid parameter

Version 10.1.3.6.5
Bugs Fixed

10216223 - SAP Open Tool: blanks removed from default values for import parameters.
10125386 - SAP Open Tool should support RFC without any parameters.
10202485 - LKM SAP ERP to Oracle (SQLLDR): Open Tool log file not created in bi-apps log dir.
10184061 - LKM SAP ERP to Oracle (SQLLDR): Upload/execution failure due to lack of synchronization.
9385073 - LKM SAP ERP to Oracle (SQLLDR): Problem with fields containing \n on windows SAP systems.
9800220 - RKM SAP ERP: wrong error message when no table has been selected.
10216273 - LKM SAP BW to Oracle (SQLLDR): KM option field_separator changed to <@=""+(char)8@>.
10208560 - LKM SAP BW to Oracle (SQLLDR): Release resources code not working properly in package.
10181923 - LKM SAP BW to Oracle (SQLLDR): ABAP syntax error if infoobjectname contains brackets.
10181239 - LKM SAP BW to Oracle (SQLLDR) fails when used with filter condition containing variable
10164053 - LKM SAP BW to Oracle (SQLLDR) hard-codes FTP path into ABAP code
10152425 - LKM SAP BW to Oracle (SQLLDR): Extract error for Z-cubes (customized cubes).
10148351 - LKM SAP BW to Oracle (SQLLDR) does not support extraction from OHD tables with semantic key.
10063489 - LKM SAP BW to Oracle (SQLLDR): Problem when extracting many columns from infocube.
10130050 - RKM SAP BW fails on infocubes using system infoobjects.
10114589 - RKM SAP BW: default value for ods_dso_name should be blank.
10021627 - RKM SAP BW: Related infoobjects are not reversed if there is no master data
9759892 - Typos in ftp_transfer_method option description

Version 10.1.3.6.4_01
Bugs Fixed
10063489 - Enhancement to the KM_LKM SAP BW to Oracle (SQLLDR).xml to extract from source tables which contain more than 35 columns.

Version 10.1.3.6.4
Bugs Fixed
9746913 - When data is extracted from SAP OpenHubDestination the order of the source columns (OHD columns) must match the order of the target table columns. Otherwise an exception is thrown.
9614560 - LKM BW invokes the process chain given in Knowledge Module option PROCESS_CHAIN, but starts data extraction without waiting for the process chain to complete.
9818544 - SAP BW OpenHub extraction does not work in due to incorrect column ordering in odiRef.getColList calls in LKMs
9670666 - A sequence of interfaces using the same process chain require that the process chain is specified for each of them.
9467503 - When reversing InfoCubes only some dimension characteristics are reversed. InfoObjects with no own attributes are omitted during reversing.

Version 10.1.3.6.2
Note: This version includes new/updated flexfields for the SAP ERP and SAP ABAP Adapters and requires a master repository upgrade.
Bugs Fixed
9384804 - LKM SAP BW to Oracle (SQLLDR): code generation fails on Unix platforms on step "Extract data".
9384860 - LKM SAP ERP to Oracle (SQLLDR): code generation fails on Unix platforms on step "Extract data".

Version 10.1.3.6.1
Bugs Fixed
9345681 - OdiFtpGet: Relative path starts with the wrong base directory.
9358765 - New dataserver flexfield: sap_character_set for supporting non-UNICODE SAP source system.
9378965 - RKM SAP BW: When running the RKM into new SAP system, step "Install Base Function" fails with the following error: LV_TASK not a member of INPUT.
9378952 - RKM SAP ERP: When running the RKM into new SAP system, step "Install Base Function" fails with the following error: LV_TASK not a member of INPUT.
9449022 - FTP error messages raised from SAP KMs are not shown in operator.

Version 10.1.3.6.0
Bugs Fixed
9094083 - LKM SAP ERP to Oracle (SQLLDR) : File separator changed to \n for UNIX systems.
9170437 - RKM SAP ERP: Retrieve list of SAP modules dynamically.
9094083 - LKM SAP BW to Oracle (SQLLDR) : File separator changed to \n for UNIX systems.
9249552 - SAP BW RKM : Obsolete step "INSTALL RFC FUNCTIONS" removed from KM.

Предупреждение для добравшихся до конца списка багов. Он неполон, часть существенно важной информации не приведена, в частности, информация о новых фичах в некоторых баг фиксах, а также возможная необходимость модификаций в мастер репозиториях. Внимательно читайте примечания к патчам!

Дата последнего изменения: 30.03.2012