tomlbacon
20th October 2010, 19:53
Trying to Release to Warehouse session tdsls4246m000 Baan V.


stpapi.put.field("tdsls4246m000", "orno.f", "orno.f")
stpapi.put.field("tdsls4246m000", "orno.t", "orno.f")
stpapi.put.field("tdsls4246m000", "cotp.f", " ")
stpapi.put.field("tdsls4246m000", "cotp.t", "ZZZ")
stpapi.put.field("tdsls4246m000", "coft.f", " ")
stpapi.put.field("tdsls4246m000", "coft.t", "ZZZZZZ")
stpapi.put.field("tdsls4246m000", "ofbp.f", " ")
stpapi.put.field("tdsls4246m000", "ofbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "stbp.f", " ")
stpapi.put.field("tdsls4246m000", "stbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "ref.date", "odat.to")
stpapi.put.field("tdsls4246m000", "log.report", "tcyesno.yes")
stpapi.put.field("tdsls4246m000", "log.success", "tcyesno.yes")
stpapi.put.field("tdsls4246m000", "rel.man", "tcyesno.no"
stpapi.insert("tdsls4246m000", do.save, err.msg)
Received Command Disabled in err.msg.
stpapi.update("tdsls4246m000", do.save, err.msg)
No error messge
stpapi.continue.process("tdsls4246m000",err.msg)
Received Comman Disabled in err.msg
stpapi.end.session("tdsls4246m000")

any one done this session before or have any ideas.
Thanks,

Tom

Tom

mark_h
20th October 2010, 22:06
Why the insert and update? Looks more like my outbound session. I would just have the continue. Also - does it generate a report? I would also include the stpapi.set.report command. Not sure those will fix it but first things I noticed.

PS - This is the correct forum for stpapi type questions.

tomlbacon
21st October 2010, 17:43
Session tdsls4246m000 starts the bhell but doesn't process, also tried to do as report but changed the to reports to no so it doesn't print. Any suggestions?

function process.release()
{

do.save = 1
stpapi.put.field("tdsls4246m000", "orno.f", "orno.f")
stpapi.put.field("tdsls4246m000", "orno.t", "orno.f")
stpapi.put.field("tdsls4246m000", "cotp.f", " ")
stpapi.put.field("tdsls4246m000", "cotp.t", "ZZZ")
stpapi.put.field("tdsls4246m000", "coft.f", " ")
stpapi.put.field("tdsls4246m000", "coft.t", "ZZZZZZ")
stpapi.put.field("tdsls4246m000", "ofbp.f", " ")
stpapi.put.field("tdsls4246m000", "ofbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "stbp.f", " ")
stpapi.put.field("tdsls4246m000", "stbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "ref.date", "odat.to +30")
stpapi.put.field("tdsls4246m000", "log.report", "tcyesno.no")
stpapi.put.field("tdsls4246m000", "log.success", "tcyesno.no")
stpapi.put.field("tdsls4246m000", "rel.man", "tcyesno.no")
| stpapi.set.report("tdsls4246m000", "rtdsls424611000", "D", err.msg)
| stpapi.print.report("tdsls4246m000", err.msg)
stpapi.update("tdsls4246m000", do.save, err.msg)
stpapi.end.session("tdsls4246m000")

}

mark_h
22nd October 2010, 15:27
Does this work?


do.save = 1
stpapi.put.field("tdsls4246m000", "orno.f", str$(orno.f))
stpapi.put.field("tdsls4246m000", "orno.t", str$(orno.f))
stpapi.put.field("tdsls4246m000", "cotp.f", " ")
stpapi.put.field("tdsls4246m000", "cotp.t", "ZZZ")
stpapi.put.field("tdsls4246m000", "coft.f", " ")
stpapi.put.field("tdsls4246m000", "coft.t", "ZZZZZZ")
stpapi.put.field("tdsls4246m000", "ofbp.f", " ")
stpapi.put.field("tdsls4246m000", "ofbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "stbp.f", " ")
stpapi.put.field("tdsls4246m000", "stbp.t", "ZZZZZZZZZ")
stpapi.put.field("tdsls4246m000", "ref.date", str$(odat.to +30))
stpapi.put.field("tdsls4246m000", "log.report", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "log.success", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "rel.man", str$(etol(tcyesno.no)))
stpapi.set.report("tdsls4246m000", "rtdsls424611000", "D", err.msg)
| stpapi.print.report("tdsls4246m000", err.msg)
stpapi.continue.process("tdsls4246m000",err.msg)
stpapi.end.session("tdsls4246m000")


Notice I just put the continue in there and included the set report. This session does not exist on our 4c4 system so I can't even look at it. I also found other items in the code to change - I assumed orno.f and orno.t are longs, I did the date in the str$ format expected and the tcyesno variables. Remember when calling a session all the variables need to be in string format. Also - the only reason I included the report name is that one time I did a session even without printing it still expected a report name.

tomlbacon
25th October 2010, 20:04
Go it working; Baan V release to Warehouse Code below:
function process.release()
{
do.save = 1
stpapi.put.field("tdsls4246m000", "orno.f", str$(tdsls401.orno))
stpapi.put.field("tdsls4246m000", "orno.t", str$(tdsls401.orno))
stpapi.put.field("tdsls4246m000", "cotp.f", str$(" "))
stpapi.put.field("tdsls4246m000", "cotp.t", str$("ZZZ"))
stpapi.put.field("tdsls4246m000", "coft.f", str$(" "))
stpapi.put.field("tdsls4246m000", "coft.t", str$("ZZZZZZ"))
stpapi.put.field("tdsls4246m000", "ofbp.f", str$(" "))
stpapi.put.field("tdsls4246m000", "ofbp.t", str$("ZZZZZZZZZ"))
stpapi.put.field("tdsls4246m000", "stbp.f", str$(" "))
stpapi.put.field("tdsls4246m000", "stbp.t", str$("ZZZZZZZZZ"))
stpapi.put.field("tdsls4246m000", "ref.date", str$(w.date))
stpapi.put.field("tdsls4246m000", "log.report", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "log.success", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "rel.man", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "proc.device", str$(etol(tcyesno.no)))
stpapi.put.field("tdsls4246m000", "alt.dev", " ")
stpapi.put.field("tdsls4246m000", "alt.spoolout", str$("<path>"))
stpapi.set.report("tdsls4246m000", "rtdsls424611000", "D", err.msg)
stpapi.form.command("tdsls4246m000", 5, "exec.cont.process", err.msg)
stpapi.update("tdsls4246m000", do.save, err.msg)
stpapi.end.session("tdsls4246m000")

}