Overview
 

1.            Summary / Overview / Purpose

Customer reports that a crane is not performing any moves, SM UI has moves but none are scheduled, and/or a crane is not showing any status' in SMUI. 

2.            Requirements

Baretail Logging experience and Intermediate SQL experience.

3.            Procedure / Body

Example: Customer is reporting that a crane is not moving and does not see any Crane Status in SM UI.

 

First go to the SM UI and locate the load handler screen for the crane or shuttle not performing any moves (check to see if there are actual moves that are queued)

Below we can see that there are moves for Crane04 but they are not scheduled and the crane is reportedly doing nothing:

 

 

Next go to the RemoteObjectServer log file and see if there is any addUpdateDeviceMove exceptions in the log file:

 

 

As we can see above that there is a nonstop feed of ‘addUpdateDeviceMove() failed’ logging.

 

Next, check to see if there is any exception noting a ‘duplicate device move’ similar to the example below:

“Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'AK_DeviceMove'. Cannot insert duplicate key in object 'dbo.DeviceMove'. The duplicate key value is (228, 1, 1, 0, <NULL>).”

 

Noting this exception and the device number, we can check the DB to see what moves are on this device using the SMDBA:

select * from devicemove where DeviceId = '228'

On this table, we will be able to see if there is a specific move that has not received a DeleteFlag:

 

If there is a deleteflag that is ‘null’ and the created date is near the time the crane has started not moving; we will need to update the deleteflag for this specific moveID.

 

Using this DB script:

 

update DeviceMove set DeleteFlag = getdate() where id = 3589226

 

‘id’ will be replaced with the 1st column of the specific move that has not received a deleteflag date.

 

Move ID located here in ‘DeviceMove’ table:

 

 

Once that DeleteFlag is successfully updated, monitor the specific crane for any movement. This will allow the crane to accept the next task. 

4.            Recovery or Back out procedure

  N/A

5.            Supporting external documentation

  N/A 

6.            Additional publication information

   N/A

 

DISCLAIMER:

Information in this document is subject to change without notice and does not represent a commitment on the part of Intelligrated. This information is typical of the questions and general advice given; however, your particular case and circumstances may produce different results or require different recommendations. Therefore, use of this information is not a suitable replacement for contacting Intelligrated Technical Service engineering for specific recommendations and solutions to your application.

 

No part of this article may be reproduced or transmitted in any form or by any means including recording, or information storage and retrieval systems, for any purpose without the express written permission of Intelligrated. All information contained within the article is private and confidential and the sole property of Intelligrated.

 

In no event, shall Intelligrated be liable for any damages whatsoever including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss, even if Intelligrated has been advised of the possibility of such damages. Because some states do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you.