If you are unable to create a new account, please email support@bspsoftware.com

 

Unable to import database function in FM using metadata wizard on 11.1.3

Started by Penny, 26 Nov 2019 09:16:46 AM

Previous topic - Next topic

Penny

I am unable to use the metadata wizard to import an oracle database function into a model.  I have done this many many times in previous version, but since the upgrade to 11.1.3, Framework Manager can import tables but not functions.  I don't receive an error code just a message that the object could not be imported.

We are using Oracle as a content store and as a datasource and have multiple custom functions from the database in our models.

Has anyone else experienced this issue, and if so have you managed to resolve it.

I have created a case with IBM but thought I would ask on this forum while I wait for IBM.

Thank-you

bus_pass_man

Are you sure that the functions are not actually there already?  I know that I get a message during import which will tell me that things could not be import which I have discovered I already had them in my model.

Open the search tool. set Search to project, class to function, and property to object name.  Enter a function name that you are looking for and press the search button.



Penny

Yes I did search for the function in the model first and am 100% sure that it was never there.  I am the only modeller here and keep track of functions that are added.
IBM has responded saying that it has also been report for a CQM report, we are using DQM but that is irrelevant to pulling the function into the model.  They suggested using an earlier version of FM to bring it in but I cannot do that.
Are others able to do this in 11.1.3?
Thank-you

Penny

I wanted to provide an update on this issue to everyone.  I created a case with IBM and demonstrated the problem via webex.  Framework Manager 11.1.3 will not import a function via the metadata wizard and no error is generated.  This has worked in previous versions from 10, 11.0 until 11.1.3.  IBM has promised an Interim Fix in the next month or so for this.  I am not sure if the problem persists in 11.1.4.

Thank-you

Penny

The fix for this is available now.  I downloaded it yesterday.

davesinner

Quote from: Penny on 06 Feb 2020 02:28:53 PM
The fix for this is available now.  I downloaded it yesterday.

Hi Penny, did you find any solution? Because, i am facing a similar problem. i can retrieve function list properly in fm with odbc datasource. But when i using jdbc datasource, missing some functions.
For example, Common functions, Business Date time functions or vendor specific functions. Only i see  four property. Operators, summaries, Member summaries, block functions. i installed 11.1.7,11.2.1,11.2.2,11.2.4. Nothing change