Search Computer Help Please

Monday, July 9, 2018

Microsoft Dynamics GP 2010 - Error emailing statements MSVCR90.dll FIX

Error: When emailing statements from Microsoft Dynamics GP 2010 you will get an appcrash with faulting module MSVCR90.dll.

MSVCR90.dll relates to visual studio studio 2008 C++ but most likely this is not the cause of your issue but it may be worth trying to reinstall it if it appears to be missing.



Cause: Windows Updates

FIX: Recent windows updates (Office Service Packs) have now altered the way Microsoft Outlook works and the client now defaults to using outlook in online mode. This breaks the email functionality for some reason most likely because the ID of the .OST file changes each time (guess)

Super easy fix : Set outlook to Use Cached Exchange Mode


In Outlook left hand pane - > right click your email and goto data File properties and then the Advanced Tab - Make sure Use Cached Exchange Mode is ticked. hit OK close and restart outlook and retry your dynamics GP emails.

hope it helps, I was going banana's trying to figure it out :)

extra: If windows updates has broken your adobe printer also checkout my other post on this issue, you can find it from the search


Tuesday, October 10, 2017

Windows Task Scheduler - Error 0x1 and Running SQLCMD , BATCH or VBS Script


Error/Issue: One day you wake up the sun is out you feel great but low and behold your windows scheduled tasks are no longer working. You will either get

(0x1) - For the Last Run Time

or they will run for eternity and not actually do anything.

Have had this error on windows server 2012 but not 2008 so I'm not sure what the difference is , anyway onto the FIX.

The FIX:

You will have to alter the jobs slightly to make them run again under your scheduled tasks.

example SQLCMD and VBS Script

SQLCMD


Task: To Backup all SQL Databases and dump .bak files into directory on local server

Settings:

- Run whether user is logged on or not
- Run with highest privileges

Actions

- Start a program
- Program/Script: "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"  (or your location)
- Add arguments (optional):

-S SQLBOX\SQL2016 -d master -E -Q "EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = 'E:\BackupLocation', @BackupType = 'FULL'" -b

If your looking for the database backup procedure you can grab it at https://ola.hallengren.com



VBS Example

Task: To delete any files older than 60 days in a directory, handy for cleaning up old backups

Settings:

- Run whether user is logged on or not
- Run with highest privileges

Start a program
- Program/Script: C:\Windows\System32\cscript.exe
- Add arguments (optional): "E:\Folder\CleanOld Files.VBS"      (quotation marks needed as there are spaces)
- Start in (optional) : C:\Windows\System32\


that is it you are now up and running