Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.

Back

Could not initialize a collection when launching SmartConnect

Published: Mar 31, 2021
Post Author Written by Ethan Sorenson

Error

When launching the SmartConnect client received the below message:

Could not log into the SQL Server
could not initialize a collection: [eOne.SmartConnect.Engine.User.UserWebFormOptions#6c6113ce-075b-4d49-8ec1-9ea400bb6db8][SQL: SELECT userwebfor0_.UserId as UserId1_, userwebfor0_.UserWebFormOptionId as UserWebF1_1_, userwebfor0_.UserWebFormOptionId as UserWebF1_100_0_, userwebfor0_.FormName as FormName100_0_, userwebfor0_.UserId as UserId100_0_ FROM [UserWebFormOption] userwebfor0_ WHERE userwebfor0_.UserId=?]

Resolution

One or more tables in the SmartConnect database are not using the expected dbo schema.
To fix, run the below SQL Statement against the SmartConnect database then relaunch SmartConnect.

If you are still having issues, feel free to email target=”_blank” rel=”noopener”> style=”color: #0000ff;”>support@eonesolutions.com

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.