• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
We ran into some problem trying to create an ARC (ALEPH Reporting Center) call number report.

Scenario:
Connect to < http://141.213.232.84/crn/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/main.xts > account: author1MIUR0 pw: author999
Under "Create reports" select "Query Studio".
Choose "General" type reports, explore the "Item analysis", "Call number information" and "Primary call no" options.
Insert "Primary call no ID" to the report area; highlight that column, and press the Filter icon.
When the "Pick values from a list" page appears, choose "Search for values"....
In the "keywords" box, type "0 qa". [Note: you need to *include* the quotation marks in the string.]
When the list appears in results, choose "Select all" and "Insert" into the choices box.
Then press "OK", after a wait, the error appears.

We try to create a report of a long call number list, i.e. select all in results, we got error message "DPR-ERR-2079: Firewall Security, Rejection. Your request was rejected by the security firewall"

2) If we use the same workflow to create a report of a short call number list, i.e. first a couple call numbers in the results, the ARC was able to generate report successfully with no errors.

3) The error message "DPR-ERR-2079 about Firewall Security leads us to check the permissions of the user that we log in on the ARC. The user is in 'Author' group, and has permissions to use 'Query Studio' to create simple reports, but has not permissions to use 'Report Studio'.

We need help to understand the error message "DPR-ERR-2079". Does it mean the user's permission is restricted from loading large amount of data to ARC report? (If so, it needs to be increased to allow more.)

Resolution:
The limit of 65536 lines still exists. This is a limit in Cognos software.

It doesn't seem we can do much to change it. The limit also exists in Cognos 8 (ARC 2.0).

We did add topics to the call number entity in ARC 2.0 (tab_topic) - this should limit the number of call number results to a specific topic.

From issue resolution: SI is closed[3/2/2009 10:48:00 AM Judith Fraenkel]

Final Status: Closed [3/2/2009 10:48:13 AM Judith Fraenkel]

• Article last edited: 10/8/2013