Best practice forum (Archived)

Missing Table when using DB HR Import

 
nate's standard profile pic
Missing Table when using DB HR Import
由 MarshallNate 发表于 2017年05月2日 Tuesday 09:22
 

We are unable to get a user import with HR Import using our external DB 

We get an error that references a table that does not exist. "mdl_totara_sync_user"

Server time: 2 May 2017 at 10:47:41, Element: user, Action: unknown, Error:
Error writing to database - ERROR:  null value in column "idnumber" violates not-null constraint
DETAIL:  Failing row contains (1, null, 0, , null, null, null, null, []).
INSERT INTO mdl_totara_sync_user
(idnumber,timemodified,username,firstname,lastna...

can't find it here
https://autodocs.totaralms.com/schemaspy/totara-9.0/

We do have a value in idnumber column for all users, and we have usernames not an empty column as it assumes.

 
永久链接 | 回复
HoldenWesley
Re: Missing Table when using DB HR Import
由 HoldenWesley 发表于 2017年05月2日 Tuesday 09:40
 

Hi Nate!

Please check in with your partner on this to see if it's an issue they've run into before. They'll also be able to help check your mapping to make sure that the Source matches the Mapping you've setup.


Cheers!

Wes

 
永久链接 | 显示父帖子 | 回复
nate's standard profile pic
Re: Missing Table when using DB HR Import
由 MarshallNate 发表于 2017年05月2日 Tuesday 12:05
 

Thanks!


We have a meeting with them this week so hopefully some good news. 

 
永久链接 | 显示父帖子 | 回复