Occasionally if we have one of the eBS environments down for cloning, and a CSR is in progress, if I add objects to the CSR and then save, I'll get a message that not all the objects could be saved (because Stat can't communicate with the environment that's offline). Is there a report or other manner for me to find out all the unlocked objects in Stat production? I don't want to have to check each of my open CSRs - one by one - to determine if I now need to lock the objects associated with that environment that was offline but is now back up.
This .jrxml file will produce a report in 5.6.0, 5.6.1 or 5.6.2. only. It will be added to the next release’s inventory
Place the file in <stat_home>/report/objects/format on the Stat Central Agent. (you do not need to stop/start the agent)
Run the appropriate script for your Stat rdbms. Commit the insert.
Oracle
insert into STAT_REPORT_DEFN values ('dw_rpt_tbl_unlock_obj','Objects Unlocked for Open CSRs','List of unlocked Objects on CSRs','Objects','Excel',50,'M',1,1,1,1,1,1,1,1,0,0,1,0,0,0,0,0,1,1,1,1,1,0,'5.6.0',0,0,1,1,0,SYSDATE,'SYSTEM','Y','Y','Y','Y','N')
MSS
insert into STAT.STAT_REPORT_DEFN values ('dw_rpt_tbl_unlock_obj','Objects Unlocked for Open CSRs','List of unlocked Objects on CSRs','Objects','Excel',50,'M',1,1,1,1,1,1,1,1,0,0,1,0,0,0,0,0,1,1,1,1,1,0,'5.6.0',0,0,1,1,0,getdate(),'SYSTEM','Y','Y','Y','Y','N')
This solution can be apply to Stat 5.6.0 or higher.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center