on 07-29-2015 9:40 AM
Hello Experts,
i am trying to install a EHP 6 for SAP ERP 6.0 on a Windows Server 2012 R2 using a Sybase ASE 15.7.132 out of an customer export (Oracle DB).
At the last "Import ABAP" job i am getting the following error message:
Looking at the "SAPVIEW log" file i found this message:
(DB) ERROR: DDL statement failed
(DROP VIEW "/CNV/9000401344C")
DbSlExecute: rc = 103
(SQL error 3701)
error message returned by DbSl:
[ASE Error SQL3701][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot drop the view '/CNV/9000401344C', because it doesn't exist in the system catalogs.
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) ERROR: DDL statement failed
(CREATE VIEW "/CNV/9000401344C" ( "MANDT" , "VROWID" , "BNAME" , "AENNR" , "DOKAR" , "DOKNR" , "DOKTL" , "DOKVR" , "EQUNR" , "MATNR" , "TPLNR" , "KLART" , "VBELN" , "PSPNR" ) AS SELECT T0001."MANDT", T0001."ROWID", T0001."BNAME", T0001."AENNR", T0001."DOKAR", T0001."DOKNR", T0001."DOKTL", T0001."DOKVR", T0001."EQUNR", T0001."MATNR", T0001."TPLNR", T0001."KLART", T0001."VBELN", T0001."PSPNR" FROM "USROBJECTS" T0001)
DbSlExecute: rc = 100
(SQL error 207)
error message returned by DbSl:
[ASE Error SQL207][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name 'ROWID'.
D:\usr\sap\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 598 error(s)
Are there any suggestions on how to fix this problem?
Please let me know if you need any further informations.
Best regards
Jakob
Hello Jakob,
Have you tried to give full permission to Oracle export for user who is installing.(Windows\administrator)
If possible place the Oracle export in the same system and try.
Regards
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jakob,
Can you please check following SAP note:-
709389 - Problems during load of SAPVIEW
Regards
Anand
Hello Jakob,
Please check following SAP:-
2069981 - SYB: Cannot drop primary key of table
Regards
Anand
Hi Johan,
thank you very much.
This note describes exactly our problem.
The field does not exist in source system, so i´ll set all "err" flags to "ign".
But how could it be, that 595 views point to a not existing field???
Kind regards,
Jakob
Jakob,
The sap note 709389 - Problems during load of SAPVIEW mentions the same but the note suggested Johan is more suitable and gives elaborate explanation too.
Thanks for letting us know.
Regards
Anand
Hi Jakob,
Check the notes.
Note 82478 - SAP system OS/DB migration
Note 1772967 - FAQ - Important SAP Notes - Sybase ASE
Note 1680803 - SYB: Migration to SAP Sybase ASE - Best Practice
Note 1799291 - SYB: Inst.Systems Based on NW 7.0 incl. EHPs: SAP Sybase ASE
Also check the following:
http://scn.sap.com/docs/DOC-36157
My question would be did you delete QCM table directly before export?
Secondly can you please attach the files import_monitor.java.log and import_monitor.log as per your error screenshot.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jakob,
I see someone else had the same problem with note 1716201 - SYB:Update control.xml files for installation: Sybase ASE as the solution.
However I see the note is not currently publicly released.
Did the customer perhaps export with option decluster/depool and you import without this option or vice versa perhaps?
Kind Regards,
Johan
Hi Johan,
do you have accesss to note 1716201?
I found this thread https://scn.sap.com/thread/3360385 including a new control.xml but i am not sure if this file is still working.
It´s possible that our customer did the export with the decluster option,
but i think there is no option to select / deselect this option at the import?
Kind regards,
Jakob
Check the definition of USROBJECTS and make sure it has the column "ROWID". The other thing that might be a cause is if you are simply trying a system copy instead of a migration. If you try a system copy, it doesn't handle the schema's correctly between DBMS's and things go amok quickly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.