Sunday, November 26, 2017

How to Convert vdi to vmdk In Windows

How to convert vdi to vmdk in Windows

VDI The virtual disk image file used in VirtualBox systems. and VMDK an open format and is one of the disk formats used in the Open Virtualization Format for virtual appliances


Step 1
In virtual box shutdown first if the system already running. 

Open command prompt run as Administrator
Type CD\ [enter]

Type CD "Program Files\Oracle\VirtualBox" [enter]

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)


Step 2

READ MORE - How to Convert vdi to vmdk In Windows

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 :
  1. Open management studio
  2. Right click the database  > Properties
  3. Pics  
  4. Click files and change the logical the with the correct one, for me is 'MSDBAX' replace with 'MSTestAX'
  5. Pics
  6. Click ok
  7. Now you can run the script for truncate the log file, like sample below
USE [MSTestAX]
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.

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.

  • 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
READ MORE - Restore database dynamic ax 2012 and deploy to new environtments.

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


READ MORE - HTTP Error 503: Service unavailable when testing Realtime Service on Dynamic AX 2012 R3

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.

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

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

  1. allow blank
  2. nullable
become true
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

  1. allow blank
  2. nullable

5. Klik the report rebuild and deploy

Thats it and Good luck

Wasalam
READ MORE - Error when refresh PurchPurchaseOrder datasource on Dynamic AX 2012 - Dwipa Rachmawan Cool :P