Datacap NENU Not Connecting to Application
Built a nenu application in 9.0.1 following the normal specifications. But it cannot connect to different applications on the same server. I've tested to see if my nenu settings are sane by copying the ruleset into the application and it works without fail. But from a nenu application to a different application, not working. It fails when attempting to run the query. I have reduced the query to most basic set of parameters; essentially any list of "Web Job" batches, but it still fails. Any ideas?
What is the actual error you are receiving in the NENU_RRS log?
Yes, I suppose that would've helped. Here is where it errors out from the log file, although it doesn't show as an error.
16:38:50.991 (0) t:F58 p:79CB7B8 action ProcessRunSqlQuery ()
16:38:50.991 (0) t:F58 p:79CB7B8 execute statement On Action Start
16:38:50.991 (0) t:F58 p:79CB7B8 nothing to exec
16:38:50.991 (0) t:F58 p:79CB7B8 /execute statement On Action Start
16:38:50.991 (0) t:F58 p:79CB7B8 call "Datacap.Libraries.Nenu.Actions->Datacap.Libraries.Nenu.Actions->ProcessRunSqlQuery"
16:38:50.991 (0) t:F58 p:79CB7B8 result 1[1] = false
16:38:50.991 (0) t:F58 p:79CB7B8 /call
16:38:50.991 (0) t:F58 p:79CB7B8 action returned false
16:38:50.991 (0) t:F58 p:79CB7B8 execute statement On Action False
16:38:50.991 (0) t:F58 p:79CB7B8 nothing to exec
16:38:50.991 (0) t:F58 p:79CB7B8 /execute statement On Action False
16:38:50.991 (0) t:F58 p:79CB7B8 /action
Note, I have tried setting this up different ways, the basic ruleset here is as follows:
SetupDisconnectAll
SetupOpenApplicationEx("TravelDocs", , , "True", Admin, Admin, 1
QueryClear()
QuerySetJobID("Web Job")
ProcessRunSqlQuery
Also, this works when I run this inside the TravelDocs application. So, I'm thinking my code is right, I think I may have a security issue. Just not sure why.
Your logging looks pretty terse. Is it possible you have your logging turned down in NENU? If not set to 0, change it to that value and see if your log provides more info.
OK, try this. I do get an error this way, but I'm not sure why.
Log started Tue Jun 07 16:23:11 2016
------------------------------------
16:23:11.8 (0) t:EA0 p:57DA8B0 State xml: <s lib="Maintenance Manager" tprofile="Maintenance" action_log_level="0" batch_log="1" log_appId="1" log_override="1" log_reflush="1" log_severity="1" log_threadproc="1" log_time="1" log_timediff="1" script_reload="1" service_log="3" />
16:23:11.8 (0) t:EA0 p:57DA8B0 Workflow "" paths: runtime="\\WIN7DATACAP9\Datacap\Maintenance Manager\batches\"; process="\\WIN7DATACAP9\Datacap\Maintenance Manager\dco_Maintenance Manager\"; setup dco="\\WIN7DATACAP9\Datacap\Maintenance Manager\dco_Maintenance Manager\Maintenance Manager.xml"; runtime dco="\\WIN7DATACAP9\Datacap\Maintenance Manager\batches\NENU_Maintenance\inputpf.xml";
16:23:11.8 (0) t:EA0 p:57DA8B0 ruleset:
16:23:11.8 (0) t:EA0 p:57DA8B0 ruleset name="MainteanceRules" id="1" target object="B" target id="Maintenance Manager_Maintenance" target type="Maintenance Manager"
16:23:11.8 (0) t:EA0 p:57DA8B0 rule "r_MasterMaintenance"
16:23:11.8 (0) t:EA0 p:57DA8B0 func "f_ResetBatchStatus"
16:23:11.8 (0) t:EA0 p:57DA8B0 action SetupDisconnectAll ()
16:23:11.18 (0) t:EA0 p:57DA8B0 Running SetupDisconnectAll Action...
16:23:11.18 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.18 (0) t:EA0 p:57DA8B0 /action
16:23:11.18 (0) t:EA0 p:57DA8B0 action SetApplication ("TravelDocs")
16:23:11.18 (0) t:EA0 p:57DA8B0 Running SetApplication Action...
16:23:11.18 (0) t:EA0 p:57DA8B0 In INIT
16:23:11.28 (16) t:EA0 p:57DA8B0 XML <s breakpoint="" lib="Maintenance Manager" wf="" tprofile="Maintenance" rses="" task="" task.index="" log_file="\\win7datacap9\datacap\maintenance manager\batches\nenu_maintenance\maintenance_rrs.log" last_batch_log_file="\\win7datacap9\datacap\maintenance manager\batches\nenu_maintenance\maintenance_rrs.log" last_exec_result="0" last_logic_result="1" flags="1">
<stack></stack>
<error code="0" api_source="" location=""></error><dc n="0"/><OnActionStart></OnActionStart><OnActionSuccess></OnActionSuccess><OnActionFailure></OnActionFailure><OnActionAbort></OnActionAbort><OnActionStop></OnActionStop><OnFunctionStart></OnFunctionStart><OnFunctionSuccess></OnFunctionSuccess><OnFunctionFailure></OnFunctionFailure><OnRuleStart></OnRuleStart><OnRuleFailure></OnRuleFailure><OnRuleSuccess></OnRuleSuccess><OnRulesetStart></OnRulesetStart><OnRulesetEnd></OnRulesetEnd><OnProcessStart></OnProcessStart><OnProcessEnd></OnProcessEnd></s>
16:23:11.28 (0) t:EA0 p:57DA8B0 DCSmart Metaword sArgument: TravelDocs
16:23:11.28 (0) t:EA0 p:57DA8B0 Smart Parameter return value: ''
16:23:11.28 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.28 (0) t:EA0 p:57DA8B0 /action
16:23:11.28 (0) t:EA0 p:57DA8B0 action SetStation ("1")
16:23:11.28 (0) t:EA0 p:57DA8B0 Running SetStation Action...
16:23:11.28 (0) t:EA0 p:57DA8B0 DCSmart Metaword sArgument: 1
16:23:11.28 (0) t:EA0 p:57DA8B0 Smart Parameter return value: ''
16:23:11.28 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.28 (0) t:EA0 p:57DA8B0 /action
16:23:11.28 (0) t:EA0 p:57DA8B0 action SetPassword ("admin")
16:23:11.28 (0) t:EA0 p:57DA8B0 Running SetPassword Action...
16:23:11.28 (0) t:EA0 p:57DA8B0 DCSmart Metaword sArgument: admin
16:23:11.28 (0) t:EA0 p:57DA8B0 Smart Parameter return value: ''
16:23:11.28 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.28 (0) t:EA0 p:57DA8B0 /action
16:23:11.28 (0) t:EA0 p:57DA8B0 action SetUser ("admin")
16:23:11.28 (0) t:EA0 p:57DA8B0 Running SetUser Action...
16:23:11.28 (0) t:EA0 p:57DA8B0 DCSmart Metaword sArgument: admin
16:23:11.28 (0) t:EA0 p:57DA8B0 Smart Parameter return value: ''
16:23:11.38 (16) t:EA0 p:57DA8B0 action returned true
16:23:11.38 (0) t:EA0 p:57DA8B0 /action
16:23:11.38 (0) t:EA0 p:57DA8B0 action SetupOpenApplication ()
16:23:11.38 (0) t:EA0 p:57DA8B0 C:\Datacap\dcshared\NET\Datacap.Libraries.Nenu.dll. AssemblyVersion: 9.0.0.0. AssemblyFileVersion: 9.0.4.54.
16:23:11.38 (0) t:EA0 p:57DA8B0 Running SetupOpenApplication Action...
16:23:11.68 (31) t:EA0 p:57DA8B0 action returned true
16:23:11.68 (0) t:EA0 p:57DA8B0 /action
16:23:11.68 (0) t:EA0 p:57DA8B0 action QueryClear ()
16:23:11.68 (0) t:EA0 p:57DA8B0 Running QueryClear Action...
16:23:11.68 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.68 (0) t:EA0 p:57DA8B0 /action
16:23:11.68 (0) t:EA0 p:57DA8B0 action QuerySetJobID ("Web Job")
16:23:11.68 (0) t:EA0 p:57DA8B0 Running QuerySetJobID Action...
16:23:11.68 (0) t:EA0 p:57DA8B0 In INIT
16:23:11.78 (0) t:EA0 p:57DA8B0 XML <s breakpoint="" lib="Maintenance Manager" wf="" tprofile="Maintenance" rses="" task="" task.index="" log_file="\\win7datacap9\datacap\maintenance manager\batches\nenu_maintenance\maintenance_rrs.log" last_batch_log_file="\\win7datacap9\datacap\maintenance manager\batches\nenu_maintenance\maintenance_rrs.log" last_exec_result="0" last_logic_result="1" flags="1">
<stack></stack>
<error code="0" api_source="" location=""></error><dc n="0"/><OnActionStart></OnActionStart><OnActionSuccess></OnActionSuccess><OnActionFailure></OnActionFailure><OnActionAbort></OnActionAbort><OnActionStop></OnActionStop><OnFunctionStart></OnFunctionStart><OnFunctionSuccess></OnFunctionSuccess><OnFunctionFailure></OnFunctionFailure><OnRuleStart></OnRuleStart><OnRuleFailure></OnRuleFailure><OnRuleSuccess></OnRuleSuccess><OnRulesetStart></OnRulesetStart><OnRulesetEnd></OnRulesetEnd><OnProcessStart></OnProcessStart><OnProcessEnd></OnProcessEnd></s>
16:23:11.78 (0) t:EA0 p:57DA8B0 DCSmart Metaword sArgument: Web Job
16:23:11.78 (0) t:EA0 p:57DA8B0 Smart Parameter return value: ''
16:23:11.78 (0) t:EA0 p:57DA8B0 action returned true
16:23:11.78 (0) t:EA0 p:57DA8B0 /action
16:23:11.78 (0) t:EA0 p:57DA8B0 action ProcessRunSqlQueryEx (1,-1)
16:23:11.78 (0) t:EA0 p:57DA8B0 Running ProcessRunSqlQuery Action...
16:23:11.78 (0) t:EA0 p:57DA8B0 !!! ERROR !!!: Impossible to build the Query. No conditions set.
16:23:11.78 (0) t:EA0 p:57DA8B0 Running SetupDisconnectAll Action...
16:23:11.88 (15) t:EA0 p:57DA8B0 result 1[1] = false
16:23:11.88 (0) t:EA0 p:57DA8B0 action returned false
16:23:11.88 (0) t:EA0 p:57DA8B0 /action
16:23:11.88 (0) t:EA0 p:57DA8B0 func result: "false"
16:23:11.88 (0) t:EA0 p:57DA8B0 /func
16:23:11.88 (0) t:EA0 p:57DA8B0 rule result: "false"
16:23:11.88 (0) t:EA0 p:57DA8B0 /rule
16:23:11.88 (0) t:EA0 p:57DA8B0 /ruleset
16:23:11.98 (16) t:EA0 p:57DA8B0 c:\datacap\RRS\Logs\wrrs
16:23:11.98 (0) t:EA0 p:57DA8B0 end log to batch