Page 1 of 7112345678910...2025303540...Last »

SQL Server Backup Files Cleanup

I learned something interesting today. Something so simple yet crucial. Alright, let me jump straight on to it.

After going live with GP2015R2, as part of SQL maintenance tasks, I created daily backup schedule in SQL Server. Client’s backup retention policy is 3 prior days. So I created a “Maintenance Cleanup Task” to remove all backup files that are older than 3 days.

All good. Only that, it didn’t work. And we realised that only yesterday. Bummer. Thankfully, it was a new server so we had plenty of space. And size of DBs are quite small. So I could see backup files dating yesterday. Which is nice.

I had to figure out what’s going wrong all this time. It’s a fairly simple setup. Nothing complex. Something must be wrong. I opened the maintenance task definition window. Shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Looks perfectly alright to me. Isn’t it? But nope. Something makes this task fail every night.

When I looked at this post, Maintenance Cleanup Task (Maintenance Plan), on Microsoft MSDN site, I could not get much help from. It was good, detailed, but not good enough to help me why my task fails every night.

I then did something that I thought is weird, but turned out to be the solution.

I changed the File extension value from .bak to just bak, as shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Saved the definition and ran the task manually to check if it worked.

Voila… It worked…!!!

Those who are reading this and thinking about why I am blogging something as simple as this (as if I found the god particle), well in all honesty, I had absolutely no idea about this till now. Just thought I would share this, as I always do. So please be nice on me.

VAIDY

Filed under: #MSDYNGP, DBA, SQL, SQL Administration, SQL Server, SSMS, Troubleshooting, Uncategorized

More:
SQL Server Backup Files Cleanup

February 23, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 112

Management Reporter – Misspelled Account Categories

This would be second Management Reporter post in a row. This also is about the default reports and how to troubleshoot the issues pertaining to the default reports.

I have an Australian edition of GP installed. Most of the terminologies (such as “Fiscal/Financial”, “Realized/Realised”, etc) are localised in GP. However, default reports in Management Reporter still are in US English, if I am not wrong.

Consider the following default balance sheet row definition:

Screen Shot 2016-02-09 at 04.51.43 PM

I was wondering why balance on this account did not show up on the report. After several minutes, I realised that the account category was misspelled, compared to what’s there in GP. Notice that on the report definition it is “Amortization” with a ‘z’ and in GP it is “Amortisation” with a ‘s’.

After changing the categories with correct ones, by referring to GP, the report started showing the correct figures.

This post is relevant only if you reuse the default reports. It’s irrelevant otherwise.

Happy Reporting!

VAIDY

Filed under: #MSDYNGP, GP Reporting, Management Reporter, Reporting, Troubleshooting, Uncategorized

Read the article:
Management Reporter – Misspelled Account Categories

February 11, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 121

Customization Maintenance: “Unable to open … – azurecurve

Management Reporter Is Unable To Connect To The Company · Form Customisation … Media & Other Sites. MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View azurecurve on facebook View azurecurve on Google+ azurecurve Development azurecurve WordPress Plugins …

Visit link:
Customization Maintenance: “Unable to open … – azurecurve

December 30, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 126

Register for the Perth Australia December 2015 GPUG Chapter Meeting

David Meego - Click for blog homepageThis is a final reminder to register for the Perth Australia December 2015 GPUG Chapter Meeting.

It will be held at the Microsoft Office in Perth on Wednesday December 9th at 6:45am for a 7:00am start.

The details of the meeting agenda were posted last month:

As we are having a presentation from the Microsoft Dynamics GP Product Management Team delivered remotely, we invited all partners and customers in Australia to join us. In person for those in Perth, WA and remotely for those elsewhere.

The session will look at What’s new in GP 2015 R2 as well as the upcoming HTML Web Client in GP 2016 and the future product roadmap.

If you are going to join us, please register for the session:

https://dcigpugportal.cobaltsaas.com/Meetings/Registration/MeetingDetails.aspx?mid=b3dbc642-8404-4712-8772-c8f82d22b62c

Below are the LiveMeeting details for those who wish to join remotely.

When: Wednesday, Dec 9, 2015 7:00 AM (WST)
Where: Microsoft Office Perth

*~*~*~*~*~*~*~*~*~*

David Musgrave has invited you to attend an online meeting using Live Meeting.
Join the meeting.

Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.

First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.

Troubleshooting
Unable to join the meeting? Follow these steps:
1. Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/mvp/join
2. Copy and paste the required information:
Meeting ID: GPUGPERTH
Entry Code: GPUGPERTH
Location: https://www.livemeeting.com/cc/mvp
If you still cannot enter the meeting, contact support

Notice
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.

Hope you can join us.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Dynamics, GP, GPUG, Microsoft Tagged: GPUG, News

See the article here:
Register for the Perth Australia December 2015 GPUG Chapter Meeting

December 7, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 239

SQL Trigger To Automatically Enable Email Documents … – azurecurve

Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). … + 44 (0843) 289 2656 View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View azurecurve on facebook View azurecurve on Google+ …

Read More:
SQL Trigger To Automatically Enable Email Documents … – azurecurve

November 6, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 128

Discount from Packt Publishing

Have you been thinking you want to get one of my books, but holding off? No time like the present! Through the end of September my publisher, Packt Publishing, is offering 50% off if you use discount code MDGP150. No more excuses. :-)Filed under: Dynamics GP Tagged: book, Dynamics GP, featured

Original post:
Discount from Packt Publishing

September 15, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 188

Refreshable Excel report for historical GL trial balance in Dynamics GP

Want to see your historical General Ledger trial balance in Excel? Yes, you can always print out the one from GP and dump it to Excel and manipulate the results, but there is an easier way. Below is a stored procedure you can use to create this. As an added bonus, if you’re using GP Reports Viewer you can […]

More:
Refreshable Excel report for historical GL trial balance in Dynamics GP

August 13, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 223