pcsoft.us.windevCopyright 2026, PC SOFT30 Nov 2019 13:51:21 Z10 Nov 2019 13:33:38 ZHello, I have some troubles with synchronizing analysis with external database (MSSQL). It shows me that last synchronization was done before 237 days, which is no true. It list of "Elements to synchronize" are still some tables and links and they never disappeared. In report after synchronization I get a huge list with links that are not synchronized. Does anybody have idea what all this means? Application seems to work ok but it makes me nervous... These are some items of the list, there are cca 50 of them. All source columns are keys of course... I tried to make a key Linked column in MSSQL but it was just a try and did not help eiher. Unable to create relationship in analysis. Link: , Source Column: Firmy.FirmaID, Linked Column: CRMKontakt.FirmaID Item involved in link must be defined as key. --- Unable to create relationship in analysis. Link: , Source Column: Firmy.FirmaID, Linked Column: DodaciList.FirmaID Item involved in link must be defined as key. --- Unable to create relationship in analysis. Link: , Source Column: Sacek.SacekID, Linked Column: DodaciList.SacekID Item involved in link must be defined as key. --- Unable to create relationship in analysis. Link: , Source Column: Firmy.FirmaID, Linked Column: DosleFaktury.FirmaID Item involved in link must be defined as key. --- Unable to create relationship in analysis. Link: , Source Column: TypyUhrady.TypUhradyID, Linked Column: DosleFaktury.TypUhradyID Item involved in link must be defined as key.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67453/read.awp30 Nov 2019 13:51:21 ZThank you for help Guenter, I will probably have to go this way.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67453/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67453/read.awpUnable to create relationship in analysis.gpredlpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67445/read.awp29 Nov 2019 07:43:04 ZHi, yes, the next step would be a new analysis, just for a test. It's not as hard as you think. Make an empty new project and bu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67445/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67445/read.awpUnable to create relationship in analysis.PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67444/read.awp28 Nov 2019 18:14:18 ZSorry I did not mention it but I tried it couple of times, quick, full. Repairing is quick, cca 1s, no error messages. The only …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67444/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67444/read.awpUnable to create relationship in analysis.gpredlpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67443/read.awp28 Nov 2019 17:19:07 ZHi, did you repair the analysis? This isthe first step before doing anything else.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67443/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67443/read.awpUnable to create relationship in analysis.PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67433/read.awp27 Nov 2019 22:04:25 ZI still did not solve it. Anybody here knows what could it be??https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67433/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67389-unable-create-relationship-analysis-67433/read.awpUnable to create relationship in analysis.