Instal Plan & cpy demo data failed

[Amien]

Hi:

I installed JDE E1 9.0(32) under Wind2008 with SQL Server 2005 SP3. when I execute "Instal Plan" or "Copy demo data" I find this error in JDE.log :

When "Copy Demo Data"

860/2396 WRK:Starting jdeCallObject Thu Apr 19 13:58:43.495005 Jdbodbc.c8352
ODB0000164 - STMT:00 [42000][2760] [Microsoft][SQL Native Client][SQL Server]The specified schema name "CRPDTA" either does not exist or you do not have permission to use it.

860/2396 WRK:Starting jdeCallObject Thu Apr 19 13:58:43.495008 Jdb_drvm.c1115
JDB9900401 - Failed to execute db request

860/2396 WRK:Starting jdeCallObject Thu Apr 19 13:58:43.495010 Jdb_exem.c420
JDB21000091 - Failed to create table F40338 in data source Business Data - CRP

860/2396 WRK:Starting jdeCallObject Thu Apr 19 13:58:45.835006 Jdbodbc.c8352
ODB0000163 - wSQLExecute failure. rc=-1

860/2396 WRK:Starting jdeCallObject Thu Apr 19 13:58:45.835008 Jdbodbc.c8352
ODB0000164 - STMT:00 [42000][2760] [Microsoft][SQL Native Client][SQL Server]The specified schema name "CRPDTA" either does not exist or you do not have permission to use it.
............................................................................................................................................
............................................................................................................................................
............................................................................................................................................


From jdedebug.log

Entering jdeCloseDictionary
Exited jdeCloseDictionary with DDType 0
Entering JDB_InitBhvr
Exiting JDB_InitBhvr with Success (UserHandle 0C446108)
Removing Table...
Entering JDB_DropTable( Table = F0002 )
Entering JDB_DropTableOvrWithSpecs( Table = F0002 )
Entering JDB_InitUser with (AUTO commit mode)
Entering JDB_BeginTransaction (UserHandle 0C4464B0)
Exiting JDB_BeginTransaction with Success (UserHandle 0C4464B0)
Exiting JDB_InitUser with Success (UserHandle 0C4464B0)
Entering JDB_OpenTable(Table = F0002)
JDB9900245 - Failed to find F98611 in cache
JDB3100011 - Failed to get location of table F0002 for environment JDEPLAN
Exiting JDB_OpenTable(Table = F0002) with Failure
Entering JDB_FreeUser (UserHandle 0C4464B0)

When "Instal Plan"


732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:28.093008 Jdbodbc.c8352
ODB0000164 - STMT:00 [42000][2760] [Microsoft][SQL Native Client][SQL Server]The specified schema name "PY900" either does not exist or you do not have permission to use it.

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:28.093011 Jdb_drvm.c1115
JDB9900401 - Failed to execute db request

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:28.093013 Jdb_exem.c420
JDB21000091 - Failed to create table F983051 in data source Versions - PY900

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513006 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513008 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'JDE_PY900.PY900.F983051'.

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513010 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513012 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F983051, ODBC DSN WIN-GL113NH1WX1.

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513014 Jdbodbc.c3285
ODB0000027 - JDBODBC_DescribeTable failed. Table F983051.

732/3404 WRK:Starting jdeCallObject Thu Apr 19 16:55:29.513016 Jdb_drvm.c1026
JDB9900168 - Failed to initialize db request

 

[Sebastian Sajaroff]

Hi,

I strongly recommend you to contact a senior CNC to
run the installation.

You may sit next to him/her and learn the procedure.
Installing JDEdwards is far from being as straightforward
as installing MS Office or Ubuntu.

There are too many different steps affecting
Deployment Server, Workstations, Web Clients,
Database Servers, Web Servers, etc.

For your particular error :

Have you ran the Platform Pack on your database server?
Are your ODBC properly configured on the Deployment
server? (look under 32-bits ODBCs, not 64-bits)
Is your SQL client configured on the Deployment box?
What about JDE datasources on your Deployment JDE.INI?
And your Data Sources on the Planner environment?

 

[Amien]

</font><blockquote><font class="small">En réponse à:</font><hr />
For your particular error :
Are your ODBC properly configured on the Deployment
server? (look under 32-bits ODBCs, not 64-bits)

[/ QUOTE ]

H ;
just to this point, I use JDE E1 (32) in Win2008 x64 and x64 EnterpriseServer also under Win2008 with SQL Server 2005 SP3 64bit.
I must use the version of JDBC 3.0? 32 or 64?

 

[Sebastian Sajaroff]

32 bits

 

[Amien]

</font><blockquote><font class="small">En réponse à:</font><hr />
I strongly recommend you to contact a senior CNC to
run the installation.
You may sit next to him/her and learn the procedure.
Installing JDEdwards is far from being as straightforward
as installing MS Office or Ubuntu.
There are too many different steps affecting
Deployment Server, Workstations, Web Clients,
Database Servers, Web Servers, etc.
For your particular error :
Have you ran the Platform Pack on your database server?
Are your ODBC properly configured on the Deployment
server? (look under 32-bits ODBCs, not 64-bits)
Is your SQL client configured on the Deployment box?
What about JDE datasources on your Deployment JDE.INI?
And your Data Sources on the Planner environment?

[/ QUOTE ]

Hi :
For the first step, it is impossible to find an senior.

sur, I installed the platform pack in database server.
You find in attachment JDE.INI fr paltform pack(name=WINDS) and deplyement server(name=WIN-GL113NH1WX1.

In the passe I installed JDE E1 9.0 in Windows server 2003 32bitand it work.