4 Replies Latest reply: Sep 21, 2013 10:25 AM by user8981455 RSS

    Joining tables from two different databases





      I am trying to join W_DAY_D from 1 database to another 2 database to the fact table . The datatype for CALENDER _DTis (DATE) from W_DAY_D  and the Create date from fact table is TIMESTAMP . I changed the the datatype in the phyiscal layer for CREATE DATE from the fact table to DATE and joined it with W_DAY_D (Calender_DT = create_date) Thought the rpd showed me no errors while saving it . But when I try adding the column in the report it throws me error


      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46008] Internal error: File server\Utility\Server\DataType\SUKeyCompare.cpp, line 772. (HY000)