7.7.251 on Local Host-Cannot connect to URL

A forum where issues related to the DataPort utility can be discussed.
Post Reply
User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Tue Oct 09, 2012 12:48 pm

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

User avatar
david-ebt
Captain (CAPT)
Captain (CAPT)
Posts: 253
Joined: Fri Dec 31, 2010 10:12 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by david-ebt » Tue Oct 09, 2012 5:34 pm

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?
David
http://www.ecombuildertoday.com
Enhanced Reporting for AbleCommerce
Image

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by jmestep » Wed Oct 10, 2012 6:31 am

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.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Wed Oct 10, 2012 8:18 am

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.

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Mon Oct 15, 2012 10:30 am

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!

User avatar
mikek
Commander (CMDR)
Commander (CMDR)
Posts: 112
Joined: Wed Oct 15, 2008 9:30 pm
Location: Boston, MA
Contact:

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by mikek » Wed Oct 17, 2012 11:19 am

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.
Mike Kolev

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Thu Oct 18, 2012 11:09 am

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?

User avatar
mikek
Commander (CMDR)
Commander (CMDR)
Posts: 112
Joined: Wed Oct 15, 2008 9:30 pm
Location: Boston, MA
Contact:

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by mikek » Thu Oct 18, 2012 12:47 pm

Enable custom error reporting customErrors mode="Off" in web config to get the exception error and see what is causing the issue.
Mike Kolev

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Thu Oct 18, 2012 1:07 pm

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.)

User avatar
mikek
Commander (CMDR)
Commander (CMDR)
Posts: 112
Joined: Wed Oct 15, 2008 9:30 pm
Location: Boston, MA
Contact:

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by mikek » Thu Oct 18, 2012 1:15 pm

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.
Mike Kolev

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Thu Oct 18, 2012 2:04 pm

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!

User avatar
mikek
Commander (CMDR)
Commander (CMDR)
Posts: 112
Joined: Wed Oct 15, 2008 9:30 pm
Location: Boston, MA
Contact:

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by mikek » Thu Oct 18, 2012 2:15 pm

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.
Mike Kolev

User avatar
AnySupport
Lieutenant (LT)
Lieutenant (LT)
Posts: 73
Joined: Fri Feb 17, 2012 8:58 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by AnySupport » Thu Oct 18, 2012 3:22 pm

And now I'm in the tool finally! Thank you! Thank you! Thank you!

Tea-Dev
Lieutenant (LT)
Lieutenant (LT)
Posts: 55
Joined: Wed Oct 12, 2011 11:15 am

Re: 7.7.251 on Local Host-Cannot connect to URL

Post by Tea-Dev » Wed Apr 10, 2013 9:38 am

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?

Post Reply