4 Replies Latest reply: Oct 31, 2013 5:25 AM by Rami Makram RSS

    Siebel 8.1.1 - DB configuration wizard errors.

    896312
      Good day!
      I am facing problems when i try to install new DB by config wizzard. Windows Server 2003, DB - SQL Server 2005
      ODBC - OK
      grantuser.sql - OK
      Siebel 8.1.1, Russian language.
      Help me please to resolve this problem.

      This is the log file :

      2011-10-26 11:15:28     [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.S_APP_VER'.

      2011-10-26 11:15:28     

      2011-10-26 11:15:28     S0002: [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.S_APP_VER'.

      2011-10-26 11:15:28     SQL Statement:
      select DB_SCHEMA_VER, NULLIF(0, 0), NULLIF(0, 0), CUSTOM_SCHEMA_VER, NULLIF(0, 0), APP_VER, COMMENTS, NULLIF(0, 0), {fn now()}, NULLIF(0, 0), 'N', NULLIF(0, 0), NULLIF(0, 0) from dbo.S_APP_VER

      2011-10-26 11:15:28     [Microsoft][SQL Native Client][SQL Server]The cursor was not declared.

      2011-10-26 11:15:28     

      2011-10-26 11:15:28     37000: [Microsoft][SQL Native Client][SQL Server]The cursor was not declared.

      2011-10-26 11:15:28     
      Unable to get schema version.
      Please verify that you have specified the correct Table Owner (dbo)
      and you have select access to the S_APP_VER table.

      2011-10-26 11:15:28     Unable to start common api.

      2011-10-26 11:15:28     Unable to start common api.

      2011-10-26 11:15:28     Error in initiate function..
        • 1. Re: Siebel 8.1.1 - DB configuration wizard errors.
          WSiebel-Oracle
          Hi,

          Please confirm if you have executed grantsql.sql and created users per information below:

          http://download.oracle.com/docs/cd/E14004_01/books/SiebInstWIN/SiebInstCOM_ConfigDB6.html#wp1327967

          Also confirm if you have provided correct tableowner (siebel) as below, item 15:

          http://download.oracle.com/docs/cd/E14004_01/books/SiebInstWIN/SiebInstCOM_ConfigDB9.html#wp1005245

          Hope it helps,

          Wilson
          • 2. Re: Siebel 8.1.1 - DB configuration wizard errors.
            896312
            Thank you for your answer, but this is first thing that i made.
            I created table S_APP_VER manualy and find this error:


            2011-10-26 15:22:58     Unable to get UTC System Preference.

            2011-10-26 15:22:58     Unable to start common api.

            2011-10-26 15:22:58     Unable to start common api.

            2011-10-26 15:22:58     Error in initiate function..

            2011-10-26 15:22:58     Elapsed time: 0 sec.

            2011-10-26 15:22:58     (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

            I'm pretty sure the problem is not in DB rights. I found this document:
            http://download.oracle.com/docs/cd/E14004_01/books/EAI2/EAI2_ExtBusComps10.html

            EBCs with non-English data require the Siebel S_APP_VER and S_SYS_PREF tables to be present in the external database.
            Siebel Business Applications use the UNICD_DATATYPS_FLG column of the S_APP_VER table to indicate whether the database is a Unicode database. A value of 8 means UTF-8, and Y means UTF-16. For Non-Unicode databases, the Enterprise DB Server Code Page system preference is also required to have the correct setting.
            For help with creating and populating these tables, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.

            But i can't find anything about structure of this tables.

            Edited by: 893309 on 26.10.2011 21:46
            • 3. Re: Siebel 8.1.1 - DB configuration wizard errors.
              mroshaw76
              Hi!

              I don't think EBCs play any part in this - assuming you're installing a new Siebel instance from the very beginning.

              It looks to me like you've specified DBO as the table owner, in the install wizard, instead of specifying SIEBEL. You should have created the SIEBEL user as part of running grantusr.sql.

              Regards,

              mroshaw
              • 4. Re: Siebel 8.1.1 - DB configuration wizard errors.
                Rami Makram

                I have exactly the same issue..

                 

                (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

                 


                Have you solved that?