Saturday, 6 December 2014

Common Issues while installing SSRS reporting extensions in AX 2012

Errors in AX 2012 while installing SSRS reporting extension

Setup cannot connect to the Application Object Server Instance (AOS) by using Business Connector.

·        Check whether service is up
·        Traverse to client configuration. Select Business connector. Cross check whether AOS detail is same as the service which you are using.
·        If not create new Business proxy configuration; You can edit it too.
·        IISReset , Service restart: Not Mandatory.

The AOS ‘MicrosoftDynamicsAX@ @’ cannot be reached. Setup cannot continue. Verify that you entered the correct server information and that the AOS service is running.

·        Check whether service is up
·        Traverse to client configuration. Select Business connector. Cross check whether AOS detail is same as the service which you are using.
·        If not create new Business proxy configuration; You can edit it too.
·        IISReset , Service restart: Not Mandatory.
·        Check if wizard works fine.
·        If not,Delete all records from sysserversession table except the one in use.
·        Check if wizard works fine.

Unable to find appropriate service endpoint information in the configuration object

·        Check in Sys Administration -> Inbound ports -> Bi Services that whether service is active
·        If not, Full CIL needs to be generated. If you are out of time
·        Go to services node in AOT and Right click SRSFrameworkService ->Add ons and click register service.
·        In the form select SRSFrameworkservice and click refresh.
·        If it did not work ; proceed with full CIL.
·        Refresh WCF config in client config.
·        Check if wizard works fine.
·        If not, Delete WCFConfig from regedit in following path
HKEY_CURRENT_USER\Software\Microsoft\Dynamics\6.0\Configuration\Orig

The operation failed with error code 1055.

·        Check if service is up. Or restart the service
·        If not, Restart server

Reporting Services Extension was not configured. An unknown issue occurred. Please contact your administrator.

·        Check if reporting extension has any active configuration.
·        If yes delete report configuration in AX.
·        Delete report and temp report database and create new data base through reporting configuration tool. Either SQL Server 2008 or 2012.
·        Before everything check event viewer.

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

·        Restart SSRS Service
·        Check whether user or admin has access to reporting service instance in SQL.
·        In SQL Server report configuration check test connection for data base
·        Still if you face the same issue delete report and temp report database and create new data base through reporting configuration tool. Either SQL Server 2008 or 2012.
·        Restarting service is suggested.

If you are stuck up in Business connector page during AX setup

 If you are stuck up in Business Connector page where Domain and User name is not editable, try this
·        Check System Service Account of AX ->System Administration module and update.
·        Check if problem is fixed.
·        Update business connector proxy from Client Configuration as explai8ned in top of this post.


Last Note
Majority of the errors should get cleared with one or the other steps mentioned above. Of course there is a chance of Touch luck J