SMP 3 Agentry exception in Complex Table Sync

[Former Member]

Hi,

We are implementing SAP WM 6.1 on SMP 3. We have a complex table with more than 150K records. 

We have made the following configurations in SAP

• Configured data staging for complex table in SAP to fetch 2000 records at a time

After syncing few thousand records an exception is thrown. This exception is repeated infinitely till the heap dump occurs.

Exception

Problem in BAPI Create (ZWAM_CTEQUIPMENT_GET): while trying to invoke the method com.sap.conn.jco.JCoDestination.getDestinationID() of a null object loaded from field com.syclo.sap.jco.JCo3Connection._destination of an object loaded from local variable 'this'

From the Java monitoring we can observe that the Heap memory is increasing and after reaching Max Heap size (6 GB) the SMP server hangs.

We have test the same configuration in Dev with 70K records and there is no issue in sync.

Appreciate your help.

Regards

Zak

[former_member1155304]

Hi Zak,

Could you describe how you resolved this exception ? I've started seeing this in our log files. The application still runs though but was concerned if this could lead to a server crash anytime soon?

Regards,

Naresh

[prashanthi_vangala2]

Hi Zak,

Are you able to resolve this issue?

Any solutions?

-shanthi

[i834235]

Zak,

There is other type of data  staging option available in WM 6.1  which is pre-populating    data  into stage tables. So during initial sync data will be read from  stage tables.

Also did you try increasing default heap size parameter in Agentry.ini file ?

Thanks

Manju.