An integration application that has been working for weeks. It stopped working after the client moved the VM to a different host to get more Ram.
The application was installed on an app VM. The SQL database is on another VM. When they moved the app VM, the application worked. When they moved the SQL VM, the application stopped working. The error message from Sage 300 session was "Error occurred when opening view OE0520.". I ran the code in debug mode. The code passed successfully the "log in", "open session", "open DB link" and logged on to the proper database. It bombed at the line when it tried to open the view:
_oDbLink.OpenView("OE0520", out viewOrders);
What could possibly the reason? I am running out of options.
Thanks in advance.
The application was installed on an app VM. The SQL database is on another VM. When they moved the app VM, the application worked. When they moved the SQL VM, the application stopped working. The error message from Sage 300 session was "Error occurred when opening view OE0520.". I ran the code in debug mode. The code passed successfully the "log in", "open session", "open DB link" and logged on to the proper database. It bombed at the line when it tried to open the view:
_oDbLink.OpenView("OE0520", out viewOrders);
What could possibly the reason? I am running out of options.
Thanks in advance.