Support Article

BIX ExtractIdentifier and ExtractDateTime column not populated

SA-26998

Summary



User has a requirement where they need to populate two different embedded page lists to same Table in the Business Intelligence Exchange (BIX) Extract defined for a Work Class.

To achieve this functionality user has created a DB Synonym for one of the pagelist properties.

When the extract rule is run in QA environment the BIX ExtractIdentifier and ExtractDateTime column in the Synonym are not getting populated. However, the columns are getting populated in dev environment as expected.


Error Messages



Not applicable

Steps to Reproduce



1.Create a BIX extract rule for a work class to populate DB tables.
2.Add embedded page list properties to the extract rule.
3.Create a synonym for one of the pagelist properties to be mapped against in the extract rule.
4.Run the Extract Rule.


Root Cause



There is a known bug with Oracle JDBC drivers with handling synonyms when using getMetaData to get the database table details. 


Resolution



User is suggested to add the connection property includeSynoyms=true to their datasource.


 

Published August 19, 2016 - Updated August 30, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.