视图报NULL

该视图是通过一个计算脚本，向一数据表中先添加数据，然后在视图的过滤中查寻数据表，但是，当改变下拉表中的选项时候，出现NULL。若点修改该，则又向其表中添加数据，而不是将视图的数据做修改，
请高手帮忙。
以下是计算脚本中的相关代码
var id = getItemValueAsString("show_ywid");
var rtn = "";  
if ( id.equals("") || id.trim().length()<0){
   rtn ="<font color='red'>请选择工单！</font>";
}else{
  println("计算基本插入计算1111111     id"+id);
  var sqc = "select '"+getWebUser().getDomainid()+"'as domainid"
+", count(item_primaryid) as "
+" item_number  from tlk_fm_gradeadd_ref where item_primaryid ='"+id+"'";
  var list = queryBySQL(sqc);
  var number = list.iterator().next().getItemValueAsDouble("number");
  println("--------------number="+number);
   if( number <=0 ){
      println("计算基本插入计算22222222222222222    sql="+sqc );
       var sqls = "select *,id as item_id from tlk_fm_gradeadd";
  var datas = queryBySQL(sqls);
  for(var iter = datas.iterator();iter.hasNext();){
  var doc = iter.next();
  var type= doc.getItemValueAsString("selecttype");
  var content= doc.getItemValueAsString("GRADEADD_WELCOM");
println("----------------content="+content);
  var key= doc.getItemValueAsString("gradeadd_select");
  var value= doc.getItemValueAsString("gradeadd_value");
   //var  pri= countNext2("XK",true,true,true,10);
  var pri = doc.getItemValueAsString("primaryid");  
  var  primary = getDocumentProcess().getSequence();
println("--------------id="+primary);
  var typeid = doc.getItemValueAsString("typeid");
  var opts = doc.getItemValueAsString("gradeadd_opts");
  var optsid = doc.getItemValueAsString("gradeadd_optsid");
  var keyid = doc.getItemValueAsString("keyid");
  var valueid = doc.getItemValueAsString("valueid");
  var domainid = getWebUser().getDomainid();
  var appli = getApplication();
     var sql = "insert into tlk_fm_gradeadd_ref "
+" (item_selecttype,item_gradeadd_welcom,item_gradeadd_select,"
+"item_gradeadd_value,item_primaryId,id,item_typeid,"
+"item_gradeadd_opts,item_gradeadd_optsid,"
+"item_keyid,item_valueid,domainid,applicationid,item_primary) "
+"values('"+type+"','"+content+"','"+key+"','"+value+"','"+id+"','"+primary+"','"+typeid+"'"
+",'"+opts+"','"+optsid+"','"+keyid+"','"+valueid+"','"+domainid+"','"+appli+"','"+pri+"')";
  println("--------------------jisuanjiaoben="+sql);
insertByDSName("tianjin",sql);
}
   }
}
当用myeclipse跟踪时候，发现，点击修改视图时候，document第一个参数为null,不知道为什么。请帮忙

您好，请问您的tomcat是否有报错，如果有，麻烦将错误信息截图贴出，谢谢
PS:为了您的问题能够及时跟进与解决，方便的话，请提供您的联系方式（QQ或电话）以便我们为您提供更好的服务

回复 2# irene
以下是报错信息
java.lang.NullPointerException
        at cn.myapps.core.dynaform.form.ejb.InputField.createItem(InputField.java:362)
        at cn.myapps.core.dynaform.form.ejb.Form.addItems(Form.java:1166)
        at cn.myapps.core.dynaform.document.action.DocumentUtil.doRefresh(DocumentUtil.java:232)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at uk.ltd.getahead.dwr.impl.ExecuteQuery.execute(ExecuteQuery.java:239)
        at uk.ltd.getahead.dwr.impl.DefaultExecProcessor.handle(DefaultExecProcessor.java:48)
        at uk.ltd.getahead.dwr.impl.DefaultProcessor.handle(DefaultProcessor.java:81)
        at uk.ltd.getahead.dwr.AbstractDWRServlet.doPost(AbstractDWRServlet.java:162)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:177)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.dwr.filter.DWRFilter.doFilter(DWRFilter.java:41)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:85)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:662)

您好，您截的错误信息不全。我不太明白您说的用myeclipse调试时document第一个参数为null是什么意思。因为您的脚本太长，建议您先将脚本简化，然后用println();语句定位一下到底是哪一句出现问题，谢谢

PS:为了您的问题能够及时跟进与解决，方便的话，请提供您的联系方式（QQ或电话）以便我们为您提供更好的服务

回复 4# irene
是这样的，insertByDSName("tianjin",sql);这个方法
与
var process = new Packages.cn.myapps.core.dynaform.document.ejb.DocumentProcessBean(getApplication());
process.doCreate(doc);
同是插入数据，结果又什么区别吗？
tomcat报错信息就是哪个，而调试跟踪，都是根据调试一条条进入的，每次刷新时，去查看后台public Item createItem(Document doc, Object value)这个方法，
第一个参数doc 为空，而我就是不明白这个现象。

您好，方便跟您远程看看嘛？我的QQ：2676466983

回复 6# irene


    这个镇的对不起，我们单位，在工作期间不让上QQ，不过还是谢谢你的热心，希望以后又问题，还请你帮忙

您好，insertByDSName方法是直接用sql对数据库进行操作。第一参数是数据源的名称，第二个是sql语句。而var process = new Packages.cn.myapps.core.dynaform.document.ejb.DocumentProcessBean(getApplication());
process.doCreate(doc);
是调用平台的文档处理类去生成记录。
如果您不方便留QQ号，那是否能告知您的手机号码，我这边跟您电话沟通一下

回复 8# irene


    谢谢你的关心，我这边的问题已经解决了，不用再跟进了，不过，我还是想知道这两个操作生成的数据为什么有区别，我的QQ369468278，一般在晚上8，9点后才能上，手机号13555718372，

您好，同事今天将会打电话跟您沟通.