7 Replies Latest reply: Oct 29, 2012 12:58 PM by Ahsan Shah RSS

    Unable to create datawarehouse tables using DAC client

    919213
      Hi,

      We are facing error while creating data warehouse tables in DAC Client.

      Please find the below mentioned error message
      ----------------------------------------------------------------------

      =====================================
      STD OUTPUT
      =====================================
      CREATING SIEBEL DATABASE OBJECTS
      F:\DAC\bifoundation\dac\UTILITIES\BIN\DDLIMP /I N /s N /u infdomain /p ******* /c DB_DAC /G "SSE_ROLE" /f F:\DAC\bifoundation\dac/conf/sqlgen/ctl-file/oracle_bi_dw.ctl /b "" /K "" /X "" /W N
      Error while importing Siebel database schema.

      =====================================
      ERROR OUTPUT
      =====================================
      Siebel Enterprise Applications ODBC DDL Import Utility, Version 7.7 [18030] ENU
      Copyright (c) 2001 Siebel Systems, Inc. All rights reserved.

      This software is the property of Siebel Systems, Inc., 2207 Bridgepointe Parkway,
      San Mateo, CA 94404.

      User agrees that any use of this software is governed by: (1) the applicable
      user limitations and other terms and conditions of the license agreement which
      has been entered into with Siebel Systems or its authorized distributors; and
      (2) the proprietary and restricted rights notices included in this software.

      WARNING: THIS COMPUTER PROGRAM IS PROTECTED BY U.S. AND INTERNATIONAL LAW.
      UNAUTHORIZED REPRODUCTION, DISTRIBUTION OR USE OF THIS PROGRAM, OR ANY PORTION
      OF IT, MAY RESULT IN SEVERE CIVIL AND CRIMINAL PENALTIES, AND WILL BE
      PROSECUTED TO THE MAXIMUM EXTENT POSSIBLE UNDER THE LAW.

      If you have received this software in error, please notify Siebel Systems
      immediately at (650) 295-5000.

      F:\DAC\bifoundation\dac\UTILITIES\BIN\DDLIMP /I N /s N /u infdomain /p ***** /c DB_DAC /G SSE_ROLE /f F:\DAC\bifoundation\dac/conf/sqlgen/ctl-file/oracle_bi_dw.ctl /b /K /X /W N

      Connecting to the database...
      Unable to connect to the database...

      ---------------------------------------------------------------

      I have established ODBC connection using Oracle client driver and able to connect with the oracle server.
      Oracle DB & client Version : 11.2.0.2- 64 bit
      DAC Version : 10.1.3.4.1
      Informatica version : 9.0.1
      OBIA : 7.9.6.3

      Can someone please help me to resolve this issue?


      Thanks,
      Prasanna