PDS Error 0x238

[Steve]

I am getting sporadic PDS errors ni the Eventlog:
-----------------------------------------------------------
Component: PDS
Line: 0
Error Number: 0x238e
Description: <Description><![CDATA[CSecurity.PopulateProjectViewTables3;
-2147467259 : Method '~' of object '~' failed]]></Description>
___________________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ProjectAccessGrant; 1 Rows
deleted - this indicates a prior crash or an Access clash using the same SPID
and Mode ; SPID=208; RetryCount = 0;]]></Description>
____________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ResourceAccessGrant; 108 Rows
deleted - this indicates a prior crash or an Access clash using the same SPID
and Mode ; SPID=87;]]></Description

 

[Gary L. Chefetz [MVP]]

Steve:

I'm doing some educated guessing here. It looks like SQL server may be
throwing a fit over some bad character data in your database manifesting as
an access issue. Have you got a project name in your database with the '~'
tilda in it? Any with characters other than alpha, numeric and the
underscore?

 

[Steve]

Gary,

Thanks for your input. Unfortunately, this is the entire message. No
specific reference to the project is made. And while you'd think the SPID
might reference it, we have 4 instances of PS2003 running, and none of the
databases have project with the numbers shown.

Any additional ideas?

Steve
----------------------------------------------

Steve:

I'm doing some educated guessing here. It looks like SQL server may be
throwing a fit over some bad character data in your database manifesting as
an access issue. Have you got a project name in your database with the '~'
tilda in it? Any with characters other than alpha, numeric and the
underscore?

I am getting sporadic PDS errors ni the Eventlog:
-----------------------------------------------------------
Component: PDS
Line: 0
Error Number: 0x238e
Description: <Description><![CDATA[CSecurity.PopulateProjectViewTables3;
-2147467259 : Method '~' of object '~' failed]]></Description>
___________________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ProjectAccessGrant; 1 Rows
deleted - this indicates a prior crash or an Access clash using the same
SPID
and Mode ; SPID=208; RetryCount = 0;]]></Description>
____________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ResourceAccessGrant; 108
Rows
deleted - this indicates a prior crash or an Access clash using the same
SPID
and Mode ; SPID=87;]]></Description>

 

[Gary L. Chefetz [MVP]]

Steve:

You didn't answer my question about the use of special characters.

Gary,

Thanks for your input. Unfortunately, this is the entire message. No
specific reference to the project is made. And while you'd think the SPID
might reference it, we have 4 instances of PS2003 running, and none of
the
databases have project with the numbers shown.

Any additional ideas?

Steve
----------------------------------------------

Steve:

I'm doing some educated guessing here. It looks like SQL server may be
throwing a fit over some bad character data in your database manifesting
as
an access issue. Have you got a project name in your database with the
'~'
tilda in it? Any with characters other than alpha, numeric and the
underscore?

I am getting sporadic PDS errors ni the Eventlog:
-----------------------------------------------------------
Component: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3;
-2147467259 : Method '~' of object '~' failed]]></Description>
___________________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ProjectAccessGrant; 1
Rows
deleted - this indicates a prior crash or an Access clash using the
same
SPID
and Mode ; SPID=208; RetryCount = 0;]]></Description>
____________________________________________________________
Component: PDS
Line: 0
Description: <Description><![CDATA[CDataAccess.ResourceAccessGrant; 108
Rows
deleted - this indicates a prior crash or an Access clash using the
same
SPID
and Mode ; SPID=87;]]></Description>