SAP Destination SAP Connector 1.0 for SAP BI
Hi, im trying to use SAP BI destination in SQL Server 2008 SSIS. I'm trying to load simple master data to InfoObject. It was possible to create InfoObject, InfoSource and infoPacket using help from white paper. unfortunatelly it fails on Test Load and package execution with following errors:=================================== Non-negative number required.Parameter name: totalWidth (Microsoft Visual Studio) ------------------------------Program Location: at System.String.PadHelper(Int32 totalWidth, Char paddingChar, Boolean isRightPadded) at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCStructure..ctor(RFCTableColumnCollection Columns) at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCParameter.RetrieveColumnsByStructure(R3Connection Connection, String StructureName) at Microsoft.SqlServer.Dts.SapBw.Connectivity.R3Connection.AddParametersAndTablesToUndefinedFunctionObject(RFCFunction& Dest, String Name) at Microsoft.SqlServer.Dts.SapBw.Connectivity.R3Connection.CreateFunction(String Name) at Microsoft.SqlServer.Dts.SapBw.Connectivity.BW.Loader.InfoPackage.SendData(DataTable data, Int32 PacketNumber, Boolean LastPacket) at Microsoft.SqlServer.Dts.SapBw.Gui.SapBiDestinationConnectionPage.btnTestLoad_Click(Object sender, EventArgs e) System: Windows 2008 Server Enterprise x64SQL Server 2008 Developer x64SAP BW 7.10 Patch Level 017What might be a cause ?Thanks for any hint
April 29th, 2009 6:52pm

Looking up in logs I found following strange answer from SAP RFC output - offest for Table BAPIRET2 are less than zero:What might cause that ?<?xml version="1.0" encoding="ISO-8859-1" ?> - <RfcFunction Name="RFC_GET_STRUCTURE_DEFINITION"> - <Imports> <TABLENGTH Type="INT" Length="4" Tag="" Decimals="0">548</TABLENGTH> </Imports> - <Exports> <TABNAME Type="CHAR" Length="30" Tag="" Decimals="0">BAPIRET2</TABNAME> </Exports> - <Tables> - <FIELDS> - <Structure FixedLength="0" ABAPStructureName=""> <TABNAME Type="CHAR" Length="30" Offset="0" Decimals="0" Tag="" /> <FIELDNAME Type="CHAR" Length="30" Offset="0" Decimals="0" Tag="" /> <POSITION Type="INT" Length="4" Offset="0" Decimals="0" Tag="" /> <OFFSET Type="INT" Length="4" Offset="0" Decimals="0" Tag="" /> <INTLENGTH Type="INT" Length="4" Offset="0" Decimals="0" Tag="" /> <DECIMALS Type="INT" Length="4" Offset="0" Decimals="0" Tag="" /> <EXID Type="CHAR" Length="1" Offset="0" Decimals="0" Tag="" /> </Structure> - <item> ...<item> <TABNAME>BAPIRET2</TABNAME> <FIELDNAME>MESSAGE</FIELDNAME> <POSITION>67108864</POSITION> <OFFSET>402653184</OFFSET> <INTLENGTH>-603979776</INTLENGTH> <DECIMALS>0</DECIMALS> <EXID>C</EXID> </item> - <item> ... </FIELDS> </Tables> </RfcFunction>
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2009 4:12pm

Is your SAP server big endian or little endian? Previously, there are some parsing problems for big endian machine, but this is fixed in the latest CU.
December 9th, 2010 9:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics