Amien
Well Known Member
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
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