New post

Find

Question
· Apr 29

WorkMgr execution issues

Hello Community,

I have a queue that I need to traverse and perform operations on. To distribute the workload across multiple processes, I used a Work Queue Manager do process and I'm not expecting any status from it So, I skipped Sync / WaitForComplete in my implementation

When I execute the below code. Lot of queues are not processed properly. If I add a 0.1-second delay, it works as expected. Is there a minimum time required for a process to start after it's added to the Queue

ClassMethod CleanUpQWrkMgr()
{
    Set QueueId=""
    Set workMgr = ##class(%SYSTEM.WorkMgr).%New()
    If workMgr="" quit
    for {
        Set QueueId = $O(^Q(QueueId),1,data),event="" q:QueueId=""
        Do workMgr.Queue("..Cleanup",QueueId)
        //h .1	
    }
    //Set st= workMgr.WaitForComplete()
}

ClassMethod Cleanup(QueueId As %Integer)
{
    Set event=""
    For {
            Set event = $Order(^Q(QueueId,event)),rev="" Q:event=""
            For {
                Set rev = $Order(^Q(QueueId,event,rev)) Q:rev=""
                If '$Data(^DQ(rev,"e",event))
                Do $I(CNT)
            }
    }
    Set ^test("CNT",QueueId)=CNT
    Quit 1
}

Thanks!

2 new Comments
Discussion (2)1
Log in or sign up to continue
Question
· Apr 29

SQLCODE 25 - Input Encountered after end of query

Hi Guys,

I'm getting the below error when trying to train my Model

This is the table I created my model from

 

Thanks

1 new Comment
Discussion (1)2
Log in or sign up to continue
Question
· Apr 28

Code Tables vs Cache SQL Tables in HealthShare Provider Directory

I have a general question about HealthShare Provider Directory using Code Tables on disk vs Cache SQL Tables. Why is Provider Directory not using the Cache SQL Tables within the IRIS platform?

Discussion (0)1
Log in or sign up to continue
Question
· Apr 28

Struggling with a SQL SELECT that is returning multiple searchable rows

I am struggling with returning a SQL Query Result that may have multiple rows that can be searched.

 set query = "SELECT Facility FROM FROM osuwmc_EnterpriseDirDB.RelationshipMedCtrID WHERE OSUmedcenterID = ?"
 SET rset = ##class(%SQL.Statement).%New()
 SET qStatus = rset.%Prepare(query)
 SET rset = rset.%Execute($Get(ID))
 do rset.%Display()

I need to take the values that are returned and say search them for a single value. How would I go about returning the EnsLib.SQL.Snapshot into a Array or List for it to be searchable.

Can this be done internally within the DTL, so I don't have to go build a Business Process and Outbound SQL Adapter Operation?
 
 Thanks

4 new Comments
Discussion (4)1
Log in or sign up to continue
Announcement
· Apr 28

[Video] Modern Observability with InterSystems IRIS & Open Telemetry

Hey Developers,

Watch this video to learn about InterSystems IRIS's new ability to integrate seamlessly with industry-standard observability tools to gather and visualize your InterSystems IRIS metrics, logs, and traces.  

⏯ Modern Observability with InterSystems IRIS & Open Telemetry@ Global Summit 2024

 Presenters:
🗣 @Michelle Stolwyk​​​​​, Director of Development, InterSystems
🗣 @Bob Kuszewski, Product Manager, Developer Experience, InterSystems  

Subscribe to our YouTube channel InterSystems Developers to stay up to date!

Discussion (0)1
Log in or sign up to continue