Common Macro Errors

Common Macro Errors

Summary:

This KB will show the most common Issues and solutions to Errors when running Macros in Visual

VBScript Standard Error

This is a standard VBscript error, review the Visual ERP Macros and see what the end user has written, or may have broken.  If this macro calls an SRI Macro, make sure that the macro exists in the VTGMacro table.


Issue 1: Red Exclamation Icon and blank box when running a Macro



Solution 1

Make Sure the Visual Mfg VSCRIPT.dll is registered

Open CMD prompt using Run as Administrator



Find the Vscript.dll on your machine this is the Visual Client Directory
In this example its in C:\Visual\localapps\VMFG10
Your location may be different





Now type in the cmd window  REGSVR32 "Path to Vscript.dll in Visual client directory"
Below is an example based on the location above



Close the Visual Window and reopen and test the macro the  ! Blank screen should be gone


Solution 2

If the error persists, make sure the Visual Client Directory Has Modify Permissions for users



Issue 2: The Remote Name Could not be Resolved

Problem: Active Object Error when running a Macro


Solution 1

Check to make sure the Remote Name\ Macro Server name is correct within the Macro
In this scenario we had a typo in the Macro Stub 



Issue 3: Active X Component Can't create Object

When running a Macro you get an error about Active X



Solution 1 

Verify you have the correct version of the Macro Server Client Installed for your Environment.
On the Web server hosting SRIMacroServer you can verify the Client Install msi
below is an example of the Installation Path of Macro Server  (Drive letter may be different)

Warning
Older Macro Server Clients are not Forward Compatible

.Net 462
MacroServer Version 10 and later



.Net 2.0 Client
MacroServer V9 and earlier



Step 1:
Verify the Client Install exists as COM in the registry

Open a CMD Window and run the below query
      reg query HKLM\SOFTWARE\Classes /s /f VTG.Loader.dll

Note: A single version (v1.1.5000.0) is installed


Note: Latest Version Below




Step 2:
Run the Macro Script

Note: You must EDIT with the proper Server Name
  1. dim lib, scriptName, serverName
  2. '_______****User Entry Required****________
  3. 'Define Script and Server
  4. scriptName = "FAKE_TEST"
  5. serverName = "localhost"
  6. '_____________________________________
  7. set lib = createobject( "VTG.Loader.Managed" )
  8. msgbox lib
  9. lib.ServerUrl = "http://" & serverName & "/SRIMacroServer"
  10. dim util
  11. msgbox "Activate"
  12. lib.ActivateObject "util","VTG.Macro.Net.dll","VTG.Macro.Net.Lib"
  13. msgbox "Activated"
  14. set util = lib.GetObject ( "util" )

  16. msgbox util.ToString()
  17. util.ServerURL = lib.ServerURL
  18. executeglobal util.Script(scriptName)
  19. msgbox util.ServerInfo

  21. util.sql = "SELECT COUNT(1) FROM dbo.PART_SITE_VIEW"
  22. msgbox "Part Count: " & util.executescalar

Issue 4: The maximum message size quota for incoming messages (####) has been exceeded.

This error occurs when data between the client and Macro Server exceeds the default maximum size (64 Kb).


Solution 1

In the macro stub, before the Macro Server macro is executed, the maximum size must be increased. 
The setting of the util.MaxReceivedMessageSize must happen directly after setting util.ServerURL and before any other statement that causes a request to the server.
This is because setting util.ServerURL resets MaxReceivedMessageSize to the default (65536) and the first statement that sends a request to the server will set the parameter on the connection. 
The connection's parameter cannot be changed once the connection is established!




  1. util.MaxReceivedMessageSize = CDbl(util.MaxReceivedMessageSize)*2

It's recommended to increase in minimal steps (by 1) to find the least needed size increase as to not overload the server.

Alert
You must close / re-open the Visual window you're running the macro from for the change to take effect.

Issue 5: The download of the specified resource has failed.

This error occurs when the server certificate has expired or is invalid.
Preview

Solution 1

If the Macro Server is using a self-signed certificate, the certificate will need to be installed on each client machine in the "Trusted Root Certificate Authorities" store.
  1. Run MMC.exe as administrator.
  2. Go to File-> Add/Remove Snap-in...
  3. Under Available Snap-Ins select "Certificates, then "Add>"
  4. Select "Computer Account" and click on "Next".
  5. Select "Local Computer" and click on "Finish"
  6. Click on "OK" to close the Add or Remove Snap-ins dialog.
  7. Drill down to Certificates->Trusted Root Certificate Authorities->Certificates.
  8. Right-click on Certificates and select All Tasks->Import...
  9. Local Machine should be selected. Click Next. 

  10. Browse to the certificate file (.pfx, etc.), select it, and click on Next on the Import Wizard.

  11. Enter the Certificate password and click on Next.
  12. Place the certificate in the "Trusted Root Certificate Authorities" store and click Next.
  13. Confirm and click Finish.
  14. It will be listed under "Intended Purpose" as "Server Authentication".
  15. Exit the Console, optionally saving the settings.

    • Related Articles

    • Macro Server - Release Notes

      v1100.1001 2025.05.11 (Beta Release) - Add support for editing Visual ERP Macros - VTG.Loader.dll is now using Framework 4.8 - Update supporting nuget packages to latest release. - VTGMACMT.exe has been renamed to MacroEditor.exe v1100.1000 ...

    • WM-Synergy Macro Editor

      WM-Synergy Macro Editor This is rich client user interface, which allows for the maintenance of Synergy Created Macros that support the Infor Visual ERP Manufacturing, (VE), Visual Basic Scripts (VBScript) typically used in a VE Macro situation. Each ...

    • Macro Server - Info

      What Is Macro Server Central Management of Macros Macros are stored in the database Deployed as a Web Service under IIS Visual Access Controls are Applied to Macros Provides Extensions to VBScript Environment SQL Queries Common VBScript Function ...

    • Running Macro - Windows Security Errors

      Be sure when testing on a Server environment that the Internet Explorer Enhanced Security Configuration is set to off for both Administrators and Users. This shoudl include Terminal Server Environments as well. Security should be set to off for users ...

    • MacroServer - Field / Form Level Security

      Create a macro that will prevent users from changing specific field level Part Master Data Create OnSaveMacro under Part Maintenance Login to Macro editor on macroserver Create Macro Script with Logic Configure Permnissions Under Visual Program ...