Hello Everyone
when we open D365 Finance and Operations through browser , then system through error
Then we check blogs and found to resolve this error do "build all model and synchronize database". So we completed build all model without any error but when we synchronize database we get 41 system error. So we decided synchronize database through powershell script. But when we run script shown below by using powershell we got error which are also mentioned below :-
c:\> cd AOSService\WebRoot\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe-bindir"C:\AOSService\PackagesLocalDirectory"-metadatadir"C:\AOSSrvice\PackagesLocalDirectory"-sqluser"Administrator"-sqlserver"MININT-F36S5EH"-sql database"AXDB"-setupmode"sync"-syncmode"fullall"-isazuresql"false"-sqlpwd""
My Sql Sever Name is :- MININT-F36S5EH
Sql User :- Administrator
Sql Databse Name is :- AXDB
i dont know how we check bindir and metadatadir path
sqlpwd is null :because when we open sql server management studio with run as administrator they dont require password
but when we run these script system through error and the error is
Error is A positional parameter cannot be found that accepts arguments 'databaseAXDB-setupmodesync-syncmodefullall-isazuresqlfalse-sqlpwd
Which line of code throws the error when you are in the debugger?
Anyway, unfortunately I can't give you more help until you finally provide me the answer to other questions that I have asked (regarding how you ended up in this situation). You need to share more information so that we can help you. So could you please answer my questions.
Thanks Nikolaos i am tried to debug where my systems fails , but when we open D365 in browser debugger can't start. I am already attached w3wp.exe "attach to process" in debug menu. We found out some errors in output window. If you suggest me how we can resolve these, So its every need ful for me.
You are right we also find out these table and delete duplicate records on that table. After that we again start synchronize db and that time synchronization is done successfully without any error. But my problem is not resolved ; when we start D365 Finanace and Operation through browser system through error " This menu items with name "Sysloaldstartpage could not be opened". Now i will try to debug where system through error.
Just look at the error messages.
From your screenshots I can see table BFSSalaryStructure.
Can you describe me which table throw error record already exists/duplicate records exists in Unique Key field .
Thanks for everything that you have suggesting me All are working perfectly ( your power shell command run perfectly, we also find w3wp.exe and iisexpress.exe on attach to process form by clicking on " Show processes from all users". And i don't know how we can stuck on these situation actually yesterday i am build all model and also their referenced model for maintenance process . But after full compilation system through 4 error we find out all the error and resolve them. And again build my model. After successfully completed build we run D365 on browser and found that system throw error . "This menu items with name defaultdashboard could not be opened".
You need to check the "Show processes from all users" in the Attach to process form. If you have more questions about how to debug, I suggest you search information from the internet or post another question.
In this discussion we should concentrate on how to fix the problem that you described in your initial question.
And to me it looks like you don't need debugging for that. First you need to fix the sync issues and see if you can then use the system. If you still can't use the system, the next step is to debug.
we cannot find w3wp.exe and iisexpress.exe in my attach to process list. Currently we are working on D365 application 8.1.Any suggestion How we can attach process and start debugging
As you can see, many errors are talking about unique index. You are trying to create / sync an unique index, but there is already some data in the table that violates the uniqueness. So it can't be synchronized.
You can resolve it by not introducing such indexes, or by removing the violating records from these tables. Only you (or your colleagues and customer) know your solution and your data and can decide if the correct resolution is to fix the data or the indexes.
For example if your Table1 has field "Name", and you have two records with same value in field Name, you can't add an unique index that contains only field Name. But if you remove one of the records (or change one of the names), you can sync it succesfully.
Before asking more questions, could you provide answers to my earlier questions? Meaning: how did you get into this situation? That is usually very relevant when we think how to resolve the problems.
We got 41 error when we sync database through VS
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156