Error when adding u…
 
Notifications
Clear all

Error when adding user to CloudPanel

8 Posts
2 Users
0 Reactions
4,733 Views
0
Topic starter

I’ve created the first reseller and company, and all the required plans. I’ve also enabled Exchange for that company.

When I try to add my first user, I get an error in my browser that states:

X Error! An error occurred while updating the entries. See inner exception for details.

The error in the log is:

00 ::: [14] ERROR ::: CloudPanel.Modules.UsersModule — Error creating new user for company KNO1: System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.SqlClient.SqlException: Invalid column name ‘TaskType’.

Looks like I need to add something to the SQL database maybe?

8 Answers
0

Someone else pointed this out to me this weekend. For some reason it left off the column on new installs and I’ll have to fix that

You can open SQL and on the delayedusertasks table just add a new column named TaskType with the integer (int) data type

0
Topic starter

That took care of it. Thank you!

Once I went back into the Customer though, I got another error:

2015-06-21 20:21:26,614 ::: [15] ERROR ::: CloudPanel.Modules.Admin.ExchangeModule — Error pulling exchange message log history data: System.InvalidOperationException: The cast to value type ‘System.Int32’ failed because the materialized value is null. Either the result type’s generic parameter or the query must use a nullable type.

I quickly realized that I hadn’t forced the scheduler to update. Once I did that, it seems to be fine. Might want to set the scheduler default to pull the initial data during installation.

Thank you again!

0
Topic starter

Got several companies and users created.

None of them can login to OWA. The only account that can login to OWA is the administrator. I’ve already changed the OWA login type to UPN in the control panel.

When I login as administrator@domain.local everything works fine. When I login as gene@test.com — I get no errors at all and just get bounced back to the OWA login page.

I can’t find anything in the Exchange logs that even resembles an error.

0

When you create the user did you choose to enable the mailbox? There is a checkbox. Also you can edit the user afterwards and enable the mailbox.

On the users page with the list of users you will see a yellow envelope if they have a mailbox.

It sounds like you didn’t enable a mailbox.

0
Topic starter

That’s what I thought too, so I double checked. The mailboxes are all enabled.

0

Didn’t I do a remote session with you and take care of this? Just checking

0
Topic starter

Didn?t I do a remote session with you and take care of this? Just checking

Yes, you certainly did. I was running everything on Server 2008 R2. It appears that installing CU9 as an update to Exchange 2013 SP2 broke permissions in Exchange.

I have since reinstalled everything using Server 2012 R2, and Installing Exchange CU9 directly. No issues at all (other than having to manually create the TaskType column in the delayedusertasks table)

Everything is working very well so far.

0

Great! 🙂

Share: