テンプレートアプリからアプリケーションの作成が失敗する

[satoru]

こんにちは

Tokyoバージョンで作成したテンプレートアプリのPDIをUtah P1にアップグレードしました。

その後このテンプレートアプリからアプリを作成したところ以下のメッセージが表示されるようになり

テンプレートからアプリケーションを作成することができなくなりました。

どなたか原因と解消方法をご存じの方いらっしゃらないでしょうか？

なお、テンプレートアプリには、翻訳テキストの設定はしておりません。

Template Execution Failure Could not load payload (112bb2cc3e1611106116fcc6b68d3656):
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
：以下、Unabled to load…の繰り返し

syslogには、以下のメッセージが出力されています

Flow Designer: Operation(Application Template - templ_GenWF - 2022-09-26 00:24:52.86c31c27970611108215337e6253af32./end) failed with error: com.snc.process_flow.exception.ProcessAutomationException: Could not load payload (112bb2cc3e1611106116fcc6b68d3656): Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language
Unable to load the 'sys_translated_text' record due to an existing record containing the same values for the following fields: tablename, fieldname, documentkey, language

at com.snc.process_flow.engine.ProcessEngine.catchPropagateOrThrowError(ProcessEngine.java:935)
at com.snc.process_flow.engine.ProcessEngine.handleTreatAsError(ProcessEngine.java:1025)
at com.snc.process_flow.engine.ProcessEngine.executeOps(ProcessEngine.java:601)
at com.snc.process_flow.engine.ProcessEngine.runInternal(ProcessEngine.java:498)
at com.snc.process_flow.engine.ProcessEngine.run(ProcessEngine.java:485)
at com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:86)
at com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:60)
at com.snc.process_flow.engine.GlideProcessAutomation.runSync(GlideProcessAutomation.java:173)
at com.snc.process_flow.engine.GlideProcessAutomation.runWithDomain(GlideProcessAutomation.java:331)
at com.snc.process_flow.engine.GlideProcessAutomation.lambda$runAsUserSync$1(GlideProcessAutomation.java:298)
at com.snc.process_flow.engine.PFSessionClone.run(PFSessionClone.java:70)
at com.snc.process_flow.engine.GlidePFSession.runPlanAsUserSession(GlidePFSession.java:42)
at com.snc.process_flow.engine.GlideProcessAutomation.runAsUserSync(GlideProcessAutomation.java:296)
at com.snc.process_flow.engine.GlideProcessAutomation.messageFlow(GlideProcessAutomation.java:381)
at com.snc.process_flow.engine.GlideProcessAutomation._start(GlideProcessAutomation.java:592)
at com.snc.process_flow.engine.GlideProcessAutomation$StartBuilder.start(GlideProcessAutomation.java:1437)
at com.glide.plan.runners.FlowObjectExecutor.startFlowObjectSynchronously(FlowObjectExecutor.java:248)
at com.glide.plan.runners.FlowObjectExecutor.executeToCompletion(FlowObjectExecutor.java:118)
at com.glide.plan.runners.FlowObjectExecutor.executeInternalWithResponse(FlowObjectExecutor.java:108)
at com.glide.plan.runners.FlowObjectExecutor.lambda$executeWithResponse$0(FlowObjectExecutor.java:47)
at com.glide.sys.Transaction.executeWithTimeout(Transaction.java:3104)
at com.glide.plan.runners.FlowObjectExecutor.executeWithResponse(FlowObjectExecutor.java:47)
at com.glide.plan.runners.FlowObjectAPI.executeWithResponse(FlowObjectAPI.java:80)
at com.snc.templates.api.services.TemplateInstanceService.executeTemplateInstanceFlow(TemplateInstanceService.java:261)
at com.snc.templates.api.services.TemplateRunnerWorker.startWork(TemplateRunnerWorker.java:55)
at com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126)
at com.glide.worker.HierarchicalProgressWorker.startAndWait(HierarchicalProgressWorker.java:26)
at com.glide.worker.BackgroundProgressJob.execute(BackgroundProgressJob.java:59)
at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:139)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:142)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:126)
at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:334)
at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:225)
at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:225)
at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:101)
: no thrown error

[Joakim1]

I am experiencing the same error.
It looks like it has something to do with the Record producer. When I deleted it, I was able to use the template again

[satoru]

Thank you for your advice.
Unfortunately, the same error occurred after deleting the record producer.

[Joakim1]

I dug a little deeper, and I found that the sanity check goes through sys_metadata records related to your sys_app. If you open the application in Studio, then settings, you might be able to find the records that are causing issues, and delete them from the template. 

[Joakim1 · Accepted solution]

We just got our issue resolved with the help from SerivceNow.
We had to delete all sys_translated_text records where Document, Table Name and Field name is NULL.
https://<instance>.service-now.com/sys_translated_text_list.do?sysparm_query=documentkey%3DNULL%5Eta...

After deleting those we were able to create a new application from a template.

Hope that helps.