Datasource 0FI_AP_4 is not available in active version in Target Systems, When this is transported to target system the transport failed with error code 12. This is caused because of Inactive version of datasource exist in Target system. In this document, I will explain the problem and it’s correction.
Author(s): Sreekanth Surampally
Company: Accenture Inc
Created on: 21 Jun 2013
Transporting 0FIAP_4 datasource is resulting in error Code 12, with an error SAPSQL_ARRAY_INSERT_DUPREC exception CX_SY_OPEN_SQL_DB.
The current ABAP program “CL_RSAR_PSA===================CP” terminated.
System program terminates at the below line, trying to insert a field which is already there. RSTSODSFIELD is the System table, which contains datasource and it’s all
When transport is moved to target system, it is checking for the existance of datasource or PSA, if does not find trying to insert the record for the datasource in
RSTSODSFIELD database table, where as this table already has got this entry and unable to accept duplicate entry. So it is giving short dump.
Collecting the object again or re importing the request will not correct the problem.
Step by Step Solution
Step1:Check the datasource version in RSDS table, in target system.
It is not in active version. Check the datasource version in RSTSODS table, it is also shows inactive.
Step2: Execute the program RSDS_DATASOURCE_ACTIVATE_ALL, for the datasource and then check whether version in RSDS and RSTSODS table got
changed. If no change in the version, then proceed with next step.
Step3: Go to RSTSODS table, give the PSA name and manually change the OBJSTAT value from INA to ACT.
To do this step, you may go to debugging mode. first select the record and click display then clicking on /h on transaction bar and press enter. ABAP debugging session opens, double click on ‘CODE’ variable and modify the value to Change.
as in above screen, then press F7 or F8 you will get a screen to modify the record you selected. Modify the value to ACT and save it.
Step4: Re import the failed request into target system, it will go successful.
Related Content: SAP note 1703960