Command to check syntax of Data Partitions and Stored Queries

Document ID : KB000095718
Last Modified Date : 18/05/2018
Show Technical Document Details
Question:
I would like to perform a check of Data Partitions and Stored Queries that exist in my Service Desk Manager environment to ensure that no Cartesian errors exist. Is there a command I can use to perform this task?
Answer:

To ensure that your data partition constraint does not produce a Cartesian product join, enter the following command:

  • Windows

    bop_cmd -f $NX_ROOT\bopcfg\interp\bop_diag.frg "check_queries()"
  • UNIX

    bop_cmd -f $NX_ROOT/bopcfg/interp/bop_diag.frg "check_queries()"
Additional Information:
When a data partitions or stored query is created in Service Desk Manager a Cartesian check is performed at the point of saving. The command outlined in this document may be useful if data partitions or stored queries were loaded into the environment that by-passed the built in system check (perhaps with a pdm_load). Under normal circumstances this command would not typically be needed.

More information on data partitions is located here:

https://docops.ca.com/ca-service-management/14-1/en/administering/configure-ca-service-desk-manager/how-to-set-up-the-data-partition