Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error running the Script

user4958421Aug 7 2009 — edited Aug 7 2009

hi,

I am trying to run a esscmd command on my laptop via cmd. I have the data file in my c drive and trying to import it using rulefile on essbase server.

**If i save the file on essbase server i am able to import it i think so i m not able to get wherein i should define the location of my datafile thats on my c drive???? Please help its urgent**

When i try to run it i get following error. Please let me know which step i m not getting right:

C:\Documents and Settings\Kapil>esscmd
Essbase Command Mode Interface - Release 9.3.1 (ESB9.3.1.0.0B181)
Copyright (c) 1991, 2007, Oracle and/or its affiliates. All rights reserved.

U.S. Patent Number 5,359,724
U.S. Patent Number 6,317,750

:::[0]->login
Login:

Host Node >localhost
User >admin
Password >password

[Fri Aug 07 09:26:23 2009]Local////Info(1051034)
Logging in user [admin]

[Fri Aug 07 09:26:23 2009]Local////Info(1051035)
Last login on Friday, August 07, 2009 9:23:11 AM

Available Application Database:
Demo
==> Basic
Sample
==> Basic
Sample
==> Xchgrate
Sample
==> Interntl
Sample_U
==> Basic
Samppart
==> Company
Sampeast
==> East
DMDemo
==> Basic
ASOsamp
==> Sample
Test
==> Test

localhost:::admin[1]->select
Select:

Enter application name >Test
Enter database name >Test
localhost:Test:Test:admin[1]->IMPORT
Import:

------ Data File Info ------

1) Local/Client Object
2) Remote/Server Object
3) File
4) SQL
Enter Data Source Location>1
Object name >Budgetdata

1) EXCEL
2) LOTUS WK1
3) LOTUS WK3
4) TEXT
5) LOTUS WK4
6) EXCEL UTF8
7) LOTUS WK1 UTF8
8) LOTUS WK3 UTF8
9) TEXT UTF8
10) LOTUS WK4 UTF8
Select Data File Type>4

------ Rules File Info ------

Specify Rules File ? (Y/N): >y

1) Local/Client Object
2) Remote/Server Object
3) File
Enter File Location>2
Rules file name >LodBud09

Abort on error ? (Y/N): >y

[Fri Aug 07 09:32:27 2009]localhost/Test/Test/admin/Error(1030208)
Application directory does not exist: Test

sts = 1030208 Import File = Budgetdata Rules File = LodBud09

Command Failed. Return Status = 1030208

Thanks!

Edited by: user4958421 on Aug 7, 2009 7:26 AM

This post has been answered by JohnGoodwin on Aug 7 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2009

Added on Aug 7 2009

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

1 comment

1,300 views