Error System.Security.Permissions.EnvironmentPermission while running report

Error System.Security.Permissions.EnvironmentPermission while running report: 

Microsoft Dynamics AX 2012 Reporting extensions

We run into issue that whenever we used a Microsoft Dynamics AX configuration file with a Reporting Services instance (as mentioned in here: http://technet.microsoft.com/en-us/library/hh389774.aspx) the following error was reported the first time a report was run after the restart of the SQL Reporting Services instance:

"The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsRuntimeErrorInExpression)"

Running the report for the second time, it renders without any error. The error is mostly seen with subsequent instances of Reporting Services because only then an Microsoft Dynamics AX configuration file (Microsoft.Dynamics.AX.ReportConfiguration.axc) is used but any Reporting Services instance that is set up to use an AX configuration file will throw this error.

The resolution we found was to use "FullTrust" permission set in place of  "Execute" for the "Report_Expressions_Default_Permissions" in the rssrvpolicy.config

Existing configuration:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="Execution"
Name="Report_Expressions_Default_Permissions"
Description="This code group grants default permissions for code in report expressions and Code element. ">

[...]

</CodeGroup>

Replacement configuration:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Report_Expressions_Default_Permissions"
Description="This code group grants default permissions for code in report expressions and Code element. ">

[..]

</CodeGroup>

AX 2012 Hands on Labs

AX 2012 Hands on Labs

There are a number of guided Hands on Labs now available on Partner Source, they can be found following the links below: 

1. Workflow Implementation
2. Accounts Payable
3. Accounts Receivable Enhancements
4. Expense Management
5. Migrating Reports to SSRS
6. Employee Procurement
7. Client Forms
8. Export Extend and Refresh
9. Edit Budgets in Excel
10. Sales Quotations in Word
11. Import Data Using Excel
12. Project Accounting

Read the complete post at http://blogs.msdn.com/b/ukax/archive/2011/04/15/dynamics-ax-2012-hands-on-labs.aspx

Understanding Opportunities in AX2009 – CRM Module

Understanding Opportunities in AX2009 – CRM Module

One of the nice upgrades in AX 2009 is the addition of Opportunities in the CRM module.  During a recent AX2009 -CRM module training event, it became clear that the term “Opportunities” doesn’t always fit nicely into the way some organizations think about their CRM process.  Here’s a quick overview of Opportunities and how they fit into AX.

One way to think about Opportunities is your Pre-Sales Bucket.  This bucket contains everything you need to create, develop and close sales deals.  Opportunities pick up where Leads end.  In most organizations it is important for there to be separate definitions for recording and working with potential-sales that are unqualified (Leads), and qualified (Opportunities).  In AX2009, Opportunities keep up with:

·Communications

·Contacts

·Competitors

·Partners

·Products being quoted

·Quoted Prices

·Quantities

·Sales Stage

·Associated documentation

Opportunities are not necessarily companies, and they can contain multiple contacts.  From AX2009:

When your lead record has become an opportunity record, you can start to track more sales-related information such as quotations and competitors. Tracking the competition for the sale can give you valuable information about how to win the opportunity and gain another customer.

When you manage your opportunities, you can also give probability percentages and prognosis ratings to the opportunity and track the probability percentage, or chance that the opportunity will become a customer.

As soon as you have provided quotations and the contact at the opportunity has made a decision, you can track whether you won the opportunity and the reason why you won it. If you have lost the opportunity, you can list why and to whom you lost the opportunity, as this information might be useful later.

The slide below illustrates how Opportunities and Leads fit into the AX2009 – CRM flow:

Top 10 New and Improved Features of Project Accounting Module in Microsoft Dynamics AX 2012

Top 10 New and Improved Features of Project Accounting Module in Microsoft Dynamics AX 2012


With all the buzz and anticipation around the launch of Microsoft Dynamics AX 2012 later on this year, it’s a good time to review the new functionality of the Project Accounting module (to be called Project Management Accounting in AX 2012).

Why focus on Project Accounting module in particular?

Project Accounting supports a wide range of functions and empowers companies to meet the challenges of growth, while providing the necessary business insight for success in the increasingly competitive global environment.


Here are the top 10 new and improved features of the module:

1. Project Timesheets – It seems that improving the user experience has been the focus here. The timesheet comment functionality and the start/end dates are much more user-friendly in AX 2012. Most importantly, users will be able to create and manage favorites in Enterprise Portal allowing them to create timesheets in much quicker fashion, improving both user experience and productivity.

2. Advanced funding – this one is an attention-grabber! As a much requested feature, advanced funding in AX 2012 allows project funding to be shared amongst any number of internal or external parties, aligning your ERP configuration even closer with your actual processes. Users will be able to set up funding limits for one or more customers per category, category group or transaction type.

3. Collaboration workspace – for all of the collaboration enthusiasts, the new version brings even more excitement with the ability to create and add collaboration workspace in projects, campaigns and opportunities where project team members can quickly organize and share information within AX, making it the one-stop-shop for information while increasing the team’s efficiency and organization levels. The new options can be set up and default the collaboration work spaces for users.

4. Management of projects in Enterprise Portal – AX 2012 puts an end to the time and expense only entries in EP, allowing Project Managers to create and manage the entire projects in EP. Workers can enter daily working hours in a much improved manner and project managers can approve it directly in EP, which significantly speeds up the process and increases worker productivity.

5. Beginning balances – this is an improvement with a huge impact. In AX 2012, users will be able to enter a beginning balance for a project which will help in transferring projects to Microsoft Dynamics AX 2012 from legacy project management systems without affecting the general ledger. Let’s say you have been tracking a project in an outside application but managing costs and revenue in AX. You will now be able to transfer the project to AX, specify a beginning balance and then track all the information in one place.

6. Project revenue from free text invoice - AX 2012 makes it possible to track revenues which are billed though free text invoicing. This was a significant requirement missing in AX 2009.

7. Transaction adjustments - this feature will make correction of wrong project entries easier, allowing adjustments even after invoicing. Adjustment dates can be used as project dates for adjustment transactions (as opposed to transaction dates only). The relationship between the original, reversed, and the replacing transaction can be well traced now with information of what exactly the user adjusted.

8. Project budgeting – Microsoft has taken budgeting to a new level with major enhancements in this area in the AX 2012 version. Project budgeting will be available at the activity level. Project budget revisions can be created at various levels of the project and can be submitted for review and approval, which once approved would trigger an immediate change to the overall project budget. A complete history or audit trial of the proposed, original, accepted (approved), and rejected budget is available for review at any point of time. Original budget can be created to define a budget at various levels in the project hierarchy and it can be submitted for approval. It can also be allocated over a period of time. The project financial inquiry and the project financial status reports now presents details of the project budget also. If you are working on a multi-year project, you can carry forward project budget at the end of the year to the future year and make necessary changes to the general ledger accounts associated with them.

9. Item charges/costs in PO, SO and invoice lines will now be recognized in projects. Any taxes for the item charges will now be going to an expense account and item charges will now be recorded in project budgets and commitments. This is an important functionality which was not available in Dynamics AX 2009.

10. Progress billing, estimates and revenue recognition – the introduction of these features addresses the critical issue of ERP migration. When migrating from one ERP system to another, data migration is a serious issue. Bringing in the existing data into the new system is where all the hurdles arise. For example, ensuring that revenue continues to be recognized for the fixed price projects that are already underway. Since revenue recognition depends on the completion % of the project, the data must be migrated so that both % of work completed (actual cost) and the remaining work (cost to complete) are reflected in proper accounts.

Microsoft Dynamics AX 2012 also promises to give a significantly improved UI experience across the modules with the introduction of new form controls such as action panes, fact boxes and fast tabs, allowing users to access critical project data in a single form without having to navigate to the related forms.

AX Scribe Services

AX Scribe Services



Error:

Solution:


Scribe account is locked out. Need to get it unlocked! 

Microsoft Dynamics AX 2009 AOS Troubleshooting tips, AOS Troubleshooting Tips and Techniques in Microsoft Dynamics AX 2009

Microsoft Dynamics AX 2009 AOS Troubleshooting tips, AOS Troubleshooting Tips and Techniques in Microsoft Dynamics AX 2009

·         AOS Configuration

·         Best Practices

·         Troubleshooting AOS issues

·         Finding Sessions and SPIDS

·         AOS Crash Maintenance

·         Tools for Troubleshooting AOS issues

AOS Configuration

·         Application Object Server Configuration

·         Database Tuning Tab

·         Tracing Tab

·         Performance Tab (Dynamics AX 2009)

·         Dynamics AX Server Configuration Utility

·         Configuration stored in Registry:

o   HKLM\SYSTEM\CurrentControlSet\Dynamics Server\4.0\instance\config name

·         Multiple AOS instances and configurations

Server Configurations

·         Each AOS instance listed

·         Each AOS has configurations

Application Object Server Tab

·         Configuration command to run at startup

·         Allowing clients to print from AOS printers

·         Enabling breakpoints

·         Fatal error reporting

·         Load Balancing

AOS Load Balancing

·         Number of client sessions

·         What is a load balancer

·         How connections work when using load balancing

·         Factors when deciding if you need a load balancer

·         Provides fail over ability

·         Balances number of clients between AOS’

·         Control the number of clients per AOS

AOS without clustering

·         With no options marked in the load balancing section each client will connect to the AOS in their client configuration

Each AOS balancing load
As a client connects to an AOS that AOS queries the database to determine which AOS the client will connect to

      AOS as Load Balancer

·         The load balancer makes the connection to the database and determines which AOS the client will connect to

·         This AOS will not accept any client connections nor do any processing

·         This AOS does not count against your AOS licenses

     AOS Load Balancer - Client Configuration

·         In the Dynamics AX 4.0/5.0 Configuration utility you will want to specify the machine name and port number for the AOS load balancer instance

·         Add AOS member instances after the load balancer

      If you do not use a load balancer then you specify all the AOS member instances in your client configuration.  If you do used the load balancer then specify the load balancer first and then the AOS member instances in case your load balancer AOS fails. 

      Database Tuning Tab

·         Max open cursors

·         Max buffer size

·         Allow index hints in queries

    Tracing Tab – Server Settings

·         SQL Statements

o   Queries issues to the SQL Database

·         Bind variables

o   Parameters specified for each of the SQL queries

·         Row fetch

o   Number of rows returned by SQL

·         Row fetch summary

o   Same as row fetch, and includes timing information

·         Connect and disconnect

o   Connections and disconnections to SQL

·         Transactions: TTSBegin, TTSCommit, TTSAbort

o   Transaction statistics, not necessary if X++ method tracing is enabled

    Tracing Tab – SQL Settings

·         RPC round trips to server

o   Remote Procedure Calls between Client and Server

·         X++ method calls

o   Method calls within the X++ language

·         Function Calls

o   X++ built in functions such as int2str

·         Number of nested calls

o   Depth of the X++ call stack when collecting traces

    Dynamics AX 2009 features

·         Performance tab

·         64 bit

·         Batching

·         Time Zones

   Best Practices

·         Separate AOS’

·         Separation of environments

·         Monitoring performance

·         Code deployment

·         Applying latest Kernel hotfixes

   Separate AOS’

·         Consider separating out the following processes / components  based on load

o   Additional Dynamics AX components

o   Third Parties

o   Batch

   Separate out environments

·         Servers for production environment should be on dedicated boxes

o   Server resources dedicated to production performance

o   Reduce risk of development code utilizing majority of Servers resources

o   Application of hotfixes

o   Additional components that need .Net BC

   AOS Baselines

·         Performance Monitor

o   Memory

o   CPU

·         Memory usage

o   Different times of day

o   When specific processes run

    Note:

    On Dynamics AX 4 memory limitation of 2 Gig for each AX32serv.exe process

•       If AX32serv.exe consistently around 1.5 gig of memory start evaluating processes and consider adding another AOS

•       If AX32serv.exe reaches 1.8 gig of memory you will likely see user connections to the AOS denied and possibly AOS crashes

   On Dynamics AX 2009 if running on Windows Server 64 bit editions the limitation is based on memory in server.

   Proper code deployment

·         Code promotion schedule

·         Promote code during down time

·         Determine if you will use XPO’s or layers to move code from development/test to production

·         Test code in environment that matches production before deploying   

   Apply Kernel Hotfixes

·         Improved Stability

·         Apply on all machines with a Dynamics AX components

o   Dynamics AX client

o   Enterprise Portal

o   SSRS machine

o   Any machine with .Net Business Connector

Troubleshooting AOS errors

·         Application event log

·         RPC errors

·         Connection issues

·         AOS Crashing

Application event log

·         Windows default event logging tool

·         Different types of events

o   AOS starting

o   User errors

o   Cache flushing

o   Crashes

Events related to connection

·         Lost connection to AOS

·         Cannot or lost connection to SQL

·         Lost connection to the AOS

Connection to AOS

·         Object Server 01: RPC error: Client provided an invalid session ID 75

o   This error message indicates that the AOS has crashed.  After the AOS crashed a client that was open when the crash occurred tried to connect to the AOS.  Since the AOS was restarted it does not recognize the existing client connection.

o   To resolve this issue the client has to be shut down and restarted

• Object Server 01: No ping from 77. Terminating the session.
• This error message indicates that the end user ended the client session before the AOS could return the requested results to the client. 
• To prevent this error message end users shouldn’t end task (ctrl –alt – delete) their Dynamics AX session.  Instead an end user should contact their AX administrator and have them end their session from the online users form.
• Object Server 01: SPID 57 for Session Id 77, is still present in the database. Please delete the SPID from the database.
• This indicates that the end user shut down their Dynamics AX client before SQL  finished processing the request.
• You can delete the SPID or let SQL finish processing
• If you don’t clean up the SPID it could cause issues such as blocking transactions, and open transactions which may lead to transaction log backup failures.

Connection to SQL

·         Object Server 03: Fatal SQL condition during login. Error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Corp\axadmin'.“

• This typically indicates the AOS service account does not have permissions to the database.
• Object Server 03: SQL diagnostics: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Corp\axadmin'.. Connect information was: Userid = [], Database = [DAX_Prod], Server = [server1], DSN = [], Other = []
• This is caused by insufficient SQL permissions.

·         Object Server 03: Internal Error occurred executing stored procedure when creating session for the AOS.

o   This indicates the AOS Service account does not have adequate permissions to the stored procedures in the database.

Connection to application files

·         Error in file: C:\Program Files \DynamicsAX\ Application\appl\prod \axsys.aod while reading in record 215B1D0
Windows Error: =  Error Code: 64 = The specified network name is no longer available.
Try again?

o   This error indicates the AOS has lost connection to the Application files.

o   To resolve this error message you need to restart the AOS.