Sage Error: A Managed Exception was Caught in caddattachementview::buildattachment

When you’re debugging a codebase, it can be difficult to find and fix errors. This is especially true when you’re working with a codebase that’s been modified over time. When add attachment view build attachment is invoked, it creates an attachment in the given directory using the given file name. In this blog post, we will discuss how to debug errors in a codebase that’s been modified over time. We will also cover some tips for improving your workflow so that you can catch and fix errors more easily

Sage software remains to rule the ‘charts’ when it comes to offering some of the most well-sought Accounts and Finance related issues. The various features of the software are well-suited for both small-scale and large-scale businesses. Hence, it is because of its ease of use that Sage has been highly recommended across the globe. One can easily take charge of their everyday accounting requirements like Invoicing, Cashflow Management, Inventory Management, VAT returns, and others.

The best part about the Sage software is that this is a perfect ‘go-to’ solution even for people without any Accounting background. Thus, now you can easily access the software and ensure that all your ‘book-keeping’ needs are catered to.

Error in Sage

Occurrence of Error and its subsequent handling is a relatively easy task. One has to be well-equipped with a few basics and all the solutions are well-sorted accordingly. The Error: “a managed exception was caught in caddattachementview::buildattachment is one such issue. Let us take a look at some of the prime reasons and their solutions

Reason for Sage Error: “A Managed Exception was caught in caddattachementview::buildattachment

The main reason for the Error: “a managed exception was caught in caddattachementview::buildattachment  is usually the damaged files in the Company directory.

Now, let us go ahead and check out the top Solutions:

Read Also : How to Resolve Sage 50 General.dat Error

Step to Fix Sage Error: “A Managed Exception was Caught in caddattachementview::buildattachment

Here we are providing some solutions to fix this issue:

Solution 1: To do so you will Need to

• Go to the specific company location 
• Check out for the file types DDF within the deirectory
• Now, rename the following:
  • Userpref.dat to OldUserpref.dat
  • Attchmnt.dat to OldAttchmnt.dat
  • Atmntbdl.dat to OldAtmntbdl.dat
  • Audittr.dat to OldAudittr.dat
  • Go aheaad and delete all the files with .DDF extension 
  • Similarly delete all the files with .LCK file type or extension
  • Delete the files with .PTL file type or extension
• Bear in mind that the attachment feature within the file is in use, in this case the renaming of the Attchmnt.dat and Atmntbdl.dat will cause the break in the links of the attached files. 
• Now, click on Windows Key + R
• Enter in Services.msc
• Click on OK
• Go to Pervasive PSQL Workgroup Engine/ Actian PSQL Workgroup Engine and right click on it.
• Click on Restart
• Close the Services
• Now, open up Sage 50
• Check if you can open the Windows once again without the error. In case the error persists, go ahead to the next step
• Once again start from steps 1-3
• Now, delete the following files:
  • File type MKD
  • File type DATtemp
  • File with name company_[Number].db
  • Be sure not to delete the file type company.db
• Now, check once again if you can open the Windows 
• You should be done by now

How to Delete Expandable DAT Files from the Clear Data Folder

If you need to know on how to delete the expandable DAT files, you need to follow the below steps:

• Go to the Clean data folder 
• Now delete the following files within

• Now open the New company Folder
• Hit on Yes for all the prompts you receive to create the empty files
• Check for errors. Probably you will not receive any.

Important Tip

Before you try to implement the above solution, it is recommended that you always create the required backup of all your important files. It is also to be noted that on implementing the above solutions, there can be a subsequent loss of non-critical data in the program. These includes existing attachments, Track-it issues, and also alerts.

How to Locate Company Directories

In order to be able to determine the location of the companies in the hard drives, you need to first be able to determine if the right version of your company has been found. Also ensure that no changes to the company has been made until the proper version has been determined.

Solution 1: Directory within an Open Company

• Go to maintain
• Go to Company information
• Locate Directory line 
• It is in the directory line that the location of the open company is found

Solution 2: Remote Data Access Company

• For remote data acess company
• Go to the System on the left-side
• Go to the section with company maintaninence
• It is here that the company directory is located.

Solution 3: From the Open Existing Company Option

• Go to the Files
• Click open company
• Go to the main sage window where no companies are open
• Click on open an exsiting company note
• This will display all the opened companies history 
• The location of every company will be given in the directory column

Solution 4: Using the Windows Search

• Locate your data path 
• Here you will find that every valid Sage company directory will be of the COMPANY.DAT file type

For windows 10

• Click open the File Explorer
• Click the Search field
• Click to select all the folders and the files
• Type enter COMPANY.DAT
• Ensure that the View is set to detail. 
• Every search result with location can be found in the Folder column.

Also Read : How to Fix PERMISS.DAT Error in Sage 50

Conclusion

So, there you have it people. These are the prime solutions when you encounter the Error: “a managed exception was caught in caddattachementview::buildattachment. However, there are a few more steps that you need to deal with before you implement the solutions. These includes locating the company directories and also creating the much required backup of all the important files and folders to ensure no loss of data occurs.

Frequently Asked Questions (FAQs)