Discussion: General Discussions | Aqua Data Server (Public)

rick.thacker Oct 1, 2018

Getting an error message "Connection reset by peer"

I'm using a custom driver to connect to an HP Vertica Instance provided to us by GoodData. Until Saturday, I was able to connect without issue then I started getting a message indicating that the connection was reset by a peer. Now I am unable to connect at all.

tomconrad Oct 1, 2018
Hi Rick,

It sounds like someone changed the credentials/authorization in the database. Maybe more security was added or the password was changed? You are getting this error using Aqua Data Server? Have you tried connecting to the database using Aqua Data Studio?

Tom

rick.thacker Oct 1, 2018

I need to upgrade from V17.0 to V19.0 on Linux.

In the upgrade process, can I go straight from v17.0 to v19.0 or do I need to upgrade a release at a time?

tomconrad Oct 1, 2018
Hi Rick,

You should be able to upgrade to v19 without upgrading to version v18 first.

Thanks,
Tom

stickjo Mar 27, 2017

Where do I find end of support dates for Studio & Server products ?

NielsGron Mar 27, 2017
Support is based on the end of a customers subscription service. Support for versions older the 2 versions previous to the current version can be confirmed by emailing license@aquafold.com

JasonK Jun 8, 2016

VA workbooks in Server

Hi,

Are there any plans to support viewing a VA workbook created in Data Studio in Data Server? We are looking for a solution that would allow a developer to create workbooks that we can then easily expose to the business, say by running automatically (say nightly) that could then be viewed static, or that run on demand when viewed, or maybe even just display the data statically like a packaged wor…
See More

3 comments - JasonK, SachinPrakash

SachinPrakash Jun 8, 2016 · 1 Like
Hi Jason,

In our product roadmap, we do have plans to add VA workbooks created in Data Studio in Data Server. Our Data Server product supports our older generation charting APIs but doesn't support the VA charting mechanism. We do have plans to add this functionality in Data Server but don't have any definitive timelines.

JasonK Jun 8, 2016
Good news. Too bad it's not today ;) If you need any customers asking for this so you can bump the priority, consider this an ask ;)

Do you have a ticket for this addition that I can start watching?

SachinPrakash Jun 10, 2016 · 1 Like
I've created a new issue for it:
https://www.aquaclusters.com/app/home/project/public/aquadataserver/issue/2967

On the issue, you can click "Like" on it. The more "Likes", the greater the priority bump :)

brianhatch May 27, 2015

Unable to start ADS 16 on Windows

Hey Guys,

I attempted an upgrade of one of my ADS instances from 13 to 16, but I'm unable to get the application to start. It's throwing a servlet exception. I'm attaching the catalina log from where it attempted and failed to start.

1 attachment

catalina.2015-05-27.log

11 KB

tariqrahiman May 27, 2015
Hi Brian,

1. Can you tell us what error message you are getting? Can you attach a screenshot of the error?
2. Can you also send us your tomcat and aquadataserver.log files? Here is the docs on logs :
https://www.aquaclusters.com/app/home/project/public/aquadataserver/wikibook/Documentation16/page/28/3-5-Tomcat-Aqua-Data-Server-Logs
3.Did you follow the Upgrade process as in the link here: https:/…
See More

amelton Apr 9, 2014 · Edited by

tariqrahiman

Query Consistency

I have a query which runs in Aqua Data Studio, but not in Aqua Data Server. If I execute an Aquascript on the server from the 'edit' screen, I get a console message:

Error on line 16: Unexpected token NAME (#16)

But, if I take the query portion of the script, modify it to run in Aqua Data Studio, it works. I can use Studio to generate a new Aquascript, but it seems that a working Studio query shou…
See More

2 attachments

last7Days.xjs

1 KB
last7Days_edited.xjs

1 KB

tariqrahiman Apr 9, 2014
Hi Andrew,

I have edited the AquaScript and attached one that works. There was a syntax error in Line# 16 where you had not escaped the quote identifier resulting in a Javascript syntax error.

You can either enclose the query within double quotes as in query = "SELECT ….";
or escape the quote identifiers using a \ character as in AS \'Last Call\'

Let us know if you have any more questions

Thanks

amelton Mar 25, 2014

OpenAPI Documentation

I've been trying to access the OpenAPI documentation, but the page is blank with no content:

http://docs.aquafold.com/ads/14.0/openapi/

Can you check that the link is working?

Thank you.

4 comments - emil.goicovici, amelton, swissarmyknife(*), emilianbold

emilianbold Mar 25, 2014
Make sure you don't have some ad-blocker blanking your page because of the "/ads/" text in the link.

swissarmyknife(*) Mar 25, 2014
I'm able to see this page through both our internal network and through an external network (AT&T - Safari on my iPhone). Can you provide some details on what browser/OS you are using to view the page? Are you able to view the link below?

http://docs.aquafold.com/

(that link should look like our www.aquafold.com home page)

amelton Mar 25, 2014
Must be a browser issue. It works on my iPhone, but none of my desktop browsers will display. Thanks, I'll continue investigating my side.

emil.goicovici Mar 25, 2014 · (edited)
I also think he has some ad-blocker (like Adblock Plus etc). I use such an ad-blocker and when opening the reported link it displays only two HTML frames with no content on them. The ad-blocker reports that three items (the inner frames) were blocked on that page.

After I temporarily disable the ad-blocker rules for that page, and reload it on my browser, it successfully displays the OpenAPI docum…
See More

amelton Mar 21, 2014 · Edited by

tariqrahiman

Aquascript Help

I have a table with two columns: `Name` and `City`. I would like to create an Aquascript that would prompt the user to supply a name and output a table with the number of occurrences of `name` by `city`.

The sql would be something like:

select count(1),city from records
where name like 'xxxxxxx'
group by city

I tried slimming down the "Company Revenue Advanced" example, but that was more than I neede…
See More

3 attachments

Sample.xjs

9 KB
Screen Shot 2014-03-21 at 2.35.10 PM.png

33 KB
Screen Shot 2014-03-21 at 2.35.22 PM.png

80 KB

tariqrahiman Mar 21, 2014
Hello Andrew,

I have created a very simple script which will accept city name as the user input and will display the count. See attached screenshots and Sample.xjs. I basically worked on the Company Revenue Advanced and trimmed out items like Export, Email which you can add easily. Let us know if you need anything else

The table structure I used is below:

CREATE TABLE city (
Name varchar(25) NOT NU…
See More

Search Tips

Aqua Data Server (Public) / nhilam

General Discussions

1 attachment

2 attachments

3 attachments

Search Tips

Aqua Data Server (Public) / nhilam

Title

General Discussions

1 attachment

2 attachments

3 attachments