One of our clients were trying to create a classic planning application and while creating a data source non of the connections (SQL as well as Essbase) were getting validated.
For SQL database connection, the problem was that the user account was set with the password policy, (when tried manually, on first logon system was prompting to change the password...)
For essbase connection, no port number was specified along with the server name.
Once these error was rectified, the data source was successfully created.
Secondly, they were also facing issue while creating an application. System used to give error as failed to create application, see the log. When trying to create an application manually with the given user credentials in EAS, the message displayed was as follows:
Error: 1056603 unable to spawn process for application []. Please ensure that adequate memory is available.
There were already too many Essbase applications and there was not enough memory to create another app. So, the IT team provided another server details. They had to recreate the data source connection and finally test Hyperion planning app was created.
