February 27, 2014 at 1:35 pm
I have an SSIS package which uses the Microsoft Connector (SAPBI Source) connected to BW. When I try to scheduled the job to run in SQL I get the following error. I am using a proxy to executive the job and I have also created an XML configuration file.
Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:47:10 PM Error: 2014-02-27 13:47:10.80 Code: 0xC0014005 Source: Description: The connection type "SAPBI" specified for connection manager "SAP BW Connection" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error Error: 2014-02-27 13:47:10.80 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">SAP BW Connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{B6CA11CF-7F4D-42AB-930C-67" from node "DTS:ConnectionManager". End Error Could not load package "\CustMast_BW" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 1:47:10 PM Finished: 1:47:10 PM Elapsed: 0.078 seconds. The package could not be loaded. The step failed.
February 27, 2014 at 8:06 pm
Looks like you haven't installed the SAPBI connector on the server that you are using to run the package from
February 28, 2014 at 6:25 am
The connector is installed on the server. The only thing I didn't do was to reboot the server. I didn't think that was necessary.
March 3, 2014 at 3:21 pm
shannon.proctor (2/27/2014)
I have an SSIS package which uses the Microsoft Connector (SAPBI Source) connected to BW. When I try to scheduled the job to run in SQL I get the following error. I am using a proxy to executive the job and I have also created an XML configuration file.Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:47:10 PM Error: 2014-02-27 13:47:10.80 Code: 0xC0014005 Source: Description: The connection type "SAPBI" specified for connection manager "SAP BW Connection" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error Error: 2014-02-27 13:47:10.80 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">SAP BW Connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{B6CA11CF-7F4D-42AB-930C-67" from node "DTS:ConnectionManager". End Error Could not load package "\CustMast_BW" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 1:47:10 PM Finished: 1:47:10 PM Elapsed: 0.078 seconds. The package could not be loaded. The step failed.
Did you test the connect to DW successfully? Does the package run independently instead of through a job ?
--
SQLBuddy
March 4, 2014 at 11:39 am
The connection to the data source works fine. This is the issue I'm now having.
I'm running SQL Server 2008 R2 SP2 and I have scheduled other SSIS packages all of which run successfully. I now have a package that contains the Microsoft Connector 1.1 which extracts data from an SAP BW Open Hub. It runs fine in BIDS, but fails when scheduled in a SQL Job with the following error:
Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:28:31 AM Error: 2014-03-04 10:28:32.81 Code: 0xC00470FE Source: Customer Master ETL from BW SSIS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "SAP BI Source" (1) cannot run on installed Standard Edition of Integration Services. It requires Enterprise Edition or higher. End Error Error: 2014-03-04 10:28:33.13 Code: 0xC002F304 Source: Failure Send Mail Task Description: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:28:31 AM Finished: 10:28:33 AM Elapsed: 1.607 seconds. The package execution failed. The step failed.
March 4, 2014 at 11:48 am
shannon.proctor (3/4/2014)
The connection to the data source works fine. This is the issue I'm now having.I'm running SQL Server 2008 R2 SP2 and I have scheduled other SSIS packages all of which run successfully. I now have a package that contains the Microsoft Connector 1.1 which extracts data from an SAP BW Open Hub. It runs fine in BIDS, but fails when scheduled in a SQL Job with the following error:
Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:28:31 AM Error: 2014-03-04 10:28:32.81 Code: 0xC00470FE Source: Customer Master ETL from BW SSIS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "SAP BI Source" (1) cannot run on installed Standard Edition of Integration Services. It requires Enterprise Edition or higher. End Error Error: 2014-03-04 10:28:33.13 Code: 0xC002F304 Source: Failure Send Mail Task Description: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:28:31 AM Finished: 10:28:33 AM Elapsed: 1.607 seconds. The package execution failed. The step failed.
This is the Error Message " The component "SAP BI Source" (1) cannot run on installed Standard Edition of Integration Services. It requires Enterprise Edition or higher. "
You need Enterprise Edition. Looks like you are on Std Edition.
--
SQLBuddy
March 4, 2014 at 11:51 am
Can I assume that it's just this particular component since all other scheduled SSIS packages run successfully?
March 4, 2014 at 11:58 am
shannon.proctor (3/4/2014)
Can I assume that it's just this particular component since all other scheduled SSIS packages run successfully?
Yes it this particular component "SAPBI Source connector"
--
SQLBuddy
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy