Problems with custom field - PLEASE

[Rafael_arcângelo]

Hi guys,

I'm very sad because this. . I have a lot of custom fields (+-10). A
create a view with these customs field in PWA. The problem is, with small
project about 100 lines, the project shows very good. But , with project
about 3.000 lines the project detais shows this message :
"Project Center cannot access the project(s) you are trying to view. It is
most likely that you either don’t have the permissions to view the project,
another user has deleted this project(s) before you were able to view it or
that another user is in the process of publishing the project"

when i see the logs, it shows this :

11/29/2008 13:44:01.82 w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable PWA:http://200.253.157.10/PACRIOANIL, SSP:SharedServices1,
User:MATHESIS\rafael, PSI: PWA.ProjectGetProjectDetailsForGrid SqlException
occurred in DAL:
<Error><Class>11</Class><LineNumber>0</LineNumber><Number>-2</Number><Procedure></Procedure>
<Message> System.Data.SqlClient.SqlError: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding. </Message> <CallStack> at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior... e43b3bc9-0b1a-4871-a949-d5177ae05cf0
11/29/2008 13:44:01.82* w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable ..., SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet
dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32
.... e43b3bc9-0b1a-4871-a949-d5177ae05cf0

anybody could help me... thanks a lot.

Rafael
Brazil

 

[Sander]

Hi Rafael,

Your are pushing your hardware over the limit with this. As you see in the log
System.Data.SqlClient.SqlError: Timeout expired
It cannot process the request fast enough to display your data.

What is the server setup you use at this moment? (eg how many servers/ which
roles / hardware config etc...)

Sander

Hi guys,

I'm very sad because this. . I have a lot of custom fields (+-10). A
create a view with these customs field in PWA. The problem is, with small
project about 100 lines, the project shows very good. But , with project
about 3.000 lines the project detais shows this message :
"Project Center cannot access the project(s) you are trying to view. It is
most likely that you either don’t have the permissions to view the project,
another user has deleted this project(s) before you were able to view it or
that another user is in the process of publishing the project"

when i see the logs, it shows this :

11/29/2008 13:44:01.82 w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable PWA:http://200.253.157.10/PACRIOANIL, SSP:SharedServices1,
User:MATHESIS\rafael, PSI: PWA.ProjectGetProjectDetailsForGrid SqlException
occurred in DAL:
<Error><Class>11</Class><LineNumber>0</LineNumber><Number>-2</Number><Procedure></Procedure>
<Message> System.Data.SqlClient.SqlError: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding. </Message> <CallStack> at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior... e43b3bc9-0b1a-4871-a949-d5177ae05cf0
11/29/2008 13:44:01.82* w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable ..., SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet
dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32
... e43b3bc9-0b1a-4871-a949-d5177ae05cf0

anybody could help me... thanks a lot.

Rafael
Brazil

 

[Gary L. Chefetz]

Rafael:

I think you may be running across a known issue with configurations with
numerous task-level fields. Please verify that this is your situation. Let
us know how many custom task fields you have, how many projects, how many
average lines and let us know what patch levels your system is at.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Hi guys,

I'm very sad because this. . I have a lot of custom fields (+-10).
A
create a view with these customs field in PWA. The problem is, with small
project about 100 lines, the project shows very good. But , with project
about 3.000 lines the project detais shows this message :
"Project Center cannot access the project(s) you are trying to view. It is
most likely that you either don’t have the permissions to view the
project,
another user has deleted this project(s) before you were able to view it
or
that another user is in the process of publishing the project"

when i see the logs, it shows this :

11/29/2008 13:44:01.82 w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable PWA:http://200.253.157.10/PACRIOANIL,
SSP:SharedServices1,
User:MATHESIS\rafael, PSI: PWA.ProjectGetProjectDetailsForGrid
SqlException
occurred in DAL:
<Error><Class>11</Class><LineNumber>0</LineNumber><Number>-2</Number><Procedure></Procedure>
<Message> System.Data.SqlClient.SqlError: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding. </Message> <CallStack> at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior... e43b3bc9-0b1a-4871-a949-d5177ae05cf0
11/29/2008 13:44:01.82* w3wp.exe (0x0F7C)
0x0158 Project Server Project Server - General
8ym5 Monitorable ..., SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet
dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32
... e43b3bc9-0b1a-4871-a949-d5177ae05cf0

anybody could help me... thanks a lot.

Rafael
Brazil