What Is The Value Mean In Idtype Column In Jiveid Table? (Doc ID 1367109.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter - Version: 11.1.1.4.0 and later   [Release: 11g and later ]
Information in this document applies to any platform.

Goal

We are trying to migrate phpbb forums over to Oracle Discussions.

Background: we are migrating phpbb forum over to Oracle Discussions. We are also integrating Oracle discussion with Oracle OID. Here is what we did
1. Create the user in Oracle OID
2. Create user in Jive using jive API
3. Migrate the forum data to Jive using jive APIs
After doing the above steps, we try to login to Jive application, we get errors. We see the unique constraint (FT4PUBWC_DISCUSSIONS.JIVEUSER_PK) is violated. After a search on google, we found that there is sequence ID stored in jiveid table. But we don’t know which one is for userid. That is reason I asked this question.
I have another question about data migration. What is Oracle recommended approach for migrating phpbb data (in mysql) to jive database? Currently, we are using Jive provided APIs. The process is very slow. It took around 12 hours to migrate 56,000 messages.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms