Error in defining the User Defined Fields

[Former Member]

Dear All,

I am facing the problem in defining the User Defined Fields in Marketing Documents > Title. On defining the UDF system displays the error message as "Internal error (1) occurred [Message 131-183]"

Currently in Marketing Document > Title block, 43 UDFs have been defined. Another few fields are to be defined, but not able to do so, due to the error. Is there any limitation in defining the number of UDF fields?

Kindly let me know the details & solution for above.

Thanks & Regards,

Yogesh Jadav.

[Former Member]

Hi,

I am facing problem in adding user defined fields to the BP Master Data. The error is "Internal error (1) [Error message 131-183]

I am unable to add the field in any of the databases (I have 5 using the same SBO-Common)

Can anybody throw some light on how to overcome this?

sriram

[Former Member]

hi,

will you please let me know i am also facing the same problem

Regards

R.Vijayakumar

[former_member583013]

Yogesh,

your table row size of 7866 seems to be within the SQL 2000 limits? I am not quite sure whats causing this.

Have you tried to contact SAP Support by opening a message on the Support portal.

I would recommend that at this time

Suda

[former_member583013]

Yogesh,

Which SQL Server version are you using SQL 2000 / SQL 2005?

In SQL 2000, there is a maximum row size restriction of 8060 bytes.

Suda

[Former Member]

Suda,

The SQL Server version is SQL 2000.

Kindly let me know the solution or work arround if possible.

Regards,

Yogesh

[Former Member]

Hi,

There are no ways to change the SQL-Server limits.

If your problem is really this, your only solution, will be to partitionate your UDF in external tables and to make links on them.

Regards,

Eric

[Former Member]

Hi,

It's difficult to answer with only what you say...

From what I saw from my different searches (I've never experienced this) it seems that you have already an UDF exists with, either, the same name or the same description on a single object.

In this case, I would first verify that one of the informations (code and name) of an UDF I want to insert don't already exists...

Regards,

Eric

[Former Member]

Hi Eric,

Thanks for your reply.

As per your reply, checked the existing UDF details i.e. Title as well as Description and found that the field which I am trying to define it does not exists in the database.

The error exactly appear when I enter data & click on the Add button after that system navigates through steps and at final system message "Yes" button is pressed then error message is displayed i.e. " Internal error (1) occurred [Message 131-183]" and this problem is only in the Marketing Document > Title Block.

Are there any restriction in defining the UDF fields for particular document?

Regards,

Yogesh Jadav

[Former Member]

Hi,

The only restrictions which I'm aware about are the length of text strings (both for Title and Description).

Beside this, I never experienced any restrictions...

Could you give all the information needed to create the UDF (name, description, type, sub-type, etc.) just to test on my machine?

Regards,

Eric

[Former Member]

Hi Eric,

As per your reply pls. find below the UDF details which I am not able to add in Marketing Document Title block.

Title Description

Inst2 Installment - 2

Set Valid Values for Field

Y - Yes

N - No

-

---

Title Description

Inst3 Installment - 3

Set Valid Values for Field

Y - Yes

N - No

-

---

Title Description Type Structure

Per1 Percentage - Advance Units and Totals Percents

Per2 Percentage - 2 Units and Totals Percents

In other documents UDF functionality is working, only in Marketing Document Title it is not working.

Regards,

Yogesh Jadav

[Former Member]

Hi,

I did exactly what you said and had no problem to add these 4 UDF.

The only time I add trouble was when I tried to add "exotic" characters (for fun, to verify who it will act with these, since for my day work I avoid them at most as possible) in the title of the UDF.

Since the title will become the name of the column in the database, it has to follow SQL guidelines (alphabetic and numeric characters, with the '_'. No space, no punctuation characters, etc.).

When you create a UDF, two things are done:

- The database schema is modified, to add the new column to the corresponding object,

- The definition of the UDF is stored in the CUFD table.

You can verify in this table (quick query) that the definition you want to add, just doesn't exists...

Regards,

Eric

[Former Member]

Hi,

I was thinking a bit more (reading again your first post).

Besides what B1 can impose to you, you're using the underlying database: SQL-Server. And on it, you have existing limits (number of columns, max size of a record, etc).

Could you execute the following query, (either directly from the SQL-Server or B1's query manager):

SELECT COUNT(*), SUM (length) FROM syscolumns sc INNER JOIN sysobjects so ON sc.id = so.id WHERE so.name = 'OINV'

And post the results?

Regards,

Eric

[Former Member]

Hi,

The output of query is 294 & 7866.

Regards,

Yogesh