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 ...
Forum Discussion
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
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.
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
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"/>
Hi Nathan,
Thanks again for the additional info. For a simple report, the information you gave would probably be enough, but looking at the Report Query, there's a couple other places that you'll need to check.
The action of the query isn't doing a simple get. Instead it's calling a custom Method: s_Indentured_Drawing_List. You can look at the source code for this Method inside of your instance by logging in as an admin and searching for it under TOC > Administration > Methods.
Additionally, the attribute sp_name="s_BOM_Quantity_RollUp" caught my eye. I can't be 100% since this is a custom method, but based on the name, I'd guess that this method is also calling a SQL stored procedure (sp) called s_BOM_Quantity_RollUp. You'll likely have to look at that stored procedure directly in the database through SQL Server Management Studio.
If I'm correct about the SQL stored procedure, then the error could be caused either by the method code or the stored procedure. I'd try looking for the name in the original error message DataSet1 in both places to try to track down where the error is actually happening. If the error is in the method code, you can check out our blog post on debugging inside of Innovator.
Please let me know if this is indeed calling a SQL procedure. In general, we strongly discourage using direct SQL for queries as it bypasses the Aras permission model, and there's almost always a way to do the same query using AML alone.
Chris
