All posts by Glenn Belyea

MAPI error when trying to send Word or Excel Document

Tips & Tricks

If you are seeing a MAPI error when using the send to e-mail recipient dialog within Word or Excel, this should fix the issue.

Resolution

To resolve this issue, follow these steps:

  1. Start Windows Explorer.
  2. Close out of Outlook, make sure there are no Outlook.exe processes hanging.
  3. Locate and then open the following folder on your computer:
    C:\Program Files\Common Files\System\Msmapi\1033  Note:  if there is not a Msmapi folder here, then look in:

    C:\Program Files (x86)\Common Files\System\Msmapi\1033

  4. Right-click the MSMapi32.dll file, and then click Rename.Note The file (Msmapi32.dll) that you are renaming differs from the file (Mapi32.dll) that is mentioned in the error message.
  5. Type Msmapi32.old, and then press ENTER to rename the file.

Restart Outlook, it will re-install the MSMapi32.dll file for you and hopefully fix the issue.

Although this is a fix for Outlook 2003, it seems to work for issues related to Outlook 2010 as well. Here is the link where I found the fix: https://support.microsoft.com/en-us/help/926196/error-message-when-you-try-to-start-outlook-2003-mapi32-dll-is-corrupt

 

FAS Printer Error

FAS

Running the most current version of FAS, when trying to print a report the errors below show up and FAS becomes unresponsive.

There is a SAGE support document on how to fix this:

The section highlighted in Yellow below (Option 3) seems to be the proper fix.

Error: “Invalid Printer Specified” when installed to the local system.

Error: “Invalid Printer Specified” when installed to the local system.
  • When clicking Print Asset Detail, nothing happens
  • Unable to print Asset Detail
  • Unable to run reports.
  • Error message: Invalid Printer Specified
  • Error message: Error occurred while generating report – please contact your system administrator. Details: Error executing the report _________
  • Error 1904.Module C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\commonobjmodel.dll failed to register.
  • HRESULT – 2147023898, Contact your support personnel.
  • Error Occurred while generating report – Please contact your System Administrator.
  • Cannot Log in
  • Memory Full
  • Unable to change Preferences
  • Unable to save Preferences
  • This field name is not known. Details: Errorkind Error in File 1DeprExpenseUT {7FFF4659-42C1-9CED-678869C0305F}.rpt Error in formula rrShowCurrency: ‘If onFirstRecord = True Then’
  • Error in formula rrShowCurrency
  • If onFirstRecord = True Then
  • Error:”SBDdesktop.exe has stopped working” running reports in 2015.1
  • Attempted to read or write protected memory
  • Program closes when running reports
  • Error: “Invalid printer specified. ()AssetBasisUT (7DE95277-4BB6-4B80-9B99-D881506800FE).rpt”
  • PCL 6 Printer Driver
  • PCL6 Printer Driver
Cause

On the update installation of Sage Fixed Asset single user products, or Premier or Network Client to a local workstation, the product specific configuration .XML file seems to be find invalid or out of date printer information.

Resolution

Option 1: Select the Correct printer:

  1. Click File, Print Setup, select an alternate printer, click OK.
  2. Click File, Print Setup, select original printer, click Ok.
  3. Run report to see if the error is resolved. If not resolved follow procedures for Option 2 , Option 3 and Option 4 below.

Option 2: Reset default printer in Devices and Printers:

  1. Exit Sage Fixed Assets.
  2. Click Start, Devices and Printers.
  3. Right click on an alternate printer and click Set as default printer.
  4. Right click on original printer and click Set as default printer.
  5. Close Devices and Printer window.
  6. Log into Sage Fixed Assets.
  7. Click File, Print Setup, select an alternate printer, click OK.
  8. Click File, Print Setup, select original printer, click Ok.
  9. Run report to see if the error is resolved. If not resolved follow procedures for Option 3 and Option 4 below.

Option 3: Delete the product specific configuration .XML file – FASSTEP.XML, FASACCT.XML or ASSTACCT.XML file:

NOTE: If the error is occuring on the Network or Premier versions this option would need to be applied on the machine where the Depreciation client is installed.

  1. Close Sage Fixed Assets Depreciation
  2. In Windows Explorer: Go to C:\Program Files (x86)\SageFAS or Sage Fixed Assets\Lite Depreciation or Depreciation or Depreciation Network or Premier Depreciation\
  3. Right click the, FASSTEP.XML (Lite Depreciation), FASACCT.XML (Depreciation or Depreciation Network) or the ASSTACCT.XML (Premier Depreciation), select Delete, click Yes.
  4. Ensure that the default printer in Start, Control Panel, Devices and Printers is set to a printer that has a PCL5 print driver.
  5. Open the Sage Fixed Assets, and run a report.

Option 4:

If the error persists:

  1. Uninstall any and all Sage Fixed Assets clients on the machine where the error has occured. This can include:
    • All Sage Fixed Assets Clients (Depreciation, Tracking, Planning)
    • All FAS clients (Asset Accounting, Inventory, CIP)
    • Crystal Reports XI Release 2 for Sage
    • SAP Crystal Reports 2011 for Sage
  2. Go to C:\Program Files (x86)\
    • Delete or Rename the SAP BusinessObjects folderNote: If there are other version of Crystal installed on the system, they should be uninstalled also prior to changing the Business Objects folder and then install the other Crystal products. Crystal must be install from oldest to newest version to prevent Crystal conflict.
  3. Install Sage Fixed Assets Depreciation (and all other needed clients), repeat steps in Option 1.

Adding a new Vendor in Yardi

Yardi Tips,

It seems that there is an added step when creating new Vendors. In the past, the Prop (property) List was auto populated by Yardi. It would take your property and add it to the list so you could see the new Vendor once you created it.

This is no longer the case. I am outlining the “Basic” Vendor creation steps. You will need to fill in more than I am, I just want you to see how to add your property to the Prop List.

After saving the minimum amount of data to create a Vendor, you will get the “Data” pulldown at the top of the screen. Where you can choose the “Prop List”.

 You will see the “Data” Pulldown once you save the Vendor. If you leave this page before adding your Property to the Prop List, you will need to call Samantha or someone at the Corporate Office to add the Property to the Prop List for you.
Click the “Data” Pulldown and you will see the “Prop List” notice that it doesn’t have any numbers next to it, that means there are no Properties assigned to the Vendor. Click the “Prop List” link to add Properties.
Now you will see a listing of the currently assigned Properties, notice that it’s empty. Click on the “List Props” Button to select your property.
Select your property and click OK.
You should see your Property in the list, Click Save.
Now that you’ve added your property to the list, you should see Prop List (1). Your Vendor is now ready to use.

Updating Attributes via command line

Admin Scripts

http://www.howtogeek.com/205910/how-to-change-file-attributes-with-attrib-from-the-windows-command-prompt/

.

What Attributes Can You Use?

Now that you have your elevated command prompt window open, you will need to know what types of attributes you can edit using the “attrib” tool. There are two main types of attributes, “basic” and “extended.”

Basic Attribute Switches (R, H, A, S)

  1. R – This command will assign the “Read-Only” attribute to your selected files or folders.
  2. H – This command will assign the “Hidden” attribute to your selected files or folders.
  3. A – This command will prepare your selected files or folders for “Archiving.”
  4. S – This command will change your selected files or folders by assigning the “System” attribute.

“Attrib” Syntax

You will need to know the proper syntax to use for the “attrib” tool before you get started.

ATTRIB [+ attribute | - attribute] [pathname] [/S [/D]]

In this syntax, you will need to know what the different switches and parameters represent.

  1. The + and – indicate whether you will activate or deactivate the attribute specified.
  2. The attributes you can use are those explained above.
  3. The “/S” signifies that you want to search the entire path specified including subfolders for a particular file.
  4. The “/D” signifies that you want to include any process folders as well.
  5. The pathname indicates the location of your target folder or file. The proper syntax for path files is shown below.
Drive and/or filename - C:\*.* OR C:\Users\Owner\Desktop\samplefile.txt

If you decide not to specify any of the attributes listed above, the files or folders will revert to their current attribute settings.

Fast Deletion of files and folders in Windows

Admin Scripts

Deleting with Windows Explorer is rubbish because it wastes lots of time enumerating the files. I usually move the stuff I need to delete to C:\stufftodelete and have a deletestuff.bat batch file to rmdir /s/q C:\stufftodelete. This is scheduled to run at night, but sometimes I need to run it during the day so the quicker the better.

Here’s the results of a quick time test of a small 5.85 MB sample of 960 files in 303 folders. I ran method 1 followed by method 2, then reset the test directories.

Method 1 removes the files and directory structure in one pass:

rmdir /s/q foldername

Method 2 has a first pass to delete files and outputs to nul to avoid the overhead of writing to screen for every singe file. A second pass then cleans up the remaining directory structure:

del /f/s/q foldername > nul
rmdir /s/q foldername
  • Method 1: 17.5s, 14.9s, 13.9s, 14.8s, 13.8s: average 14.98 seconds
  • Method 2: 14.3s, 12.1s, 11.7s, 14.2s, 11.8s: average 12.82 seconds

Here’s results of another test using 404 MB of 19,521 files in 3,243 folders:

  • Method 1: 2 minutes 20 seconds
  • Method 2: 2 minutes 33 seconds

So there’s not much in it, probably too close to judge on a single test.

Edit: I’ve retested with much more data, this is a typical case for me: 28.3 GB of 1,159,211 files in 146,918 folders:

  • Method 1: 2h 15m, 2h 34m: average: 2 hours 25 minutes
  • Method 2: 49m, 57m: average: 53 minutes