WFA datasource failed "NULL supplied to NOT NULL column"
- Views:
- 206
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-workflow-automation-wfa
- Specialty:
- legacy
- Last Updated:
Applies to
Oncommand Workflow Automation 5.1.1 (WFA)
Oncommand Unified Manager 9.5 p1 (OCUM)
Issue
In WFA custom datasource fails with error "
NULL supplied to NOT NULL column 'resourcename'
"We are seeing the below error in WFA logs,
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