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
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.
SAP Knowledge Base Article - Preview