WFA データソースが失敗しました " NULL が NULL ではありません "

最後の更新
PDFとして保存

Views:: 170

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa

Specialty:: om

Last Updated:

環境

OnCommand Workflow Automation 5.1.1 （ WFA ）

OnCommand Unified Manager 9.5 p1 （ OCUM ）

問題

WFA のカスタムデータソースがエラーNULL supplied to NOT NULL column 'resourcename' で失敗します。

WFA のログに次のエラーが表示されます。

2021-06-24 02:15:53,161 ERROR [org.jboss.as.ejb3.invocation] (Thread-2465 (ActiveMQ-client-global-threads)) WFLYEJB0034: EJB Invocation failed on component CacheJobWorkerImpl for method public abstract void com.netapp.wfa.cache.job.CacheJobWorker.loadFromExtractedFilesGlobalizeAndLoad(com.netapp.wfa.cache.execution.ETLRunner,boolean): javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException:

Failed to load from 'D:\Apps\NetApp\WFA\jboss\standalone\tmp\wfa\address=(host=hostname.com)(port=3306)(type=master)-cm_storage.annotation_block-9616876557522129577.dump' into wfa_staging.cm_storage_annotation_block

Caused by: com.netapp.wfa.util.SqlShellException:

Failed to load from 'D:\Apps\NetApp\WFA\jboss\standalone\tmp\wfa\address=(host=hostname.com)(port=3306)(type=master)-cm_storage.annotation_block-9616876557522129577.dump' into wfa_staging.cm_storage_annotation_block

Caused by: java.sql.SQLDataException: (conn=7781) Column set to default value; NULL supplied to NOT NULL column 'resourcename' at row 1