Installation Error - Phase "Import ABAP"

[jakobweimer]

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

[Former Member · Accepted solution]

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

[jakobweimer · Accepted solution]

Hello Anand,

thanks for your reply.

The Oracle export is in the same system and all users have full permissions.

Best regards

Jakob

[Former Member · Accepted solution]

Hello Jakob,

Can you please check following SAP note:-

709389 - Problems during load of SAPVIEW

Regards

Anand

[jakobweimer · Accepted solution]

Hi Anand,

at first this note sounds pretty good, but in my case there is only a missing column and not a whole table.

Kind regards

Jakob

[Johan_sapbasis · Accepted solution]

Hi Jakob,

Please review this note.

2147935 - How to analyze import issues on SAPVIEW package

Kind Regards,

Johan

[Former Member · Accepted solution]

Hello Jakob,

Please check following SAP:-

2069981 - SYB: Cannot drop primary key of table

Regards

Anand

[jakobweimer · Accepted solution]

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

[Johan_sapbasis · Accepted solution]

Hi,

I would think perhaps the QCM tables was not cleared on the export side beforehand. That would be my best guess.

You could always still confirm with SAP AG on an OSS Incident message if your timeframe allows.

Hope you manage to import successfully.

Regards,

johan

[Former Member · Accepted solution]

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

[Johan_sapbasis]

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

[jakobweimer]

Hello Johan,

thanks for your reply.

I got the export directly from our customer, i will ask them about the QCM table.

Attached you can find the requested files.

Kind regards,

Jakob

import_monitor.java.txt.zip

import_monitor.txt.zip

[Johan_sapbasis]

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

[jakobweimer]

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

[former_member182259]

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.