Nullpointer Exception when Adding a new db Task

[MANI-1986cognos]

In cognos event studio after a event is performed we want to update the db task by stored procedure but when i try to add a new db task or edit the db task I am getting a nullpointer exception   

the error code is PRS-INS-1425 

 

error desc states : an error has encountered executimg operation request 

 

i have tried option such as 

 

1 recreating

2 checking my fm whther the proc is missing (we have added the dataitem as stored procedure)

3 in my other env its working fine i have tried to take that and checked it even that is also not working 

the above ia happening when the agent is edited in event studio 10.2.2 and when the agent is schedules and executed I am getting this issue

 

CNC-ASV-0078 ERROR STATES THAT THERE IS NO MODEL FOR THE STORED PROCEDURE .

 

PLEASE NOTE I HAVE ADDED IT IN MY PACKAGE AND ITS BEEN PUBLISHED.