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.
<?xml version=“1.0” encoding=“utf-8”?>
<CONFIGURATION>
<CONNECTIONTYPE>DataBase</CONNECTIONTYPE>
<DATABASETYPE>FireBird</DATABASETYPE>
<DATABASECONNECTIONSTRING>ServerType=0;DataSource=70.233.225.10;DataBase=AYANOVACC;User=SYSDBA;Password=rebbig;Dialect=3;</DATABASECONNECTIONSTRING>
</CONFIGURATION>
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()