WFA 数据源出现故障 "NULL supplied to not NULL column"

最后更新
另存为PDF

Views:: 23

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