My Oracle Support Banner

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

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle WebCenter Portal - Version to [Release 11g]
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.