R98403 Broken w/ SP 11.3?

Guest

Guest
Has anyone run R98403 to Copy Tables from one Data Source (PRODDTA, PRODCTL) to another (CRPDTA, CRPCTL) under service pack 11.3 (B733.1) in an Oracle environment?

It seems that this service pack (or one of its predecessors between 7.1 and 11.3) has broken something that affects some tables. This process ran fine under 7.1 but under 11.3 there are some tables that it reports errors on. Research turns up that the data rows are copied across OK but errors occurred when dropping and re-creating indices. This only happens on a small number of tables out of the whole, but these include such tables as F03B11 (Customer Ledger), F0902 (G/L Acct Balances), F0911 (Account Ledger), etc.

There are many SARS out on the knowledge base about fixes to problems that "could" be causing this. Unfortunately all these fixes are applied to the B73.3.3 level only it seems.

Another serious thing that's occurring is that all Primary key indices (all tables copied) are created on the <DataSource>T tablespace instead of the <DataSourceI> tablespace with the result that a lot of space and I-O has been shifted.

We're looking for some validation from others with a similiar configuration/release level that this is an widespread problem before escalating the problem with JDE.

Sample Log Error message appears below:
Thanks In Advance for your input.

1252/1208 Wed Nov 15 14:53:55 2000 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - DROP INDEX CRPDTA.F03B11_1

1252/1208 Wed Nov 15 14:53:55 2000 DBPERFRQ233
OCI0000179 - Error - ORA-01418: specified index does not exist

1252/1208 Wed Nov 15 14:53:55 2000 jdb_drvm840
JDB9900170 - Failed to execute db request

1252/1208 Wed Nov 15 14:53:56 2000 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - DROP INDEX CRPDTA.F03B11_12

1252/1208 Wed Nov 15 14:53:56 2000 DBPERFRQ233
OCI0000179 - Error - ORA-01418: specified index does not exist

1252/1208 Wed Nov 15 14:53:56 2000 jdb_drvm840
JDB9900170 - Failed to execute db request

1252/1208 Wed Nov 15 14:53:57 2000 jdb_exem274
JDB2100007 - Failed to fetch record from Business Data - CRP

1252/1208 Wed Nov 15 14:53:57 2000 jdb_exem279
JDB2100008 - Loading default creation parameters

1252/1208 Wed Nov 15 14:54:01 2000 jdb_exem828
JDB2100016 - Failed to fetch record from datasource Business Data - CRP

1252/1208 Wed Nov 15 14:54:01 2000 jdb_exem833
Loading default creation parameters

1252/1208 Wed Nov 15 14:54:01 2000 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - DROP INDEX CRPDTA.F03B11_1

1252/1208 Wed Nov 15 14:54:01 2000 DBPERFRQ233
OCI0000179 - Error - ORA-01418: specified index does not exist

1252/1208 Wed Nov 15 14:54:01 2000 jdb_drvm840
JDB9900170 - Failed to execute db request

1252/1208 Wed Nov 15 14:54:04 2000 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - CREATE INDEX F03B11_12 ON CRPDTA.F03B11 (RPDOC ASC, RPDCT ASC, RPKCO ASC, RPSFX DESC) tablespace crpdtai storage ( pctincrease 0 )

1252/1208 Wed Nov 15 14:54:04 2000 DBPERFRQ233
OCI0000179 - Error - ORA-01408: such column list already indexed

1252/1208 Wed Nov 15 14:54:04 2000 jdb_drvm840
JDB9900170 - Failed to execute db request

1252/1208 Wed Nov 15 14:54:04 2000 jdb_exem571
Index perform request failed

1252/1208 Wed Nov 15 14:54:04 2000 jdb_exem573
JDB2100018 - Failed to create index 12 for table F03B11 in data source Business Data - CRP

1252/1208 Wed Nov 15 14:54:04 2000 K2PDFUtils1951
PRTPDF_EndDoc: Final PDF file:C:\B7\PrintQueue\R98403_WAG0021_D1001115_T145346667.pdf






Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11.0, Oracle SE 8.0.5<P ID="edit"><FONT SIZE=-1>Edited by ljones on 11/15/00 04:08 PM.</FONT></P>
 
ljones,
Look on Orales website for the error number that appears after ORA
in your error file. This should get you started in your troubleshooting
efforts. What version of Oracle are you using? Do you have all the
latest Oracle patches on your database???
Lisa Stinebuck
 
Back
Top