E1: ENV: UBE R98403 Fails to Copy Tables to Business Data - CRP Data Source - ODB0000164 Error: Cannot find the object "CRPDTA.Fxxx" because it does not exist or you do not have permissions. (Doc ID 974235.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

When attempting to copy Business data from DV to CRP, the following errors occur:

2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.326012 Jdbodbc.c8352        ODB0000164 - STMT:00 [42000][1088] [Microsoft][SQL Native Client][SQL Server]Cannot find the object "CRPDTA.F03012Z1.F03012Z1_1" because it does not exist or you do not have permissions.
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.326016 Jdb_drvm.c1116       JDB9900401 - Failed to execute db request
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.326018 Jdb_exem.c1709      JDB2100046 - Failed to drop index.
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.326022 Jdb_exem.c2058      JDB2100047 - Failed to drop index number 1 for table F03012Z1
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.373003 Jdbodbc.c8352        ODB0000163 - wSQLExecute failure. rc=-1
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.373005 Jdbodbc.c8352        ODB0000164 - STMT:00 [42S02][3701] [Microsoft][SQL Native Client][SQL Server]Cannot drop the table 'F03012Z1', because it does not exist or you do not have permission.
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.420006 Jdbodbc.c8352        ODB0000163 - wSQLExecute failure. rc=-1
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.435001 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.
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.435004 Jdb_drvm.c1116       JDB9900401 - Failed to execute db request
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.435006 Jdb_exem.c420        JDB21000091 - Failed to create table F03012Z1 in data source Business Data - CRP
2296/5756 WRK:Starting jdeCallObject Fri Dec 04 11:55:44.435030 tccopy.c577              TCE000009 - CopyTable create output table failed.  

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms