Metadata Manager XI 3.1 Custom Attributes Issue

system · February 12, 2010, 9:38pm

BOE version 3.1 SP2 FP 2.3
MM version 3.1
Windows Server 2003 x64 SP2

We’re having an issue with adding custom attributes in MM because the drop down on the data type field isn’t working. I can see the drop down arrow, but it doesn’t expand, so we can’t select any of the type options. We’ve tried to manually type the values, but it doesn’t take. It’s like the LOV doesn’t exist for the drop down.

Has anyone else run into this issue? I haven’t been able to find anything out there anywhere, so I’m a little worried that SAP is just going to tell me to reinstall everything again…

Jesse Mauser (BOB member since 2003-04-03)

system · February 12, 2010, 10:34pm

was it working earlier ? or this is the first time you are trying to use this function ?

right click on the page on the list, and select view source, in the notepad search for following, and check if lists the datatypes
_getDataTypeOptions

the problem could be the datatypes are not loaded from MMRepo or browser has some issue displaying the drop down (script disabled etc)

also check if there is some error related to this getting logged in

\BusinessObjects Enterprise 12.0\Logging\MMExplorer*.log or MMCore*.log files

manoj_d (BOB member since 2009-01-02)

system · February 12, 2010, 11:14pm

We haven’t played with it in a very long time. The last time I remember it working was when we just moved to XI 3.0. We did a little POC, and everything seemed to work fine. Sense then, we haven’t really touched it, and have done multiple upgrades.

I’ll try your suggestions and let you know how it goes. Thanks for the ideas.

Jesse

Update:

And guess what… It’s all of a sudden working. I don’t have a clue what changed… I have some more work to do to see if I can replicate this thing in other environments.

Thanks for your time.
Jesse

Jesse Mauser (BOB member since 2003-04-03)

system · February 17, 2010, 6:58pm

And it’s happening again… I’ve looked at the ‘view source’ and I have the following entries:

}

function initCustomFieldsScripts(){

_setMessages();
setTransparentImageConfig("/bomm/images/transp.gif", "TransparentCovering");
setDataTypeOptions(_getDataTypeOptions());
setCustomDataTypes(_getCustomDataTypes());
       }

I’ve tried both IE and Chrome, and they behave the same. I’ve double checked all the security settings in IE, and went through and enabled all the script settings, but it doesn’t change the behavior.

As for the log files, it’s only logging the version info:

I’ll keep playing with it and update the tickets if SAP is able to come up with anything.

Thanks,
Jesse

Jesse Mauser (BOB member since 2003-04-03)

system · February 18, 2010, 5:33pm

the function is retuning null, the function should look something like as below. There is nothing wrong with the explorer

    function _getDataTypeOptions(){
         var data = [];
       
         option = ["Boolean","Boolean"];
         data.push(option);
       
         option = ["Decimal","Decimal"];
         data.push(option);
       
         option = ["Integer","Integer"];
         data.push(option);
       
         option = ["String","String"];
         data.push(option);
       
         option = ["URL","URL"];
         data.push(option);
       
         return data;
    }

The problem could be with the database query not returning any data, following is the query that is used to get the datatypes
select * from MMT_Type_Code a where a.type_code_cd=‘CFTY’

is your database server o which bomm repo is created restarted ?
does restarting tomcat resloves this issue ? last time when this issue disappeared was the tomcat restarted ?
What is the Application server you are using ? tomcat or any other Web Server?
What is the MM Repository Database Type ?

manoj_d (BOB member since 2009-01-02)

system · February 19, 2010, 12:20am

Thanks, that makes more sense.

Restarting tomcat worked. But I’d tried that before, in addition to rebooting the server, and it never worked before. I’m chalking it up to having SAP on the phone when I tried it.

I was able to query the BOMM repo just fine (SQL 2005), so I’ll just keep watching it, and see if I can find anything in the event logs to help explain when/why it gets out of sync.

Thanks for your help.
Jesse

Jesse Mauser (BOB member since 2003-04-03)

system · February 24, 2010, 5:57pm

I think I manged to reproduce the issue
are you opening Metadata Management Explorer from InfoView (Open -> Metadata Mangement Explorer) ?

I can see this issue, if I open the MM Explorer after restart of tomcat for the first time from InfoView
If I directly open the MM Explorer from Programs or Browser, I don’t see this problem

I am checking this in other systems, with different Authentication to see if its consistently reproducible, will create a bug for this

in this case I tried with WinAD

manoj_d (BOB member since 2009-01-02)

system · February 24, 2010, 6:35pm

Yes, WinAD for me as well. I was opening from infoview, and via it’s own link. Thanks for the help.

Jesse Mauser (BOB member since 2003-04-03)

system · February 25, 2010, 9:18pm

the issue is not related to authentication type, the problem happens if you open MMExplorer first from InfoView, after the tomcat restart

if you open MM Explorer first from Browser, and then use it from InfoView then this issue will not happen

have filed a bug and its fixed, most likely will be available in the Next FP of MM XI 3.1 (12.1.0.3)

manoj_d (BOB member since 2009-01-02)