• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 94 subscribers
  • Views 2558 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Synchronisation Editor SAP Infotype Data Buffer Exceeded Error

Umar Qayum
over 6 years ago

Hi,

 

I am trying to retrieve data from infotype PA0008, however I am receiving a Data Buffer Exceeded error. 

Target System -> Edit Connection (Upload XML File) -> Update Schema -> Browse. The Table creates in Schema Types, and results are found correctly in Results List, however when I try to click a result to view teh System Object, I receive the Error.

 

I believe this is because the PA0008 infotype has a lot of columns. Is there anyway I can restrict the amount of columns I am retrieving? Some sort of select certain columns statement rather than the full amount of columns. 

 

My Query is in an XML Format in a text file that I am loading through the Synchronisation Editor

Query = 

 

<Table Definition = "CCC_RankData" TableName="PA0008" Key="PERNR,SUBTY,ENDDA,BEGDA,SEQNR,MANDT" X500"CN,OU,OU,OU,OU,OU" SQL="SUBTY = '93'" LOAD="OBJPS"

 

<SAPExtendedSchematype Bem = "HR, PA0008" DisplayPattern="%OBJPS%" ListObjectsDefinition = "CCC_RankData" ReadObjectDefinition = "CCC_RankData" InsertObjectDefinition = "" WriteObjectDefinition = "" DeleteObjectDefinition = "" />

 

Thanks

Parents
  • 0 over 6 years ago
    I would suggest two things from my experience:
    1. You are not using all PK in your definition which is not needed but You have to use tho ones that distinct the records between them. So verify if You have any equal records with the PK You are using (PERNR,SUBTY,ENDDA,BEGDA,SEQNR,MANDT)...maybe adding OBJPS would help as You are using it as display pattern
    2. if You use only OBJPS as display pattern than this must be unique... if it is not YOu will also get the error... that is why I would suggest something like %ENDDA% - %BEGDA% - %SEQNR% - %MANDT%
    ...I also get all tables without declaring any columns in LOAD
Reply
  • 0 over 6 years ago
    I would suggest two things from my experience:
    1. You are not using all PK in your definition which is not needed but You have to use tho ones that distinct the records between them. So verify if You have any equal records with the PK You are using (PERNR,SUBTY,ENDDA,BEGDA,SEQNR,MANDT)...maybe adding OBJPS would help as You are using it as display pattern
    2. if You use only OBJPS as display pattern than this must be unique... if it is not YOu will also get the error... that is why I would suggest something like %ENDDA% - %BEGDA% - %SEQNR% - %MANDT%
    ...I also get all tables without declaring any columns in LOAD
Children
No Data