Getting error when trying to add udf in Marketing document Title level

[Former Member]

Hi all

I'm getting  this error "internal error occurred (-1) message [131-183]" when trying to add udf in marketing document title level.I'm giving udf length also correctly.But I don't know why this error?Any body give any solutions ?

Thanks

Ramu

[former_member186095 · Accepted solution]

Here is another possible solution from SAP note #1669863:

1669863  - User-Defined Field cannot be added for specific object

Version   1   Validity: 03.01.2012 - active Language   English

Content:      Summary    |    Header Data    |    References    |    Validity 

Symptom

When you try to add new User-Defined Field for specific object (for example Business Partners or Items or Marketing Documents header data or rows...) below error is displayed:

"Internal Error (1) occurred [Message 131- 183]".

This error is triggered by SQL limitation of data length of table row which is 8060 bytes.

 

Cause

Application error

 

Solution

SAP intends to provide a patch or patches in order to solve the problem described.

The section Reference to Related Notes below will list the specific patches once they become available.

The corresponding Info file of the patches in SAP Service Marketplace will also show the SAP Note number.

Be aware that these references can only be set at patch release date.

SAP will deliver patches only for selected releases at its own discretion, based on the business impact and the complexity of the implementation.

Remark:

After the fix for this issue is delivered there will be a different error message displayed for user:

"SQL Server limitation for row data length  (8060 bytes)"

 

Other terms

CUFD, UFD1, Alter Table, New Column

   
       

Header Data

Released on	03.01.2012 17:30:15
Release status	Released for Customer
Component	SBO-GEN-UDF User-Defined Fields
Priority	Correction with medium priority
Category	Program error

  
      

References

This document refers to:

  SAP Business One Notes

1669809

SQL data leght limitation explanation

This document is referenced by:

   SAP Business One Notes 

1681770

Overview Note for SAP Business One 8.81 patch 11

 
   
      

Validity

Software Component	Version
SAP BUSINESS ONE	2007 A
	2007 B
	8.8
	8.81

    

Good luck

Rgds,

JImM

[Former Member · Accepted solution]

Thank  you  for your valuable reply to me,

I read total what you have sent me,but can you give exact solution for this.My sap system details are given bellow:

sap b1 version:8.8 PL 10

Database:Sql server 2008R2

[former_member186095 · Accepted solution]

Hi kilaru,

If the solution from these threads:

http://scn.sap.com/thread/1256793

http://scn.sap.com/thread/1124752

can't solve your problem and you are sure that the sap note is the correct solution, I suggest to upgrade to SAP B1 8.82. I suggest it because there is no SAP B1 8.82 in the validity part of the sap note above.

After upgrade but the problem still exists, you can create ticket to SAP support.

Rgds,

[former_member186095 · Accepted solution]

Hi,

The exact solution for your case is to apply the sap note.

The sap note informed that the problem is only able to solved by upgrading to SBO 8.81 PL11.

If you check the note, there is a sentence "sap business one note"and then followed by the words: "

1681770

Overview Note for SAP Business One 8.81 patch 11

So, it means that the sap note #1669863 explains the error message like you face now and in the sap note 1681770, you will find the sap note #1669863. Through sap note 1681770 we can see all of problems that fixed in SAP B1 8.81 Patch 11.

So, I suggest you to upgrade to SBO 8.81 PL11 in the test server prior to upgrade the live server. I suggest you to upgrade so that you can see if the problem solved in this version or not. If solved, you must upgrade to this version but if it's still not solved, Try to upgrade to SBO 8.82 PL04. if also not solve, create ticket to SAP support.

Another possiblity cause of error is the udf type and its structure are input with incorrect value or amount. So you must also check it.

Can you provide the screen shoot of udf property and the error message warning in message bar of SAP B1 that appears when you add the document ?

Rgd,

JimM

[Former Member · Accepted solution]

Hi,

Yes, I  can provide screen shot of this error log file and let me know status of this error.

Thanks

Ramu

[former_member186095 · Accepted solution]

Hi,

Thx for the screen shot.

Based on the error message I see in the screen shot, the problem is noted by sap support in the sap note.

Here is the sapnote #:

1669863  - User-Defined Field cannot be added for specific object.

So, the solution for your problem is to upgrade to SAP B1 8.81 PL11. That's the solution from the sap note.

Rgds,

JimM

[Former Member]

Hi Ramu,

How many UDF have you created so far on the marketing document title level?

Thanks,

Gordon

[Former Member]

Hi  Gordon Du ,

Already some UDFs are there,But when I'm trying to add, it   gives error.

[former_member186095]

Hi,

you may check this thread:

http://scn.sap.com/thread/1256793

http://scn.sap.com/thread/1124752

The solution from both threads might be helpful to solve your problem

Rgds,

JimM