MDM connect to ASE error

[Former Member]

Hi,

my database is ASE 157, When I created a repository, it reported such error, I have followed the instructions as the installation guide, can anyone help? thanks very much!

MDS log are:

2014-10-16T08:47:36.618,140291125999360,24,"SQL_ERROR SQLSTATE= ZZZZZ, ErrorCode= 911, Msg=[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Attempt to locate entry in sysdatabases for database 'casestudy_Z000' by name failed - no entry found under that name. Make sure that name is entered properly.

SQLSTATE= ZZZZZ, ErrorCode= 5701, Msg=[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'casestudy_m000'.

[junwu]

right click your mdm server --->DBMS settings....

[Former Member]

Hi Jun,

Thanks for your reply very much, I tried your way but there is no initialization option in the DBMS settings, please see below info, there is only a partition option.

[junwu]

change the value to 2, and click ok.

[junwu]

did you click the ok before? actually it is the initialization.

[Former Member]

I changed the partition to 2, but when I create repository, there is an error message in MDS log although the repository can be created successfully, please see error log below, can you have a look at it? Thanks!

ERROR message:

2014-10-17T02:13:36.642,140291146622720,23,"Creating Repository: tt, on DBMS Server: 10.173.3.81:5000",MDSAdminServer@CreateRep,XCatServer.cpp,1608,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

2014-10-17T02:14:29.262,140291146622720,24,"SQL_ERROR SQLSTATE= ZZZZZ, ErrorCode= 911, Msg=[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Attempt to locate entry in sysdatabases for database 'tt_Z000' by name failed - no entry found under that name. Make sure that name is entered properly.

SQLSTATE= ZZZZZ, ErrorCode= 5701, Msg=[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'tt_m000'.

   Schema 'tt_m000', use tt_Z000",MDSAdminServer@CreateRep,ODBC_DBConnection.cpp,566,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

2014-10-17T02:14:29.262,140291146622720,24,"ODBC_DBConnection::Exec2: Unexpected Exec error",MDSAdminServer@CreateRep,ODBC_DBConnection.cpp,503,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

2014-10-17T02:14:47.299,140291146622720,23,"Init Database Tag: tt10.173.3.81:5000SAP_ASE_2_16_7_3",MDSAdminServer@CreateRep,XCatDB.cpp,886,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

2014-10-17T02:14:47.527,140291146622720,23,"Mounted repository tt <10.173.3.81:5000 [SAP_ASE]> is available",MDSAdminServer@CreateRep,XCatDB.cpp,1041,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

2014-10-17T02:14:47.539,140291146622720,23,"Repository tt creation completed OK",MDSAdminServer@CreateRep,XCatServer.cpp,1713,MDSAdminServerCommand_CreateRep,,,server_user,tt <10.173.3.81:5000 [SAP_ASE]>,,,

[junwu]

error message is very clear, you haven't initialized your DB