Posts

Favorite Filters for Admin Users in ServiceNow

When first logging into ServiceNow as an admin, it can be a bit overwhelming.

To narrow this down, you can “favorite” a few key filters to focus in on what’s important.

 

Simply go to the All Applications Tab and STAR a filter that works best for you as shown below:

My favorite filters are My Groups Work – Active and Closed, which show all tickets assigned to my group that are either Active and or Closed:

When you have your filters selected, go to your favorites tab and click a filter to see what results it narrows down:

This is one of the most useful features ServiceNow offers. Enjoy!

Resolving “Cannot run this program while GL 190 is running” error when trying to release journal entries in GL40.1

You may run into this error at some point in GL40.1:

Fortunately, there’s an easy fix to this. First login to Lawson portal and search GLMONITOR:

In GLMONITOR, type “GL190” and select Inquire. If you get results and notice the run time, the process is in fact still running and causing the issue with GL40:

Go to job scheduler by opening LID and typing in jobschd >> F7 + A to select all users >> Then W to go to waiting screen.

Look for any GL190 jobs running and verify the User Name is the same one in GLMONITOR when inquiring on GL190 program. Check the error and if its safe to recover, recover it and let the job complete.

Go back to GLMonitor and inquire on GL190 to verify the job is no longer running:

Go to GL40.1 and release your Journal Entries. This should solve the error. Good luck!

Modifying VMWare to use Microsoft Remote Desktop Protocol so you can Transfer Files Easier

First, you’ll need to connect to your installed VMWare Client:

Now before connecting to the virtual server, right click the connection and select Microsoft Remote Desktop:

Once this is selected, you’ll be able to connect to the host Virtual machine and use VMWare as if it was Microsoft Native Remote Desktop Protocol.

One of the biggest advantages of this is being able to copy and paste files to and from the VMWare client using CTRL + C and CTRL + V.

The other Protocol settings can be used as well.

VMWare Blast is optimized for mobile cloud and consumes less CPU in case you’re trying to save battery life.

PCoIP may be better optimized for use when a poor internet connection but results will likely be equal to the other options.

How to add or edit Smart Notification related Info to an existing Smart Note in LBI

First lets login into LBI and open smart notifications:

Once open, go to Notifications Tab:

Select edit on the notification you want to modify:

Go to the Related Info >> Links >> Enter a Name and Web Address >> Add >> Save Updates:

To edit an existing related info link, simply select edit under “My Custom Urls”:

Make sure you Save Updates!

These related Info Links show up at the bottom of the report the user receives as shown below:

And that’s it! Hope this helps you the next time you need to edit Smart Notifications in the future.

Lawson Jobinteg Command Issues

The Lawson Jobinteg command is powerful for clearing up orphaned jobs that may be causing users issues. This is usually in the form of a job that can’t be deleted or is corrupted and likely caused from patches and or upgrades to the form or job.

Disclaimer: For v10, a patch may also be needed to fully resolve some jobs when running the jobinteg command.  The patch is available for LSF 10.0.6 and 10.0.7 only, as of 8/2015 and may have changed since then.

jobinteg -v

Brings back all bad records and NTIDs tied to them.  This is useful if you need to create a report to analyze which potential jobs are corrupted/bad or get approval to delete them.

jobinteg -t

Brings back summarized report of all bad jobs.

jobinteg -d

Wipes all orphaned/corrupt jobs listed in the summary or full report.  This usually resoles most jobs that receive errors upon inquiry or running them.

Hope this was helpful!

The Powerful Info button in ServiceNow Tickets

In ServiceNow there are a ton of buttons when you first start using it and it can be overwhelming and easy to ignore them at first.

When a ticket finally makes it to you, it might be in a hierarchy of other ticket types (requests, changes, tasks, incidents).  For my example it’s under the “Request Item” field.

The Request Item in our case is another ticket type in the hierarchy and usually has more detailed of what the task is to complete this ticket.  A useful button that you may overlook is the “I’ button which is essentially an Info button with tons of helpful information.

This button shows a plethora of information that may be relevant in resolving the ticket or task and essentially allows you to view more specifics about the ticket without just searching for it elsewhere in ServiceNow.

All these Info buttons could be useful, some give detailed user information while others give location info.  It saves a bunch of time. Hope this was helpful!

Adding or Replacing Existing SSL CERTS Lawson (WINDOWS)

This is a PFX cert.

Start – This is being done on a Lawson LSF server.

  1. Drag the folder with the Cert onto the server you want to apply it to.
    1. Once you do that, make sure you check whether or not the server is running IIS. Typically by searching for IIS Manager or checking services.
  2. Double click the cert file that you dragged onto the server.
  3. Select Local machine:
  4. Specify the file you want to import (should default on the cert you just clicked to run) >> Next
  5. Enter the password for the cert and click next.
  6. Open command prompt as admin and type: start certlm.msc
  7. Under Personal >> Certificates, you should see the new cert you imported: The old one is below the one highlighted in red.
  8. Now go to IIS Manager, Sites >> select WebsiteName and then on right pane select bindings as shown below
  9. Select https binding and edit
  10. Select new cert and click ok
  11. Back in command prompt type: iisreset /restart
  12. Test and you’re done

When applying to Landmark server, we need to run the following commands below (Important to stop and start exactly as shown):

For Mingle in ISS Manager, we need to select the Sharepoint secure site and select bindings.

How to Secure a User’s Lawson Report Writer Access

Common Problem: User XXXXXX does not have update authority for folder XXXXX

This is an error you may run into when a user doesn’t have report writer permissions to add to a folder.

To resolve this, follow the example below:

 

This will take you to RW03.1 (you can also go directly to RW03.1 if you know the user class name)

 

Once you have the user class selected, set FC to A, add your users ID, set flags and press change. If list is full, press Page Down key.

UPDATED: Submitting ACA (Affordable Care Act) to IRS

There is an easier method with additional options to Submit ACA to the IRS. We’ve posted articles in 2016 before, but here’s the latest walk through.

 

UPDATED: Submitting ACA (Affordable Care Act) to IRS.

Once you have done all your Infor work to create your files for submitting to IRS, the steps below will help you get your file submitted successfully. The final files are generated when you run the BN299.

Download the schema package from the IRS website: Schema Package – IRS

Follow instructions on validating the files generated from Infor. See attached KB from Infor View Attachment

Example of file names:

1094C_Request_XXXXX_YYYYMMDDXXXXXXXXXXZ.xml

1094C_Request_XXXXX_YYYYMMDDXXXXXXXXXXZ-Manifest.xml

An XML Reader Application is needed to validate the files. Altova XMLSpy application is a good program to use for this. Follow the steps in the above KB article to validate the files.

Once you make the changes that are noted in the XML Validator you will need to update the Checksum value in the Manifest.xml

Checksum verifies the integrity of the file. Windows has a pre-installed utility called CertUtil. HashAlgorithm choices: MD2 MD4 MD5 SHA1 SHA256 SHA384 SHA512. For our example, we are using SHA256 since our file generated with that from BN299.

From the command prompt:

  1. Browse to the location where your files
  2. Type CertUtil –hashfile <path to XML filename> <HashAlgorithm>
  3. Press Enter
  4. Example:

The generated hash value should be placed in the ChecksumAugmentationNum tag in the Manifest.xml (remove spaces)

You also will need to make sure the AttachmentByteSizeNum is correct. This can change when you make changes to the file.

See attached KB from Infor for details. View Attachment

  1. Locate the Forms XML File.
  2. Right click on the file, select Properties
  3. Locate the Manifest XML File.
  4. Right click and open using Wordpad
  5. Find <p4:AttachmentByteSizeNum> entry
  6. Replace the existing byte size entry with the byte size found in the Forms XML File properties.
    In this example: Change Manifest Size: 4522 to match Forms XML File size: 4598
  7. Save update

And we’re done!

Modify column data type without dropping table

“String or binary data would be truncated.”

This is a common error if you’re trying to update a field with more data than it allows, e.g. trying to update a char(30) field with a 50 character string.

 

If you try to modify the column data type you’ll get a new error:

“The changes you made require the following tables to be dropped and re-created”. This might be an inconvenience for you.

Easy fix:  Go to Tools >> Options >> Select Designer and Uncheck >> “Prevent saving changes that require table re-creation”

 

And you’re DONE!  Modify the data type and run your update query.