View returns an error.

Question

View returns an error.

kamal 73819

SSC Rookie

Points: 40
More actions
September 17, 2018 at 9:58 am

#368326

Hello All,
I am facing a problem in one of my views
the problem is that When selecting from the required table the data retrieved successfully .but when I created a view that joined the same table with another one it returns this error
" Cannot create a row of size 8104 which is greater than the allowable maximum row size of 8060.."
The table contains only 25 rows till now.
if I limited the view by
select top(25)
it works.
Can you help in this please
Thanks in adance

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

kamal 73819 - Monday, September 17, 2018 9:58 AM
Hello All,
I am facing a problem in one of my views
the problem is that When selecting from the required table the data retrieved successfully .but when I created a view that joined the same table with another one it returns this error
" Cannot create a row of size 8104 which is greater than the allowable maximum row size of 8060.."
The table contains only 25 rows till now.
if I limited the view by
select top(25)
it works.
Can you help in this please
Thanks in adance

First, is this an indexed view or a standard view? Second, it sounds like a data related issue. You didn't post the DDL for the tables involved or for the view so there really isn't much more we can do except take shots in the dark. You should start looking at the data and see what may be happening.

kamal 73819 SSC Rookie Points: 40 More actions · Answer 2

Lynn Pettis - Monday, September 17, 2018 10:06 AM
kamal 73819 - Monday, September 17, 2018 9:58 AM
Hello All,
I am facing a problem in one of my views
the problem is that When selecting from the required table the data retrieved successfully .but when I created a view that joined the same table with another one it returns this error
" Cannot create a row of size 8104 which is greater than the allowable maximum row size of 8060.."
The table contains only 25 rows till now.
if I limited the view by
select top(25)
it works.
Can you help in this please
Thanks in adance
First, is this an indexed view or a standard view? Second, it sounds like a data related issue. You didn't post the DDL for the tables involved or for the view so there really isn't much more we can do except take shots in the dark. You should start looking at the data and see what may be happening.

It is a standard view.
iI did not post the DDL script as it's too long The tabel contain more that 400 column as it is a table for a local questionnaire.
One note that all columns are Varchar(100).
but it works when I select directly from the table .

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

kamal 73819 - Monday, September 17, 2018 10:15 AM
Lynn Pettis - Monday, September 17, 2018 10:06 AM
kamal 73819 - Monday, September 17, 2018 9:58 AM
Hello All,
I am facing a problem in one of my views
the problem is that When selecting from the required table the data retrieved successfully .but when I created a view that joined the same table with another one it returns this error
" Cannot create a row of size 8104 which is greater than the allowable maximum row size of 8060.."
The table contains only 25 rows till now.
if I limited the view by
select top(25)
it works.
Can you help in this please
Thanks in adance
First, is this an indexed view or a standard view? Second, it sounds like a data related issue. You didn't post the DDL for the tables involved or for the view so there really isn't much more we can do except take shots in the dark. You should start looking at the data and see what may be happening.
It is a standard view.
iI did not post the DDL script as it's too long The tabel contain more that 400 column as it is a table for a local questionnaire.
One note that all columns are Varchar(100).
but it works when I select directly from the table .

Can't see what you see. I stand by what I believe based on what you have posted, you need to look at the data you are returning in the view and see what is happening. If you can return 25 rows (top (25)) but can't return a full result set, it looks like a data issue.

WoundedParrot SSCommitted Points: 1647 More actions · Answer 4

Your view is too large, and some of the rows within the view exceed the maximum allowed bytes per row.
Break your view down into smaller views or look into removing columns you don't need.

kamal 73819 SSC Rookie Points: 40 More actions · Answer 5

WoundedParrot - Tuesday, September 18, 2018 7:57 AM
Your view is too large, and some of the rows within the view exceed the maximum allowed bytes per row.
Break your view down into smaller views or look into removing columns you don't need.

Yes That was the case thank you so much.
I did what you say and it worked out

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Again, we are just shooting in the dark. Without the DDL for the tables and the view we really can't provide better answers.