Troubleshooting iDMS

Review the following to assist with troubleshooting iDMS.

Known behaviors

The following are known behaviors for iDMS. Contact ASI Support for any additional questions or assistance.

  • Password protected files - Spreadsheets protected by a password are not currently supported by iDMS.
  • Unintentional shopping cart deletion - If a contact in iMIS has items in their shopping cart and you delete any data from that contact record, the shopping cart will also be deleted. This occurs regardless of what you delete — such as an activity or even a single row from a custom panel source.

Troubleshooting

Do the following to troubleshoot:

Changes Not Recorded to Change History

iDMS uses the iMIS REST API to change data in iMIS. So, any fields that are showing in the Change History on the iMIS Staff Site will also log any changes made by iDMS.

See Logging changes to panel data.

Note: The iMIS Username seen in the User field in the Change History will be the iMIS username that is set as the Background Account for the Cloud ID.

Due to how the iMIS REST API operates, you are unable to customize the User that is shown in the Change History.

Validation Failure

Validation failure happens when data in the uploaded file (or IQA) does not have a matching counterpart in iMIS. iDMS will then not attempt to import the incorrect data and instead throw a validation failure. This is corrected by finding the data in the file that is causing this. It may be a typo or a code that is incorrect.

For example, the Last Name field in iMIS has a max of 50 characters. The validation can be skipped, but in this case the import would be successful but the last name in iMIS would be truncated to the first 50 characters.

Data Overflow

Trying to insert data into a field that is too long. Make sure you are meeting the requirements of the field in iMIS that you are importing into. 

Timeout or Long Run Time

A timeout can occur either when the connection with iMIS is lost or if the Job exceeds a time limit. One explanation for iUpdate Jobs taking longer than expected is if the IQA query being used does not have Only display unique results enabled.

Internal Server Error

When you receive the error that is highlighted below (InternalServerError), this indicates that it means that iDMS has received an error from the iMIS instance REST API call that is coming back with no information. To find out what is happening here, create a ticket with ASI to get them to read their Event Log on their server and try to pull that information.

Request Entity Too Large

The Dashboard Data Router has a limitation of 28.6MB. Therefore, to solve this issue either remove the blob data or its column from the IQA, or make sure all data included is under 28.6MB.