Cage Code 00000

Question

Good day all.&nbsp; Would having a Cage Code of all 0's cause a problem when a report is ran?&nbsp; I receive errors for some of my parts reports that indicate that I do not have permissions to run the report (I'm an Admin).&nbsp; When I try to run the report from the parts attached to the part that causes an error, I can run the reports with no problems.&nbsp; I'm trying to figure out what is causing the problem.&nbsp; This is a custom report to generate a BOM.&nbsp; The BOM lists have included parts and a few different types of documents.&nbsp;
I have inherited this system from a previous contract, so I am trying to figure out how it was set-up and what exactly it is doing.&nbsp; Thanks for any help you can provide.

An error has occurred during report processing. ---&gt; Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---&gt; Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---&gt; System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

christopher_gillis · Answer

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 · Answer

Christopher,

Good day.&nbsp; CAGE stands for Commercial and Government Equipment.&nbsp; It is one of the fields that we have in our Parts.&nbsp; The previous care takers of our database created a Parts List ItemType where the document and all of the parts are attached to.&nbsp; Then the Part pulls the Parts List to display, instead of using the Part and BOM feature built into the system.&nbsp; 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.&nbsp; I have been trying to figure out why the report produces an error, but have not had much luck so far.&nbsp;
There are a lot of things that I have noticed wrong about this.&nbsp; There are Parts Lists,&nbsp;Drawings, and&nbsp;Documents&nbsp;inside of Parts Lists.&nbsp; I'm not sure what exactly is causing the problem.

christopher_gillis · Answer

Thank you for the additional info. :)&nbsp;
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 &gt; Administration &gt; 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 · Answer

Here is the Report information.&nbsp; I'm still learning the system, so I'm sure there is something that I am missing.
Name:&nbsp; s_BOM Quantity RollUp
Type:&nbsp; Item
Location:&nbsp; Client
Target:&nbsp; One Window
Method:&nbsp; N/A
Label:&nbsp; BOM Quantity RollUp
Description:&nbsp; Displays all parts of an assembly &amp; subassemblies below it, including quantities of each of those parts for the entire structure
Report Query:
&lt;Item type="s_Part" action="s_Indentured_Drawing_List" part_id="{@id}" sp_name="s_BOM_Quantity_RollUp"/&gt;

christopher_gillis · Answer

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&nbsp;get. Instead it's calling a custom Method:&nbsp;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&nbsp;TOC &gt; Administration &gt; Methods.&nbsp;
Additionally, the attribute&nbsp;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&nbsp;s_BOM_Quantity_RollUp. You'll likely have to look at that stored procedure directly in the database through SQL Server Management Studio.&nbsp;
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&nbsp;DataSet1 in&nbsp; 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&nbsp;our blog post on&nbsp;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

Forum Discussion

Cage Code 00000

8 Replies

Recent Discussions

DBList request failed: Request uri: 'http://localhost/InnovatorServer/Server/DBList.aspx', Status code: '404', Reason: 'Not Found'.

Batch Loader Download Location / Source Code

MPP 2025 Release (14.0.3) Corrupt Archive

HTTP Error 500.19 after installing Innovator 2025 - Solved

Installing Aras kills IIS?