SQL error in PC

[Former Member]

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 ?

Thanks,

Deepak

[Former Member]

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 database.you 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 .

Regards,

Jaya