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 for Me (Login required).

Search for additional results

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