Router Unable to load some websites and download apps from Google Play

After buying new ZAIN router (Saudi mobile company)  , I found that some sites does not open like portal.elm.sa/

So I found trouble was belongs to Router Firewall .

Disabling Firewall fixes it.




ORA-02298 Parent Keys Not Found

After you export DB then import it you may get this error:




That means a value found in child table but not found in parent table.

You can solve it by the following script to get the values not found :

select <COLUMN_NAME> from <CHILD_TABLE> a where not exists (select <COLUMN_NAME> from

<PARENT_TABLE> where primary_key = a.<KEY_VALUE>);


To looks like :

Then you will get different values and insert them into parent table  or delete them from child table.


Thanks to Atlassian Documentation