Hi Red1,
I already tested the winenv.js, RUN_Setup.bat file Please see the below is the output.
I already able to run the Compiere application directly without any problem
When I try to run the application from the eclipse I am facing this problem.
C:\Compiere2\utils>RUN_Env.bat
Setting myEnvironment ....
1 file(s) copied.
General ...
PATH = C:\oracle\product\10.1.0\Db_1\bin;C:\oracle\product\10.1.0\Db_1\jre\
1.4.2\bin\client;C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin;C:\PROGRAM FILES\TH
INKPAD\UTILITIES;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Prog
ram Files\ATI Technologies\ATI Control Panel;C:\Program Files\PC-Doctor for Wind
ows\services;C:\jboss-3.2.3\bin;C:\apache-ant-1.6.1\bin;C:\j2sdkee1.3.1\bin;C:\j
2sdk1.4.2_04\bin;C:\PROGRA~1\cvsnt;
CLASSPTH = "C:\Compiere2\lib\CClient.jar;C:\Compiere2\lib\CTools.jar;C:\Compier
e2\lib\oracle.jar;C:\Compiere2\lib\jPDFPrinter.jar;"
.
Homes ...
COMPIERE_HOME = C:\Compiere2
JAVA_HOME = C:\j2sdk1.4.2_04
COMPIERE_DB_URL = jdbc:oracle:thin:@SCE29:1521:scinetic
.
Database ...
COMPIERE_DB_USER = compiere
COMPIERE_DB_PASSWORD = compiere
COMPIERE_DB_PATH = oracle
.. Oracle specifics
COMPIERE_DB_TNS = scinetic
COMPIERE_DB_SYSTEM = scinetic
C:\Compiere2\utils>C:\j2sdk1.4.2_04\bin\java -version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-b28)
Java HotSpot(TM) Client VM (build 1.4.2-b28, mixed mode)
.
Java Version should be "1.4.1"
---------------------------------------------------------------
Press any key to continue . . .
.
---------------------------------------------------------------
Database Connection Test (1) ... scinetic
If this fails, verify the COMPIERE_DB_TNS setting with Oracle Net Manager
You should see an OK at the end
Press any key to continue . . .
C:\Compiere2\utils>tnsping scinetic
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 17-MAR-2
005 09:09:35
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SCE29)(P
ORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = scinetic.scine
tic.com)))
OK (20 msec)
.
---------------------------------------------------------------
Database Connection Test (3) ... system/scinetic in C:\Compiere2\utils\oracle
If this test fails, verify the system password in COMPIERE_DB_SYSTEM
Press any key to continue . . .
C:\Compiere2\utils>sqlplus system/scinetic@scinetic @C:\Compiere2\utils\oracle\T
est.sql
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Mar 17 09:09:39 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
CONNECTION
-----------
Success
Disconnected from Oracle Database 10g Release 10.1.0.2.0 - Production
.
---------------------------------------------------------------
Checking Database Size
Press any key to continue . . .
C:\Compiere2\utils>sqlplus system/scinetic@scinetic @C:\Compiere2\utils\oracle\C
heckDB.sql compiere
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Mar 17 09:09:57 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
no rows selected
MISSING
------------------------------------------------------------
Tablespace INDX does not exist - You need to create it first
no rows selected
old 1: INSERT INTO &1..AD_System
new 1: INSERT INTO compiere.AD_System
old 8: (SELECT * FROM &1..AD_System WHERE AD_System_ID=0)
new 8: (SELECT * FROM compiere.AD_System WHERE AD_System_ID=0)
0 rows created.
old 1: UPDATE &1..AD_System
new 1: UPDATE compiere.AD_System
old 9: || ',C#=' || (SELECT COUNT(*) FROM &1..AD_Client)
new 9: || ',C#=' || (SELECT COUNT(*) FROM compiere.AD_Client)
1 row updated.
Commit complete.
Resize:
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 10g Release 10.1.0.2.0 - Production
.
---------------------------------------------------------------
Database Connection Test (4) ... compiere/compiere
This may fail, if you have not imported the Compiere database yet - Just enter E
XIT and run this script again after the import
Press any key to continue . . .
C:\Compiere2\utils>sqlplus compiere/compiere@scinetic @C:\Compiere2\utils\oracle
\Test.sql
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Mar 17 09:10:47 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
CONNECTION
-----------
Success
Disconnected from Oracle Database 10g Release 10.1.0.2.0 - Production
.
Done
Press any key to continue . . .
C:\Compiere2\utils>
I also complete the testing in the C:\Compiere\Compiere-all folder RUN_Setup.bat the result is the same. Tablespace INDX does not exist - You need to create it first
Any problem in the above line.