Axapta 2012 - Restoring Databases

hellosayeed · November 7, 2012, 6:03am

Hello All,

I have successfully installed axapta application object server and when i open client shows the initialization checklist. Can i skip the checklist execution and simply restore the demo database in sql server and start AOS ?. If i restore the demo database then will it effect the model database.

Any ideas appreciated.

Thanks,

Sayeed

janisce · November 7, 2012, 7:45am

AX 2012 database contains both - data and application, and it’s all stored in one single DB - there are no 2 databases. So if you will restore the DB, then application will be restored as well.

In AX2012 R2 version data and code will be in separate databases !!

Harish · November 7, 2012, 9:53am

Hi Syed,

It would be better if you complete your initialization check list first and then load demo database. But of course you can restore the demo database and then complete it as well.

BTW as per documentation it appears that using latest version of DMF, it should be possible to copy / restore database between two installations. Obviously this will be helpful to you only if you have demo database already loaded in an instance. Nevertheless hope this info is of use.

janisce · November 7, 2012, 6:43pm

Why would you set up the companies, the configurations etc, etc in that checklist and then in the end just wipe that all with a demo data…? It is useless waste of time. The only things which are important to do after restoring the DB is X++ and CIL compilation…

Harish · November 8, 2012, 1:10pm

Hi Janis,

Completing the initialization check list does not mean the configuration (such as legal entities, system parameters etc) should be setup.

Only those steps which says ‘Required’ is mandatory.

hellosayeed · November 9, 2012, 3:32pm

Thanks for the clarity guys.

I have installed AX 2012 R2 (means two databases i.e. data and model ) and i have only demo database backup. If i restore only demo database and leave the model as it was after AOS installation then will Axapta works with demo data. I want to avoid initialization checklist after AOS installation. Please help me on this.

hellosayeed · November 10, 2012, 8:07am

I have tested in the following manner and it works.

Installed AOS server with two databases ( Axapta Db and Model DB)
Restored the Demo Database on the installed database
Restarted the AOS server and everything works fine.

It shows all the companies available in Demo Database.

Thanks Harish and Janis for your valuable answers.

tFabrio · November 10, 2012, 1:48pm

Hello Janis, Haris, I would like to know if I need to compile the X++ and CIL after I insert/update the license information. I noticed that AX prompted to run the data base synchronization and threw few warnings and error message about four tables that start with projxxxx (I assume that are related to projects).

"Synchronize database Specified field Qty of datasource ProjJournalTrans does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view ProjJournalTransHourUnpostedView can not be created in the database.
Synchronize database Specified field Qty of datasource ProjJournalTrans does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view ProjJournalTransFeeUnpostedView can not be created in the database."
Synchronize database Specified field StatementPLHourCost of datasource ProjParameters_1 does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view ProjTransBudgetCube can not be created in the database.
Synchronize database Specified field StatementConsumpHourCost of datasource ProjParameters_1 does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view ProjTransPostingCube can not be created in the database.

Thank you

janisce · November 10, 2012, 7:48pm

Hi Patrick,

those few ProjXXXXXXX Views and Tables are usual suspects in almost every AX 2012 synchronization attempt, even in a freshly installed and uncustomised system. Don’t even pay much attention to this (just Press “Continue”).

Janis.

tFabrio · November 14, 2012, 4:30pm

Hello Janis, after installing the Data migration frame work beta 2 and I ran the compilation, database synch and CIL; I saw these error as below. I am wondering if you have come across such errors and what the remedy would be. Will this pose any issue? Thank you again for your feedback.

Finished pass 1 at 11/14/2012 7:59:07 AM

Error when loading the method. Type: CustomerTransaction_CustSettlementLine, Method: new

Error when loading the method. Type: CustomerTransaction_CustSettlement, Method: new

Error when loading the method. Type: CustomerTransaction_CustTransOpenLine, Method: new

Error when loading the method. Type: CustomerTransaction_CustTransOpen, Method: new

Error when loading the method. Type: CustomerTransaction_CustTrans, Method: new

Error when loading the method. Type: CustomerTransaction, Method: new

The CIL generator found errors and could not save the new assembly.

Harish · November 14, 2012, 4:43pm

Hi Patrick,

CustomerTransaction class is extended from AifDocument. Please can you try following -

Ccompile-foward from AifDocument.
Likewise compile-forward from ‘AfStronglyTypedDataContainer’ for other classes.

tFabrio · November 14, 2012, 9:45pm

Thanks a lot Harish. Could you please tell me how could I compile forward from AifDcoument (from AOT)

tFabrio · November 14, 2012, 9:52pm

Thanks Harish. I found it AOT/Class/AifDocument. after compiling I have got this message "The #CustomerTransaction macro does not exist.

Harish · November 15, 2012, 3:50pm

Hi Patrick,

The missing macro is the root cause for CIL error.

Either the DMF not installed correctly or during installation of DMF something must have got over-written. Please can you get a developer to check.

tFabrio · November 21, 2012, 3:05pm

Hello harish, we looked at the ‘CustomerTransaction_CustTrans’ class and 'new method is showing a syntax error as below

6837.cust-transans.png

I tried to find it under Macro, but couldn’t be able to locate. What could we do to restore this? Could we un-install the DMF and try?

one thing to note - Interesting I was looking at an another AX instance (it is probably not the featurepack version) that I couldn’t find the CustomerTransaction class.

cgalindo · January 6, 2013, 2:32pm

Hello, I have the same error with those clases/macros after DMF installation. Any progress to solve?

matt1980 · January 22, 2013, 3:35pm

Same to here… i think this is the bug from R2 itself. These classes is not come from DMF beta2 installation if not mistaken.

Some one can advice?

ksurjadi · February 21, 2013, 8:59pm

The issue is caused by the update from DMF in fpk layer againts macro DataContainerTypes.

Go to AOT and open DataContainerTypes and merge the code from sys and fpk layer.

The macro content should look like the following (or you can just replace the macro with the code blow):

#AxdPurchReqImportDCT

#AxdCatImpDCT

#AxdcatvcDCT

#MiscDataContainerTypes

#MetadataServiceDataContainerTypes

#AifDimensionDataContainerTypes

#AifTableNaturalKeyDataContainerTypes

#SyncServiceDataContainerTypes

#AxdCustomerDCT

#AxdASNDCT

#AxdAddressDCT

#AxdAssetConditionDCT

#AxdAssetGroupDCT

#AxdAssetLocationDCT

#AxdAssetMajorTypeDCT

#AxdBillsofMaterialsDCT

#AxdCashDiscDCT

#AxdChartOfAccountsDCT

#AxdConfigTableDCT

#AxdContactPersonsDCT

#AxdCountingJournalDCT

#AxdCustPaymJournalDCT

#AxdDeliveryModesDCT

#AxdDimensionsDCT

#AxdExchangeRatesDCT

#AxdFixedAssetDCT

#AxdFreeTextInvoiceDCT

#AxdHRMAbsenceReqDCT

#AxdHcmJobApplicationDCT

#AxdHcmJobPostingDCT

#AxdInventColorDCT

#AxdInventDimCombinationDCT

#AxdInventItemGroupDCT

#AxdInventLocationDCT

#AxdInventoryOnHandDCT

#AxdInventoryTransactionsDCT

#AxdInventSizeDCT

#AxdItemDCT

#AxdEMSSimulatedFlowDCT

#AxdPaymentTermsDCT

#AxdPriceDiscountJournalDCT

#AxdPriceListDCT

#AxdProdPickingListDCT

#AxdProfitLossJournalDCT

#AxdPurchaseInvoiceDCT

#AxdPurchaseRequisitionDCT

#AxdRouteCardDCT

#AxdSalesInvoiceDCT

#AxdSalesOrderDCT

#AxdSalesPackingSlipDCT

#AxdSysImportBusSectorsDCT

#AxdSysImportContactPersonsDCT

#AxdSysImportLeadsDCT

#AxdTransferJournalDCT

#AxdTrvPBSDetailDCT

#AxdTrvPBSMaindataDCT

#AxdUnitDCT

#AxdUnitConversionDCT

#AxdLedgerGeneralJournalDCT

#AxdVendGroupDCT

#AxdVendTableDCT

#AxdVendorPaymentDCT

#AxdPickingListDCT

#AxdProjectHourJournalDCT

#AxdServiceAgreementDCT

#AxdReturnOrderInDCT

#AxdReturnOrderOutDCT

#AxdSalesInvoice_EinvoiceDCT

#AxdProjInvoiceDCT

#AxdExpenseDCT

#AxdServiceOrderDCT

#AxdSalesConfirmationDCT

#AxdCustomerQuotationDCT

#AxdAttendanceOutDCT

#AxdAttendanceInDCT

#AxdRFQSendDCT

#AxdRFQReplyDCT

#AxdVendInvoiceDCT

#AxdTransferOrderCreateDCT

#AxdTransferOrderPostingDCT

#AxdEcoResCategoryDocDCT

#AxdEcoResProductMasterDimValueDCT

#AxdEcoResProductDCT

#AxdSalesQuotationDCT

#AxdCustPaymentsDCT

#AxdVendPaymentsDCT

#AxdCustomerTransactionDCT

#AxdAdvancedLedgerEntryDCT

#AxdBankStmtISODCT

#AxdsmmBusRelDCT

#AxdsmmLeadsDCT

#AxdBudgetTransactionDCT

#AxdContactPersonsDCT

#AxdLedgerExchangeRateTypeDCT

#AxdLedgerExchangeRateDCT

#AxdLedgerCurrencyDCT

#AxdInventItemLocationDCT

#AxdTransferOrderDCT

#AxdEMSMeterReadingFlowDCT

#AxdEMSSubstanceFlowDCT

#AxdLogisticsAddressZipCodeSetupDCT

#AxdDOCommerceShpDCT

#AxdDOCommerceSalesTableDCT

#AxdLineDiscountDCT

#AxdDOCommerceDimensionDCT

#AxdDOCommerceDimensionGroupDCT

#AxdDOCommerceDlvModeDCT

#AxdSalesMultilineDiscountDCT

#AxdDOCommerceMarketplaceDCT

#AxdDOCommerceOnlineStoreDCT

#AxdSalesTotalDiscountDCT

#AxdEUSLReportingDCT

#AxdDOCommerceItemGroupDCT

#AxdTaxItemGroupsDCT

#AxdTaxGroupsDCT

#AxdTaxCodesDCT

#AxdCustCreditCardDCT

#AxdInventItemBarcodeDCT

#AxdPurchRFQSitesDCT

#AxdDlvDlvTermDCT

#AxdDlvDlvModeDCT

#AxdMarkupMarkupTableDCT

#AxdPurchRFQPaymTermsDCT

#AxdPurchRFQUnitDCT

#AxdDOCommerceQtyOnHandDCT

#AxdCaseWebDetailDCT

#AxdCaseCategoryDetailDCT

#AxdsmmLeadPrioritiesDCT

#AxdVendVendRequestSignupDCT

#AxdEcoResCategoryDocumentDCT

#AxdDOCommercePriceDiscDCT

#AxdDMFExeStatusDCT

#AxdDMFProcessGrpDCT#AxdBankStmtDCT

#AxdBankStmtDCT

//

#AxdIntrastatReportDCT

//

#AxdBudgetPlanDCT

//

#AxdTaxImportLinesForAIF_CNDCT

#AxdTaxExportLinesForAIF_CNDCT

//

#AxdRoutesDCT

#AxdPayrollEarningsImportDCT

#AxdCustECollectionLetterDCT

#AxdRetailCatAttribDCT

#AxdHcmWorkerImportDCT

#AxdBudgetPlanOfficeAddinDCT

cgalindo · February 28, 2013, 11:34pm

Thanks Kristanto,

Could you please give some guide to to the merge from sys and fpk layer for DataContainerType.

ksurjadi · February 28, 2013, 11:49pm

Hi Carlos,

As I mentioned in my post, you can copy the code I posted to replace the content DataContainerType macro.