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>
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>