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.6
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Back Next

Troubleshooting Data Loading into SAP BI

Troubleshooting Data Loading into SAP BI

The Workflow Manager reports that the session completes successfully, but the SAP BI system reports that the session failed.
This might occur when the PowerCenter Integration Service successfully moves data into the InfoSource, but SAP BI fails to move the data from the InfoSource to the InfoCube. This problem is not related to PowerCenter or PowerExchange for SAP BI. The problem is related to the SAP BI server. See the SAP BI documentation.
I cannot start an InfoPackage.
The most common reasons for a failed connection are:
  • The
    sapnwrfc.ini
     file is improperly configured.
     Verify that the PROGRAM_ID defined for the connection to the RFC server program matches the Program ID for the external source in SAP BI.
  • The SAP BW Service is not running.
  • The SAP BW Service is running, but the PowerCenter Integration Service is not running.
     The InfoPackage is launched and sends a request to the SAP BW Service. The SAP BW Service, in turn, sends a request to the PowerCenter Integration Service to start the session. If the PowerCenter Integration Service is not running, you might see the following message: 
    There was a problem connecting to the Integration Service [Error Number <error>]. Retrying...
    The error number embedded in the message originates from the operating system.
    The InfoPackage aborts if the SAP BW Service does not connect to the PowerCenter Integration Service immediately.
If you have problems starting an InfoPackage, test the connection using the Administrator Workbench.
To test the SAP BW Service connection:
  • From the Administrator Workbench or Data Warehousing Workbench, click the Source Systems tab.
  • Right-click the source system and select Change.
  • Click the Test Connection button.
  • The RFC Connection Test returns a status screen that indicates the status and description of the connection.
When I try to start a workflow containing an SAP BI session in the Workflow Manager, nothing happens.
You cannot use the Workflow Manager to start or schedule a PowerCenter workflow with an SAP BI session. You need to configure the workflow to run on demand. Create an InfoPackage in the SAP BI system to schedule the workflow containing an SAP BI session.
I need to stop a workflow containing an SAP BI session.
To stop an SAP BI workflow, stop the PowerCenter workflow using
pmcmd
 or in the Workflow Monitor. You cannot stop an InfoPackage in SAP BI.
The InfoPackage starts in SAP BI, but no message appears in the log for the PowerCenter session.
This may occur if you have more than one SAP BW Service in the same environment using the same Program ID. When you have multiple SAP BW Services in the same environment using the same Program ID, the SAP BW Service which was started first receives the requests from the SAP BI system.
When you do not see a message in the Administrator tool or SAP BI Monitor log for an Infopackage that starts in SAP BI, verify if there are other SAP BW Services connected to the SAP BI system. Check the log for the other SAP BW Services to see if the InfoPackage started.
I ran a session to load data into SAP BI. However, the session status reported by SAP BI is not the same as the session status reported by the PowerCenter Integration Service.
Status messages coming from SAP BI are not transported correctly to the PowerCenter Integration Service when the load is successful but has zero rows.
In SAP BI, you can set the Traffic Light Color options to indicate success if there is no data. SAP BI sends a status message of success to the PowerCenter Integration Service when a load is successful but has zero rows.
The SAP BW Service starts my filter session run, but the log includes an error message “Error in opening parameter file.”
This only occurs on Windows. The permissions on the directory that contains the parameter file are not set correctly. Enable the SAP BW Service appropriate read and write permissions for the parameter file directory.
I ran a session that successfully loaded data into SAP BI, but the Administrator tool log includes irrelevant messages about the session.
This may occur if you entered an invalid value for the CONTEXT field in the ZPMSENDSTATUS ABAP program when creating the process chain. You must enter BW LOAD for the CONTEXT field in a process chain that loads data.
I ran a session to load data into SAP BI. However, the session failed with the following error in the session log: 
WRITER_1_*_1>WRT_8025 Error in BW Target. [===>SAPSendDone Failed.
SAP system exception raised.
key = RFC_ERROR_SYSTEM_FAILURE
message = &INCLUDE INCL_INSTALLATION_ERROR
This may occur if the Packet Size session property is higher than the packet size configured in the SAP BI system or higher than the available memory on the node where the PowerCenter Integration Service process runs. Decrease the value of the Packet Size property and run the session again.
0 COMMENTS
We’d like to hear from you!