Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.8
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for SAS
  3. Installation and Configuration
  4. Working with SAS Sources
  5. Working with SAS Targets
  6. Working with SAS Sessions
  7. Appendix A: SAS Datatype Reference
  8. Appendix B: SPI Server Configuration Parameters
  9. Appendix C: Error Messages

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Back Next

Integration Service Messages

Integration Service Messages

10017 A version mismatch is detected. The client version is not compatible with a server you are trying to connect to.
Cause:
 The Integration Service component of PowerExchange for SAS is not of the same version as the Communication component.
Action:
 Make sure you install both components from the same version.
11010 Data field length exceeds the maximum value.
Cause:
 The value for the length of the field is larger than that allowed by SAS.
Action:
 Enter a valid length. Check SAS documentation for valid lengths.
10001 Cannot connect to the SPI server, host = <host name>, port = <port number>, error = <error code>.
Cause:
 SPI server TCP/IP port is not accessible.
Action:
 Check the Communication component and network configuration. Make sure SPI Server is running.
10002 Session open request failed, host = <host name>, port = <port number>, error = <error code>.
Cause:
 SPI Server cannot initialize a session.
Action:
 Check the SPI Server log for more information.
10003 Failed to retrieve a session ID.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
10004 Failed to close the session.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
10005 Requested not supported data type, field = <field name>, data type = <data type enumeration>.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
10006 Failed to retrieve SAS session log, error code = <error code>.
Cause:
 SPI Server cannot read or pass the SAS log file.
Action:
 Check the existence and permissions of the SAS log file.
10007 Failed to retrieve connection attributes.
Cause:
 Failed to retrieve connection information from the session.
Action:
 Contact Informatica Global Customer Support.
10008 Failed to retrieve a host name.
Cause:
 Failed to retrieve host name from the SAS database connection.
Action:
 Contact Informatica Global Customer Support.
10009 Failed to retrieve a port number.
Cause:
 Failed to retrieve port number from the SAS database connection.
Action:
 Contact Informatica Global Customer Support.
10010 Failed to retrieve a library name from the extension field.
Cause:
 Failed to retrieve value of the LibraryName metadata extension.
Action:
 Contact Informatica Global Customer Support.
10011 SAS code generation failed, not supported data type: <data type enumeration>.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
10012 Unexpected command received, command code = <command code> .
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
10013 The session has been aborted.
Cause:
 When the user aborts the session.
Action:
 Run the session again.
10014 Failed to retrieve ‘libname overrule’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the Libname Overrule session property.
Action:
 Contact Informatica Global Customer Support.
10015 SPI server login failed because of wrong user name or password.
Cause:
 Authentication to SPI Server failed.
Action:
 Use the right credentials to connect to SPI Server.
10016 Failed to retrieve ‘trace’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the Trace session property.
Action:
 Contact Informatica Global Customer Support.
10018 Failed to retrieve ‘tablename overrule’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the Tablename Overrule session property.
Action:
 Contact Informatica Global Customer Support.
10018A Failed to retrieve the server code page ID.
Cause:
 Failed to retrieve the code page ID of the machine where Integration Service is running.
Action:
 Contact Informatica Global Customer Support.
10019 Failed to create locale for the code page <code page ID> .
Cause:
 Failed to create the locale for the code page of the machine where Integration Service is running.
Action:
 Contact Informatica Global Customer Support.
10020 Failed to expand library name parameter.
Cause:
 Failed to expand mapping parameter specified for library name.
Action:
 Contact Informatica Global Customer Support.
10021 Failed to expand table name parameter.
Cause:
 Failed to expand the mapping parameter specified for table name.
Action:
 Contact Informatica Global Customer Support.
10019 Failed to create locale for the code page <code page ID>.
Cause:
 Failed to create the locale for the code page of the machine where Integration Service is running.
Action:
 Contact Informatica Global Customer Support.
10020 Failed to expand library name parameter.
Cause:
 Failed to expand mapping parameter specified for library name.
Action:
 Contact Informatica Global Customer Support.
10021 Failed to expand table name parameter.
Cause:
 Failed to expand the mapping parameter specified for table name.
Action:
 Contact Informatica Global Customer Support.
10022 Failed to retrieve Pre SAS Code from the extension field.
Cause:
 Failed to retrieve the value of the PreSASCode metadata extension.
Action:
 Contact Informatica Global Customer Support.
10023 Failed to retrieve Post SAS Code from the extension field.
Cause:
 Failed to retrieve the value of the PostSASCode metadata extension.
Action:
 Contact Informatica Global Customer Support.
10024 Failed to retrieve ‘PreSASCode overrule’ attribute from the extension field.
Cause:
 Failed to retrieve value of the PreSASCode Overrule session property.
Action:
 Contact Informatica Global Customer Support.
10025 Failed to retrieve ‘PostSASCode overrule’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the PostSASCode Overrule session property.
Action:
 Contact Informatica Global Customer Support.
10026 Failed to expand PreSASCode parameter.
Cause:
 Failed to expand mapping parameter specified for PreSASCode.
Action:
 Contact Informatica Global Customer Support.
10027 Failed to expand PostSASCode parameter.
Cause:
 Failed to expand mapping parameter specified for PostSASCode.
Action:
 Contact Informatica Global Customer Support.
10028 Open SAS code not allowed.
Cause:
 Specified SAS code is not allowed.
Action:
 Enter allowed SAS code.
10031 Opening parenthesis not matched.
Cause:
 Unmatched opening parenthesis found in the SAS code.
Action:
 Correct the SAS code with proper closing parenthesis.
10032 Opening quote char not matched.
Cause:
 Unmatched opening quote found in the SAS code.
Action:
 Correct the SAS code with proper closing quote.
10033 Invalid value for Pre/Post SAS Code.
Cause:
 Specified SAS code is incorrect. See the session log for more information.
Action:
 See the SAS documentation.
10035 The repository is not licensed for PowerExchange for SAS, or the license has expired.
Cause:
 There is no valid license for the use of PowerExchange for SAS.
Action:
 Install the proper license keys.
11001 Table %s has no fields.
Cause:
 Cannot get the field list from the Application Source Qualifier.
Action:
 Contact Informatica Global Customer Support.
11002 Failed to get ISourceInstance list.
Cause:
 Cannot get the source list from the Application Source Qualifier.
Action:
 Contact Informatica Global Customer Support.
11004 Failed to retrieve the source table.
Cause:
 Cannot retrieve table metadata for the SAS source object.
Action:
 Contact Informatica Global Customer Support.
11005 Failed to flush PowerCenter buffer, buffer capacity = <buffer capacity>, records to flush = <number of records>.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
11006 Failed to retrieve data, error code = <error code>.
Cause:
 SAS does not start.
Action:
 Check the SAS environment. Try to start SAS manually and check the error messages from SAS.
11007 Failed to retrieve a where clause from the extension field.
Cause:
 Failed to retrieve the value of the WhereClause metadata extension.
Action:
 Contact Informatica Global Customer Support.
11008 Failed to retrieve ‘where clause overrule’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the Whereclause Overrule session property.
Action:
 Contact Informatica Global Customer Support.
11009 Failed to retrieve metadata extension attributes.
Cause:
 Cannot retrieve session level SAS table object metadata from the session object.
Action:
 Contact Informatica Global Customer Support.
11010 Data field length exceeds maximum value.
Cause:
 The value for the length of the field is larger than that allowed by SAS.
Action:
 Specify a valid length. Check SAS documentation for valid lengths.
11011 Failed to retrieve partition key information.
Cause:
 Failed to retrieve partition key information from the session.
Action:
 Contact Informatica Global Customer Support.
11012 Failed to expand where clause parameter.
Cause:
 Failed to expand mapping parameter specified for where clause.
Action:
 Contact Informatica Global Customer Support.
11013 Failed to retrieve 'Join Type' from the extension field.
Cause:
 Failed to retrieve Join Type information from the mapping.
Action:
 Contact Informatica Global Customer Support.
11014 Failed to retrieve 'Join Condition' from the extension field.
Cause:
 Failed to retrieve Join Condition information from the mapping.
Action:
 Contact Informatica Global Customer Support.
11015 Failed to retrieve 'Join Type overrule' attribute from the extension field.
Cause:
 Failed to retrieve Join Type information from the session.
Action:
 Contact Informatica Global Customer Support.
11016 Failed to retrieve 'Join Condition overrule' attribute from the extension field.
Cause:
 Failed to retrieve Join Condition information from the session.
Action:
 Contact Informatica Global Customer Support.
11017 Failed to expand Join Condition parameter.
Cause:
 Failed to expand mapping parameter specified for join condition.
Action:
 Contact Informatica Global Customer Support.
11018 For %s Only two sources per source qualifier are supported.
Cause:
 More than two tables participate in the join and the join is not an inner join.
Action:
 Limit the number of tables to two or specify an inner join.
11019 Failed to get the Primary key - Foreign key relation for creating the Join.
Cause:
 Failed to retrieve Primary key-Foreign key relation information from the mapping which does not specify join condition.
Action:
 Create PK-FK relations in the Source Analyzer or specify a join condition.
15001 Failed to retrieve the target table.
Cause:
 Cannot retrieve table metadata for the SAS target object.
Action:
 Contact Informatica Global Customer Support.
15002 Failed to send data, error code = <error code>.
Cause:
 SAS does not start.
Action:
 Check the SAS environment. Try to start SAS manually and check the error messages from SAS.
15003 Failed to retrieve target instances.
Cause:
 Failed to retrieve the target instance from the session.
Action:
 Contact Informatica Global Customer Support.
15006 Failed to retrieve indexes information from the extension field.
Cause:
 Failed to retrieve indexes from the metadata extension.
Action:
 Contact Informatica Global Customer Support.
15007 Failed to load index information from the extension field.
Cause:
 Internal error.
Action:
 Contact Informatica Global Customer Support.
15008 Failed to retrieve key index information from the extension field.
Cause:
 Failed to retrieve key index metadata extension.
Action:
 Contact Informatica Global Customer Support.
15009 Failed to retrieve load type attribute from the extension field.
Cause:
 Failed to retrieve the value of the Load Type session property.
Action:
 Contact Informatica Global Customer Support.
15010 Failed to retrieve ‘data compression’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the Compress session property.
Action:
 Contact Informatica Global Customer Support.
15011 Failed to retrieve ‘output per partition’ attribute from the extension field.
Cause:
 Failed to retrieve the value of the 'output per partition' session property.
Action:
 Contact Informatica Global Customer Support.
0 COMMENTS
We’d like to hear from you!