Tasks are not getting created and throwing SQLException

, ,
1

In our TEST env, suddenly the Tasks were not getting created and throwing an exception as below:

com.wm.app.b2b.server.ServiceException: electric.util.WrappedException: SOAPException( Server.userException: com.webMethods.portal.bizPolicy.BizException: [POP.001.0002] A “java.sql.SQLException” occurred with the Message "[wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“WM7PORTAL”.“T_TASK_AUDIT”.“TASK_AUDIT_ID”) " ) com.wm.app.b2b.server.ServiceException: electric.util.WrappedException: SOAPException( Server.userException: com.webMethods.portal.bizPolicy.BizException: [POP.001.0002] A “java.sql.SQLException” occurred with the Message "[wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“WM7PORTAL”.“T_TASK_AUDIT”.“TASK_AUDIT_ID”) " ) at pub.task.taskclient.queueTask(taskclient.java:118) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at

In one of our process model, on certain condition a step for task creation is invoked. Suddenly we started observing this error in one of the process model and we tried testing the other process model also which has a different task. Same error was repeated on other task also.

Same tasks were working fine in our other environments like Development & Production. Even earlier these tasks were working fine in TEST environment also but suddenly during our new test cycle happening now, we were facing this error.

Any guess on what is this error?

  • We tried executing the service “pub.task.taskclient.queueTask” from developer with taskTypeID as Input in QA and we got the same error; whereas when we execute the same service in Development environment, we get the Task Id as output from this service.

  • We restarted MWS, whole wM environment and even resetting the username/password in WmTaskClientPackage at IS and reloading the package.

  • We tried executing the pub.task.taskclient.queueTask

2

Hi, On our initial analysis we found out all the DB triggers were missing for this portal schema. Can we use DB configurator with ‘RECREATE’ option to repair the tables in existing schema?

Is this possible with data available in the current DB objects?

Will the ‘RECREATE’ delete the existing run time data?

3

Our DBA has imported all DB Object structures alone form DEV env to the TEST env. After this all missing triggers got imported to TEST env DB and also it ensured all missing DB objects was taken care with this activity.

This has resolved the issue we faced in task creation.