Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Dynamics AX 2009 SSRS report throws the error "The Default value expression for the report parameter "AX_CompanyName" contains error"


Symptom

When you try to run any Microsoft SQL Server Reporting Services (SSRS) reports that were deployed from Dynamics AX Reporting extensions, you receive the following error message: 

"The DefaultValue" expression for the report parameter "AX_CompanyName" contains an error: Dynamics Adapter LogonAs failed
 

↑ Back to the top


Cause

The problems occurs if the Business Connector session is not getting created.  
You do not see a Business Connections session type in the online users form in Dynamics AX.  
You also do not see an event ID of 172 for a Business connector startup session on the SSRS server.  
You do not have Enterprise Portal Framework license.

↑ Back to the top


Resolution

On the SSRS server machine where you have .NET BC installed, check the following:  

1. Check Microsoft.Dynamics.BusinessConnectorNet file version in :\windows\assembly folder (GAC). To do this, right-click on the file, select Properties then select the Version tab. Make sure it's the same version as your AOS version (ax32serv.exe)

2. Make sure that the SSRS service account is the same as your Business Connector Proxy account in Dynamics AX.

3. Check the Dynamics AX client configuration for the Business Connector (non-interactive use only) configuration and make sure it points to an active AOS in the Connection tab. (Administrative Tools> Microsoft Dynamics AX 2009 Configuration)

4. Copy the Business Connector configuration to the desktop and double click on it to launch Dynamics AX. This will validate that the configuration is good  

5. Check the Application event log on the SSRS server to make sure you do not see other errors as to why Business Connector is not able to connect to the AOS. Sometimes, the error in the event log indicates that the client path is incorrect. For example, it might try to launch the AX client from \Program Files\Microsoft Dynamics AX\50\Client\Bin instead of \Program Files (x86)\Microsoft Dynamics AX\50\Client\Bin on a 64 bit server (this is related to the next item listed) . 

6. If Business Connector proxy account is also a user in Dynamics AX, login to this server as the Business Connector proxy account and validate you can launch Dynamics AX successfully as the Business Connector proxy user using the active Dynamics AX client configuration (not an axc file). Sometimes, the Dynamics AX config file for the Business Connector proxy user is not set up correctly in the registry (HKCU/Sofware/Microsoft/Dynamics AX/5.0/Configuration). You will receive an error message that indicates the path to the Dynamics AX client is invalid if the issue is related to the previous bullet point when trying to launch the AX client (ax32.exe) 

7. Verify you can browse to the Enterprise Portal site or Reports Manager site successfully and that you do not see an Internet Explorer (IE) connection error. If you do see a connection error in IE, check to make sure you have marked the Automatically detect settings check box for your proxy setting in IE. To do this, click Tools, click Internet Options, click the Connections tab, and then click LAN Settings. Click to mark the Automatically detect settings check box.

8. Make sure you have the Enterprise Portal Framework lincense. To verify, Click Administration, click Setup, click System, and then click License information. Click the Web tab, and verify you have Enterprise Portal Framework License (you should see ******* in the License code column.)


↑ Back to the top


Keywords: kbmbspartner, kbsurveynew, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 2521632
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 84