Page 1 of 86012345678910...2025303540...Last »

GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

There were couple of exceptions related to GP2015 R2 that I wished to share here. One would be discussed here and other one on the next post.

After upgrading to GP2015 R2, while doing a routine testing, following error message was thrown while trying to open Smartlist:

Screen Shot 2015-07-31 at 6.53.32 PM

Full message as follows:

Unhandled database exception:
A get/change operation on table ‘ASI_MSTR_Explorer_Favorites’ failed accessing SQL data.

Number of results columns doesnt match table definition.

Number of results columns doesnt match table definition.

EXCEPTION_CLASS_DB
DB_ERR_SQL_DATA_ACCESS_ERR

Debugging this error took me to the table Smartlist Favorites Master (ASIEXP81). Strange, however, that number of columns indeed matched.

I remembered this issue happening in GP 10 and GP 2010. Suggested solutions were to run GRANT.SQL on all databases and changing ODBC provider to SQL Native Client. However, in my case, both were already done and confirmed.

To avoid any further delay or issue(s), I decided to backup the records from ASIEXP81, recreate the table using GP SQL Maintenance and push the records back from the backup table.

Resolution: Drop and create the table Smartlist Favorites Master (ASI_MSTR_Explorer_Favorites, ASIEXP81) using GP SQL Maintenance.

Only that, I did not have to reinsert the records. When I opened the Smartlist after recreating the table, it automatically populated all records. Strange, again. But it worked.

Word of caution: Always take backup before you do anything with the data.

VAIDY

Filed under: Uncategorized

More:
GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

August 2, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 5

#GPPT What’s New: Run C# and VB.Net scripts with .Net Execute

David Meego - Click for blog homepageThe Support Debugging Tool already has the ability to create and execute Dexterity sanScript and Transact-SQL scripts, without needing the Dexterity development environment or SQL Server Management Studio installed.

Now GP Power Tools adds the ability to create and execute Visual C# scripts and Visual Basic.Net scripts, without needing Visual Studio installed.

Welcome to the new .Net Execute window. Developed with the assistance of my friend Andrew Dean from Envisage Software Solutions in Sydney, the .Net Execute window allows developers with a Visual Studio and Visual Studio Tools for Microsoft Dynamics GP background to write and execute .Net scripts inside Dynamics GP.

Net Execute

When you select a script language, a template script is automatically generated in that language including the appropriate using or Imports statements. The system also adds the references to the appropriate DLLs. You can click on the References button to add additional references for other Dynamics GP dictionaries or other system or custom features.

 Net Execute References

The script editor window provides all the standard features, such as the Insert button for inserting code constructs, the Helper button for adding calls to Helper functions, the Names button for looking up and inserting dictionary resources as well as the Script menu with find, replace and syntax checking.

Using the Helper functions it is possible to create or load scripts written in Dexterity, SQL or either of the .Net languages and execute them. This allows you to write scripts in any combination of the four languages regardless of what the base language is.

Support for Visual C# and Visual Basic.Net is provided by the two addins installed with GP Power Tools. The Visual C# extension addin providing support for Visual C# scripts and the Visual Basic.Net extension addin providing support for Visual Basic.Net. These addins DLLs must be installed for the functionality to be available.

Finally, the Visual Basic.Net extension addin also provides an additional feature in the Runtime Execute window: Dexterity sanScript code can be executed in the context of a modified form, rather than the original form, and so read and write to Modifier added local fields.

Enjoy

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

Read More:
#GPPT What’s New: Run C# and VB.Net scripts with .Net Execute

August 2, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 5

#GPPT What’s New: Administrator Password vs System Password

David Meego - Click for blog homepageThe Administrator level (Advanced Mode) features of GP Power Tools require application level security, SQL Server sysadmin or dbo status and the System Password (if one is configured) to access them.

So what happens if you want a user to be able access a feature and can provide the security required at the application level and SQL Server level, but you don’t really want to provide them with the Microsoft Dynamics GP System password?

There is a solution. GP Power Tools now allows you to setup a separate Administrator Password instead of the System Password. Use the new Administrator Password Setup window to configure how you want the system to behave.

Administrator Password Setup

Once activated, the system will ask for the GP Power Tools Administrator Password (if one is configured) instead of the System Password. You also have the option to activate the feature, but not enter an Administrator password. This will disable the password request for GP Power Tools Advanced Mode windows while still leaving the System Password active on Dynamics GP system windows.

The second option on the window allows you configure GP Power Tools to not ask users for the Administrator Password when they have access to the Administrator Password Setup window. This is controlled using the GP POWER TOOLS PASSWORD Security Role. The idea here is to make life easier for the system administrator by not challenging them to enter a password every time they want to open an Advanced Mode window.

You can easily identify which password is being requested as the prompts are different on the dialog windows:

System Password         Administrator Password

Now you can choose how you want to secure the administrator level features of GP Power Tools.

Enjoy

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, What’s New

Visit site:
#GPPT What’s New: Administrator Password vs System Password

August 1, 2015 · WinthropDC · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 9

#GPPT What’s New: Security Activity Tracking and Security Log

David Meego - Click for blog homepageAs GP Power Tools approaches release, it is time to continue the What’s New series and explain another of the new features added to the product.

You can now enable Security Activity Tracking to collect statistical data on the usage of the various resources and security objects within the system.

This tracking can provide accurate data on which users use particular areas of the Microsoft Dynamics GP application and can be used to assist with the creation of Security Tasks and Security Roles when designing your security model.

The feature is enabled from the Administrator Settings window. Once enabled GP Power Tools will track every call to the application level security system and log whether access was granted or denied.

Administrator Settings 1

The information collected is kept on a user & company, user, company and system basis, so you can analyse the data from whichever angle you wish.

The new Security Log window is used to review the captured activity information. You can view the information for any user and/or company you select. The data can be initially sorted by resource or one of the 3 count columns (Total, Granted or Denied), however once the data is displayed you can click on the column headers to change the sorting as desired.

Security Log 

You can select any row in the data and right click or use the Security button to drill down to the Security Information window. You can right click or use the Open button to open a window or report if you want to see which window or report it is. You can also double click to open the Resource Information to that object or resource.

Finally you can use the checkboxes to select individual resources and/or security objects, then use the Security button to create Security Tasks and Security Roles from the selected items.

Security Log Create Task

You can now build your security model based on actual historical usage data from your own system.

Enjoy

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, Security, What’s New

View the original here:
#GPPT What’s New: Security Activity Tracking and Security Log

July 31, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 11

Hands On With Microsoft Dynamics GP 2015 R2: Install … – azurecurve

Deploy The Sample Company · Create A … of a Dynamics GP Consultant on the Microsoft Dynamics GP Community Site Visit coralcurve | A Consultants Dabblings In Dynamics CRM Perfect Image Email azurecurve View Ian Grieve’s about.me View Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

Visit site:
Hands On With Microsoft Dynamics GP 2015 R2: Install … – azurecurve

July 29, 2015 · Ian Grieve · No Comments
Tags: ,  · Posted in: Blogs I Follow Total Views: 4

Microsoft Windows 10 is now here

David Meego - Click for blog homepageFollowing on from yesterday’s post: Microsoft Windows 10 is almost here.

Windows 10 is now here and starting to install on PCs that reserved their free upgrade from Windows 7 or Windows 8.1.

My eldest son has already upgraded his Surface Pro 2 and is trying out Cortana, the Edge browser and the Xbox One integration.

Cortana

He has already tried streaming the video from the Xbox One to his screen. So now he can play Xbox games from his room while he is meant to be studying…. Great. :(

If you want to download the ISO images for Windows 10, check out the official Microsoft site below:

Remember you must upgrade first before you can do a clean install, as mentioned in yesterday’s post.

Enjoy

David

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

Filed under: Microsoft, News, Public Service Announcement, Windows Tagged: General, News, Windows, Windows 10

View the original here:
Microsoft Windows 10 is now here

July 29, 2015 · WinthropDC · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 15

Microsoft Windows 10 is almost here

David Meego - Click for blog homepageIt is already the 29th July 2015 in Australia and Windows 10 is almost here.

I know that because it is already downloading into a hidden C:$Windows.~BT folder onto my machines.

Now one question that many people are asking is “Can I do the free upgrade as a clean install if I have downloaded the ISO image?

The short answer is No.

The long answer is ….

Can I perform a clean install using the Free upgrade?

No, it will require that you are running a previous qualifying version and start the upgrade from within the qualifying version. You can initiate a clean install after completing the Upgrade.

Please be aware that you cannot use the free upgrade offer to perform a clean install on first attempt. You must first upgrade from the qualifying version of Windows 7 or Windows 8/8.1 (whether you do it through Windows Update or using the .ISO file). Ensure the upgrade is completed successfully and then ensure that it is activated. You can then proceed to do a clean install by using recovery media or using the Reset function in Start > Settings > Update & Security > Recovery > Reset this PC (Get Started).

For more information on all your Windows 10 questions, please see the following article:

Enjoy

David

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

Filed under: Microsoft, News, Public Service Announcement, Windows Tagged: General, News, Windows, Windows 10

Link:
Microsoft Windows 10 is almost here

July 28, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 19

Page 1 of 86012345678910...2025303540...Last »