Forum Discussion

Nathan's avatar
Nathan
Creator III
6 years ago

Cage Code 00000

Good day all.  Would having a Cage Code of all 0's cause a problem when a report is ran?  I receive errors for some of my parts reports that indicate that I do not have permissions to run the report ...
Reporting
christopher_gillis's avatar
christopher_gillis
Community Manager
6 years ago

Hi Nathan,

Could you clarify what you mean by "Cage Code"? Do you mean the ID of the item?

Chris

Christopher Gillis

Aras Labs Software Engineer

  • Nathan's avatar
    Nathan
    Creator III
    6 years ago

    Christopher,

    Good day.  CAGE stands for Commercial and Government Equipment.  It is one of the fields that we have in our Parts.  The previous care takers of our database created a Parts List ItemType where the document and all of the parts are attached to.  Then the Part pulls the Parts List to display, instead of using the Part and BOM feature built into the system.  I have a report that is supposed to act like the BOM reports, but a couple of them lock up the system and the one that does run, has errors until I can get to a low enough level to run it.  I have been trying to figure out why the report produces an error, but have not had much luck so far. 

    There are a lot of things that I have noticed wrong about this.  There are Parts Lists, Drawings, and Documents inside of Parts Lists.  I'm not sure what exactly is causing the problem.

    • christopher_gillis's avatar
      christopher_gillis
      Community Manager
      6 years ago

      Thank you for the additional info. :) 

      Since this is a customized data model, could you also provide some more specifics about the report to help us diagnose the issue? Is this a Report item inside of Innovator (TOC > Administration > Reports) or an external report in something like SQL Server Reporting Services? What query is this report running exactly?

      Could you also provide some more details on the data model with Parts List? I'm not sure I understand the added value of wrapping the Parts and Documents inside of the Parts List instead of relating the Documents directly to the Parts.

      Chris

      • Nathan's avatar
        Nathan
        Creator III
        6 years ago

        Here is the Report information.  I'm still learning the system, so I'm sure there is something that I am missing.

        Name:  s_BOM Quantity RollUp

        Type:  Item

        Location:  Client

        Target:  One Window

        Method:  N/A

        Label:  BOM Quantity RollUp

        Description:  Displays all parts of an assembly & subassemblies below it, including quantities of each of those parts for the entire structure

        Report Query:

        <Item type="s_Part" action="s_Indentured_Drawing_List" part_id="{@id}" sp_name="s_BOM_Quantity_RollUp"/>