Wednesday, January 20, 2010

SVN Error Object of the Same Name as the Administrative Directory

Problem:

When checking out files from SVN the following error is reported:

Failed to add directory
'C:\Inetpub\wwwroot\AddictionTee_com_loc\Admin\Editor\scripts\language\_svn':
object of the same name as the administrative directory

Solution:

SVN files have been added as files under source control.  i.e. svn files where included in files explicitly committed to the repository.  Remove these files as indicated by the path in the error message.  Also search the entire folder hierarchy for additional SVN files.

Monday, January 18, 2010

ASPDNSF Cannot Login to Admin

Problem:
Cannot login to admin.  Always prompts to change password not matter what password is entered.
Solution:
UPDATE [Customer]
     SET [Password] = 'your new password here',
           [SaltKey] = -1,
           [LockedUntil] = DateAdd(d, -1, GetDate()),
           [BadLoginCount] = 0,
           [PwdChangeRequired] = 0,
           [PwdChanged] = GetDate()
     WHERE [Email] = 'your admin email address here'
and then touch web.config to recompile website.

Thursday, January 14, 2010

IS Report Errors After Report SaveAs

Version: Interprise Suite 2007 SP5.3.3

Problem:

When creating a copy of an existing report using File –> SaveAs, the new report generates various errors when viewed.

Solution:

Bind/fix all report fields as per the following documentation.

Wednesday, January 13, 2010

IS Lock Down of Inventory Item Code

Version: Interprise Suite 2007 5.3.4

Problem:

Inventory item codes can be easily changed which changes the url of the item in Interprise Suite E-Commerce.

Solution:

One of the new features in SP 5.3.4 is the lock down of item code editing.  This new feature will prevent users from accidentally changing the item code. In order to edit this you now need to do a right click and select edit to change the item name/code.

Friday, January 8, 2010

ASPDNSF WSI Event Callback Not Firing

AspDotNetStorefront Version: 8.0.1.2

Problem:

An event is added in AspDotNetStorefront admin with the full url of the external page to run.  However, the external page does not run on that event.

Solution:

The EventHandler.aspx must have the page setting ValidateRequest="false"

e.g. <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="EventHandler.aspx.cs" Inherits="EventHandler" ValidateRequest="false" %>

After New IS Upgrade, 'IsInitializeOnFormLoad' Client Error

Version: Interprise Suite 5.3.3

Problem:

After upgrading to version 5.3.3 the client reports error 'IsInitializeOnFormLoad' when trying to view any form.

The following exception was caught by the Interprise Suite.

10/03/2009 23:07:00
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Invalid column name 'IsInitializeOnFormLoad'.
Source : .Net SqlClient Data Provider

Solution:

Manually delete the IS SQL Server cache database on the client e.g. 6FE7FCC4-C588-4397-935C-859769A1C657

IS Error When Printing Purchase Order

Version: Interprise Suite 2007 5.3 ebiz

Problem:

The following error is generated when trying to print a purchase order:

The value for column ‘Contact’ in table ‘SupplierPurchaseOrder’ is DBNull

Solution:

IS: Open the supplier, click the setup tab and update the following columns:

Default Contact Name
Accounts Contact Name
Sales Contact

or

Database: Update the following columns in table Supplier:

SupplierContactCode
DefaultAPContact
DefaultContact