| Author |
 Topic  |
|
noobix
13 Posts |
 Posted - 07/22/2008 : 07:40:15
|
Right now I'm evaluating your latest DB Ghost 5 beta release.
Using the Data and Schema Scripter I created the sql script file folder structure. That worked as expected creating a bunch of sql files in the file system.
After that I way trying to run the first taks of the Change Manager (Build a database) using the created scripts. The process failed with the error message: "Build.ProcessScripts() Invalid attempt to read when no data is present."
Actually none of the Change Manager tasks could be executed successfully due to the same error.
I forgot to mention that I tried to script the production DB with and without static data but that didn't have any impact on the Change Manager and its task error.
Maybe you can tell me how to interpret/fix that error.
We are looking for a DB change management product that can reliably support us in our DB development/deployment (test/prod) process.
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 07:51:33
|
Would you be able to zip the scripts up and send them to techsupp@innovartis.co.uk please?
regards,
Malcolm Leach
www.innovartis.co.uk
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server |
 |
|
|
noobix
13 Posts |
Posted - 07/22/2008 : 08:00:11
|
Hi Malcolm,
thanks for the fast reply, I do appreciate that!
(always good to know support is right there when you need it)
Unfortunately I'm not allowed to send you the scripts
due to company policy.
Maybe there is another way you could help me?
Regards,
Tino
|
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 08:04:53
|
Ok, could you create a report file from the Change Manager and send that through?
regards,
Malcolm Leach
www.innovartis.co.uk
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server |
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 08:05:59
|
oh, and just so we know exactly where we are what version are you using?
Thanks. |
|
|
|
noobix
13 Posts |
Posted - 07/22/2008 : 08:36:59
|
I'm using version 5.0.0.634.
A few minutes ago I scripted (without data) Microsoft's sample DB AdventureWorks and tried to build it again from the scripts but the same error keeps popping up.
Unfortunately there is not much information in the report (and build) file (the build process fails right at the beginning, no matter whether I'm using our prod. DB or AdventureWorks).
Here is the report file content:
*********************************************************************
DB Ghost Database Builder version 5.0.0.634
22.07.2008 15:26:14...Creating Database TestDBGhost from scripts
|
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 08:59:30
|
I just tried with version 5.0.635 and managed to build AdventureWorks with no issues so I don't think this problem is anything to do with the database as such.
Are all your SQL Server settings at the "factory defaults"? Do you have SQL 2005 SP2 installed? What collation settings are you using?
|
|
|
|
noobix
13 Posts |
Posted - 07/22/2008 : 09:06:32
|
Is there any difference between my version 5.0.634 any yours 5.0.635?
My SQL Server 2005 collation is SQL_Latin1_General_CP1_CI_AS
(all the databases have the same).
SQL2005 SP2 is a pending windows update on my development machine.
I'll install it tonight.
What do you think could be the problem here?
|
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 09:10:16
|
Frankly, I don't really know as I can't reproduce the problem here.
I'm just trying to cut down on / understand the difference between your environment and ours. Service Packs etc. are an obvious candidate.
Could you try creating a single table create script and see if the Change Manager can build that? That should tell us whether or not it is a script or configuration related issue. |
|
|
|
noobix
13 Posts |
Posted - 07/22/2008 : 09:35:19
|
As you suggested I removed all sql scripts but one CREATE TABLE script.
The Change Manager still cannot build that.
|
|
|
|
leachm
124 Posts |
Posted - 07/22/2008 : 09:46:35
|
| Ok, thanks. Let's wait and see what upgrading the Service Pack level does then... |
|
|
|
Mark Baekdal
86 Posts |
Posted - 07/22/2008 : 09:54:14
|
can you open up one of the Adventure works scripts that the scripter created - is there anything of interest there?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
|
|
|
|
Mark Baekdal
86 Posts |
Posted - 07/22/2008 : 10:00:46
|
when you try to create the database - is the database TestDBGhost created? That would show that the database created ok, and the problem is dealing with the scripts. Can you record the build sql to a file and check that as well?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
|
|
|
|
Mark Baekdal
86 Posts |
Posted - 07/22/2008 : 10:02:10
|
and while i'm thinking about it - could you capture the SQL using profiler to see what SQL the builder last ran before it failed?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
|
|
|
|
noobix
13 Posts |
Posted - 07/22/2008 : 10:06:56
|
I'm sorry guys, I made a mistake. I already have SP2 installed.
What I meant by "pending windows update" was the latest security update for SQL Server 2005 Service Pack (KB948109).
My SQL Server 2005 version is currently 9.00.3068.00.
Mark, there is nothing special about the AdventureWorks scripts. The same DDL sql stuff as in my prod. DB scripts. I can't see any differences.
If you want I could zip the AdvWorks scripts and send them to you.
|
|
|
|
Mark Baekdal
86 Posts |
Posted - 07/22/2008 : 10:10:55
|
No, I don't think that'll be necessary. What about the other questions - Does the database get created, can you profile the application run and see what statements were run before failure?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
|
|
|
|
Topic |
|
DB Ghost 5 - Change Manager doesn't work
