Error in report R890912

We are upgrading from JDE Xe (SP 18.1) to Peoplesoft enterprise one 8.10 on prototype. Successfully finished client and server package build. Running post-upgrade report R890912 and getting the following error. Thanks for your help

ODB0000164 - STMT:00 [42000][2760] [Microsoft][ODBC SQL Server Driver][SQL Server]Specified owner name 'CRPDTA' either does not exist or you do not have permission to use it.

4216/3184 Mon Oct 25 10:27:21.845 JDB_DRVM.C942
JDB9900401 - Failed to execute db request

4216/3184 Mon Oct 25 10:27:21.860 JDB_EXEM.C422
JDB21000091 - Failed to create table F0912 in data source Business Data - CRP

4216/3184 Mon Oct 25 10:27:21.860 JDB_RQ1.C7036
JDB2700007 - Failed to create non JDE table

4216/3184 Mon Oct 25 10:27:21.860 tcinit.c153
TCE009067 - JDB_AssignNonJDETablename failed for table F0912

4216/3184 Mon Oct 25 10:27:22.220 IPCMISC.C294
API ipcSawUnregisterProcV1 : process 4216 unregistered in entry 9

4216/3184 Mon Oct 25 10:27:22.235 RUNBATCH.C1228
Job of type UBE failed with rcode = 0

4216/3184 Mon Oct 25 10:27:22.251 RUNBATCH.C1282
Batch job 12 ended in error

Check to see if crpdta (owner) has dbo privileges in the database crp. Enterprise manager - > security -> Logins (tab to database permissions) database crp, highlight the row and then see if the db_owner box is checked. if not check it and re run the report.

Thanks for your help. I gave db_owner permission for CRP database and got the same error. Any help.

================
R890912_XJDE0001_D041027_T075555988.log
Opening UBE Log for report R890912, version XJDE0001
--UBE--[0]-- Start Time : 7:55:57
TCEngine Level 0 c:\b9\system\TCEngine\tcinit.c : TCE009067 - JDB_AssignNonJDETablename failed for table F0912
--UBE--[0]-- Unable to resolve AB Number for Send Message.
--UBE--[0]-- End Time : 7:55:59
UBE Job Finished with Error(s).
Increase Debug Level into your jde.ini to view the cause of this error.
==========
*************************jde.log***************************
1756/452 Wed Oct 27 07:55:26.493 jdb_ctl.c2803
Starting OneWorld

1756/452 Wed Oct 27 07:55:34.835 Env.cpp136
Solution Explorer Started

1756/1588 Wed Oct 27 07:55:55.968 jdekprnt.c1021
KNT0000119 - PRTTable_GetDefaultPrinterInfo failed to find printer: User: CRPDTA Host: WinClient

1788/1824 Wed Oct 27 07:55:58.912 JDBODBC.C7310
ODB0000163 - wSQLExecute failure. rc=-1

1788/1824 Wed Oct 27 07:55:58.912 JDBODBC.C7310
ODB0000164 - STMT:00 [42000][2760] [Microsoft][ODBC SQL Server Driver][SQL Server]Specified owner name 'CRPDTA' either does not exist or you do not have permission to use it.

1788/1824 Wed Oct 27 07:55:58.912 jdb_drvm.c942
JDB9900401 - Failed to execute db request

1788/1824 Wed Oct 27 07:55:58.912 jdb_exem.c422
JDB21000091 - Failed to create table F0912 in data source Business Data - CRP

1788/1824 Wed Oct 27 07:55:58.922 jdb_rq1.c7036
JDB2700007 - Failed to create non JDE table

1788/1824 Wed Oct 27 07:55:58.922 tcinit.c153
TCE009067 - JDB_AssignNonJDETablename failed for table F0912

1788/1824 Wed Oct 27 07:55:59.002 jdb_ctl.c6450
JDB9900155 - Failed to get non - zero AB Number.
*********************************************************

Hi Jenny, I did notice that the instructions say to login as the data source owner for these conversions. I'm not sure if you tried this? If you did sign in with crpdta, I would then try in query analzyer, logged as crpdta to make sure you can create a table. I looks like from the logs crpdta doesn't have permissions. Hopes this helps...
Matt

We're upgrading to 8.11 and receive the same error. Did you ever resolve this error?

Hi there,

Login to your SQL Server with CRPDTA, and try to create
any table on JDE_CRP. I'm pretty sure that your CRPDTA
login hasn't CREATE TABLE permissions.

Sebastian Sajaroff

Same error here, same UBE. PRODDTA is set up as database owner for PS_PROD, but I am getting exactly the same error. Upgrading 8.0 to 8.10. Any other ideas? Thanks.