cancel
Showing results for 
Search instead for 
Did you mean: 

Error 'Not Supported'

former_member338618
Participant
0 Kudos

Hi,

I'm in the process of testing Crystal server 2013 & am having issues with existing reports.

I initially received the following error code:

The viewer could not process an event. Error in File GPCR0010Act - Cost of Sales (Actual) by Delivery Note:

Max processing time or Max records limit reached []

---- Error code:0 [CRWEB00000119]

I have since set the max records to infinite & the report now simply times out.

Running the report in developer returns the error 'Not Supported' followed by 'No more Files' then shows the requested output.

Could anyone advise what might be causing these errors?

The report runs with no issues on XI...

Many thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

What type of database are you connecting to?  If it's MS SQL Server 2008 or newer and you're using either ODBC or OLE DB, you'll need to install the SQL Server Native Client 10 (2008) or 11 (2012 or 2014) and create your connections using that instead of the "SQL Server" driver that's installed by default.

There are also differences in the supported versions of other types of database clients as well.  You can look at the Product Availability Matrix (PAM) to get the versions of DB clients that Crystal Server will work with .

-Dell

former_member338618
Participant
0 Kudos

Hi Dell,

We use Pervasive SQL 11.

Other reports work perfectly.

The PAM is asking for authentication...

DellSC
Active Contributor
0 Kudos

The latest version I can find only shows support for Pervasive SQL 10 - 11 is not listed yet.

Can you use the version 10 client to connect to the 11 server?  If so, I would make sure that's what's installed on your server.  Also, you need to make sure that it's the 32-bit version of the client - even though BO is 64-bit software, the Crystal modules are still 32-bit and require 32-bit data connections.

-Dell

former_member183750
Active Contributor
0 Kudos

Hi Andrew

The PAM for CR designer (db support will be the same for CRS) should not be challenging for logon - pls see this link:

In case you are still not bale to see the result, here is a screenshot:

Even though the PAM does not specify v11, I suspect this should still work.

So. You mention that "Other reports work perfectly."

Are these off of the same database? If so, then the question is; what's the diff? (SPs? Views? Links? Subreports? Mutliple starting points, etc., etc.)

Also, in your original post you say: "I'm in the process of testing Crystal server 2013..". Question then would be; is this limited to running the reports on CR Server and thus reports run fine in the CR 2013 designer?

Oh, one more thing. Please see the following:

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

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

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

  Follow me on Twitter

former_member338618
Participant
0 Kudos

Hi Ludek,

The reports are all from the same data set & all have similar structure, this report is however one of the most complex (but only regarding the multiple file links).

If I run the reports on server I get a time out error, If I run in developer i get the vague 'Not Supported' error followed by 'No More Files' after which the report appears to provide an output.

The exact same report runs with no issues on server XI...

former_member183750
Active Contributor
0 Kudos

Hi Andrew

Does the report run in the CR 2013 designer?

- Ludek

former_member338618
Participant
0 Kudos

Hi Ludek,

It depends on how much data I want to report, If I run it for the last month (it's a cost of sales report FYI) it completes, If I extend this to, say, 6 months it fails.

Keep in mind this doesn't happen with Crystal XI.

I've been in contact today with a UK reseller & he's pointed me to running the SQL in a query app, I get the following error if I try the 6 month (hopefully this will shed a bit more light on the problem, though Google hasn't been very forthcoming regarding this error)...

ErrorCode: -2146232009

[W3ODBCCI.DLL]

NativeError: 0, SQLState: HYT00

ErrorMessage: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]S1T00Timeout expired.

former_member183750
Active Contributor
0 Kudos

Hi Andrew

From where I stand, the issue is consistent in CR 2013 and the SQL query app. I would thus suspect  Pervasive SQL 11(?). Maybe posting to their support forums will not be a bad idea.

When I google 'pervasive timeout' I get a number of interesting hits. E.g.:

SQL Timeouts with P.SQL v11 - Pervasive Community Site

- Ludek