Hi Florian, [Florian K�rner wrote]
> Subject: Error using replication manager > > I use the command repmcli to fill an existing table with rows > from another > table with an identical schema. I use the command TABLELOAD > in my script > with a file that was successfully created with TABLEEXTRACT. > I get an error and logfile "repserver.log" says: > > TABLELOAD TABLE tab_tislot_role INFILE > '/opt/sapdb/tislot_replication_files/tab_tislot_role.rep' OUTFILE > '/opt/sapdb/tislot_replication_files/loadlog.rep' > > / * > / E -25011: Error executing internal SQL statement 'DELETE > "TAB_TISLOT_ROLE"': 'SQL error -115 = Table is read only > (error position: 1) > '. > / E -25801: Internal error [28_1, 2119, -9014]; contact > technical support > / E -25801: Internal error [28_1, 1444, -25801]; contact > technical support > / M Releasing user connection (USER: 'TISYS'). > / * > > > I can't figure out what's wrong, and why is the rep manager doing the > DELETE? > Ooops, the docs miss an important feature: The table must be empty to run TABLELOAD successfully. To ensure this RepMan tries to delete all rows if the table is filled instead of issuing an error message and stopping processing (we'll change that with one of the next versions to 'issue an error'). That's why it tries to delete. The state 'read only' is set if you either loaded the table already using FASTLOAD or another TABLELOAD. To reset the state you need to backup the db. HTH Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
