2 Replies Latest reply: Feb 12, 2013 11:14 PM by 940828 RSS

    Error in delete aggregate using nQcmd

    940828
      Hi ,

      I am using version 11.1.1.5

      I am trying to write a script does the following:

      Delete a particular aggregate.
      create the aggregate

      Below is the content of the script:

      ============================
      delete aggregates "orcl".."poc"."ag_F_dtl";

      create aggregates

      "ag_F_dtl"
      for "POC"."F_Defects"("No of Events","No of Bad Parts - Summary","Reference Quantity - Summary")
      at levels ("POC"."Vendor"."Detail" using_surrogate_key , "POC"."Organisation"."Org Details" using_surrogate_key , "POC"."Material - Product"."Mtl - Detail" using_surrogate_key , "POC"."Time"."Month" using_surrogate_key )
      using connection pool "orcl"."Agg Conn Pool"
      in "orcl".."POC";
      ============================

      Below is the error i get when the script is executed using the nQcmd command: (Error in the delete aggregate statement)

      [10058][State: S1000] [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general er
      ror has occurred.
      [nQSError: 43113] Message returned from OBIS.
      [nQSError: 27002] Near <">: Syntax error [nQSError: 26012] .
      Statement preparation failed

      Request you help.

      Regards,
      HPR
        • 1. Re: Error in delete aggregate using nQcmd
          Srini VEERAVALLI
          Check this link might help you.
          http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/aggpersist.htm

          I didnt find any thing other than Case for key words.. also 'poc' is not consistent in both statements
          • 2. Re: Error in delete aggregate using nQcmd
            940828
            Hi Srini,

            My problem is still unresolved.

            Just a question.

            My understanding of the syntax for delete aggregates is :

            delete aggregates <Db name used in the physical layer>..<BMM Layer name>.<aggregate table name>;

            Can you please confirm if this is right?

            Additionally, my intention is to refresh the data in there aggregate tables by using the above command.
            Can you please suggest if there is a better way of doing it or any alternate method?

            Regards,
            HPR