Informatica PowerMart/PowerCenter Troubleshooting Guide Version 5.1.0 June 2001 Copyright (c) 2001 Informatica Corporation. All rights reserved. Printed in the USA. This software and documentation contain proprietary information of Informatica Corporation, they are provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. No part of this document may be reproduced or transmitted in any form, by any means (electronic, photocopying, recording or otherwise) without prior consent of Informatica Corporation. Use, duplication, or disclosure of the Software by the U.S. Government is subject to the restrictions set forth in the applicable software license agreement as provided in DFARS 227.7202-1(a) and 227.7702-3(a) (1995), DFARS 252.227-7013(c)(1)(ii) (OCT 1988), FAR 12.212(a) (1995), FAR 52.227-19, or FAR 52.227-14 (ALT III), as applicable. The information in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Informatica Corporation does not warrant that this documentation is error free. Informatica, PowerMart, PowerCenter, PowerChannel, PowerConnect, PowerPlug, PowerBridge, and MX are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughout the world. All other company and product names may be trade names or trademarks of their respective owners. Portions of this software are copyrighted by MERANT, 1991-2000. Apache Software This product includes software developed by the Apache Software Foundation (http://www.apache.org/). The Apache Software is Copyright (c) 1999-2000 The Apache Software Foundation. All rights reserved. Redistribution and use in source and binary forms of the Apache Software, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. The end-user documentation included with the redistribution, if any, must include the following acknowledgment: “This product includes software developed by the Apache Software Foundation (http://www.apache.org/).” Alternately, this acknowledgment may appear in the software itself, if and wherever such third-party acknowledgments normally appear. 4. The names “Xerces” and “Apache Software Foundation” must not be used to endorse or promote products without prior written permission of the Apache Software Foundation. 5. Products derived from this software may not be called “Apache”, nor may “Apache” appear in their name, without prior written permission of the Apache Software Foundation. THE APACHE SOFTWARE IS PROVIDED “AS IS” AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The Apache Software consists of voluntary contributions made by many individuals on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, International Business Machines, Inc., http://www.ibm.com. For more information on the Apache Software foundation, please see http://www.apache.org/. DISCLAIMER: Informatica Corporation provides this documentation “as is” without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of non-infringement, merchantability, or use for a particular purpose. The information provided in this documentation may include technical inaccuracies or typographical errors. Informatica could make improvements and/or changes in the products described in this documentation at any time without notice.
Preface Welcome to PowerMart and PowerCenter, Informatica’s integrated suite of software products that deliver an open, scalable solution addressing the complete life cycle for data warehouse and analytic application development. Both PowerMart and PowerCenter combine the latest technology enhancements for reliably managing data repositories and delivering information resources in a timely, usable manner. The metadata repository coordinates and drives a variety of core functions including extraction, transformation, loading, and management. The Informatica Server can extract large volumes of data from multiple platforms, handle complex transformations, and support high-speed loads. PowerMart and PowerCenter can simplify and accelerate the process of moving data warehouses from development to test to full production.
Y
About Informatica Documentation The complete set of printed documentation for PowerMart and PowerCenter includes the following books:
Designer Guide. Provides information needed to use the Designer. Includes information to help you create mappings, mapplets, and transformations. Also includes a description of the transformation datatypes used to process and transform source data.
Getting Started. Provides basic tutorials for getting started. Also contains documentation about the sample repository.
Installation and Configuration Guide. Provides information needed to install and configure the Informatica tools, including details on environment variables and database connections.
Metadata Reporter Guide. Provides information on how to install and use the web-based Metadata Reporter to generate reports on the metadata in PowerMart and PowerCenter repositories.
Repository Guide. Provides information needed to administer the repository using the Repository Manager or the pmrep command line program. Includes details on functionality available in the Repository Manager, such as creating and maintaining repositories, folders, users, groups, and permissions and privileges.
Session and Server Guide. Provides information to help you create and run sessions in the Server Manager, as well as administer the Informatica Server. Also contains information on tuning sessions and the Informatica Server for better performance.
Transformation Language Reference. Provides syntax descriptions and examples for each transformation function provided with PowerMart and PowerCenter.
Troubleshooting Guide. Provides error messages that you might encounter while using PowerMart or PowerCenter. Each error message includes one or more possible causes and actions that you can take to correct the condition. Documentation available with our other products includes:
Informatica® Metadata Exchange SDK User Guide. Provides information about the second generation of Metadata Exchange interfaces for PowerMart and PowerCenter repositories.
Informatica® PowerChannel™ User Guide. Provides information on how to transport compressed and encrypted data through a secure channel.
PowerCenter™ Integration Server for BW Installation Guide. Provides information to install and configure PCISBW for loading source data into a SAP Business Warehouse. It also contains basic instructions for loading into BW.
PowerConnect™ for IBM® DB2® Installation Guide. Provides information on setting up a mainframe environment to work with PowerCenter, including connectivity issues for mainframe and DB2 databases.
YL
3UHIDFH
PowerConnect™ for IBM® MQSeries® User and Administrator Guide. Provides information to install PowerConnect for IBM MQSeries, build mappings, extract data from message queues, and load data to message queues.
PowerConnect™ for PeopleSoft® User and Administrator Guide. Provides information to install PowerConnect for PeopleSoft, extract data from PeopleSoft, build mappings, and run sessions to load PeopleSoft source data into your data warehouse.
PowerConnect™ for SAP™ R/3® User and Administrator Guide. Provides information to install PowerConnect for SAP R/3, extract data from SAP R/3, build mappings, and run sessions to load SAP R/3 data into a data warehouse.
PowerConnect™ for Siebel® User and Administrator Guide. Provides information to install PowerConnect for Siebel, extract data from Siebel systems, build mappings, and run sessions to load Siebel source data into a data warehouse.
PowerPlug™ User Guide. Provides information on how to use PowerPlug to extract metadata from leading data modeling tools and import it into PowerMart/PowerCenter repositories through Informatica Metadata Exchange SDK.
PowerBridge™ for Hyperion® Essbase® Server User Guide. Provides information on how to use PowerBridge to export multi-dimensional metadata from PowerMart/PowerCenter repositories into the Hyperion Integration Server through Informatica Metadata Exchange SDK.
$E R X W,Q IR U PD W LF D' RF X P HQ W DW LR Q
YLL
About this Book The Troubleshooting Guide is written for all PowerMart and PowerCenter users. It contains troubleshooting information for all aspects of data warehouse development, including source analysis, transformation development, mapping development, and running sessions. This guide assumes you have knowledge about your operating systems, relational database concepts, and the interface requirements for your supporting applications. The online help and Adobe Acrobat versions of this book contain material for PowerMart 5.1/ PowerCenter 5.1. The printed version of this book contains material for PowerMart 5.0/ PowerCenter 5.0. To view printed material for the new features in PowerMart 5.1/ PowerCenter 5.1, refer to the PowerMart/PowerCenter Supplemental Guide. The material in this book is available for online use.
About PowerCenter and PowerMart This guide contains information about both PowerMart and PowerCenter. The documentation explicitly mentions software features that differ between the two products.
If You Are Using PowerCenter With PowerCenter, you receive all product functionality, including the ability to register multiple servers, share metadata across repositories, and partition data. A PowerCenter license lets you create a single repository that you can configure as a global repository, the core component of a data warehouse. When this guide mentions a PowerCenter Server, it is referring to an Informatica Server with a PowerCenter license.
If You Are Using PowerMart This version of PowerMart includes all features except distributed metadata, multiple registered servers, and data partitioning. Also, the various options available with PowerCenter (such as PowerCenter Integration Server for BW, PowerConnect for IBM DB2, PowerConnect for IBM MQSeries, PowerConnect for SAP R/3, PowerConnect for Siebel, and PowerConnect for PeopleSoft) are not available with PowerMart. When this guide mentions a PowerMart Server, it is referring to an Informatica Server with a PowerMart license.
YLLL
3UHIDFH
Document Conventions This guide uses the following formatting conventions: ,I\RX VHH «
Other Informatica Resources In addition to the product manuals, Informatica provides these other resources:
Informatica Webzine Informatica web site Informatica Developer Network Informatica Technical Support
Accessing the Informatica Webzine The Informatica Documentation Team delivers an online journal, the Informatica Webzine. This journal provides solutions to common tasks, conceptual overviews of industry-standard technology, detailed descriptions of specific features, and tips and tricks to help you develop data warehouses. You can access the webzine at: http://www.informatica.com/webzine The Informatica Webzine is a password-protected site. Informatica has an online registration form for login accounts to its webzine and web support. To register for an account, go to the following URL: http://www.informatica.com/support/webpaswdreq.html If you have any questions, please email [email protected]. To better serve your needs, the Informatica Documentation Team welcomes all comments and suggestions. You can send comments and suggestions to: [email protected]
Visiting the Informatica Web Site You can access Informatica’s corporate web site at http://www.informatica.com. The site contains information about Informatica, its background, upcoming events, and locating your closest sales office. You will also find product information, as well as literature and partner information. The services area of the site includes important information on technical support, training and education, and implementation services.
Visiting the Informatica Developer Network The Informatica Developer Network is a web-based forum for third-party software developers. You can access the Informatica Developer Network at http://devnet.informatica.com. The site contains information on how to create, market, and support customer-oriented add-on solutions based on Informatica’s interoperability interfaces.
[
3UHIDFH
Obtaining Technical Support There are many ways to access Informatica technical support. You can call or email your nearest Technical Support Center listed below or you can use our WebSupport Service. Both WebSupport and our Customer Site require a user name and password. To receive a user name and password, please contact us at [email protected] or call 650-687-6300. 1RUWK$PHULFD6RXWK$ PHULFD
New Features and Enhancements This section describes new features and enhancements to PowerMart and PowerCenter.
Version 5.1 The following list describes new features and enhancements in PowerMart 5.1/PowerCenter 5.1.
Performance Enhancements High precision decimal arithmetic. The Informatica Server optimizes data throughput to increase performance of sessions using the Enable Decimal Arithmetic option.
To_Decimal and Aggregate functions. The Informatica Server uses improved algorithms to increase performance of To_Decimal and all aggregate functions such as percentile, median, and average.
Cache management. The Informatica Server uses better cache management to increase performance of Aggregator, Joiner, Lookup, and Rank transformations.
Partition sessions with sorted aggregation. You can partition sessions with Aggregator transformation that use sorted input. This improves memory usage and increases performance of sessions that have sorted data.
Relaxed Data Code Page Validation When enabled, the Informatica Client and Informatica Server lift code page selection and validation restrictions. You can select any supported code page for source, target, lookup, and stored procedure data.
Designer Features and Enhancements Debug mapplets. You can debug a mapplet within a mapping in the Mapping Designer. You can set breakpoints in transformations in the mapplet.
Support for slash character (/) in table and field names. You can use the Designer to import source and target definitions with table and field names containing the slash character (/). This allows you to import SAP BW source definitions by connecting directly to the underlying database tables.
Server Manager Features and Enhancements Continuous sessions. You can schedule a session to run continuously. A continuous session starts automatically when the Load Manager starts. When the session stops, it restarts immediately without rescheduling. Use continuous sessions when reading real time sources, such as IBM MQSeries.
[LL
3UHIDFH
Partition sessions with sorted aggregators. You can partition sessions with sorted aggregators in a mapping.
Register multiple servers against a local repository. You can register multiple PowerCenter Servers against a local repository.
Version 5.0 The following list describes new features and enhancements in PowerMart 5.0/PowerCenter 5.0.
Designer Features and Enhancements Debugger. You can debug a mapping from the Mapping Designer. Using the Debugger Wizard, choose to run the Debugger against an existing session in debug mode or create a debug session. Before you debug a mapping, set breakpoints in the mapping where you want the Informatica Server to evaluate data and error conditions. The Debugger pauses when a breakpoint evaluates to true, and you can change transformation output data.
Double-click folder icon to open the folder and tool. When you double-click a folder icon in the Navigator window, the Designer opens the folder and displays the last tool that was active within that folder.
Find in Workspace tool. You can search for text strings in tables, columns, or ports across all open objects in the workspace.
Full screen view. You can view the workspace over the entire screen. The Designer hides the menu, the Navigator and Output windows, and the title bar to maximize the workspace window.
Invalid mapping icon. The Designer displays a new icon for invalid mappings in the Navigator window.
Lookup cache. You can use a dynamic lookup cache in a Lookup transformation. When you use a dynamic lookup cache, the Informatica Server updates the lookup cache during the session run. Also, you can share persistent lookup caches within and across mappings by naming the cache files.
Mapping parameters and variables. Create mapping parameters and variables in a mapplet or mapping to make mappings more flexible. Mapping parameters and variables represent values in mappings and mapplets. Use mapping parameters and variables to reduce the overhead of creating multiple mappings when only certain attributes of a mapping need to change.
New Designer shortcut keys. New shortcut keys allow you to cut, copy, paste, and delete rows when you edit a repository object.
New workspace look. You can select two colors to create a color gradient for the title bars of repository objects. Other components of the workspace, such as links, arrows, and tool title, also have a sharper, three-dimensional look.
Object import and export. You can export objects from a repository and import objects into a repository. When you export a repository object, the Designer or Server Manager
1 H Z) HD W XU H VDQ G ( Q KD Q F HP H Q WV
[LLL
creates an XML file describing the repository metadata. Use the XML file to import repository objects into a repository. You can export and import sources, targets, transformations, mapplets, mappings, and sessions.
Preview data. The Designer allows you to preview data for relational sources, flat file sources, and relational targets.
Retain relationships and source or target definition descriptions when re-importing a source or target definition. When you re-import a source or target definition, you have the option of retaining primary and foreign key relationships and source or target descriptions.
Resizable Expression Editor. You can resize the Expression Editor by dragging the corner of the dialog box.
Router transformation. The Designer allows you to use a Router transformation to test data based on multiple conditions. The Router transformation allows you to route groups of data to a transformation or a target.
Save mappings and mapplets under a different name. The Designer allows you to save mappings and mapplets under a different name within the same folder.
XML sources and targets. You can use XML data as a source or target. You can create source and target definitions from an XML, DTD, or XML schema file and use them in mappings. When you run a session, you can read data from an XML source file and validate it against a DTD. You can also write data from any type of source to an XML file.
Informatica Server Enhancements Expanded pmcmd capability. You can use the command line program pmcmd to specify a parameter file when you start a session or batch. This allows you to change the values of session parameters, and mapping parameters and variables at runtime.
Parallel data processing. Available with PowerCenter only. If you run the Informatica Server on a symmetric multi-processing system, you can use multiple CPUs to process a session concurrently. You configure partitions in the session properties based on source qualifiers. The Informatica Server reads, transforms, and writes partitions of data in parallel for a single session.
Process session data using threads. The Informatica Server runs on two processes: the Load Manager process and the DTM process. The DTM process creates threads to perform session tasks, such as reading, transforming, and writing data as well as performing pre-and post-session operations.
Metadata Reporter The Metadata Reporter is a web-based application that enables you to run reports against repository metadata. With the Metadata Reporter, you can access information about your repository without having knowledge of SQL, the transformation language, or the underlying tables in the repository.
[LY
3UHIDFH
Repository Manager Features and Enhancements Compare Folders. You can compare the contents of folders in the same repository or across different repositories.
Copy and Replace Folder Wizard. You can maintain shortcuts from local to global repositories when you copy and replace folders. When copying folders, you can select the shared folder to associate shortcuts.
Display user privileges. The Manage Privileges dialog box displays all user and group privileges so you can assign and revoke privileges by selecting the appropriate option.
pmrep. A command-line utility for Windows NT/2000 that allows you to perform repository tasks and change session-related parameters. Using pmrep, you can connect to, back up, delete, and restore a repository. Additional pmrep commands allow you to update database connectivity information for a repository, update email address information for session notification email, and update server variables.
Server Manager Features and Enhancements Additional email variables. With new email variables, you can configure post-session email to include information, such as the mapping used during the session.
Additional server variables. You can configure several new server variables when registering a server. Server variables such as $PMSuccessEmailUser allow you to configure sessions without hard-coding information.
Copy session. You can copy sessions across folders and repositories using the Copy Session Wizard in the Server Manager.
Enhanced user security. You can set read, write, and execute permissions for users and groups to restrict access to database, FTP, and external loader connections.
Global validation of sessions. You can validate a specified set of sessions in a folder or validate all of the invalid sessions in a folder.
Read-only privileges for sessions. You can set user and group permissions and privileges that allow users to view, but not edit, session properties.
Session parameters. Create session parameters to reuse sessions. You can create parameters for database connections, reject files, and file sources and targets. You can also use a builtin session parameter for the session log. Define session parameters in the session parameter file.
Sybase IQ 12 External Loader. You can use Sybase IQ 12 external loaders to load multibyte data. Null characters and delimiters can be up to four bytes long.
Teradata External Loader. You can use Teradata external loaders to load single-byte data. The Teradata external loader uses ASCII-based single-byte code pages.
Transformation Language Enhancements You can use two new built-in system variables with PowerMart and PowerCenter:
1 H Z) HD W XU H VDQ G ( Q KD Q F HP H Q WV
[Y
SESSSTARTTIME. Returns the system date value on the machine hosting the Informatica Server when the server initializes the session. You can use SESSSTARTTIME within any function that accepts transformation date/time datatypes using the transformation language.
$$$SessStartTime. Returns the system date value on the machine hosting the Informatica Server when the server initializes the session. You can use $$$SessStartTime at the mapping level in the filter condition, user-defined join, or SQL override of a source qualifier. You can also use $$$SessStartTime in session-level overrides for mapping attributes. You can also use four new variable functions with mapping variables:
SetCountVariable. Counts the number of evaluated rows and increment or decrement a mapping variable for each row.
SetMaxVariable. Evaluates the value of a mapping variable to the higher of two values. SetMinVariable. Evaluates the value of a mapping variable to the lower of two values. SetVariable. Sets the value of a mapping variable to a specified value.
[YL
3UHIDFH
&KDSWHU
Client Error Messages This chapter covers the following error message topics:
Overview The Informatica Client displays messages while performing tasks. Many of these messages are informational, but some are error messages. You can use this chapter to help determine what causes error messages to appear and what measures you can take to correct the problems. This chapter contains messages displayed in the following locations:
Designer, Server Manager, and Repository Manager status bars and output window Client message boxes
Informatica Client Messages The Informatica Client tools display messages in the status bar as you perform tasks, such as opening or copying objects. For example, the Designer displays error messages when you perform tasks that are not permitted, such as copying an object to a folder where you do not have write permission. While the Informatica Client tools do not allow you to perform illegal tasks, you can determine the likely cause of the problem by noting the message in the status bar, then consulting this chapter for details. Status bar and output window messages are listed alphabetically, by tool.
Client Message Boxes When you work with the Designer, Server Manager, or Repository Manager, a message box might appear with repository-related error messages. These repository-related messages begin with the text prefix REP. See “REP Codes” on page 118 for details on these messages.
Taking Action This chapter lists possible causes for each error message with recommended actions for each cause. Before taking action, make sure to read all possible causes listed under the error message to identify the most likely source of your error. You might try all of the actions listed or only one, depending on the situation. If you follow the suggested instructions but the problem persists, please contact Informatica Technical Support for additional help.
&KDSWHU& OLHQW(UURU0HVVDJHV
Designer Messages The following general messages might appear in the status bar, output window, or message boxes of the Designer: All of the selected objects must be the same type.
Cause:
You tried to drag objects of a different type, such as source and target definitions, at the same time.
Action:
You cannot drag objects of differing types. Drag the object types separately.
Cannot select a mapping/mapplet along with another source/target/transformation/mapping/ mapplet. Please clear the selection before adding this object.
Cause:
You tried to select a mapplet/mapping when a source/target/transformation was already selected, or you tried to select a source/target/transformation when a mapplet/mapping was already selected.
Action:
Clear the selection before adding the object.
Cannot step to the selected transformation.
Cause:
You cannot step to the selected transformation.
Action:
Select a different transformation.
Copy this object to the selected folder?
Cause:
You dragged an object from a non-shared folder to another non-shared folder. Or you used Ctrl-drag to copy an object from a shared folder to a non-shared folder.
Action:
If you drop the object in the folder, the Designer copies the object being dragged.
Create a shortcut to this object in the selected folder?
Cause:
You dragged an object from a shared folder to another folder.
Action:
If you drop the object in the folder, the Designer creates a shortcut to the object being dragged.
Error: Invalid number of fields for transformation: .
Cause:
The Sequence Generator transformation allows only two fields. You specified an incorrect number of fields detected during object import.
Action:
Check the XML file used for object importing. Make sure the number of fields in the transformation meets the requirement.
The escape character and delimiters you have specified overlap.
Cause:
You selected an invalid combination of escape character and delimiter.
Action:
Select a different character for the escape character or the delimiter.
' H V LJ QH U 0 HV V DJ H V
Failed to validate field , the content of this field is incorrect.
Cause:
You tried to modify the default value for RANKINDEX for the Rank transformation.
Action:
Do not change any default values for the RANKINDEX field.
A fatal error has occurred. Please see the session or server log for more information.
Cause:
When you ran the Debugger, an error occurred in the Informatica Server.
Action:
Check the session and server log for information on the error.
The folder is already open. To activate it, select the folder in the drop-down list on the toolbar.
Cause:
You attempted to open a folder that was already open.
Action:
To activate the open folder, select the folder in the drop-down list on the toolbar.
In transformation , group has invalid group type.
Cause:
You changed the Router transformation group type from INPUT or OUTPUT to INPUT/OUTPUT in the exported XML file.
Action:
Make sure there is no INPUT/OUTPUT group type.
No existing valid sessions are available for this mapping. Please verify a valid session exists that does not have recovery enabled.
Cause:
You tried to debug a mapping that has no valid sessions.
Action:
Validate the session in the Server Manager. Or create a new session.
No response from server- timeout reached.
Cause:
Load Manager did not respond to a request from the Debugger in the Designer before a timeout occurred.
Action:
Increase the length of time between timeouts. For Windows NT/2000 systems, select the Miscellaneous tab in the Informatica Server Setup. Increase number of seconds in the Stay Connected for (secs) setting. For UNIX systems, run the pmconfig utility and increase the number of seconds for the LMStayConnectedToRepositForDuration setting.
Not enough rows to enable import field names from first row.
Cause:
You tried to import a flat file with only header data.
Action:
Add another line of data and reimport.
This object cannot be copied.
Cause:
You tried to copy a schema.
Action:
You cannot copy schemas. If you want a second instance of a schema you must recreate the schema with the Star Schema Wizard.
&KDSWHU& OLHQW(UURU0HVVDJHV
The quote character and delimiters you have specified overlap.
Cause:
You selected an invalid combination of quote character and delimiter.
Action:
Select a different character for the quote character or the delimiter.
The quote character and escape character you have specified overlap.
Cause:
You selected an invalid combination of quote and escape characters.
Action:
Select a different character for the quote or escape character.
Select the folder to use.
Cause:
You dragged a repository object in the Navigator from a folder to a repository, which is not allowed.
Action:
Drag the repository object into an open folder in the Navigator or into an open workspace.
Switch to the Mapping Designer and open this mapping.
Cause:
You dragged a mapping from the Navigator to the Source Analyzer, Warehouse Designer, or Transformation Developer workspace.
Action:
If you drop the mapping in the workspace, the Designer switches to the Mapping Designer then opens the mapping.
Syntax error: bad variable name (the variable’s name NEWVARIABLE1).
Cause:
You altered the XML file or created an invalid mapping variable name. The imported mapping variable has an invalid name. The name has to start with $$, has to be longer than two characters, can only have alpha numerics and underscores.
Action:
Make sure mapping variable names follow the correct format.
Unable to copy this object.
Cause:
You tried to copy an object that cannot be copied. This is a general message. The Designer uses this message only if no other message is appropriate.
Action:
Determine why the object cannot be copied.
Unable to create a shortcut to a shortcut. The shortcut will be copied.
Cause:
You tried to create a shortcut to a shortcut.
Action:
You cannot create shortcuts to a shortcut. The Designer copies the shortcut instead, creating a shortcut to the original object.
Unable to create a shortcut to a new object. The object will be copied.
Cause:
You created a shortcut to an object that you did not save to the repository. The Designer copies the object instead.
Action:
To create a shortcut to the new object, save the repository first.
' H V LJ QH U 0 HV V DJ H V
A variable with this name, (the variable’s name $$NEWVARIABLE1), already exists in the mapping.
Cause:
You altered the XML file or created an invalid mapping variable name. The imported mapping variable name is not unique within the imported mapping.
Action:
Make sure mapping variable names are unique within any mapping.
You do not have write permission on the selected folder.
Cause:
You dragged a repository object into a folder or folder workspace for which you do not have write permission.
Action:
If you do not have write permission for a folder, you cannot copy objects, create shortcuts, or edit objects within that folder. If you require write permission for the folder, have the repository administrator or folder owner evaluate the situation and grant the write permission accordingly.
&KDSWHU& OLHQW(UURU0HVVDJHV
Source Analyzer Messages The following messages may appear in the Designer status bar and message boxes when working with the Source Analyzer tool: Copy these sources.
Cause:
You dragged sources from one folder to another or you held down the Ctrl key as you dragged sources.
Action:
If you drop the sources in an open folder, the Designer copies dragged sources.
The null character you have entered is not valid in this code page. Please enter a different null character.
Cause:
You selected a code page that is not US-ASCII and entered a null character that is not valid in that code page.
Action:
Enter a valid null character in the code page you selected.
Open these sources.
Cause:
You dragged one or more sources from a folder in the Navigator to the open workspace.
Action:
If you drop the source, the Designer opens that source.
Source definitions can be opened in the Source Analyzer.
Cause:
You dragged an object into the Source Analyzer that is not a source.
Action:
You can only edit source definitions in the Source Analyzer. To edit other objects, switch to the appropriate tool.
Switch versions and open this source.
Cause:
You dragged a source from the Navigator into an open workbook, but the workbook belongs to a different version of the folder.
Action:
If you drop the source in the workbook, the Designer switches versions and opens the source.
You have opened a bad or empty file.
Cause:
You tried to import a flat file source that contains no data.
Action:
Make sure the flat file you are importing contains data.
6 RX U FH $ Q D O\ ]H U 0 H VV D JH V
Warehouse Designer Messages The following messages may appear in the Designer status bar and message boxes when working with the Warehouse Designer tool: Cannot copy schemas.
Cause:
You copied a schema from one folder to another.
Action:
You cannot copy schemas. If you release the schema in the folder, the Designer creates a shortcut to the schema.
Copy these sources and then create targets from these sources.
Cause:
You created targets from sources in a different folder by dragging sources from one folder into another folder with the Warehouse Designer workbook open.
Action:
If you drop the sources, the Designer first copies the sources to the new folder, then uses copied sources to create new targets.
Copy these targets.
Cause:
You dragged targets from one folder to another. Or you held the Ctrl key down as you dragged targets.
Action:
If you drop the targets, the Designer copies them to the new folder.
Create shortcuts to these sources and then create targets from these sources.
Cause:
You created targets from sources in a shared folder by dragging sources from the shared folder into another folder with the Warehouse Designer workbook open.
Action:
If you drop the sources, the Designer first creates shortcuts to the original sources, then uses the shortcuts to create new targets.
Create targets from these sources.
Cause:
You created targets from sources by dragging sources into the Warehouse Designer.
Action:
If you drop the sources, the Designer create targets from those sources.
Only target definitions and schemas can be opened in the Warehouse Designer.
Cause:
You dragged an object into the Warehouse Designer workspace, and that object is not a target or schema.
Action:
Switch to the appropriate tool to edit other objects. You can edit targets or schemas edited in the Warehouse Designer. You can also drag sources into the Warehouse Designer to create targets.