+Praveen Seshadri [AppSheet] +Philip Garrett ...

expressions
(Levent KULAÇOĞLU) #1

@praveen @Philip_Garrett_Appsh @Brian_Sabino I have a Workflow template which is working fine. I have taken a copy of that template and changed the {Yes/No} parameter of the SELECT expression only. When I set the WF rule and test it, I receive the following error:

============================================================ ERROR Something has gone wrong!

The URL is: /template/showtable?appName=3a20fd98-d7fd-4ae9-b83d-71042617b0a8&workflowRuleName=AYLIK%20FAAL%C4%B0YET%20RAPOR&locale=en-US&tzOffset=-180&location=0%2C%200&settings=%7B%22_RowNumber%22:%220%22%2C%22_EMAIL%22:%22%22%2C%22_NAME%22:%22%22%2C%22_LOCATION%22:%22%22%2C%22Options%20Heading%22:%22%22%2C%22Option%201%22:%22%22%2C%22Option%202%22:%22%22%2C%22Country%20Option%22:%22%22%2C%22Language%20Option%22:%22%22%2C%22Option%205%22:%22%22%2C%22Option%206%22:%22%22%2C%22Option%207%22:%22%22%2C%22Option%208%22:%22%22%2C%22Option%209%22:%22%22%2C%22_THISUSER%22:%22onlyvalue%22%7D

Object reference not set to an instance of an object.

Please contact support@appsheet.com ============================================================ Both the templates and the WF actions are identical except the SELECT formula they have. One is working fine, and the last one that I have copied from it is issueing this error. Can you please check?

(Praveen Seshadri (AppSheet)) #2

Got the support request. Will investigate and respond

(Levent KULAÇOĞLU) #3

@praveen thanks for your prompt intervention, appreciated.

(Levent KULAÇOĞLU) #4

@praveen if needed here are the app info:

Account: bessriders@gmail.com (GOOGLE) Account ID: 543624 AppName: 5S Takip Sistemi

Check-out the WF rules below: - ANLIK DURUM RAPORU (working fine) - HAFTALIK RAPOR (issuing the error/identical report with the above) - AYLIK RAPOR (issuing the error/identical report with the above) Translate

(Levent KULAÇOĞLU) #5

@praveen here is the latest audit log for AYLIK RAPOR WF Rule…

Properties:

{

“AppTemplateName”: “5STakipSistemi-543624”,

“AppId”: “3a20fd98-d7fd-4ae9-b83d-71042617b0a8”,

“AppTemplateVersion”: “1.000294”,

“RuleName”: “AYLIK RAPOR”,

“EventType”: “Change”,

“Operation”: “Change workflow rule”,

“RuleEvalMode”: “Production”,

“TableName”: “Eğitmenler”,

“RuleTableName”: “Eğitmenler”,

“OperationUpdateMode”: “UPDATES_ONLY”,

“EventMatch”: “Workflow event successfully matched”,

“Condition”: “=AND(ISNOTBLANK([MONTHLY]),[_THISROW_BEFORE].[MONTHLY]<>[_THISROW_AFTER].[MONTHLY])”,

“MatchesCondition”: “True”,

“Exception”: "System.NullReferenceException: Object reference not set to an instance of an object.\r\n

at Nirvana.Data.ReplaceTemplateExpressions.GetFormatSettings(Context context, Change change, AppEvaluatable appEvaluatable, String tableName) in q:\git\Jeenee\V2API\Workflow\Template\TemplateExpression\ReplaceTemplateExpressions.cs:line 92\r\n

at Nirvana.Data.ReplaceTemplateExpressions.ReplaceExpression(Context context, WorkflowTemplateBindContext bindContext, TemplateExpression templateExpression, TemplateMimeType templateMimeType, String templateText, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressions) in q:\git\Jeenee\V2API\Workflow\Template\TemplateExpression\ReplaceTemplateExpressions.cs:line 211\r\n

at Nirvana.Data.ReplaceTemplateExpressions.Replace(Context context, WorkflowTemplateBindContext bindContext, String templateText, TemplateExpressions templateExpressions, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Template\TemplateExpression\ReplaceTemplateExpressions.cs:line 268\r\n

at Nirvana.Data.TemplateHtml.ReplaceTemplateExpressions(Context context, WorkflowTemplateBindContext bindContext, XElement rootElement, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Template\TemplateHtml\TemplateHtml.cs:line 48\r\n

at Nirvana.Data.TemplateHtml.Replace(Context context, WorkflowTemplateBindContext bindContext, String tableName, Boolean compatibilityMode, Int32[] columnSliceMapping, Change change, AppDataContext appDataContext, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, Templates templates, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Template\TemplateHtml\TemplateHtml.cs:line 76\r\n

at Nirvana.Data.TemplateHtml.Replace(Context context, WorkflowTemplateBindContext bindContext, String tableName, Boolean compatibilityMode, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, Templates templates, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Template\TemplateHtml\TemplateHtml.cs:line 167\r\n

at Nirvana.Data.WorkflowTemplate.Replace(Context context, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 179\r\n

at Nirvana.Data.WorkflowActionEmail.GetAttachment(Context context, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, Dictionary`2 emailExpressionExts, AppErrors appErrors) in q:\git\Jeenee\V2API\Workflow\Action\WorkflowActionEmail.cs:line 182\r\n

at Nirvana.Data.WorkflowActionEmail.CreateEmail(Context context, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode) in q:\git\Jeenee\V2API\Workflow\Action\WorkflowActionEmail.cs:line 45\r\n

at Nirvana.Data.WorkflowRuleEvaluator.CreateActions(Context context, AppTemplate appTemplate, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in q:\git\Jeenee\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 109\r\n

at Nirvana.Data.WorkflowRuleEvaluator.ProcessRule(Context context, String tableName, Int32[] columnSliceMapping, Change change, UpdateModeEnum updateMode) in q:\git\Jeenee\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 481",

“Performance”: “{“Version”:1,“Time”:“00:00:00”,“PerformanceTimingRoot”:{“Mid”:154,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Eğitmenler”}]},“Timer”:{“Time”:“00:00:00”},“Children”:[]}}” }

(Praveen Seshadri (AppSheet)) #6

I can no longer find these wf rules in the app. Perhaps you have removed them?

(Praveen Seshadri (AppSheet)) #7

Best to follow up via the support thread you started.