Error While Importing Tables to an Oracle ODS
I am totally new to BODS. We are suing t he 4.1 version. I have created a datastore in one of my Oracle 11g databases. Its an ODS. While i am importing a few table it throws me an error stating "
Cannot Save<Foreign Key List> for repository object <table_name>.<SQL submitted to Oracle Server <BOBJP>
resulted in error<ORA-01400:cannot insert NULL into "AL_FKPKREL"."FKCOLUMN_NAME")>
Only one of the tables selected was imported. What i understand is that because a FK is declared in my ODS it is throwing an error. Is there a work around to this.
I have no idea about the metadeta tables but as the name goes, AL_FKPKREL, may be it stores the PK-FK relationship. So do i import all the tables that are joined to a particular table?In that way my DS will be populated with many useless tables. I can't literally disable all my FKs in my ODS.
Can anyone please suggest?