Open Forum

Error opening Project in Project Analyzer

  • 1.  Error opening Project in Project Analyzer

    BRONZE CONTRIBUTOR
    Posted 18 days ago

    Hello,

    I created a test system and test company database based off of my live database.  I am receiving an error in my test environment when I open a Project in Project Analyzer.  

    sql server message 8144

    procedure or function PJPROJ_spk2 has too many arguments specified.

    Using the Database Maintenance, I ran Execute views and Stored Procedures.

    Any other things that I should check?



    ------------------------------
    Mackenzie Platten
    Crestwood Associates L.L.C.
    Schaumburg IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Error opening Project in Project Analyzer

    GOLD CONTRIBUTOR
    Posted 18 days ago
    I would suggest checking the proc to see if someone edited it; it should have 5 parms.

    Also, run a trace to see what is actually being passed from the screen to SQL server via profiler.

    Marc

    ------------------------------
    Marc DeLozier
    Finance SysAdmin
    David Evans and Associates Inc.
    Portland OR
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Error opening Project in Project Analyzer

    BRONZE CONTRIBUTOR
    Posted 6 days ago
    Thanks for your reply.  I found the PJPROJ_spk2 in the original db and re-executed it in the test db.

    ------------------------------
    Mackenzie Platten
    Crestwood Associates L.L.C.
    Schaumburg IL
    ------------------------------

    Academy - Online Interactive Learning from Experts