The SMS Board will not load for a specific user

Environment

  • Scheduling Type: Secondary, Elem w/MST, Flex


Cause

Invalid value in USO.VL1


Resolution

Reset the USO.VL1 value 


Aeries Web query, identify invalid records: 

LIST USO IF OP = "Master Schedule Board" AND ( VL1 : "UNDEFINED" OR VL1 : """" )


Aeries Web query, update invalid records:

CHANGE USO VL1 TO "" IF OP = "Master Schedule Board" AND ( VL1 : "UNDEFINED" OR VL1 : """" )


SQL query, identify invalid records:

SELECT * FROM USO
WHERE OP IN ('Master Schedule Board')
AND (VL1 like '%undefined%' OR VL1 = '""')


SQL query, update invalid records:

UPDATE USO 
SET VL1 = ''
WHERE OP IN ('Master Schedule Board') AND (VL1 like '%undefined%' OR VL1 = '""')