I found that People table in Hummingbird database can be imported using Hummingbird's Database Import tool, so I confirm to customer that they can provide user from their system, then we can transform the format into ready format to import to Hummingbird using that tool. And indeed it works. all the people imported using that tool can logged in and logged off as normally created user using People interface from DM Admin web.
Until... someday i found that the user that was created using that tool have document security issue. No, not the insecure issue, but too secure issue, lol..
The document that has been security enabled to them, cannot be seen by them. I try to check in DOCSADM.SECURITY table, and yes, they have been added to the document security.
even the document created by them self, cannot be found by them after the document is created (but administrator still can find that document). So there was an error, the document was not exist after the document was created by them.
I try to create a user, using normal way, using DM Admin > People > Add People. and add that people into current trustee of the document, then I logged in as that new person. taa..daaa... the document was there. I try to create document using that person, and the document has no error when it was created, It was accessible to that person.
So the main problem is to find the different between the normal way created person and the batch way created person :P
After searching the tables for whole day, I found that in DOCSADM.PEOPLEGROUPS there should be a line like this:
| GROUPS_SYSTEM_ID | PEOPLE_SYSTEM_ID | LAST_UPDATE |
| -1 | 12934 | 47:34.8 |
| 0 | 12934 | 08:14.2 |
| 2518 | 12934 | 08:14.2 |
| 7131 | 12934 | 45:57.3 |
| 12934 | 12934 | 34:12.6 |
So the solution was like this:
insert into DOCSADM.PEOPLEGROUPS (GROUPS_SYSTEM_ID,PEOPLE_SYSTEM_ID ,LAST_UPDATE)
values(@PeopleSystemId,@PeopleSystemId,getdate())
It took me whole day to find this, you can't imagine how happy I am when I found that, lol
0 comments:
Post a Comment