Page 1 of 1

7.7.251 on Local Host-Cannot connect to URL

Posted: Tue Oct 09, 2012 12:48 pm
by AnySupport
Hello,
I'm completely stumped at what I did wrong, and yet cannot find a similar post for help here.

I'm running a development license of AbleCommerce 7.7 on a virtual machine for review.
  • I downloaded DataPort 7.7.251 and installed the program.
  • I moved the files from the ClientAPI\7.0.7\ Bin & Client API folders into the wwwroot\Bin and wwwroot\ClientAPI folders respectively.
  • I appended a prefix of OLD_... to the original files and moved them out to a folder on my desktop as a backup.
  • I restarted the IIS server and AbleCommerce will still run, but when I open the DataPort, it cannot understand my store URL.
My store URL is : http://newton/Default.aspx I've tried: newton, http://newton/Default.aspx, http://newton/, http://newton/store/
and the answer is always "Failed to connect - are you sure the URL is correct?"

I'm completely stumped at what is failing or how to troubleshoot this at all. I don't have much experience in troubleshooting IIS configurations, so any suggestions would be just hugely appreciated!
Thank you!

FROM HELP/ABOUT:
AbleCommerce for ASP.NET
VERSION: 7.0.7.14600
MSSQL v2008
AC SCHEMA v2005
.NET CLR v4.0.30319.269
ASP.NET TRUST: Unrestricted
...
CommerceBuilder.DataClient.Api: 7.7.14430.0
CommerceBuilder.DataClient.Csv: 7.0.34.0
...
DataPort.Framework: 7.4.221.0

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Tue Oct 09, 2012 5:34 pm
by david-ebt
Does the site itself work from any of the URLs you gave? Are you running this locally on the virtual machine? Is so, have you tried http://localhost or http://127.0.0.1?

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Wed Oct 10, 2012 6:31 am
by jmestep
I ran into the same problem with a site that was located at http://www.xxx.com/xxx/ .....
I think the dataport has a bug to where it not connect if the store is in a subfolder of the url.
I just gave up trying because I hadn't had a problem with any other site and it wasn't crucial to connect to this site- I just got a backup of the database to use.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Wed Oct 10, 2012 8:18 am
by AnySupport
The store URL is copied from the standard image link at the top of the admin section and does load the store without issue. Just using newton without a page loads the standard IIS cover image, so I didn't really expect that to work but I tried it after my own URL failed because the tool suggested it.

I will try providing the tool with localhost and the ip when I get to my desk again and will update with the results later today.

I ran a completely standard install as far as I understand for AbleCommerce so I'm just not sure why I'd have a setup at wouldn't work for the dataport tool standard install.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Mon Oct 15, 2012 10:30 am
by AnySupport
Sorry for the delay. Lost the rest of last week. I just tried again using the following:

IE Browser:
http://localhost/ --> IIS Homepage
http://localhost/Default.aspx --> switches to http://newton/Default.aspx and shows the store front

DataPort:
http://localhost/ , localhost, localhost/Default.aspx, http://localhost/Default.aspx
all resulted: Failed to connect - are you sure the store url is correct?

Any suggestions on how else to troubleshoot this?

Thanks!

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Wed Oct 17, 2012 11:19 am
by mikek
AbleCommerce Dataport utility uses clientapi/ClientApiService.ashx to communicate with the database. Make sure clientapi/ClientApiService.ashx page exist
and is accessible trough: http://newton/clientapi/ClientApiService.ashx

If the page is not accessible or generates exceptions then dataport will not work properly.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 11:09 am
by AnySupport
Hi Mike,

I just tried to access that page through the browser and got the following:

"We are sorry, but the page you are trying to access has experienced an error.
Please contact us to report this problem."

Is that just an IIS permission I would need to find/set up?

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 12:47 pm
by mikek
Enable custom error reporting customErrors mode="Off" in web config to get the exception error and see what is causing the issue.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 1:07 pm
by AnySupport
I found this in the error log in the AC Admin page:
10/18/2012 11:34:23 AM : Error : An error has occured at http://newton/clientapi/ClientApiService.ashx

Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\xy2pxaub.0.cs' could not be found error CS2008: No inputs specified
Then I found the web.config file and altered it.
Then the following appeared.
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.InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\Windows\TEMP\ddsyywm4.0.cs' could not be found
error CS2008: No inputs specified

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:

[InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\Windows\TEMP\ddsyywm4.0.cs' could not be found
error CS2008: No inputs specified
]
System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence) +1024
System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies) +1997
System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping xmlMapping, Type type, String defaultNamespace) +149
System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace) +549
System.Xml.Serialization.XmlSerializer..ctor(Type type) +6
CommerceBuilder.DataClient.Api.EncodeHelper.Serialize(Object ObjectToSerialize) +111
CommerceBuilder.DataClient.Api.AuthenticationHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context) +1209
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
(and sorry, I just can't ignore it: occured is incorrect in the AC Error log display. It should be occurred.)

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 1:15 pm
by mikek
It seems that the user account assigned to site application pool does not have List Folder Contents and Read permissions on the %windir%\Temp folder.

In IIS go to application pool settings and see what is the windows user account assigned to this applicaiton pool. From windows explorer navigate to c:\windows\temp, right click and under security add
permissions for this account. If the site is running on a local dev. machine you can assign all permissions.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 2:04 pm
by AnySupport
The Application Pool is running under NetworkService. The "SYSTEM" user has full control for c:\windows\temp, but NETWORK SERVICE is not listed anywhere. I have added NETWORK SERVICE as a user with Full Control, since this is just a virtual machine for evaluation purposes.

Now the DataPort tool is understanding "newton/default.aspx" and letting me by. Once I figured out which user I was supposed to give it to log in..

I got this:
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'FileName' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'MediaKey' for database table 'ac_DigitalGoods'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_GiftCertificates'.
Field length should be extended from '40' to '50' for field 'SerialNumber' for database table 'ac_GiftCertificates'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_OptionChoices'.
Field length should be extended from '20' to '255' for field 'SkuModifier' for database table 'ac_OptionChoices'.
Field length should be extended from '100' to '255' for field 'Name' for database table 'ac_OrderItemDigitalGoods'.
with options to say OK or SKIP
OK to let it attempt to modify the fields, SKIP to leave the field sizes alone.
I assume it's ok to let it try to modify the fields, but could you confirm this?

Is this a normal next step? I've not altered anything in our database table definitions (since I have no idea how), so I'm surprised the tool is taking issue with the standard database defs.

Thank you!

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 2:15 pm
by mikek
This is OK, extending database nvarchar from 100 to 255 is safe. Just press OK to continue. The operation will make changes to the database schema which will not affect your site functionality.

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Thu Oct 18, 2012 3:22 pm
by AnySupport
And now I'm in the tool finally! Thank you! Thank you! Thank you!

Re: 7.7.251 on Local Host-Cannot connect to URL

Posted: Wed Apr 10, 2013 9:38 am
by Tea-Dev
I am getting the following error but I am running IIS 7 and the user under application pool is not available.

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.InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\Windows\TEMP\ddsyywm4.0.cs' could not be found
error CS2008: No inputs specified

What need to be done to over come this issue?