Home Forums Discussions Problems Amazing Charts Backup error

Hello all,

First time here, unfortunately for a call for help. I'll give a quick run down of the situation. The office came to the conclusion that it was time to upgrade our server. Nothing fancy at all, Dell PE T20 w/ E3-1225 v3, 20GB ram, running Server 2012 R2. The old server was Server 2008 R2.

I migrated all the users, shares, etc. to the new server. Over a weeks time I verified everything was copacetic on that front. Well, the doctor has a hosted EMR but he also likes to keep the data in Amazing Charts locally just in case we lose internet for an extended period of time so he still has access to patient information. He copies this data manually, just FYI. The decision was made to migrate AC to the new server and that would allow us to retire the old as that was the only thing it was doing now.

On the old server I created an AC backup. No big deal, everything went as expected. Installed AC on the new server, created a dummy practice, and imported the backup. I had to open ports in the firewall to allow access to SQL from his computers but other than that it all went fine. However, over the last week I've been trying to create a backup of the database on the new server. The AC backup utility runs, says its creating a backup, and about 10+ minutes later errors outs with a message like "Backup error, check backup log".

It creates the BACKUP folder in the AC folder, and even the folder inside that for that backup instance. I've checked security permissions on the folder, even as far as to make sure Everyone, Admins, the SQL acct etc has Full access but to no avail. I also can't find any type of log if it is actually creating one.

Its probably very important to note he's still running 5.0.29. I have no idea why hes still running such an old version, but it was working fine on the old Server 2008 server.

I'd appreciate any help/ideas anyone can offer.

Thanks in advance,
Tristan

Tristan,

I can log n later this morning and take a look, but check in the AC folder itself and the backup folder - are there any .bak files? This is the step in the process, where AC makes a SQL backup.

No, it just creates the folders. The office is closed until Thursday and I'm posting this from home. I tried posting yesterday but didn't realize new accounts required approval and had left before it was approved (no biggie).

Tristan,

Sounds like there is a server/permissions error, but that version is solid, so it shouldn't be a long term issue.

You can use our contact form to reach us, or send me a Private Message.

Tristan it does this when there is a backup error. you can delete those folders. you are probably running out of room. I added a 6tb hard drive and moved everything over to it. The one issue is that with AC you can't keep AC from making a backup file in the Back up folder in ACbackups. you can add a second place to make a file but you can't keep it from the main drive.

I found after all the work of moving everything that my biggest issue is in the temp folder for my server i needed to clear it out!!!!

you may not need to make the server change...we can talk privately if you want.

The OS drive is a 1TB drive, with 800+gig free. Overkill for the needs of this particular office but plenty of room to grow, so I know it's not a space issue. I did, however, run into that problem on the old server. To fix it I just trimmed about 150gig off the 2TB data drive, created a new logical partition and mounted the volume as the BACKUP folder in the AC folder. Worked like a charm. The decisions been made to retire the old one however, so I'm just trying to facilitate that. This is the only issue I'm having.

I'm pretty convinced it's a permission issue somewhere but since I can't locate any error logs I'm just trial-and-erroring and comparing from the old server at this point. Unfortunately I haven't been able to get any time to dedicate being physically at the office, so I'm doing this periodically over VPN in my spare time at night.

Greatly appreciate your input,
Tristan

Almost all software support's first question will be what version are you on. I don't even think AC supports that version anymore. The first thing I would do would be to upgrade from v5 to at least v8.2.4. I wouldn't upgrade to v9 yet as that may throw other things into the mix.

I think you have to upgrade to a newer version in between. Did v5 use SQL 2005 or 2012. I thought it was 2005.

What do you mean by he copies the data manually? This has me fascinated.

Besides the fact that 8.2.4 has infinite improvements. v9 even more, but it already has some issues with backups.

I've fixed the issue within what I think is satisfactory. I'm going to assume that it's a permission issue between SQL Express 2005 and Server 2012 R2. For whatever reason when it initiates the BACKUP DATABASE command it can create the BACKUP folder, the corresponding folder with practice-date-timestamp, and then the AmazingCharts.bak file. The file size never reaches above 0. I'm guessing its related to a security thing with the Program Files (X86) folder and a MODIFY permission.

To bypass this and basically make it think it was still using the BACKUP folder I made a symbolic link to a folder on the data drive. Ran the backup utility, and finally ended up with a fancy little backup zip.

From the CLI and in the Amazing Charts folder:
MKLINK /D BACKUP "E:\Backups\Amazing Charts"

Bert,

To appease your fascination, he basically generates some report with the patients information with his hosted EMR and then copy/pastes that data in one chunk to Amazing Charts. This is merely for his peace of mind in case he loses internet or something for an extended period of time. We're well within tornado alley so it's not too far fetched to think connectivity could be down for an extended time.

Everything seems copacetic on my end now. Thanks everyone for the help. Hopefully this can help someone else in the future

Tristan

Hi Tristan,

It's rather obvious you know what you are doing based on the script. But do you think that it's possible SQL 2012 would work better than SQL 2005. I don't understand why you would upgrade to this very nice server set up and still run v5.x and SQL 2005? Is 2005 at end of life yet?

I only ask about the double charting as you may want to check with your liability insurance and attorneys to see if they are both discoverable.

If there is a SQL permissions issue, it also would make sense to fix that rather than add another layer of complexity. Glad it's fixed.