How big are your blobs?

Strange question, but many Agresso databases contain more blob data than they do financial data.

What is blob data? Generally speaking it refers to files that are stored in the database such as JPEG’s, PDF’s text files, Word docs etc, and these may be scanned invoices, bacs remittances, pay slips, log files, report results files and so on.
The two main blob tables are ACRPRINTBLOB and ADSFILEBLOB. The former holds the server logging and report results files, and the latter is for scanned invoices etc.

It isn’t uncommon to find databases that contain over 80% blob data. This isn’t an issue in itself, but it’s useful to keep a watch on things to ensure that images are not being scanned at very high quality which produces large files.

It also allows for future planning in regards to clearing down the ACRPRINTBLOB table or if you want to store the contents of ADSFILEBLOB outside the database in a Windows file share.

On SQL Server based systems it’s relatively easy to determine the size of these tables as you can just use the command SP_SPACEUSED in a SQL Server query window. Selecting the Agresso database and running the command on its own shows the size of the database itself.

sp_spaceused
 
 
 
 
 
 
 
 

 

 

Running the command followed by a table name shows the size of the table.

exec sp_spaceused acrprintblob
exec sp_spaceused adsfileblob


 
 
 
 
 
 
 
 

 

 

 


Agresso Milestone 4 Active Directory Authentication and SSO

There are four entities within Agresso Milestone 4 that require authentication when you connect to them.
  • Desktop Client
  • Web Client
  • Web Services
  • Agresso Management Console
The standard way to log into these is to use an Agresso username and password, but there is is also Single Sign On (SSO) which logs you straight in with no need to enter any credentials and finally Active Directory (AD) authentication which allows you to log in by using your Windows logon credentials.
It is possible to setup SSO or AD logon either via the Desktop Client (System Administration) or within the Agresso Management Console (AMC), both have the same screen.

Authentication methods are setup on a platform basis. So you could have SSO for Agresso Web users and AD logon or Agresso logon for the Agresso Desktop client.

Agresso Authentication gives the standard logon screen (also get this if no authenticators are selected)

Windows Password Authentication asks you for Windows logon details. Note that there is no longer a Client field, it has been changed to Domain. The username and password fields are now for your Windows Network (AD) username and password.

The last option of Windows Authentication gives you SSO where no logon details have to be entered.
For AD or SSO authentication to work you still need to create an ABW user, and to this user you need to link a Windows Logon in the format of DomainNameWindowsLogon, as well as providing the default company that you want them to log into. All of this is setup in the User master file.

A slight word of caution. If you plan on quickly testing this and setup a Windows Logon against your ABW account and then switch on Windows Password Authentication, you will be able to logon using your AD credentials, but everyone else on the system who is not mapped to their Windows account will be effectively locked out.
Although, it is possible to move over Agresso Authentication along with either of the other two options. This will allow you to still login using Agresso authentication if your ABW account is not linked to a Windows Domain User. This is useful for system users that sometimes may need to log on to the system as other users.
For SSO to the web there are a couple more things that need to be configured against the Web publication in the AMC which basically modifies IIS to allow Windows Authentication

SSO logon is particularly useful for organisations that may have large numbers of users that occasionally use Agresso such as Timesheet users as they have no requirement to remember their Agresso username or password.
AD authentication also has the above advantage but provides more security.
Please note that if you enable SSO for the Agresso web client and you are prompted for Windows username and password when you connect, check that on the Agresso Web server that Internet Explorer Enhanced Security Configuration is turned off. This is done in Server Manager. This setting is turned on by default on Windows Server.

 


Agresso Maintenance Mode

Agresso Maintenance Mode

If you have planned downtime for your Agresso system or just wish to inform users of an upcoming upgrade for example, it’s simply a case of going into the Agresso Management Console and enabling it.

 

For the Agresso Desktop Client, go into the Agresso Management Console on the server which is hosting the centrally configured client and navigate to the following screen.

Agresso Management Console

Enable maintenance mode and enter your desired message. Don’t forget to save your changes.
There are three settings in this screen for the ‘Shutdown Mode’. ‘None – Notification Only’ allows users to log on as normal but gives the following pop up message when they start the Agresso desktop client.

Agresso Notification

The further two settings deny access to the Agresso Desktop Client. Both are a variation of the same theme. The first one denies access for users using this particular central client but allows them access via other central clients should they exist. The bottom setting is the one that you would really use should you want to stop people logging in.

Agresso No Access

Once this is turned on the following is displayed when users start the Agresso Desktop Client.

Agresso System Unavailable

The settings for the Agresso Web Client are separate to the above. To enable this you will need to log onto the Agresso Web server and go to the following menu.

Agresso Web Client

The above settings will not disconnect any users that are already connected they only stop new connections. There are several more drastic ways of evicting connected users from the system such as rebooting the server, remove the share for the centrally configured client, restarting IIS etc.

How does your Agresso or critical SQL Server Disaster Recovery Plan stack up?

Can you afford to do nothing? If there is a disaster or unexpected event and you have Payroll or other business critical functions how quickly can your organisation resume these operations, hours, days, weeks? How do you quantify the cost of not investing in a backup and recovery solution? Doing nothing can seem like a good plan until something happens.
Disaster Recovery is a big concern for most organisations and it is not surprising that many organisations (large and small) have no DR plan in place or they may have one but it is not fit for purpose, it’s costly and it has not been updated to keep up with technological and organisational developments. On average companies reported 2.3 business outages per year and that is just one type of potential disaster. Severe weather is another, flooding has caused lots of problems for many UK businesses over the past 2 years with hardware being the most common single source of failure.
Think about the impact on productivity, how many employees will be effected, what is the average cost per hour of those employees, what will the impact on revenue be? Use a Downtime Cost Calculator to get an idea for your organisation, then think about is it really worth doing nothing.
At ERP Hosting we offer DR solutions for Agresso and other SQL Server based system. You do not have to be one of our Cloud Hosted customers to enjoy the peace of mind and benefits of one of our DR solutions. If you have a Business Critical SQL Server application or you have Agresso Business World (Unit 4) we can review your current plan, make recommendations for improvements and present you with DR options for a DR solution that is fit for purpose, cost effective and better than doing nothing.

Are you running Agresso Business World on Oracle?

If the licensing costs are rising after moving over to virtual environments, or the licensing costs are halting your plans to virtualise, or perhaps you simply don’t have the Oracle expertise to fully manage the system in-house. Then we can reduce your costs by hosting and fully managing your AGRESSO system in a SQL Server environment located in an ISO accredited data centre.
We carry out the data conversion between Oracle and SQL Server, along with all of the technical project management and installation that is required to seamlessly move your system to the cloud. This entire process can normally be carried out with little impact and with minimal or zero downtime during office hours.
There are no restrictions on the versions of Oracle or AGRESSO that you are using.