Hi
I have a valid and working template which takes 2 parameters and can be accessed
using a URI of the form
http://localhost/dbports/template/tm...65&AddrID=3084
However when I try to include this information in an XSLT transformation using the
document() function it escapes the & in the URIstring to & and accessing the
template using
http://localhost/dbports/template/tm...mp;AddrID=3084
doesn't seem to work. It just returns the following HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>
This must be something simple mustn't it ? Any ideas ?
TIA
Feargal Hogan
Can you please forward the code fragment that does the invocation? Is that
the argument to the document() function or the output of the XSLT that you
then send over HTTP?
Thanks
Michael
"Feargal Hogan" <feargalhNO@.Spam.portinfo.co.uk> wrote in message
news:uVRIGc6rEHA.1232@.TK2MSFTNGP11.phx.gbl...
> Hi
> I have a valid and working template which takes 2 parameters and can be
> accessed
> using a URI of the form
> http://localhost/dbports/template/tm...65&AddrID=3084
> However when I try to include this information in an XSLT transformation
> using the
> document() function it escapes the & in the URIstring to & and
> accessing the
> template using
> http://localhost/dbports/template/tm...mp;AddrID=3084
> doesn't seem to work. It just returns the following HTML
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html;
> charset=windows-1252"></HEAD>
> <BODY></BODY></HTML>
> This must be something simple mustn't it ? Any ideas ?
> TIA
> Feargal Hogan
>
|||Michael
Thanks. I figured out the problem. I just set disable-output-escaping in
"<xsl:value-of " element
Feargal
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:OcFfI2HsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Can you please forward the code fragment that does the invocation? Is that
> the argument to the document() function or the output of the XSLT that you
> then send over HTTP?
> Thanks
> Michael
> "Feargal Hogan" <feargalhNO@.Spam.portinfo.co.uk> wrote in message
> news:uVRIGc6rEHA.1232@.TK2MSFTNGP11.phx.gbl...
>
Showing posts with label working. Show all posts
Showing posts with label working. Show all posts
Monday, March 26, 2012
Thursday, March 22, 2012
ERWIN
I'm working with a developer that used ERWIN to create the database I have
to interface with. At first glance I noticed that there are a ton of
unecessary triggers, many of which look like they won't even be hit because
they're trying to detect and raise error messages for FK violations (when
there are already FK contraints).
I don't like what I'm seeing so far. Can anyone give me the lowdown about
using this tool with SS2K?
PaulHehe, I've just spent the last two months working with some scripts that
were generated from ERWin.
In a nutshell, the tool is great for reverse engineering a database and
creating pretty DB Diagrams for documentation. Other than this, I don't
like the program myself as I prefer to see the entire table - not just the
columns as FK's, but also datatypes all constraints, indexes and any default
data which is inserted at table creation time.
I'm sure that there are people who love the tool, and to them I say good for
you. It's a personal choice really.
The triggers that your talking about sound like the developer added these
not realising the performance hit. Sounds like you'll have alot of work to
do. Good luck
Regards
Colin Dawson
www.cjdawson.com
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
> because they're trying to detect and raise error messages for FK
> violations (when there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||Erwin is a great tool and I use it religiously. However, it has it's
quirks. You have to be careful to set settings right to make sure that
those triggers aren't created.
I rarely use their native code and constraint generation, so I cannot give
you too much advice, but it is very easy to use and very extensible (which
is why I love it.)
I just created these two tables (ignore the types) and ran it with the
default generation. Everything is good (enough) until the triggers, so I
would just get rid of the triggers.
CREATE TABLE E_1 (
e1Id char(18) NOT NULL,
value char(18) NULL
)
go
ALTER TABLE E_1
ADD PRIMARY KEY (e1Id ASC)
go
CREATE TABLE E_2 (
e1Id char(18) NOT NULL,
value char(18) NULL,
e2Id char(18) NOT NULL
)
go
ALTER TABLE E_2
ADD PRIMARY KEY (e2Id ASC)
go
ALTER TABLE E_2
ADD FOREIGN KEY (e1Id)
REFERENCES E_1 (e1Id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go
create trigger tD_E_1 on E_1 for DELETE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* DELETE trigger on E_1 */
begin
declare @.errno int,
@.errmsg varchar(255)
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON PARENT DELETE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if exists (
select * from deleted,E_2
where
/* %JoinFKPK(E_2,deleted," = "," and") */
E_2.e1Id = deleted.e1Id
)
begin
select @.errno = 30001,
@.errmsg = 'Cannot DELETE E_1 because E_2 exists.'
goto error
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tU_E_1 on E_1 for UPDATE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* UPDATE trigger on E_1 */
begin
declare @.numrows int,
@.nullcnt int,
@.validcnt int,
@.inse1Id char(18),
@.errno int,
@.errmsg varchar(255)
select @.numrows = @.@.rowcount
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON PARENT UPDATE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if
/* %ParentPK(" or",update) */
update(e1Id)
begin
if exists (
select * from deleted,E_2
where
/* %JoinFKPK(E_2,deleted," = "," and") */
E_2.e1Id = deleted.e1Id
)
begin
select @.errno = 30005,
@.errmsg = 'Cannot UPDATE E_1 because E_2 exists.'
goto error
end
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tD_E_2 on E_2 for DELETE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* DELETE trigger on E_2 */
begin
declare @.errno int,
@.errmsg varchar(255)
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON CHILD DELETE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if exists (select * from deleted,E_1
where
/* %JoinFKPK(deleted,E_1," = "," and") */
deleted.e1Id = E_1.e1Id and
not exists (
select * from E_2
where
/* %JoinFKPK(E_2,E_1," = "," and") */
E_2.e1Id = E_1.e1Id
)
)
begin
select @.errno = 30010,
@.errmsg = 'Cannot DELETE last E_2 because E_1 exists.'
goto error
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tU_E_2 on E_2 for UPDATE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* UPDATE trigger on E_2 */
begin
declare @.numrows int,
@.nullcnt int,
@.validcnt int,
@.inse2Id char(18),
@.errno int,
@.errmsg varchar(255)
select @.numrows = @.@.rowcount
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON CHILD UPDATE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if
/* %ChildFK(" or",update) */
update(e1Id)
begin
select @.nullcnt = 0
select @.validcnt = count(*)
from inserted,E_1
where
/* %JoinFKPK(inserted,E_1) */
inserted.e1Id = E_1.e1Id
/* %NotnullFK(inserted," is null","select @.nullcnt = count(*) from
inserted where"," and") */
select @.nullcnt = count(*) from inserted where
inserted.e1Id is null
if @.validcnt + @.nullcnt != @.numrows
begin
select @.errno = 30007,
@.errmsg = 'Cannot UPDATE E_2 because E_1 does not exist.'
goto error
end
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
> because they're trying to detect and raise error messages for FK
> violations (when there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||I think this is better...
CREATE TABLE E_1(
e1Id char(18) NOT NULL PRIMARY KEY,
value char(18) NULL
)
go
CREATE TABLE E_2 (
e1Id char(18) NOT NULL ADD PRIMARY KEY,
value char(18) NULL,
e2Id char(18) NOT NULL,
CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
ON UPDATE NO ACTION
)
go
Or better still
CREATE TABLE E_1(
e1Id char(18) NOT NULL,
value char(18) NULL
CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
)
go
CREATE TABLE E_2(
e1Id char(18) NOT NULL,
value char(18) NULL,
e2Id char(18) NOT NULL,
CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE
NO ACTION ON UPDATE NO ACTION
)
go
Here's what's been added - all constraints are now named, the entire table
is now seen and known (I've not included filegroups in the above example
though) The entire table is listed in one foul swoop, everything is shown
together at the same time, with the exception of listing the tables which
depend on this table but that's another issue. These are the things that I
think are lacking from products like ERWin. Don't mistunderstand me, I
think they great tools for showing a table graphically, but for creating
databases... I think there's alot to be desired. Also looking at the
graphical tool, it's not easy to see what check constraints, defaults and
indexes are available - the front end just doesn't show them. ERWin is good
for the job is was designed for though - to show the relationship between
tables.
Regards
Colin Dawson
www.cjdawson.com|||Hi
I'm also new to SQL and am using Xcase Ver 7x Anybody know any advantages,
di
vantages etc with it.
So far it seems to be ok creating, modifying tables, constraints etc
"Programming proves that Natural Selection is true, since every time I
idiot-proof a program a better idiot comes along.
Robert W. Drummond
John Linville
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>I think this is better...
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL PRIMARY KEY,
> value char(18) NULL
> )
> go
> CREATE TABLE E_2 (
> e1Id char(18) NOT NULL ADD PRIMARY KEY,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
> ON UPDATE NO ACTION
> )
> go
> Or better still
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL,
> value char(18) NULL
> CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
> )
> go
> CREATE TABLE E_2(
> e1Id char(18) NOT NULL,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
> CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON
> DELETE NO ACTION ON UPDATE NO ACTION
> )
> go
> Here's what's been added - all constraints are now named, the entire table
> is now seen and known (I've not included filegroups in the above example
> though) The entire table is listed in one foul swoop, everything is shown
> together at the same time, with the exception of listing the tables which
> depend on this table but that's another issue. These are the things that
> I think are lacking from products like ERWin. Don't mistunderstand me, I
> think they great tools for showing a table graphically, but for creating
> databases... I think there's alot to be desired. Also looking at the
> graphical tool, it's not easy to see what check constraints, defaults and
> indexes are available - the front end just doesn't show them. ERWin is
> good for the job is was designed for though - to show the relationship
> between tables.
> Regards
> Colin Dawson
> www.cjdawson.com
>|||Yes, clearly this is better, and why I have built lots of macro code to
implement this in ERwin. Alters are much easier to automatically generate,
especially since you can do them again later (after dropping them of
course.) The company I worked for a long time ago (and I work for them
again today :) had a consultant who also worked with the original company
that owned/wrote the original ERwin product (when it was pretty much all
that there was.) Hence we have grown an insane number of macros that deal
with everything, even turning on and off triggers, custom triggers,
constraints, indexes, everything. It was not easy, but my code is really
really useful, especially during rapid development because I can modify all
of the objects in just minutes.
I occasionally use the base ERwin functionality but only when I am in a
hurry to do something small. I used to try to lobby for changes, but
after CA purchased it I just have never found the right way, and I have all
of this code that works. The only real problem is that it is such a bother
to use I cannot even get coworkers to use it, much less sharing it with the
world. Perhaps I will do something like that and post it on my blog one
day.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>I think this is better...
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL PRIMARY KEY,
> value char(18) NULL
> )
> go
> CREATE TABLE E_2 (
> e1Id char(18) NOT NULL ADD PRIMARY KEY,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
> ON UPDATE NO ACTION
> )
> go
> Or better still
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL,
> value char(18) NULL
> CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
> )
> go
> CREATE TABLE E_2(
> e1Id char(18) NOT NULL,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
> CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON
> DELETE NO ACTION ON UPDATE NO ACTION
> )
> go
> Here's what's been added - all constraints are now named, the entire table
> is now seen and known (I've not included filegroups in the above example
> though) The entire table is listed in one foul swoop, everything is shown
> together at the same time, with the exception of listing the tables which
> depend on this table but that's another issue. These are the things that
> I think are lacking from products like ERWin. Don't mistunderstand me, I
> think they great tools for showing a table graphically, but for creating
> databases... I think there's alot to be desired. Also looking at the
> graphical tool, it's not easy to see what check constraints, defaults and
> indexes are available - the front end just doesn't show them. ERWin is
> good for the job is was designed for though - to show the relationship
> between tables.
> Regards
> Colin Dawson
> www.cjdawson.com
>|||Sounds to me like we're singing from the same hymm sheet. Just different
parts of it. Currently I'm a script jockey, as you saw from my previous
post I like to get things neat done one etc. as DBA for the company that I
work for, I'm trying to tighten up the database structures to make sure that
all foreign keys check constraints proper indexing etc, is in place. As I
don't have an unlimited amount of time to get everything into place and
working 100%, I took the decision early on that ERWin was as you say "it is
such a bother to use". For documentation ERWin is brilliant for creating
documentation, the diagrams are much better looking that the diagrams from
SQL Server, so the company tend to use these. Also lesser experiences
developers can use the tool for creating a basic table structure,
brainstorming and stuff like that to get something off the ground. Once
they're happy with the design, I have to perseude them to generate a script
then go through it with a fine too comb to be sure that they've not missed
anything. After they've finished, it's my turn and I spend ages giving the
developer the third degree and adding about a million extra contraints and
mocking their indexing ideas. However once corrected the database is
extremely well designed. I just wish that ERWin could read in a script and
learn the style that was used to create that script, then when using ERWin
to generate a script it generates a script as close a possible to the
original.
I've waffled for too long on this now.
Regards
Colin Dawson
www.cjdawson.com
"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:uAtpGSspFHA.3004@.TK2MSFTNGP15.phx.gbl...
> Yes, clearly this is better, and why I have built lots of macro code to
> implement this in ERwin. Alters are much easier to automatically
> generate, especially since you can do them again later (after dropping
> them of course.) The company I worked for a long time ago (and I work
> for them again today :) had a consultant who also worked with the original
> company that owned/wrote the original ERwin product (when it was pretty
> much all that there was.) Hence we have grown an insane number of macros
> that deal with everything, even turning on and off triggers, custom
> triggers, constraints, indexes, everything. It was not easy, but my code
> is really really useful, especially during rapid development because I can
> modify all of the objects in just minutes.
> I occasionally use the base ERwin functionality but only when I am in a
> hurry to do something small. I used to try to lobby for changes, but
> after CA purchased it I just have never found the right way, and I have
> all of this code that works. The only real problem is that it is such a
> bother to use I cannot even get coworkers to use it, much less sharing it
> with the world. Perhaps I will do something like that and post it on my
> blog one day.
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often
> convincing." (Oscar Wilde)
>
> "Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
> news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>|||I used ERWIN for a short time myself and I did like it up to a point.
Unfortunately, it doesn't support SQL Server 2000's declarative referential
integrity (DRI) and creates triggers to cascade updates and deletes to
related tables.
For this reason alone I stopped using ERWIN. I found that the triggers
remained after I altered table/column names or relationships, which caused
updates/deletes to fail until I realised what was happening.
I'm sure it's great for SQL 7, but it would have to be configured properly
to be worthwhile in SQL 2000. IMO.
Thanks. Dan.
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
because
> they're trying to detect and raise error messages for FK violations (when
> there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||I think so to. The basics we are both saying is that ERWin output sucks.
Cannot disagree with that, especially since I wrote my own script
generators, albeit in the ERwin tool :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:bdgOe.93743$G8.59922@.text.news.blueyonder.co.uk...
> Sounds to me like we're singing from the same hymm sheet. Just different
> parts of it. Currently I'm a script jockey, as you saw from my previous
> post I like to get things neat done one etc. as DBA for the company that I
> work for, I'm trying to tighten up the database structures to make sure
> that all foreign keys check constraints proper indexing etc, is in place.
> As I don't have an unlimited amount of time to get everything into place
> and working 100%, I took the decision early on that ERWin was as you say
> "it is such a bother to use". For documentation ERWin is brilliant for
> creating documentation, the diagrams are much better looking that the
> diagrams from SQL Server, so the company tend to use these. Also lesser
> experiences developers can use the tool for creating a basic table
> structure, brainstorming and stuff like that to get something off the
> ground. Once they're happy with the design, I have to perseude them to
> generate a script then go through it with a fine too comb to be sure that
> they've not missed anything. After they've finished, it's my turn and I
> spend ages giving the developer the third degree and adding about a
> million extra contraints and mocking their indexing ideas. However once
> corrected the database is extremely well designed. I just wish that
> ERWin could read in a script and learn the style that was used to create
> that script, then when using ERWin to generate a script it generates a
> script as close a possible to the original.
> I've waffled for too long on this now.
> Regards
> Colin Dawson
> www.cjdawson.com
>
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:uAtpGSspFHA.3004@.TK2MSFTNGP15.phx.gbl...
>sql
to interface with. At first glance I noticed that there are a ton of
unecessary triggers, many of which look like they won't even be hit because
they're trying to detect and raise error messages for FK violations (when
there are already FK contraints).
I don't like what I'm seeing so far. Can anyone give me the lowdown about
using this tool with SS2K?
PaulHehe, I've just spent the last two months working with some scripts that
were generated from ERWin.
In a nutshell, the tool is great for reverse engineering a database and
creating pretty DB Diagrams for documentation. Other than this, I don't
like the program myself as I prefer to see the entire table - not just the
columns as FK's, but also datatypes all constraints, indexes and any default
data which is inserted at table creation time.
I'm sure that there are people who love the tool, and to them I say good for
you. It's a personal choice really.
The triggers that your talking about sound like the developer added these
not realising the performance hit. Sounds like you'll have alot of work to
do. Good luck
Regards
Colin Dawson
www.cjdawson.com
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
> because they're trying to detect and raise error messages for FK
> violations (when there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||Erwin is a great tool and I use it religiously. However, it has it's
quirks. You have to be careful to set settings right to make sure that
those triggers aren't created.
I rarely use their native code and constraint generation, so I cannot give
you too much advice, but it is very easy to use and very extensible (which
is why I love it.)
I just created these two tables (ignore the types) and ran it with the
default generation. Everything is good (enough) until the triggers, so I
would just get rid of the triggers.
CREATE TABLE E_1 (
e1Id char(18) NOT NULL,
value char(18) NULL
)
go
ALTER TABLE E_1
ADD PRIMARY KEY (e1Id ASC)
go
CREATE TABLE E_2 (
e1Id char(18) NOT NULL,
value char(18) NULL,
e2Id char(18) NOT NULL
)
go
ALTER TABLE E_2
ADD PRIMARY KEY (e2Id ASC)
go
ALTER TABLE E_2
ADD FOREIGN KEY (e1Id)
REFERENCES E_1 (e1Id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
go
create trigger tD_E_1 on E_1 for DELETE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* DELETE trigger on E_1 */
begin
declare @.errno int,
@.errmsg varchar(255)
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON PARENT DELETE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if exists (
select * from deleted,E_2
where
/* %JoinFKPK(E_2,deleted," = "," and") */
E_2.e1Id = deleted.e1Id
)
begin
select @.errno = 30001,
@.errmsg = 'Cannot DELETE E_1 because E_2 exists.'
goto error
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tU_E_1 on E_1 for UPDATE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* UPDATE trigger on E_1 */
begin
declare @.numrows int,
@.nullcnt int,
@.validcnt int,
@.inse1Id char(18),
@.errno int,
@.errmsg varchar(255)
select @.numrows = @.@.rowcount
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON PARENT UPDATE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if
/* %ParentPK(" or",update) */
update(e1Id)
begin
if exists (
select * from deleted,E_2
where
/* %JoinFKPK(E_2,deleted," = "," and") */
E_2.e1Id = deleted.e1Id
)
begin
select @.errno = 30005,
@.errmsg = 'Cannot UPDATE E_1 because E_2 exists.'
goto error
end
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tD_E_2 on E_2 for DELETE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* DELETE trigger on E_2 */
begin
declare @.errno int,
@.errmsg varchar(255)
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON CHILD DELETE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if exists (select * from deleted,E_1
where
/* %JoinFKPK(deleted,E_1," = "," and") */
deleted.e1Id = E_1.e1Id and
not exists (
select * from E_2
where
/* %JoinFKPK(E_2,E_1," = "," and") */
E_2.e1Id = E_1.e1Id
)
)
begin
select @.errno = 30010,
@.errmsg = 'Cannot DELETE last E_2 because E_1 exists.'
goto error
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
go
create trigger tU_E_2 on E_2 for UPDATE as
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* UPDATE trigger on E_2 */
begin
declare @.numrows int,
@.nullcnt int,
@.validcnt int,
@.inse2Id char(18),
@.errno int,
@.errmsg varchar(255)
select @.numrows = @.@.rowcount
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
/* E_1 R/1 E_2 ON CHILD UPDATE NO ACTION */
/* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="E_1"
CHILD_OWNER="", CHILD_TABLE="E_2"
P2C_VERB_PHRASE="R/1", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_1", FK_COLUMNS="e1Id" */
if
/* %ChildFK(" or",update) */
update(e1Id)
begin
select @.nullcnt = 0
select @.validcnt = count(*)
from inserted,E_1
where
/* %JoinFKPK(inserted,E_1) */
inserted.e1Id = E_1.e1Id
/* %NotnullFK(inserted," is null","select @.nullcnt = count(*) from
inserted where"," and") */
select @.nullcnt = count(*) from inserted where
inserted.e1Id is null
if @.validcnt + @.nullcnt != @.numrows
begin
select @.errno = 30007,
@.errmsg = 'Cannot UPDATE E_2 because E_1 does not exist.'
goto error
end
end
/* ERwin Builtin Sun Aug 21 15:19:26 2005 */
return
error:
raiserror @.errno @.errmsg
rollback transaction
end
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
> because they're trying to detect and raise error messages for FK
> violations (when there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||I think this is better...
CREATE TABLE E_1(
e1Id char(18) NOT NULL PRIMARY KEY,
value char(18) NULL
)
go
CREATE TABLE E_2 (
e1Id char(18) NOT NULL ADD PRIMARY KEY,
value char(18) NULL,
e2Id char(18) NOT NULL,
CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
ON UPDATE NO ACTION
)
go
Or better still
CREATE TABLE E_1(
e1Id char(18) NOT NULL,
value char(18) NULL
CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
)
go
CREATE TABLE E_2(
e1Id char(18) NOT NULL,
value char(18) NULL,
e2Id char(18) NOT NULL,
CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE
NO ACTION ON UPDATE NO ACTION
)
go
Here's what's been added - all constraints are now named, the entire table
is now seen and known (I've not included filegroups in the above example
though) The entire table is listed in one foul swoop, everything is shown
together at the same time, with the exception of listing the tables which
depend on this table but that's another issue. These are the things that I
think are lacking from products like ERWin. Don't mistunderstand me, I
think they great tools for showing a table graphically, but for creating
databases... I think there's alot to be desired. Also looking at the
graphical tool, it's not easy to see what check constraints, defaults and
indexes are available - the front end just doesn't show them. ERWin is good
for the job is was designed for though - to show the relationship between
tables.
Regards
Colin Dawson
www.cjdawson.com|||Hi
I'm also new to SQL and am using Xcase Ver 7x Anybody know any advantages,
di
vantages etc with it.So far it seems to be ok creating, modifying tables, constraints etc
"Programming proves that Natural Selection is true, since every time I
idiot-proof a program a better idiot comes along.
Robert W. Drummond
John Linville
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>I think this is better...
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL PRIMARY KEY,
> value char(18) NULL
> )
> go
> CREATE TABLE E_2 (
> e1Id char(18) NOT NULL ADD PRIMARY KEY,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
> ON UPDATE NO ACTION
> )
> go
> Or better still
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL,
> value char(18) NULL
> CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
> )
> go
> CREATE TABLE E_2(
> e1Id char(18) NOT NULL,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
> CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON
> DELETE NO ACTION ON UPDATE NO ACTION
> )
> go
> Here's what's been added - all constraints are now named, the entire table
> is now seen and known (I've not included filegroups in the above example
> though) The entire table is listed in one foul swoop, everything is shown
> together at the same time, with the exception of listing the tables which
> depend on this table but that's another issue. These are the things that
> I think are lacking from products like ERWin. Don't mistunderstand me, I
> think they great tools for showing a table graphically, but for creating
> databases... I think there's alot to be desired. Also looking at the
> graphical tool, it's not easy to see what check constraints, defaults and
> indexes are available - the front end just doesn't show them. ERWin is
> good for the job is was designed for though - to show the relationship
> between tables.
> Regards
> Colin Dawson
> www.cjdawson.com
>|||Yes, clearly this is better, and why I have built lots of macro code to
implement this in ERwin. Alters are much easier to automatically generate,
especially since you can do them again later (after dropping them of
course.) The company I worked for a long time ago (and I work for them
again today :) had a consultant who also worked with the original company
that owned/wrote the original ERwin product (when it was pretty much all
that there was.) Hence we have grown an insane number of macros that deal
with everything, even turning on and off triggers, custom triggers,
constraints, indexes, everything. It was not easy, but my code is really
really useful, especially during rapid development because I can modify all
of the objects in just minutes.
I occasionally use the base ERwin functionality but only when I am in a
hurry to do something small. I used to try to lobby for changes, but
after CA purchased it I just have never found the right way, and I have all
of this code that works. The only real problem is that it is such a bother
to use I cannot even get coworkers to use it, much less sharing it with the
world. Perhaps I will do something like that and post it on my blog one
day.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>I think this is better...
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL PRIMARY KEY,
> value char(18) NULL
> )
> go
> CREATE TABLE E_2 (
> e1Id char(18) NOT NULL ADD PRIMARY KEY,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON DELETE NO ACTION
> ON UPDATE NO ACTION
> )
> go
> Or better still
> CREATE TABLE E_1(
> e1Id char(18) NOT NULL,
> value char(18) NULL
> CONSTRAINT PK_E_1_e1Id PRIMARY KEY (e1Id ASC)
> )
> go
> CREATE TABLE E_2(
> e1Id char(18) NOT NULL,
> value char(18) NULL,
> e2Id char(18) NOT NULL,
> CONSTRAINT PK_E_2_e2Id PRIMARY KEY (e2Id ASC),
> CONSTRAINT FK_E_2_e1Id FOREIGN KEY (e1Id) REFERENCES E_1 (e1Id) ON
> DELETE NO ACTION ON UPDATE NO ACTION
> )
> go
> Here's what's been added - all constraints are now named, the entire table
> is now seen and known (I've not included filegroups in the above example
> though) The entire table is listed in one foul swoop, everything is shown
> together at the same time, with the exception of listing the tables which
> depend on this table but that's another issue. These are the things that
> I think are lacking from products like ERWin. Don't mistunderstand me, I
> think they great tools for showing a table graphically, but for creating
> databases... I think there's alot to be desired. Also looking at the
> graphical tool, it's not easy to see what check constraints, defaults and
> indexes are available - the front end just doesn't show them. ERWin is
> good for the job is was designed for though - to show the relationship
> between tables.
> Regards
> Colin Dawson
> www.cjdawson.com
>|||Sounds to me like we're singing from the same hymm sheet. Just different
parts of it. Currently I'm a script jockey, as you saw from my previous
post I like to get things neat done one etc. as DBA for the company that I
work for, I'm trying to tighten up the database structures to make sure that
all foreign keys check constraints proper indexing etc, is in place. As I
don't have an unlimited amount of time to get everything into place and
working 100%, I took the decision early on that ERWin was as you say "it is
such a bother to use". For documentation ERWin is brilliant for creating
documentation, the diagrams are much better looking that the diagrams from
SQL Server, so the company tend to use these. Also lesser experiences
developers can use the tool for creating a basic table structure,
brainstorming and stuff like that to get something off the ground. Once
they're happy with the design, I have to perseude them to generate a script
then go through it with a fine too comb to be sure that they've not missed
anything. After they've finished, it's my turn and I spend ages giving the
developer the third degree and adding about a million extra contraints and
mocking their indexing ideas. However once corrected the database is
extremely well designed. I just wish that ERWin could read in a script and
learn the style that was used to create that script, then when using ERWin
to generate a script it generates a script as close a possible to the
original.
I've waffled for too long on this now.
Regards
Colin Dawson
www.cjdawson.com
"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:uAtpGSspFHA.3004@.TK2MSFTNGP15.phx.gbl...
> Yes, clearly this is better, and why I have built lots of macro code to
> implement this in ERwin. Alters are much easier to automatically
> generate, especially since you can do them again later (after dropping
> them of course.) The company I worked for a long time ago (and I work
> for them again today :) had a consultant who also worked with the original
> company that owned/wrote the original ERwin product (when it was pretty
> much all that there was.) Hence we have grown an insane number of macros
> that deal with everything, even turning on and off triggers, custom
> triggers, constraints, indexes, everything. It was not easy, but my code
> is really really useful, especially during rapid development because I can
> modify all of the objects in just minutes.
> I occasionally use the base ERwin functionality but only when I am in a
> hurry to do something small. I used to try to lobby for changes, but
> after CA purchased it I just have never found the right way, and I have
> all of this code that works. The only real problem is that it is such a
> bother to use I cannot even get coworkers to use it, much less sharing it
> with the world. Perhaps I will do something like that and post it on my
> blog one day.
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often
> convincing." (Oscar Wilde)
>
> "Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
> news:zp6Oe.93559$G8.66384@.text.news.blueyonder.co.uk...
>|||I used ERWIN for a short time myself and I did like it up to a point.
Unfortunately, it doesn't support SQL Server 2000's declarative referential
integrity (DRI) and creates triggers to cascade updates and deletes to
related tables.
For this reason alone I stopped using ERWIN. I found that the triggers
remained after I altered table/column names or relationships, which caused
updates/deletes to fail until I realised what was happening.
I'm sure it's great for SQL 7, but it would have to be configured properly
to be worthwhile in SQL 2000. IMO.
Thanks. Dan.
"PJ6" <nobody@.nowhere.net> wrote in message
news:%23%23eGBBmpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> I'm working with a developer that used ERWIN to create the database I have
> to interface with. At first glance I noticed that there are a ton of
> unecessary triggers, many of which look like they won't even be hit
because
> they're trying to detect and raise error messages for FK violations (when
> there are already FK contraints).
> I don't like what I'm seeing so far. Can anyone give me the lowdown about
> using this tool with SS2K?
> Paul
>|||I think so to. The basics we are both saying is that ERWin output sucks.
Cannot disagree with that, especially since I wrote my own script
generators, albeit in the ERwin tool :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Colin Dawson" <newsgroups@.cjdawson.com> wrote in message
news:bdgOe.93743$G8.59922@.text.news.blueyonder.co.uk...
> Sounds to me like we're singing from the same hymm sheet. Just different
> parts of it. Currently I'm a script jockey, as you saw from my previous
> post I like to get things neat done one etc. as DBA for the company that I
> work for, I'm trying to tighten up the database structures to make sure
> that all foreign keys check constraints proper indexing etc, is in place.
> As I don't have an unlimited amount of time to get everything into place
> and working 100%, I took the decision early on that ERWin was as you say
> "it is such a bother to use". For documentation ERWin is brilliant for
> creating documentation, the diagrams are much better looking that the
> diagrams from SQL Server, so the company tend to use these. Also lesser
> experiences developers can use the tool for creating a basic table
> structure, brainstorming and stuff like that to get something off the
> ground. Once they're happy with the design, I have to perseude them to
> generate a script then go through it with a fine too comb to be sure that
> they've not missed anything. After they've finished, it's my turn and I
> spend ages giving the developer the third degree and adding about a
> million extra contraints and mocking their indexing ideas. However once
> corrected the database is extremely well designed. I just wish that
> ERWin could read in a script and learn the style that was used to create
> that script, then when using ERWin to generate a script it generates a
> script as close a possible to the original.
> I've waffled for too long on this now.
> Regards
> Colin Dawson
> www.cjdawson.com
>
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:uAtpGSspFHA.3004@.TK2MSFTNGP15.phx.gbl...
>sql
Wednesday, March 21, 2012
Errors using DATEDIFF and DATEADD formulas
I am trying to use the DATEDIFF function in a formula, but it isn't
working. Here is the formula that I am entering into the "Define
Formula" dialog box:
DATEDIFF("day", TimeLogged, TimeClosed)
When I click ok, it gives me the message, "The arguments to the
following function are not valid: DATEDIFF". With that in mind, I
looked in the Help file for the report builder and under the "DATEDIFF
statement" documentation, it had the following example:
DATEDIFF("month", #1/1/2009#, #3/31/2009#)
This one yielded the same results. I also tried the DATEADD formula
and got the same type of error message. Other formulas, such as YEAR,
WEEK, etc. work fine.
Does anyone have any suggestions? I get the same results using both
the Report Builder and Visual Studio 2005.Hi,
the syntax is like this.
DATEDIFF("d", TimeLogged, TimeClosed)
This will work.
Amarnath.
"photogulliver" wrote:
> I am trying to use the DATEDIFF function in a formula, but it isn't
> working. Here is the formula that I am entering into the "Define
> Formula" dialog box:
> DATEDIFF("day", TimeLogged, TimeClosed)
> When I click ok, it gives me the message, "The arguments to the
> following function are not valid: DATEDIFF". With that in mind, I
> looked in the Help file for the report builder and under the "DATEDIFF
> statement" documentation, it had the following example:
> DATEDIFF("month", #1/1/2009#, #3/31/2009#)
> This one yielded the same results. I also tried the DATEADD formula
> and got the same type of error message. Other formulas, such as YEAR,
> WEEK, etc. work fine.
> Does anyone have any suggestions? I get the same results using both
> the Report Builder and Visual Studio 2005.
>
working. Here is the formula that I am entering into the "Define
Formula" dialog box:
DATEDIFF("day", TimeLogged, TimeClosed)
When I click ok, it gives me the message, "The arguments to the
following function are not valid: DATEDIFF". With that in mind, I
looked in the Help file for the report builder and under the "DATEDIFF
statement" documentation, it had the following example:
DATEDIFF("month", #1/1/2009#, #3/31/2009#)
This one yielded the same results. I also tried the DATEADD formula
and got the same type of error message. Other formulas, such as YEAR,
WEEK, etc. work fine.
Does anyone have any suggestions? I get the same results using both
the Report Builder and Visual Studio 2005.Hi,
the syntax is like this.
DATEDIFF("d", TimeLogged, TimeClosed)
This will work.
Amarnath.
"photogulliver" wrote:
> I am trying to use the DATEDIFF function in a formula, but it isn't
> working. Here is the formula that I am entering into the "Define
> Formula" dialog box:
> DATEDIFF("day", TimeLogged, TimeClosed)
> When I click ok, it gives me the message, "The arguments to the
> following function are not valid: DATEDIFF". With that in mind, I
> looked in the Help file for the report builder and under the "DATEDIFF
> statement" documentation, it had the following example:
> DATEDIFF("month", #1/1/2009#, #3/31/2009#)
> This one yielded the same results. I also tried the DATEADD formula
> and got the same type of error message. Other formulas, such as YEAR,
> WEEK, etc. work fine.
> Does anyone have any suggestions? I get the same results using both
> the Report Builder and Visual Studio 2005.
>
Monday, March 19, 2012
errors installing SQL Server Express 2005
I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.
After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.
I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.
Thanks in advance for help any of you can suggest.
Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006
Process ID : 2036
c:\6645bd818fccc8ef0bad80e6a12f5b\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/1/5 23:48:6
Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned true
Running: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6
Loaded DLL:c:\6645bd818fccc8ef0bad80e6a12f5b\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned true
Running: ValidateWinNTAction at: 2006/1/5 23:48:8
Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned true
Running: ValidateMinOSAction at: 2006/1/5 23:48:8
Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned true
Running: PerformSCCAction at: 2006/1/5 23:48:8
Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned true
Running: ActivateLoggingAction at: 2006/1/5 23:48:8
Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned true
Running: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8
Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.
Running: PerformSCCAction2 at: 2006/1/5 23:48:8
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned true
Running: PerformDotNetCheck at: 2006/1/5 23:48:9
Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned true
Running: ComponentUpdateAction at: 2006/1/5 23:48:9
Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned true
Running: DetectLocalBootstrapAction at: 2006/1/5 23:48:30
Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned true
Running: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30
Errors in the metadata manager
Hello,
I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message.
"Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . 0 0 "
Any ideas how to solve this problem?
Thank you in advance.
Looks like the data folder is corrupted. Could you please try the following steps:
1. Stop the Analysis Services service
2. Delete everything in your C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\%YOUR_PROJECTNAME% folder
3. Restart the Analysis Services service
4. Re-deploy your project
Hope this helps,
Artur
|||I already try this but without stopping the analysis services and didn't work.
I will try it again... thanks for the help:)
|||You should really stop Analysis Server :)
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, March 11, 2012
errors in ssis package execution
i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis packages
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal.
I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal.
I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>
errors in ssis package execution
i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis packages
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal."Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>packages
> were initially working fine,After installing sql server 2008 ctp, all ssis
> packages stopped executing and giving error "Could not create
> DTS.Application
> because of error 0x80040154", also import export wizard in sql 2005 is not
> working.
> After that i uninstalled sql server 2008 ctp and integration
> service of sql 2005, and again installed integrtaion service of sql 2005
> but
> still i am getting error in ssis package execution.Please suggest me a
> solution asap , as it is on a production server.
> Thanks
> Rupesh Mondal.
Hi Rupesh
Error Code 0x80040154 relates to class not registered, therefore it looks
like a SSIS component has been corrupted. The easiest solution may be to
remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
just get away with installing that.
John|||I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
> >packages
> > were initially working fine,After installing sql server 2008 ctp, all ssis
> > packages stopped executing and giving error "Could not create
> > DTS.Application
> > because of error 0x80040154", also import export wizard in sql 2005 is not
> > working.
> > After that i uninstalled sql server 2008 ctp and integration
> > service of sql 2005, and again installed integrtaion service of sql 2005
> > but
> > still i am getting error in ssis package execution.Please suggest me a
> > solution asap , as it is on a production server.
> >
> > Thanks
> > Rupesh Mondal.
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>|||Hi
Have you re-installed .NET? Otherwise I would re-install from scratch.
Hopefully this is not a production server!
John
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:81A467AD-B56B-44FC-92C9-D4FA96019C87@.microsoft.com...
>I had already removed and reinstalled "ssis" but it didnt worked ok,and i
> already had sp2 installed on my database server.
> Thanks and Regards,
> Rupesh Mondal.
> "John Bell" wrote:
>> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
>> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>> >packages
>> > were initially working fine,After installing sql server 2008 ctp, all
>> > ssis
>> > packages stopped executing and giving error "Could not create
>> > DTS.Application
>> > because of error 0x80040154", also import export wizard in sql 2005 is
>> > not
>> > working.
>> > After that i uninstalled sql server 2008 ctp and
>> > integration
>> > service of sql 2005, and again installed integrtaion service of sql
>> > 2005
>> > but
>> > still i am getting error in ssis package execution.Please suggest me a
>> > solution asap , as it is on a production server.
>> >
>> > Thanks
>> > Rupesh Mondal.
>> Hi Rupesh
>> Error Code 0x80040154 relates to class not registered, therefore it looks
>> like a SSIS component has been corrupted. The easiest solution may be to
>> remove and re-install SSIS or SQL Server. If you are not on SP2 then you
>> may
>> just get away with installing that.
>> John
>>
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal."Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>packages
> were initially working fine,After installing sql server 2008 ctp, all ssis
> packages stopped executing and giving error "Could not create
> DTS.Application
> because of error 0x80040154", also import export wizard in sql 2005 is not
> working.
> After that i uninstalled sql server 2008 ctp and integration
> service of sql 2005, and again installed integrtaion service of sql 2005
> but
> still i am getting error in ssis package execution.Please suggest me a
> solution asap , as it is on a production server.
> Thanks
> Rupesh Mondal.
Hi Rupesh
Error Code 0x80040154 relates to class not registered, therefore it looks
like a SSIS component has been corrupted. The easiest solution may be to
remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
just get away with installing that.
John|||I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
> >packages
> > were initially working fine,After installing sql server 2008 ctp, all ssis
> > packages stopped executing and giving error "Could not create
> > DTS.Application
> > because of error 0x80040154", also import export wizard in sql 2005 is not
> > working.
> > After that i uninstalled sql server 2008 ctp and integration
> > service of sql 2005, and again installed integrtaion service of sql 2005
> > but
> > still i am getting error in ssis package execution.Please suggest me a
> > solution asap , as it is on a production server.
> >
> > Thanks
> > Rupesh Mondal.
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>|||Hi
Have you re-installed .NET? Otherwise I would re-install from scratch.
Hopefully this is not a production server!
John
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:81A467AD-B56B-44FC-92C9-D4FA96019C87@.microsoft.com...
>I had already removed and reinstalled "ssis" but it didnt worked ok,and i
> already had sp2 installed on my database server.
> Thanks and Regards,
> Rupesh Mondal.
> "John Bell" wrote:
>> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
>> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>> >packages
>> > were initially working fine,After installing sql server 2008 ctp, all
>> > ssis
>> > packages stopped executing and giving error "Could not create
>> > DTS.Application
>> > because of error 0x80040154", also import export wizard in sql 2005 is
>> > not
>> > working.
>> > After that i uninstalled sql server 2008 ctp and
>> > integration
>> > service of sql 2005, and again installed integrtaion service of sql
>> > 2005
>> > but
>> > still i am getting error in ssis package execution.Please suggest me a
>> > solution asap , as it is on a production server.
>> >
>> > Thanks
>> > Rupesh Mondal.
>> Hi Rupesh
>> Error Code 0x80040154 relates to class not registered, therefore it looks
>> like a SSIS component has been corrupted. The easiest solution may be to
>> remove and re-install SSIS or SQL Server. If you are not on SP2 then you
>> may
>> just get away with installing that.
>> John
>>
Friday, February 24, 2012
Error:20533.Unable to Open Database
In my project I have used VB 6 and CR 8. In my machine the application is working fine. When it was loaded in the customer machine with windows 98 OS, when the report is clicked, it shows the error 'Error:20533 Unable to Open Database'. The Back end used is MS Access. Anybody pl. guide me to install my project? What to do and how to do?
Pl. post your reply due to urgency.Case 1)If u r running ur exe at client side u must place ur Database at the location u have given to ur DSN
Case 2)If u have installed ur setup at client side and just want to replace exe then check whethere u r replacing ur exe in the folder that has been installed on m/c|||Tried. But getting the same error.|||Open the Report and Do verify Database and map the columns if any|||Verify database. In my machine it works. I haven't installed the CR in the client machine. HOw to set right this problem. Is it necessary to load the CR in the client side? Pl. help
Meenakshi.R|||Did you use DSN to connect to CR?|||I haven't used any DSN for CR inthe client side. How to create that DSN for CR? pl. explain.|||How do you connect CR to database? Did you use OLE DB?
Create a DSN pointing to that DB and design reports. In the Client system create the same DSN and point it to that DB.
Otherwise refer this
http://www.businessobjects.com/support/default.asp
Pl. post your reply due to urgency.Case 1)If u r running ur exe at client side u must place ur Database at the location u have given to ur DSN
Case 2)If u have installed ur setup at client side and just want to replace exe then check whethere u r replacing ur exe in the folder that has been installed on m/c|||Tried. But getting the same error.|||Open the Report and Do verify Database and map the columns if any|||Verify database. In my machine it works. I haven't installed the CR in the client machine. HOw to set right this problem. Is it necessary to load the CR in the client side? Pl. help
Meenakshi.R|||Did you use DSN to connect to CR?|||I haven't used any DSN for CR inthe client side. How to create that DSN for CR? pl. explain.|||How do you connect CR to database? Did you use OLE DB?
Create a DSN pointing to that DB and design reports. In the Client system create the same DSN and point it to that DB.
Otherwise refer this
http://www.businessobjects.com/support/default.asp
Error: Unable to connect to the remote server.
I have been running RS for a month and it was working fine. However, now it is giving me the following error:
The underlying connection was closed: Unable to connect to the remote server.
Any ideas? Thanks
Is this both remotely and from the local server? And of course some of the basice questions:
Have you installed any new software?
Have you made any changes to your IIS?
Have there been any firewall changes?
Is this from all machines?
|||Yes, this is both remotely and from the server. SQL is intalled on the remote server. The error is from all machines. The only new software installed on the IIS (where RS is intalled) is Cold Fusion. This might be the cause, but I don't understand how? No firewall changes have been made.
Thanks
|||I don't know if this is an option, but have you tried to reinstall report services? or removing Cold Fusion. Also you may want to call the makers of Cold Fusion and see if they have heard anything like this.
To be honest I am taking stabs in the dark on this one, sorry.
Error: The service queue "ClientQueue" is currently disabled.
Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error:
The service queue "ClientQueue" is currently disabled.
Which I found from looking at the Service Broker Statistics Report is true. There are 5 queues total and only the dbo.ClientQueue is disabled.
Questions:
1). How do I enable it?
2).What caused it to become disabled?
I tried running the following commands:
1). alter database [dbo].[ServiceQueue] set enable_broker
2). alter database [ServiceQueue] set enable_broker
within the Microsoft SQL Server Management Studio.
Thanks
God Bless...
doug
1) ALTER QUEUE [ClientQueue] WITH STATUS = ONSee http://msdn2.microsoft.com/en-us/library/ms189529.aspx
2) Most likely you rolled back 5 RECEIVEs in a row, activating poison message detection.
See http://msdn2.microsoft.com/en-us/library/ms166137(en-US,SQL.90).aspx
HTH,
~ Remus|||Thanks!
That Worked!
Doug
Wednesday, February 15, 2012
Error: Subreport could not be shown
I've got a report with subreport, passing an id field from the main to the
sub, working fine in report designer, but when I upload and view the report
on the reportserver, I get "Error: Subreport could not be shown" on each
line where I would expect to see subreport data.
How stoopid am I being? I can't find any mentions of this error message on
MSDN, Books Online, general google search etc.
Anyone with any ideas?
--
Regards
Paul Paintinhowdy - did you get this problem sorted out? I am having exactly the same problem and cannot for the life of me find any documentation on the net to fix it!!!!
Please reply if you found out what the hell to do
cheers
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
sub, working fine in report designer, but when I upload and view the report
on the reportserver, I get "Error: Subreport could not be shown" on each
line where I would expect to see subreport data.
How stoopid am I being? I can't find any mentions of this error message on
MSDN, Books Online, general google search etc.
Anyone with any ideas?
--
Regards
Paul Paintinhowdy - did you get this problem sorted out? I am having exactly the same problem and cannot for the life of me find any documentation on the net to fix it!!!!
Please reply if you found out what the hell to do
cheers
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Subscribe to:
Posts (Atom)