User manual BUSINESS OBJECTS DATA INTEGRATOR 11.7.3 RELEASE NOTES 10-2007

[. . . ] BusinessObjects Data Integrator Release Notes Data Integrator 11. 7. 3 October 31, 2007 Copyright © 2007 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 6, 247, 008; 6, 289, 352; 6, 490, 593; 6, 578, 027; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998 and 7, 139, 766. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence, Crystal Enterprise, Crystal Analysis, Web Intelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] ADAPT00635201 In the Data Integrator Designer, the trace logs are now sorted properly by date when clicking on the Date column header. BusinessObjects Data Integrator Release Notes 57 7 Resolved issues ADAPT00635698 In the DB2 table loader, if the Use input key option is selected and if any generated UPDATE statements updated more than one row, the load failed. ADAPT00635475 A new option has been added for the Sybase IQ bulk loader that allows you to specify the row delimiter in the data file generated by Data Integrator. ADAPT00637736 In a real-time job, using the same data flow more than once caused an incorrect SQL INSERT statement to be generated. ADAPT00638268 When running Data Integrator with SAP R/3 version 3. x, the following error could occur: BODI-1112339:Error:Cannot import the metadata table <name=*-CCSS-KOSTL>. R/3CallReceive er ror <function Z_AW_TREE_IMPORT40: Call (PER FORM) to a non-existent routine. This problem has been fixed. ADAPT00641650 When using the Ignore row marker option in the flat file format, data truncation could occur. ADAPT00642513 When importing a database link created in Microsoft SQLServer 2005, the Designer did not recognize the database link as a valid link. ADAPT00642531 When a COBOL copybook contained REDEFINES sections, the data for those fields was not processed properly by Data Integrator. ADAPT00642556 When a data flow or a work flow runs in an infinite loop, the Data Integrator engine process (al_engine) leaked memory. Data Integrator also now submits a slightly different SQL statement to Microsoft SQL Server to improve performance when retrieving changed data from the SQL Server replication server distribution database. 58 BusinessObjects Data Integrator Release Notes Resolved issues 7 ADAPT00644740 When defining a custom function in the Designer, the order of the input parameters was reversed in the function. ADAPT00645348 In Auto Documentation, the Case Transform did not display correctly. ADAPT00645757 The Repository Manager failed if you upgraded a repository from a computer with a Designer-only Data Integrator installation. ADAPT00646862 For Microsoft SQLServer CDC readers, there is a new option in the source editor called Automatically delete rows after reading. This option lets you delete rows after reading them from the replication server to manage server volume. For example, if many rows collect on the replication server during a given retention period, performance could suffer. If you select this option, Data Integrator deletes only the rows that have already been read by all Data Integrator CDC readers and other named subscriptions (and also observes the retention period setting). However, if there are additional anonymous subscribers, Data Integrator is unable to identify them and could delete rows regardless of whether they have been read by those subscribers. A CDC reader subscription is not established until the first time a job with such a subscription is successfully executed. If in the CDC reader Automatically delete rows after reading option is selected, and this reader with this subscription has not been executed before in any other data flow, Data Integrator will assume that there is only one subscription and the data will be purged after reading. This behavior will stop after the job has been executed at least once. If that is not the desired behavior, try these workarounds: · Do not enable Automatically delete rows after reading for the first run of the Data Integrator job to establish all subscriptions. · If a CDC table has more than one subscription, check the Delete after reading option in one CDC source only and execute the corresponding job last. BusinessObjects Data Integrator Release Notes 59 7 Resolved issues ADAPT00647533 The function get_domain_description() did not return a value when used with PeopleSoft 8. 9 domains. ADAPT00647923 The Performance Optimization Guide incorrectly stated that if a data flow was not valid or saved, Data Integrator alerted you when you tried to view optimized SQL for the data flow. [. . . ] The project can be used in a data flow as long as the fields containing periods are not used. A workaround for this problem is to rename any Data Quality project fields to use another character instead of the period. Business Objects suggest using the underscore character ("_"). BusinessObjects Data Integrator Release Notes 87 8 Known issues ADAPT00741303 The Message Client sample (client_sample) program in the AccessServer directory has not been updated for this release. ADAPT00743879 Data Integrator does not correctly handle Oracle UTF8 database the NCHAR data type in a table comparison rowby-row select option if the column is used in the primary key or compared column. [. . . ]