|
Home > Archive > BizTalk Server Applications Integration > September 2005 > BizTalk 2004 and SAP integration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk 2004 and SAP integration
|
|
| Phillip 2005-08-22, 8:48 pm |
| Hi,
I desperately need help to resolve the issues below:
I wanted to insert a new document in SAP using Microsoft SAP adapter 2.0 and
SAP .Net connector 1.3. And I wanted to do it by calling SAP's RFC,
bapi_document_create2.
-I was able to generate the schema for the bapi bapi_document_create2 by
using schema generator from VS IDE.
-I built a simple BizTalk orchestration to submit a message with the message
type is schema above.
-Every time I submitted the message to insert a new document, I got a
successful response from SAP. But I could not find that document anywhere in
SAP. it looked like the data got rollback somehow.
Questions:
1) do I need to explicitly commit the data, how?
2)If I use documentfiles node to upload file to SAP, I got this mesage
"Error while checking and storing file c:\myfile\text.xml". What wrong?
this is the message I got from SAP:
<RETURN>
<TYPE></TYPE>
<ID></ID>
<NUMBER>000</NUMBER>
<MESSAGE></MESSAGE>
<LOG_NO></LOG_NO>
<LOG_MSG_NO>000000</LOG_MSG_NO>
<MESSAGE_V1></MESSAGE_V1>
<MESSAGE_V2></MESSAGE_V2>
<MESSAGE_V3></MESSAGE_V3>
<MESSAGE_V4></MESSAGE_V4>
<PARAMETER></PARAMETER>
<ROW>0</ROW>
<FIELD></FIELD>
<SYSTEM></SYSTEM>
</RETURN>
this is the original biztalk message:
<ns0:BAPI_DOCUMENT_CREATE2_Request
xmlns:ns0="http://schemas.microsoft.com/BizTalk/2003">
<CAD_MODE></CAD_MODE>
<DOCBOMCHANGENUMBER></DOCBOMCHANGENUMBER>
<DOCBOMREVISIONLEVEL></DOCBOMREVISIONLEVEL>
<DOCBOMVALIDFROM></DOCBOMVALIDFROM>
<DOCUMENTDATA>
<DOCUMENTTYPE>PRN</DOCUMENTTYPE>
<DOCUMENTNUMBER>ZC836AV</DOCUMENTNUMBER>
<DOCUMENTVERSION>08</DOCUMENTVERSION>
<DOCUMENTPART>000</DOCUMENTPART>
<DESCRIPTION>Microsoft 7100 Project 26735</DESCRIPTION>
<USERNAME>DMSGPSCPIC</USERNAME>
<STATUSEXTERN>PL</STATUSEXTERN>
<STATUSINTERN>PL</STATUSINTERN>
<STATUSLOG></STATUSLOG>
<LABORATORY></LABORATORY>
<ECNUMBER></ECNUMBER>
<VALIDFROMDATE></VALIDFROMDATE>
<REVLEVEL></REVLEVEL>
<DELETEINDICATOR></DELETEINDICATOR>
<CADINDICATOR></CADINDICATOR>
<STRUCTUREINDICATOR></STRUCTUREINDICATOR>
<PREDOCUMENTNUMBER></PREDOCUMENTNUMBER>
<PREDOCUMENTVERSION></PREDOCUMENTVERSION>
<PREDOCUMENTPART></PREDOCUMENTPART>
<PREDOCUMENTTYPE></PREDOCUMENTTYPE>
<AUTHORITYGROUP></AUTHORITYGROUP>
<DOCFILE1></DOCFILE1>
<DATACARRIER1></DATACARRIER1>
<WSAPPLICATION1></WSAPPLICATION1>
<DOCFILE2></DOCFILE2>
<DATACARRIER2></DATACARRIER2>
<WSAPPLICATION2></WSAPPLICATION2>
<VRLDAT></VRLDAT>
<USERDEFINED1></USERDEFINED1>
<USERDEFINED2></USERDEFINED2>
<USERDEFINED3></USERDEFINED3>
<USERDEFINED4></USERDEFINED4>
<SAVEDOCFILE1></SAVEDOCFILE1>
<SAVEDATACARRIER1></SAVEDATACARRIER1>
<SAVEDOCFILE2></SAVEDOCFILE2>
<SAVEDATACARRIER2></SAVEDATACARRIER2>
<CREATEDATE></CREATEDATE>
<REFDOCUMENTNUMBER></REFDOCUMENTNUMBER>
<REFDOCUMENTPART></REFDOCUMENTPART>
<REFDOCUMENTVERSION></REFDOCUMENTVERSION>
<FILESIZE1></FILESIZE1>
<FILESIZE2></FILESIZE2>
<CMFIXED></CMFIXED>
<CMRELEVANCE></CMRELEVANCE>
</DOCUMENTDATA>
<HOSTNAME></HOSTNAME>
<PF_FTP_DEST></PF_FTP_DEST>
<PF_HTTP_DEST></PF_HTTP_DEST>
<CHARACTERISTICVALUES>
<CLASSTYPE />
<CLASSNAME />
<CHARNAME>PLANT_CODE</CHARNAME>
<CHARVALUE>0875</CHARVALUE>
<DELETEVALUE />
</CHARACTERISTICVALUES>
<CLASSALLOCATIONS>
<CLASSTYPE>017</CLASSTYPE>
<CLASSNAME>DIR_PRN_CLASS</CLASSNAME>
<STATUS></STATUS>
<STANDARDCLASS />
<DELETEALLOCATION />
<ECNUMBER />
</CLASSALLOCATIONS>
<COMPONENTS>
<DELETEVALUE></DELETEVALUE>
<DOCUMENTTYPE></DOCUMENTTYPE>
<DOCUMENTNUMBER></DOCUMENTNUMBER>
<DOCUMENTPART></DOCUMENTPART>
<DOCUMENTVERSION></DOCUMENTVERSION>
<ORIGINALTYPE></ORIGINALTYPE>
<LANGUAGE></LANGUAGE>
<SOURCEDATACARRIER></SOURCEDATACARRIER>
<STORAGECATEGORY></STORAGECATEGORY>
<DOCFILE></DOCFILE>
<FORMAT></FORMAT>
<DESCRIPTION></DESCRIPTION>
<PH_OBJID></PH_OBJID>
</COMPONENTS>
<DOCUMENTDESCRIPTIONS>
<DELETEVALUE />
<LANGUAGE>E</LANGUAGE>
<LANGUAGE_ISO>EN</LANGUAGE_ISO>
<DESCRIPTION>Microsoft 7100 Project 26735</DESCRIPTION>
<TEXTINDICATOR />
</DOCUMENTDESCRIPTIONS>
<DOCUMENTFILES>
<DELETEVALUE></DELETEVALUE>
<DOCUMENTTYPE></DOCUMENTTYPE>
<DOCUMENTNUMBER></DOCUMENTNUMBER>
<DOCUMENTPART></DOCUMENTPART>
<DOCUMENTVERSION></DOCUMENTVERSION>
<ORIGINALTYPE>1</ORIGINALTYPE>
<SOURCEDATACARRIER></SOURCEDATACARRIER>
<STORAGECATEGORY>ZMRO01</STORAGECATEGORY>
<WSAPPLICATION>XML</WSAPPLICATION>
<DOCPATH>F:\SAPRPC\</DOCPATH>
<DOCFILE>PED0000004-002.xml</DOCFILE>
<STATUSINTERN></STATUSINTERN>
<STATUSEXTERN></STATUSEXTERN>
<STATUSLOG></STATUSLOG>
<APPLICATION_ID></APPLICATION_ID>
<FILE_ID></FILE_ID>
<DESCRIPTION></DESCRIPTION>
<LANGUAGE>E</LANGUAGE>
<CHECKEDIN>X</CHECKEDIN>
<ACTIVE_VERSION>X</ACTIVE_VERSION>
<CREATED_AT>20050602195606</CREATED_AT>
<CHANGED_AT>20050602195606</CHANGED_AT>
<CREATED_BY>DMSGPSCPIC</CREATED_BY>
<CHANGED_BY>DMSGPSCPIC</CHANGED_BY>
<CONTENT_DESCRIPTION></CONTENT_DESCRIPTION>
</DOCUMENTFILES>
<DOCUMENTSTRUCTURE>
<DELETEVALUE></DELETEVALUE>
<DOCUMENTTYPE>CRN</DOCUMENTTYPE>
<DOCUMENTNUMBER>PED0000085</DOCUMENTNUMBER>
<DOCUMENTPART>000</DOCUMENTPART>
<DOCUMENTVERSION>04</DOCUMENTVERSION>
<QUANTITY>1.000</QUANTITY>
<SORTSTRING></SORTSTRING>
<RECALLOWED></RECALLOWED>
<CAD_POS></CAD_POS>
</DOCUMENTSTRUCTURE>
<LONGTEXTS>
<DELETEVALUE></DELETEVALUE>
<LANGUAGE>E</LANGUAGE>
<LANGUAGE_ISO>EN</LANGUAGE_ISO>
<TEXTLINE></TEXTLINE>
</LONGTEXTS>
<OBJECTLINKS>
<DELETEVALUE />
<OBJECTTYPE>MARA</OBJECTTYPE>
<OBJECTKEY>ZC836AV</OBJECTKEY>
<DOCUMENTDIRECTION />
<OBJECTDESCRIPTION></OBJECTDESCRIPTION>
<OBJECTLINKID></OBJECTLINKID>
<ADDOBJECTTYPE />
<ADDOBJECTKEY />
</OBJECTLINKS>
</ns0:BAPI_DOCUMENT_CREATE2_Request>
| |
| Florian Wöhrl 2005-09-05, 5:57 pm |
| There's a method in the .NET Proxy object instance called "CommitWork()"
sapEDMProxy sapEDM = new RFCIOS_SAPEDM.sapEDMProxy();
sapEDM.Bapi_Document_Create2(" ", DocBomChangeNumber, DocBomRevisionLevel,
DocBomValidFrom,
oDocumentData, sLocalHostName, sFTPDest, sHTTPDest, out DocumentNumber, out
DocumentPart, out DocumentType,
out DocumentVersion, out oReturn, ref oCharacteristicValues, ref
oClassAllocations, ref oComponents,
ref oDocumentDescriptions, ref oDocumentFiles, ref oDocumentStructure, ref
oLongTexts, ref oObjectLinks);
sapEDM.CommitWork();
| |
| Phillip 2005-09-29, 5:58 pm |
| I figured it out.
I have to call the bapi, "bapi_transaction_commit" seperately. Also,
make sure you use session-shared memory when calling this bapi.
|
|
|
|
|