Assign a task to resource

7,558 views

When a try to assign a task i get this in log: 2013-08-25 22:07:47,279 ERROR com.ganib.schedule.ScheduleEntry - Error occurred while storing task: java.sql.SQLException: Parameter number 24 is not an OUT parameter

asked Aug 25, 2013 by Moises (200 points)
I just download this file http://sourceforge.net/projects/ganib/files/Ganib-1.3/Ganib-1.3.zip/download which contains ganib.war and ganib.sql. Deployed both and still getting "2013-08-26 17:53:30,017 ERROR com.ganib.schedule.ScheduleEntry - Error occurred while storing task: java.sql.SQLException: Parameter number 24 is not an OUT parameter"
        
I tried de VMWARE and also got the same problem.

6 Answers

0 votes

Hi Moises,

When a try to assign a task i get this in log: 2013-08-25 22:07:47,279 ERROR com.ganib.schedule.ScheduleEntry - Error occurred while storing task: java.sql.SQLException: Parameter number 24 is not an OUT parameter

You are facing this problem because of the version mismatch within application & database. Please remove your MySQL database & import it from ganib archive you are using.

Thanks,

answered Aug 26, 2013 by Emily S (820 points)
0 votes

I just download this file http://sourceforge.net/projects/ganib/files/Ganib-1.3/Ganib-1.3.zip/download which containsganib.war and ganib.sql. Deployed both and still getting "2013-08-26 17:53:30,017 ERROR com.ganib.schedule.ScheduleEntry - Error occurred while storing task: java.sql.SQLException: Parameter number 24 is not an OUT parameter"

answered Aug 26, 2013 by Moises (200 points)
0 votes

Hi Moises,

Can you please provide MySQL version you have installed on your system. Also please paste a full stacktrace from logs/catalina.out.

Thanks

answered Aug 29, 2013 by Emily S (820 points)
mysql(5.6.12)
Version 5.6 has a different problem with the SQL syntax used in other part of the system, but I am using 5.5 and are also getting this error.
I am using Ganib-1.3 bundle and MySQL 5.5 on Windows for a test (although I would prefer to use PostgreSQL) and I am getting the same error. I have used the sql script that is inside the zip archive and was able to create an account, a project, and even managed to create a task, but I cannot assign it to me (as for a test).
What could be the cause and how to correct this?
        
As an update I downgraded my MySQL Server to 5.1.72 to comply with the mysql connector provided in the bundle and still getting "ERROR com.ganib.schedule.ScheduleEntry - Error occurred while storing task: java.sql.SQLException: Parameter number 24 is not an OUT parameter"
        
0 votes
Hi Moises,
We've fixed above issue & uploaded to sourceforge. Please download & install database script from the latest archive.
Thanks
answered Sep 10, 2013 by Emily S (820 points)
0 votes

i get this error too . my sql version is 5.1 and i just run sql file in archive file

answered Dec 7, 2013 by seyfodin (180 points)
0 votes

Hello Seyfodin

Please run this SQL patch on you Ganib Local Database, you will probable able to assign the task.

DELIMITER $$
DROP PROCEDURE IF EXISTS  STORE_ASSIGNMENT $$
CREATE PROCEDURE STORE_ASSIGNMENT (
    IN I_SPACE_ID INT(11),
    IN I_PERSON_ID INT(11),
    IN I_OBJECT_ID INT(11),
    IN I_PERCENT DOUBLE,
    IN I_ROLE VARCHAR(80),
    IN I_PRIMARY_OWNER TINYINT(4),
    IN I_START_DATE DATETIME,
    IN I_END_DATE DATETIME,
    IN I_ACTUAL_START DATETIME,
    IN I_ACTUAL_FINISH DATETIME,
    IN I_ESTIMATED_FINISH DATETIME,
    IN I_WORK DOUBLE,
    IN I_WORK_UNITS DOUBLE,
    IN I_WORK_COMPLETE DOUBLE,
    IN I_WORK_COMPLETE_UNITS DOUBLE,
    IN I_IS_COMPLETE DOUBLE,
    IN I_PERCENT_COMPLETE DOUBLE,
    IN I_MODIFIED_BY INT(11),
    IN I_RECORD_STATUS VARCHAR(1),
    IN I_ASSIGNOR_ID INT(11),
    IN I_STATUS_ID INT(11),
    IN I_TIMESHEET_ESTIMATED_FINISH DATETIME,
    IN I_WHEN_TO_WORK VARCHAR(10),
    OUT O_STATUS INT(11))
BEGIN
        DECLARE DUPLICATE_KEY INT DEFAULT 0;
        DECLARE CONTINUE HANDLER FOR 1062
        SET DUPLICATE_KEY=1;
        CALL LOG_ERROR(' IN STORE ASSIGNMENT ',I_OBJECT_ID,I_PERSON_ID);
   IF (I_PRIMARY_OWNER = 1) THEN
        UPDATE PN_ASSIGNMENT
        SET IS_PRIMARY_OWNER = 0
        WHERE SPACE_ID = I_SPACE_ID AND
            PERSON_ID = I_PERSON_ID AND
            OBJECT_ID = I_OBJECT_ID AND
            I_PRIMARY_OWNER != 0;
   END IF;
           CALL LOG_ERROR(' IN STORE ASSIGNMENT-STEP 1 ',I_OBJECT_ID,I_PERSON_ID);
         INSERT INTO PN_ASSIGNMENT
            (SPACE_ID, PERSON_ID, ASSIGNOR_ID, OBJECT_ID, STATUS_ID, PERCENT_ALLOCATED, ROLE,
             IS_PRIMARY_OWNER, START_DATE, END_DATE, ACTUAL_START, ACTUAL_FINISH,
             ESTIMATED_FINISH, WORK, WORK_UNITS, WORK_COMPLETE,
             WORK_COMPLETE_UNITS, IS_COMPLETE, PERCENT_COMPLETE, MODIFIED_BY,
             MODIFIED_DATE, RECORD_STATUS, DATE_CREATED,TIMESHEET_ESTIMATED_FINISH, WHEN_TO_WORK)
          VALUES
            (I_SPACE_ID, I_PERSON_ID, I_ASSIGNOR_ID, I_OBJECT_ID, I_STATUS_ID, I_PERCENT, I_ROLE,
            I_PRIMARY_OWNER, I_START_DATE, I_END_DATE, I_ACTUAL_START,
            I_ACTUAL_FINISH, I_ESTIMATED_FINISH, I_WORK, I_WORK_UNITS,
            I_WORK_COMPLETE, I_WORK_COMPLETE_UNITS, I_IS_COMPLETE, I_PERCENT_COMPLETE,
            I_MODIFIED_BY, SYSDATE(), I_RECORD_STATUS, SYSDATE(),I_TIMESHEET_ESTIMATED_FINISH, I_WHEN_TO_WORK);
        CALL LOG_ERROR(' IN STORE ASSIGNMENT-STEP 2',I_OBJECT_ID,I_PERSON_ID);
          IF DUPLICATE_KEY = 1 THEN
            UPDATE PN_ASSIGNMENT
              SET STATUS_ID = I_STATUS_ID,
                  PERCENT_ALLOCATED = I_PERCENT,
                  ROLE = I_ROLE,
                  IS_PRIMARY_OWNER = I_PRIMARY_OWNER,
                  START_DATE = I_START_DATE,
                  END_DATE = I_END_DATE,
                  ACTUAL_START = I_ACTUAL_START,
                  ACTUAL_FINISH = GET_ACTUAL_FINISH_DATE(I_PERSON_ID,I_OBJECT_ID,I_IS_COMPLETE),
                  ESTIMATED_FINISH = I_ESTIMATED_FINISH,
                  WORK = I_WORK,
                  WORK_UNITS = I_WORK_UNITS,
                  WORK_COMPLETE = I_WORK_COMPLETE,
                  WORK_COMPLETE_UNITS = I_WORK_COMPLETE_UNITS,
                  IS_COMPLETE = I_IS_COMPLETE,
                  PERCENT_COMPLETE = I_PERCENT_COMPLETE,
                  MODIFIED_BY = I_MODIFIED_BY,
                  MODIFIED_DATE = SYSDATE(),
                  RECORD_STATUS = I_RECORD_STATUS,
                  ASSIGNOR_ID = I_ASSIGNOR_ID,
                  TIMESHEET_ESTIMATED_FINISH  =  I_TIMESHEET_ESTIMATED_FINISH,
                  WHEN_TO_WORK = I_WHEN_TO_WORK
              WHERE SPACE_ID = I_SPACE_ID
                AND PERSON_ID = I_PERSON_ID
                AND OBJECT_ID = I_OBJECT_ID;
        CALL LOG_ERROR(' IN STORE ASSIGNMENT - STEP3 ',I_OBJECT_ID,I_PERSON_ID);
        END IF;
        SET O_STATUS = 0;
    END$$
DELIMITER ; 
 

Jaclyn

Jaclyn N,
Ganib Support Team, Ganib Inc.
Free Signup | Free Download | Documentation
Skype ID: ganib.support
Email: support@ganib.com

 

answered Dec 12, 2013 by Jaclyn (18,310 points)
...