SQL error -302 while accessing table when Run Info Package

[Former Member]

Dear SAP experts,

I run BW 3.x.

I am currently run info package but it's give short dump like bellow :

CX_SY_OPEN_SQL_DB

SQL error -302 while accessing table /BIC/B0000071

Kindly help me what should I do...

Regards

[Former Member · Accepted solution]

Hi Donnie,

It appears that the datasource for which infopackage your are running have some fields of improper lengths than what system is expecting. Can you ensure that field lengths are same as of your source system datasource field lengths?

SQL302 is generally because of improper lengths of fields and sql is trying to feed in data of larger length into the field.

I would say try to replicate your datasource again and then try it. If your datasource is in flat file format then check the lengths of datasource and your flat file.

After ensuring that field lengths are same you can run the infopackage. You should not get any issues then.

Please let me know if there are any questions.

If problem persist then share your datasource name in case it is standard or custom.

Thanks

Amit

[Former Member · Accepted solution]

Hi Amit,

soryy for late reply.

becausethe system down yesterday.

I will check it and I will let you know.

Thank you very much.