Question Re: IMPORT_PROPER PHASE ERROR in Technology Q&A

IMPORT_PROPER PHASE ERROR

former_member274353 — Mon, 10 Aug 2015 17:46:55 GMT

HI ,

During spam/saint upgrade showing error in phase import_proper any bdy help .

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 05:07:36 GMT

hi Sandeep,

Can you paste the Action logs from the SPAM tcode. you can see a spool icon to access the same.

Based on the error then we will be able to guide.

regrds,

Ram

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 05:11:07 GMT

Hi Sandeep,

Can you pl share the logs for the same..

Kind Regard's

Mirza Ismail.

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 06:03:13 GMT

Hello Dear,

Kindly reset the SPAM Queue and the try again and if possible restart OS.

To reset the queue go to SE37->put the OCS_RESET_QUEUE->Execute.

Then Put the value IV_TOOL=SPAM

IV_FORCE=X

Also check the SAP Note 822379.

If any, Let me know.

Thanks

Santosh Dwivedi

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 06:13:19 GMT

@Santosh,

This a not recommended way by SAP to reset the queue unless and untill its must.

So Sandeep try to fix it based on the error your seeing lot of recommendations will come up based on the logs.

So sandeep do update us if your still seeing issue and update us on the logs too.

Regards,

ram

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 06:24:47 GMT

Dear Ramkrishna,

I had already faced this issue earlier and resole it by as marked solutions.

For reseting of OCS queue also marked in sap note 822379.

You can check.

Regards

Santosh

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 07:10:18 GMT

Hi Sandeep,

1. Do not force reset the queue. SPAM do not allow you to reset the queue in this phase and there is a reason why this feature is stil there. Without proper handling, this can destroy your system. This is not a solution and also this is not supported by SAP.

2. Please check the Note, 1912676 , which provides more information about what kind of issues can occur in import_proper phase and how they should be handled.

In case you still are not able to resolve the issue, we would need more details to help you further.
Screenshot is just not enough to help here.

Thanks.

BR,
Gaurav

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Tue, 11 Aug 2015 09:54:49 GMT

HI ,

I have restart the whole system after restart checked spam status green and try again other support package but showing error

Re: IMPORT_PROPER PHASE ERROR

manumohandas82 — Tue, 11 Aug 2015 10:00:28 GMT

Hi Sandeep ,

Please traverse to /usr/sap/trans/log and post your ALOG and SLOG also the transport logs for the transport number SAPKD7408

Thanks ,

Manu

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 10:19:34 GMT

Hi Sandeep,

Also do confirm if you have RDDIMPDP job running successfully in system. and along with this tp & R3trans version are updated.

Regards,

Ram

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Tue, 11 Aug 2015 10:58:03 GMT

Hi ,

I have Updated Latest kernel and successfully run Job RDDIMPDP and attached SLOG and ALOG ,

I have attached rar file .

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 11:14:06 GMT

Hi Sandeep,

You mentioned that you restarted the system, and SPAM was green. A restart will not do this.
Was queue resetted with OCS_RESET_QUEUE in import_proper phase?

From the dumps, it says transformation is not active. however such thisng should not happen. This only happens due to aborted update attempt.

So I have few queries here.

1. What were the packages which you were trying to update in last attempt ?
2. How was issue in IMPORT_PROPER solved (How did SPAM become green).
3. Are packages in last queue already imported ?
4. What are the package in new queue which is being imported now ?

Thanks.

Best Regards,
Gaurav Pandey
SAP Product Support

Re: IMPORT_PROPER PHASE ERROR

manumohandas82 — Tue, 11 Aug 2015 11:14:26 GMT

Hi Sandeep ,

The files attached does not contain ALOG or SLog files . Take the last 100 lines formeach of the file and post it in a text file and attach the same .

Meanwhile check the following Note ( Under section Syntax Errors with object CL_OCS_RT_ANALYSIS )

1913676 - Troubleshooting guide for Support Package / Add-Ons Installations errors during the main import 'IMPORT_PROPER' phase in SPAM or SAINT

Thanks ,

Manu

Re: IMPORT_PROPER PHASE ERROR

Former Member — Tue, 11 Aug 2015 11:18:24 GMT

Hi,

I checked the attached logs and could see in log SAPID* log that error code was 16 . So definitely it was not successful. Reason of the isuse was that "ASE has run out of locks". So you have to simply
increase the limit and repeat the database.

BR,
Gaurav

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Tue, 11 Aug 2015 12:06:09 GMT

HI Gaurav ,

I am new sybase datbase please advise hot to incease the limit of ase

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Wed, 12 Aug 2015 05:40:32 GMT

HI Gaurav ,

I have checked current lock in my data base . so please advise how much i will have to increase the locks attached screen shoot

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Wed, 12 Aug 2015 05:56:35 GMT

HI Ramkrishna ,

As required attached action log file

Re: IMPORT_PROPER PHASE ERROR

Former Member — Wed, 12 Aug 2015 06:10:39 GMT

Hi Sandeep,

Kindly Upgrade SPAM version 58 first and then go to next patches....

Regard's

Mirza Ismail.

Re: IMPORT_PROPER PHASE ERROR

Former Member — Wed, 12 Aug 2015 06:19:09 GMT

Hello Sandeep,

As error coming in log file.

First upgrade the SPAM/SAINT version at level of 58 and above then try.

Regards

Santosh Dwivedi

Re: IMPORT_PROPER PHASE ERROR

former_member274353 — Wed, 12 Aug 2015 06:43:30 GMT

Hi Santosh ,

This error coming in spam/saint version same