|
Home > Archive > Microsoft Content Management Server > November 2004 > Save Placeholder Failed Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Save Placeholder Failed Error
|
|
| Pradnya 2004-04-14, 3:33 pm |
| Hi,
I get above error with details as "Server ODBC error.
Contact the site administrator." It happens
intermittently.Any idea how to resolve this ?
Thanks,
Pradnya
| |
| Manasvin@msnews.microsoft.com 2004-04-14, 3:33 pm |
| Looks Like CMS cannot contact the SQL server intermittently . Is your DB on
a separate machine ?
Piyush
"Pradnya" <pradnya@singtel.com> wrote in message
news:17c6401c421ff$8ddb8ed0$a001280a@phx
.gbl...
> Hi,
>
> I get above error with details as "Server ODBC error.
> Contact the site administrator." It happens
> intermittently.Any idea how to resolve this ?
>
> Thanks,
> Pradnya
| |
| Pradnya 2004-04-14, 10:37 pm |
| Yup, SQL database is on a separate server.Any
resolution/workaround to this problem ?
Cheers,
Pradnya
>-----Original Message-----
>Looks Like CMS cannot contact the SQL server
intermittently . Is your DB on
>a separate machine ?
>
>Piyush
>
>"Pradnya" <pradnya@singtel.com> wrote in message
> news:17c6401c421ff$8ddb8ed0$a001280a@phx
.gbl...
>
>
>.
>
| |
| Stefan [MSFT] 2004-04-14, 11:41 pm |
| Hi Pradnya,
Piyush is right.
Seems as if you have database connectivity issues.
MCMS uses the ODBC interface to connect to the database and relies on a
valid ODBC database connection.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manasvin@msnews.microsoft.com" <manasvin@hotmail.com> wrote in message
news:OnRwndkIEHA.2972@TK2MSFTNGP12.phx.gbl...
> Looks Like CMS cannot contact the SQL server intermittently . Is your DB
on
> a separate machine ?
>
> Piyush
>
> "Pradnya" <pradnya@singtel.com> wrote in message
> news:17c6401c421ff$8ddb8ed0$a001280a@phx
.gbl...
>
>
| |
| anonymous 2004-04-15, 12:39 am |
| Hey Pradnya,
You may have to re-write the code to stop it from creating
too many CmsContexts within a single function call. Step
through the code and look for functions that create the
CmsContext and functions within the function that does
that. I've found that the problem is more pronounced when
using same variable names to hold the context within the
same HTTP request. I would suggest passing the context in
as a parameter insted of recreating it and disposing them
when you don't need it anymore.
I'm not convinced that it's a connection to the DB (seeing
that none of the other apps on the same server and web
site have this problem), it may be something to do with
the way the objects work (in particular, CmsContext) with
the database on the application level - just a pure guess.
Cheers to you too,
M
>-----Original Message-----
>Yup, SQL database is on a separate server.Any
>resolution/workaround to this problem ?
>
>Cheers,
>Pradnya
>
>intermittently . Is your DB on
>.
>
| |
| Stefan [MSFT] 2004-04-15, 12:39 am |
| Hi Pradnya,
you need to fix your database connection.
Ensure that the database is always available.
For details: post to a networking related newsgroup.
This is not a CMS topic.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pradnya" <pradnya@singtel.com> wrote in message
news:1cb2f01c42290$a5fcce20$a301280a@phx
.gbl...[vbcol=seagreen]
> Yup, SQL database is on a separate server.Any
> resolution/workaround to this problem ?
>
> Cheers,
> Pradnya
>
> intermittently . Is your DB on
| |
|
| Hi Stefan,
I work with Pradnya.
The database is always available. Other modules are
connected to it and they don't get this problem. We are on
HA where the server is monitored. So if the database is
down, alarm bells start ringing and we will know. The
problem can be isolated to this particular module (whose
code I am partly responsible for and therefore know
it's "problems").
Curious, what kinds of connection issues do you suspect?
regards
M
>-----Original Message-----
>Hi Pradnya,
>
>you need to fix your database connection.
>Ensure that the database is always available.
>For details: post to a networking related newsgroup.
>This is not a CMS topic.
>
>Cheers,
>Stefan.
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>"Pradnya" <pradnya@singtel.com> wrote in message
> news:1cb2f01c42290$a5fcce20$a301280a@phx
.gbl...
>
>
>.
>
| |
| Stefan [MSFT] 2004-04-15, 3:41 am |
| Hi M,
I'm not a networking expert. I only can say that this error message is
coming up from the ODBC layer - a part of the OS (MDAC) which reports a
problem with the database connection.
In the part I have seen this when (e.g.) a network card or a switch caused
troubles.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"M" <anonymous@discussions.microsoft.com> wrote in message
news:1cc1001c422b1$a887e2d0$a501280a@phx
.gbl...[vbcol=seagreen]
> Hi Stefan,
>
> I work with Pradnya.
>
> The database is always available. Other modules are
> connected to it and they don't get this problem. We are on
> HA where the server is monitored. So if the database is
> down, alarm bells start ringing and we will know. The
> problem can be isolated to this particular module (whose
> code I am partly responsible for and therefore know
> it's "problems").
>
> Curious, what kinds of connection issues do you suspect?
>
> regards
> M
>
> confers no rights.
| |
|
| Hi Stefan,
Is there a possibility that codes such as this could cause
this problem?
public void A()
{
CmsApplicationContext cmsContext = new
CmsApplicationContext()
//do whetever it takes to create new context
foreach(object in objectCollection)
{
call function B
}
}
public void B()
{
CmsApplicationContext cmsContext = new
CmsApplicationContext()
....
call B recursively
}
In essence, the CmsApplicationContext is created
repeatedly multiple times within a single request. Up to a
certain number (especially if they are all referenced by
local variables of the same name), the connection to the
DB starts to fail. There may be other factors, I'm not
sure. Wild guess: Is something getting pooled and maybe a
boundary condition breached?
I'm making a pure guess by linking the ODBC and the
CmsContext objects with this error. The reason behind this
is because when I cleaned up the codes to use a single
context within the functions, the problem disappeared.
It's only this *one* module (was rushed out hence the less
than perfect code). Other modules do not face this problem
and are executing fine, connecting to the database 100% of
the time, so I'm not leaning towards the network
connectivity side of the explanation ;-)
M
>-----Original Message-----
>Hi M,
>
>I'm not a networking expert. I only can say that this
error message is
>coming up from the ODBC layer - a part of the OS (MDAC)
which reports a
>problem with the database connection.
>In the part I have seen this when (e.g.) a network card
or a switch caused
>troubles.
>
>Cheers,
>Stefan.
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>"M" <anonymous@discussions.microsoft.com> wrote in message
> news:1cc1001c422b1$a887e2d0$a501280a@phx
.gbl...
on[vbcol=seagreen]
and[vbcol=seagreen]
error.[vbcol=seagreen]
>
>
>.
>
| |
| Manasvin@msnews.microsoft.com 2004-04-15, 4:39 am |
| Hi
Is it possible for you to monitor the number of connections and the like
using performance monitor on the CMS server machine ? This might give some
clues
Manasvin
"M" <anonymous@discussions.microsoft.com> wrote in message
news:184db01c422c0$919b0f20$a001280a@phx
.gbl...[vbcol=seagreen]
> Hi Stefan,
>
> Is there a possibility that codes such as this could cause
> this problem?
>
> public void A()
> {
> CmsApplicationContext cmsContext = new
> CmsApplicationContext()
>
> //do whetever it takes to create new context
>
> foreach(object in objectCollection)
> {
> call function B
> }
> }
>
> public void B()
> {
> CmsApplicationContext cmsContext = new
> CmsApplicationContext()
> ...
>
> call B recursively
> }
>
> In essence, the CmsApplicationContext is created
> repeatedly multiple times within a single request. Up to a
> certain number (especially if they are all referenced by
> local variables of the same name), the connection to the
> DB starts to fail. There may be other factors, I'm not
> sure. Wild guess: Is something getting pooled and maybe a
> boundary condition breached?
>
> I'm making a pure guess by linking the ODBC and the
> CmsContext objects with this error. The reason behind this
> is because when I cleaned up the codes to use a single
> context within the functions, the problem disappeared.
>
> It's only this *one* module (was rushed out hence the less
> than perfect code). Other modules do not face this problem
> and are executing fine, connecting to the database 100% of
> the time, so I'm not leaning towards the network
> connectivity side of the explanation ;-)
>
> M
>
> error message is
> which reports a
> or a switch caused
> confers no rights.
> on
> and
> error.
| |
| Stefan [MSFT] 2004-04-15, 2:13 pm |
| Yes.
You should not create CmsApplicationContext recursivly.
Why don't you pass the existing context to the routine and only use one
CmsApplicatonContext?
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"M" <anonymous@discussions.microsoft.com> wrote in message
news:184db01c422c0$919b0f20$a001280a@phx
.gbl...[vbcol=seagreen]
> Hi Stefan,
>
> Is there a possibility that codes such as this could cause
> this problem?
>
> public void A()
> {
> CmsApplicationContext cmsContext = new
> CmsApplicationContext()
>
> //do whetever it takes to create new context
>
> foreach(object in objectCollection)
> {
> call function B
> }
> }
>
> public void B()
> {
> CmsApplicationContext cmsContext = new
> CmsApplicationContext()
> ...
>
> call B recursively
> }
>
> In essence, the CmsApplicationContext is created
> repeatedly multiple times within a single request. Up to a
> certain number (especially if they are all referenced by
> local variables of the same name), the connection to the
> DB starts to fail. There may be other factors, I'm not
> sure. Wild guess: Is something getting pooled and maybe a
> boundary condition breached?
>
> I'm making a pure guess by linking the ODBC and the
> CmsContext objects with this error. The reason behind this
> is because when I cleaned up the codes to use a single
> context within the functions, the problem disappeared.
>
> It's only this *one* module (was rushed out hence the less
> than perfect code). Other modules do not face this problem
> and are executing fine, connecting to the database 100% of
> the time, so I'm not leaning towards the network
> connectivity side of the explanation ;-)
>
> M
>
> error message is
> which reports a
> or a switch caused
> confers no rights.
> on
> and
> error.
| |
| Stefan [MSFT] 2004-04-15, 2:13 pm |
| Hi Manasvin,
this is more an SQL related question.
I'm sure SQL server has monitoring tools to monitor the number of
connections coming in from a specific machine.
But this is better asked on a SQL related newsgroup.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manasvin@msnews.microsoft.com" <manasvin@hotmail.com> wrote in message
news:OiDZfNsIEHA.3968@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Is it possible for you to monitor the number of connections and the like
> using performance monitor on the CMS server machine ? This might give some
> clues
>
> Manasvin
>
> "M" <anonymous@discussions.microsoft.com> wrote in message
> news:184db01c422c0$919b0f20$a001280a@phx
.gbl...
>
>
| |
|
| Thanks, Stefan - is there a change in how resource gallery access should be
configured in sp1a. This error is now shows to the users who are in the
role of authors for the channel, before upgrade they couold add attachments
to all resource galleries even despite they were not in any resource-related
group
"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:u7nKXaGvEHA.1204@TK2MSFTNGP10.phx.gbl...
> Hi Ilona,
>
> this can happen if the author is saving placeholder content containing
links
> to resource gallery items where he does not have rights to.
> E.g. if a different author has created the posting and added an image from
a
> resource gallery where the second author who updates the posting does not
> have rights to.
>
> This can also happen if the resource gallery items has been deleted
> meanwhile.
> As the item will still remain in the repository as it is referenced but in
a
> special folder (archive folder) where only administrators have rights to.
>
> Cheers,
> Stefan.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> MCMS FAQ:
>
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/...t+S
erver
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
> --------------------------------
>
>
> "ilona" <ilona_scrambled@no-go.com> wrote in message
> news:u1YfW$EvEHA.1404@TK2MSFTNGP11.phx.gbl...
item.[vbcol=seagreen]
> means
>
>
| |
|
|
|
| Stefan,
after giving authors permissions to all resource galleries to all authors
they are still getting the Save Placeholder Error.
No authors can get around this error till their content that includes
resource gallery items is deleted by Administrator (with content cut) and
then the content pasted back in when you log in as that author. While doing
this, resource gallery items have to be re-added from scratch by the author.
Only after all this it finally works.
This problem is HUGE because about 60 authors can not successfully update
their content. Is there a fix that can be applied on the large scale like
this?
"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:eA0ECXMvEHA.4028@TK2MSFTNGP15.phx.gbl...
> Hi Ilona,
>
> these users need to have author rights on the resource galleries.
> There was a bug in RTM which allowed authors to see resource galleries
they
> didn't have author rights at which was corrected with SP1.
>
> Cheers,
> Stefan.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> MCMS FAQ:
>
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm
> MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
> MCMS Sample Code:
>
http://www.gotdotnet.com/community/...t+S
erver
> MCMS Whitepapers and other docs:
> http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
> --------------------------------
>
>
> "ilona" <ilona_scrambled@no-go.com> wrote in message
> news:#ooVrJJvEHA.3748@TK2MSFTNGP10.phx.gbl...
> be
> attachments
> resource-related
> from
> not
but[vbcol=seagreen]
> in
> to.
>
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm
>
http://www.gotdotnet.com/community/...t+S
erver
Placeholder[vbcol=seagreen]
it[vbcol=seagreen]
>
>
| |
|
|
|
|
|
|
|