Steffen, thanks very much for all the clarifications. By now, I have implemented a solution to work around the date transformation issue.
Regarding the Replication Manager issue, I am restating here a question that I have already posted in another message to this mailing list: Can I upgrade the SAPDB subsystem / layer of my SAP-R/3 application without uninstalling / reinstalling the entire SAP-R/3 "monster"? Or, to put it in another way, how can I replace / upgrade parts of the SAPDB setup (e.g. Replication Manager)? For example, can I install & use SAPDB Loader of Rel.7.4 on top of SAPDB, Rel.7.3? Regards, Panos Platon Tsapralis, SAP-R/3 Specialist, ABAP/4 Developer, Athens, GREECE, cell phone: +306936353566, telefax: +18019925665, [EMAIL PROTECTED], [EMAIL PROTECTED] ----- Original Message ----- From: "Schildberg, Steffen" <[EMAIL PROTECTED]> To: "'PanosPlaton@HoTMaiL'" <[EMAIL PROTECTED]> Sent: Tuesday, 18 February, 2003 15:56 Subject: RE: Replication Manager: SET DATE command. > Hi Panos, > > PanosPlaton@HoTMaiL [mailto:[EMAIL PROTECTED]] wrote: > > > > Steffen, the file 'repserver.log' mentions: > > > > "/ M ReplMan 7.3.0 Build 015-000-070-423" > > > > Even if I include the "VERSION" statement into my command > > file, nothing more > > gets posted into the "repserver.log" file. Please, keep in > > mind that my > > SAPDB setup is part of a SAP-R/3 installation (Mini SAP Web > > Application Server Test Drive). > > > The interesting part is the build number which is in your case: 15. So all > information is already displayed in the first information string. > That version is rather ancient. > Is it possible for you to upgrade the RepMan? > Is this a SAP customer installation? > > > Regarding the date transformation, the following error > > appears into the log > > file when I try to store date values into the database via Replication > > Manager: > > > > "/ E -25317: Constant must be compatible with column type and length > > (column: 'ERDAT')." > > > > Column "ERDAT" is defined as VARCHAR(8) (I can check this > > information using > > SQL Studio). For your convenience, I am attaching my command file (the > > version that produces the error, mentioned above) and a > > one-line subset of the ASCII data file. > > > Hmm, let me clarify that to understand you right. That means you're attempting > to store a date (say 08.01.2003) into a VARCHAR(8) column? That won't work even if you > specify the date format in your command. Dates are only transformed (as described in > my former mail for instance from external format EUR to internal DB format) if the field > in the data file is loaded into a column of data type DATE. Otherwise the RepMan (and > that's the case here) simply tries to load the 10 Byte value 08.01.2003 into a 8 Byte > VARCHAR column and fails. The behavior of RepMan at this point is correct. > To have the RepMan transform from EUR to INTERNAL your column ERDAT must be of > type DATE. > > Regards, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
