User bio
404 bio not found
Member since Mar 7, 2019
Posts:
Replies:
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
}
Certifications & Credly badges:
![InterSystems HL7® Interface Specialist](https://images.credly.com/images/d235c8cf-2d11-49b8-86f5-a6a3e3481bcc/image.png)
![HealthShare Patient Index Training](https://images.credly.com/images/9226050c-cd94-4c22-9c6b-27bf2d8efcd3/image.png)
![InterSystems HL7® Interface Specialist](https://images.credly.com/images/d235c8cf-2d11-49b8-86f5-a6a3e3481bcc/image.png)
Global Masters badges:
Ray has no Global Masters badges yet.
Followers:
Ray has no followers yet.
Following:
Ray has not followed anybody yet.
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
}