During the initial investigation it was observed that There were lot of Locks in the database as first action the AX support team tried to free locked sessions by seeing the blocking SPIDS and killing them to see if the problem goes off, further the team did AOS servers restart but the problem continued. On detailed analysis it was found there were lots of Page waits on the Inventory and sales related transactions. The individual waits were not that bad but there were lots of them, they seem to be on inventtrans regularly.
Half the indexes were missing on the inventtrans on Sql Server database also there was no clustered index and the table was a heap leading to trashed performance.
It Appeared that the Indexes on the Invent Trans table which was huge table of over 20 GB size have got accidently deleted along with few other tables while doing maintenance which was causing huge paging issues and freezing in the AX 2009 database. It appeared possibly Indexing process stopped abruptly while Index reorganisation job was executing .Further on investigating the cause of failure of the backup job it appeared that the trashed indexes on the database had an impact on the overall table sizes, increasing the database size and increasing the backup size tremendously leading this is a disc full during backup error.
Once the team had identified the issue as resolution we had to run AX 2009 Synchronization from Application side as to ensure the Indexes at application level matches with Indexes at Database level. For that we had to get AX2009 system offline. It took couple of hours to recreate all indexes as part of running synchronization to build all Indexes. On Inventtrans it took longest time. As all the Indexes have synchronised post running the AX Application Synchronization, after doing basic testing the AX2009 system was issued back to users under monitoring till the time users reported that all the operations are fine. It was also decided to revisit the backup strategy as client were left with only one Backup and the clean up script deletes the backup which is x hrs old since it is purely date/time based.
From Next blog I will continue my journey of our AX 2009 rollout in Eastern Europe. Signing off for now
With the advancement of Azure cloud infrastructure, there arise many heterogeneous requirements which are of type of system(s) having combination of on-cloud and on-premise components. Specially from the on-premise database point of view for certain scenario, this blog series is intended to explain the options, steps, concerns and benefits of different approaches.
For complete blog, please refer to this.
Microsoft provides Business Productivity framework and tools related to it for enterprises. Let's see in this blog what does it provides and what offering are available from Microsoft in this field.
The BPIO model sits on top of this Core IO model and leverages optimal utilization of basic IT infrastructure.
(Courtesy: Microsoft Corporation)
Figure 2: BPIO
A organization as it progresses and grows in IT infrastructure, moves from Basic towards Dynamic organization. Important part of BPIO at the application level is Collaboration. Effective collaboration between employees within an organization and within teams is important. For that, Microsoft has offering for functionalities like, Workspaces, Portals, Social Computing and Project Management.
One important product that provides it all is: SharePoint Server. Specifically with the coming of SharePoint Server 2010, Social Computing incollaboration stack has increased.
BPOS (Business Productivity Online Services suite)
After the success of BPIO model and Microsoft came with BPOS (Business Productivity Online Services suite). This is a set of collaboration and messaging suite provided by Microsoft as subscription and SaaS. It includes Microsoft SharePoint Online, Exchange Online, Office Comunication Online and Live Meeting online. This offering has got discontinued now.
As more and more organizations are adopting Cloud based services, Microsoft along with its cloud offering Azure, introduced, cloud productivity service microsoft Office 365. In Office 365, Microsoft provides, Office Professional Plus, Exchange Online, SharePoint Online, Lync Online and Office Web Apps.
Figure 3: Microsoft Collaboration Business Productivity Tools / Applications
By including IT and Collaboration in their Enterprise model and growing from one level to another level of Collaboration optimization, today's organizations can reduce overhead costs and improve their Business Productivity.
Hi All,as promised in my previous blog where I shared challenges in getting fiscal printer integrated with Ax2009 SP1 I will continue to share another challenge which we faced during our First Ax2009 rollout in Eastern Europe This was related to statutory Invoicing & reporting .Once we had come out of the hurdles of Fiscal Printer integration, immediate challenge was related to the Statutory Invoicing on Fiscal Printer and VAT registers reporting.
Statutory Invoicing for Fiscal Printer in Eastern Europe requires separation of positive and negative lines of the Invoice. Only positive Lines should go to fiscal printer for Printing Zero Value or negative value lines should not be printed on the Invoices generated from fiscal printer. The AX 2009 System does not support this by default . It required Customisation to handle this scenario by adding flag.
For VAT register reporting we primarily faced two major problems:
a) Not able to view VAT reporting Menu and the reports under General Ledger: - This Issue was due to the non-enabling of the configuration key while doing GLS merge
b) Cannot view any data in statutory Input VAT report or Output VAT report: - This issue was due to errors in VAT setup Configuration as the VAT setup differs for EU region which governs the generation statutory VAT registers.
Tracing this, there was a field in this form TaxTable(TaxTable).TaxType_W, had different values.
We changed from "Other"to "Standard VAT"
This worked and finally we were able to view all reports.
In my next Blog I will continue the journey of our Eastern Europe AX 2009 roll out experience further with a new challenge we faced and how we resolved. Signing off for now. Keep looking out for this space till then.