Skip to Content (Press Enter)
UserImage.jpg
Abhi
431Views
4Comments
Detach Evaluation
Question
Hi,

I am looking to evaluate the detach functionality of Outsystems using the No-lockin tutorial.

Steps Followed:

1) Detached the code
2) Published the Code
3) Create an AWS instance with required configuration to host the Detached App on it
4) Took a backup of databases "outsystems" & "osSession" from on premises server and imported into sql on the aws server & checked the login permissions for all users such as  OSADMIN, OSSTATE...
5) Hosted the app on IIS
6) Made changes in the machine.config file by including <appSettings> tag and declaring the connection strings

But I get an error for OSSTATE login as:
'Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'OSSTATE'. '
 
Is there a database called ASPSTATE? If yes, where can I find this on on-premises server? 

Have run SQLPROFILER and this Seems to be a problem with connecting to the database ASPSTATE 
Have debug the code to see that the connections are closing as soon as they open


private IDbConnection GetConnection() {
            IDbConnection conn = null;
            try {
                conn = GetConnectionFromDriver();
                conn.Open();
                return conn;
            } catch {
                if (conn != null) {
                    conn.Dispose();
                }
                throw;
            }
        }


Any help regarding this issue is appreciated. Have been trying this since for a while.

Please let me know if there is something that I'm missing from above 


ConfigError.png
0
0
16 Jun 2016
Copy Link
2019-11-12 17-31-26
Justin James
 
MVP
Look in the config tool to get the connection details for your session DB.

J.Ja
0
0
16 Jun 2016
Copy Link
UserImage.jpg
Abhi
Hi J. Ja Thanks for the reply.. I have checked the from configuration tool pointing the session DB to osSession database with OSSTATE credentials
0
0
16 Jun 2016
Copy Link
UserImage.jpg
Abhi
Abhi wrote:
Hi J. Ja Thanks for the reply.. I have checked the from configuration tool pointing the session DB to osSession database with OSSTATE credentials
If I configure the database as "osSession" I get a different error "Resource cannot be found" 

and then when I tried to open .../contactManager/_default.aspx I get this error of Invalid espace. 


Invalid eSpace info provided to AppInfo : eSpace Id: 0, eSpace Name: ''
   at OutSystems.HubEdition.RuntimePlatform.AppInfo..ctor(ESpaceInfoForAppStart eSpaceInfo)
   at ssContactManager.Global.Application_Start(Object sender, EventArgs e)
Appreciate any help regarding this. Thanks!!
0
0
17 Jun 2016
Copy Link
UserImage.jpg
John Kim

We are experiencing the same issue.  Anyone else run into this issue?

0
0
11 Apr 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.