Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. ARC "unable to execute reports" error

    ARC "unable to execute reports" error

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    When trying to run reports in ARC, we are getting "unable to execute reports" error.

    We can't login into ARC at all.

    Resolution:
    Please follow ARC troubleshooting instructions outlined below. Submit a Pivotal incident if the problem is not resolved after you've restarted the CRN in step 4.

    The following components should be up:

    1. Oracle database and Listener
    2. iPlanet (Sun ONE)
    3. Apache
    4. CRN – must be checked and started/restarted last

    1. Oracle instance and Listener

    sqlplus $ARCCONNSTR@$ARC_SID
    Make sure you can connect to the database using the listener
    If it doesn’t work perform the following to check what is up:
    ps –ef | grep ora
    To start the listener (should be performed as oracle user):
    lsnrctl start
    To start the database (should be performed as oracle user):
    sqlplus /nolog
    connect / as sysdba
    set pause off
    startup.

    2. iPlanet

    /usr/iplanet/servers/slapd-arc/check-slapd && echo "OK"
    If the iPlanet is up you will get: OK
    You can also check if you can connect to port 390 on localhost:
    telnet localhost 390
    If you need to start iPlanet you should do it as root user:
    /usr/iplanet/servers/slapd-arc/start-slapd
    Stopping the iPlanet server is not required and not recommended unless the machine is going down

    3. Apache

    To check if the apache is up:
    ps –ef | grep http | grep crn
    To start/stop the apache server:
    cd ~crn/apache/bin
    ./apachectl stop
    ./apachectl start
    If the Apache port is less then 1024 start and stop must be done as root user with full path.

    4. CRN – must be checked and started/restarted last

    Make sure all other components are up
    Check which CRN processes are running:
    running
    you will get a list of running process excluding httpd
    Check that the service is working properly:
    cd ~/cognos/bin
    ./crnctl.sh isRunning
    you should get:
    ReportNet service is running
    To start and stop the crn
    cd ~/cognos/bin
    ./crnctl.sh <start/stop>

    Additional Information

    unable to execute reports ARC error message


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ARC ‘Local Sum’ not always reflecting Aleph ‘Local Amount’
      • ARC 1.1 ETL fails after installing rep change 1324
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved