Just Wanna Help
Finnaly ... This is mY Blog I just wanna sharing with everyone... And make Everyone smile ... coz mybe they are find useful thing in here...
Sunday, November 26, 2017
How to Convert vdi to vmdk In Windows
Open command prompt run as Administrator
Type BoxManage.exe clonehd C:\virtual\VM\DAX2012CU10\DAX2012CU10.vdi D:\temp\DAX2012CU10.vmdk --format vmdk (ex. i have vdi file DAX2012CU10.vdi and convert to DAX2012CU10.vmdk
wait untul progress 100% (see the picture at below)
Monday, February 22, 2016
Msg 8985, Level 16, State 1, Line 2 Could not locate file '' for database '' in sys.database_files. The file either does not exist, or was dropped.
This error raised when i want to shrink log file, the solution for this just rename the logical file in SQL management studio, i am using SQL 2012 version :
In my case this error caused by, when restore backup file we choose another name for db, unfortunately the logical name is still using previous name.
So the solution is :
Please following this step :
GO
ALTER DATABASE [MSTestAX] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(MSTestAX_log, 1)
ALTER DATABASE [MSTestAX] SET RECOVERY FULL WITH NO_WAIT
GO
8. Finish
READ MORE -
Msg 8985, Level 16, State 1, Line 2 Could not locate file '' for database '' in sys.database_files. The file either does not exist, or was dropped.
In my case this error caused by, when restore backup file we choose another name for db, unfortunately the logical name is still using previous name.
So the solution is :
Please following this step :
- Open management studio
- Right click the database > Properties
- Pics
- Click files and change the logical the with the correct one, for me is 'MSDBAX' replace with 'MSTestAX'
- Pics
- Click ok
- Now you can run the script for truncate the log file, like sample below
GO
ALTER DATABASE [MSTestAX] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(MSTestAX_log, 1)
ALTER DATABASE [MSTestAX] SET RECOVERY FULL WITH NO_WAIT
GO
8. Finish
Friday, July 24, 2015
Restore database dynamic ax 2012 and deploy to new environtments.
In Dynamic AX 2012 R3, When you need the data from production environtment and you want to restore it in your environtment, there are few tables that you want to change it or deleted the value.
1. Open Database for Dynamic AX 2012
2. Find this following table.
READ MORE -
Restore database dynamic ax 2012 and deploy to new environtments.
1. Open Database for Dynamic AX 2012
2. Find this following table.
- UserInfo and change it column SID, NETWORKDOMAIN, for column ID value is Admin
- SYSSERVERCONFIG = deleted the existing value and then add a new row for your server environtment
- SYSSERVERSESSIONS = deleted the existing value, except your server environment value.
Regards
:Dpr
Thursday, April 16, 2015
HTTP Error 503: Service unavailable when testing Realtime Service on Dynamic AX 2012 R3
HTTP Error 503: Service unavailable when testing CDX Realtime Service on Dynamic AX 2012 R3 CU8
The syntax above raise when test CDX Realtime Service on IIS
The Solution is :
Try check your account name for running service CDX Realtime (Length of account shouldn't exceeds (20)
example : DevRealTimeServiceAcc (21)
thil will cause an error when we browse Realtime Service In IIS with the account by example, because the system only read (20 char) whic is DevRealTimeServiceAc
Wednesday, March 18, 2015
Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView). Error accessing database connection. Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.
I have an error on my server delevelopment in dynamic ax 2012 r3
the error syntax is : Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView).
Error accessing database connection.
Cannot create a record in SysXppAssembly (SysXppAssembly).
The record already exists.
the solution is :
1.full compile
2. synchronize
3. full cill
4. restart aos
5. start dyanmic ax 2012 (the error fixed)
READ MORE -
Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView). Error accessing database connection. Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.
the error syntax is : Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView).
Error accessing database connection.
Cannot create a record in SysXppAssembly (SysXppAssembly).
The record already exists.
the solution is :
1.full compile
2. synchronize
3. full cill
4. restart aos
5. start dyanmic ax 2012 (the error fixed)
Friday, September 05, 2014
How To Get Contact Information on Dynamic AX 2012 R3 - Dwipa Rachmawan
Here is the sample how to get or retrieve multiple contact information on customer
like the following pictures :
When we are clicked the button More options - Advanced :
As you can see in this form the datasources is LogisticsElectronicAddress
but the information about Purpose is not in here.
So this is the jobs for retrieve contact information and display the value Purpose
static void DPR_ContactInformation(Args _args){ DirPartyContactInfoView contactInfoView; LogisticsElectronicAddress logisticsElectronicAddress; LogisticsElectronicAddressRole logisticsElectronicAddressRole; LogisticsLocationRole logisticsLocationRole; CustTable custTable; DirPartyPostalAddressView DirPartyPostalAddressView,postalAddressView; select * from CustTable where custTable.AccountNum == '3003'; while select contactInfoView where contactInfoView.Party == custtable.Party join DirPartyPostalAddressView where DirPartyPostalAddressView.Party == contactInfoView.Party join logisticsElectronicAddressRole where logisticsElectronicAddressRole.ElectronicAddress == contactInfoView.RecId { info(strFmt('Name=%1 Type=%2 Locator=%3 Purpose=%4',contactInfoView.LocationName, contactInfoView.Type, contactInfoView.Locator, LogisticsLocationRole::findRec(logisticsElectronicAddressRole.LocationRole).Name)); }}
And here is the result
Good Luck
Wasalam
READ MORE -
How To Get Contact Information on Dynamic AX 2012 R3 - Dwipa Rachmawan
like the following pictures :
When we are clicked the button More options - Advanced :
As you can see in this form the datasources is LogisticsElectronicAddress
but the information about Purpose is not in here.
So this is the jobs for retrieve contact information and display the value Purpose
static void DPR_ContactInformation(Args _args){ DirPartyContactInfoView contactInfoView; LogisticsElectronicAddress logisticsElectronicAddress; LogisticsElectronicAddressRole logisticsElectronicAddressRole; LogisticsLocationRole logisticsLocationRole; CustTable custTable; DirPartyPostalAddressView DirPartyPostalAddressView,postalAddressView; select * from CustTable where custTable.AccountNum == '3003'; while select contactInfoView where contactInfoView.Party == custtable.Party join DirPartyPostalAddressView where DirPartyPostalAddressView.Party == contactInfoView.Party join logisticsElectronicAddressRole where logisticsElectronicAddressRole.ElectronicAddress == contactInfoView.RecId { info(strFmt('Name=%1 Type=%2 Locator=%3 Purpose=%4',contactInfoView.LocationName, contactInfoView.Type, contactInfoView.Locator, LogisticsLocationRole::findRec(logisticsElectronicAddressRole.LocationRole).Name)); }}
And here is the result
Good Luck
Wasalam
Wednesday, August 27, 2014
Error when refresh PurchPurchaseOrder datasource on Dynamic AX 2012 - Dwipa Rachmawan Cool :P
When i do custom report Purchase Order in AOT the report name is PurchPurchaseOrder
and do refreshing on dataset PurchPurchaseOrderLine. The error raise
Element
':PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal' has already been defined.To correct this, rename one or more of the model elements so that they have a unique name.
Do following step in order to fixed the problem
1. just rename it the parameter IsPurchConfirmationRequestJournal become IsPurchConfirmationRequestJournalX (you can do as you want)
2. set property this IsPurchConfirmationRequestJournal
3. after you rename it, right click the report PurchPurchaseOrder and klik restore. (just klik ok if there is popup windows)
4. do refreshing again on dataset PurchPurchaseOrderLine
when doing system will create for you another parameter which is IsPurchConfirmationRequestJournal
and change this parameter property like above
READ MORE -
Error when refresh PurchPurchaseOrder datasource on Dynamic AX 2012 - Dwipa Rachmawan Cool :P
and do refreshing on dataset PurchPurchaseOrderLine. The error raise
Element
':PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal' has already been defined.To correct this, rename one or more of the model elements so that they have a unique name.
Do following step in order to fixed the problem
1. just rename it the parameter IsPurchConfirmationRequestJournal become IsPurchConfirmationRequestJournalX (you can do as you want)
2. set property this IsPurchConfirmationRequestJournal
- allow blank
- nullable
3. after you rename it, right click the report PurchPurchaseOrder and klik restore. (just klik ok if there is popup windows)
4. do refreshing again on dataset PurchPurchaseOrderLine
when doing system will create for you another parameter which is IsPurchConfirmationRequestJournal
and change this parameter property like above
- allow blank
- nullable
5. Klik the report rebuild and deploy
Thats it and Good luck
Wasalam
Subscribe to:
Posts (Atom)