[CLOSED] Data Migrator - 7706M Create Synonym Datasource is not Unique Error
I am creating a Synonym for a table from an Oracle 11g configured adapter into a application folder, But I am facing an issue here.
The error I am getting is '(FOC1567)CREATE SYNONYM: DATASOURCE '%1' IS NOT UNIQUE'.
I have tried deleting all the synonyms related to the corresponding table.And I have tried different naming patterns too.I am absolutely sure that there are no other synonyms in the complete application directory for same table.
Still I am facing the same issue. Can anyone please help me on this issue on how to resolve it.
Thanks in Advance.This message has been edited. Last edited by: <Kathryn Henning>,
Webfocus 8, Windows All Versions.
October 22, 2015, 08:54 AM
Welcome to Focal Point!
While we wait to see if other members reply to your question. Here is a few items found within the IBI knowledge base regarding FOC 1567 error.
The use of Field name Filler in a Key Group causes the following error: (FOC1567) CREATE SYNONYM: DATASOURCE '%1' IS NOT UNIQUE
Please try using SET SYNONYM=BASIC in your edasprof.prf and see if this will allow you to create the synonym.
Ensure your Oracle database and Oracle client are on the same release.
The following has caused problems in the past and generated this error message:
1) The comments on the Oracle table contain CR/LF and caused the ending single quotes to be dropped. Removing or shorting the comments on the Oracle table resolved the issue.
2) Verify if there are 2 entries for the table named xxxx within the schema.
This may require a case to be opened in the "Case Management" link on the Technical Support Center - if the above does not help.
This will be a server issue and with the case please provide the following if at all possible. This is not a common issue. 1) The Reporting Server's edaserve.cfg file. 2) The " " edasprof.prf file. 3) The ODBC DSN entry for the datasource.
If you do open a case please update the subject line with [CASE OPENED] and provide an update once it is resolved. This will help others in the future.
Thank you for participating in the Focal Point Forum.
Kindest regards, Tamra Colangelo Focal Point Moderator Information Builders Inc.
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
November 23, 2015, 09:27 AM
Dear Tamra, Thanks for the timely help. My issue is now resolved. The issue was there were two tables with same name but the two tables were in different schemas. We changed one table name and tried to recreate the synonym and we were successful.
I still dont understand why DataMigrator is treating tables from different schemas as unique data source.