Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Athens, Greece
    Posts
    6

    Unanswered: DWC07356E rc=7356 connect Essbase server

    Hello to everyone,
    I know that this error has been displayed again but it was for another situation.
    This rc stands for many cases.
    Anyway my problem is this:
    DWC07356E An agent's processing of a command of type "runUDP" failed for edition "0" of step "Currency Dimension - Update CRM Cube".
    Error calling EssBuildDimension. See file ess53.err for more information.See the trace file for details.
    RC = 7356 RC2 = 8410

    I forgot to mention that db2 is trying to connect to an Essbase server in order to get the Dim Rules Files

    Any ideas will help
    Thank you in advance
    Niki
    Last edited by Niki Karavoulia; 05-08-03 at 08:30.

  2. #2
    Join Date
    May 2003
    Location
    Athens, Greece
    Posts
    6

    Failed to Establish Connection With SQL Database

    This is the trace file which i get when i test the user defined programm .

    essotl2 is starting
    Argc=10.
    Database Userid=mmmm, Password=XXXXXX
    Rules file: TimeDim, local = 0
    Essbase: server=INFOTECH, application=PROFIT, database=Pd_Prof, User=mmmmm, Password=xxxxxxxxxN
    Error File=ess162.err
    Calling EssInit...Started Mon May 12 13:22:55 2003

    Calling EssLogin...Started Mon May 12 13:22:55 2003

    Essbase Error: Level: 2, Number 1051034
    LogString=[Mon May 12 13:22:55 2003]Local////Info(1051034)
    MessageString=Logging in user olapadmin
    Essbase Error: Level: 2, Number 1051035
    LogString=[Mon May 12 13:22:55 2003]Local////Info(1051035)
    MessageString=Last login on Mon May 12 11:15:39 2003
    Essbase Error: Level: 2, Number 1051036
    LogString=[Mon May 12 13:22:55 2003]Local////Info(1051036)
    MessageString=1 unsuccessful attempt(s) since last login
    Calling EssGetVersion...Started Mon May 12 13:22:55 2003

    Essbase Application Server - Version 6.0.0
    Calling EssSetActive...Started Mon May 12 13:22:55 2003

    Calling EssCreateLocalContext...Started Mon May 12 13:22:57 2003

    Calling EssBuildDimension...Started Mon May 12 13:22:57 2003

    Essbase Error: Level: 2, Number 1019018
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Info(1019018)
    MessageString=Writing Parameters For Database [Cst_Prof]
    Essbase Error: Level: 2, Number 1021003
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Info(1021003)
    MessageString=Connection String for [CYPRUSDW] is generated
    Essbase Error: Level: 2, Number 1021006
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Info(1021006)
    MessageString=SELECT Statement [SELECT * FROM PROFIT_TIME_DIMENSION] is generated
    Essbase Error: Level: 2, Number 1021013
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Info(1021013)
    MessageString=ODBC Layer Error: [08001] ==> [SQ30080 - Communication error occurred during distributed database processing.]
    Essbase Error: Level: 2, Number 1021014
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Info(1021014)
    MessageString=ODBC Layer Error: Native Error code [30080]
    Essbase Error: Level: 4, Number 1021001
    LogString=[Mon May 12 13:23:11 2003]INFOTECH/PROFIT/Pd_Prof/olapadmin/Error(1021001)
    MessageString=Failed to Establish Connection With SQL Database Server. See log file for more information
    EssBuildDimension error: 1021001
    See file ess162.err (if exists) for more information

  3. #3
    Join Date
    May 2003
    Location
    Athens, Greece
    Posts
    6
    we managed to find a solution to our problem

    anyway i want to thank you for your attention

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Could you be so kind and share the solution with as.

    Grofaty

  5. #5
    Join Date
    May 2003
    Location
    Athens, Greece
    Posts
    6

    Of course...

    Good morning Frofaty
    First of all I must explain that we have two Essbase servers one for test and one for live. Test was made copy of Live, and when I tried to establish connection through data warehouse center, the connection string still led to Live...even though i had changed everything in the configuration files and in the udp of DWC.
    The solution was that I erased the files in the essbase server and I created the rule files again. Then I tested it from DWC and it is working..

    With respect
    Niki

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •