Hi Buck,

I just installed BD6 alongside fatgeorge FileUpload 3.2 and XMod 5.5 on a DNN install v4.09.04. Upon installing XMod alone or XMod + fatgeorge, XMod and the fairly empty portal run very fast, however after installing BD6, before I can even configure anything I get XMod crashing with this error every time. Any ideas on what is causing this? Everything is installed by the documentation exactly, I can't understand why these products aren't playing together nicely. Any thoughts? I have to have this working (read: at least navigable) by tomorrow...

Error: XMod 5.5 is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] buff, Int32 offset, Int32 len) at System.Data.SqlClient.TdsParserStateObject.ReadString(Int32 length) at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ReadColumnData() at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at DotNetNuke.Common.Utilities.CBO.HydrateObject(Object objObject, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.CreateObject(Type objType, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.FillCollection(IDataReader dr, Type objType) at KnowBetter.XMod.FormController.GetForms(Int32 PortalId) at KnowBetter.XMod.XModDisplay.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Hi Ben,

We have many Business Directory customers successfully using Business Directory on XMod 5.5.

My first thought is to get the FatGeorge FileUpload Control 3.5.3.

The 3.2 version is not XMod 5.5 compatible.

If you purchased the FatGeorge module at Snowcovered.com, the new version should be in the patches and hot fix section of Your Account.

or

Contact FatGeorge at http://fatgeorge.co.uk.

Buck

Ben,

Another thought is to make sure that your installation of DotNetNuke did not include a database object qualifier.

DBobjectQualifier - This form parameter is used for the SQL database calls in the form. It is a combination of the database user permission and the database qualifier. The parameter default is .dbo. In most cases you can leave this parameter set at its default value. If you have set a unique qualifier, during the DotNetNuke wizard installation, you will need to replace the default value with the user permission and qualifier. Note: This value is the prefix to all of your DotNetNuke database tables. Example: dbo.portal2_

You can also contact Kelly Ford, developer of XMod, and pass the XMod error to him at:

http://dnndev.zendesk.com/login

Thank you for your input so far, I am not 100% clear on what i should be looking for in a DBobject Qualifier. Are you saying that I want it to be the default dbo, or that I should change it to reflect the id of each portal? Chances are it is the default now as the installation is setup through our hosting provider - is that something that we would have to request in order to use BD6?

Also, I did try upgrading FatGeorge upload control to 3.5.3, without any change in performance. Could it be a lack of resources from our servers, or is it definitely a setup issue?

Thanks again,

Ben

Hi Ben,

When DotNetNuke users install DotNetNuke through the install wizard they are asked if they want to set an object qualifier for the database.

The way to check Business Directory if the default dbo. setting is working is if you can see a list of states and countries in the associated drop down boxes on the BD6 form, then it is working correctly.

If you can retrieve states and countries you do not need to change the object qualifier.

We have hundreds of BD6 clients using the product without a report of the error that you describe.

Xmod is typically very fast since it is XML based.

That is the reason I wanted you to check with Kelly Ford and see if he recognizes the errors as XMod issues or DotNetNuke version issues.

If you want me to take a quick look and see if your BD6 is configured correctly, send the site URL and a temp host login and password to support@dnnprofessor.com.

Buck

Buck,

Thank you for all of your help, I asked the same question on the XMod help desk that you left a link to, and they seemed to think it was due to a database resource problem or a bottleneck of some kind. We switched hosting providers and are now able to run the business directory without any problems.

Thanks so much for your assistance!

Ben