Data Portal running slow on remote site

AyaNova service management & work order software

AyaNova Support Forum

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Data Portal running slow on remote site

Rate Topic

Display Mode

Topic Options

Author

Message

juanMorales

Posted 3/12/2008 11:45:22 AM

Junior Member

Group: Forum Members
Last Login: 3/20/2008 9:22:05 AM
Posts: 19, Visits: 59

When I use the original config.txt file which points to the correct server and database, AyaNova runs really slow. To start up after logging in takes about two minutes and just opening a workorder takes about 1.5 minutes. This was not a problem before upgrading from 3.6 to 4.1. When on a computer which is on the same local network as the server everything runs normally.

DataBase
FireBird
ServerType=0;DataSource=70.233.225.10;DataBase=AYANOVACC;User=SYSDBA;Password=rebbig;Dialect=3;

I tried to use the EXAMPLE_DATAPORTALconfig.txt file with the appropriate server address and port number and got the following. I get this same message whether I am on the server, local computer, or remote computer. I have created a port in the router firewall. I get the correct results when I enter http://70.233.225.10:6969/dataportal.rem?wsdl on the server as well as the remote machines.

Error message:

AyaNova was unable to start

Depending on how early in startup the problem occurred,
a detailed log of the problem with suggestions *may* have
been saved to the file AyaLog.txt
located at: file:\C:\Program Files\Ground Zero Tech-Works Inc\AyaNova_CC

Error details:
Unhandled exception:
The input stream is not a valid binary format. The starting contents (in bytes) are: 3C-68-74-6D-6C-3E-0D-0A-20-20-20-20-3C-68-65-61-64 ...
System.Runtime.Serialization.SerializationException

Stack Trace:

Server stack trace:
at System.Runtime.Serialization.Formatters.Binary.SerializationHeaderRecord.Read(__BinaryParser input)
at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadSerializationHeaderRecord()
at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryResponseMessage(Stream inputStream, IMethodCallMessage reqMsg, Boolean bStrictBinding)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at CSLA.Server.DataPortal.Fetch(Object Criteria, DataPortalContext context)
at CSLA.DataPortal.Fetch(Object Criteria)
at CSLA.Security.BusinessIdentity.LoadIdentity(String UserName, String Password, AyaNovaConnectionSettings ACS)
at CSLA.Security.BusinessPrincipal..ctor(String Username, String Password, AyaNovaConnectionSettings ACS)
at CSLA.Security.BusinessPrincipal.Login(String Username, String Password, AyaNovaConnectionSettings AyaNovaConnectionSetting)
at GZTW.AyaNova.BLL.AyaBizUtils.1()
at GZTW.AyaNova.BLL.AyaBizUtils.Initialize()
at AyaNova.Form1.0()

Post #3878

AyaNova Sales & Support

Posted 3/12/2008 12:15:33 PM

AyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 8:27:06 PM
Posts: 1,702, Visits: 4,008

Hi again

I am not sure if I understand this right - you are trying to have a remote computer connect to the database using a local area connection and are saying it is too slow?

As per the Data Portal installation and configuration steps, you do NOT have a remote computer connect using the same connection as a local area network computer - it of course would be massively slow.

If you connected remotely from a computer runinng AyaNova 3.6 directly using the local area network configuration, it would also have been slow because you also would only connect from a remote computer using the Data Portal configuration.

The Data Portal is specifically created to to be in between a remote computer and the database server. And the AyaNova 4 Data Portal and AyaNova 4 itself has also been optimized for increased speed.

I believe there is a misunderstanding here of what is to be done.

To your other issue you posted about:

When I try the connection http://70.233.225.10:6969/dataportal.rem?wsdl I get a completely different message than what you list in your posting.

The link http://70.233.225.10:6969/dataportal.rem?wsdl is what you would enter to test remotely step #13 of the Data Portal connection steps, but does this mean you have successfully completed the steps prior to this?

From this link, I am assuming that you have set up a new virtual Data Portal site rather than using the default installation of AyaNova 4's Data Portal (otherwise it would be http://ipaddress:portnumber/AyaNovaDP/dataportal.rem?wsdl):

When you initially test as per step #13 of the Data Portal connection steps http://www.ayanova.com/AyaNova4webHelp/data_portal_installation_and_c.htm , on the server itself where the Data Portal is installed, you enter http://xxx.xxx.xxx.xxx:XXXX/dataporal.rem?wsdl to confirm that you have the basics installed correctly - where xxx.xxx.xxx.xxx is the private internal ip of the server, and XXXX is the port number as per the previous steps.

**Confirm what exactly you enter at the server itself for step #13

**Confirm do you actually receive what it shows in the screenshot for that test?

**If you do not successfully get as per the screenshot for that step, that means that you have something installed incorrectly or not confirmed or set and need to redo your previous steps.

If you do not successfully perform a step, you of course are going to get even more issues if you go past that step and ignore it. You must address an installation and configuration issue when it comes up before continuing.

**It may be a similar issue that you had with your WBI that you had just recently posted about - that there was something major wrong with the installation itself such as files missing, and re-installing fixed it. I would recommend that you redo your steps from the beginning, and note them down as you go, so that if you encounter an issue again and have confirmed you have done and checked each step, you can provide that information so that we can troubleshoot.

- Joyce