Sunday, June 20, 2010

Leaving for Spain

Thursday, June 10, 2010

Public vs Private Cloud Computing and Companies

I found these articles insightful regarding the decisions that companies face regarding cloud computing.  It seems that “Private” cloud computing is an option that companies are considering when security, privacy and control cannot be ceded to a “public” cloud. Yet the cost savings and flexibility of outsourcing your infrastructure is very appealing to those that make decisions. 

“An organization with a large internal IT estate may wish to repurpose some of this to create a private infrastructure cloud--a sound way to increase utilization of existing assets and consider the internal economics of providing IT as a service.”Owen Garrett, “Keeping Cloud Costs Grounded”, 2010, <http://www.forbes.com/2010/06/02/internet-software-zeus-technology-cloud-computing-10-garrett.html?partner=email>(accessed June 04, 2010).

“As cloud computing shows its strengths in flexibility and economical operations, corporate computing operations are taking notice--even at companies that are too conservative to place much trust in the cloud services on the Internet. So now we hear a lot of talk about "private clouds," which usually mean server clusters behind the corporate firewall that mimic the operation of the public clouds.”David F. Carr, “What Cloud Computing Means”, <http://www.forbes.com/2010/06/02/microsoft-google-amazon-technology-cloud-computing-10-leaders.html?partner=email>(accessed June 04, 2010).

Can medical organizations go with IaaS (Infrastructure as a Service) and still meet HIPPA compliance?  Will relying on the vendor’s best practices on securing patient data be sufficient to avoid government fines in the event of a breach?  These are questions that have not been answered and unfortunately may not have an answer until the first breach occurs.  I would expand on David F. Carr statement that not only “companies that are too conservative”, but industries that are too conservative like banking, medical will need to be slow to move towards public cloud computing. Any company that deals intimately with user privacy will need to experiment with the private cloud computing option before they ever considering the public aspect of cloud computing.

Posted via email from Orencio's posterous

Friday, June 4, 2010

Check you settings

This site made fixing my setting for my privacy reeeeally easy.  I think FB has been really useful for connecting with friends but let’s face it they are pimping out our info to make money which isn’t cool.  So check your setting and close the door to protect your info and your.

http://www.reclaimprivacy.org/

Posted via email from Orencio's posterous

Tuesday, June 1, 2010

Progress AI Roll forward Issue

I had an issue with restoring my Progress database and the AI roll forward process that has me a little stumped.  I restored the backup from 5/27 12:30AM without incident.  During the evening I went and copied over the AI files for that day as seen at the very bottom.  Below I copied the command prompt for the session I was using during the roll forward operation.

C:\Intergy\DB>rfutil medman -C roll forward -a D:\int_bkp\CopyAI\medman.a4

OpenEdge Release 10.1B0347  as of Tue Feb  3 10:20:44 EST 2009

** The database was last changed Thu May 27 21:13:10 2010. (831)

** The after-image file expected Tue May 25 21:00:04 2010. (832)

** Those dates don't match, so you have the wrong copy of one of them. (833)

roll forward open D:\int_bkp\CopyAI\medman.a4 error: -1. (11014)

I got a response from Donald Church that explained what’s going on:

“Glad to hear that the training is proving useful – and I think I know what is happening with your AI roll. According to your screenshots, you restored a backup that was made at 12:30 AM on 27 May. This would mean that at that time an AI switch would have occurred, the previous AIs copied to the backup folder and all copied AIs would have been remarked as empty. (This is assuming you had used the backup script and not a manual backup)

What the message in the Roll Forward of .a4 is telling you is that at some point after the restore, around 9:13 PM, the database was started and records began to be written. So if you imagine for a moment that the database was on record 10,000 at the time of backup, the AI file immediately started would have recorded record 10,001. But by starting the database at 9:13, a new record 10,001 was written along with whatever data followed thereafter. Now fast forward to 10:20 PM when you attempt the Roll Forward – you are asking the database to accept the original record 10,000 from the AI file when it is now on record 10,012 or something due to the database running since the restore. In a nutshell, by using the database after the restore, you invalidated all those AI records since they are sequential for only the original data.

This is similar to the issue in the movie ‘Back to the Future, Part II’ – Doc and Marty couldn’t fix what Biff did with the sports almanac in the future because if they traveled to the future, it would be the alternate future where Biff was powerful. The solution to your problem is the same as what they did in the movie – go to the past and fix it there. Restore the database from the backup again and Roll Forward the AIs without starting the database this time. That will make the numbers be in sequence and work.

The only caveat to all this is whether or not AI was turned on after you did the original restore – if so, you might have AI data based off all the records that the database added after the restore at 9:13 PM. Luckily, RFUTIL is pretty smart and will notice those records don’t match on time stamps and have wrong sequence numbers.”

Orencio Cárdenas

IT Manager

Femwell

Tel.# 305-273-4641 X141

Tel.# 305-631-7670 Help Desk

Cell# 786-566-8457

Posted via email from Orencio's posterous

Progress AI Roll forward Issue

I had an issue with restoring my Progress database and the AI roll forward process that has me a little stumped.  I restored the backup from 5/27 12:30AM without incident.  During the evening I went and copied over the AI files for that day as seen at the very bottom.  Below I copied the command prompt for the session I was using during the roll forward operation.
C:\Intergy\DB>rfutil medman -C roll forward -a D:\int_bkp\CopyAI\medman.a4
OpenEdge Release 10.1B0347  as of Tue Feb  3 10:20:44 EST 2009
** The database was last changed Thu May 27 21:13:10 2010. (831)
** The after-image file expected Tue May 25 21:00:04 2010. (832)
** Those dates don't match, so you have the wrong copy of one of them. (833)
roll forward open D:\int_bkp\CopyAI\medman.a4 error: -1. (11014)
I got a response from Donald Church that explained what’s going on:
“Glad to hear that the training is proving useful – and I think I know what is happening with your AI roll. According to your screenshots, you restored a backup that was made at 12:30 AM on 27 May. This would mean that at that time an AI switch would have occurred, the previous AIs copied to the backup folder and all copied AIs would have been remarked as empty. (This is assuming you had used the backup script and not a manual backup)

What the message in the Roll Forward of .a4 is telling you is that at some point after the restore, around 9:13 PM, the database was started and records began to be written. So if you imagine for a moment that the database was on record 10,000 at the time of backup, the AI file immediately started would have recorded record 10,001. But by starting the database at 9:13, a new record 10,001 was written along with whatever data followed thereafter. Now fast forward to 10:20 PM when you attempt the Roll Forward – you are asking the database to accept the original record 10,000 from the AI file when it is now on record 10,012 or something due to the database running since the restore. In a nutshell, by using the database after the restore, you invalidated all those AI records since they are sequential for only the original data.

This is similar to the issue in the movie ‘Back to the Future, Part II’ – Doc and Marty couldn’t fix what Biff did with the sports almanac in the future because if they traveled to the future, it would be the alternate future where Biff was powerful. The solution to your problem is the same as what they did in the movie – go to the past and fix it there. Restore the database from the backup again and Roll Forward the AIs without starting the database this time. That will make the numbers be in sequence and work.

The only caveat to all this is whether or not AI was turned on after you did the original restore – if so, you might have AI data based off all the records that the database added after the restore at 9:13 PM. Luckily, RFUTIL is pretty smart and will notice those records don’t match on time stamps and have wrong sequence numbers.”

Intergy Backup Restore Checklist

I’ve been restoring our Intergy database on Progress and I developed this checklist below to help define the process. I read the Checklist Manifesto and found the overall message really applicable to IT tasks. 

Intergy Backup Restore Checklist

r 1. Is the medman.odbk file from the previous date on the Intergy Backup Server (INTBKPSRV)

o    If NO find it on \\192.168.3.200\share\int_bkp and move to INTBKPSRV.

r 2. Copy AI files from Production server to AI drive on INTBKPSRV

r 3. Confirm that drive structure matches production environment

o    D = AI

o    E = BI

o    F = DB

r 4. Before Installing run (install.exe user \) prior to running the setup.exe for Intergy.

r 5. Install Intergy Server (Point DB to drive F)

o    EHR

o    Storage Server

o    Patient Portal

o    > 50 Users

r 6. AI & BI file locations: During installation you must point Intergy toward the appropriate drives for where this data will reside. (See step 2)

r 7. After Server Restart Launch Database Administration

r 8. Choose Enterprise 80 GB

r 9. Redirect the AI, BI and DB to the correct drive paths

r 10. Navigate in Command Prompt to c:\intergy\db to run all commands

r 11. Intergy large File Support: To add support for larger than 2GB storage area files, run the following command:

o    PROUTIL medman –C enablelargefiles

r 12. Consult the medman.lg file for detailed information concerning the database.

r 13. Shutdown Database: promon medman Option 8 then Option 2

r 14. VERIFY DATABASE: prorest medman D:\IntergyBackup\medman.odbk –vp

r 15. DELETE DATABASE FILES: prodel medman

r 16. RESTORE DATABASE: prorest medman D:\IntergyBackup\medman.odbk

r 17. Launch “Database Administration” and Start the database.

r 18. Run Intergy, Intergy EHR and Test

ROLL FORWARD

r 19. RESTORE FILES FROM LAST BACKUP: rfutil medman –C roll forward –a <afile#>

r 20. ENABLE AI: rfutil medman –C aimage begin

POST RESTORE STEPS

r 21. Verify Cluster size: proutil medman –C truncate bi 16384

r 22. Verify AI is enabled: rfutil medman –C aimage extent list

r 23. RESTART SERVER (After restart review the medman.lg file to ensure proper database start up.

Restore database without loading Intergy

r Repeat Steps 12 through 18


Intergy Testing

r Login to 10 random Data Sets

r Check patient demographic data in Intergy PM and Intergy EHR.

r Check patient billing data in Intergy PM

r View EOB image from DOM

r Print Encounter form

r Print Schedule Summary for the day

r Change patient demographic and billing data

r Make a backup of new changed database. (45 min)

r Restore original database and have Operations validate that data is gone. (45 min)

r Restore changed database and have Operations validate that data is restored. (45 min)

Orencio Cárdenas

IT Manager

Femwell

Tel.# 305-273-4641 X141

Tel.# 305-631-7670 Help Desk

Cell# 786-566-8457

Posted via email from Orencio's posterous