Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problem DashBoard in APFW (Act! Premium for Web)

New Member
Posts: 3
Country: United States

Problem DashBoard in APFW (Act! Premium for Web)

I' have a problem when my users try to access the option Dashboard at APFW, and the system generates the following error in ErrorLog.xls y the application produce an error and logoff.

 

SOURCE: .Net SqlClient Data Provider
MESSAGE: Conversion failed when converting from a character string to uniqueidentifier.
FORM:
QUERYSTRING: dashFile=ACT!+Default+Dashboard.dsh&type=render&dashComp=TopOpportunities5b2a5cba70024533984c06a571f29450&ctype=TopOpportunities&height=162&width=435&fontSize=8&fontFamily=Tahoma&marginSpacing=4&fontSizeBestFit=true&cachbuster=0.019811763132450644
TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean)
STACKTRACE:    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, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Act.Framework.ComponentModel.BaseManagerDB.LoadKeysFromDataReader(IDataReader dr, List`1 list, InitialFetchCancellingMonitor cancellingMonitor)
   at Act.Framework.ComponentModel.BaseManagerDB.GetDataKeys(SortCriteria[] sortCriteria, InitialFetchCancellingMonitor cancellingMonitor)
REFERER: http://xxxxx.com/APFW/Dashboard/default.aspx
2/22/2009 9:10:27 PM Error creating component, OpportunityPipelineByStage.
Conversion failed when converting from a character string to uniqueidentifier.
2/22/2009 9:10:28 PM Error creating component, OpportunitiesByUser.
Conversion failed when converting from a character string to uniqueidentifier.
2/22/2009 21:10
SOURCE: .Net SqlClient Data Provider
MESSAGE: Conversion failed when converting from a character string to uniqueidentifier.
FORM:
QUERYSTRING: dashFile=ACT!+Default+Dashboard.dsh&type=render&dashComp=TopOpportunities5b2a5cba70024533984c06a571f29450&ctype=TopOpportunities&height=162&width=435&fontSize=8&fontFamily=Tahoma&marginSpacing=4&fontSizeBestFit=true&cachbuster=0.723203403620027
TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean)
STACKTRACE:    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, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Act.Framework.ComponentModel.BaseManagerDB.LoadKeysFromDataReader(IDataReader dr, List`1 list, InitialFetchCancellingMonitor cancellingMonitor)
   at Act.Framework.ComponentModel.BaseManagerDB.GetDataKeys(SortCriteria[] sortCriteria, InitialFetchCancellingMonitor cancellingMonitor)
REFERER: http://xxxxx.com/APFW/Dashboard/default.aspx
2/22/2009 21:10
SOURCE: Act.Web
MESSAGE: Object reference not set to an instance of an object.
FORM:
QUERYSTRING: dashFile=ACT!+Default+Dashboard.dsh&type=render&dashComp=SalesToDate1b8b38ec44c5484d9ad78a021bf95959&ctype=SalesToDate&height=162&width=384&fontSize=8&fontFamily=Tahoma&marginSpacing=4&fontSizeBestFit=true&cachbuster=0.8937717006211552
TARGETSITE: Void OnInit(System.EventArgs)
STACKTRACE:    at Act.Web.Dashboard.DashboardXmlHttp.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
REFERER: http://xxxxx.com/APFW/Dashboard/default.aspx
 

 

Tks.

Moderator
Posts: 4,395
Country: USA

Re: Problem DashBoard in APFW (Act! Premium for Web)

What version of AFW are you using?  Do all users have this issue?  Try restarting IIS and SQL on the server.
New Member
Posts: 3
Country: United States

Re: Problem DashBoard in APFW (Act! Premium for Web)

We have a Version 11.0.1.504

I found that my users had registers in tha applications with characters how %, ", ' etc...  i'd like to know which characters are invalid in the web version?

 

Tks.

New Member
Posts: 1
Country: United Kingdom

Re: Problem DashBoard in APFW (Act! Premium for Web)

Hi

 

Did you ever solve your problem here? We are experiencing the same thing..

 

Any hints?

 

Thanks