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.
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.
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.
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
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.
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
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
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
Monday, August 18, 2014
Windows Server 2012 Release Candidate domain controllers have a default for the security setting named "Allow cryptography algorithms compatible with Windows NT 4.0" that prevents weaker cryptography algorithms when establishing security channel sessions.
Problem Syntax :
Windows Server 2012 Release Candidate domain controllers have a default for the
security setting named "Allow cryptography algorithms compatible with Windows NT 4.0"
that prevents weaker cryptography algorithms when establishing security channel
sessions.
Solution is :
1. Just log-off off your windows account.
2. Then Log-in with an Administrator account
3. Try again the proses
4. does it (this solution work with my situation),
what about yours ...!, please comment.
Monday, March 10, 2014
Concenate the expresion in SSRS reports in Dynamics AX 2012
by the example : ssrs expression in the textbox
first way..
create texbox and enter this expression
="Mars Odyssey was launched in "& First(Fields!AsOfDate.Value) &" to hunt for past or present water on the red planet."
second way..
create texbox and enter this expression only
=First(Fields!AsOfDate.Value,"TCN_RencanaFillingDP")
after that insert the text before the expression
Mars Odyssey was launched in
and then insert the other text after the expression
to hunt for past or present water on the red planet.
like this pictures below

i am prefer the second way.
:Dpr
Monday, October 28, 2013
CIL Error and Solution in Dynamic AX 2012
- If that syntax you have, and you already fix it the object in AOT, but the error still same you must doFull Compile AOT (this is too much consuming time :( )
CIL generation: The given key was not present in the dictionary.
- Increment CIL (this is less consuming time :D )
- Full Compile AOT (this is too much consuming time :( )
- with this step number one, you will find an error, and then you can fix it the error, and try increment CIL again
- but if the error still raise you can find the log file in C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL and it is called Dynamics.Ax.Application.dll (do compiling object in the log file, and try to fix the error on it. and start CIL Increment again. source link is : http://axfaq.blogspot.ro/2012/07/log-files-ax-2012-different-log-files.html
- Just export the object that maybe contain the error, my favorite is class, export with option layer on it. Open the xpo with some text editor, and find the object in AOT and compile it, and fix it when the error raise it, and do increment CIL again.
Thursday, September 05, 2013
Refresh from after calling method
To refresh a parent form, you can often use a task to refresh the form. You should use a task when the form has a single root data source. For example, the CustTableListPage, SalesTable, VendTable, and HcmWorker forms all have a single root data source. When you use a task to refresh the form, you cause a call to the research method for all data source tables associated with the form.
To update the form root data source
In the AOT, expand Forms, find the dialog or drop dialog form that you want to work with. Expand the form node.
Right-click the Methods node, click Override method, and then click closeOK. The method opens in the code editor.
Use the FormRun class together with the #taskF5 refresh task to refresh any form that opens this dialog or drop dialog form.
The following code example shows how to get a reference to the calling form and how to refresh that form. Notice how the formRun instance is populated with a reference to the calling form. Also notice how #taskF5 is used to force a refresh of the specified form.
X++
public void closeOk()
{
#Task
FormRun formRun;
super();
// Get an instance of the calling form.
formRun = element.args().caller();
// If the caller is a form, refresh that form.
if(formRun)
{
formRun.task(#taskF5);
}
}
In the code editor, press the compile button. When compiling is finished, close the code editor.
Right-click the form and then click Save.
To refresh the parent form, open the form you use to call the dialog or drop dialog form where you added the previous code. Select a record, open the dialog form, and make a change to a field that appears on the parent form. Click OK to close the dialog form. The parent form is refreshed and shows the value that you updated in the dialog form.
Refreshing a Form with Multiple Root Data Sources
The form that opens your dialog or drop dialog form might have multiple root data sources. For example, the smmActivities form has two root data sources. If you have more than one root data source, you should refresh the data source that includes fields that were updated by using the dialog or drop dialog form.
To find and update a specified root data source
In the AOT, find the dialog or drop dialog form that you want to work with. Expand the form node.
Right-click Methods, click Override method, and then click closeOK. The method opens in the code editor.
Use the FormRun class to get a reference to the calling form. You then have to iterate the list of root data sources to find the data source table that include the fields you updated in the dialog or drop dialog form. You must know the name of the root data source table.
The following code example shows how to get a reference to the calling form, how to iterate a list of root data sources, and how to use the research method to refresh a specified data source. Notice how the tableNum function specifies the root data source table you want to refresh. Caution
In the example, the target root data source table is named Table1. You would have to change this parameter to the name of the root data source table that contains the fields updated by the dialog or drop dialog form.
X++
public void closeOk()
{
FormRun formRun;
List dsList;
ListEnumerator dsListEnumerator;
FormDataSource formDS;
super();
// Get an instance of the calling form.
formRun = element.args().caller();
// If the caller is a form, find and refresh the specified root data source.
if(formRun)
{
dsList = formRun.rootFormDataSources();
if(dsList && dsList.elements() > 0)
{
dsListEnumerator = dsList.getEnumerator();
while(dsListEnumerator.moveNext())
{
formDS = dsListEnumerator.current();
if(formDS.table() == tableNum(Table1))
{
formDS.research(true);
break;
}
}
}
}
}
In the code editor, press the compile button. When compiling is finished, close the code editor.
Right-click the form and then click Save.
To refresh the parent form, open the form you use to call the dialog or drop dialog form where you added the previous code. Select a record, open the dialog form, and make a change to a field that appears on the parent form. Click OK to close the dialog form. The parent form is refreshed and shows the value that you updated in the dialog form.
sumber : http://msdn.microsoft.com/en-us/library/hh812104.aspx
Tuesday, August 27, 2013
Interfacing Dynamic AX With Eksternal Database Via ODBC with Batch Processing
Why why why.. what is happening in here.. when i execute the code via jobs, the code runs very well and succesfully insert and update the eksternal database.. but when i create runbase batch class and calling the code the syntax error will raise : Unable to log on to the database. [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified Object 'OdbcConnection' could not be created.
At Last i finally did it..
For my situation the problem is :
Succes running with jobs because refers to the fact that you connect to the database through the user logged to the current session. When you run a Job from the AX client, this is executed with the user that runs the current AX client (the one logged to the active session);
Failed to running :
When code is executed from server in a batch job, code is executed through the user that runs the AOS windows service.
So the solutions is.. Eng Ing Eng....
CREATE ODBC WITH AOS ACCOUNT, yes IT Works Trust Me..
if there is question just email me, okay...
Thursday, May 23, 2013
Upload Financial Dimension Value For Dynamic AX 2012
Example : You have financial dimension : Department and you want to insert or add financial dimension value into it.
here goes the scripts :
static void TCN_DPRcreateDimensionValue(Args _args)
{
DimensionValueService service;
DimensionValueContract dimensionValueContract;
TCN_FinancialDimensionValueTemp dimTemp;
service = new DimensionValueService();
dimensionValueContract = new DimensionValueContract();
try
{
while select dimTemp order by FinancialDimension
{
dimensionValueContract.parmDescription(dimTemp.FinancialDimensionDescription); //financial dimension value description
dimensionValueContract.parmValue(dimTemp.FinancialDimensionValue); //financial dimension value;
dimensionValueContract.parmDimensionAttribute(dimTemp.FinancialDimension); //financial dimension
service.createDimensionValue(dimensionValueContract);
}
}
catch
{
ttsAbort;
}
info("Hore Sukses");
}
Good Luck
Please suit for your needs :D
Dwipa
Thursday, May 16, 2013
SRSS Reporting Format Report Date In Visual Studio 2010 with Dynamic AX 2012
="Page "&Globals!PageNumber &" of "&Globals!TotalPages
2. Print current date with prefix like Jakarta, 1 April 2013
="Jakarta, " & day(Globals!ExecutionTime) & " " & monthname(month(Globals!ExecutionTime)) & " " & year(Globals!ExecutionTime)
3.Print date with passing parameter from dataset dynamic ax 2012 //ex. param is InvoiceDate
="Jakarta, " & day(Fields!InvoiceDate.Value) & " " & monthname(month(Fields!InvoiceDate.Value)) & " " & year(Fields!InvoiceDate.Value)
4. Print date without timestamp
=Format(Fields!Start_Date.Value,"dd/MM/yyyy")
5. Print number
=RowNumber(nothing)
6. Print or counting amount of records on table or matrix
=CountRows("Tablix1")
7. Print only one records in row
=IIF(Rownumber("Tablix1") >1,"","Solar Beban LMM")
Monday, October 15, 2012
ScreenCam running Microsoft Dynamic AX without domain
1. Dynamic Ax 2009 on win 7 (http://www.youtube.com/watch?v=A_8idKbXO1U&feature=share&list=ULA_8idKbXO1U)
2. Dynamic Ax 4 on win 7 (http://www.youtube.com/watch?v=Z5xgq66TDSk&feature=share&list=ULZ5xgq66TDSk)
3. Dynamic Ax 2009 on win 8 release preview (soon)
Sunday, October 14, 2012
Install Dynamic Ax without domain
List of Dynamic Ax without join domain in my laptop
1. Dynamic Ax 4 or Axapta 4 on windows (XP, Seven[7], Eight[8] version release preview )
2. Dynamic Ax 2009 or Axapta 5 on windows (XP, Seven, Eight[8] version release preview)
on the next post, i will show you all how to do that.
have a nice day...
Dwipa Rachmawan
Sunday, April 29, 2012
Belajar Install Zend Framework
Yang perlu bro and sis lakukan adalah :
1. Download Xampp di ane pake yang versi 1.7.4
2. Kemudian install xampp (next - next - finish :) ) biasanya kalo install begitu... gampang kan.Setelah install akan membuat foder C:\xampp
2. Download Zend Framework ane pake yang versi Zend Framework 1.11.11 Full
3. Setelah download frameworknya, lakukan extract (kala ane ke folder C:\xampp\ZendFramework-1.11.11)
4. klik Windows, Start -> Run, and then use cmd), ketik zf lalu enter apabila muncul pesan error " 'zf' is not recognized as an interanl or external commnad, operable program or batch file."
lakukan pengeditan pada environment variable (biasanya sih letaknya di klik kanan my computer -> property -> advanced system setting -> klik environment variabel. pada system variabel path nya ditambahkan C:\xampp\mysql\bin;C:\xampp\php;C:\xampp\ZendFramework-1.11.11\bin
5. Sekarang waktunya mencoba framework dengan cara : klik windows, start -> run -> cmd
ketik "zf create project myproject" dengan cara ini, akan membuat folder di
C:\Users\Dwipa\myproject (contoh di komputer ane nih gan, pakai windows 7) dan didalam folder ini juga terdapat folder-folder yang lain semisal : application, docs, library, dll.
6. Membuat virtual host dengan cara, Lakukan pengeditan pada file C:\xampp\apache\conf\httpd.conf
tambahkan syntax spt gbr dibawah ini :
- #framework zend by dpr
Listen 8181
paste ke C:\Users\Dwipa\myproject\library
8. Ketikan http://localhost:8181/ di browser (firefox, opera, etc), jika semua berjalan lancar, akan muncul zend welcome page. seperti gambar dibawah ini
9. Demikianlah penjelasan yang singkat ini, selamat mencoba. sumber dari Internet
Monday, February 13, 2012
Cara memfilter data format datetime dengan parameter date
static void dpr_datetime(Args _args)
{
HRMPartyEmployeeRelationship hrmPartyEmployeeRelationship;
Date dateFilter;
int row;
;
dateFilter = 07/11/2011 //use backslash
while select hrmPartyEmployeeRelationship where
hrmPartyEmployeeRelationship.ValidFromDateTime >= datetobeginUtcDateTime(dateFilter,DateTimeUtil::getUserPreferredTimeZone())
&& hrmPartyEmployeeRelationship.ValidFromDateTime <= datetobeginUtcDateTime(dateFilter,DateTimeUtil::getUserPreferredTimeZone())
{
row++;
info(strfmt('%1 %2 %3 %4 %5', row, dateFilter, hrmPartyEmployeeRelationship.EmplId, hrmPartyEmployeeRelationship.ValidFromDateTime,
hrmPartyEmployeeRelationship.ValidToDateTime));
}
}
Wednesday, February 08, 2012
Testing BlogJet
I have installed an interesting application - BlogJet. It's a cool Windows client for my blog tool (as well as for other tools). Get your copy here: http://blogjet.com
"Computers are incredibly fast, accurate and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination." -- Albert Einstein
Wednesday, December 08, 2010
Tahun Baru Islam 1 Muharram 1431H
Yups, kemaren hari selasa, 7 Desember 2010 bertepatan dengan tahun baru Islam 1431H.
Ditahun yang baru ini temanku daru membelikan sepeda Polygon Premier 3.0 dengan harga Rp. 2.545.000 (dua juta lima ratus empat puluh lima ribu rupiah) dengan cara pembayaran kredit 0 %. oh alangkah senangnya aku. thanks bro.. mudah2an dengan sepeda ini badan gw menjadi sehat wal'afiat, dan bisa mengurangi syukur2 panci (buncit) di perut gw hilang.. wakakak.








