5 Replies Latest reply: Jan 24, 2013 6:01 AM by JeromeFr RSS

    scd1 error

    960855
      i got an error while performing scd1 by using SID column that is mapped to native seq error is missing expression. i think select statement is not getting that sid column...any body help me to clear that
      thanks
      nari
        • 1. Re: scd1 error
          JeromeFr
          Hi,

          Please could you provide us the entire error message, the KM used, the mapping for the column you think is the problem and the generated SQL code from the failing step in your execution ?


          Thanks,

          JeromeFr
          • 2. Re: scd1 error
            960855
            i am trying to populate target table using scd1 using KM is ikm oracle incremental update.i am trying to map sid with some seq which is can be used as native sequence in ODI but i am getting error is below

            ODI-1217: Session INF_SCD1 (196001) fails with return code 936.
            ODI-1226: Step INF_SCD1 fails after 1 attempt(s).
            ODI-1240: Flow INF_SCD1 fails while performing a Integration operation. This flow loads target table DIM_EMP_SCD1.
            ODI-1228: Task INF_SCD1 (Integration) fails on the target ORACLE connection ORACLE_SERVER.
            Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)


            note: but successfully populated to target when not used sequence(surrogate key) in my target.
            • 3. Re: scd1 error
              JeromeFr
              Could you go on the operator, expand your execution, find the failing step, double click on it and click on the "Code" tab?
              This generated SQL code might help us to find the error.


              Did you define a Unique Key?
              • 4. Re: scd1 error
                Prerna Vij
                Hi,

                I had come accross the same error when I was trying to use the sequence as a key in my interface. It was resolved when I unchecked the Update behaviour and did not mark it as Key. I marked some other column as the key column.

                Try it, might help.

                Regards,
                Prerna
                • 5. Re: scd1 error
                  JeromeFr
                  Of course, the Unique Key cannot be define on your SK if it's populated by a sequence in this interface.
                  The unique key should be a column (or a set of column) that ODI can use to recognize which rows from the source already exists in the target.