Skip to Content
avatar image
Former Member

SQL error in PC

Hi All

I am getting the error at Attrib.Change step in Process Chain step.

Error says like SQL Error 1652,Error When filing the aggregate 100178.

Can you please tell me why i am getting this error?

Is this error from BI side or from BASIS side?

Can we do anything from BI side to avaoid this error in future ?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 14, 2011 at 06:08 AM

    Hi Deepak ,

    SQL error 1652 and 12801


    1.I think this is a problem for Basis .

    2.It is temp table space PSAPTEMP problem, ask basis team to increase temp table size and then try again .Ideally it should be around 5 - 3 % size of can increase existing data file size for that .This is table use to buffer temporary data .

    3.After that Aggregate filling job should run fine .

    4.Also Check note 164925 and 416772

    Hope this will be helpful .



    Add comment
    10|10000 characters needed characters exceeded