čtvrtek 24. září 2009

Nová verze ODI - Cumulative Patch Set 10.1.3.5.3

Jeste před vydáním Oracle Data Integrator 11g byl uvolněn (14.9.2009) kumulativní patch set, který základní verzi ODI 10.1.3.5.0 povýší na verzi 10.1.3.5.3. Patch set může být instalován i na dříve vydané 10.1.3.5.x patch sety, tj. 10.1.3.5.0_01, 10.1.3.5.0_02, 10.1.3.5.1, 10.1.3.5.1_01, 10.1.3.5.2, 10.1.3.5.2_02.

Patch je ke stažení z Metalinku, pod označením 8909138 - link na patch najdete zde.

Co nového jednotlivé verze přináší najdete níže.


Version 10.1.3.5.3.
New/Modified Objects
The following KMs have been modified or added in this version:
  • RKM E-Business Suite
  • RKM SAP ERP
  • RKM SAP ERP Connection Test
  • LKM SAP ERP to Oracle (SQLLDR)

The following technologies have been modified or added in this version:

  • SAP ABAP

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_02
Bugs Fixed
  • 8589752 - KM SQL to Essbase Data - Load in bulk mode instead of row by row processing when an error occurs during load.

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_01
New/Modified Objects

The following KMs have been modified or added in this version:

  • LKM SAP ERP to Oracle (SQLLDR)

  • RKM SAP ERP

The following technologies have been modified or added in this version:

  • SAP ABAP

New Features
  • SAP ABAP Adapter is available in this release. This adapter includes the SAP ABAP technology and the LKM SAP ERP to Oracle (SQLLDR) and RKM SAP ERP knowledge modules. The Knowledge Module Reference's Guide was updated with a description of this adapter and a new Getting Started with SAP ABAP Adapter guide has been added to the documentation library. Note that this adapters requires SAP JCo 3.0.2, a JVM 1.5 and Oracle Data Integrator version 10.1.3.5.1 or above to run.


Version 10.1.3.5.1

Note: In addition to the bugs listed below, all bugs and new features listed in into previous versions are merged into this version.
New/Modified Objects
The following KMs have been modified or added in this version:
  • IKM Oracle Slowly Changing Dimensions (modified)

  • RKM Oracle

  • RKM Oracle OLAP (Jython)

The following technologies have been modified or added in this version:

  • SAP ABAP

  • All technologies have been upgraded with new datatypes.

New Features
  • 8214474 : Need the support for BIGINT datatype for PostgreSQL technology in topology

  • 7460039 : Need the ability to connect to sap systems using logon groups

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.



Erik Eckhardt

Žádné komentáře: