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

After installing the Dynamics AX client on my machine, having set it to connect to a development AOS, I needed to eventually connect the client to the testing AOS. During installation, I was prompted to enter the AOS name, however changing this later was not immediately clear. At first, I assumed this could be done in the AX client, however, after a little bit of digging, I found that changing the AOS connection must be performed via the “ Microsoft Dynamics AX Configuration Utility ” ( Start > Control Panel > Administrative Tools > Microsoft Dynamics AX Configuration ). If you are like me however, you may be curious to know exactly where these settings reside behind the scenes. Using the utility, you cannot change the “Original” configuration, but rather, are expected to create a new configuration which you can then apply and later edit as often as you desire. This serves the purpose well, and I cannot foresee a reason to ever need to modify the original c...

AX databases are by default created with the same collation as your SQL Server has. But time to time you might need the database to have different collation. Maybe you think you can just execute ALTER DATABASE statement to change database's collation but this won't help. It is necessary to take in account that also all character columns (char, varchar, nchar, nvarchar, text, ntext) have also collation that might be different from the database one. So, what do you have to do to change collation of the whole database including the columns? Let's assume we have a database that has Latin1_General_CS_AS collation. Having AX database with case sensitive collation is really bad idea so we want to change it to Latin1_General_CI_AS. First step we have to do is to script out current database. Open SQL Server Management Studio , connect to SQL Server Database Engine and expand Databases node in Object Explorer. Then right-click the required database and from the context ...

This blog explains that how to move sharepoint site from one domain to another domain. Scenerio: I am having two separate domains in Mumbai and Chennai called Mumbai as Mumbai.com and Chennai as Chennai.com. Both domains are running SharePoint server 2007 with different domain. I am planning to move Mumbai SharePoint server 2007 site to Chennai SharePoint server 2007. For this scenario, you can do the following steps to move SharePoint site from domain to another. NOTE: SharePoint version should be same, mean if you installed service pack on source machine (Mumbai SharePoint server) at the same, you should install service pack on destination server (Chennai SharePoint server) You can check the version of SharePoint, open SharePoint central administration->site setting, you can view the version. Steps to be following: Source SharePoint server (Mumbai SharePoint server): 1. Take back of the SharePoint site which you required to move using stsadm.exe command utility. Stsad...

CRM 4.0 Installing on Server 2008 ERROR: Service msftesql was not found on computer 'XYZ'. The specified service does not exist as an installed service. CAUSE: This error come from confilict between installing Microsoft Dynamics CRM 4.0 (Enterprise or Professional) with SQL 2008. The msftesql is the "Microsoft SQL Server Full Text Indexing Service" which has a different name under SQL Server 2008. SOLUTION: - Run > Regedit - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - Rename MSSQLFDLauncher Folder to msftesql - Reboot System - Administrative Tools > Services > SQL Full-text Filter Daemon Launcher (MSSQLSERVER) and Check START Status - Rename back msftesql Folder to MSSQLFDLauncher - Take Enjoy

Error message when you try to log on to a Windows Server 2003-based terminal server: "Windows cannot load the user's profile but has logged you on with the default profile for the system" Event ID 1505 Event Type: Error Date: date Time: time Event ID: 1505 Source: Userenv User: Example\Username Computer: ServerName Description: Windows cannot load the user's profile but has logged you on with the default profile for the system. DETAIL - Insufficient system resources exist to complete the requested service. Event ID 1508 Event Type: Error Date: date Time: time Event ID: 1508 Source: Userenv User: NT AUTHORITY\SYSTEM Computer: ServerName Description: Windows was unable to load the registry. This is often caused by insufficient memory or insufficient security rights. DETAIL - Insufficient system resources exist to complete the requested service. for C:\Documents and Settings\Username\ntuser.dat To resolve this problem, modify the registry to increase the PoolUsageMaxim...

Moss Server 2007 SharePoint Server 2010 Office client required to view and edit documents uploaded to document libraries (Download and open) Office Web Application enables Word, PowerPoint, Excel and Visio documents, using Silverlight or HTML with JavaScript (Depending on Browser Support) No Co-Authoring Capability Co-Authoring Capabilities available for Word, PowerPoint (with client software) and Excel (Available over the web) Lot of post backs Fewer post backs for default actions – more Ajax usage No inherent support of Ajax or Silverlight Fully supported Static themes. You just pick a theme and its applied across the site, no preview You can select a theme , customize it and preview before applying it on the site No bookmarking, tagging or rating capability Its all there Content Types scoped to site collections New concept of having a Content Type hub which can be shared across web applications Media files would have to...

In MOSS 2007 you’ll notice that users are able to upload pictures to there personal My Sites. These pictures also get propogated to the Contact Details web part as well as People Search Results. So it’s actually a common practice for many companies to standardize on employee photos and disable everyone from uploading their glamour shots. To do this, first go to your Active Directory Management Console and hopefully you have the Exchange AD Management Plugin installed also. You’ll know if you have it installed if you see all the tabs below: 1. Click on the Exchange Advanced Tab 2. Click Custom Attributes 3. Use one of those extensionAttribute values to store any kind of link to your picture. 4. OK out of AD. Now you want to go to your MOSS Central Admin and do the following: 5. Go to your Shared Services Provider 6. Under User Profiles and My Sites click on User profiles and properties 7. Click on View Profile Properties at the bottom of the page. 8. Edit the Picture Property 9. Select ...

Microsoft Dynamics CRM ınternet karşılıklı dağıtım yapılandırması aracını kullanmak için aşağıdaki adımları izleyin: 1. Microsoft Dynamics CRM ınternet karşılıklı dağıtım yapılandırması aracını edinin. Aşağıdaki dosya Microsoft Yükleme Merkezi'nden yüklenebilir: Bu resmi kapatBu resmi aç Download Download the CRM4IFDTool.zip package now. (http://download.microsoft.com/download/4/e/f/4ef5f568-7320-4861-a947-47baf0966537/crm40ifdtool.zip) Yayım Tarihi: 6 Şubat 2008 Microsoft Destek dosyalarını karşıdan yükleme hakkında daha fazla bilgi için, Microsoft Bilgi Bankası'ndaki makaleyi görüntülemek üzere aşağıdaki makale numarasını tıklatın: 119591 (http://support.microsoft.com/kb/119591/ ) Microsoft Destek Dosyaları Çevrimiçi Hizmetler'den Nasıl Alınır Microsoft bu dosyada virüs taraması yapmıştır. Microsoft, dosyanın kullanıma sunulduğu tarihteki en güncel virüs tarama yazılımını kullanmıştır. Dosya, üzerinde herhangi bir yetkisiz değişiklik yapıl...

The Error I've seen this error a couple of times now and the fix unfortunately hasn't been all that consistent. The event log item looks like: Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 7/18/2008 Time: 5:31:59 PM User: N/A Computer: [COMPUTERNAME] Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 7/18/2008 5:31:59 PM Event time (UTC): 7/19/2008 12:31:59 AM Event ID: 5e5f200f0a3042648734373e1a3e2fc6 Event sequence: 356 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/773312491/Root-1-128608981453287591 Trust level: WSS_Minimal Application Virtual Path: / Application Path: [PATH] Machine name: [COMPUTERNAME] Process information: Process ID: 5428 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of a...

Kernel Version (Update Rollup 4.0) Axapta version Kernel build Application build Comments Axapta 2.5 1270.3 377 Option Pack 2.5 Axapta 2.5 SP1 1270.15 377-20 Option Pack 2.5-1 Axapta 2.5 SP2 1270.31 377-57 Market Pack 2.5-2 Axapta 2.5 SP2 Kernel Hotfix 1 1270.31-3 377-57 Market Pack 2.5-2 Axapta 2.5 SP3 1270.37 377-79 Market Pack 2.5-3 Axapta 2.5 SP3 Kernel Hotfix 1 1270.37-1 377-79 Market Pack 2.5-3 Axapta 2.5 SP3 Kernel Hotfix 2 1270.3703 377-79 Market Pack 2.5-3 Axapta 2.5 SP4 1270.3800 377-109 4 Market Pack 2.5-4 Axapta 3.0 1951.8 514 OP023 Axapta 3.0 Kernel Hotfix 1 1951.801 514 OP023 Axapta 3.0 SP1 first version 1951.17 514-12 SP1 OP023-6 SP1 Axapta 3.0 SP1 1951.18 514-12 SP1 OP023-6 SP1 Axapta 3.0 SP2 1951.2410 514-90 SP2 OP023-19 Axapta 3.0 SP3 1951.3730 514-193 SP3 OP023-71 Axapta 3.0 SP3 Kernel Hotfix 1 1951.3733 514-193 SP3 OP023-71 Axapta 3.0 SP4 1951.4060 514-320 SP4 OP023-196 Axapta 3.0 SP5 1951.5160 514-513 SP5 OP023-379 Axapta 3.0 SP6 1951.7609 514-859 SP6 OP023-659 Ax...

Problem: Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) ------------------------------ Program Location: at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.Initialize(MaintenancePlanData planData) at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintView.LoadMaintenancePlan(String connectionString, IManagedConnection connection, String objectUrn) at Microsoft.DataTransformationServices.VsIntegration.DtsDesignerService.OpenDesigner(String connectionString, Object connection, String objectUrn) at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke() I had the same issue in around 3 production SQL 2005 servers which already had SP2. I tried reinstalling Management studio. Reinstalled Inegration services and both didnt work. So as a last resort I reinstalled SP2. Note as it was production I didnt r...

[Original Post] Starting from Service Pack 2, Windows SharePoint Services 3.0 and SharePoint Server 2007 support Windows Server 2008 R2 and Windows Server 2008 SP2. When you try to install SharePoint bits on Windows Server 2008 R2 directly, you may see the following dialogue: This is because Windows SharePoint Services 3.0 and SharePoint Server 2007 bits without SP2 slipstreamed are not supported on Windows Server 2008 R2. The KB article 962935 is not live on the web site yet. To install on Windows Server 2008 R2, for Windows SharePoint Services 3.0 you can download the slipstream builds here: Windows SharePoint Services 3.0 with SP2 (x86) http://www.microsoft.com/downloads/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&displaylang=en Windows SharePoint Services 3.0 with SP2 (x64) http://www.microsoft.com/downloads/details.aspx?familyid=9FB41E51-CB03-4B47-B89A-396786492CBA&displaylang=en For SharePoint Server 2007, you can follow Create an installation source that i...

About this Exam This certification exam measures ones understanding of the Microsoft Dynamics AX 2009 Installation and Configuration course. Audience Profile Candidates for this exam should have completed the Microsoft Dynamics AX 2009 Installation and Configuration course. Credit Toward Certification When you pass Exam MB6-820: AX 2009 Installation & Configuration, you complete the requirements for the following certification(s): [MB6-820]: [AX 2009 Installation & Configuration] •Microsoft Certified Business Management Solutions Specialist Exam MB6-820: AX 2009 Installation & Configuration: counts as credit toward the following certification(s): [MB6-820]: [AX 2009 Installation & Configuration] •Microsoft Certified Business Management Solutions Professional - Installation and Configuration for Microsoft Dynamics AX •Microsoft Certified Business Management Solutions Professional - Developer for Microsoft Dynamics AX Note This preparation guide is subject to change...

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...