Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I am using Servoy 7.3 with ASA 10.0.1 as the backend

I use a Sybase VIEW to generate a report, that has worked well for months

The VIEW had 3 Sub Selects, but I added 1 more. The Report SELECT Query itself did not change

Now, if I run the Report Query in Servoy, Sybase crashes

and if I run the Report Query in Sybase Central's ISQL, it works

Why might it crash from one, and not the other ? I see no errors

Can a VIEW get too complex ?

greg

asked 13 Mar '14, 08:48

Gregory%20Durniak's gravatar image

Gregory Durniak
13991017
accept rate: 0%

Hi Greg, Does ISQL crash or does the database server crash? Could you supply to SQL statement for the view along with the version of the server SELECT @@version? Are there any assertions recorded in the -o/-oe log?

(13 Mar '14, 11:07) Mikel Rychliski
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×51
×31
×3

question asked: 13 Mar '14, 08:48

question was seen: 1,688 times

last updated: 13 Mar '14, 11:07