Skip to main content

Posts

Showing posts with the label sql server

Error on Purchase order posting in Ax 2012

 If You are getting following error on  Purchase order posting in Ax 2012 Error Description Cannot execute a data definition language command on accounting distribution (AccountingDistributionTmpJournalize). Amount in transaction currency: 0,00. The SQL database has issued an error.  Object Server 01:   [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name  'tempdb.DBO.t100007_093C403F6242343F93ED4D1F8739A'. Error Message  INSERT INTO tempdb."DBO".t100007_093323236220423232323 (TRANSACTIONCURRENCYAMOUNT,ACCOUNTINGDISTRIBUTION,RECVERSION,PARTITION) SELECT T1.TRANSACTIONCURRENCYAMOUNT,T1.RECID,1,5637144576 FROM ACCOUNTINGDISTRIBUTION T1 WHERE ((T1.PARTITION=5637144576) AND ((T1.REFERENCEROLE=3) AND (T1.SOURCEDOCUMENTLINE<>563343466))) AND EXISTS (SELECT 'x' FROM ACCOUNTINGDISTRIBUTION T2 WHERE ((T2.PARTITION=5637144576) AND (((T2.SOURCEDOCUMENTLINE=5637251266) AND (T2.MONETARYAMOUNT=1)) AND (T2.RECID=T1.REFERENCEDISTRIBUTION)))

Reports configuration manager Error

If I have uninstalled and reinstalling the reports ,in reports configuration manager it showing error Solutions: 1.delete the ReportServer database from SQL server or name the database name different from the old one 2.drop the reportserver db in server put the snapshot of the error after adding the new DB name in rs config or Do not create new report server. Select the 2nd option of configuring existing database and select Reporting server as the database

AOS Service Account in Microsoft Dynamics AX Object Server

The domain account or Network Service account the Microsoft Dynamics AX Object Server Windows service will runas. This account is used to communicate with the database server. Consider the following points when you select an account: • It is strongly recommend that you use a domain account in a production environment. You should use the Network Service account only in development and testing environments. • If the SQL Server and the AOS are on different computers, you must use a domain account. • If you plan to install any Microsoft Dynamics AX components on a domain controller, you must use a domain account. • If you plan to use Message Queuing (also known as MSMQ) for document exchange with web services on IIS, and you want to send signed messages, you must use a domain account. (If you are sending unsigned messages using web services on IIS, the AOS can run under the Network Service account.)