Transcription
Troubleshooting GuideInformatica PowerCenter (Version 8.1.1)
Informatica PowerCenter Troubleshooting GuideVersion 8.1.1January 2007Copyright (c) 1998–2007 Informatica Corporation.All rights reserved. Printed in the USA.This software and documentation contain proprietary information of Informatica Corporation and are provided under a license agreement containingrestrictions on use and disclosure and are also protected by copyright law. Reverse engineering of the software is prohibited. No part of this document may bereproduced 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 and asprovided 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 FAR52.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, PowerCenter, PowerCenterRT, PowerCenter Connect, PowerCenter Data Analyzer, PowerMart, SuperGlue, Metadata Manager, Informatica DataQuality and Informatica Data Explorer are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughoutthe world. All other company and product names may be trade names or trademarks of their respective owners.Portions of this software and/or documentation are subject to copyright held by third parties, including without limitation: Copyright DataDirect Technologies,1999-2002. All rights reserved. Copyright Sun Microsystems. All Rights Reserved. Copyright RSA Security Inc. All Rights Reserved. Copyright OrdinalTechnology Corp. All Rights Reserved.Informatica PowerCenter products contain ACE (TM) software copyrighted by Douglas C. Schmidt and his research group at Washington University andUniversity of California, Irvine, Copyright (c) 1993-2002, all rights reserved.Portions of this software contain copyrighted material from The JBoss Group, LLC. Your right to use such materials is set forth in the GNU Lesser GeneralPublic License Agreement, which may be found at p. The JBoss materials are provided free of charge byInformatica, “as-is”, without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitnessfor a particular purpose.Portions of this software contain copyrighted material from Meta Integration Technology, Inc. Meta Integration is a registered trademark of Meta IntegrationTechnology, Inc.This product includes software developed by the Apache Software Foundation (http://www.apache.org/). The Apache Software is Copyright (c) 1999-2005 TheApache Software Foundation. All rights reserved.This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit and redistribution of this software is subject to terms availableat http://www.openssl.org. Copyright 1998-2003 The OpenSSL Project. All Rights Reserved.The zlib library included with this software is Copyright (c) 1995-2003 Jean-loup Gailly and Mark Adler.The Curl license provided with this Software is Copyright 1996-2004, Daniel Stenberg, Daniel@haxx.se . All Rights Reserved.The PCRE library included with this software is Copyright (c) 1997-2001 University of Cambridge Regular expression support is provided by the PCRE librarypackage, which is open source software, written by Philip Hazel. The source for this library may be found at cre.InstallAnywhere is Copyright 2005 Zero G Software, Inc. All Rights Reserved.Portions of the Software are Copyright (c) 1998-2005 The OpenLDAP Foundation. All rights reserved. Redistribution and use in source and binary forms, withor without modification, are permitted only as authorized by the OpenLDAP Public License, available at tml.This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.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 thisdocumentation may include technical inaccuracies or typographical errors. Informatica could make improvements and/or changes in the products described inthis documentation at any time without notice.
Table of ContentsPreface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiAbout This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xivDocument Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xivOther Informatica Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvVisiting Informatica Customer Portal . . . . . . . . . . . . . . . . . . . . . . . . . . xvVisiting the Informatica Web Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvVisiting the Informatica Knowledge Base . . . . . . . . . . . . . . . . . . . . . . . xvObtaining Technical Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvChapter 1: Client Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Business Components Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Data Profiling Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4Java Transformation Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11PowerCenter Connect for IBM MQSeries Messages . . . . . . . . . . . . . . . . . . . 16PowerCenter Connect for JMS Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . 17PowerCenter Connect for PeopleSoft Messages . . . . . . . . . . . . . . . . . . . . . . 21PowerCenter Connect for Salesforce.com Messages . . . . . . . . . . . . . . . . . . . 26PowerCenter Connect for SAP NetWeaver BW Option Messages . . . . . . . . . 28PowerCenter Connect for SAP NetWeaver mySAP Option Messages . . . . . . . 30Importing Source Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Validating the Filter Condition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31Validating the Join Condition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Validating SAP Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Creating ABAP Program Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36Cleaning ABAP Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Generating and Installing ABAP Programs . . . . . . . . . . . . . . . . . . . . . . 37Validating SAP Mappings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42Importing and Exporting SAP Mappings . . . . . . . . . . . . . . . . . . . . . . . 42Working with IDocs Using ALE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44Data Migration Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Business Content Integration Messages . . . . . . . . . . . . . . . . . . . . . . . . . 46PowerCenter Connect for Siebel Messages . . . . . . . . . . . . . . . . . . . . . . . . . . 48PowerCenter Connect for TIBCO Messages . . . . . . . . . . . . . . . . . . . . . . . . 52iii
PowerCenter Connect for webMethods Messages . . . . . . . . . . . . . . . . . . . . . 55PowerCenter Connect for Web Services Messages . . . . . . . . . . . . . . . . . . . . . 57XML Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Chapter 2: Administration Console Error Messages . . . . . . . . . . . . . 63Administration Console Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . 64Chapter 3: ADV Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69ADV Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Chapter 4: ALERT Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71ALERT Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Chapter 5: ATHR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73ATHR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74Chapter 6: AUTH Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77AUTH Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78Chapter 7: BR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83BR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84Chapter 8: BTree Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87BTree Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88Chapter 9: BW Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91BW Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92Chapter 10: CFG Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95CFG Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96Chapter 11: CMD Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105CMD Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106ivTable of Contents
Chapter 12: CMN Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107CMN Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108Chapter 13: CNF Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143CNF Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144Chapter 14: CNX Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145CNX Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146Chapter 15: CSE Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147CSE Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148Chapter 16: CTSDK Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149CTSDK Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150Chapter 17: DBGR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151DBGR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152Chapter 18: DCF Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157DCF Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158Chapter 19: DMI Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159DMI Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160Chapter 20: DOM Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163DOM Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164Chapter 21: DP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165DP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166Chapter 22: DS Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173DS Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174Table of Contentsv
Chapter 23: DSP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175DSP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176Chapter 24: EP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177EP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178Chapter 25: EXP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191EXP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192Chapter 26: EXPFN Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199EXPFN Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200Chapter 27: FEXP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201FEXP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202Chapter 28: FR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203FR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204Chapter 29: FTP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213FTP Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214Chapter 30: HIER Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219HIER Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Welcome to PowerCenter, the Informatica software product that delivers an open, scalable data integration solution addressing the complete life cycle for all data integration projects including data warehouses, data migration, data synchronization, and information hubs.
