URGENT HELP NEEDED: JMS ERROR

I am getting the below error in the JMS log file suddenly.

2011-09-27 07:52:01,968 INFO [STDOUT] 07:52:01,968 ERROR [http-0.0.0.0-9380-4] com.documentum.mthdservlet.DoMethod - Exception invoking com.prod.docu.methods.glo.managestatus.SetStatus.

DfException:: THREAD: http-0.0.0.0-9380-4; MSG: [DM_SYSOBJECT_E_CANT_SAVE_NO_LINK]error: "Cannot save GC_BankWorkflow 2011-9-27Error Stack Trace sysobject without any link.

"; ERRORCODE: 100; NEXT: null

at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:290)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForInt(NetwiseDocbaseRpcClient.java:505)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$6.evaluate(DocbaseConnection.java:1193)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1000)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForInt(DocbaseConnection.java:1186)

at com.documentum.fc.client.impl.docbase.DocbaseApi.parameterizedSave(DocbaseApi.java:738)

at com.documentum.fc.client.DfSysObject$1.evaluate(DfSysObject.java:353)

at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluateUnderTransactionWithDeadlockRetry(TransactionalFunctorWithRetry.java:38)

at com.documentum.fc.client.impl.util.TransactionalFunctorWithRetry.evaluate(TransactionalFunctorWithRetry.java:25)

at com.documentum.fc.client.DfSysObject.evaluateUnderTransactionWithDeadlockRetry(DfSysObject.java:908)

at com.documentum.fc.client.DfSysObject.doSaveImpl(DfSysObject.java:381)

at com.documentum.fc.client.DfSysObject.doSave(DfSysObject.java:185)

at com.documentum.fc.client.DfPersistentObject.saveEx(DfPersistentObject.java:891)

at com.documentum.fc.client.DfPersistentObject.save(DfPersistentObject.java:886)

at com.documentum.fc.client.DfDocument___PROXY.save(DfDocument___PROXY.java)

at com.documentum.bpm.rtutil.GenericWorkflowMethod.printStackTrace(GenericWorkflowMethod.java:165)

Can any body help me in this context? Its very urgent.

Find more posts tagged with

Comments

Imran_Yusubov

Hi,

When do you get this error?Is this is a workflow method or what?

Check the attachments and packages and see if there are any sys_object objects with i_folder_id[0]=null.

See this thread.

http://www.dmdeveloper.com/articles/programming/messages53/dmsysobj.e.html#head83

Hope that helps.

dctm_dev

This is method is getting generated in JMS log. Yes this is a workflow method. Can you please let me know the DQL query to check the item you asked for. Also let me know if there is any object then how to recover it ?

I tried with the below query but its not getting executed and saying have syntaxt error in the query.

select * from dm_sysobject where i_folder_id=null;

Imran_Yusubov

Hi,

I guess this query shuld list the sys_objects with null i_folder_id[0].

select object_name from dm_sysobject where r_object_type!='dm_cabinet' and i_folder_id is null and i_position=-1 ENABLE(ROW_BASED)

Also run the consistency checker job I guess it should list the results too.

Some more questions,

what this method do?

has it ever worked?

Hope that helps.

dctm_dev

There is no result for the above query.

This method forward the workitem from one activity to another activity and also send mails.

Yes this workflow method worked successfully and it is also working now but at the back end this is giving this error in the JMS log file.

I also found the below error in the docbase log

Tue Sep 27 12:00:22 2011 570707: 1880142[1880142] DO_METHOD TRACE LAUNCH: method launch: failed, user: myrepositry, session id: 0101d11e8000000b, method: <customMethodName>

dctm_dev

It is very urgent and can anyone please help me out of this situation ? I am looking for urgent help which is really appreciated. Its my production issue.

Imran_Yusubov

Hi,

Please attach the method here see if we can find out what can cause this.

dctm_dev

you want me to attach the code ?

Please find below the code:

public class SetPromoteStatus extends WorkflowMethod {

IDfCollection coll = null;

IDfSession session1=null;

public SetPromoteStatus() {}

protected int doTask(IDfWorkitem iDfWorkitem, IDfProperties idfproperties, PrintWriter printWriter)

throws Exception {

DfLogger.info(this,"SetPromoteStatus: Entering to doTask():",null, null);

try {

IDfFolder historyObj=null;

wiObj = iDfWorkitem;

sess = iDfWorkitem.getSession();

String preWorkItemId ="";

String objStatus="";

int slavalue=0;

//System.out.println("Getting session (SetPromoteStatu) for CAW with Session ID::"+sess.getSessionId());

queueItemId = wiObj.getQueueItemId();

//System.out.println(" doTask IdfWrokitem---------r_runtime_state-------->>>"+wiObj.getString("r_runtime_state"));

//System.out.println(" doTask queueItemId ------------->"+queueItemId);

IDfList idflist = idfproperties.getList(PACKAGE_NAMES);

//System.out.println("idflist ------------->"+idflist);

if(idflist == null || idflist.getCount() == 0)

{

DfLogger.warn(this, "No package specified", null, null);

return 0;

}

String state = idfproperties.getString(STATE);

//System.out.println(" doTask State ------------->"+state);

String status = idfproperties.getString(STATUS);

//System.out.println("doTask status ------------->"+status);

boolean promotionflag = idfproperties.getBoolean(PROMOTION_FLAG);

//System.out.println(" doTask promotionflag ------------->"+promotionflag);

considerElapseTime = idfproperties.getBoolean(ELAPSE_TIME_FLAG);

IDfSysObject obj = null;

// get the host country boolean

boolean bHostCountry = idfproperties.getBoolean(HOST_COUNTRY_FLAG);

for(int i = 0; i < idflist.getCount(); i++)

{

String packageName = idflist.getString(i);

obj = getComponentByName(packageName);

objStatus=obj.getString("status");

//System.out.println("doTask Promote to the State ---------> "+status);

slavalue = obj.getInt("sla_value");

//System.out.println("doTask slavalue inside idflist loop ------------->"+slavalue);

if(bHostCountry)

{

//System.out.println("doTask line# 70 inside if--host country----------");

m_CountryName = obj.getString("host_country");

}

else

{

//System.out.println("doTask line# 75 inside side--country----------");

m_CountryName = obj.getString("country");

}

if(status != null && !"".equalsIgnoreCase(status))

{

preWorkItemId = Utils.getPreviousWorkItemId(sess, iDfWorkitem.getWorkflowId().toString());

//System.out.println("doTask Inside if loop -------preWorkItemId befor entering in the createHistoryObject------>"+preWorkItemId);

if(!"".equalsIgnoreCase(preWorkItemId))

{

if(slavalue == 1)

slavalue = 0;

historyObj=

createHistoryObject(preWorkItemId, iDfWorkitem.getActivity().getObjectName(),obj.getObjectName(),slavalue, obj.getString("status"), printWriter);

}

if(considerElapseTime)

{

double elpMin = obj.getDouble("elapsed_min");

elpMin += elapsedMinutes;

obj.setDouble("elapsed_min", elpMin);

double processSLA = Utils.getProcessSLA(sess, obj.getObjectName());

if(processSLA > 0.0D && elpMin > processSLA)

obj.setInt("sla_value", 2);

else

obj.setInt("sla_value", 0);

}

obj.setString("status", status);

obj.save();

if(null!=historyObj){

//linkCommentsToHistory(iDfWorkitem.getWorkflowId().toString(),obj.getObjectName(), historyObj);

}

if(state != null && !"".equalsIgnoreCase(state))

{

if(promotionflag)

{

for(; !state.equalsIgnoreCase(obj.getCurrentStateName()); obj.save())

//System.out.println("doTask Current state name----if------>>"+obj.getCurrentStateName());

obj.promote(null, false, false);

}

else

for(; !state.equalsIgnoreCase(obj.getCurrentStateName()); obj.save())

//System.out.println("Current state name----else------>>"+obj.getCurrentStateName());

obj.demote(null, false);

}

setNextActivityPerformer();

sendEmail(obj);

if(iDfWorkitem !=null && iDfWorkitem.getActivity().getObjectName().equalsIgnoreCase("Inquiry Completed"))

{

createMISHistoryObject(preWorkItemId,iDfWorkitem.getActivity().getObjectName(),obj.getObjectName(), objStatus,slavalue);

}

else

{

createMISHistoryObject(preWorkItemId,status,obj.getObjectName(), objStatus,slavalue);

}

DfLogger.info(this,"SetPromoteStatus: Leaving from doTask():",null, null);

return 0;

}

catch(DfException exp)

{

//exp.printStackTrace();

DfLogger.error(this,"SetPromoteStatus:doTask():ERROR:"+exp.getMessage(),null, null);

DfLogger.warn(this, "Error executing the Method", null, exp);

return 1;

}

//DfLogger.info(this,"SetPromoteStatus: Leaving from doTask():",null, null);

}

private void sendEmail(IDfSysObject obj)

{

try

{

String groupAdminName = null;

String groupDesc = null;

String Owner_name=null;

String user_name="";

if(m_WorkQueueName!=null && !m_WorkQueueName.equals(""))

{

groupAdminName = Utils.getGroupAdminForWorkItemQueueByWorkQueueName(sess,m_WorkQueueName);

groupDesc=Utils.getGroupDesc(sess,m_WorkQueueName);

}

Owner_name=obj.getString("icsr_login_id");

String emil_query="Select user_name from dm_user where user_login_name='"+Owner_name+"'";

IDfQuery idfQuerry = new DfQuery();

idfQuerry.setDQL(emil_query);

IDfCollection coll = null;

try {

coll = idfQuerry.execute(sess,IDfQuery.DF_QUERY);

while(coll.next())

{

user_name = coll.getString("user_name");

}

coll.close();

}

catch(DfException de )

{

//de.printStackTrace();

DfLogger.error(this,"SetPromoteStatus:sendEmail():ERROR:"+de.getMessage(),null, null);

}

StringBuffer sbMessage = new StringBuffer();

if(obj!=null)

{

sbMessage.append("");

sbMessage.append("File Number:"+obj.getObjectName());

sbMessage.append(" ");

sbMessage.append("Home Country:"+obj.getString("country"));

sbMessage.append(" ");

sbMessage.append("Host Country:"+obj.getString("host_country"));

sbMessage.append(" ");

sbMessage.append("Queue Name:");

if(groupDesc != null && !groupDesc.equals(""))

{

sbMessage.append(groupDesc);

}

sbMessage.append(" ");

sbMessage.append("Product:"+obj.getString("product_enquired"));

sbMessage.append(" ");

}

String [] addressList = getUserAddressList(m_WorkQueueName,groupAdminName,user_name);

sendStatusMail(sbMessage.toString(),addressList);

}

catch(DfException dfe)

{

dfe.printStackTrace();

DfLogger.error(this,"SetPromoteStatus:sendEmail():ERROR4:"+dfe.getMessage(),null, null);

}

private void sendStatusMail(String msgBody,String [] ToList){

try{

String subject = "CAW - !! Posted Event: 'Task Assigned'";

String from = "";

String mailhost = "";

String strQuery1 = "select \"value\" AS mailhost,r_object_id from ctb_config_mult_val_gl where app_source='CAW' and object_name = 'MAILHOST'";

/*** get mail host days ***/

IDfCollection collection = execQuery(strQuery1,sess);

while (collection.next()){

mailhost = collection.getString("mailhost");

}

collection.close();

String strQuery2 = "select \"value\" AS from1,r_object_id from ctb_config_mult_val_gl where app_source='CAW' and object_name = 'MAIL_FROM_ID'";

/*** get from Id days ***/

IDfCollection collection1 = execQuery(strQuery2,sess);

while (collection1.next()){

from = collection1.getString("from1");

}

collection1.close();

Address address[] = new InternetAddress[ToList.length];

for(int i=0;i<ToList.length;i++){

address[i]=new InternetAddress(ToList[i]);

DfLogger.info(this,"sendStatusMail:"+ToList[i],null,null);

}

Properties props = new Properties();

props.put("mail.smtp.debug", true);

props.put("mail.smtp.host", mailhost);

Session session = Session.getDefaultInstance(props, null);

try {

MimeMessage msg = new MimeMessage(session);

msg.setFrom(new InternetAddress(from));

msg.addRecipients(MimeMessage.RecipientType.TO, address);

msg.setSubject(subject);

msg.setSentDate(new Date());

msg.setContent(msgBody,"text/plain");

Transport.send(msg);

}catch(Exception ex){

ex.printStackTrace();

DfLogger.error(this,"setPromoteStatus -- sendStatusMail() method [1]::"+ex.getMessage(),null,null);

}

}catch(Exception ex1)

{

//ex1.printStackTrace();

DfLogger.error(this,"setPromoteStatus -- sendStatusMail() method [2]::"+ex1.getMessage(),null,null);

//DfLogger.error(this,ex1.getMessage(),null,null);

}

private void setNextActivityPerformer() throws Exception

{

try

{

// assign the workqueue for the next step before completing the workitem

IDfList objPerformerList =null;

String strNextActivityName = null;

String strProcessName = null;

strProcessName = Utils.getProcessNameByWorkitemId(sess, wiObj.getObjectId().getId());

//System.out.println(" setNextActivityPerformer strProcessName------>"+ strProcessName);

// get the next acvitivy name

IDfList listForwardActivities = wiObj.getForwardActivities();

IDfActivity activity = null;

//loop through the activities

for (int i = 0; i < listForwardActivities.getCount(); ++i)

{

objPerformerList = new DfList();

//get the activity

activity = (IDfActivity) listForwardActivities.get(i);

strNextActivityName = activity.getObjectName();

if(strNextActivityName!=null && strNextActivityName.trim().length()>0)

{

String value=null;

value=Utils.getWorkQueueNameForCountry(sess, strProcessName, strNextActivityName, m_CountryName);

//System.out.println(" setNextActivityPerformer getWorkQueueNameForCountry------>"+ value);

if(value!=null && value.trim().length()>0)

{

m_WorkQueueName=value;

objPerformerList.append(m_WorkQueueName);

wiObj.setPerformers(strNextActivityName, objPerformerList);

//System.out.println(" setNextActivityPerformer objPerformerList------>"+objPerformerList );

}

catch(Exception e)

{

//e.printStackTrace();

DfLogger.error(this,"SetPromoteStatus:setNextActivityPerformer():ERROR:"+e.getMessage(),null, null);

throw e;

}

protected IDfSysObject getComponentByName(String packageName)

throws DfException

{

com.documentum.fc.client.IDfPersistentObject idfpersistentobject = super.getComponent(packageName);

if(!(idfpersistentobject instanceof IDfSysObject))

throw new DfException("Error !!!! Document " + packageName + " is not Sysobject.");

IDfSysObject idfsysobject = (IDfSysObject)idfpersistentobject;

if(idfsysobject.isCheckedOut())

throw new DfException("Document " + idfsysobject.getObjectName() + " (" + idfsysobject.getObjectId().toString() + ") of package " + packageName + " is checked out.");

else

return idfsysobject;

}

private void createMISHistoryObject(String workItemId, String activityName, String appName, String previousActivityName,int slavalue )

{

IDfFolder historyObj = null;

IDfFolder prehisObj=null;

IDfSysObject appObj=null;

// IDfSysObject country=null;

try

{

// System.out.println("1") ;

appObj=(IDfSysObject)sess.getObject(new DfId(appName));

if(appObj.getString("title").equalsIgnoreCase("INQUIRY_TO_APPLICATION"))

{

appObj.setTime("r_creation_date", new DfTime());

appObj.setString("title","");

appObj.save();

}

// System.out.println("2") ;

historyObj = (IDfFolder)sess.newObject("ctb_mis_history_gl");

// System.out.println("3") ;

if(historyObj == null)

return ;

historyObj.setObjectName(historyObj.getObjectId().getId());

//System.out.println("4") ;

historyObj.setString("app_num",appName);

historyObj.setString("app_source","CAW");

//System.out.println("5") ;

IDfWorkitem preWIobj =null;

if(workItemId!=null && workItemId.trim().length()>0)

{

preWIobj = (IDfWorkitem)sess.getObject(new DfId(workItemId));

historyObj.setString("performer_name", preWIobj.getPerformerName()==null?"":preWIobj.getPerformerName());

historyObj.setString("task_name", preWIobj.getActivity().getObjectName()==null?"":preWIobj.getActivity().getObjectName());

}

// System.out.println("6") ;

prehisObj=(IDfFolder)sess.getObjectByQualification("ctb_mis_history_gl where app_num='"+appName+"' and app_runtime_state=1 and app_source='CAW'");

// System.out.println("7") ;

if(prehisObj==null )

{

IDfWorkflow wf=(IDfWorkflow)sess.getObjectByQualification("dm_workflow where r_object_id in(select r_workflow_id from dmi_package where any r_component_id='"+appName+"') and \n" +

" r_runtime_state in(0,1,3)");

if(wf!=null)

{

historyObj.setTime("activity_start_time",wf.getTime("r_start_date"));

historyObj.setInt("app_runtime_state",1);

}

else if(wf==null)

{

}

else

{

prehisObj.setTime("activity_end_time",new DfTime());

if(prehisObj.getTime("activity_end_time").isNullDate())

{

historyObj.setTime("activity_start_time",new DfTime());

}

else

{

historyObj.setTime("activity_start_time",prehisObj.getTime("activity_end_time"));

}

historyObj.setInt("app_runtime_state",1);

prehisObj.setInt("app_runtime_state",0);

prehisObj.save();

}

historyObj.setString("activity_name", activityName);

historyObj.setInt("sla_value",0);

historyObj.setString("call_type",appObj.getString("call_type"));

historyObj.setString("icsr_name",appObj.getString("icsr_login_id"));

historyObj.setString("product_enquired",appObj.getString("product_enquired"));

IDfSysObject preMISHisObj=(IDfSysObject)sess.getObjectByQualification("ctb_mis_history_gl where app_num='"+appName+"' and app_source='CAW' order by r_object_id desc");

if(preMISHisObj!=null)

{

historyObj.setString("previous_activity_name", preMISHisObj.getString("activity_name"));

}

else

{

historyObj.setString("previous_activity_name", previousActivityName);

}

historyObj.setString("queue_name", m_WorkQueueName);

String val="";

val=getPath(m_WorkQueueName);

if(val!=null && val.trim().length()>0)

{

historyObj.setString("country_name",val.substring(val.lastIndexOf("/")+1,val.length()));

val=val.substring(0,val.lastIndexOf("/"));

historyObj.setString("hub_name",val.substring(val.lastIndexOf("/")+1,val.length()));

}

val=getPathCountry(appObj.getString("country"));

if(val!=null && val.trim().length()>0)

{

historyObj.setString("home_country",val.substring(val.lastIndexOf("/")+1,val.length()));

<strong style="color: black; font-size: 10

dctm_dev

I am also getting this error in the bpm-runtime log

9:29:51,216 ERROR Exception encountered in automatic workflow task [http-0.0.0.0-9380-4 - bpm.com.prod.docu.methods.glo.managestatus.SetPromoteStatus]

DfException:: THREAD: http-0.0.0.0-9380-4; MSG: [DM_SYSOBJECT_E_CANT_SAVE_NO_LINK]error: "Cannot save <Wf_Name> 2011-07-27Error Stack Trace sysobject without any link."; ERRORCODE: 100; NEXT: null