The below error can occur while doing the data source upload having type database i.e load the data from the database.

************
DEBUG com.tibco.mdm.session.repository.datasource.DataFragmentSsnBean - File name not found for DATAFRAGMENT:::39738
DEBUG com.tibco.mdm.workflow.engine.activities.MqActivityInstUploadDataSource - Validate returned : Status: = 1, Message = Unable to load the data from SQL to database
DEBUG com.tibco.mdm._UserTextFormatter - Missing resource for code = D:\MDM_HOME\MDM910\MDM\mdm\9.1\common\null (The system cannot find the file specified)
DEBUG com.tibco.mdm._UserTextFormatter - Missing resource for code = D:\MDM_HOME\MDM910\MDM\mdm\9.1\common\null (The system cannot find the file specified)
ERROR com.tibco.mdm.workflow.engine.MqWfProcessInst - Error while executing activity : D:\MDM_HOME\MDM910\MDM\mdm\9.1\common\null (The system cannot find the file specified): (Undefined)

[TIBCO EMS Session Dispatcher (909)] ERROR com.tibco.mdm.workflow.engine.MqWfProcessInst - Error reported in workflow:
<MqException: BEGIN>
Code: D:\MDM_HOME\MDM910\MDM\mdm\9.1\common\null (The system cannot find the file specified): (Undefined)
ID: 0A004B01_8A80CB816A82D43D016A82DF11D800B2
DATETIME: Sat May 04 18:13:38 IST 2019
STACKTRACE:     at com.tibco.mdm.workflow.engine.activities.MqActivityInstUploadDataSource.getNativeLoaderException(MqActivityInstUploadDataSource.java:425) 
    at com.tibco.mdm.workflow.engine.activities.MqActivityInstUploadDataSource.execActivity(MqActivityInstUploadDataSource.java:259) 
    at com.tibco.mdm.workflow.engine.MqProcessInst.execActivity(MqProcessInst.java:633) 
    at com.tibco.mdm.session.workflow.engine.activities.MqActivityInstSsnBean.execActivity(MqActivityInstSsnBean.java:120) 
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
    at java.lang.reflect.Method.invoke(Method.java:497) 
*************

The error states that the source is not available to load the data and filename i.e table name is not present in the datafragment table for that particular data load.

Cause:
=====
By looking at the datafragment table the sourcetablename is empty because of this the elink.log shows undefined i.e it takes the name as null.
=====
 

Product: TIBCO MDM Version: 9.x OS: All Supported Operating Systems

To resolve this issue update the datafragment table with correct sourcetablename i.e table name.

To get the datafragment id for particular datasource use the below query:

SELECT id FROM datafragment where name='DATASOURCE_NAME';

update  datafragment set sourcetablename='Table_Name' where id=XXXX;

commit;

where XXXX is the datafragment id of the datasource

Example: Suppose user have TEST_DB_LOAD datasource and table name DBLOAD

To get the datafragment id use the below query:

SELECT id FROM datafragment where name='TEST_DB_LOAD';

And the update the sourcetablename in the datafragment table using below query:

update  datafragment set sourcetablename='DBLOAD' where id=YYYY;

commit;

where YYYY is the datafragment id of the datasource.






 

Unable to load data using datasource format as database