Everything for SAP Hana / Basis /Technology / BO / BW

While deploying to Sharepoint (WSS 3.0 or MOSS) I have come across several situations where the templates don’t get installed correctly – and in some cases some files are missing or in the wrong directories. If the EP templates don't display under the custom tab – or you don't have a custom tab there is an excellent blog post here that will help. When you run create the sharepoint site you get an error “File not found” It seems to revolve around template definition files and if you make sure the files below are in place and do an iisreset the deployment should work ok. Reinstalling the EP and .NET connector may also do the same job as manually moving the files, but I have been more successful with the manual method! •C:\Program files\Common files\Microsoft shared\web server extensions\12\TEMPLATE\1033\AXSITEDEF •C:\Program files\Common files\Microsoft shared\web server extensions\12\TEMPLATE\1033\AXSITEDEF\DOCTEMP •C:\Program files\Common files\Microsoft shared\web server exten...

here is good trick that you can obtain fragmentation status of each table in any selected database SELECT c.name as TableName, b.name as IndexName, avg_fragmentation_in_percent as Fragmentation FROM sys.dm_db_index_physical_stats (DB_ID(), null, NULL, NULL, NULL) AS a JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id, sys.tables as c where c.object_id=a.object_id order by avg_fragmentation_in_percent; Results ; Fragmentation > 5 AND to do Sp_MSForEachTable @command1 = "PRINT 'ALTER INDEX ALL ON TABLE ? WITH Reorganize'", @command2= "ALTER INDEX ALL ON ? REORGANIZE" for every table on selected database in SQL Server 2005. Fragmentation > 30 Rebuild Index - ALTER INDEX REBUILD to do EXEC Sp_MSForEachTable @command1 = "PRINT 'ALTER INDEX ALL ON TABLE ? REBUILD' ", @command2="ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = 80, ONLINE = OFF,SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = OFF)" for every...

Document management system in Microsoft Dynamics AX is used to attach documents, notes or images against specific records. All the documents are stored in DocuValue table with their reference in DocuRef table. In order to enable document management system we have to perform some simple steps. Open Navigation Pane Go to Basic -> Setup -> Document Management Now you can see four options related to document management Document types Active document tables Parameters Document file extension Now go open active document tables Create a new entry (Ctrl + N) Add your table in the grid and check mark active tab Open AOT -> Data Dictionary -> Tables -> DocuRef table open setSmmTable and place an entry of your table over here void setSmmTable() { switch (this.RefTableId) { case tablenum(CustTable), tablenum(VendTable), tablenum(SalesTable), tablenum(ProjTable), tablenum(ContactPerson), tablenum(smmActivities), tablenum(SalesQuotationTable), tablenum(smmMailings), tablenum(smmBusRel...

*** HATA 2 AxWebPart.cab Deployment Failed while doing Dynamics AX 2009 Enterprise Portal Setup Here is the quick fix for the following error: ========================================================================================================================== Entering function FindSolutionInFarm Solution AxWebParts.cab exists in the server farm. Leaving function FindSolutionInFarm Removing solution AxWebParts.cab from farm Adding SharePoint solution AxWebParts.cab at farm level Setup could not deploy SharePoint solution AxWebParts.cab. Exception: Error: Cannot add the specified assembly to the global assembly cache: Microsoft.Dynamics.WebParts.dll. Leaving function AddWPPackage Setup could not deploy SharePoint solution AxWebParts.cab. Exception: Setup could not deploy SharePoint solution AxWebParts.cab. Exception: Error: Cannot add the specified assembly to the global assembly cache: Microsoft.Dynamics.WebParts.dll. Error: Cannot add the specified...