[Данные, строки] Редактирование файла txt с охранением блоков текста в другой файл.

CheFix · 17 Авг 2012

Здравствуйте уважаемые форумчане!
Очень хотелось бы облегчить себе жизнь при чтении лога.
Если тяжело написать, то дайте наводку, буду рад любой помощи!

Версия AutoIt: 3.
3.3.8.1
Описание:
Редактирование txt файла (лога).
Структура файла такая:
...
1: The SQL script ' ttt.sql' is scheduled to execute. Note that the final decision will be made later if you have a schema version specified for this script. Script Execution=RunOnInstall, Action=Install, Component State=Install, Schema=0001.00008.0000
1: The SQL script 'rollback.sql' is not scheduled to execute. Script Execution=RunOnRollback, Action=Install, Component State=Install, Schema=
1: Attempting to establish the SQL connection... Server: test Database:
1: Attempting to execute SQL scripts...
1: Determining if the SQL script 'struct.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'test.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B898.tmp'
1: Executing SQL at Line 10 >>>
1: Executing SQL at Line 19 >>>
1: Executing SQL at Line 22 >>>
1:ADO Error: Number: -2147467259 Description: ORA-01430:
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 22. Continuing to the next batch.
1: Executing SQL at Line 25 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430:
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 25. Continuing to the next batch.
1: Executing SQL at Line 28 >>>
1: Executing SQL at Line 31 >>>
1: Executing SQL at Line 41 >>>
1: Executing SQL at Line 45 >>>
1: Executing SQL at Line 55 >>>
1: Executing SQL at Line 56 >>>
1: Finish executing SQL script file: 'test.sql'
1: Determining if the SQL script 'test2.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'test3.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B8B9.tmp'
1: Executing SQL at Line 8 >>>
1: Executing SQL at Line 17 >>>
...
Скрипт должен сохранить в новый файл блоки лога, которые содержат слово Error (можно ADO Error: Number :smile:

, блок будет начинаться со слова Prepare executing SQL script file, а заканчиваться словом Finish executing SQL script file. В итоге должно получиться что-то подобное:
...
---------------------------------------------
1: Prepare executing SQL script file: 'test.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B898.tmp'
1: Executing SQL at Line 10 >>>
1: Executing SQL at Line 19 >>>
1: Executing SQL at Line 22 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430:
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 22. Continuing to the next batch.
1: Executing SQL at Line 25 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430:
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 25. Continuing to the next batch.
1: Executing SQL at Line 28 >>>
1: Executing SQL at Line 31 >>>
1: Executing SQL at Line 41 >>>
1: Executing SQL at Line 45 >>>
1: Executing SQL at Line 55 >>>
1: Executing SQL at Line 56 >>>
1: Finish executing SQL script file: 'test.sql'
---------------------------------------------
...

Примечания:
В логе несколько таких блоков с ошибками. Сам лог достаточно большой.

sngr · 17 Авг 2012

Код:

#include 'array.au3'
#include 'file.au3'
$file=FileRead(@ScriptDir&'\123')
$str=StringRegExp($file,'(?sim)(ADO Error: Number:.*?Finish)',3)
_FileWriteFromArray(@ScriptDir&'\321',$str)

CheFix · 17 Авг 2012

Не работает почемуто. :(

Буду разбираться с StringRegExp.

sngr · 17 Авг 2012

Что неработает? Конкретезируй проблему.

CheFix · 17 Авг 2012

Запускаю скрипт, он успешно завершает свою работу, а файл 321.txt пустой.
Расширения в скрипте дописал и файлы переименовал.

sngr · 17 Авг 2012

На следующей строке после $file=FileRead поставь msgbox(0,'',$file)

CheFix · 17 Авг 2012

Я извиняюсь, всё работает! :smile:

Есть еще вопрос, что нужно дописать в

Код:

$str=StringRegExp($file,'(?sim)(ADO Error: Number:.*?Finish)',3)

чтобы блок начинался от сточки - Prepare executing SQL script file?

sngr · 17 Авг 2012

ADO Error: Number: меняешь на Prepare executing SQL script file:

CheFix · 17 Авг 2012

А как сделать, что бы между словами "Prepare executing SQL script file:" и "Finish executing SQL script file:"
обязательно было "ADO Error?

Попробовал:

Код:

$str=StringRegExp($file,'(?sim)(Prepare executing SQL script file:.*?ADO Error:.*?Finish executing SQL script file.*?\R)',3)

Не получилось :(

C2H5OH · 17 Авг 2012

А почему у меня получилось?

sngr · 17 Авг 2012

CheFix Приложи лог-файл.

C2H5OH · 17 Авг 2012

Код:

#include 'array.au3'
#include 'file.au3'
$file=FileRead(@ScriptDir&'\123.txt')
$str=StringRegExp($file,'(?sim)(Prepare executing SQL script file:.*?ADO Error:.*?Finish executing SQL script file.*?\R)',3)
_FileWriteFromArray(@ScriptDir&'\321.txt',$str)

123.txt

Код:

1: The SQL script ' ttt.sql' is scheduled to execute. Note that the final decision will be made later if you have a schema version specified for this script. Script Execution=RunOnInstall, Action=Install, Component State=Install, Schema=0001.00008.0000 
1: The SQL script 'rollback.sql' is not scheduled to execute. Script Execution=RunOnRollback, Action=Install, Component State=Install, Schema= 
1: Attempting to establish the SQL connection... Server: test Database:  
1: Attempting to execute SQL scripts... 
1: Determining if the SQL script 'struct.sql' will be executed... 
1: The SQL script will be executed because no schema version is specified for this script. 
1: Prepare executing SQL script file: 'test.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B898.tmp' 
1: Executing SQL at Line 10 >>> 
1: Executing SQL at Line 19 >>> 
1: Executing SQL at Line 22 >>> 
1:ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 22. Continuing to the next batch. 
1: Executing SQL at Line 25 >>> 
1: ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 25. Continuing to the next batch. 
1: Executing SQL at Line 28 >>> 
1: Executing SQL at Line 31 >>> 
1: Executing SQL at Line 41 >>> 
1: Executing SQL at Line 45 >>> 
1: Executing SQL at Line 55 >>> 
1: Executing SQL at Line 56 >>> 
1: Finish executing SQL script file: 'test.sql' 
1: Determining if the SQL script 'test2.sql' will be executed... 
1: The SQL script will be executed because no schema version is specified for this script. 
1: Prepare executing SQL script file: 'test3.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B8B9.tmp' 
1: Executing SQL at Line 8 >>> 
1: Executing SQL at Line 17 >>> 
1: ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 25. Continuing to the next batch. 
1: Executing SQL at Line 28 >>> 
1: Executing SQL at Line 31 >>> 
1: Executing SQL at Line 41 >>> 
1: Executing SQL at Line 45 >>> 
1: Executing SQL at Line 55 >>> 
1: Executing SQL at Line 56 >>> 
1: Finish executing SQL script file: 'test3.sql'

321.txt

Код:

Prepare executing SQL script file: 'test.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B898.tmp' 
1: Executing SQL at Line 10 >>> 
1: Executing SQL at Line 19 >>> 
1: Executing SQL at Line 22 >>> 
1:ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 22. Continuing to the next batch. 
1: Executing SQL at Line 25 >>> 
1: ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 25. Continuing to the next batch. 
1: Executing SQL at Line 28 >>> 
1: Executing SQL at Line 31 >>> 
1: Executing SQL at Line 41 >>> 
1: Executing SQL at Line 45 >>> 
1: Executing SQL at Line 55 >>> 
1: Executing SQL at Line 56 >>> 
1: Finish executing SQL script file: 'test.sql' 

Prepare executing SQL script file: 'test3.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B8B9.tmp' 
1: Executing SQL at Line 8 >>> 
1: Executing SQL at Line 17 >>> 
1: ADO Error: Number: -2147467259 Description: ORA-01430:
 Source: Microsoft OLE DB Provider for Oracle SQL State:  Native Error: 1430 
1: There was a SQL scripting error at line 25. Continuing to the next batch. 
1: Executing SQL at Line 28 >>> 
1: Executing SQL at Line 31 >>> 
1: Executing SQL at Line 41 >>> 
1: Executing SQL at Line 45 >>> 
1: Executing SQL at Line 55 >>> 
1: Executing SQL at Line 56 >>> 
1: Finish executing SQL script file: 'test3.sql'

Добавлено:
Сообщение автоматически объединено: 17 Авг 2012

Сам с регулярными выражениями не очень, потому и попробовал в качестве примера, чтобы разобраться. :smile:

sngr · 17 Авг 2012

C2H5OH Этот пример работает, но работает неверно.

Код:

Prepare
...
ADO
...
Finish
...
Prepare
...
...
Finish
Prepare
...
ADO
...
Finish

При таком сочетании в вывод попадёт 1 блок и 2 вместе с 3 , хотя 2 должен игнорироваться.

CheFix · 17 Авг 2012

Лог:

1: There was a SQL scripting error at line 20. Continuing to the next batch.
1: Executing SQL at Line 23 >>>
1: Executing SQL at Line 26 >>>
1: Executing SQL at Line 29 >>>
1: Executing SQL at Line 32 >>>
1: Executing SQL at Line 35 >>>
1: Executing SQL at Line 38 >>>
1: Executing SQL at Line 41 >>>
1: Executing SQL at Line 51 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02264: jméno je již používáno existujícím omezením
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2264
1: There was a SQL scripting error at line 51. Continuing to the next batch.
1: Executing SQL at Line 65 >>>
1: Executing SQL at Line 75 >>>
1: Executing SQL at Line 79 >>>
1: Executing SQL at Line 83 >>>
1: Executing SQL at Line 87 >>>
1: Executing SQL at Line 91 >>>
1: Executing SQL at Line 95 >>>
1: Executing SQL at Line 97 >>>
1: Finish executing SQL script file: 'struct_expucto.sql'
1: Determining if the SQL script 'struct_iszp.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_iszp.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B8FB.tmp'
1: Executing SQL at Line 8 >>>
1: Executing SQL at Line 11 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01442: sloupec modifikovaný na NOT NULL je již NOT NULL
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1442
1: There was a SQL scripting error at line 11. Continuing to the next batch.
1: Executing SQL at Line 14 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 14. Continuing to the next batch.
1: Executing SQL at Line 17 >>>
1: Executing SQL at Line 20 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 20. Continuing to the next batch.
1: Executing SQL at Line 23 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 23. Continuing to the next batch.
1: Executing SQL at Line 26 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 26. Continuing to the next batch.
1: Executing SQL at Line 29 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 29. Continuing to the next batch.
1: Executing SQL at Line 32 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 32. Continuing to the next batch.
1: Executing SQL at Line 35 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 35. Continuing to the next batch.
1: Executing SQL at Line 38 >>>
1: Executing SQL at Line 41 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 41. Continuing to the next batch.
1: Executing SQL at Line 44 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 44. Continuing to the next batch.
1: Executing SQL at Line 48 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 48. Continuing to the next batch.
1: Executing SQL at Line 51 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 51. Continuing to the next batch.
1: Executing SQL at Line 54 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 54. Continuing to the next batch.
1: Executing SQL at Line 57 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 57. Continuing to the next batch.
1: Executing SQL at Line 60 >>>
1: Executing SQL at Line 63 >>>
1: Executing SQL at Line 66 >>>
1: Executing SQL at Line 69 >>>
1: Executing SQL at Line 73 >>>
1: Executing SQL at Line 76 >>>
1: Executing SQL at Line 79 >>>
1: Executing SQL at Line 82 >>>
1: Executing SQL at Line 85 >>>
1: Executing SQL at Line 95 >>>
1: Executing SQL at Line 97 >>>
1: Executing SQL at Line 99 >>>
1: Executing SQL at Line 101 >>>
1: Executing SQL at Line 104 >>>
1: Executing SQL at Line 106 >>>
1: Executing SQL at Line 108 >>>
1: Executing SQL at Line 111 >>>
1: Executing SQL at Line 113 >>>
1: Executing SQL at Line 115 >>>
1: Executing SQL at Line 118 >>>
1: Executing SQL at Line 120 >>>
1: Executing SQL at Line 122 >>>
1: Executing SQL at Line 125 >>>
1: Executing SQL at Line 128 >>>
1: Executing SQL at Line 131 >>>
1: Executing SQL at Line 134 >>>
1: Executing SQL at Line 144 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02264: jméno je již používáno existujícím omezením
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2264
1: There was a SQL scripting error at line 144. Continuing to the next batch.
1: Executing SQL at Line 148 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02264: jméno je již používáno existujícím omezením
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2264
1: There was a SQL scripting error at line 148. Continuing to the next batch.
1: Executing SQL at Line 157 >>>
1: ADO Error: Number: -2147217900 Description: ORA-00955: název je již užíván existujícím objektem
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 955
1: There was a SQL scripting error at line 157. Continuing to the next batch.
1: Executing SQL at Line 185 >>>
1: Executing SQL at Line 203 >>>
1: Executing SQL at Line 213 >>>
1: Executing SQL at Line 217 >>>
1: Executing SQL at Line 221 >>>
1: Executing SQL at Line 225 >>>
1: Executing SQL at Line 229 >>>
1: Executing SQL at Line 233 >>>
1: Executing SQL at Line 237 >>>
1: Executing SQL at Line 241 >>>
1: Executing SQL at Line 245 >>>
1: Executing SQL at Line 256 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02275: toto referenční omezení již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2275
1: There was a SQL scripting error at line 256. Continuing to the next batch.
1: Executing SQL at Line 259 >>>
1: Executing SQL at Line 264 >>>
1: Executing SQL at Line 265 >>>
1: Finish executing SQL script file: 'struct_iszp.sql'
1: Determining if the SQL script 'struct_konfig_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_konfig_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B90C.tmp'
1: Executing SQL at Line 8 >>>
1: Executing SQL at Line 11 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 11. Continuing to the next batch.
1: Executing SQL at Line 12 >>>
1: Finish executing SQL script file: 'struct_konfig_openspa.sql'
1: Determining if the SQL script 'struct_labor.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_labor.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B91D.tmp'
1: Executing SQL at Line 20 >>>
1: Executing SQL at Line 36 >>>
1: Executing SQL at Line 75 >>>
1: Executing SQL at Line 84 >>>
1: Executing SQL at Line 93 >>>
1: Executing SQL at Line 96 >>>
1: Executing SQL at Line 99 >>>
1: Executing SQL at Line 102 >>>
1: Executing SQL at Line 105 >>>
1: Executing SQL at Line 118 >>>
1: Executing SQL at Line 125 >>>
1: Executing SQL at Line 132 >>>
1: Executing SQL at Line 139 >>>
1: Executing SQL at Line 140 >>>
1: Finish executing SQL script file: 'struct_labor.sql'
1: Determining if the SQL script 'struct_log_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_log_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B92D.tmp'
1: Executing SQL at Line 15 >>>
1: ADO Error: Number: -2147217900 Description: ORA-00955: název je již užíván existujícím objektem
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 955
1: There was a SQL scripting error at line 15. Continuing to the next batch.
1: Executing SQL at Line 49 >>>
1: ADO Error: Number: -2147217900 Description: ORA-00955: název je již užíván existujícím objektem
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 955
1: There was a SQL scripting error at line 49. Continuing to the next batch.
1: Executing SQL at Line 66 >>>
1: ADO Error: Number: -2147217900 Description: ORA-00955: název je již užíván existujícím objektem
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 955
1: There was a SQL scripting error at line 66. Continuing to the next batch.
1: Executing SQL at Line 76 >>>
1: Executing SQL at Line 77 >>>
1: Finish executing SQL script file: 'struct_log_openspa.sql'
1: Determining if the SQL script 'struct_pay_tv.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_pay_tv.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B92E.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_pay_tv.sql'
1: Determining if the SQL script 'struct_permanent_data.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_permanent_data.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B94E.tmp'
1: Executing SQL at Line 8 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 8. Continuing to the next batch.
1: Executing SQL at Line 11 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 11. Continuing to the next batch.
1: Executing SQL at Line 14 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 14. Continuing to the next batch.
1: Executing SQL at Line 17 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 17. Continuing to the next batch.
1: Executing SQL at Line 20 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 20. Continuing to the next batch.
1: Executing SQL at Line 23 >>>
1: ADO Error: Number: -2147467259 Description: ORA-01430: přidávaný sloupec již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1430
1: There was a SQL scripting error at line 23. Continuing to the next batch.
1: Executing SQL at Line 24 >>>
1: Finish executing SQL script file: 'struct_permanent_data.sql'
1: Determining if the SQL script 'struct_pkstat.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_pkstat.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B95F.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_pkstat.sql'
1: Determining if the SQL script 'struct_prava_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_prava_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B970.tmp'
1: Executing SQL at Line 10 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02275: toto referenční omezení již v tabulce existuje
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2275
1: There was a SQL scripting error at line 10. Continuing to the next batch.
1: Executing SQL at Line 11 >>>
1: Finish executing SQL script file: 'struct_prava_openspa.sql'
1: Determining if the SQL script 'struct_preklady.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_preklady.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B980.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_preklady.sql'
1: Determining if the SQL script 'struct_registr.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_registr.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B991.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_registr.sql'
1: Determining if the SQL script 'struct_reporty.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_reporty.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9A1.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_reporty.sql'
1: Determining if the SQL script 'struct_restdietka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_restdietka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9B2.tmp'
1: Executing SQL at Line 9 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02264: jméno je již používáno existujícím omezením
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2264
1: There was a SQL scripting error at line 9. Continuing to the next batch.
1: Executing SQL at Line 19 >>>
1: Executing SQL at Line 30 >>>
1: ADO Error: Number: -2147467259 Description: ORA-02298: není možno zkontrolovat platnost (RESTDIETKA_AUH.FKRUCTPOLIDUCT) - nebyly nalezeny nadřízené klíče
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 2298
1: There was a SQL scripting error at line 30. Continuing to the next batch.
1: Executing SQL at Line 31 >>>
1: Finish executing SQL script file: 'struct_restdietka.sql'
1: Determining if the SQL script 'struct_skladleku.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_skladleku.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9C3.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_skladleku.sql'
1: Determining if the SQL script 'struct_skladmtz.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_skladmtz.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9D3.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_skladmtz.sql'
1: Determining if the SQL script 'struct_smenarna.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_smenarna.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9E4.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_smenarna.sql'
1: Determining if the SQL script 'struct_tmp_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'struct_tmp_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~B9F4.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'struct_tmp_openspa.sql'
1: Determining if the SQL script 'plsql_ciselniky.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_ciselniky.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA05.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_ciselniky.sql'
1: Determining if the SQL script 'plsql_cominfo.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_cominfo.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA16.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_cominfo.sql'
1: Determining if the SQL script 'plsql_dietka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_dietka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA26.tmp'
1: Executing SQL at Line 18 >>>
1: Executing SQL at Line 19 >>>
1: Finish executing SQL script file: 'plsql_dietka.sql'
1: Determining if the SQL script 'plsql_discoverer.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_discoverer.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA27.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_discoverer.sql'
1: Determining if the SQL script 'plsql_dochazka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_dochazka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA47.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_dochazka.sql'
1: Determining if the SQL script 'plsql_expucto.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_expucto.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA58.tmp'
1: Executing SQL at Line 67 >>>
1: Executing SQL at Line 116 >>>
1: Executing SQL at Line 117 >>>
1: Finish executing SQL script file: 'plsql_expucto.sql'
1: Determining if the SQL script 'plsql_iszp.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_iszp.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA69.tmp'
1: Executing SQL at Line 62 >>>
1: Executing SQL at Line 123 >>>
1: Executing SQL at Line 228 >>>
1: Executing SQL at Line 243 >>>
1: Executing SQL at Line 278 >>>
1: Executing SQL at Line 330 >>>
1: Executing SQL at Line 382 >>>
1: Executing SQL at Line 430 >>>
1: Executing SQL at Line 544 >>>
1: Executing SQL at Line 740 >>>
1: Executing SQL at Line 774 >>>
1: Executing SQL at Line 803 >>>
1: Executing SQL at Line 911 >>>
1: Executing SQL at Line 950 >>>
1: Executing SQL at Line 970 >>>
1: Executing SQL at Line 994 >>>
1: Procedura nebo balík PL/SQL byly vytvořeny s chybami kompilace.
1: Executing SQL at Line 1131 >>>
1: Executing SQL at Line 1521 >>>
1: Executing SQL at Line 2329 >>>
1: Executing SQL at Line 2369 >>>
1: Executing SQL at Line 2755 >>>
1: Executing SQL at Line 3538 >>>
1: Executing SQL at Line 3711 >>>
1: Executing SQL at Line 4040 >>>
1: Executing SQL at Line 4051 >>>
1: Executing SQL at Line 4061 >>>
1: Executing SQL at Line 4152 >>>
1: Executing SQL at Line 4693 >>>
1: Executing SQL at Line 4717 >>>
1: Executing SQL at Line 5250 >>>
1: Procedura nebo balík PL/SQL byly vytvořeny s chybami kompilace.
1: Executing SQL at Line 5951 >>>
1: Executing SQL at Line 9006 >>>
1: Executing SQL at Line 9527 >>>
1: Executing SQL at Line 9557 >>>
1: Executing SQL at Line 9753 >>>
1: Executing SQL at Line 9876 >>>
1: Executing SQL at Line 10022 >>>
1: Executing SQL at Line 10856 >>>
1: Executing SQL at Line 10857 >>>
1: Finish executing SQL script file: 'plsql_iszp.sql'
1: Determining if the SQL script 'plsql_konfig_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_konfig_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA89.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_konfig_openspa.sql'
1: Determining if the SQL script 'plsql_labor.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_labor.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BA99.tmp'
1: Executing SQL at Line 22 >>>
1: Executing SQL at Line 39 >>>
1: Executing SQL at Line 40 >>>
1: Finish executing SQL script file: 'plsql_labor.sql'
1: Determining if the SQL script 'plsql_log_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_log_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BAAA.tmp'
1: Executing SQL at Line 23 >>>
1: Executing SQL at Line 43 >>>
1: Executing SQL at Line 44 >>>
1: Finish executing SQL script file: 'plsql_log_openspa.sql'
1: Determining if the SQL script 'plsql_pay_tv.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_pay_tv.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BABB.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_pay_tv.sql'
1: Determining if the SQL script 'plsql_permanent_data.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_permanent_data.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BACB.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_permanent_data.sql'
1: Determining if the SQL script 'plsql_pkstat.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_pkstat.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BACC.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_pkstat.sql'
1: Determining if the SQL script 'plsql_prava_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_prava_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BAEC.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_prava_openspa.sql'
1: Determining if the SQL script 'plsql_preklady.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_preklady.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BAED.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_preklady.sql'
1: Determining if the SQL script 'plsql_registr.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_registr.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BAFE.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_registr.sql'
1: Determining if the SQL script 'plsql_reporty.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_reporty.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB0F.tmp'
1: Executing SQL at Line 366 >>>
1: ADO Error: Number: -2147217900 Description: ORA-00955: název je již užíván existujícím objektem
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 955
1: There was a SQL scripting error at line 366. Continuing to the next batch.
1: Executing SQL at Line 690 >>>
1: Procedura nebo balík PL/SQL byly vytvořeny s chybami kompilace.
1: Executing SQL at Line 691 >>>
1: Finish executing SQL script file: 'plsql_reporty.sql'
1: Determining if the SQL script 'plsql_restdietka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_restdietka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB1F.tmp'
1: Executing SQL at Line 359 >>>
1: Executing SQL at Line 360 >>>
1: Finish executing SQL script file: 'plsql_restdietka.sql'
1: Determining if the SQL script 'plsql_skladleku.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_skladleku.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB3F.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_skladleku.sql'
1: Determining if the SQL script 'plsql_skladmtz.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_skladmtz.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB40.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_skladmtz.sql'
1: Determining if the SQL script 'plsql_smenarna.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_smenarna.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB51.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_smenarna.sql'
1: Determining if the SQL script 'plsql_tmp_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'plsql_tmp_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB71.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'plsql_tmp_openspa.sql'
1: Determining if the SQL script 'inic_ciselniky.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_ciselniky.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB72.tmp'
1: Executing SQL at Line 14 >>>
1: Executing SQL at Line 18 >>>
1: Executing SQL at Line 24 >>>
1: Executing SQL at Line 28 >>>
1: Executing SQL at Line 37 >>>
1: Executing SQL at Line 41 >>>
1: Executing SQL at Line 49 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (CISELNIKY_AUH.UNQ_SOURCE_ISOKOD)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 49. Continuing to the next batch.
1: Executing SQL at Line 53 >>>
1: Executing SQL at Line 61 >>>
1: Executing SQL at Line 65 >>>
1: Executing SQL at Line 68 >>>
1: Finish executing SQL script file: 'inic_ciselniky.sql'
1: Determining if the SQL script 'inic_cominfo.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_cominfo.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BB83.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_cominfo.sql'
1: Determining if the SQL script 'inic_dietka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_dietka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBA3.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_dietka.sql'
1: Determining if the SQL script 'inic_discoverer.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_discoverer.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBA4.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_discoverer.sql'
1: Determining if the SQL script 'inic_dochazka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_dochazka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBC4.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_dochazka.sql'
1: Determining if the SQL script 'inic_expucto.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_expucto.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBC5.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_expucto.sql'
1: Determining if the SQL script 'inic_iszp.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_iszp.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBE5.tmp'
1: Executing SQL at Line 13 >>>
1: Executing SQL at Line 16 >>>
1: Finish executing SQL script file: 'inic_iszp.sql'
1: Determining if the SQL script 'inic_konfig_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_konfig_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BBF6.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_konfig_openspa.sql'
1: Determining if the SQL script 'inic_labor.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_labor.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC07.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_labor.sql'
1: Determining if the SQL script 'inic_log_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_log_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC17.tmp'
1: Executing SQL at Line 14 >>>
1: Executing SQL at Line 16 >>>
1: Executing SQL at Line 29 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 29. Continuing to the next batch.
1: Executing SQL at Line 33 >>>
1: Executing SQL at Line 39 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 39. Continuing to the next batch.
1: Executing SQL at Line 43 >>>
1: Executing SQL at Line 49 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 49. Continuing to the next batch.
1: Executing SQL at Line 53 >>>
1: Executing SQL at Line 59 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 59. Continuing to the next batch.
1: Executing SQL at Line 63 >>>
1: Executing SQL at Line 69 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 69. Continuing to the next batch.
1: Executing SQL at Line 73 >>>
1: Executing SQL at Line 79 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (LOG_OPENSPA_AUH.PK_LOGDSTYPY0)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 79. Continuing to the next batch.
1: Executing SQL at Line 83 >>>
1: Executing SQL at Line 86 >>>
1: Finish executing SQL script file: 'inic_log_openspa.sql'
1: Determining if the SQL script 'inic_pay_tv.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_pay_tv.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC28.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_pay_tv.sql'
1: Determining if the SQL script 'inic_permanent_data.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_permanent_data.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC38.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_permanent_data.sql'
1: Determining if the SQL script 'inic_pkstat.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_pkstat.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC49.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_pkstat.sql'
1: Determining if the SQL script 'inic_prava_openspa.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_prava_openspa.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC5A.tmp'
1: Executing SQL at Line 13 >>>
1: Executing SQL at Line 17 >>>
1: Executing SQL at Line 22 >>>
1: Executing SQL at Line 26 >>>
1: Executing SQL at Line 31 >>>
1: Executing SQL at Line 35 >>>
1: Executing SQL at Line 40 >>>
1: Executing SQL at Line 44 >>>
1: Executing SQL at Line 49 >>>
1: Executing SQL at Line 53 >>>
1: Executing SQL at Line 58 >>>
1: Executing SQL at Line 62 >>>
1: Executing SQL at Line 67 >>>
1: Executing SQL at Line 71 >>>
1: Executing SQL at Line 76 >>>
1: Executing SQL at Line 80 >>>
1: Executing SQL at Line 85 >>>
1: Executing SQL at Line 89 >>>
1: Executing SQL at Line 94 >>>
1: Executing SQL at Line 98 >>>
1: Executing SQL at Line 103 >>>
1: Executing SQL at Line 107 >>>
1: Executing SQL at Line 112 >>>
1: Executing SQL at Line 116 >>>
1: Executing SQL at Line 121 >>>
1: Executing SQL at Line 125 >>>
1: Executing SQL at Line 130 >>>
1: Executing SQL at Line 134 >>>
1: Executing SQL at Line 139 >>>
1: Executing SQL at Line 143 >>>
1: Executing SQL at Line 148 >>>
1: Executing SQL at Line 152 >>>
1: Executing SQL at Line 157 >>>
1: Executing SQL at Line 161 >>>
1: Executing SQL at Line 166 >>>
1: Executing SQL at Line 170 >>>
1: Executing SQL at Line 176 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (PRAVA_OPENSPA_AUH.PK_POD_ID)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 176. Continuing to the next batch.
1: Executing SQL at Line 180 >>>
1: Executing SQL at Line 190 >>>
1: ADO Error: Number: -2147217873 Description: ORA-00001: nesplněna podmínka jedinečnosti (PRAVA_OPENSPA_AUH.PK_PODLEK_ID)
Source: Microsoft OLE DB Provider for Oracle SQL State: Native Error: 1
1: There was a SQL scripting error at line 190. Continuing to the next batch.
1: Executing SQL at Line 194 >>>
1: Executing SQL at Line 195 >>>
1: Finish executing SQL script file: 'inic_prava_openspa.sql'
1: Determining if the SQL script 'inic_preklady.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_preklady.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC6A.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_preklady.sql'
1: Determining if the SQL script 'inic_registr.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_registr.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC7B.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_registr.sql'
1: Determining if the SQL script 'inic_reporty.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_reporty.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC8B.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_reporty.sql'
1: Determining if the SQL script 'inic_restdietka.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_restdietka.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BC9C.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_restdietka.sql'
1: Determining if the SQL script 'inic_skladleku.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_skladleku.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BCAD.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_skladleku.sql'
1: Determining if the SQL script 'inic_skladmtz.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_skladmtz.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BCCD.tmp'
1: Executing SQL at Line 1 >>>
1: Finish executing SQL script file: 'inic_skladmtz.sql'
1: Determining if the SQL script 'inic_smenarna.sql' will be executed...
1: The SQL script will be executed because no schema version is specified for this script.
1: Prepare executing SQL script file: 'inic_smenarna.sql'. Path: 'C:\Users\KONZUL~1\AppData\Local\Temp\~BCCE.tmp'
1: Executing SQL at Line 1 >>>

Я не правильно написал. :stars:
Скрипт работает, но некоторые блоки содержат, другие блоки с таким же началом и концом но без слов "ADO Error".
Точно как написал sngr !

sngr · 17 Авг 2012

Код:

$file=FileRead(@ScriptDir&'\123')
$str=StringRegExp($file,'(?ims)(Prepare executing.*?Finish)',3)
$res=''
For $i=0 To UBound($str)-1
	If StringInStr($str[$i],'ADO') Then $res&=$str[$i]&@CRLF&@CRLF
Next
FileWrite(@ScriptDir&'\321',$res)

C2H5OH · 17 Авг 2012

Угу, мы люди не гордые, можем и второй проход сделать

Код:

#include 'array.au3'
#include 'file.au3'
$file=FileRead(@ScriptDir&'\123.txt')
$str=StringRegExp($file,'(?sim)(Prepare executing SQL script file:.*?Finish executing SQL script file.*?\R)',3)
For $i = UBound($str)-1 To 0 Step -1
	If StringInStr($str[$i],"ADO Error:") = 0 Then _ArrayDelete($str,$i)
Next
_FileWriteFromArray(@ScriptDir&'\321.txt',$str)

CheFix · 17 Авг 2012

C2H5OH - Браво! Работает отлично! :ok:

Спасибо!

C2H5OH · 17 Авг 2012

Так и последний скрип sngr практически такой же, только не массив правит, а строку формирует. :IL_AutoIt_1:

Автор темы	Похожие темы	Форум	Ответы	Дата
A	Из ресурсов исполняемых файлов получить данные в виде строки-структуры	Общие вопросы по AutoIt	4	Пятница в 19:04
	[Данные, строки] Поиск определенных данных в txt и копирование их в другой txt	Стол заказов	1	17 Ноя 2021
D	[Данные, строки] Редактирование строки для передачи в Send()	Общие вопросы по AutoIt	6	2 Июн 2014
A	[Данные, строки] Работа с PDF документам: создание, редактирование	Общие вопросы по AutoIt	2	24 Ноя 2013
M	[Данные, строки] Редактирование строки	Общие вопросы по AutoIt	5	27 Дек 2010

Поиск

Поиск

[Данные, строки] Редактирование файла txt с охранением блоков текста в другой файл.

CheFix

Новичок

sngr

AutoIT Гуру

CheFix

Новичок

sngr

AutoIT Гуру

CheFix

Новичок

sngr

AutoIT Гуру

CheFix

Новичок

sngr

AutoIT Гуру

CheFix

Новичок

C2H5OH

AutoIT Гуру

sngr

AutoIT Гуру

C2H5OH

AutoIT Гуру

sngr

AutoIT Гуру

CheFix

Новичок

sngr

AutoIT Гуру

C2H5OH

AutoIT Гуру

CheFix

Новичок

C2H5OH

AutoIT Гуру