Hello,
Im using SAP DB LOADER to get all the data from a Table to TextFile.
TABLE STRUCTURE :
CREATE TABLE ATG_MovCompl (
Ano smalLint,
Aplicacao char(3),
AreaID smalLint,
DocID decimal(7,0),
TipoDocID char(1),
LinhaID smalLint,
TipoTerceiro char(1),
Artigo char(40),
DescrResumida char(20),
Unidade char(16),
QtUnidade decimal(16,6),
Peso decimal(10,3),
Comprimento decimal(16,4),
Largura decimal(16,4),
Altura decimal(16,4),
IvaID decimal(1,0),
Taxa decimal(4,2),
PercDescCab decimal(5,2),
PercDescLin decimal(5,2),
Observacao char(40),
DescrDesc char(41),
AlternativoID char(25),
CritFactArmz char(1),
PrecoLido decimal(12,4),
PercDescCabLido decimal(5,2),
PercDescLinLido decimal(5,2),
InspeccaoID char(3),
RefFornID char(25),
DescrForn char(40),
MtvDevolID char(3),
DivPreco decimal(12,4),
VlrDivLiq decimal(12,2),
VlrDivDesc decimal(14,2),
VlrDivIva decimal(14,4),
Sequencia decimal(10,2),
Plano char(20),
GPRTransaccaoID integer)
NUMERO OF ROWS : 1 125 522
COMMAND:
DATAEXTRACT FOR DATALOAD TABLE ATG_MOVCOMPL
OUTFILE 'c:\Backup\restore.ssc' APPEND
OUTFILE 'c:\Backup\ATG_MOVCOMPL.DAT'
LSERVER stops after a then folwing error :
"The Instruction on "0x784a9789" references memory in "0x4354453e". The
memory cannot be "read".
Console Error Message :
"Replication server error (-4 : 'Connection broken')"
Output of "loader.prt" :
DATAEXTRACT FOR DATALOAD TABLE ATG_MOVCOMPL
OUTFILE 'c:\Backup\restore.ssc' APPEND
OUTFILE 'c:\Backup\ATG_MOVCOMPL.DAT'
// *
// M LOAD TRANSFORMATIONPACKAGE x''
// *
// M Number of tables to transform: 1
// *
// M Number of views to transform: 0
// *
// M Number of synonyms to transform: 0
// *
INSERT INTO TRANSFORMATIONMODEL ( PACKAGEGUID, STEPID, CMD, SEQ_NO, OWNER,
TABLENAME, TABLETYPE ) ( SELECT x'' , CMD_NO, CMD, SEQ_NO, OWNER,
TABLENAME, TABLETYPE FROM TEMP.LOA_SAVE_CATALOG_LS00 WHERE NOT
(TABLETYPE IN ('VIEW', 'SYNONYM') AND SEQ_NO > 0) )
// *
// E -25392: '[SAP AG][SQLOD32 DLL][SAP DB]Integrity constraint
violation;200 POS(1) Duplicate key.'
// E -25392: '200'
I Think thats all Information I Can Give...
Any Idea ????
Tanks,
Jo�o Rodrigues
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
