Hi Robert,

Resolved by putting a custom the OnInit() method at the top of the custom SQL.InboundAdapter service, it release all persistent values associated with the adapter at start of the service

Method OnInit() As %Status {        
Do ..Adapter.ClearAllAppData(..%ConfigName)    
Quit $$$OK 
}

I did try clearing the “key Field Name” , it does read all rows, but it reads them multiple times and you end up with duplicate data.

Hi Robert,

I tried the following three different ways and they did not work.

Parameter ADAPTER = "EnsLib.SQL.InboundAdapter";

Method OnInit() As %Status
{
   Do ..Adapter.InitializePersistentValue(..%ConfigName,"%LastKey",0)
   Quit $$$OK
}


Method OnInit() As %Status
{
   Do ..Adapter.ClearStaticAppData(..%ConfigName)
   Quit $$$OK
}

Method OnInit() As %Status
{
   Do ..Adapter.ClearRuntimeAppData(..%ConfigName)
   Quit $$$OK
}