I’m trying to build a .properties file to pass to the lcm_cli.bat that will promote all of the reports that are sourced from a specified universe. I’ve tried the following queries:
Select SI_NAME, SI_AUTHOR, SI_WEBI_DOC_PROPERTIES From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") And SI_KIND = 'WebI'And SI_INSTANCE = 0
and
Select SI_NAME, SI_AUTHOR, SI_WEBI_DOC_PROPERTIES From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") And DESCENDANTS("SI_NAME='Folder Hierarchy'", "SI_ID in (23)") And SI_KIND = 'WebI'And SI_INSTANCE = 0
Both of these options return errors
Failed to get dependencies of the job.(PRS 00048)
The property with ID SI_CUID does not exist in the object (FWM 02021)
GetRelatedDependenciesFailed
Both queries return the expected reports when run in Query Builder.
Searching for the error codes on the SAP Site hasn’t offered anything productive.
Any suggestions?