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

Error on training database

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

9 Posts

2 Users

0 Reactions

63 Views

RSS

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Curious for those of you who have a training database that mirrors your live database if you have every gotten this error message? Also, how did you license your test db?

Posted : June 8, 2012 4:04 am

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

How are you mirroring your database? LogShipping, Mirroring, other?

I think we had this issue as well. If I recall correctly you may have to delete the cpsuser account from the mirrored database and then re-add them. I am not 100% sure if this fixes that issue or not however.

Posted : June 8, 2012 4:28 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Havent had a chance to setup a mirroring yet. It is a direct db copy and restore.

Posted : June 8, 2012 4:31 am

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

Yes, that is what we are doing as well. I am pretty sure you need to go to the database CentricityPS, go to securities and logons and delete the CPSUSER. then recreate him at the top level and attach them back to the restored version of CPS database.

We have to do this even during a regular upgrade when moving database from one server to another. for some reason the permissions do not come across corecctly, Also probably just missing the CPSUSER account at the top level of securities for the SQL server.

Posted : June 8, 2012 4:36 am

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

ErnieT said:

Havent had a chance to setup a mirroring yet. It is a direct db copy and restore.

How are you copying your DB files across to the secondary server? I know we were using powershell to copy the file over, but as the file size grew that job started to freeze the entire server making it unresponsive. I had to automate an ftp transfer of the file nightly to avoid this issue, just FYI.

Posted : June 8, 2012 4:41 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Right now it is a Manual process. Havent had a chance to automate anything yet.

Posted : June 8, 2012 4:42 am

joshua.tilson

(@joshua-tilson)

Posts: 130

Estimable Member

ErnieT said:

Right now it is a Manual process. Havent had a chance to automate anything yet.

If you want some help / advice / what have you, when you come to that bridge let me know and I will be happy to help.

Posted : June 8, 2012 4:44 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

Thanks, I will probably take you up on that.

Posted : June 8, 2012 4:46 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

You da man Joshua. Deleted and recreated the account and worked like a charm. I will be putting that in my notes.

Posted : June 8, 2012 4:51 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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