Create session error : X3 engine error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ADOVAL'. : SQL Server ErrorDeta

Question

Hello, 
 
 When i'm trying to access the X3 reference folder and the pilot folder i get below error. 
 Create session error : X3 engine error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ADOVAL'. : SQL Server ErrorDeta 
 The X3 version is V11 and patch 14. We have reconfigured the solution and this occurred after that. After re configuring the patch level show as 2 now. Can anyone help me pls. 
 
 Eranda

chris hann · Accepted Answer

Hi erandarg , I would suggest checking out SQL server security Logins. There was one reported instance of the same error. The X3 permissions in SQL Server was changed and this did not allow the the endpoint to load properly, resulting in error. here is the comments to that issue: 
 "The BP realized that he checked the wrong user on Sql Server Management Studio. The BP checked again the Server Roles for X3 user on Sql Server Management Studio - Sql Instance - Security Folder. The BP disabled the "serveradmin", "setupadmin", "sysadmin" and kept enable only the "Public" option for X3 user. After that the BP was able to connect to X3 folder". 
 Example below of the user security login "X3" and its Sever Role:

Sage X3

Create session error : X3 engine error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ADOVAL'. : SQL Server ErrorDeta

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING