Skip to Content
avatar image
Former Member

MDM connect to ASE error

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'.

mdm_error1.PNG (7.1 kB)
error2.PNG (4.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2014 at 02:27 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2014 at 02:33 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jun Wu

      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]>,,,