Open Forum

View My Drafts

Back to discussions
Expand all | Collapse all

Error opening Project in Project Analyzer

  • 1.  Error opening Project in Project Analyzer

    SILVER CONTRIBUTOR
    Posted Dec 30, 2020 10:46 AM

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


  • 2.  RE: Error opening Project in Project Analyzer

    GOLD CONTRIBUTOR
    Posted Dec 30, 2020 04:11 PM
    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
    ------------------------------

    Original Message


  • 3.  RE: Error opening Project in Project Analyzer

    SILVER CONTRIBUTOR
    Posted Jan 11, 2021 07:52 PM
    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
    ------------------------------

    Original Message