ETL job is failing loading data from SAP BW to SQL

2021-01-15T13:22:46.587+00:00

Hello Team,

I created an SSIS Package to load data from SAP BW to SQL SERVER. The package is running fine but failing in SQL Agent Job. Below is the Error.

ERPConnect.ERPException: Could not find attribute 'Name' in node 'HierarchyLevels' at ERPConnect.RFCSoapProcessor.GetAttributeValueFromNode(XmlNode node, String AttributeName) at ERPConnect.BW.BWCube.XMLToHierarchiesCollection(BWCube cube, XmlNode node, HierarchyCollection parcol) at ERPConnect.BW.BWCube.XMLToDimensionCollection(BWCube cube, XmlNode node, DimensionCollection parcol) at ERPConnect.BW.BWCube.InnerLoadFromXML(XmlDocument xdoc) at XtractIS.XtractSourceBWQuery.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket) End Error Error: 2021-01-13 12:46:26.93 Code: 0xC0047038 Source: Extract Data from POA SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Xtract BW Cube" (4157) returned error code 0x80131500. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:46:25 PM Finished: 12:46:26 PM Elapsed: 1.903 seconds. The package execution failed. The step failed.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,949 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,589 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,901 Reputation points
    2021-01-18T03:06:07.683+00:00

    Hi @siva rama krishna reddy tangirala ,

    1.Please check if the user who will run the ssis package in sql agent job has full permission to access to the source "Extract Data from POA".

    2.Please check if you tick use 32-bit runtime in sql agent job.

    Best Regards,
    Mona


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.