[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference utrop1::linkworks_v3

Title:LinkWorks V3.0 Notes Conference
Notice:LNX_APO = APO issues, LINKWORKS_V3 = V3.0 issues
Moderator:tacklr.apd.dec.com::TACK_Lm::TACK_L
Created:Tue Jun 28 1994
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2269
Total number of notes:8338

2122.0. "lnxbm problem with NTI/SQL German" by GENIE::16.184.48.160::genie::tschanz () Wed Feb 12 1997 15:33

Hi

We have problems with the lnxbm on NTI-Server with German language.

Server Versions:
================
NTI Server with V4.0 (Build 1381) German

MS SQL-Server V6.50.201 German (SQL-DMO V6.05.02, DB-Lib. V6.50.201)
LinkWorks V3.08 (December)
Regional Settings: Deutsch (Schweiz)
Short date: TT.MM.JJ
Long date: TTTT,T.MMMM JJJJ		

The backup is running as well with: lnxbm -bd:\lnxsave  but the restore 
of the cell goes wrong.


restore with lnxbm:
===================
lnxbm -r -bd:\lnxsave -ld:\lnxsave\restore.log  and start restore with 
option 3.

am and cm restore is ok!!

Starting restore of 'CELL1_1'

Dropping current database ........................... ok
Restoring database .................................. failed.


Backup Manager error: failed (is not a lot of information)

restore with dbu:
=================
dbu -od dCELL1_1 -v308 -L%OPROOT%\cell\db\layout -mcell -C
dbu -or dCELL1_1 -bd:\lnxsave\cl000001\db -ld:\lnxsave\dburestore.log

Restoring table dmpattern:			3 rows
Restoring table eingangsbuch		failed

Database restore failed
[Microsoft][ODBC SQL Server Driver][SQL Server]
Umwandlung von CHAR in DATETIME f�hrte zu einem DATETIME-Wert ausserhalb 
des
g�ltigen Bereichs.


Has anybody also a German configuration and has the backup verifyed

Thanks for your help

Toni
T.RTitleUserPersonal
Name		DateLines
2122.1Problem with DateTime data types with NTI/SQL GermanNETRIX::"[email protected]"Peter KellerWed Feb 26 1997 17:0066
Dear Toni,

I had the same problem with dbu on NTI-Server with German language
(I used dbu to migrate from a SCO UNIX-Server platform to NTI).

Server Versions:
================
NTI Server with V3.51 (Build 1057; Service Pack 5) German
Regional settings: Deutsch (Deutschland)
Dateformat: TMJ (for short and long format)
(calling date returns (e.g.: Mi 26.02.1997))

MS SQL-Server V6.00.121 German (SQL-DMO V6.0, DB-Lib. V6.00.128)
LinkWorks V3.07
Installed languages: English and German
Default language:    German

Using dbu to migrate the cell database failed for all non-empty tables
(e.g.: eingangsbuch, attrsuche, etc.) using the data type datetime
with the error message:

Database restore failed
[Microsoft][ODBC SQL Server Driver][SQL Server]
Umwandlung von CHAR in DATETIME f�hrte zu einem DATETIME-Wert 
ausserhalb des g�ltigen Bereichs.

After solving this problem by converting the corresponding *.dta files
I had the same problem by trying to manipulate user-defined LNX 
attributes of data type datetime.

If I tried to assign the value 12.02.1997 the attribute was set to
02.12.1997 and if I tried to assign the value 13.02.1997 the error
message 
[Microsoft][ODBC SQL Server Driver][SQL Server]
Umwandlung von CHAR in DATETIME f�hrte zu einem DATETIME-Wert 
ausserhalb des g�ltigen Bereichs.
was generated and no value was assigned to the attribute.

I checked the following master tables
* syslanguages:
- dateformat:    dmy
- name:          Deutsch

to make sure that every language information was set to German.

After using a simple LNX-Server script using the NOW()-function
to determine the current date and time on the Server I got the 
following suprising result:

WNT-Server: date:  Mi 26.02.1997
LNX-Script: Now(): 02-26-1997

I'm not sure if this is correct but I think that LNX is not able
to handle German date information. Therefore I changed the 
default language for the SQL-Logins omuser and omdba from <default>
to us_english and everything works fine.

Maybe this information can help to solve your problem.

 
Regards,
          Peter


	
[Posted by WWW Notes gateway]
2122.2I'll check this next weekGENIE::bike02.ebo.dec.com::genie::tschanzThu Feb 27 1997 09:187
Hi Peter,

Hm i'll check this next week.

Thanks for your answer.

Regards Toni