1800785 - Database Errors in Teradata Logs Generated by BODS 4 Scripts
1
SAP Knowledge Base Article Symptom When Using Scripts in Job , Job execution went fine , however on the target Terdatata DB the logs show additional messages like "User- generated transaction ABORT" or ROLLBACK statements. Environment SAP Data Services Resolution Duplicate rows error and Rollback errors are by design. We run the prepared sql to check the commit size acceptable to teradata db. This is done to set a commit size. The “too many end transactions error” is fixed and the fix for it should be coming out soon. Keywords BODS, BODI, DS, DI, Edge Header Data Product 1800785 - Database errors in Teradata logs generated by BODS 4 scripts Version 1 Validity: 13.12.2012 - active Language English Released On 13.12.2012 11:55:45 Release Status Released to Customer Component EIM-DS Data Services Priority Normal Category Problem Product Product Version SAP Data Services SAP Data Services 4.0
-
Upload
prasanna-kumar -
Category
Documents
-
view
217 -
download
2
description
1800785 - Database errors in Teradata logs generated by BODS 4 scripts
Transcript of 1800785 - Database Errors in Teradata Logs Generated by BODS 4 Scripts
-
SAP Knowledge Base Article
Symptom
WhenUsingScriptsinJob,Jobexecutionwentfine,howeveronthetargetTerdatataDBthelogsshowadditionalmessageslike"User-generated transaction ABORT" or ROLLBACK statements.
Environment
SAP Data Services
Resolution
DuplicaterowserrorandRollbackerrorsarebydesign.Werunthepreparedsqltocheckthecommitsizeacceptabletoteradatadb.Thisisdoneto set a commit size. The too many end transactions erroris fixed and the fix for it should be coming out soon.
Keywords
BODS, BODI, DS, DI, Edge
Header Data
Product
1800785 - Database errors in Teradata logs generated by BODS 4 scripts
Version 1 Validity: 13.12.2012 - active Language English
Released On 13.12.2012 11:55:45 Release Status Released to Customer Component EIM-DS Data Services Priority Normal Category Problem
Product Product Version
SAP Data Services SAP Data Services 4.0
![ITI7 Programación Web...t olinware0 IENTAS LIPGOP clirectc Escribe aquí para buscar XAMPPControl 5th 2019] XAMPP Control Panel v3.2.4 Logs Logs Logs Logs Help 09.15 p. m.](https://static.fdocument.pub/doc/165x107/602d7ab12c483e44a51a152d/iti7-programacin-t-olinware0-ientas-lipgop-clirectc-escribe-aqu-para-buscar.jpg)
