SRM-MDM Catalog DB initialization error...

[Former Member]

Hi SDN,

I'm trying to connect an MDM Server to to an database (MCOD with SRM 5.0) so that I can configure the SRM-MDM Catalog.

The thing is that I'm having some errors regarding the connection from MDM Console to MDM Server.

I start MDM Server (5.5 SP06 5.5.63.57) without problems under HP-UX IA64 11.31 and MDM Console under Windows connects without problems, but when I try to define DB Settings it stays in connection for a while (5 seconds) and then gave me an core dump and stops the mds server (????). The MDM Console message is "Socket error on device"

Oracle did not register anything.

Now I have two questions:

1. Is possivel to use SRM database to be used by MDM? There's some step that I missed out of MDM 5.5 installation guide?

2. The error is that I use MDM Console under windows? Is there an MDM Console for HP-UX? How can I Call it? With CLIX? But HOW?

I also tried the database initialization with clix

clix dbSetDBMSSetting dbserverhostname SID:o:system:manager TempTableSpaceName=PSAPTEMP

but it result in:

Database setting name, "TempTableSpaceName", was not found

Loading '/opt/MDM/LangStrings/CatMgrCommonCore.lang' (eng_US)...

Loaded 1407 strings from '/opt/MDM/LangStrings/CatMgrCommonCore.lang'

Error: 0xffab400a, Invalid setting name

TempTableSpaceName is the setting name in the guide.... I'm now a little confused with all this stuf!!

Thanks in advance,

Best Regards,

Pedro Rodrigues

[Former Member · Accepted solution]

clix dbSetDBMSSetting dbserverhostname SID:o:system:manager TempTableSpaceName=PSAPTEMP is not a d initialize command

just type clix on the command prompt and it would give you different options available wih clix.

[Former Member · Accepted solution]

Hi Gaurav,

you're right, what I need is to adjust PSAPTEMP

clix gave this

CLIX dbSetDBMSSetting MdsHostSpec DBMSHostSpec settingName=value [-D]

Modify one of the DBMS settings for the DBMS instance listed from

the dbGetDBMSSetting command. settingName must be entered exactly

do you know what is the correct settingName to do this?

Thanks and best Regards,

Pedro Rodrigues

[Former Member · Accepted solution]

Hi again,

here we are some more information about the core dump!!!

Core was generated by `mds-r'.

Program terminated with signal 10, Bus error.

BUS_ADRALN - Invalid address alignment. Please refer to the following link that helps in handling unaligned data: http://docs.hp.com/en/7730/newhelp0610/pragmas.htm#pragma-pack-ex3

warning: Load module /oracle/SID/102_64/lib/libclntsh.so has been stripped.

Debugging information is not available.

warning: Load module /oracle/SID/102_64/lib/libnnz10.so has been stripped.

Debugging information is not available.

warning: No unwind information found.

Skipping this library /opt/MDM/lib/libicudata.sl.30.

#0 0xc0000000001b6dd0:0 in getsockopt+0xb0 ()

from /usr/lib/hpux64/libxnet.so.1

hope it helps

Pedro

[Former Member · Accepted solution]

check the following

clix dbGetDBMSSetting hostname mdshostspec

what values does it shows you.....

The values that it would give can be used in the

dbSetDBMSSetting accordingly as you want

[Former Member · Accepted solution]

Hi Gaurav,

What should I introduce in mdshostspec parameter? this is not the MDS hostname?

thanks

Pedro

[Former Member · Accepted solution]

Pedro....

the clix without any option lists all this (in AIX atleast)

MdsHostSpec -- host:password

if no password

MdsHostSpec -- hostname

host is local host name or IP address

the colon and password are needed only if the mds is password controlled

DBMSHostSpec -- DBMSInstanceName:dbType:userName:password

DBMSInstanceName is determined by your DBMS naming conventions

dbType field is one of [m, o, s, d, i, z] for

MaxDB, Oracle, Sql Server, DB2, DB2_i5/OS, or

If you havent given any password for your mds server then you can just use the hostname

[Former Member · Accepted solution]

Gaurav,

you're right, sorry!!!

clix dbGetDBMSSetting hostname also needs the DBMSHostSpec, and when I execute it, MDS stops in the same way with an core dumped

/opt/MDM/bin/mds[56]: 13764 Bus error(coredump)

Loading '/opt/MDM/LangStrings/Networking2.lang' (eng_US)...

Loaded 20 strings from '/opt/MDM/LangStrings/Networking2.lang'

Error: 0x83000106, Socket error on receive

and core says

Core was generated by `mds-r'.

Program terminated with signal 10, Bus error.

BUS_ADRALN - Invalid address alignment. Please refer to the following link that helps in handling unaligned data: http://docs.hp.com/en/7730/newhelp0610/pragmas.htm#pragma-pack-ex3

warning: Load module /oracle/DRM/102_64/lib/libclntsh.so has been stripped.

Debugging information is not available.

warning: Load module /oracle/DRM/102_64/lib/libnnz10.so has been stripped.

Debugging information is not available.

warning: No unwind information found.

Skipping this library /opt/MDM/lib/libicudata.sl.30.

#0 0xc0000000001b6dd0:0 in getsockopt+0xb0 ()

from /usr/lib/hpux64/libxnet.so.1

Thanks

Pedro

[Former Member · Accepted solution]

Have you initialized your database

clix dbInitialize hostname:password DBMSHostSpec

DBMSHostSpec = DB instance:type:dbuser:password

where tyoe is o in your case.

Does it gets properly innitialized?

The server crash is a very frequent issue with MDM apart from Windows.On all UNIX flavors its not stable till now.Please open a message with SAP if you are using UNIX.

[Former Member · Accepted solution]

I couldn't initialize the database because of this core dump, the message is already oppened and in processing by SAP

thanks anyway!!

Best Regards,

Pedro Rodrigues

[Former Member · Accepted solution]

Hi all,

I was able to pass this issue, oracle client librarys were not acessible to user mdm, I'd to add it to sapsys group...

now I'm with this erro

***LOG Q0I=> NiPConnect: 127.0.0.1:59818: connect (239: Connection refused) [nixxi.cpp 2770]

there's only one result in an google search but non solution, did any one have any clue??

thanks

Pedro

[Former Member · Accepted solution]

SOLVED

We define the DBMS Server as the server hostname on MDM Console, and it should be the the Database SID ...

thanks all

[Former Member · Accepted solution]

Hi Pedro,

I am facing some issues starting MDM server, we have installed MDM 5.5 with Oracle 10.2.0.2 in HP UX 11.31 system, then we upgraded Oracle to 10.2.0.4, after this mdm is not starting.

When I mention /home/mdm_admin/mdm/mds $ mds start

It starts & withing few secs throws Bus Error - Core Dump.

We are able to start mdis & mdss

Do you have any idea over this.

Thanks & Regards

Rupali S

[Former Member · Accepted solution]

Hi Rupali,

could you check the if the user mdm as dba autorization and/or if it could access oracle client??

this was one of the issues that I had!!

I hope you could solve it with this

best regards,

Pedro