Important Error with Stambia analytics

Hello,
I have a process that works verry well in stambia designer, but when I try to execute it in stambia analytics it didn't work and gave me the error :
"SQL exception error cross-database are not implemented"
while I'm using just a single database.

Hi,
Can you have a closer look at the step which produces this error?
You may want to compare the SQL executed in the Analytics version and the SQL executed in the Designer version. => Is there a difference ?

Hi,
I compared them and there is no difference between them.

There is a small difference: the database name is enclosed in double quotes, or not.
If you work with a database such as Postgresql, this is a big difference. Postgresql database names can be case sensitive, and I guess this is the origin of the error.

Can you show how your metadata is set in the Designer? the server node & the schema node, please.

Hi,
Okay, I see.
Here are my metadata (the server node and the schema node).

Okay thanks, I don't really see why this would not work the same between Designer & Analytics.
Can you please open a Support Ticket? please refer to this forum page URL so that they can see the history.

Okay thank you.
I'll contact the support.

Hi,
I solved the problem.
I changed the name of the catalog name from (DB_OCD_SR_OM_FA_TT_IM_RECETTE ) to ("DB_OCD_SR_OM_FA_TT_IM_RECETTE") in Stambia analytics and my process runs well.