SAP B1 Solution Packager hangs

[Former Member]

Hello Experts,

We have an issue with the Solution Packager. While we are trying to create a package, Solution Packager hangs in the third step while creating the setup for documents. We have also removed all of the parameterization  (UDT, UDF, UDO, FMS etc...) and the issue still occurs.

Please find attached the additional log file from the Solution Packager,

Thank you in advance.

Kind Regards,

Vasilis Korolis

Addon_SoP_01.txt.zip

[Former Member]

I had the same issue this week and found that it was caused by the following:

If you do not package ALL items, Solution packager runs a query (in the Preparing Document Layout stage) like this:

SELECT COUNT(ItemCode) FROM OITM WHERE ItemCode NOT IN ('A00001, 'A00002') etc.

If you have a large number of items (I had 36,000 this week) the query can be exceptionally long and not execute.

I was able to solve the problem by packaging all items and then running a DI macro that deleted the items I didn't want to bring over.

[Former Member]

Did you ever resolve this issue? We are experiencing the same thing with one of our databases.

[john_obrien7]

Also facing same issue.

Solution Packager freezing on Preparing Form Layouts

SAP B1 9.1 pl 5 64bit.

Any info?

[kothandaraman_nagarajan]

Hi,

Please raise ticket to SAP support.

Thanks & Regards,

Nagarajan