This explains a lot - although I would have expected Axapta to display
the error message instead of just crashing...
Is there a way to increase the maximum row size in SQL server?
The table was based on a customer requirement who needed many searchable
free text fields. After analyzing the data the customer has in these
fields, I found that it was safe to significantly shorten most of the
fields - so I could resolve the problem - however still would be
interested to know what to to if the requirement really was to have such
a large record size.
[EMAIL PROTECTED] wrote:
> Your table design exceeds the maximum allowable number of bytes pr rows in sql server.
>
> If you assign the 1000 characters to all of your fields and try to insert a record you will get an error message from sql server like this
>
> SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size xxxx which is greater than the allowable maximum of 8060.
>
> Because of this you need to redesign your table anyway and that might resolve the other problems that you have.
>
> Could you please explain why you are designing a table with 15 string field with length 1000???
>
> -------------- Original message --------------
> From: Stefan Osterburg <[EMAIL PROTECTED]>
> I have the problem with MS SQL, I have tried to change the field length
> to 999 - without success.
>
> The problem does not occur with only one or few fields of length 1000
> but only if I have about 15 oder 16 of these fields in the table (I
> suppose if the record buffer becomes to big for a certain operation the
> kernel tries on it)
>
> Rudi Hansen wrote:
>> Change the field length to 999 chars, if you run Axapta on a Oracle SQL server I know it has a problem with Char 1000 fields.
>>
>> I´m not sure if it is also a problem with MSSQL.
>>
>> ________________________________
>>
>> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Osterburg
>> Sent: 23. februar 2006 09:56
>> To: [email protected]
>> Subject: [development-axapta] Axapta crashes when accessing a table with many large fields
>>
>>
>> Hello all,
>>
>> I have created a table that contains a lot of large text fields. In my
>> case the table consists of 15 string fields with a length of 1000 each
>> and an ID field with a length of 10.
>>
>> Now Axapta crashes every time I try to perform certain operations on
>> this table for example:
>> - exporting data
>> - clicking into the id field that is used in another table
>> - performing certain selects (select count)
>>
>> Many other operations work without problems, for example using the table
>> browser on the table or joining the table in a form and displaying the data.
>>
>> Is there a known limitation for record/table sizes in Axapta? What can I
>> do to avoid the crashes apart from decreasing field sizes?
>>
>> Stefan
>>
>>
>>
>>
>>
>>
>> SPONSORED LINKS
>> Computer part <http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w> Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ> Microsoft axapta <http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg>
>> Support exchange <http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA>
>>
>> ________________________________
>>
>> YAHOO! GROUPS LINKS
>>
>>
>> * Visit your group "development-axapta <http://groups.yahoo.com/group/development-axapta> " on the web.
>>
>> * To unsubscribe from this group, send an email to:
>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>>
>> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
>>
>>
>> ________________________________
>>
>>
>>
>>
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
> SPONSORED LINKS Computer part Programming languages Microsoft axapta
> Support exchange
>
>
>
> YAHOO! GROUPS LINKS
>
> Visit your group "development-axapta" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
