FDMEE Locatin Lock Status Script
edited Sep 8, 2020 5:07AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered
Hi,
I am was trying to check for FDMEE Location Lock script where I see details from "TLOGPROCESS" table and from Column "INTLOCKSTATE. But I have tried with couple of combinations, nothing worked out.
There is no fdmContext Object type supported for "INTLOCKSTATE". Request you to let me know if i can achieve in a better and simpler way. Kindly share your thoughts.
Sample script used for Script validation.
=========================================================
sSQL = "SELECT PERIODKEY, INTLOCKSTATE FROM TLOGPROCESS"
rsProcDets = fdmAPI.executeQuery(sSQL, None)
while rsProcDets.next():
PerKey = rsProcDets.getString("PERIODKEY")
lstat = rsProcDets.getInt("INTLOCKSTATE")
file.write("Period: %s Process State: %s " % str(PerKey), lstat)
0