Category Archives: SQL

AX 2012, SSRS error: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs.

There was an issue we came across today where the users were not able to run any report on AX client and were getting the below error;

“The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameterhttp://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SRSQueryBuilderArgs’. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver or add the type corresponding to ‘SRSQueryBuilderArgs’ to the list of known types – for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to DataContractSerializer.’. Please see InnerException for more details”.

Reason:
 This happens quite frequently when AOS serving the reporting server crashes, or someone restart the AOS server without ending client user sessions.

Solution: 

To overcome this problem and to make things straight, kindly follow the below steps;

  1. Manually end client’s session,  AX> System Admin > Users> Online user> End session.
  2. Stop AOS.
  3. Open SQL, Select the record from SysClientSessions, take the backup of the records just to be on a safe side.
  4. Delete all the records from SysClientSessions table from the databse.
  5. Restart SSRS services
  6. Start AOS

This should resolve your problem.. 🙂

“Memory” full error while Synchronizing AOT and Compiling single table _ Dynamics AX 2012

MS Dynamics AX 2012 R3 CU10, has been implemented internally in our organization. Today, one of our Finance manager called me up to share an issue that he was receiving while running Trial balance.

The error was referring to the project objects “ProjTransTable and the Form.

Hence, I did a complete AOT Synchronization. System completed the synchronization with one error stating that “MSDynamicsAX_model TmpDB” memory is full linking it back to the ProjTrans Table.

I decided to compile ProjTrans table individually and system stopped with the same warning stating that “MSDynamicsAX_model TmpDB” memory is full.

I opened the SQL and took the properties of MSDynamicsAX_model database to check the actual path of the file. In my case the file location was:

“C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA”

I realized that our infrastructure team assigned less space to drive “C” and mistakenly assigned the free space to a different drive and because of having 0 space AX was throwing error. So, I enhanced space of C drive and eventually the error walked away after this activity.

  • We were able to successfully synchronize AOT
  • We were able to successfully compile ProjTrans table
  • we were able to successfully run trail balance and relevant reports

Finally, for us ……mystery was resolved 😉