SAP Knowledge Base Article - Preview

2799257 - SUM nZDM FDC phase - transaction aborted - SAP ASE for Business Suite

Symptom

SUM migration to SAP ASE using nZDM option fails with the following error in phase MAIN_SHDRUN/SUBMOD_FDC_RUN2/RUN_FDCS_SEGMENT.
This is seen on SUM 1.0 only.

C ERROR: -1 in function free_curs_stmt (SQLFreeHandle) [line 50166]
C (277) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]There was a transaction active
C when exiting the stored procedure '*sq1219636507_1047082754ss*'. The temporary
C table '#SAP_FDC__1CRR_A000015244' was dropped in this transaction either explici
C tly or implicitly. This transaction has been aborted to prevent database corrupt
C ion.
C
C sql statement is ==> declare @stmt varchar(16384) declare @res_1 varchar(96) declare @old_1 varchar(
C 96) create table #SAP_FDC__1CRR_A000015244 ( "PHIO_ID" varchar(96)) select
C top 1 @old_1 = "PHIO_ID" from "/1CRR/A000015244" order by "PHIO_ID" while 1 =
C 1 begin set @stmt = 'select top 100000 ' || '@res_1 = "PHIO_ID" fro
C m "/1CRR/A000015244"' || ' where ( "PHIO_ID" > @old_1 ) ' || 'order
C by "PHIO_ID"' exec( @stmt ) if ( @old_1 = @res_1 ) or ( @res_1 is null
C ) break select @old_1 = @res_1 insert into #SAP_FDC__1CRR_A000015244 values
C ( @res_1) end select * from #SAP_FDC__1CRR_A000015244 drop table #SAP_FDC__1CRR_
C A000015244
C transaction aborted by server


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SUM 1.0

Product

SAP Solution Manager 7.1

Keywords

SUM, nZDM, MAIN_SHDRUN/SUBMOD_FDC_RUN2/RUN_FDCS_SEGMENT, "temporary table", FDC, , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.