Установка Гидры. Не могу победить :-(
Atom Ответить
06.06.2011


Доброго времени суток, роботостроители!
Случайно набрел на этот проект. Зачетная вещь, чего и говорить.
Хочется тоже присоединиться к вашему сообществу. С# освоил, т.к. програмлю на асм с детства.
Одна проблема - не совсем понятно, как устанавливать базу данных. Когда запускаю скрипт trading.sql - вылазят ошибки
Может в WIN7 хитрости какие-то ?
С SQL раньше дел не имел, если не трудно - направьте на путь истинный. Где косяк ? И где порыть ?

Теги:


Спасибо:




5 Ответов
esper

Фотография
Программист
Дата: 06.06.2011
Ответить


Цитата:
Когда запускаю скрипт trading.sql - вылазят ошибки

Какие именно ошибки?
Спасибо:

jurik8

Фотография
Дата: 06.06.2011
Ответить


esper Перейти
Цитата:
Когда запускаю скрипт trading.sql - вылазят ошибки

Какие именно ошибки?


вот чего пишет
Msg 15025, Level 16, State 1, Line 41
The server principal 'trading' already exists.
Msg 1801, Level 16, State 3, Line 3
Database 'Trading' already exists.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '100'.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 102, Level 15, State 6, Line 2
Incorrect syntax near 'HONOR_BROKER_PRIORITY'.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 15023, Level 16, State 1, Line 3
User, group, or role 'trading' already exists in the current database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Exchange' in the database.
Msg 6246, Level 16, State 1, Line 2
Assembly "Ecng.Data.SqlServer" already exists in database "master".
Msg 6249, Level 16, State 1, Line 1
The associated file "Ecng.Data.SqlServer.pdb" already exists for assembly "Ecng.Data.SqlServer".
Msg 6249, Level 16, State 1, Line 1
The associated file "Properties\AssemblyInfo.cs" already exists for assembly "Ecng.Data.SqlServer".
Msg 6249, Level 16, State 1, Line 1
The associated file "SqlExtendedProcedures.cs" already exists for assembly "Ecng.Data.SqlServer".
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HistorySession' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Strategy' in the database.
Msg 2714, Level 16, State 3, Procedure usp_RethrowError, Line 26
There is already an object named 'usp_RethrowError' in the database.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Portfolio' in the database.
Msg 2714, Level 16, State 51, Procedure PageSelect, Line 2
There is already an object named 'PageSelect' in the database.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Parameter or variable '@WorkingFrom' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #4: Cannot find data type time.
Parameter or variable '@WorkingTo' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #5: Cannot find data type time.
Parameter or variable '@Interval' has an invalid data type.
Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_ReadBySourceId, Line 4
There is already an object named 'MarketDataSourceSettings_ReadBySourceId' in the database.
Msg 2714, Level 16, State 3, Procedure HistorySession_Count, Line 3
There is already an object named 'HistorySession_Count' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_Count, Line 3
There is already an object named 'Exchange_Count' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_UpdateByName, Line 18
There is already an object named 'Exchange_UpdateByName' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_ReadByName, Line 4
There is already an object named 'Exchange_ReadByName' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_ReadAll, Line 6
There is already an object named 'Exchange_ReadAll' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HydraSecurityInfo' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Order' in the database.
Msg 2714, Level 16, State 3, Procedure HistorySession_ReadAll, Line 6
There is already an object named 'HistorySession_ReadAll' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Position' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Trade' in the database.
Msg 2714, Level 16, State 3, Procedure Security_ReadAll, Line 6
There is already an object named 'Security_ReadAll' in the database.
Msg 2714, Level 16, State 3, Procedure Security_Count, Line 3
There is already an object named 'Security_Count' in the database.
Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Parameter or variable '@LastTradeTime' has an invalid data type.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'OrderFail' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'MyTrade' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HistorySessionOrder' in the database.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HistorySessionOrder_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HistorySessionOrder_Session' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_HydraSecurityInfo_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_MyTrade_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_MyTrade_Trade' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Order_Portfolio' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Order_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_OrderFail_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Portfolio_Exchange' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Position_Portfolio' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Position_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Trade_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.

и в папке c:\stocksharp\ пусто

как и где сделать "Run the RECONFIGURE statement to install." не могу никак вдуплить. SQL пока для меня совсем никак...
Автор топика
Спасибо:

esper

Фотография
Программист
Дата: 06.06.2011
Ответить


Цитата:
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.

Возможно у процесса SQLServer-а нет прав на запись в данную директорию
Спасибо:

jurik8

Фотография
Дата: 06.06.2011
Ответить


esper Перейти
Цитата:
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.

Возможно у процесса SQLServer-а нет прав на запись в данную директорию


Удалил все приложения, связанные с SQL
Установил SQL Server 2005 Express

Запускаю скрипт trading.sql из SQL Server Management Express и вот такая хрень вылазит

Msg 22002, Level 16, State 1, Line 0
RegCreateKeyEx() returned error 5, 'Отказано в доступе.'
Необходимо перезапустить SQL Server
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '100'.
Msg 102, Level 15, State 6, Line 2
Incorrect syntax near 'HONOR_BROKER_PRIORITY'.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Parameter or variable '@WorkingFrom' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #4: Cannot find data type time.
Parameter or variable '@WorkingTo' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #5: Cannot find data type time.
Parameter or variable '@Interval' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Parameter or variable '@LastTradeTime' has an invalid data type.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_HydraSecurityInfo_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Order_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Position_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Trade_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission.
Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.

Через администрирование/службы перезапускаю службу SQL Server
повторно запускаю скрипт - та же самая хрень...
Уже неделю бьюсь. Ничего не понимаю, что еще надо сделать-то чтоб базы сформировались и запустились.
В папке c:\stocksharp создалось 2 файла - база и лог, все ок. Но почему дальше ошибки летят - неясно. Выручайте, профи-SQLщики ! А то руки опускаются уже.
Автор топика
Спасибо:

DT

Фотография
Дата: 06.06.2011
Ответить


Спасибо:


Добавить файлы через драг-н-дроп, , или вставить из буфера обмена.

loading
clippy