Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

merging charts error

Bugs, Known Issues, Open Cases

Last Post by Anonymous 1 second ago

11 Posts

4 Users

0 Reactions

87 Views

RSS

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

We are trying to merge two chart of the same patient but it timeout. GE has no solution yet but recommended us to merge the reverse. However, we need to keep the second chart instead of the first one. Any suggestions?

SQL error 0.
Source: .Net SqlClient Data Provider
Number: -2
State: 0
Class: 11
Server:
Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Proc:
Line: 0
SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DBCommandWrapper command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DBCommandWrapper command)
at GE.CPO.Common.Logic.CommonLogic.MergePatient(Int32 sourcePatient, Int32 targetPatient, String sourceName, String targetName)
at GE.CPO.Common.UI.SelectPatient.MergePatientDlg.OnMergeClick(Object sender, EventArgs e)
Win32Exception: The wait operation timed out

Posted : September 6, 2018 3:46 am

acantu

(@acantu)

Posts: 722

Prominent Member

Looks like it is timing out trying to merge the documents. I would say to try to merge after hours to see if the less load on the database helps. Otherwise maybe there might be a huge amount of data to merge that Centricity cannot handle it and you may need to have GE run a manual script to complete the merger.

Posted : September 6, 2018 3:54 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I tried but no luck. The chart we want to keep has about 60 documents whereas the one we don't want has over 300 documents. 300 does not seem to be that many to timeout.

Posted : September 6, 2018 4:12 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

run the stored procedure for merging chart against the PID

Posted : September 6, 2018 4:13 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I spoke with GE. They said they might have to run the queries manually and since there is a lot of queries, it's going to take hours.

Posted : September 6, 2018 4:32 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Naaa..

i get the same error almost all the time, it happens with very large patients charts.

i run the stored procedure on the SQL side of it and it takes a few seconds, sometimes up to a minute.

Posted : September 6, 2018 4:40 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

are you referring to the merge patient setresults stored procedure?

Posted : September 6, 2018 4:51 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

No, the stored procedure name is

trReassignPatient

Posted : September 6, 2018 5:26 am

swren

(@swren)

Posts: 14

Eminent Member

Our VAR just increased the timeout limit when this happened to us. Quick fix.

Posted : September 7, 2018 12:05 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

Do you know where to increase the timeout value?

Posted : September 7, 2018 1:08 am

swren

(@swren)

Posts: 14

Eminent Member

I'm sorry, but I don't. They made the change within the database, and I don't know SQL.

Posted : September 7, 2018 1:14 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0