4 Replies Latest reply on Sep 21, 2013 3:25 PM by user8981455

    Joining tables from two different databases

    user8981455


      Hi,

       

       

      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)