VersaDev 
VersaDev
VersaDev
VersaDev
Delivering Business Software Solutions
Welcome Guest Search | Active Topics | Members | Log In | Register

Problems in CRM module Options
Heather
Posted: Thursday, July 10, 2008 3:09:56 PM
Rank: Newbie
Groups: Member

Joined: 7/10/2008
Posts: 3
Points: 9
Location: New Zealand
When I open a contact or organisation and click on either Assets, Calls or Communications I get the following error:

Server Error in '/' Application.


The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /versasrs/ntautologon.aspx



Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433


It appears to be trying to load the page from my local PC rather than the servers URL. I have gone through the DSN settings a hundred times and can't figure this one out.

Thanks,

Heather
David@VersaDev
Posted: Thursday, July 10, 2008 4:19:41 PM

Rank: Member
Groups: Member

Joined: 5/8/2008
Posts: 13
Points: 45
Location: Adelaide - Australia
Hello,

Please open SQL Management Studio and open table tbl_ApplicationSettings, then modify the property versaSRSURL (ID=1019) - modify the column Value1 to reflect the URL of versaSRS. E.g. http://my_server_name/versaSRS

After setting the necessarry string for this setting - ensure that you force a reload of the Application Global Setting through versaSRS.

To do this, select the Administrator Menu option, then chose 'System Tools > System Info' --> scroll down this panel and click the "RELOAD GLOBAL SETTINGS" button.

Knowledge Base article relating to Application Settings and Global Settings Reload; http://www.versadev.com/kbview.aspx?kbaid=176

Cheers,
David
VersaDev
Heather
Posted: Friday, July 11, 2008 6:40:51 AM
Rank: Newbie
Groups: Member

Joined: 7/10/2008
Posts: 3
Points: 9
Location: New Zealand
Thanks,

That did the trick.

One more question.... Is there any way to edit the list of Asset type defintions within the system or do I have to edit the SQL Table?

Heather
Warren
Posted: Friday, July 11, 2008 10:26:43 AM

Rank: Member
Groups: Member

Joined: 5/5/2008
Posts: 2
Points: 6
Location: Australia
There is currently no GUI to perform this. However, you can easily extend the available asset types via the database.

To add a new asset type,open the versaSRS database and add a new record to the table tbl_VersaAssetTypes. Please note that AssetTypeID should be set to a unique negative integer value (e.g. -1), ManagedExternally must be set to a value of 0 and ModuleTypeID must be set to a value of 2.

Warren
pcguru01
Posted: Monday, August 10, 2009 10:12:18 PM
Rank: Newbie
Groups: Member

Joined: 8/10/2009
Posts: 1
Points: 3
Location: Australia
Hi I'm also having a problem with the CRM module. I get the followin in versaSRS when clicking on the "My CRM" drop down:

Server Error in '/VERSASRS' Application.


Invalid object name 'tbl_Users'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'tbl_Users'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Invalid object name 'tbl_Users'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +180
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +128
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(CommandType commandType, String commandText) +57
VersaCRM.SecurityCheck.IsAdministrator() +93
VersaCRM.OrganizationList.Show_Organizations_ByPage(Int32 SortBy) +326
VersaCRM.OrganizationList.Page_Load(Object sender, EventArgs e) +443
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


When I check the CRMWebServiceURL it points to: http://localhost/versacrm/services/contact_details_service/contact_details_service.asmx

I tried to find the folder /versacrm/services/contact_details_service but it doesn't exist.

Any ideas? Eh?

Ben
Philip@versadev
Posted: Monday, August 17, 2009 3:37:53 PM
Rank: Administration
Groups: Administration , Member

Joined: 11/20/2008
Posts: 46
Points: 41
Location: Australia
Hi,

You will need to check in the versaSRS-SMC and make sure that the connection string for the field 'CRMDSN' is the same as the 'versaSRSDSN' field. Also open the database and make sure that the tbl_Users table is there.

Cheers,
Philip
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.107 seconds.