When creating a person with personservice I get an exception: Invalid object name 'Customers.CustomerId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) .. omitted Sounds to me like like a missing table? But I have not…

Try adding it with this query: USE [DatabaseName] GO CREATE SEQUENCE [Customers].[CustomerId] AS [bigint] START WITH 100001 INCREMENT BY 1 MINVALUE 1 CACHE 3 GO Maybe start with should be different depending on the number of users in the database you upgraded.

The only thing I can think of is a missing Id on the person. How do I force the default Id to be stored?

Maybe it is trying to map a value to the Id, that value should be unique which system provides such as LSC100001, LSC100002, etc… you can change the prefix in web.config (LSC).

I know that. But how do I apply the next id?

Even when I don’t use the mapping function I still get the same error. var person = new Person(fieldTemplate.SystemId) { FirstName = model.NewAccount.FirstName, LastName = model.NewAccount.LastName, Email = model.NewAccount.Email, …

I am not sure where you are getting the Customers.CustomerId from. You are creating a new person, the system will generate that value so no need for you to populate the Id property.

The catch in my first post in this thread are what is giving me that error.

I had issues running my 7.3 version but I tried your code in 7.4 (No changes on Person entity) and there were no issues… not sure why you get that error.

Did you start with 7.3.2 or have you upgraded from an older version?

Started with clean accelerator 7.2.3. Upgraded database from 6.0.0.

PersonService.Create(...) throws exception

Questions

steve.redstorm February 12, 2020, 12:56pm 8

Yes, let me see if I get the same error when using your code in my solution on 7.3 version, I get back to you.

Topic		Replies	Views
Create organization problem? Questions litium-7	4	403	February 4, 2019
Person update error Questions	4	496	November 2, 2021
Error during database upgrade Questions litium-7	16	1323	January 23, 2019
Person validation not allowing special characters as Id Questions litium-8	1	161	March 19, 2024
Remove prefix from Litium customer number Questions	1	335	May 8, 2018

PersonService.Create(...) throws exception

Related topics