From: Bumes, Hans-Georg (hans-georg.bumessap.com)
Date: Thu Nov 06 2003 - 06:27:19 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Matthias,

> I'm encountering a strange problem (WinXP, verified on Win2K) when trying to
> extract all data for a given user via the Sapdb loader. Maybe a simple
> oversight - I hope sombody can help. What I do is the
> following: I call the loader with "loadercli -b ofbizexport.dat"; the file
> "ofbizexport.dat" looks like this
>
> USE SERVERDB OFBIZ
> //
> USE USER OFBIZEK PASSWRD
> //
> TABLEEXTRACT USER DATA OUTSTREAM FILE 'C:\ofbizexp.dat'
>
> About 16 Megs of data are extracted to the specified file and then the
> process dies, actually the whole database instance gets
> killed; console
>
> // M Loader 7.4.3 Build 027-123-048-452
> // *
> ...
> TABLEEXTRACT USER DATA OUTSTREAM FILE 'C:\ofbizexp.dat' PAGES
> // *
> // M Number of tables to transform: 531
> ....
> // M EXECUTE PACKAGE TO TRANSFORM DATA
> // *
> // E -25009: Failure in db communication (receive): 4 = connection broken
> .
> // E -25801: Internal error [vls26_TETable.cpp, 1886, -25009]; contact
> technical support
> // E -25349: Error extracting PRIMARY data of table WORKFLOW_PARTICIPANT.

the tabledefintion of 'WORKFLOW_PARTICIPANT' contains more then one key column and at least one long column.
under this circumstance the kernel aborts as described in
http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1124516

as a workaround you can use the 'RECORDS' format of SAP DB Loader to extract your data.

USE SERVERDB OFBIZ
//
USE USER OFBIZEK PASSWRD
//
TABLEEXTRACT USER DATA OUTSTREAM FILE 'C:\ofbizexp.dat' RECORDS

Regards,
 Hans-Georg

--
Hans-Georg Bumes
SAP DB, SAP Labs Berlin
http://www.sapdb.org/

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]