20.02.2014, 05:46
#1
Разбирающийся
Не стартует old база: Database not loaded due to error(s)
Стоит SH4, Версия программы 4.89, версия склада 4.92
Так вот, у меня 2 базы, одну когда-то свернули и изредка к ней обращались, потом уже давно забросили и работали в новой базе. Сейчас понадобилось посмотреть старую базу, а сервер с этой базой не может стартануть, хотя другой сервер с новой базой стартует нормально.
Вот логи проблемного сервера:
——————————-
20.02.2014 10:22:15- Server started
version=1.30
subkey=SDB2
def working set size min=204800, max=1413120
max cache memory=1024 pages (4096 K)
20.02.2014 10:22:15- Loading datafile: C:UCSSDBSrvDatabase11goddueti.sdb (datalog=C:UCSSDBSrvDatabase11goddueti.sdl)
20.02.2014 10:22:15- Loading library: C:UCSSDBSrvshtrans.dll
20.02.2014 10:22:15- Error- Code=142, Win32 error=0, Info=262228, Text=4.51.
20.02.2014 10:22:15- Database not loaded due to error(s).
20.02.2014 10:22:17- Server stopped
———————————
Вот с этого ярлыка запускаю: C:UCSSDBSrvSdbserv.exe /nSDB2
———————————
Вот SdbsConf: C:UCSSDBSrvDatabase11goddueti.sdb
C:UCSSDBSrvDatabase11goddueti.sdl
———————————
Старая и новая база в одном каталоге располагаются-с правами все нормально. Пробовал копировать базу в другой каталог для проверки-такая же ошибка. Вспоминал, что могло этому предшествовать…..вспомнил, что когда-то делали обновление SH4 для того, чтобы появилась алкогольная декларация-может быть причина в этом? или куда копать?
22.02.2014, 23:24
#4
Разбирающийся
У вас возможно память полетела.
Шмелев Дмитрий.
Программы под заказ. Разработка модулей для взаимодействия с RKeeper, StoreHouse, Premiera и другими системами автоматизации от UCS и не только.
e-mail: bytes.child@gmail.com
тел. Оренбург: +7-905-888-2161
тел. Москва: +7-915-498-3421
Hi,
I am trying to load data using SQL Loader but getting below error.
Table to be loaded —
CREATE TABLE TEST_PIPE_SEP (FILE_NAME VARCHAR2(3000), KEY_COL VARCHAR2(4000), DESCR VARCHAR2(100), RUN_DATE DATE );
I am creating dynamic CTL file using Shell and SED command so that I can get the current processing file and pass it as default value for the FILE_NAME column
#!/bin/ksh
echo "starting script"
#cd data
for i in data/Key_Mismatch_Output_UAT*.csv
do
#echo "$i"
filename=`basename "${i}"`
echo "$filename"
#sed '1d' "$i" >> test.csv
sed -e "s/#file_name#/file_name "${filename}",/g" test.ctl > new_test_3.ctl
sqlldr ERRORS=100000 userid=$USER_CRED control=new_test_3.ctl data=data/$filename silent=all log=data/$filename".log" bad=data/$filename.bad skip=1
wait
done
echo "ending script"
The format of test.ctl is as below which I am editing on run time using SED to pass the current processing file name —
LOAD DATA
CHARACTERSET WE8ISO8859P1
APPEND
INTO TABLE TEST_PIPE_SEP
FIELDS TERMINATED BY ','
(
#file_name#
key_col "trim(:key_col)",
descr "trim(:descr)",
run_date "SYSDATE"
)
The new file which will get created after the SED commend is as below —
LOAD DATA
CHARACTERSET WE8ISO8859P1
APPEND
INTO TABLE TEST_PIPE_SEP
FIELDS TERMINATED BY ','
(
file_name "Key_Mismatch_Output_UAT.csv.20170804070448.1_LIVE.csv.20170804070448.2_20170804070448.csv",
key_col "trim(:key_col)",
descr "trim(:descr)",
run_date "SYSDATE"
)
The CSV file and its contains —
Key Columns,Description
"C"|"G000053929"|"ABCD"|"G000053929"|""|""|"TTA"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file1
"C"|"G000053621"|"HGHQ"|"G000053621"|""|""|"CBI"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file2
"C"|"G000053929"|"HGHQ"|"G000053929"|""|""|"TTA"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file2
and I am getting below error and not able to find the route cause tried changing the CTL file as much as possible but not able to load data
Table TEST_PIPE_SEP, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
FILE_NAME FIRST * , CHARACTER
SQL string for column : "TRIM('Key_20170804070448.csv')"
KEY_COL NEXT * , CHARACTER
DESCR NEXT * , CHARACTER
RUN_DATE NEXT * , CHARACTER
SQL string for column : "SYSDATE"
Table TEST_PIPE_SEP:
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Please ask me if more information is required.
I am using
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 — 64bit Production
I am trying to load data using SQL Loader but getting below error.
Table to be loaded —
CREATE TABLE TEST_PIPE_SEP (FILE_NAME VARCHAR2(3000), KEY_COL VARCHAR2(4000), DESCR VARCHAR2(100), RUN_DATE DATE );
I am creating dynamic CTL file using Shell and SED command so that I can get the current processing file and pass it as default value for the FILE_NAME column.
#!/bin/ksh
echo "starting script"
#cd data
for i in data/Key_Mismatch_Output_UAT*.csv
do
#echo "$i"
filename=`basename "${i}"`
echo "$filename"
#sed '1d' "$i" >> test.csv
sed -e "s/#file_name#/file_name "${filename}",/g" test.ctl > new_test_3.ctl
sqlldr ERRORS=100000 userid=$USER_CRED control=new_test_3.ctl data=data/$filename silent=all log=data/$filename".log" bad=data/$filename.bad skip=1
wait
done
echo "ending script"
The format of test.ctl is as below which I am editing on run time using SED to pass the current processing file name —
LOAD DATA
CHARACTERSET WE8ISO8859P1
APPEND
INTO TABLE TEST_PIPE_SEP
FIELDS TERMINATED BY ','
(
#file_name#
key_col "trim(:key_col)",
descr "trim(:descr)",
run_date "SYSDATE"
)
The new file which will get created after the SED commend is as below —
LOAD DATA
CHARACTERSET WE8ISO8859P1
APPEND
INTO TABLE TEST_PIPE_SEP
FIELDS TERMINATED BY ','
(
file_name "Key_Mismatch_Output_UAT.csv.20170804070448.1_LIVE.csv.20170804070448.2_20170804070448.csv",
key_col "trim(:key_col)",
descr "trim(:descr)",
run_date "SYSDATE"
)
The CSV file and its contains —
Key Columns,Description
"C"|"G000053929"|"ABCD"|"G000053929"|""|""|"TTA"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file1
"C"|"G000053621"|"HGHQ"|"G000053621"|""|""|"CBI"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file2
"C"|"G000053929"|"HGHQ"|"G000053929"|""|""|"TTA"|""|""|""|""|""|"DRR"|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|""|"",Not Present in file2
and I am getting below error and not able to find the route cause tried changing the CTL file as much as possible but not able to load data
Table TEST_PIPE_SEP, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
FILE_NAME FIRST * , CHARACTER
SQL string for column : "TRIM('Key_20170804070448.csv')"
KEY_COL NEXT * , CHARACTER
DESCR NEXT * , CHARACTER
RUN_DATE NEXT * , CHARACTER
SQL string for column : "SYSDATE"
Table TEST_PIPE_SEP:
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Please ask me if more information is required.
I am using
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 — 64bit Production
This is a school assignment and I’m having trouble with my DNS bind configuration. I’m supposed to setup a DNS server and I need to set SOA, NS and glue record, A records for www, mail and for the name server for the subdomain, and a CNAME.
I’m trying to setup a DNS server for the following domain: mcduckcorp.duckburg.cali.
I have three different db files, mcduckcorp.db, duckburg.db and cali.db. I did a check with the command «named-checkzone» and here is the result:
mcduckcorp.db:
dns_master_load: /etc/bind/mcduckcorp.db:1: extra input text
dns_master_load: /etc/bind/mcduckcorp.db:16: www.mcduckcorp.duckburg.cali: CNAME and other data
zone mcduckcorp.duckburg.cali/IN: loading from master file /etc/bind/mcduckcorp.db failed: extra input text
zone mcduckcorp.duckburg.cali/IN: not loaded due to errors
duckburg.db:
dns_master_load: /etc/bind/duckburg.db:1: extra input text
zone duckburg.cali/IN: loading from master file /etc/bind/duckburg.db failed: extra input text
zone duckburg.cali/IN: not loaded due to errors
cali.db
dns_master_load: /etc/bind/cali.db:1: extra input text
zone cali/IN: loading from master file /etc/bind/cali.db failed: extra input text
zone cali/IN: not loaded due to errors
And here are the configuration-files:
mcduckcorp.db:
$TTL 30 d
$ORIGIN mcduckcorp.duckburg.cali.
@ IN SOA ns1.mcduckcorp.duckburg.cali. mail.mcduckcorp.duckburg.cali. (
2019092700 ;serial
86400 ;refresh
7200 ;retry
3600000 ;expiration
172800) ;minimum
@ IN NS ns1.mcduckcorp.duckburg.cali.
ns1.mcduckcorp.duckburg.cali. IN A 192.168.1.10
mail.mcduckcorp.duckburg.cali. IN A 192.168.1.10
www.mcduckcorp.duckburg.cali. IN A 192.168.1.10
www IN CNAME squirrel
duckburg.db:
$TTL 30 d
$ORIGIN duckburg.cali.
@ IN SOA ns1.duckburg.cali. mail.duckburg.cali. (
2019092700 ;serial
86400 ;refresh
7200 ;retry
3600000 ;expiration
172800) ;minimum
@ IN NS ns1.duckburg.cali.
ns1.duckburg.cali. IN A 192.168.1.10
mail.mcduckcorp.duckburg.cali. IN A 192.168.1.10
www.mcduckcorp.duckburg.cali. IN A 192.168.1.10
subdomain IN NS ns1.mcduckcorp.duckburg.cali.
ns1.mcduckcorp.duckburg.cali. IN A 192.168.1.10
www IN CNAME squirrel
cali.db:
$TTL 30 d
$ORIGIN cali.
@ IN SOA ns1.cali. mail.cali. (
201909700 ;serial
86400 ;refresh
7200 ;retry
3600000 ;expiration
172800) ;minimum
@ IN NS ns1.cali.
ns1.cali. IN A 192.168.1.10
mail.mcduckcorp.duckburg.cali. IN A 192.168.1.10
www.mcduckcorp.duckburg.cali. IN A 192.168.1.10
subdomain IN NS ns1.duckburg.cali.
ns1.duckburg.cali. IN A 192.168.1.10
www IN CNAME squirrel
I’ve obviously made a (or a few) mistakes but I’m not sure what’s wrong. Any help would be appreciated!
After upgrading from Ubuntu 8.04 to 10.04 my DNS isn’t working properly anymore.
I keep getting this error when I run named-checkzone example.com /var/cache/bind/example.com.zone.db
zone example.com/IN: NS 'mx002a.example.com' has no address records (A or AAAA)
zone example.com/IN: not loaded due to errors.
in /var/cached/bind/example.com.db
$TTL 3D
@ IN SOA mx002a.example.com. chantra.example.com. (
200608081 ; serial, todays date + todays serial #
8H ; refresh, seconds
2H ; retry, seconds
4W ; expire, seconds
1D ) ; minimum, seconds
;
;
mx002a.example.com IN A 192.168.85.19
example.com. IN NS mx002a.example.com.
mx001 60 IN A 192.168.85.17
mx001 60 IN A 192.168.85.18
MadHatter
79k20 gold badges182 silver badges230 bronze badges
asked Oct 16, 2012 at 4:50
1
You must either specify the FQDN of everything in the zone file, or set $ORIGIN. Also, if you specify an FQDN, you must specify it with a trailing dot (this is why it doesn’t see your A record for mx002a.example.com).
To fix it:
$TTL 3D
$ORIGIN example.com.
@ IN SOA mx002a.example.com. chantra.example.com. (
200608081 ; serial, todays date + todays serial #
8H ; refresh, seconds
2H ; retry, seconds
4W ; expire, seconds
1D ) ; minimum, seconds
;
;
@ IN NS mx002a.example.com.
mx002a IN A 192.168.85.19
mx001 60 IN A 192.168.85.17
mx001 60 IN A 192.168.85.18
@ is a shortcut for just the origin.
answered Oct 16, 2012 at 4:57
Falcon MomotFalcon Momot
25.1k14 gold badges62 silver badges92 bronze badges
1