Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error While Importing Tables to an Oracle ODS

Hello Experts,

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?

Regards,

Ankit

Former Member
Not what you were looking for? View more on this topic or Ask a question